When clicking on "Download Filtered Data" button in Seelk Studio's Catalog app

a download is prompted. Your browser downloads an .xlsx file that contains all the raw data regarding your products as seen on Amazon. Each row in the spreadsheet represents a single product.

The definitions for the columns (A through to CG) contained in the .xlsx file are as follows:

[A] sku

If you are an Amazon Seller your the SKU number will be available here.

[B] asin

ASIN stands for Amazon Identification Number — it is an 10 digit alphanumerical value specific to your product

[C] country

The country that the product is y being sold in.

[D] marketplace

Which ecommerce site your product is being sold. In this case it will only be Amazon.

[E] marketplace_name

This is the database specific naming for which markerketplace country that your product is being sold in. It will be either:

Europe

amazon_fr (France)

amazon_uk (United Kingdom)

amazon_es (Spain)

amazon_de (Germany)

amazon_it (Italy)

North America

amazon_us (United States)

amazon_ca (Canada)

amazon_mx (Mexico)

Asia

amazon_jp (Japan)

amazon_cn (China)

amazon_in (India)

[F] parent_asin

The parent ASIN of that product if it is variation of a main product

[G] health_score

The overall health score for the product as calculated by Seelk Studio. It is a composite of the following scores:

  • Catalog Score
  • Offer (BuyBox) Score
  • Review Score

[H] brand

The brand under which product is listed

[I] catalogue_health_score

It is a composite score based on various elements of the content on an Amazon page, include (bullet points, description, number of images, etc.)

[J ] buy_box_health_score

It is a composite score based on the Buy Box score (should be active, offer should be prime, sns option should be available and should have stock)

[K] review_health_score

Reviews is a break down of the reviews rating system for individual products on Amazon based on the 0 to 5 star rating system..

You can imagine that 0 or 1 star equals a 0-20% score, and so on.

[L] 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).

[M] is_pantry

True or False — Is this product consider "pantry" by Amazon - i.e. an indespensible everyday product?

[N] is_add_on_item

True or False — Is the product available as an "Add-On" item by Amazon?

[O] is_prime_only

True or False — Is this product only available on Prime?

[P] is_fast_track

True or False — Is this product offered on Fast Track?

[P] has_a_plus

True or False — Does this product have A+ content?

[R] is_404

True or False — Does this product page exist or not?

[S] is_sns

True or False — Is this product offered on a "Subscribe and Save" basis (i.e. please send me this product on a customisable frequency — ex. please send me a "Permanent Blue Marker" in the first week of every month.

[T] is_prime

There are five options for the status of your Buy-Box: Active, Prime-Only, Add-On, Inactive and Pantry

[U] is_fresh

True or False — Is this product considered as "fresh produce"?

[V] has_active_buy_box

True or False — Does this product currently have an active BuyBox or not?

[W] has_vendor_offer

True or False— Is this product offered (by you!) as a Vendor

[X] merchant_id

What is the merchant ID of the BuyBox owner

[Y] buy_box_currency

The currency for the BuyBox price

[Z] min_price

The minimum price offered for the product

[AA] max_price

The maximum price offered for the product

[AB] buy_box_price

The currenty BuyBox price for the product

[AC] buy_box_owner

True or False — Are you the BuyBox owner for this product?

[AD] vendor_price

The Vendor price for this product

[AE] nb_sellers

The total number of Sellers (both MFN and FBA)

[AF] nb_mfn_sellers

The number of MFN sellers selling this product

[AG] nb_fba_sellers

The number of FBA sellers selling this product

[AH] has_stock

True or No — Is this product in stock?

[AI] nb_size_variations

The number of size-related variations for this product

[AJ] nb_color_variations

The number of color-related variations for this product

[AK] nb_style_variations

The number of style variations for this product

[AL] title

The title of the product

[AM] nb_images

The number of images contained on the product's page

[AN] images_url_1

The source URL of the image 1 of the product

[AO] images_url_2

The source URL of the image 2 of the product

[AP] images_url_3

The source URL of the image 3 of the product

[AQ] images_url_4

The source URL of the image 4 of the product

[AR] images_url_5

The source URL of the image 5 of the product

[AS] images_url_6

The source URL of the image 6 of the product

[AT] images_url_7

The source URL of the image 7 of the product

[AU] nb_videos

The number of videos on the product's page

[AV] videos_url_1

The URL of the first video on the product's page

[AW] videos_url_2

The URL of the second video on the product's page

[AX] bullet_points

The number of bullet points that appear on the product's page

[AZ] —> [BH] bullet points

The text content contained in your Bullet Points section of the product's page

[BI] description

The text content of the Description section of the product's page

[BJ] nb_reviews

The number of reviews the product has earned

[BK] weighting_average_rating

The average rating to 2 decimal points of accuracy that (between 0 and 5) the product has earned

[BL] nb_1_star

The number of 1 star ratings for the product

[BM] nb_2_star

The number of 2 star ratings for the product

[BN] nb_3_star

The number of 3 star ratings for the product

[BO] nb_4_star

The number of 4 star ratings for the product

[BP] nb_5_star

The number of 5 star ratings for the product

[BQ] nb_answered_questions

The number of questions answered regarding the product

[BR] page_url

The URL of the product page

[BS] image

The URL of the thumbnail image for your product

[BT] ranking

The ranking of your product within its sub-category

[BU] finest_sales_ranking

The product's ranking at its deepest level category

[BV] category

The sub-category that the product is currently listed in

[BW] top_category

The main category that the product is currently listed in

[BX] sub_category_url

The URL of the sub-category of the product

[BY] scraping_date

The date that this data was last collected for the product

Did this answer your question?