Managing failed order imports

When the bol.com connector fetches order feeds from bol.com, it will create a new Prestashop order for every item in every order that it finds.
So, when 1 client buys 2 different products from you in the same order, you will end up with 2 Prestashop orders which are linked.

Before creating an order, the import process will check if it can link the product found in the order to precisely one product in your Prestashop shop.
If it can’t, then it will log the found information and you will need to tell it to which product it should map the found info.

You will be notified about this fact in the order overview (see image below) so you do not need to check the “Manage failed order imports” page manually.

Note that you should generally not need this module. If you maintain a well organised system where Reference Code’s and EAN’s are unique, you should need this screen only on very rare occasions.

The process

The sequence in which the import process tries to find a local product for the bol.com order is:

  1. Check if there is exactly 1 product in the product table with reference code abc123.
    Yes? -> Use that product.
    No? -> Continue with step 2.
  2. Check if there is exactly 1 product in the product table with EAN 8718256058165.
    Yes? -> Use that product.
    No? -> Continue with step 3.
  3. Check if there is a mapping for this EAN/Reference code combination in the “failed import mappings” table.
    Yes? Use that product and delete the mapping.
    No? Store the found EAN and Reference code in the “failed import mappings” table.

The screen

As you can see in the overview above, apparently an order was found for a product with EAN 0192835646372 and Reference code NONEXIST234 , but it’s hasn’t been mapped to a local product yet.
Click “edit” to do so.

Mapping a product combination

If you need to map a product combination (let’s say the T-Shirt – Size: L, Color: Navy) then you need to find the Local Product Combination ID.
This ID can be found by navigating to the product combination in the product tab and remembering its “product_attribute_id” as seen below.

You don’t need to enter the Local Product ID.

Mapping a regular product

The Local Product ID you need to fill out is the database ID of the product. You can find this in the Catalog -> Products overview as seen below.

Once you’ve stored that mapping, run the import process again (or wait for the scheduled task to run again) and your order should get imported.

After that, the warning at the top of the orders page should be gone and your “Managing failed order imports” should be empty again.