All Collections
Export & Share
Extract last Catalog information retrieved on Amazon.
Extract last Catalog information retrieved on Amazon.

Exporting raw data regarding your products as last seen on Amazon into an Excel file.

Apolline Vanneste avatar
Written by Apolline Vanneste
Updated over a week ago

Seelk Studio’s Catalog App is dedicated to your Amazon content performance tracking. In the Overview & Products tabs, you can extract various information that can be found on your Amazon product pageBuy Box price and owner, number of sellers, bullet points content, number of 1 star reviews...

These information will be the latest retrieved based on your product scrapping frequency.

  1. Access the Catalog App, either the Overview or Products tabs.

  2. Filter the list of ASINs to extract product information on using for example tag, attribute or section filters. Otherwise, the extract will contain all the ASINs that have been added in Seelk Studio in the core section.

  3. Click on ‘Export filtered products data’.

Screen Shot 2022-04-02 at 14.58.32.png

An excel file named accountname_Catalog-Filtered-Data_date will be directly saved in your computer ‘Downloads’ file with the below columns:

  • marketplace: amazon_marketplacecode of the product.

  • asin: Amazon Identification Number; a 10-digit alphanumerical value specific to your product.

  • title: title as displayed on Amazon.

  • section: the Seelk Studio product section the product has been set on.

  • parent_asin: the parent ASIN of that product if it is variation of a main product.

  • brand: the brand under which the product is listed on Amazon.

  • scraping_date: last date at which the data for the product was collected on Amazon —It varies based on the product scrapping frequency defined.

  • page_url: The URL of the product page

  • overall_score: The overall health score for the product as calculated by Seelk Studio. It is a composite of the following Content score, Offer score & Review score.

  • content_score: composite score based on various elements of the content on an Amazon page like title length, number of images, number of videos...

  • offer_score: composite score based on the Buy Box score —buy box status, prime & stock availability.

  • review_score: composite score based on customer reviews —number of reviews & average rating.

  • is_404: either ‘TRUE’ or ‘FALSE’ —Does this product page exist?

  • is_pantry: ‘TRUE’ or ‘FALSE’ —Is this product considered "pantry" by Amazon; i.e. an everyday product?

  • is_sns: ‘TRUE’ or ‘FALSE’ — Is this product offered on a "Subscribe and Save" basis?

  • is_prime: ‘TRUE’ or ‘FALSE’ —Is this product only available on Prime?

  • is_fresh: TRUE’ or ‘FALSE’ —Is this product considered as "fresh produce"?

  • is_premium_beauty: ‘TRUE’ or ‘FALSE’ —Is this product considered as “premium beauty” by Amazon?

  • is_professional_beauty: ‘TRUE’ or ‘FALSE’ —Is this product considered as “professional beauty” by Amazon?

  • preorder_available: ‘TRUE’ or ‘FALSE’ —Can this product be ordered before its release date?

  • has_a_plus: ‘TRUE’ or ‘FALSE’ —Does this product have A+ content?

  • has_stock: ‘TRUE’ or ‘FALSE’ —Is this product in stock according to its product page?

  • has_active_buy_box: ‘TRUE’ or ‘FALSE’ —Does this product currently have an active Buy Box, ie. is there an Add-to-Cart button allowing consumers to buy the product?

  • has_vendor_offer: ‘TRUE’ or ‘FALSE’ —Is this product offered as a Vendor?

  • vendor_price: The Vendor price for this product.

  • is_buy_box_owner: ‘TRUE’ or ‘FALSE’ —For this specific product you either own the Buy Box (TRUE) or do not own the Buy Box (FALSE).

  • buy_box_owner: The name of the entity owning the Buy Box, either Amazon for a Vendor offer or the entity name for 3P Sellers.

  • merchant_id: The merchant ID of the Buy Box owner.

  • buy_box_currency: The currency for the Buy Box price.

  • buy_box_price: The current Buy Box price for the product, ie. price at which customers buy it.

  • min_price: The minimum price offered for the product.

  • max_price: The maximum price offered for the product.

  • nb_sellers: The total number of Sellers (both MFN and FBA).

  • nb_mfn_sellers: The number of MFN sellers selling this product.

  • nb_fba_sellers: The number of FBA sellers selling this product.

  • nb_images: The number of images contained on the product's page.

  • images: The URL of the thumbnail image for your product.

  • images_url_1 (to) images_url_7: The URL of the product’s images based on appearance order.

  • nb_videos: The number of videos on the product's page.

  • videos_url_1 (to) videos_url_2: The URL of the first and second videos on the product's page.

  • bullet_points: The number of bullet points that appear on the product's page.

  • bullet_points_1 (to) bullet_points_10: The text content contained in your Bullet Points section of the product’s page.

  • description: The text content of the Description section of the product's page.

  • nb_reviews: The number of reviews the product has been given.

  • average_rating: The average rating for this product, between 0 and 5.

  • weighted_average_rating: The weighted average rating based on the number of reviews.

  • nb_1_star (to) nb_5_star: The number of 1 to 5 stars ratings for the product.

  • nb_answered_questions: The number of questions answered regarding the product.

  • top_category: The main category that the product is currently listed in.

  • smallest_category_name: The smallest category that the product is currently listed in

  • smallest_category_ranking: The product's ranking at its smallest level category.

All the following columns are product attributes.

Note: Depending on your catalog size, this spreadsheet may take a few minutes to process before being downloaded on your computer.

Example (extract):

Screen Shot 2022-04-03 at 13.32.39.png
Did this answer your question?