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 theQuickBooks Desktop Connectorapp and which data you might have to migrate manually. For a full list of data mapping terms, refer toQuickBooks POS and Shopify POS glossary and data mapping.
On this page
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 theQuickBooks Desktop Connectorapp:
| 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 or UPC | Barcodes | ✔ |
| Customer note | Customer note | ✔ |
| Sales receipt | 订单(支付/完成) | ✘ |
| 发票 | Orders (unpaid/fulfilled) | ✘ |
| 发票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) | ✘ |
| 比尔或物品的收据(QuickBooks桌面) | 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 theQuickBooks Desktop Connectorapp:
- customer data
- names
- 电子邮件
- phone numbers
- vendor data (migrates over asSuppliersin 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 aQuickbookstag and with aDraftstatus. You can do the following:
- Filter and sort your imported products using theQuickbookstag.
- Review the product information and make any necessary changes before making your products available for sale. You can change theproduct status fromDrafttoActivefor individual products or in bulk using thebulk editor.
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.
Item numbers and UPCs
QuickBooks allows for multiple scannable barcodes for a single product, but Shopify allows only one barcode per product in theBarcodesfield in Shopify. During migration, you can choose product number to import as a barcode. You need to choose fromItem NumberorUPC, but you can't select both.
In Shopify, you can also attach a SKU number to an inventory product that's is searchable, but not scannable. You canedit SKUs in bulk using a CSV fileafter migration.
If you require saving multiple product numbers in your inventory, then you can use metafields after migration. Learn more about米etafields.
Learn aboutusing barcodes and SKUs in the POS.
QuickBooks data that can't be migrated using the connector app
The following data can't be migrated from QuickBooks POS to Shopify using theQuickBooks Desktop Connectorapp, 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米anually 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:
- 米ake 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 byusing a CSV file
- use a third-party app, such asifyApps形象法力gerto import your images
- hire a Shopify expertto 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 theSKU (Stock Keeping Unit)field.
Transfer slips
Transfers slips aren't migrated from QuickBooks POS to Shopify. You can import transfer slips manually asProduct transfersin Shopify.
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 asSelling Pointto migrate your store credit as gift cards to Shopify.
If you choose to use the Selling Point app, then you need toset 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 asGrowave,Smile,Yotpo, orLoyalty Lion, to migrate your customer loyalty information to Shopify.