Troubleshoot Missing Orders when Imported via CSV File

Reason: There could be many reasons why orders are not imported via CSV file, like fields that aren’t mapped correctly, data mismatches, special characters in the data, etc.

1). Check the field mapping settings you chose for the CSV import:

The user needs to verify the field mapping to determine whether the field you have in the CSV file is mapped in Webgility or not. If it’s not mapped correctly, then you need to map it accordingly.

2). Check whether there are extra commas in the row:

Find the row with the extra comma and remove it. Note: Extra commas are often found in name and address fields. Save the CSV file and import it again.

3). Check whether there are special characters in the CSV file:

Usually, special characters will be found in the Item name or number in the CSV file. If there are extra special characters in the CSV file, then those need to be removed and saved. Import the CSV file again, and then see if orders are getting imported or not.

4). Check if the date format is correct in the CSV file:

The date format needs to be in MM/DD/YYYY format. If the date format is incorrect in the CSV file, then the user will also get an error message while importing the orders into Webgility through CSV.

5). Check the currency sign in the amount field in CSV:

Remove the currency sign from the amount field as shown in the above screenshot, and then save the CSV file. Import the CSV again to import the order.

After performing the above troubleshooting steps, if there is still an error while importing the orders in Webgility, please contact our Webgility Support Team for help.