Import Products to QB


You can import items from Excel to QB.

Excel Import

In QB, click lists on the top menu. Click item list. On the bottom, click excel > import items.

Field Mappings

For SKU Vault, here are the mappings:

SKU Vault Field Name QB Field Name
SKU Item Name
On Hand Qty On Hand

For the COGS account in QB, choose Cost of Goods Sold. For the inventory asset account, choose inventory asset. You can choose sales as a generic income account.

Have more questions? Submit a request
Powered by Zendesk