Order import allows vendors to import orders from a CSV file you pull from any integration or platform allowing vendors to distribute orders from any channel before an integration has been built, decreasing manual effort on your part and increasing fraud protection.
To import, first, move to the Order tab and navigate to Order Import.
Import setup is the most difficult part, once you’ve set this up, you’ll be able to use the same setup to continually upload orders from the same file source.
Name: name the import so it can easily be identified in your import table
Description: Add context in case you have any notes particular to this import type
Import type: CSV, this means you’ll be uploading a comma-separated value file (CSV File)
Downloading your CSV File
In order to upload a CSV, you’ll need a CSV. Below, we’ll walk through Shopify and eBay, showing you how to download a CSV file for use in the import tool.
Changings a CSV file:
CSV files are a file type - in the case you upload a file and it is in .xls you’ll need to change it to a CSV. This can be done by the following the method below.
Uploading the file
Next, you’ll be able to upload the CSV file.
To import the file, press the Upload Orders and select the CSV file you’d like to import
Currently, our system can only handle 100 orders per file upload
Select Same as billing address if the shipping address is the same as the billing address
Select CSV file with headers if the CSV file has headers in the first row, such as the file below.
Select Comma or Semi-colon delimited file depending on your file type.
Comma or semi-colon delimited file is a region-based setting
Switching from a semi-colon to a comma-delimited CSV file is easy. Here's how:
- Click on the Start menu.
- Type control panel.
- Click on Control Panel (Desktop app).
- Select Clock, Language, and Region.
- Click Region.
- Select Additional settings in the pop-up window.
- Change the List separator to a comma.
- Click Apply.
- Hit OK.
Once done, try saving your CSV file and check if you will see a comma instead of a semicolon
Now that we have our file, with headings, in CSV format we’ll move to fulfill our first set of orders. Below you’ll find a sample file we’ll use to fulfill our orders.
We’ll now map in our columns, to map in columns, you’ll enter the column position, using integers (i.e. 1,2,3,4) to map in the columns into all the fields.
Once mapping in all columns, you’ll press Update.
Once Update is pressed, your orders will now show in the CSV list as follows.
Once created, press “Run” and the dispatch will begin processing, marking the row as running and will gradually create and distribute the orders. This takes a few minutes as this takes a significant amount of system processing. When running the system will show a Y for is running.
Once the order is marked as N for is running, a new CSV file can be uploaded if it has the same column order and settings, pulling in new orders and automatically dispatching them.
Change the existing CSV file, by selecting
then go to the Import dashboard and press run, for the operation to run again with the new information
As a measure to protect vendors, we’ve made it so the Platform order ID field will automatically recognize two orders with the same order ID.
If an order with the same order ID is caught, ZeroOne will not distribute the product, avoiding duplicate distributions.
In the case, a file is running and orders are unable to be uploaded into the system, you can check the status by looking at the status column on the import page. Here you will how many items were processed and errors in distribution.
To view errors, you can go to the logs by going to the Import Settings, and pressing Logs
here you’ll see the items which had errors and the reason why the error occurred