ShiftDocs

Orders and shipping

Upload orders in bulk

Last updated

Use the Bulk Order tab on the Create Order screen to upload many orders at once via a CSV file.

Bulk order upload file requirements

  • CSV format only.
  • Maximum file size: 10 MB.
  • Click Download Template on the Bulk Order tab to get the sample CSV with the exact expected columns.

Bulk order upload required columns

Based on the downloadable template, here's what each row needs:

Required: S NO, Payment Method (COD/PPD), Customer Name, Customer Mobile, Customer Shipping Address Line 1 and Line 2, Customer Country, Customer State, Customer City, Customer Pin code, Product Name, Product SKU, Product Quantity, Product Cost, and Weight (kg).

Optional: Order Number (custom), Order Date, Customer Email, Product HSN Code, Product Tax %, Product Category, Length/Breadth/Height, and Order Type (Essentials/Non Essentials - if you're not sure which applies, reach out to support for further information).

Order date format and sender (seller) columns in the bulk upload file

Order Date format: if you fill this in, use dd-MM-yyyy HH:mm (for example, 02-01-2022 21:09).

Sender (seller) columns are all-or-nothing: the Seller Name, Seller Email, Seller Mobile, Seller Address Name, Seller Shipping Address Line 1/2, Country, State, City, and Pin code columns are all optional as a group - if you leave every one of them blank, your account's primary pickup address is used automatically for the whole file. If you fill in even one seller column, all of the seller columns become required for that row.

Multi-Product orders in bulk order upload

To add multiple products to a single order, repeat the same S NO (serial number) across multiple rows - all rows sharing an S NO are combined into one order. All rows in the same group must share the same receiver address and payment method. Order Number is optional - if left blank, it's generated automatically per order/group.

Tips for a clean bulk order upload

The How to Upload Orders section on the Bulk Order tab lists these tips:

  • Ensure all required fields are filled in correctly so your orders upload smoothly without any errors.
  • Ensure each Order Number is unique in your account to avoid duplicates.
  • Ensure the customer's Address Line 1 and Line 2 are entered accurately so deliveries reach the right place.
  • Seller/sender fields are optional - if left blank, your account's primary pickup address will be used. If you do fill them, all seller fields must be completed.
  • To add multiple products in one order, use a new row for each product with the same S.No. Order Number is optional and will be auto-generated if left blank.

Bulk order upload progress and results

  • Only one bulk upload can be in progress at a time per account - you'll need to wait for a running upload to finish before starting another. Progress is shown live as the file processes.
  • Each order in the file is processed independently: if some rows have errors, the valid orders in the same file are still created; only the problem rows are skipped.
  • When the upload finishes, you'll see one of two results: all orders processed successfully, or a partial success message showing how many orders were imported and how many had errors.
  • You can download a sheet of just the failed rows, with the reason for each failure, so you can fix and re-upload only those.
  • Successfully uploaded orders land in Forward Orders at New status.
  • The Upload History on the same tab shows your past uploads (Batch ID, Details, Status), with a summary message for each.

What file format does bulk order upload accept, and are there any limits?

CSV only, up to 10 MB. Only one bulk upload can be in progress at a time.

What columns are required in the bulk order upload template?

S NO, Payment Method, Customer Name, Customer Mobile, Customer Shipping Address Line 1 and Line 2, Customer Country/State/City/Pin code, Product Name, SKU, Quantity, Cost, and Weight. Everything else - Order Number, Order Date, Customer Email, HSN Code, Tax %, Category, dimensions, Order Type, and all seller/sender fields - is optional. Click Download Template on the Bulk Order tab to see the exact columns and format.

What date format should I use for Order Date in the bulk upload file?

dd-MM-yyyy HH:mm - for example, 02-01-2022 21:09.

How do I add multiple products to one order in my bulk upload file?

Repeat the same S NO (serial number) across multiple rows - all rows with the same S NO are combined into a single order. They must share the same receiver address and payment method.

What happens if some rows in my bulk upload file have errors?

The valid orders in the file are still created - only the problem rows are skipped. You can download a sheet listing the failed rows with reasons, so you can fix and re-upload just those.

Still need help?

Your account manager and our support team are a message away.

Talk to us