To bulk import orders (note this feature is only available in paid plans), you will need to click the upload icon on the top right of the Orders section.

Once you see the pop-up

Click the “Download Sample File” link to download a sample CSV order import file.

Open the CSV file. You will see some sample orders in this file

Important: please do NOT change the first header row of this file or it will cause an import failure.

You can delete the existing rows of sample orders and create new rows with the following parameters:

Field NameDescription
*Order IdThis is a required field. This is usally the order ID of the channel/shopping cart/marketplace you’re trying to import the order from.
Order Date as dd-mm-yyyyThis is an optional field to indicate the date the order was placed on your channel. If you leave this blank, the system will assume today’s date as the order date.
*ChannelEnter the name of the channel for which you’re importing orders. For example, for manual order you can use the channel name – CUSTOM.
*Payment Method(COD/Prepaid)A mandatory field to indicate whether the order is cash on delivery (COD) or Prepaid.
*Customer First NameThis is the consignee’s first name.
*Customer Last NameThis is the consignee’s last name.
*EmailThis is the consignee’s email.
*Customer MobileThis is the consignee’s mobile number.
*Shipping Address Line 1This is address line 1 for the consignee’s shipping address.
*Shipping Address Line 2This is address line 2 for the consignee’s shipping address.
*Shipping Address CountryThis is country for the consignee’s shipping address. For most purposes this should be – India.
*Shipping Address StateThis is the state for the consignee’s shipping address.
*Shipping Address CityThis is the city for the consignee’s shipping address.
*Shipping Address PostcodeThis is the post code for the consignee’s shipping address.
Billing Address Line 1Optional field incase billing address is different from shipping address.
Billing Address Line 2Optional field incase billing address is different from shipping address.
Billing Address CountryOptional field incase billing address is different from shipping address.
Billing Address StateOptional field incase billing address is different from shipping address.
Billing Address CityOptional field incase billing address is different from shipping address.
Billing Address PostcodeOptional field incase billing address is different from shipping address.
*Master SKUThis is a mandatory field. In Shiprocket, every channel order must link to a master SKU. You will need to manually create (or bulk import) your catalog with SKU codes into Shiprocket and then ensure the SKU code is mapped to orders you’re importing using this bulk importer.
*Product QuantityQuantity of the product that is being ordered. This is a mandatory field.
*Selling Price(Per Unit Item, Inclusive of Tax)Listed price of the product that was sold in this order.
Discount(Per Unit Item)Discount amount (if applicable). This is an optional field.
Shipping Charges(Per Order)Shipping charges (if applicable) on your order. This is an optional field.
COD Charges(Per Order)COD charges (if applicable) on your order. This is an optional field.
Gift Wrap Charges(Per Order)
Total Discount (Per Order)
Weight Of Shipment(kg)This is important and will help avoid billing errors later. Please fill the weight of the shipment in KGs in this field.
Send Notification(True/False)Whether you want to notify the customer on shipment updates for this order.
CommentAny comments you want to record against this order.

On successful import, you will see a message as follows:

 

If bulk import fails, you will see an error:

You can download the error file to see the details of the error. The file will only contain records which are errored out, and the rest of the records will import.

You can see the “error” column in the CSV to see the nature of the error:

You can then fix the errors in your input CSV import file and re-try.

in Bulk Import and ExportOrders

Related Articles