Before you start
Prepare .xlsx, .csv, .txt or .tsv, not legacy .xls. Choose an available warehouse and matching format.
Steps
- Download the sample CSV for headers; select file, format and warehouse, adding an opening password when needed.
- Use Preview. Check valid, failed, skipped and order counts. Correct errors in the original file and preview again.
- Review the duplicate warning before import. Check results and history, then create a batch in DG orders.
Verify the result
Compare imported orders/lines and failed rows. Preview alone creates no orders, and failed rows are excluded.
Notes and examples
Required fields: request_date, customer_name, product_name, original_qty. Quantities must be positive with at most 5 decimals. Orders group by order number, date and customer.
Limitations
Limits: 20 MB, 50,000 rows and 300 columns. Use supported text encoding. Importing the same file again creates duplicate orders.
Troubleshooting
Use row errors to check dates, numbers and headers; check the format for sheet errors. Remove Excel protection if unsupported rather than repeatedly forcing imports.
Frequently asked questions
What is Import orders for?
Preview standard or marketplace files and create DG orders from valid rows.
What do I need before using Import orders?
Prepare .xlsx, .csv, .txt or .tsv, not legacy .xls. Choose an available warehouse and matching format.
How do I use Import orders?
Download the sample CSV for headers; select file, format and warehouse, adding an opening password when needed. Use Preview. Check valid, failed, skipped and order counts. Correct errors in the original file and preview again. Review the duplicate warning before import. Check results and history, then create a batch in DG orders.
How do I verify the result in Import orders?
Compare imported orders/lines and failed rows. Preview alone creates no orders, and failed rows are excluded.
What should I keep in mind in Import orders?
Required fields: request_date, customer_name, product_name, original_qty. Quantities must be positive with at most 5 decimals. Orders group by order number, date and customer.
What are the limitations of Import orders?
Limits: 20 MB, 50,000 rows and 300 columns. Use supported text encoding. Importing the same file again creates duplicate orders.
How do I troubleshoot Import orders?
Use row errors to check dates, numbers and headers; check the format for sheet errors. Remove Excel protection if unsupported rather than repeatedly forcing imports.