Unable to find the expected product for order

 

You import your orders and you get an error message like this:

Unable to find the expected product for order - #000-123456-12345678 ASIN: B0011ABCDE SKU: XXX-YYY
- Skipping Order: Product count mismatch (000-123456-12345678)

It simply indicates that the module cannot find the product in your database.

You use the module for the first time :

It is possible that you have a previous inventory on Amazon with different references, in this case you will have to purge your inventory on Amazon and you can only import new orders, the ones created with references matching the ones you have on PrestaShop.

Take note of the article: Validate your catalog structure

Proceed then to an export by sending offers (synchronization) and matching

You have exported your products with the module :

The module imports products using as identifier the “Reference” field. On Amazon this field is the SKU. SKU corresponds to the Reference field on PrestaShop.

First, take note of the article: Validate your catalog structure explaining that.

Then, if your product does contain a reference, make sure that:

  • The product is active and is in Stock
  • This reference is identical in all points to the one in the order you are trying to import from Amazon
  • The reference on PrestaShop does not contain spaces before or after
  • The product is not a duplicate (multiple items with the same reference)