To transfer the orders back to the vendor, a daily orders.csv is generated and uploaded to the dedicated SFTP server. The vendor has to download and process the file, and move it to an archives folder. The order file includes the timestamp and is unique.
The file contains following columns, including header:
- order_id: The 35up internal identifier of the order. This one has to be passed throughout all communication
- item_id: The 35up internal identifier of the order item. This one has to be passed throughout all communication
- item_sku: The vendor SKU for the item bought
- item_qty: The qty of the item bought
- shipping_first_name: First name of the shipping address of the end customer
- shipping_last_name: Last name of the shipping address of the end customer
- shipping_company: (optional) Company name of the shipping address of the end customer
- shipping_extra: Additional line of the shipping address of the end customer
- shipping_street_name: (optional - either street name and number or line) Street name of the shipping address of the end customer
- shipping_street_number: (optional - either street name and number or line) Street number of the shipping address of the end customer
- shipping_street_line: (optional - either street name and number or line) Street name and number of the shipping address of the end customer
- shipping_city: City of the shipping address of the end customer
- shipping_state: (optional) 2 digit (ISO 3166-1 alpha-2) state code of the shipping address of the end customer
- shipping_country_code: 2 digit (ISO 3166-1 alpha-2) country code of the shipping address of the end customer
- shipping_postcode: Post code of the shipping address of the end customer
In case a customer orders more than one different item, multiple lines will be generated within the file.
Example file download
