Mapping Shopify Collections to QuickBooks Products or Classes

Explore how to effectively map your Shopify collections to QuickBooks products or classes, streamlining your order management and accounting processes.

Written by the MyWorks Team

Updated at March 5th, 2024

The mapping section of MyWorks Sync allows you to 'match' your Shopify collections, products or variations in Shopify to corresponding products in QuickBooks Desktop. This article focuses on the ability to map your Collections in Shopify to QuickBooks products, classes, and/or locations.  

Mapping your Shopify Collections can be helpful in several different scenarios:

  • You don't need each individual Shopify product in QuickBooks,
  • You only need to track sales separately in QuickBooks by your Shopify Collections
  • You use Classes in QuickBooks to handle reporting for different Shopify Collections  

When a Collection is mapped to a Shopify product or class, MyWorks will honor that mapping as we sync Shopify orders to QuickBooks: controlling the QuickBooks item or class used for the line items and order detail for the order in QuickBooks.  

It's not required to map your Shopify Collections, so they can be left blank by default. For example, if you don't want all your Shopify products in QuickBooks, that's quite alright, and you can either leave them unmapped, or map multiple Shopify products to a single QuickBooks product.

Mapping your Shopify Collections

Mapping your Shopify Collections to QuickBooks Desktop is as easy as “connecting the dots”! Visit the Collections tab in MyWorks Sync > Map in your Shopify admin area.

On the left side, you can see your Shopify Collections - and in the columns on the right; a list of your QuickBooks Online products and classes. Each column is optional, and you can leave them blank as desired. 

Note: If a product or variation is mapped to a QuickBooks product in Map > Products, or Map > Variations, that mapping will override any mapping for the Collection that product is in. 

Once a Collection is mapped, it will always remain mapped unless it's deleted in Shopify.