Ordoro provides a user-friendly interface for creating or updating orders, products, tracking numbers, and more. However, in cases where bulk updates are required, our Data Import feature is the perfect solution. By uploading CSV files, users can quickly and efficiently make large-scale changes to orders and products, streamlining their workflow and saving valuable time.
Related support articles:
- How do I use the Data Import?
- How do I update products in bulk?
- How do I bulk update inventory quantities?
- Can I create Purchase Orders in bulk in Ordoro?
How to create orders via a CSV file
1. Go to Account Settings -> Data Import.
2. In the dropdown menu, select Create Orders.
3. Download the example file for the data type. This will download a CSV file to your computer.
4. Open the example file and edit it to manage your bulk update. The columns in the spreadsheet are listed below.
- Order ID *Required
- Order Date
- Notes from Customer
- Grand Total
- Product Amount
- Tax Amount
- Discount Amount
- Shipping Amount
- Shipping Type
- Ship to Name
- Ship to Company
- Ship to Email
- Ship to Phone
- Ship to Street 1
- Ship to Street 2
- Ship to City
- Ship to State
- Ship to Zipcode
- Ship to Country
- Bill to Name
- Bill to Company
- Bill to Email
- Bill to Phone
- Bill to Street 1
- Bill to Street 2
- Bill to City
- Bill to State
- Bill to Zipcode
- Bill to Country
- Line Product SKU *Required
- Line Product Name *Required
- Line Item Price (Must also include Line Total Price for Line Item Price to appear)
- Line Quantity *Required
- Line Notes
- Line Discount Amount
- Line Total Price
5. Upload the file using the drag and drop feature or select the file from your computer.
6. Follow the remaining steps in this help article to save the information.