Troubleshooting QuickBooks Desktop POS migration errors and common issues
If you encounter an error during the upload of QuickBooks data files to Shopify, then review the error message that you receive and refer to the following troubleshooting resources.
On this page
Troubleshooting data file upload errors
When you upload QuickBooks data files to Shopify, you might receive error notifications that provide guidance on how to resolve the issue.
Unable to upload file due to pre-requisites not being met
If you receive the Unable to upload file due to pre-requisites not being met error, then ensure that the following pre-requisites are met:
- Confirm that you meet the migration requirements
- Make sure that you're uploading files with the correct file extension: .xlsx or .xls
If you're unable to resolve this error, then contact Shopify Retail Support.
Unable to upload file due to missing headers
If you receive the Unable to upload file due to missing headers error, then check whether your data file has the following columns:
- Inventory data file: Item Number, Item Name, Item Description, Attribute, Size, Average Unit Cost, Regular Price. Vendor Name, Qty 1, QB ListID.
- Customer data file: Company, Last Name, First Name, Street, Street2, State, ZIP, Phone 1, EMail, QB ListID, City.
- Vendor data file: Company, Last Name, First Name, Street, Street2, City, State, ZIP, Phone 1, EMail, QB ListID.
If the indicated columns exist in your upload file, then contact Shopify Retail Support.
If the indicated columns don't exist in your upload file, then contact Intuit Support.
Troubleshooting line item errors
After you start the data migration, you might encounter the Line item error notification. This means that there's an issue in a few data entries that you need to fix. An exception file is generated that you can download to fix or delete your data values, and then reupload your data file.
Review the following table to learn more about the common line item errors and how to solve them:
| Error code | Solution |
|---|---|
| Phone/Email has already been taken | Correct or delete the customer's phone number or email. |
| Phone/email is invalid | Correct or delete the customer's phone number or email. |
| The quantity couldn't be set because the location was deleted | Ensure that the location is set up properly in your Shopify admin. If the location exists, then create a new location and set the line to this new location. Reupload the exception file into the Inventory section again. |
| Cost per item must be greater than or equal to 0 | Update your cost per item line with a value that's greater or equal to 0. |
| Title can't be blank | Add the product title. |
| Reason not found while pushing data | Contact Shopify Retail Support. |
| Unknown Error, please contact support | Contact Shopify Retail Support. |
| Customer does not exist | Contact Shopify Retail Support. |
Troubleshoot line item errors
To troubleshoot the line item errors, you need to download the exception file that's indicated in the notification, and then correct the data, save and upload the exception file to the QuickBooks Desktop Connector app.
For example, if you receive the phone or email already taken or the phone is invalid notification and you don't have an updated phone or email to provide, then you can decide to delete the phone number or email and save it. To import a customer into Shopify, only the customer name is required.
You can also skip the data files with errors, but this data won't be imported into Shopify.
Steps:
- In the Line item error notification, depending on the file that has errors click Download Inventory error file, Download Customers error file, or Download Vendors error file.
- Open the error file, review the Failed reason column, and correct the errors.
- Go to the QuickBooks Desktop Connector app, click Add data file in the corresponding section, such as Inventory, Customers, or Vendors, to reupload the data file.
- Optional: If you want to skip the file with the missing data, then click Skip this file > Yes, continue migration. The data that you skip isn't imported to Shopify.
Troubleshooting common issues
Review the following QuickBooks Desktop POS migration and integration commons issues and how to troubleshoot them:
Can't export QuickBooks data files for migration
Review this guide on how to export QuickBooks data files. If you need further assistance, then contact Intuit Support.
Can't find Stocky API key
You can get your Stocky API key from the Stocky app in your Shopify admin. For more information, refer to get your Stocky API key
Stocky API key is incorrect
Try generating a new API Key in the Stocky app, and then try again with the new key.
Integrated before migrating
If you integrated your QuickBooks Desktop accounting software with Shopify before you migrated your QuickBooks Desktop POS data to Shopify, then you need to reset the process and complete the migration first. Contact Shopify Retail Support for help.
Unable to update to QuickBooks Desktop POS version 19
Depending on what version of QuickBooks Desktop POS you're using, your update path to QuickBooks Desktop POS version 19 can be different. For more information, refer to updating your QuickBooks Desktop POS to version 19
Can't integrate QuickBooks Online with Shopify
If you're using QuickBooks Online instead of QuickBooks Desktop accounting software, then you can migrate your QuickBooks data, but you can't integrate using the QuickBooks Desktop Connector app. To integrate and sync your Shopify POS data to QuickBooks Online, you can use the third-party QuickBooks Online app by Intuit.
Products have imported with incorrect or zero quantity
Check the Adjustment History section of your product in QuickBooks Desktop POS. If your product was edited twice by the app, then your QuickBooks Desktop POS locations might have been mapped to a single Shopify location. Contact Shopify Retail Support for help.
QuickBooks data files upload is taking too long
The migration can take from an hour to five hours to complete. The length of the migration depends on many factors, such as your QuickBooks POS setup, the amount of data you're migrating, or the number of your locations. The current average migration length is approximately 5.5 hours. The QuickBooks Desktop Connector App can migrate up to 50,000 line items per day. If the migration is taking longer than 5.5 hours, then contact Shopify Retail Support for help.