Unable to upload file as the following headers were missing : QB ListID.

Solved

Unable to upload file as the following headers were missing : QB ListID.

jessschnehageRG
Shopify Partner
8 1 0

Hello,

 

We are performing a test migration for our client on a separate Shopify instance before doing the actual migration on their Shopify store. 

 

Client has followed this documentation (https://help.shopify.com/en/manual/sell-in-person/quickbooks/migration#export-data) and has provided us with exported data files.  

 

When uploading within the Desktop Connector we are receiving the following error message:
Unable to upload file as the following headers were missing :
 QB ListID. Make sure you have updated QuickBooks POS and followed all the instructions for exporting the file. If this error persists, please contact support.


Client followed the following instructions as per documentation when exporting, but there seems to be data missing from the export that Shopify requires. 

Steps:

  1. From your desktop device, open the QuickBooks Desktop Point of Sale app.
  2. Click File > Utilities > Export.
  3. Select the data file that you want to export, and then click Next.
  4. Next to the Select destination file field, click Browse, and then select the file destination where you want to save your data file.
  5. In the Write records to (sheet) field, select Sheet1.
  6. Click Manage Templates. click Select all, and then click Save.
  7. Click Next, and then click Export.

Sharing in the hopes that anyone has encountered this before or has any ideas. Thank you!

Accepted Solutions (2)

jessschnehageRG
Shopify Partner
8 1 0

This is an accepted solution.

kgirrard
Tourist
6 1 2

This is an accepted solution.

There is a step missing from the instructions. There's an input that selects an export profile, which specifies which columns to include. I had to create new profiles for each of Customers, Inventory, and Vendors that contained All Fields, and then select that profile when performing the export.

View solution in original post

Replies 3 (3)

jessschnehageRG
Shopify Partner
8 1 0

This is an accepted solution.

kgirrard
Tourist
6 1 2

This is an accepted solution.

There is a step missing from the instructions. There's an input that selects an export profile, which specifies which columns to include. I had to create new profiles for each of Customers, Inventory, and Vendors that contained All Fields, and then select that profile when performing the export.

Danceman1
Excursionist
30 1 8
Just create a header on the first available blank column and name it QB LIST ID…it will accept it….someone screwed up because its not listed in any export.