Import Products to QB

Introduction

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