Troubleshooting CSV template errors: Import orders

Troubleshooting CSV template errors: Import orders

To import orders in bulk, you need to use the CSV template. You might receive errors if the CSV template is not filled correctly.

In this article, you will learn how to troubleshoot the CSV template errors received while importing orders.

Error

How to resolve

Failed: Channel order ID is missing; it cannot be blank. Make sure to add the Channel order ID and upload the CSV again.

Make sure to enter the Channel order ID. Do not leave the Channel order ID column blank.

Failed: Customer order ID is missing; it cannot be blank. Make sure to add the Customer order ID and then upload the CSV again.

Make sure to enter the Customer order ID. Do not leave the Customer Order ID column blank.

Failed: Payment method is incorrect in CSV. Make sure to add the correct payment method, like COD or prepaid, and then upload the CSV again.

The payment method should be either COD or Prepaid.

Failed: COD amount is missing. Make sure to add the COD amount when the payment method is COD, and then upload the CSV again.

Make sure to enter the COD amount if the payment method is COD.

Failed: COD amount is incorrect in CSV. Make sure to add the correct COD method and then upload the CSV again.

Make sure the COD amount entered is not a negative value.

Failed: The shipping contact number is in the alphabet. Make sure to add the correct number and then upload the CSV.

Make sure the shipping contact number entered does not have alphabets.

Failed: The shipping contact number is incorrect. Make sure to add the required 10-digit correct number and then upload the CSV.

Make sure no country code or 0 as a prefix is added to the shipping contact number.

Failed: The shipping contact number is missing; it cannot be blank. Make sure to add the shipping contact number and then upload the CSV.

Make sure to enter the shipping contact number when Eshopbox is the shipping provider.

Failed: The shipping contact number is incorrect; it cannot be a special character. Make sure to add the 10-digit shipping contact number and then upload the CSV.

Make sure no special characters are present in the shipping contact number.

Failed: The shipping customer name is missing; it cannot be blank. Make sure to add the shipping customer name and then upload the CSV again.

Make sure to enter the shipping customer's name. Do not leave the shipping customer name column blank.

Failed: The shipping customer's name is incorrect. Make sure the shipping customer name is not numeric, and then upload the CSV again.

Make sure there are no special characters in the shipping customer's name.

Failed: The shipping email ID is incorrect. Make sure to add the correct shipping email ID, and then upload the CSV again.

Make sure the shipping email ID entered is correct.

Failed: The shipping address is missing; it cannot be blank. Make sure to add the shipping address and then upload the CSV again. It is mandatory if you have opted for Eshopbox shipping.

Make sure to enter the shipping address. Do not leave the shipping address column blank if you have opted for Eshopbox shipping.

Failed: The shipping pin code is incorrect. Make sure to add the correct shipping pin code and then upload the CSV again. It is mandatory if you have opted for Eshopbox shipping.

Make sure to enter the shipping pin code. Do not leave the shipping pin code column blank if you have opted for Eshopbox shipping.

Failed: Shipping country is missing; it cannot be blank. Make sure to add the shipping country and then upload the CSV again.

Make sure to enter the shipping country. Do not leave the shipping country column blank.

Failed: Shipping country is incorrect in CSV. Make sure to add the correct shipping country, then upload the CSV again. Enter IN for India.

Make sure the shipping country entered should be IN for India.

Failed: Product ID is missing; it cannot be blank. Make sure to add the Product ID and then upload the CSV again.

Make sure to enter the Product ID. Do not leave the Product ID column blank.

Failed: The selling price is missing; it cannot be blank. Make sure to add the selling price and then upload the CSV again.

Make sure to enter the selling price. Do not leave the selling price column blank.

Failed: The selling price cannot be negative.

Make sure the value of the selling price entered is not negative.

Failed: If the selling price is incorrect, upload the CSV again.

Make sure the selling price unit is a numeric value only. Alphabet and special characters are not allowed.

Failed: Quantity is missing; it cannot be blank. Make sure to add the quantity and then upload the CSV again.

Make sure to enter the quantity. Do not leave the quantity column blank.

Failed: Quantity cannot be negative.

Make sure the entered value of the quantity is not negative.

Failed: The quantity is incorrect. Make sure the quantity is numeric, and then upload the CSV again.

Make sure the entered value of the quantity is a numeric value.

Failed: The shipping label and invoice URL are incorrect. Make sure to add the correct shipping label and invoice URL, and then upload the CSV again.

Make sure the shipping label and invoice URL should start with either http or https.

Failed: The gift wrap is incorrect. Make sure to add the correct gift wrap and upload the CSV again.

Make sure the gift wrap column has only “Yes” or “No” as value.

Failed: You cannot create an order using a virtual kit ESIN. Make sure to use the component of the virtual kit to create the order and then upload the CSV again.

You need to use a component of the virtual kit to create an order. Make sure the SKU provided is a base product or a virtual kit.

Failed: Channel order id is blank for other items in the CSV. Make sure to add the Channel order ID and upload the CSV again.

Make sure to enter the Channel order ID. Do not leave the channel order id column blank for any ordered item.

Failed: You have an issue in other items of this order. Make sure to resolve them and then upload the CSV again.

Make sure to check the remark for other order items of the order.

Failed: The date format is incorrect. Make sure to use the correct date format dd-mm-yyyy hh:mm:ss and then upload in CSV.

Make sure to add the correct date and time format i.e. dd-mm-yyyy hh:mm:ss in CSV. All the characters should be written in small.

Failed: Forward shipping provider is missing; it cannot be blank. Make sure to add the Forward shipping provider and upload the CSV again. Enter "Eshopbox" if you want Eshopbox to ship the order.

Make sure to not leave the Forward shipping provider column blank in the CSV. Enter "Eshopbox" if you want Eshopbox to ship the order.

In case you still face any issues, you can contact Eshopbox support by raising a support ticket from your Eshopbox workspace. Learn here how to raise a support ticket.

Note: Please share the import CSV file and the error you are getting while raising the support ticket.