QuickBooks POS and Shopify POS glossary and data mapping

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

QuickBooks POS and Shopify POS terminology mapping

QuickBooks Desktop 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 POS)	Purchase Orders (Items Received)
Bill / Item Receipt (QuickBooks Desktop)	Purchase Orders (Items Received)
Inventory	Product
Inventory Style Grid	Product variants or options
Transfer Slips	Product Transfers
Customers	Customers
Vendor	Supplier
Vendor	Vendor
Stores (QuickBooks Desktop POS)	Locations
Classes (QuickBooks Desktop accounting software)	Locations
Intuit QuickBooks Payments	Shopify Payments
Automatic Discounts	Discounts
Charge Volume	GMV
Customer note	Customer note

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 Desktop POS (items)	Shopify (products)
Item Number or UPC	Barcodes
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 Desktop 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

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

Shopify	QuickBooks 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 Discounts	Automatic Discounts

Purchase orders and receiving vouchers

Purchase orders and receiving vouchers data mapping

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

Customers

Customers data mapping

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

Adjustment memos

Adjustment memos data mapping

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

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

Shopify	QuickBooks Desktop accounting software
Company	Customer
Company Location	Class
Draft Payment Term	Invoice Payment Term
Draft Orders	Invoices