Comment on page
CSV Inventory Mapping
How to map Amazon inventory to QuickBooks inventory with CSV files
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 do not keep inventory in stock (e.g. use dropshipping), map Amazon SKUs to QuickBooks Online Non-inventory Products / QuickBooks Desktop Non-inventory Parts.
Import Statementto go to Amazon Statements page
Import(next to the corresponding statement) to start mapping verification
Entriwise Amazon Statements page
Amazon SKUis equal to
QuickBooks Item Name, Entriwise will map them automatically
- 1.go to
Download CSVto save file with product mapping on the computer
- 1.open saved CSV file with product mapping
- 2.enter corresponding
QuickBooks Item Name
- 3.save changes and close the file
To verify mapping, upload updated CSV file to Entriwise
- go to
CSV Mappingpage and click
- Choose CSV file, click
Opento upload the file and verify mapping
When mapping is complete, your mapping page will have no unmapped items listed. Now you can proceed with the import.
Entriwise Mapping page