Links

Steps to upload your own ASIN and SKU file

Daton's new file intake system allows you to upload your own list of ASINs and SKUs. Applicable to Amazon Selling Partner and Vendor Central connectors.

What is this?

Amazon's SP-API (used for Daton's Selling Partner and Vendor Central connectors) has a list of tables that return data only when an ASIN/SKU is given as an input to the API. Daton has now launched a mechanism for users to upload their own ASIN and SKU file to take advantage of Selling Partner and Vendor Central tables that are dependent on an input of ASIN or SKU.

What was being done before?

Daton was using one of FBAInventorySummary, AllListingsReport or ActiveListingsReport (new) to fetch a list of ASINs and SKUs from Amazon and pass those ASINs as input to tables like CatalogItems, GetCompetitivePricingForASIN etc.
There are multiple options being offered because each report had its share of caveats.

Why is this being done?

Users with Seller accounts in France, Japan and China will not get an adequate list of ASINs/SKUs from any of the reports mentioned above and therefore lose access to all the data that Amazon has to offer for particular ASINs.
Users now also have the option to edit the list of ASINs to what they really require. AllListingsReport is known to be quite massive with tens of thousands of ASINs/SKUs depending on the Seller. This causes us to send hundreds of thousands of completely unnecessary API calls to fetch different tables for each ASIN/SKU in case the user does not want data for some ASINs/SKUs.
While users still have the option to select any of the existing reports as the input, they now have the option of uploading their own file.

Which tables require ASIN/SKU input?

The following tables offered by Daton require inputs according to Amazon's SP-API
Table name
Required input
CatalogItems
ASIN
CatalogItemsSummary
ASIN
CatalogItemsVariations
ASIN
CatalogItemsSalesRank
ASIN
CatalogCategoriesForASIN
ASIN
CatalogCategoriesForSKU
SKU
GetCompetitivePricingForSKU
SKU
GetCompetitivePricingForASIN
ASIN
PricingForASIN
ASIN
ListingsItemsSummary
ASIN
ListingsItemsIssues
ASIN
ListingOffersForASIN
ASIN

Steps to Upload ASIN/SKU file

  1. 1.
    The file must be in an csv format.
  2. 2.
    There must be two columns - ASIN and SKU. Do not upload a file with only one column.
  3. 3.
    Each column must have a header called 'ASIN' and 'SKU'. Do not use column headers other than ASIN and SKU (for example: asin1, asin_1, sellerSKU, ASIN%#[email protected], foo)
  4. 4.
    Make sure that you have a distinct list of ASINs and SKUs (i.e. no ASIN and SKU are repeated in their respective columns). We are aware that a single ASIN can have multiple SKUs and therefore, we do not need you to map the ASINs and SKUs to each other. The two columns can be unrelated, we only need a list of both. This will reduce fetching the same data multiple times.

Ideal File Format