You can import items from Excel to QB.
In QB, click lists on the top menu. Click item list. On the bottom, click excel > import items.
For SKU Vault, here are the mappings:
|SKU Vault Field Name||QB Field 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.