Sales history can be added to our system in several ways. The standard integration and the API are preferred.
Before forwarding your sales history, please contact us. We will check if the information is not already in our system.
The information must be provided in a fixed format. The file must be a CSV file, separated by commas.
Send the file to support@optiply.nl and we will process the list for you within 48 hours.
Below is how to pass on your sales history to us:
Sales History
It is possible to deliver sales history. In order to process sales order lines, they must be delivered in the following way:
remote_order_id,ean,sku_id,quantity,subtotalvalue,placed,completed
1,8718923131580,123-ABC,1,100.50,01-01-2020,02-01-2020
2,8718923013398,898-OIU,45,90,02-01-2020,02-01-2020
3,,012ee2g,8,,02-01-2020,
4,8718923455432,098-WEEK,1,5.02,02-01-2020,03-01-2020
4,8723249234553,024-fedg,8,6.02,02-01-2020,03-01-2020
You can also use this template to create your file: sales data template.csv
In this CSV file:
- At least we need the remote_order_id, sku, quantity and placed
- placed - is the date on which the order was placed.
- completed - is the date on which the order was shipped.
- remote_order_id - is the order number and can be retrieved from the source system. It ensures that each order will always be correctly matched when importing multiple files.
- ean, subtotalvalue and completed need to be in the heading but the values in the columns are optional (can be empty).
Note:
The 'order line price' (subtotalvalue) must be given in a maximum of two decimals and separated by a dot.
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.