Skip to main content

Order items

1. Preparing the import file

Before we explain the process of importing and updating order items, we provide you with important information regarding the import of data into your plentymarkets system in this chapter.

Your plentymarkets system obtains the necessary data on the order items from an import file in CSV format. This import file has to contain the following columns, as you can see from this sample set up from the dynamic export:

EN elasticsync bp order importdatei

Make sure that the CSV file required for the next step is saved locally on your computer.

2. Importing and updating order items

This chapter describes how to use ElasticSync to import and update order items. Order items are items included in an order.

Carrying out the basic settings:

  1. Go to Data » Elastic Sync NEW.

  2. Click on the plus sign (Add sync).

  3. Enter a distinct name for the sync in the area Basic data.

  4. Select the option Orders from the drop-down list Type.

  5. In the area Import, you can leave the settings as they are.

  6. In the area Source, select the option HTTP.
    → Three further lines are displayed.

  7. In the drop-down list HTTP options, select the options Data upload.

  8. In the line URL, click on the button with the three dots (Select file).
    → A new window opens.

  9. Click on Upload file, select the CSV file containing the data belonging to the order items that you wish to import, and click on Open.

  10. Place a check mark in the line of the file and click once in the line of the file.
    Important The line must be clicked a second time. Only when the line is displayed in blue can you upload it by clicking on Select.
    → The URL – i.e. the path from that you uploaded the CSV file – is now displayed in grey in the field URL.

  11. Save the settings.

You have uploaded the CSV file successfully. In the following, carry out the matching settings.

Carrying out the matching settings:

  1. Click on Matching on the left side.

  2. In the Matching area, select the following data fields to update the order items:

EN elasticsync bp order matching
Functionality of the matching

The matching fields selected here and available in the sync type orders are generally linked by an AND-condition. This means that if the fields Order ID and Variation ID are selected, only data lines containing values for both these data columns are imported.

Next, you carry out the mapping settings.

Carrying out the mapping settings:

  1. Click on Mapping on the left side.

  2. Click on the plus sign (Add mapping).

  3. Enter a name.

  4. In the field Position, enter the number 1.

  5. Save the settings.
    → The area Import data / plentymarkets data fields opens.

In this area, you assign the fields from your CSV file to the data fields in plentymarkets. Assign the fields displayed to the left to the plentymarkets data fields as shown below:

EN elasticsync bp order mapping
Mandatory fields for mapping

Please pay attention to the fact that the plentymarkets fields Order item / Description, Order item / Quantity, Order item / Currency and Order item / Type are mandatory fields. You can only import and update order items at the same time if you carry out the mapping settings as shown above.

3. Testing and carrying out the sync

After having carried out the settings described above, you should test the sync using the button Test sync.
The first 10 lines of your CSV file are used for the test, and no cache is used. After running the test, check the log for error messages by clicking on the Log button or open the tested orders manually. We recommend that you only start running the sync after the test sync has been completed without error messages.

To top