Error While Insert Orders, There Was an Issue While Saving Your Orders. - Order Import
This article addresses the “Error While Insert Orders: There Was an Issue While Saving Your Orders” message that can occur when importing orders into Webgility Desktop via CSV files. The error typically arises due to issues such as incorrectly mapped fields, data mismatches, extra commas, special characters, incorrect date formats, or currency symbols in the CSV file. The article guides users through the necessary checks and corrections to ensure successful CSV order imports.
Reason:
There could be numerous reasons why orders are not imported via CSV file into Webgility Desktop. S uch as incorrectly mapped fields, data mismatches, and special characters in the data.
Steps to Troubleshoot Missing Orders when Imported via CSV File
1). Verify the field mapping settings you selected for the CSV import.
The user must verify the field mapping to check if the fields in the CSV file are correctly mapped in Webgility Desktop. If not mapped correctly, they need to map it accordingly.

2). Look for any extra commas in the rows.
Identify the row with the extra comma and remove it. Note that additional commas are commonly found in name and address fields. Save the CSV file and re-import it.

3). Check for special characters in the CSV file.
Special characters are typically found in the item name or number within the CSV file. If there are any additional special characters in the CSV file, they should be removed and the file saved. After removing the special characters, import the CSV file again and verify if the orders are being imported successfully.
4). Ensure the date format is correct in the CSV file.
The date format must be MM/DD/YYYY. Incorrect date format in CSV will result in an error message when importing orders into Webgility Desktop.
5). Double-check the currency sign in the amount field in the CSV.
Remove the currency sign from the amount field, as shown in the screenshot above, and save the CSV file. Afterward, import the CSV file again to import the order.



