Skip to content

v0.3.1

v0.3.1: Updated AmazonProductPageParser for KDP data, migration tables, more...
@fofxtools fofxtools tagged this 11 Oct 03:13 
- Moved AmazonProductPageParser::bsrToMonthlySalesBooks() to src/functions.php bsr_to_monthly_sales_books()
- Added columns to table amazon_products
  - kdp_trim_size
  - kdp_royalty_estimate
  - monthly_sales_estimate
- Updated table amazon_keywords_stats
  - Added columns:
    - json___products__kdp_royalty_estimate
    - json___products__monthly_sales_estimate
    - avg___products__kdp_royalty_estimate
    - avg___products__monthly_sales_estimate
  - Deleted columns:
    - json___products__bsr_rank___monthly_sales_books
    - avg___products__bsr_rank___monthly_sales_books
- Updated AmazonProductPageParser
  - Updated parseAll() to add details if Publisher is 'Independently published'
    - kdp_trim_size
    - kdp_royalty_estimate
    - bsr_monthly_sales_estimate_books
  - Updated insertProduct()
    - Added:
      - kdp_trim_size
      - kdp_royalty_estimate
      - monthly_sales_estimate (based on bsr_monthly_sales_estimate_books; only set if category is Books)
  - Updated computeProductsStats()
    - Added:
      - json___products__kdp_royalty_estimate
      - json___products__monthly_sales_estimate
      - avg___products__kdp_royalty_estimate
      - avg___products__monthly_sales_estimate
    - Deleted:
      - json___products__bsr_rank___monthly_sales_books
      - avg___products__bsr_rank___monthly_sales_books
Assets 2
Loading