QuickBooks POS and Shopify POS glossary and data mapping

Note

Information on this page is applicable only to QuickBooks Desktop POS merchants that are migrating to Shopify. Learn more about QuickBooks Desktop POS migration.

When you migrate your QuickBooks Desktop POS or integrate your QuickBooks Desktop accounting software with Shopify POS, your data is mapped to Shopify. You can use the following tables to better understand how your QuickBooks data is mapped to Shopify.

This page overviews how QuickBooks Desktop POS and accounting software data is mapped in Shopify. Some data types, such as orders, product images, or purchase orders, aren't migrated to Shopify. Learn more which data can be migrated using the QuickBooks Desktop Connector app and which data you might have to migrate manually.

QuickBooks POS and Shopify POS glossary

Review the following table that maps QuickBooks POS terminology with Shopify POS and Stocky terminology.

QuickBooks POS and Shopify POS terminology mapping

QuickBooks POS	Shopify and Stocky
Sales Receipts	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 Point of Sale)	Purchase Orders (Items Received)
Bill / Item Receipt (QuickBooks Desktop)	Purchase Orders (Items Received)
Inventory	Product
Inventory Style Grid	Product Variants/Options
Transfer Slips	Product Transfers
Customers	Customers
Vendor	Supplier
Vendor	Vendor
Stores (QuickBooks Desktop Point of Sale)	Locations
Classes (QuickBooks Desktop)	Locations
Intuit QuickBooks Payments	Shopify Payments
Automatic Discounts	Discounts
Charge Volume	GMV

QuickBooks POS migration data mapping

Learn about how your QuickBooks POS data is mapped in Shopify.

You can view how your data is mapped for the following areas:

• customers
• items and products
• vendors

Customers

Customers data mapping

QuickBooks POS	Shopify
First Name	First Name
Last Name	Last Name
Billing Address 1	Customer Address (address1)
Billing Address 2	Customer Address (address2)
Billing Address City	Customer Address (City)
Billing Address State	Customer Address (state)
Billing Address Postal Code	Customer Address (Zip)
Phone	Phone
Email	Email

Items and products

Items and products data mapping

QuickBooks POS (items)	Shopify (products)
Item Number	Barcode
Item Name	Title + Attribute + Size
Item Description	Description
Attribute	Title + Attribute + Size
Size	Title + Attribute + Size
Average Unit Cost	Cost
Regular Price	Price
Vendor Name	Vendor
Weight	Weight
Qty #	Inventory Level (per location)

Vendors

Vendors data mapping

QuickBooks POS	Stocky
Company	Supplier Company Name
First Name	Supplier Contact Name
Last Name	Supplier Contact Name
Street	Supplier Address 1
City	Supplier City
Street 2	Supplier Address 1
Zip	Zip/Postcode
Phone	Phone
Email	Email

QuickBooks Desktop integration data mapping

Learn about how your QuickBooks Desktop accounting software data is mapped in Shopify.

You can view how your data is mapped for the following areas:

• customers
• orders
• purchase orders and receiving vouchers
• adjustment memos
• vendors

Caution

QuickBooks Desktop POS orders and purchase orders data aren't migrated to Shopify. For more information refer to QuickBooks Desktop POS data migration considerations

Customers

Customers data mapping

Shopify	QuickBooks Desktop
First Name	First Name
Last Name	Last Name
Customer Address (Address1)	Billing Address 1
Customer Address (Address2)	Billing Address 2
Customer Address (City)	Billing Address City
Customer Address (State)	Billing Address State
Customer Address (Zip)	Billing Address Postal Code
Phone	Phone
Email	Email

Orders

Orders data mapping

Shopify	QuickBooks POS
Orders (Paid/Fulfilled)	Sales Receipts
Orders (Unpaid/Fulfilled)	Invoice
Orders (Partially Paid/Fulfilled)	Invoice with Payment
Orders (Unpaid/Unfulfilled)	Sales Order
Orders (Partially Paid/Unfulfilled)	Sales Order with Deposit
Order Discounts	Automatic Discounts

Purchase orders and receiving vouchers

Purchase orders and receiving vouchers data mapping

Stocky	QuickBooks Desktop
Purchase Orders (Items Received)	Bill
Vendor/Supplier	Vendors
PO Number	Reference Number
Purchase Items	Item Reference Full Name
Retail Price	Item Line Amount
Cost Price	Item Line Cost
Purchase Order ID	Transaction Number

Adjustment memos

Adjustment memos data mapping

Stocky	QuickBooks Desktop
Stock Adjustment ID	Transaction Number
Stock Adjustment Status	Is Adjustment
Adjusted at Date	Transaction Date
Adjusted at Time	Time Created
Stock Adjustment Product Cost (Sum)	Journal Debit Amount
Product Price (Sum)	Journal Credit Amount

Vendors

Vendors data mapping

Stocky	QuickBooks Desktop
Supplier Company Name	Company
Supplier Contact Name	First Name
Supplier Contact Name	Last Name
Supplier Address 1	Street
Supplier City	City
Supplier Address 1	Street 2
Zip / Postcode	Zip
Phone	Phone
Email	Email