Importing buy orders
With a few exceptions, it is possible to import buy orders into Optiply. In the case your integration does not allow it, it is possible to create a .csv file to import buy orders into Optiply.
Here is how to create the file:
supplier, bo_remote_id,ean_code,sku_code,quantity,sub_total_value,placed,completed
abc,8718923131580,,123-ABC,1,100.50,01-01-2020,02-01-2020
abc,8718923013398,,898-OIU,45,90,02-01-2020,02-01-2020
abc,,,012ee2g,8,,02-01-2020,
abc,8718923455432,,098-WEEK,1,5.02,02-01-2020,03-01-2020
abc,8723249234553,,024-fedg,8,6.02,02-01-2020,03-01-2020
In this CSV file:
- supplier - name of the supplier in the order
- buy_order_id - is the number of the order as you have it in your source system.
It ensures that each order will always be correctly matched when importing multiple files.
- ean - identifier of the product.
- sku_id - identifier of the product
- quantity -number of products in the order line.
- subtotalvalue - total price of the amount in the line.
- placed - is the date on which the order was placed.
- completed - is the date on which the order was closed.
- ean, subtotalvalue and completed need to be in the heading, but the values in the columns are optional (can be empty).
Note:
When both 'ean' and 'skuCode' are filled in, 'ean' is used as identification. We recommend filling in only the 'skuCode' where possible.
The CSV file must be comma-separated.
At least we need the remote_order_id, sku, quantity and placed ( the rest of the columns can remain empty but not with "Null" or "0"
The date format must be DD-MM-YYYY or YYYY-MM-DD
You can also use this template to create your file: buy_order_template.csv
Before forwarding your buy order history, please contact us. We will check if the information is not already in our system.
Send the file to support@optiply.nl, and we will process the list for you as soon as possible.