1. Home
  2. Docs
  3. WGits for Quickbooks
  4. How Do I Map my SKUs with Quickbooks?

How Do I Map my SKUs with Quickbooks?

  • User Guide Search

In our WGits software, you are able to use your existing SKUs in your current ecommerce platform to map to different Item names in Quickbooks. That way if the two sets of identifiers are different and you don’t want to change them or can’t change them, you can map them with this importer.

One by One

You can also add these unique SKUs to be mapped one at a time by filling in the “Source SKU” field and the “QB SKU” field with the corresponding Item Name in Quickbooks representing the QB SKU. Then press the purple plus button.

Screenshot of the SKU Mapper tool

Batch Import SKUs

First all you need to do is open excel, in column A, fill in the DTC Platform SKUs that you have in your current system. In column B, fill in the Quickbooks item names.

Note: Don’t use headers or any other data other than the SKUs and item names.

Go to the Setup tab > then click on the SKU Map tab > click on the Import Map button.

In Excel make sure you follow this kind of format, simply add the ecommerce system SKUs in column A and the corresponding or matching item name in Quickbooks.

Note: You can assign multiple ecommerce platform SKUS (Column A) to a single Quickbooks item name (Column B). You cannot assign a single ecommerce platform SKU to multiple Quickbooks items. The importer does not allow you to have the same SKU listed in Column A more than once.

Excel screenshot showing how to import SKUs

Note: You must save your file as a .csv format.

Once your file is ready press the “Import Map” button and find your excel file on your computer in the .csv format. Once you select that file, the SKUs will map themselves into place and will be visible on the main screen.

You can then remove the SKUs mapped if needed one at a time. There is no batch deletion or batch removal at this time.

Was this article helpful to you? Yes No

How can we help?