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