Importing and Updating Products
Product import uses a Comma Separated Values (CSV) file to import products, main image files and custom extension data. The structure of this file is defined in the APIs docs.
You can use product import to:
- update existing products, including images, templates/flow fields and entries. The entry in the
.csv
file must have a uniqueid
and/orexternal_ref
that matches theid
andexternal_ref
of the existing product you want to update. You may have both a uniqueid
andexternal_ref
, but you must have at least one. - Add new products, including new images, templates/flow fields and entries. For new products that you want to add, the entry in the
.csv
file must have anexternal_ref
that does not match any existing products.
You cannot use product import to:
- Delete existing products.
- Import product bundles.
Each row in a .csv
file represents a product you want to create/update. Each file can have 50,000 rows, including the header. If a CSV file exceeds 50,000 rows, an error is displayed, and the products are not imported.
A .csv
file must not be larger than 50 megabytes. If a .csv
file is larger than 50 megabytes, a 503 client read error
is displayed.
If you want to create/update more than 50,000 products or your .csv
file is larger than 50 megabytes, you must have a separate .csv
file and import each .csv
file one at a time.
To import products:
- Go to Product Experience Manager > Products.
- Click Product Imports tab.
- In Import File, click Choose File.
- Browse to the location of your Comma Separated Values (CSV) file.
- Select your CSV file and click Open. A notification indicating whether the operation is successful is displayed. The imported product information is displayed in the All Products tab.