Create new or update existing products in bulk using a predefined Excel or CSV template from the Products page.
You can download the template or existing products in an Excel or CSV file to add or update product details in bulk. Upon uploading the file, the application validates the data and identifies the missing, invalid, or mismatched values. This ensures data accuracy and consistency across the application.
To create or update products using Excel:
- Go to Products page and select the checkboxes corresponding to products.
- Click Download > Download in Excel.
- Entities – Enter all the attribute details for each product in a row-wise.
- In the asset attributes column, enter the asset file name (originalFilename) for asset attributes, for example, product-image.jpg. The asset must exist in the Digital Assets library and match the attribute's supported file type.
- Relationships – Add or update product relationships, such as assets, related products, and variants.
- Entities – Enter all the attribute details for each product in a row-wise.
In the same file, you can also add more rows to create new products.
-
Navigate to the Products page and click Upload.
-
In the Upload dialog, click to browse and select, or drag and drop the file from your system.
-
Click Done once the upload process is completed. The Products page auto-refreshes to display the latest details.
You can also perform the upload from Quick Actions. For more information, see How to upload products