What is the "Auto Mapping" feature, and how can I use it?

How to use the Auto Mapping feature for data that already exists in both WooCommerce and QuickBooks

Written by the MyWorks Team

Updated at June 30th, 2023

Table of Contents

After installing our WooCommerce Sync for QuickBooks Online, one of the final configuration steps is mapping, or linking - existing WooCommerce data to corresponding QuickBooks Online data. Read more about mapping here.

The mapping process is very simple and only needs to be completed once. However, for stores with hundreds - or even thousands of customers or products, this can be a lengthy and sometimes impossible task to accomplish manually.

This is where our automap features are helpful.

Customers

For WooCommerce stores with hundreds or thousands of customers, it can be difficult to map all your existing customers one by one manually. To help automate the mapping process, you're able to AutoMap by customer name or customer email. As long as your WooCommerce and QuickBooks Online customers have a matching email or name, this function will automatically map them.

To use this, simply scroll to the bottom of the Map > Customers page and click on AutoMap by name or AutoMap by email.

Products

For WooCommerce stores with hundreds or thousands of products, it can be difficult to map all your existing products one by one manually. To help automate the mapping process, you're able to AutoMap by product SKU. As long as your products in both WooCommerce and QuickBooks Online have a matching SKU, this function will automatically map them.

To automatically map your products by SKU, scroll to the bottom of the Map > Products page and click on AutoMap by SKU.