Entriwise Documentation
  • Entriwise Documentation
  • Getting Started
    • Connect Entriwise
    • Configure QuickBooks Desktop
      • Amazon Balance Account
      • Track Amazon Orders
      • Track Amazon Fees
      • Entriwise Connector
    • Configure QuickBooks Online
      • Amazon Balance Account
      • Track Amazon Orders
      • Track Amazon Fees
  • User Guide
    • Item Mapping
      • Manual Item Mapping
      • Inventory Tracking
      • CSV Inventory Mapping
    • Transaction Import
      • Amazon Orders
      • Amazon Refunds
      • Amazon Fees
      • Amazon Other
      • Amazon Ignored
  • FAQ
Powered by GitBook
On this page
  • Initiate Mapping Verification
  • Edit Item Mapping
  • Verify Mapping
  • Completed Mapping
  1. User Guide
  2. Item Mapping

Manual Item Mapping

How to manually map Amazon SKUs and services in Entriwise

PreviousItem MappingNextInventory Tracking

Last updated 4 years 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.

If you use QuickBooks Online, you may want to view

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.

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

Edit Item Mapping

Note: if Amazon inventory SKU is equal to QuickBooks inventoy item name, Entriwise will map them automatically

To edit item mapping:

  • select Edit (orange pen) on the right side of the mapping that you want to edit

  • enter an existing QuickBooks Item Name from the drop (hint: you can type to filter items)

    • QuickBooks inventory or non-inventory item for amazon-sku

    • QuickBooks service item for amazon-charge, amazon-fee, amazon-other, and amazon-promotion

  • select Confirm (orange check mark) to save new QuickBooks Item Name

  • repeat for all unmapped items

Verify Mapping

To verify updated mapping, select Verify Mapping.

Completed Mapping

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

go to page

Item Mapping
QuickBooks Online Inventory Tutorial
Entriwise Amazon Statements page
Edit mapping
Save mapping
Verify mapping