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.
- At the top-right corner click on “Import” button.
- Select “Import Products” 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
- Under the Template Format section, choose your preferred format: CSV or Excel.
- Click Download Sample CSV File. You’ll see multiple pre-built templates for different categories (e.g., Books, Home & Decor, Beauty & Personal Care, Electronics, Fashion, Grocery).
- Select and download the template relevant to your products.
- Open the downloaded file and fill in the product details as per your requirements:
- Single Products: Fill in the basic product fields like title, description, price, and stock.
- Images: Add image URLs for your products. You can:
- Host your images on your server or Mystore files.
- Use open-source links or public image hosting platforms (e.g., Google Drive with shareable links, Dropbox, Imgur, etc.).
- Options & Variants: Define product options like size or color by filling in the option name and variant values.
- Tiered Pricing: If you want to set tiered pricing, add multiple pricing levels for different purchase quantities.
5. Import and Validate
- Once your product sheet is prepared, upload it.
- The system will validate the data before importing.
- If errors are found, details will be shown so you can correct them and re-upload.
Was this page helpful?