Amazon

 查看中文帮助中心  

1. Creating an Amazon feed in Lengow

1.1 Selecting your product category

When you want to sell your products on Amazon, first of all you must choose the product category(ies) in which you want to publish your items. Each product category has its own characteristics, defined in inventory loader files known as “Flat Files”. They are all listed in your Amazon Seller Central account. Here is a direct link to the log-in page:

  • Amazon.it

Inventory file templates

Browse tree guides (BTG)

  • Amazon.co.uk

Inventory file templates

Browse tree guides (BTG):

  • Amazon.de

Inventory file templates and BTG

  • Amazon.es

Inventory file templates

Browse tree guides (BTG)

  • Amazon.fr

Inventory file templates

Browse tree guides (BTG)

  • Amazon.ca

Inventory file templates and BTG

Amazon CA is not available for merchants which do not have a Canadian Bank account.

  • Amazon.com

Inventory file templates and BTG

If you don't know which product category to choose for your catalogue, contact your Amazon account manager. Bear in mind that each product category corresponds to a Lengow feed. If you sell your catalogue in several product categories, you will have several Lengow feeds.

1.2. Managing European accounts on Lengow

Do you have a European Amazon account and would like to sell your products in several countries?

Lengow has developed a new version of its API to enable you to send several feeds to a multilingual European account.

As feeds vary from one country to another, you will need to create an Amazon feed for each country.

1.3 The "price and quantity" feed

If you already have products live on Amazon, you can request a “Price and Quantity” feed as opposed to a feed by product category. The Price and Quantity file allows you to update your current inventory and prices without filling in all of the required fields for complete product categories. It is a simplified version and can therefore be processed more quickly, and is sent to Amazon every hour.

1.4 The "Listing Loader" feed

The Listing Loader allows you to sell products that already exist in the Amazon catalogue; you cannot create new product detail pages using this feed. If your products do not exist in the Amazon catalogue, please select a “product category” feed.

Note: For this feed, mark the value "123" in the categories that you want to send in the "Product Management" tab.

1.5 The "Amazon Shipping Overrides" feed

Shipping Overrides feed allows you :

  • to alter your default shipping settings for a product, based on their sKU. There are two types of shipping overrides:Exclusive (you may creates an entirely new shipping charge) and additive (you may add an extra charge to the current shipping charge).
  • to manage shipping options for specific products. You may activate or de-activate specific shipping area.

For more information, go on your Amazon Seller Central.

1.6 The "Amazon Business" feed

Thanks to the Amazon Price and Quantity B2B feeds, you can promote your offers on Amazon Business. This Amazon feature is currently only available for Germany and the UK.

If your  products already exist on Amazon, you can put your business offers online thanks to Amazon Price and Quantity B2B feed.

If your  products don't exist on Amazon yet, an Amazon feed for product creation is necessary to create your products and put your offers online on Amazon Business.

Note: you must first subscribe to Amazon Business before you can publish B2B offers.

1.7 Amazon Prime Now marketplace

Amazon Prime Now is a marketplace that differ from Amazon. It is  reserved for Amazon Prime members.

This service is not available at the moment with Lengow.

1.8 Amazon Prime service

This option offers Amazon customers many benefits, especially in terms of speed of delivery.

Follow steps detailed in "Managing Shipping Methods - Amazon Prime Option" paragraph.

2. Configuring and optimising your Amazon feed

2.1 Establishing matches between your categories and those used by Amazon

Amazon requires merchants to match their categories with Amazon’s browse node categories. To match your categories with Amazon’s categories, go to Products Management. The more explicit your category names are, the easier it is for you to match your categories.

For some product categories, the “product type” is also essential. This enables you to define what type of product you are selling in a given category (for example in the jewellery category: “earring”, “fashion jewellery”). So remember to highlight this information populated using the values permitted by Amazon.

2.2 Match the fields

Amazon requires a particular feed structure depending on the category chosen. 

In order to proceed with the field matching, you need to go to the page “Feed Management” then “Field matching”:

Check the field matching and complete any missing information. Read the field definitions carefully and there you will find: 

  • The field name.
  • The field definition.

To help you to configure your Amazon's feed, we advice you to:

2.3 Required values for Amazon

Some product categories have required values. To find out whether a field is required, please refer to the Data Definition tab of Amazon's Inventory file template. This tab indicates which fields are required, desired and optional (recommended).

By default, Lengow matches all the required fields, except where they are not included in your source feed.

For example, the field Clothing-type for the Amazon Clothing feed must contain the following values so that your products can be uploaded to Amazon: Shirt / Sweater / Pants / Shorts / Skirt / Dress / Suit / Blazer / Outerwear / Socks hosiery / Underwear / Bra / Shoes / Hat / Bag / Accessory / Sleepwear / Swimwear

If these values are not included in your source feed, you need to add a virtual column to your source feed (“champ virtuel” in Lengow to be created under “Feed Management > Source feed”) which has the header or column name “amazon_clothing_type”, for example. This column, which will be empty by default because it has been added virtually, may subsequently be populated using automatic rules. In order to highlight the optimised feed, don't forget to match it in the page “Feed Management > Field matching”.

This stage can be quite time-consuming, but it is essential for allowing customers to find your products easily and for submitting products in line with Amazon's requirements.

2.4 Managing shipping fees

Amazon will not let you submit a fixed amount for shipping fees directly in the feed; you can choose one of the following options:

On Lengow:

1. Manage your shipping fees in your Lengow feed

  • Indicate the weight of your products in “Feed Management / Field matching” (Weight and WeightUnitofMeasure fields): Amazon will calculate the shipping fees automatically according to the weight of your items

or

  • Add your shipping fees to your sales prices on Amazon using an automatic rule: {YourPricefield}-{addition}-{YourShippingFeesfield} / e.g.: {PRICE_PRODUCT}-{addition}-{SF}

2. Configure a specific feed to manage exceptions.

Configure another Amazon feed called Amazon Shipping Overrides to implement exceptions to your shipping fees by SKU

3. Configure your shipping fees directly in your Amazon Seller Central account, especially the Free Shipping option. For more information, please contact Amazon.

2.5 Delivery mode management - Amazon Prime Option

To enable the Amazon Prime option for your products delivery:

  • Step 2: In Lengow, in  the "merchant-shipping-group-name" field enter the shipping method value: "Amazon Prime"

2.6 Shipping managed by the Amazon Fulfillment service (FBA)

2.6.1 Include products in the FBA program

Lengow lets you indicate in the feed submitted to Amazon that your products are shipped by Amazon, if you use the Fulfillment by Amazon (FBA) programme.

You must use the field “fulfillment-center-id” (visible in the field matching of your Amazon feed; if this field is not visible contact the Lengow support team). This field will tell Amazon the processing network used: the wording AMAZON_EU indicates that the product is “Processed by Amazon”.

If you leave this field empty, or if you enter the wording “DEFAULT”, the product will be automatically converted to “Processed by the seller” (and will therefore be removed from the FBA programme).

To add the wording AMAZON_EU to your Amazon feed, you must match the Amazon fulfillment-center-id field with one of the fields in your source feed (or a virtual feed created in Lengow), and complete with an automatic rule:

Example:

Field conditions 

  • "Product_ID" IS "IDproduct1|IDproduct2" (separate the product IDs with a vertical bar (|) to add several products).

Then execute this actions

  • "fulfillment-center-id" becomes "AMAZON_EU"
  • "Quantity" Becomes empty

Please note that the Quantity field for these products must not contain any value; add a “Then” condition to your rule for your Quantity field so that you can insert a space and clear the field.

Also make sure that the "fulfillment_latency" field is empty for your products sold through the FBA program.

Check whether the products do indeed have the wording AMAZON_EU, no quantity and no value in the "fulfillment_latency" field in the optimised feed.

2.6.2 Orders with the FBA program

Orders are reported in Lengow with the wording "Shipped by the marketplace" in the order information.

If you import orders into your e-commerce back office :

  • Through the Lengow API: The information appears in the <tracking_informations> node.
  • Through a Lengow plugin:
    • Prestashop and Magento 1 and 2: Activate the option to import orders shipped by marketplaces.
    • Woocommerce: It is not possible to import orders shipped by marketplaces.

2.7 Managing sales/promotions on Amazon

Would you like to display sale/promotional prices on Amazon? You will need to enter a promotional price (“sale_price” field), a start date (“sale_from_date” field in yyyy-mm-dd format) and an end date (“sale_end_date” field in yyyy-mm-dd format) in “Feed Management / Field matching”.

Sample rule (source feed in Prestashop):

IF PRICE_PRODUCT IS NOT {PRICE_REDUCTION}

THEN

• Amazon_SaleFromDate (virtual field created by default by Lengow) becomes YYYY-MM-DD (for example, 2013-01-01)

• Amazon_SaleThroughDate (virtual field created by default by Lengow) becomes YYYY-MM-DD (for example, 2020-01-01)

In the Amazon field matching page, you must match the Amazon fields called sale_price”, “sale_from_date” (your start date) and “sale_end_date” (your end date) with your PRICE REDUCTION, Amazon_SaleFromDate and Amazon_SaleThroughDate fields. The three fields are interdependent. If one of them contains a date or a price, the two others must be filled in.

Please note: you must also clear the fields PRICE REDUCTION, Amazon_SaleFromDate and Amazon_SaleThroughDate if there is no promotion:

IF PRICE_PRODUCT IS {PRICE_REDUCTION}

THEN PRICE_REDUCTION becomes (insert a space to clear the field)

It is not necessary to clear the Amazon_SaleFromDate and Amazon_SaleThroughDate fields. Since these are virtual fields, by definition they are cleared and can therefore only be filled in when the product is on promotion.

To set up your sales, follow our guide.

2.8 Setting up product variations

Product variation management is recommended on Amazon, as it gives your products greater visibility and also makes it easier for web users to select the product (size, colour, etc.) they are looking for.

Here is what a product page looks like on Amazon after configuring Size and Colour variations for a pair of boots:

When you create parent/child relationships between products, you help customers find different versions of the product they are viewing. For example, the product detail page for a T-shirt might include links to the same shirt in a larger size, or for shirts in a different colour.

Lengow requires specific information in your data feed in order to build these relationships within the solution.

Not every Amazon category supports parent/child relationships, but if an appropriate variation theme exists for your products, you must include your products in a parent/child relationship.
For more information on which categories support parent/child relationships, see Amazon Comparison Table.

Examples of valid variations:
- Identical products that vary only by colour
- A product that is available in different scents
- A product that is available in different sizes and colours

Examples of invalid variations:
- Individual bath gel, shampoo and scented powder (separate skus) that are the same scent
- Short sleeved and long sleeved t-shirts by the same manufacturer
- Dinner plates, salad plates and soup bowls (separate skus) with the same pattern

2.8.1 Managing your product variations: linked parent and child products – how can you include products with different sizes and/or colours?

A product is said to have “variations” when it is sold with different attributes: size, colour, etc. It is necessary in such situations to configure the Parent/Child product link.

Generally speaking, each of the products in your catalogue must have a unique ID, including parent products and child products.

Child products must also have a shared characteristic, i.e. another ID field that is common to all of them: the parent ID (MOTHER_ID, Parent_ID, etc.)

Example with one product:

Note: These values are examples, adapt them according to your Inventory file templates.

The first row is the “parent” product row. This must be present in your feed so that all of the product variations can be sent to Amazon.

In this example, the unique ID of the parent row (Unique_identifier: 1500) will be used as a parent product reference number or display page for the child products (1500_1, 1500_2 etc.).

This parent row must not contain any indications of size, colour, etc. in the title. The “child” products, on the other hand, must possess information about size and/or color, etc.

2.8.2 Defining the variation method for your product variations: according to which criteria will the child products differ?

Lengow recommends that you have a Variation_theme field in your source feed which contains the type of product variation. For example, size, color, size-color, etc. This will enable you to quickly and easily identify the variation method used to vary your products and therefore to build your Parent/Child relationships.

2.8.3 Defining the variation attributes: In which field(s) do you have variation data?

You must also have a field in your source feed where you enter the product variation information between one child product and another. For example, if different sizes are available, you absolutely must have a “SIZE” field in your source feed, which contains values such as “40”, “42”, etc. The same goes for different colours, or even different sizes AND colours (for example: Red, Yellow, 40, 42).

2.8.4 Defining the fields necessary for building Amazon product variations

Creating parent/child relationships requires attention to detail: this relationship must be correctly configured right from the word go, based on the field matching performed. The column (found in “Feed Management / Field matching”):

  • "Parentage" (or "parent_child") defines whether a given SKU (product ID) is a parent or a child. Please enter Child or Parent.
  • "parent_sku" declares the parent SKU. Use only for a child SKU; the parent product must not contain any parent ID.
  • "relationship_type" is used only for the child product to declare the type of variation linking the child to the parent. It may differentiate between several products from the same range (Variation) or provide a direct link to the accessories of a product (Accessory).
  • "variation_theme" is used to define the variation criteria. It can relate to colour, size or a combination of the two (Size, Colour or SizeColour).
  • "Colour", "Size", "Length", etc. attribute fields are used to indicate the colour, size, length, etc. of the child product depending on its Variation type. Please also note the following fields:
  • "external_product_id": only child products should contain an ID (EAN, UPC, ASIN code, etc.). When creating automatic rules, please make sure you enter nothing for the parent products.
  • "external_product_id_type": if you enter an ID (EAN, UPC, ASIN code, etc.) in the external_product_id field, enter the type of code used: EAN, UPC or ASIN. Please note that for parent products, you must not fill in the “external_product_id_type”.

To help you set up product variations in Amazon, Lengow provides virtual fields (in “Fedd Management / Source feed”) which must be matched up on the “Feed Management > Field matching” page if you want to use them.

These fields are visible in the scrolling down menu in your Amazon Field Matching. These fields must be matched with the Amazon corresponding fields.

Once these fields are matched, you can create automatic rules to indicate if the product is a parent product or a child product.

Here is the kind of result you will need to have in the optimised feed (output from Lengow) so that Amazon accepts your product variations:

Note: These values are examples, adapt them according to your Inventory file templates.

2.8.5 Defining Parent product pages: What information must be provided about the parent products?

Amazon requires certain information for the parent product pages:

  • "Parentage" (or "parent_child") must be filled in with the value “parent”
  • "variation_theme" must be filled in with one of the permitted values (e.g. Size, Colour, SizeColour, etc.)
  • No EAN code (the Amazon fields “external_product_id” (EAN) and “external_product_id_type” must be empty)
  • No price (standard_price, sale_price, sale_from_date and sale_end_date must be empty)
  • No quantity (quantity must be empty)
  • No delivery time (fulfillment_latency must be empty)
  • No currency (currency must be empty)

You must fill in certain fields and clear others. Note, however, that you can create rules to manage all of these instances. Go to “Feed Management > Automatic rules”

Creating a "Parent Product Page" rule

Define the conditions of your rule in order to select only the “parent” rows in your catalogue.

Here are two examples of conditions:

or

Then perform these actions

2.8.6 Defining Child product pages: What information must be provided on the child products?

Amazon requires certain information for the child product pages:

  • "parent_child" must be filled in with the value “child”
  • "variation_theme" must be filled in with one of the permitted values (e.g. Size, Color, etc.)
  • "parent_sku" must contain the parent product reference shared by all of the product variations
  • "relationship_type" must correspond to the type of variation (Accessory or Variation)
  • An EAN code (the Amazon fields “external_product_id” (EAN) and “external_product_id_type” must be filled in)
  • "external_product_id_type" must be filled in with one of the values (ASIN, EAN, UPC, etc.) according to the “external_product_id” indicated
  • A variation attribute – a colour, a size, a length, etc. – must be provided in the corresponding Amazon field (Colour, Size, Length, etc.)

Note: These examples may vary, adapt them according to your Inventory file templates.

You can only create one rule to define all of this information.

Creating a "Child Product Page" rule

Define the conditions of your rule in order to select only the “parent” rows in your catalogue.

Here are two examples of conditions:

or

Then perform these actions

Note: These values are examples, adapt them according to your Inventory file templatesPlease note that if your parent reference field is not {parent_id}, indicate yours instead.

2.8.7 How do you fill in variation themes?

If you only have one theme: COLOUR

Your products only vary by colour: you sell a product that comes in different colours, for example.

In this case, you will need to create a new automatic rule:

Note: These values are examples, adapt them according to your Inventory file templates.

If you only have one theme: SIZE

Your products only vary by size: you sell posters that come in different sizes, for example.

In this case, you will need to create a new automatic rule:

Note: These values are examples, adapt them according to your Inventory file templates.

If you have several variation themes: SIZE and COLOUR

Your products vary by colour and size: you sell clothes that come in different sizes and colours, for example.

In this case, you will need to create a new automatic rule:

Note: These values are examples, adapt them according to your Inventory file templates.

If you have a catalogue that contains all three cases:

  • Some products that vary only by size
  • Some products that vary only by colour
  • Some products that vary by size and colour

Then you will need to set up three automatic rules for variation themes so that every eventuality can be taken into account.

2.8.8 More information about parentage

More information about building up Parent/Child Relationship on amazon's website

Amazon's note: The relationship you create is a relationship between your specific skus. When you submit your product information, Amazon will use the relationship information that you provide in connection with the information provided by other sellers of the same products to determine the specific relationship that is presented to customers. This means that the information displayed on the site may differ from your submitted relationship. The skus in your inventory, however, will reflect the most recent information you submitted, regardless of how the products are displayed on the site.

The next step after the feed is created is to link your Amazon Seller account to our developer account.

2.9 The options tab

In the “Options” tab of your Amazon feed, check the various points and modify them if needed. For more details about this tab, consult our tutorial "Options" tab.

2.10 Check the attributes in your updated feed 

To check the data sent to the distributer, consult the optimised feed. All the updating that you have done in Lengow will be visible IMMEDIATELY (automatic rules, search/replace, matching etc.).

Comment: Check your updated feed as often as possible to reassure yourself that your parameters have been correctly applied to your new products. 

3. Integration of your catalogue on the Amazon site

3.1 Linking Lengow with your Amazon (MWS) account

First step is to link Lengow with your Amazon Marketplace Web Services (MWS) account, you must first link your Amazon Seller Central account to our Lengow developer account.

Here is the procedure to follow for an AMAZON UK account:

  • Go to your Amazon Seller Central > Settings > User Permissions
  • Click on "Authorise a developer" (at the bottom of your page)
  • Complete : 
    • Developer's Name : "Lengow"
    • Developer ID : 1210-7071-8869 (for Amazon.co.uk)

Note: If you want to send your product catalog to an Amazon site other than “Amazon.co.uk”, please refer to the list of links and associated developer numbers below:

Amazon website Link to sign up with MWS Developer number
Amazon.com https://developer.amazonservices.com/ 1714-9375-2818
Amazon.ca https://developer.amazonservices.ca/ 1714-9375-2818
Amazon.co.uk https://developer.amazonservices.co.uk/ 1210-7071-8869
Amazon.de https://developer.amazonservices.de/ 1210-7071-8869
Amazon.it https://developer.amazonservices.it/ 1210-7071-8869
Amazon.es https://developer.amazonservices.es/ 1210-7071-8869
Amazon.fr https://developer.amazonservices.fr/ 1210-7071-8869
Amazon.com.au https://developer.amazonservices.com.au/ 5664-6054-8511

Please note that one MWS authorization is sufficient for all EU Marketplaces. Sellers active on more than one marketplace in Europe don't need to re-authorise our developer number 1210-7071-8869.

Click on "Next" to get these IDs:

  • Seller ID 
  • MWS Authorisation Token 

Do not hesitate to ask our Lengow support team, if you have any question.

3.2 Retrieving the Seller Token

The Seller Token is available in your Seller Central account (https://sellercentral-europe.amazon.com/gp/homepage.html). To find it, click on Settings > Account info > Your Merchant Token. It is displayed at the bottom of the page:

3.3 Enter the API user name and password in Lengow

You must enter your API user name and password in Lengow in order to be able to send your product catalogue to Amazon. To do this, you need to go to “Feed Management” and then the “API login” tab:

  • Merchand ID (Seller ID) 
  • Seller Token 
  • MWS Authorisation Token 

Be careful! Your products will not be sent to Amazon, if any of those values is false or empty.

Please note that pSeroducts will be automatically sent to Amazon once your API logins are entered and your categories mapped with Amazon’s. Pay attention to define the parameters of your products in Lengow, before filling in those API login.

3.4 Sending/uploading your catalogue

Your catalogue is automatically sent every four hours.

4. Delete or stop advertising a product 

4.1 Disabling a live product on Amazon

Lengow can only update products that are included in your source feed.

If you have already sold items on Amazon and your product reference numbers are different, Lengow cannot do anything with these products (impossible to update or delete).

To disable a live product through Amazon Seller Central you have two possibilities

- The manual solution: Go to the inventory management on Seller Central (Inventory → Manage Inventory), select in your inventory the “Active” tab in which you see only the active products then select the check box of all products, finally in the “Actions” select “Delete products and offers.” Caution must be done for each page of your active stock (this may take several pages).

- The half manual solution: Go to Download the Stock (Inventory tab) , then ask a “Inentory Report”, with the report in which you have all the products that have a strictly positive stock, you can then create a file “Inventory Update”, you load it in Inventory → Add products via Upload (choosing well as file type “Inventory Files for non-Media Categories”, and never checking the checkbox “Purge all my listings and replace them with this file”, and loading the file as text Separator Tab).

Be careful with the manual solution because it removes completly your listing and you can publish only when the new Lengow feed is sent. The second solution is more secure.

To disable a live product through Lengow on Amazon you have two possibilities:

• You can either disable the product in “Product Management” (make sure you don't have any automatic rules that contradict this action),

• Or you can enter a quantity of “0” in Lengow (using an automatic rule or directly in the product page, for example).

PLEASE NOTE: If the product is no longer sent to Amazon (unless it is sent with the quantity set at 0), the product will remain visible on Amazon with the latest inventory information known by Amazon. Amazon operates by updating data rather overwriting it.

Lengow has created a security mechanism which enables products to be saved virtually in “Product Management” when they disappear from your source feed. They are contained in the category “virtual products”. However, in order to avoid any problem due to over-selling, please keep the products that are out of stock in your source feed for 1 to 2 days so that the “product unavailable” information is definitely sent to Amazon.

4.2 Deleting one or more Amazon products

To delete one or more product pages on Amazon via Lengow, you must use Amazon's Update-Delete field and enter Delete in this field. This enables you to delete a product on the website and in your Amazon Seller Central account.

To do this, create an “UpdateDelete” virtual field in Lengow and match this field with the Amazon field of the same name in “Field matching”.

You can then either go to “Product Management”, search for your product, open the product page and enter Delete in the UpdateDelete field  at the bottom of the product page, then save  .

or you can create an automatic rule:

IF

(your product reference number field) IS (enter here the various product IDs to be deleted, separated by a vertical bar (|))

For example:

IF

PRODUCT_ID IS 1458|7895|5687

THEN

UpdateDelete becomes Delete

The “Delete” information will be automatically included in the optimised feed and sent to Amazon. The products will then disappear from your Seller Central account (within 1 hour max.).

Please note that if you put Delete in the "Personalized field" column in the “Field matching”, this value will be applied to all products in the feed and will delete them all from your Seller Central account. To delete your entire catalogue, you just need to go to “Feed Management > Field matching”:

• Enter Delete in Amazon's Update-delete field:

• Unmatch the “Image” field matched with the fields Main-Image, Swatch-image and OtherImage URL1 to 8

5. Managing Amazon orders

Lengow will retrieve your new Amazon orders from your "Orders Dashboard" each hour. Then orders update on Amazon according to the information entered in the solution.

However, if you edit an order in Amazon, the order will not be updated in Lengow.

Your Amazon orders must therefore be processed either in Lengow or in Amazon. (This must be done in Lengow if you would like to be able to retrieve Amazon order statuses from our API or via our imports of Prestashop or Magento orders)

6. Amazon integration reports

6.1 Download and format an Amazon integration report

Amazon integration reports are available from the "Indexing history" tab > "Report" link. Each time your Amazon optimized feed is sent, we keep an integration report. We recommend that you look at the latest version. 

The "Report" link will open the Amazon integration report in a new tab. If the latter is not available, wait until Amazon has finished processing your optimised stream or download the previous version.

In order to format an Amazon integration report, follow these steps:

  1. Copy the whole report from your browser
  2. Paste the values into a text editor (eg. "NotePad++" on PC or "TextWrangler" on Mac)
  3. Copy the values from the text editor
  4. Paste the values into an "Excel" spreadsheet
  5. Delete the lines that are used for the Amazon header (approximately the first 80 lines)

Reminder:

  • To select all of the values, use the "Ctrl+A" on PC or "cmd+A" keys on Mac. 
  • To copy the values, use the "Ctrl+C" on PC or "cmd+C" keys on Mac. 
  • To paste the values, use the "Ctrl+V" on PC or "cmd+V" keys on Mac. 

In the report you will find:

  • "Number of records processed": is the number of products sent, shown on the optimized feed (sheet, child and parent).
  • "Number of records successful": is the number of products properly configured and integrated on Amazon.

Products with errors follow (one line per error)

  • "original-record-number":  Amazon internal identifier. Not required for these purposes.
  • "SKU": The ID of the product concerned. You can send this value to Amazon in the optimized feed.
  • "error code":  Amazon error code
  • "error-type":  Type of Amazon error, there are three types:
    • "Info": Provides information on the integration report
    • "Erreur": Error that blocks publication of the product
    • "Avertissement": Error that does not block the publication of the product
  •  "error-message": description of the Amazon error

In order to increase the number of your references visible on Amazon, concentrate on the correction of "errors".

The 'Info' and 'Avertissement' messages do not prevent the publication of products. However, these are often associated with actual "errors".

Example of Amazon error reporting once in Excel format:

6.2 Main types of error and how to correct them

The explanation of errors is available on your Amazon Sellercentral. Here are the main errors and how to solve them:

Amazon error code: 8026

The merchant is not allowed to sell in this category of product. Validation of your account may be necessary depending on the area concerned.

ExampleSeller is not authorized to list products in this category. For more details, see: http://sellercentral.amazon.fr/gp/errorcode/8026

Action to take:

  • Contact your Amazon account manager and make a validation request.
  • If you don't have an account, fill in this form (select "Products and inventory" > "Issue with listing products" > "Difficulty adding or viewing a product" > "View and apply to restricted categories")

Amazon error code: 8541 or 8542

The correspondence of the given products is in doubt, Amazon is therefore unable to assign an ASIN to your product. 

ExampleThe SKU data provided conflicts with the Amazon catalog. The standard_product_id value(s) provided correspond to the ASIN XXX, but some information contradicts with the Amazon catalog. The following are the attribute value(s) that are conflicting: ...

Note: An ASIN is an Amazon internal product identifier. Each product on Amazon has its own ASIN. Merchants who sell the same product will have the same ASIN for that product. This allows Amazon to group multiple vendors on a single product sheet. If you get error 8541 or 8542, it means that Amazon thinks that an ASIN has already been created (often with the EAN code given), but that your product information does not correspond exactly with the information that Amazon already has for this ASIN. 

Action to take:

1 / Amazon sends the name of the concerned field, the value you sent and the value that they already have for the ASIN. Multiple fields may be concerned. You can verify that the proposed ASIN matches your product in two ways:

  • Look to see if the information given by Amazon corresponds to your product
  • Or check the product on Amazon by using the ASIN in your browser in the following manner: https://www.amazon.fr//dp/ASIN_HERE

2 / If the proposed ASIN corresponds to your product, there are two possible solutions:

  • Change the values that are causing the problem, in order to get closer to those given by Amazon and see if this solves the problem. We recommend that you go through your custom product values to make these changes.
  • Force publication by using the ASIN indicated by Amazon. In order to do this, a custom value must be input into the product sheet. The ASIN code should be placed into the "external_product_id" field, the value ‘ASIN’ must be placed in the "external_product_id_type" field.

Note: in order for the value shown on your product sheet to be taken into account in the optimised feed, the field must match those found in the "field matching" tab of the feed management page. 

You can then give the values requested by Amazon on the product form:

Note 2: it is possible to change ASIN values en masse. To do this, contact our customer support.

3 / If the ASIN proposed by Amazon does not match your product, contact Amazon support.

Amazon error code: 8560

Amazon cannot integrate the product, because at least one piece of mandatory information is missing.

Here are three common cases:

  • Missing EAN: As shown above, EAN codes are required to publish products on Amazon, they are used to identify products. It is therefore necessary to recover the EAN of the product from your supplier and to provide it to Amazon. If you are the manufacturer of your own products, you must acquire EAN codes for them.
  • Missing brand: Brand is an important element of Amazon matching since it allows verification of the EAN in the case there is any doubt.
  • Missing product type: “Product_type” is a variable, which is not requested during matching, that may be required depending on the areas involved and on the category type. Consult the authorised values found in the FlatFile for the area directly concerned. To find authorised values see the "Inventory Loader File Template" on Sellercentral.

Action to take:

Fill in the missing value on your Amazon feed.

Amazon error code: 20000

Amazon is unable to access the product image URL. 

ExampleWe could not access the image at URL http://my-website.com/my-image.jpg. Ensure the URL is correct and the image is publicly accessible.

Action to take:

Check that: 

  • The product image URL loads correctly in your browser.
  • The product image URL is available publicly.

If not, correct this in your source feed. 

Amazon error code: 20005 or 13013

This error is due to a malfunction of the report. It will be removed from the error report when other errors are corrected.

Example: error 13013 : This SKU does not exist in the Amazon.com catalog. Your inventory data was not processed. For reasons why, and help fixing this, see http://sellercentral.amazon.com/gp/errorcode/13013

Example: error 20005Images could not be associated with this SKU. This error may be resolved by addressing other product data errors. For more information, see: http://sellercentral.amazon.com/gp/errorcode/20005

Note: If this error is not due to another error, that means that the product is in process of creation.

Amazon error code: 90117

The maximum number of characters in the "Description" field for this product has been exceeded.

Example: The Product Description field contains an invalid value: […] The value exceeds the maximum number of characters allowed: 2000.

Action to take:

Amazon error code: 99001

The brand is not populated for this product.

ExampleA value is required in the "Message/Product/DescriptionData/Brand/..." field

Action to take:

Add the brand for the product concerned and it will be integrated.

Amazon error code: 99003

The values in the field "size-map" or "colour-map" are not correct. For these fields Amazon requires values available in the "Inventory Loader File Template" on Sellercentral.

ExampleA required value is missing for the specified variation theme.

Action to take:

Perform a "search/replace" or "automatic rules" to adapt the values in your source feed so that they match the values required by Amazon.

Amazon error code: 20014

When the image is in https, Amazon may return an error indicating that it is unavailable.

Error would be: The submitted image is invalid or corrupted

If the image URL is also available in http, then use the search / replace tool to amend the URL to http and correct the error.

If the URL is available in HTTPS, wait for the next Amazon error report to see if Amazon still detects a problem recovering your image.

7. Useful links