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 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

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

Ready to start selling with Shopify?

Try it free