Manual Item Mapping

Last updated 2 months ago

To import Amazon Seller Central transactions into QuickBooks, it is necessary to configure Amazon to QuickBooks item mapping.

If keep inventory in stock and need to track its quantity on hand, current inventory value and average cost, map Amazon SKUs to QuickBooks Online Inventory Products / QuickBooks Desktop Inventory Parts.

Note: if you use QuickBooks Online, you may want to view QuickBooks Online Inventory Tutorial

If you do not keep inventory in stock (e.g. use dropshipping), map Amazon SKUs to QuickBooks Online Non-inventory Products / QuickBooks Desktop Non-inventory Parts.

1. Initiate Mapping Verification

  1. click Import Statement to go to Amazon Statements page

  2. click Import (next to the corresponding statement) to start mapping verification

Entriwise Amazon Statements page

2. Edit Item Mapping

Note: if Amazon SKU is equal to QuickBooks Item Name, Entriwise will map them automatically

Enter corresponding QuickBooks Item Name:

  1. click Edit (red pen) on the right side and enter existing QuickBooks Item Name

  2. click Confirm (orange check mark) to save new QuickBooks Item Name

  3. repeat for all unmapped items

Entriwise Mapping page

3. Verify Mapping

To verify updated mapping, click Verify Mapping.

Entriwise Mapping page

Completed Mapping

When mapping is complete, your mapping page will have no unmapped items listed. Now you can proceed with the import.

Entriwise Mapping page