Import in bulk using Excel
If you have a large number of products to upload, you can use the CSV or Excel import option to add them all at once. This method is efficient and recommended for bulk uploads.
Steps to Import Products in Bulk
1. Access the Import Tool
- Navigate to the Products section from the left-hand menu.
- Click on the three-dot menu located at the top-right corner beside the “Add Manually” button.
- Select “Import” from the dropdown menu.
2. Upload Your Product File
- You'll now see an interface that allows you to import products.
- Under the File Upload section:
- Click “Choose File” and select your product file in the correct format.
- Once the file is selected, click on “Import File” to upload and begin processing.
3. Use Advanced Options (Optional)
Before importing, you can configure the following advanced settings:
Option | Description |
Update products or variants using SKU | Ensures that existing product records are updated if a matching SKU is found. |
Do not create new categories | Prevents creation of new categories if they are not already defined in your system. |
Do not associate parent categories to products automatically | Stops automatic assignment of parent categories when a subcategory is used. |
Tick the checkboxes as needed based on your product setup.
4. Download and Edit the Sample File
To make sure your file is formatted correctly:
- Under the Template Format section, choose your preferred format: CSV or Excel.
- Click “Download Sample CSV File” and then click on the download icon.
- Open the downloaded file and use it as a reference to fill in your product details correctly.
Once you’ve prepared your product sheet and uploaded it:
- The system will validate and import the data.
Errors, if any, will be shown with details so you can correct and re-upload.