Manual Item Mapping

Last updated 3 months ago

How to manually map Amazon SKUs and services in Entriwise

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.

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. select Import Statement to go to Amazon Statements page

  2. select 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. select Edit (red pen) on the right side and enter an existing QuickBooks Item Name

  2. select 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, select Verify Mapping.

Entriwise Mapping page

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