Managing failed order imports

⚠️ This page is missing screenshots and will be updated soon

When the bol.com connector fetches orders from bol.com it will create a new Prestashop order for every order it finds on bol.com.
It will not create duplicate orders.

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 rarely need this functionality if you keep your Reference Code’s and EAN’s unique.

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.

If the mapping was successful the module will check if there is still enough stock to accept the order.
If not then the order will be skipped too.

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.