QuickBooks POS and Shopify POS glossary and data mapping

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 Desktop POSShopify and Stocky
Sales ReceiptsOrders (Paid/Fulfilled)
InvoiceOrders (Unpaid/Fulfilled)
Invoice with PaymentOrders (Partially Paid/Fulfilled)
Sales OrderOrders (Unpaid/Unfulfilled)
Sales Order with DepositOrders (Partially Paid/Unfulfilled)
Purchase OrderPurchase Orders (Items Not Received)
Receiving Voucher (QuickBooks Desktop POS)Purchase Orders (Items Received)
Bill / Item Receipt (QuickBooks Desktop)Purchase Orders (Items Received)
InventoryProduct
Inventory Style GridProduct variants or options
Transfer SlipsProduct Transfers
CustomersCustomers
VendorSupplier
VendorVendor
Stores (QuickBooks Desktop POS)Locations
Classes (QuickBooks Desktop accounting software)Locations
Intuit QuickBooks PaymentsShopify Payments
Automatic DiscountsDiscounts
Charge VolumeGMV
Customer noteCustomer note

QuickBooks Desktop 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 POSShopify
First NameFirst Name
Last NameLast Name
Billing Address 1Customer Address (address1)
Billing Address 2Customer Address (address2)
Billing Address CityCustomer Address (City)
Billing Address StateCustomer Address (state)
Billing Address Postal CodeCustomer Address (Zip)
PhonePhone
EmailEmail

Items and products

Items and products data mapping
QuickBooks Desktop POS (items)Shopify (products)
Item Number or UPCBarcode
Item NameTitle + Attribute + Size
Item DescriptionDescription
AttributeTitle + Attribute + Size
SizeTitle + Attribute + Size
Average Unit CostCost
Regular PricePrice
Vendor NameVendor
WeightWeight
Qty #Inventory Level (per location)

Vendors

Vendors data mapping
QuickBooks Desktop POSStocky
CompanySupplier Company Name
First NameSupplier Contact Name
Last NameSupplier Contact Name
StreetSupplier Address 1
CitySupplier City
Street 2Supplier Address 1
ZipZip/Postcode
PhonePhone
EmailEmail

QuickBooks Desktop accounting software 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:

  • orders (all orders are synced from Shopify to QuickBooks desktop accounting software)
  • purchase orders and receiving vouchers
  • customers
  • adjustment memos
  • vendors
  • companies

Orders

Orders data mapping
ShopifyQuickBooks Desktop accounting software
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 DiscountsAutomatic Discounts

Purchase orders and receiving vouchers

Purchase orders and receiving vouchers data mapping
StockyQuickBooks Desktop accounting software
Purchase Orders (Items Received)Bill
Vendor/SupplierVendors
PO NumberReference Number
Purchase ItemsItem Reference Full Name
Retail PriceItem Line Amount
Cost PriceItem Line Cost
Purchase Order IDTransaction Number

Customers

Customers data mapping
ShopifyQuickBooks Desktop accounting software
First NameFirst Name
Last NameLast 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
PhonePhone
EmailEmail

Adjustment memos

Adjustment memos data mapping
StockyQuickBooks Desktop accounting software
Stock Adjustment IDTransaction Number
Stock Adjustment StatusIs Adjustment
Adjusted at DateTransaction Date
Adjusted at TimeTime Created
Stock Adjustment Product Cost (Sum)Journal Debit Amount
Product Price (Sum)Journal Credit Amount

Vendors

Vendors data mapping
StockyQuickBooks Desktop accounting software
Supplier Company NameCompany
Supplier Contact NameFirst Name
Supplier Contact NameLast Name
Supplier Address 1Street
Supplier CityCity
Supplier Address 1Street 2
Zip / PostcodeZip
PhonePhone
EmailEmail

Companies

Draft orders and draft payment terms have bidirectional sync capability. Changes made in QuickBooks Desktop accounting software are synced back to Shopify.

Companies data mapping
ShopifyQuickBooks Desktop accounting software
CompanyCustomer
Company LocationClass
Draft Payment TermInvoice Payment Term
Draft OrdersInvoices
Can’t find the answers you’re looking for? We’re here to help.