Flexport recently launched manual bulk order upload functionality. Merchants can now save time by uploading up to 1000 orders at once rather than one order at a time.
How it works:
1. Navigate to the Orders page and select Import Orders
2. Download the CSV template and enter your order information
The file is required to be CSV. We will enable other file types in the future.
Details about the fields in the template:
|
Recipient First Name |
Required |
| Recipient Last Name | Required |
| Street (Line 1) | Required |
| Street (Line 2) | Optional |
| City | Required |
| State |
Required for domestic U.S. addresses Optional for international addresses |
| Country |
Required for all addresses Must be the 2-letter ISO country code https://www.nationsonline.org/oneworld/country_code_list.htm |
| Zip Code | Required for domestic U.S. addresses Optional for international addresses |
| Service Level |
Required Standard 2 day 3 day AK/HI/US Territories US Military Worldwide Standard |
| Custom Order ID |
Optional We included this field for sellers who wish to use their own unique custom Order IDs e.g. to map to other order management systems |
| DSKU* |
Required This field must contain the DSKU, no other type (UPC, code 128) will successfully upload |
| Quantity DSKU | Required |
*The template allows for up to 8 DSKUs
3. Click Import Orders
You will then see the order import in progress
Before creating orders, you will see a preview of the total cost of the orders.
Once you click Create orders, you will see the order creation in progress.
If there are no upload errors, you will see a message with the count of orders created
Once the upload is complete, you will see a message in the notification bar.
4. Errors
When importing orders, the below errors can occur. When possible, we will indicate which rows in the CSV file are experiencing the errors.
| Invalid country code | Country codes must be the 2-letter ISO country codes specified here https://www.nationsonline.org/oneworld/country_code_list.htm |
| Invalid service level |
Service levels must be entered exactly as they are specified in the template: Standard, 2 day, 3 day, AK/HI/US Territories, US Military or Worldwide Standard |
| Invalid or unknown DSKU | The DSKU must be 11 characters and start with a "D" |
| Missing city, country, name, or street | These are required fields for all addresses |
| No items | Each row must contain at least on DSKU and the DSKU quantity |
| Invalid or missing quantity | Quantity must be a number greater than zero and is required |
FAQs
1. Will tracking automatically be passed to the marketplace for these orders?
No, tracking will not be uploaded to the marketplaces because these are manual Flexport orders. Merchants will need to send the tracking numbers to their customers when the orders are uploaded.
2. When will Flexport enable other file types (.txt)?
We will likely offer other file formats in Q3 2022
3. How many orders can I upload at once?
You can upload 1000 orders at once.
4. Can I bulk upload removal orders?
No, at this time merchants cannot bulk upload removal orders.
5. Can I upload multiple files?
No, only one file can be uploaded at one time.
6. Will all carriers be eligible for bulk upload orders?
Yes, there are no carrier restrictions.
7. Are special characters allowed in the name or address field in the template?
No, not at this time. Our shipping labels cannot have special characters.
8. Can I enter zip codes starting with the number 0 into the template?
Yes. To do this, you will need to update the column to Text instead of Number format.