QuickBooks Desktop POS data migration considerations

Before you migrate your QuickBooks POS data to Shopify, make sure to review which data can be migrated using the QuickBooks Desktop Connector app and which data you might have to migrate manually. For a full list of data mapping terms, refer to QuickBooks POS and Shopify POS glossary and data mapping.

QuickBooks data migration scope

Review the following table to learn more which QuickBooks Desktop POS data can and can't be migrated to Shopify using the QuickBooks Desktop Connector app:

QuickBooks data migration table
QuickBooks data type Shopify data type Data can be migrated
Customer Customer
Inventory Products
Inventory style grid Product variants or options
Product images Product images
Transfer slips Product transfers
Vendors Vendor or supplier
Stores (POS) or Classes (QuickBooks Desktop) Locations
Item number Barcodes
UPCs (if not using item numbers) Barcodes
Sales receipt Orders (paid/fulfilled)
Invoice Orders (unpaid/fulfilled)
Invoice with payment Orders (partially paid/fulfilled)
Sales order Orders (unpaid/unfulfilled)
Sales order with deposit Orders (partially paid/unfulfilled)
Purchase order Purchase orders (items not received)
Receiving voucher (QuickBooks Desktop POS) Purchase orders (items Received)
Bill or Item Receipt (QuickBooks Desktop) Purchase orders (items received)
Automatic discounts Discounts
Alternative lookup (ALU) SKU numbers
Store credits Giftcards
Loyalty Loyalty

QuickBooks data that can be migrated using the connector app

The following data can be migrated from QuickBooks POS to Shopify using the QuickBooks Desktop Connector app:

  • customer data
    • names
    • emails
    • phone numbers
  • vendor data (migrates over as Suppliers in the Stocky app)
  • location data (maximum 20 locations)
  • inventory and product data
    • product title
    • barcodes (item number)
    • quantity
    • location
    • price

Products and product variants

After you migrate, your product variants are imported as individual products to Shopify. The migration doesn't overwrite any existing products in Shopify. Your migrated products are imported with a Quickbooks tag and with a Draft status. You can do the following:

Data migration item limit

You can migrate up to 50,000 items per day. For example, if you have 150,000 items, then it will take around three days to migrate your data from QuickBooks POS to Shopify. This item limit applies across all import files, such as products, customers, and inventory.

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.

QuickBooks data that can't be migrated using the connector app

The following data can't be migrated from QuickBooks POS to Shopify using the QuickBooks Desktop Connector app, but you can look for alternative methods to import your data:

Product images

Product images aren't migrated from QuickBooks POS to Shopify. However, you can manually export your inventory pictures in bulk from QuickBooks POS. After you export your images, you can import these images to Shopify using one of the following methods:

  • make the images publicly available online using a tool, such as Dropbox or Google Photos, export your product list from Shopify, add appropriate image URLs for each item, and then reupload the images by using a CSV file
  • use a third-party app, such as ifyApps Image Manager to import your images
  • hire a Shopify expert to export and import product images for you

Alternative Lookup (ALUs)

Alternative Lookup (ALUs), also known as product SKU numbers in Shopify, aren't migrated from QuickBooks POS to Shopify. After you complete the initial data migration, you can import ALUs from QuickBooks POS to Shopify manually in SKU (Stock Keeping Unit) field.

Transfer slips

Transfers slips aren't migrated from QuickBooks POS to Shopify. You can import transfer slips manually as Product transfers in Shopify.

UPCs

Item numbers are migrated as barcodes in Shopify. However, UPC barcodes aren't migrated from QuickBooks POS to Shopify, because Shopify POS can scan only one barcode field per product. After you finish your initial migration, you can use of the following methods to manually migrate your UPC barcodes:

  • manually import UPC barcodes by overwriting the item id that is added in the Barcode field in Shopify
  • add new barcodes to the items in the store that use UPCs

Orders, purchase orders, and discounts

Order history, such as orders, purchase orders, discounts, and customer order history, aren't migrated from QuickBooks POS to Shopify. After you migrate to Shopify, your new purchase orders are created in the Stocky app and synced with the QuickBooks Desktop accounting software.

Existing store credit

Store credit isn't migrated from QuickBooks POS to Shopify. You can use third-party apps, such as Selling Point to migrate your store credit as gift cards to Shopify.

If you choose to use the Selling Point app, then you need to set up your gift card report for export, import your report to the Selling Point app, and then reissue these gift cards to each customer to use in the store.

Customer loyalty information

Customer loyalty information isn't migrated from QuickBooks POS to Shopify. You can use a third-party app, such as Growave, Smile, Yotpo, or Loyalty Lion, to migrate your customer loyalty information to Shopify.

Ready to start selling with Shopify?

Try it free