Product import details

Use File import to create product items or update existing products from a CSV file. The product template identifies purchasing, sales, inventory, pricing, tax, account, and other supported fields, and the current generated template remains the source of truth for additional requirements introduced by account configuration.

Before you begin

You need permission to create or update product items.
Open Menu > Administration > Data import > File import, select Import, and select Product Item and the required operation. Download a new template for that selection.
Keep the generated headers unchanged. Required columns are marked in the downloaded template.

Supported operations

Create new records creates a product for each valid row.
Update existing records updates a product identified by an internal ID or external ID.
Create new or update existing records updates a referenced product and creates a product when no matching reference is supplied.

Required product data

Complete the required template fields, including:

Primary Column, using a sequential number for each product.
Item Name/Number, using the product identifier shown on transactions.
Display Name/Code, using the product name shown to users.
Purchasable or Sellable. Enter TRUE for at least one of these fields. Enter FALSE when the corresponding use does not apply.

The current template is the source of truth for additional required fields introduced by your account configuration.

Update existing products

Use one of these references to identify each existing product:

Internal ID: Open the Items list, select Actions > Download view, and use the Internal ID value from the downloaded file. Add the matching internal-ID column from the update template to your CSV file.
External ID: Use External ID (set) when creating a product. In a later update file, use the matching External ID (lookup) column and value.

Do not change the values used to identify a product between creating and updating it.

Import the file

Upload the completed template and follow Import a file. After the job finishes, review its result file. Correct failed rows and import those rows again.