Import in bulk using CSV
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 icon. 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.
- Attributes:Add product attributes as required based on the category or sub-category for which the Excel file was downloaded.
⚠️ Mandatory attributes must be filled in to ensure successful import.
How to fill the CSV/Excel file?
When uploading products using the CSV, you only need to focus on certain mandatory fields. Here’s what each of those fields means and how to fill them:
| Field Name | What It Means | How to Fill It |
|---|---|---|
| name | Product title | The name you want shown to customers (e.g., The Great Gatsby). |
| alias | URL-friendly name | Lowercase, no spaces (use dashes). Can be auto-generated from name. |
| description | Product description | Short text about the product (plain text or basic HTML). |
| price | Selling price | Numeric only, no currency symbols (e.g., 499). |
| compare_price | Original/list price | Old price to show discount. If not used, repeat price. |
| publish | Visibility flag | Use 1 = visible, 0 = hidden. |
| weight | Package weight | Numeric only, in grams. |
| package_dimension | Dimensions of the package | Enter the package dimensions (width, length, height). |
| inventory_quantity | Stock count | How many items you have in stock (e.g., 50). |
| hsn | Tax classification code | Numeric HSN code, no spaces (e.g., 49011010). |
| image1 | Product image URL | Enter the URL of the first image. If your files are uploaded in the Files section of your store, you can simply use the relative path to the image. For multiple images, add more columns as image1, image2, image3, etc. Refer to Preparing Images for the CSV file for detailed steps. |
| ondc.time_to_ship | Dispatch time | Number of days to ship after order (e.g., 2). |
| ondc.return_window | Return period | Number of days allowed for returns (e.g., 7). |
| ondc.category_id | ONDC category | Category ID or name as per ONDC mapping. |
| isbn | Book ISBN | Enter the ISBN as text (format column as text in Excel to avoid scientific notation). |
| unit_count | Quantity per pack | Number of items in the pack (e.g., 1 for single, 6 for pack of six). |
| unit_count_type | Unit type | Label for unit (e.g., piece, box). |
| country_of_origin | Country of manufacture | Use two-letter ISO code (e.g., IN for India). |
| category | Product category | Write the category name, and if it has subcategories, separate them using |
| manufacturer_or_packer_name | Manufacturer/packer | Name of the manufacturer or company packing the product. |
| month_year_of_manufacturing_or_packing | Manufacture/packing date | Format as MM-YYYY or MMM-YYYY (e.g., 10-1995 or Oct-1995). |
| manufacturer_or_packer_address | Manufacturer/packer address | Full postal address of manufacturer or packer. |
Category-Specific Mandatory / Important Fields
| Category | Important / Mandatory Fields | Attributes | Notes |
|---|---|---|---|
| Books | name, alias, description, price, inventory_quantity, image1, isbn, category | Nil | isbn is mandatory for books. Use text format in Excel to avoid scientific notation. |
| Electronics | name, alias, description, price, inventory_quantity, image1, weight, hsn, manufacturer_or_packer_name, manufacturer_or_packer_address, category | colour, compatible devices, connectivity, height, breadth, length, weight, brand | hsn and weight are crucial for tax/shipping calculations. |
| Fashion / Apparel | name, alias, description, price, inventory_quantity, image1, category, size, color | size, colour, fabric, brand, gender | Include options/variants for size and color. |
| Home & Decor | name, alias, description, price, inventory_quantity, image1, weight, category | colour, material, brand | Weight is important for shipping cost calculations. |
| Beauty & Personal Care | name, alias, description, price, inventory_quantity, image1, weight, manufacturer_or_packer_name, categorycategory | brand, colour, skin type, formulations, preference, conscious, ingredient, concern, gender | Include weight for shipping; manufacturer details help compliance. |
| Grocery / Food Items | name, alias, description, price, inventory_quantity, image1, unit_count, unit_count_type, ondc.time_to_ship, ondc.return_window, category | shelf life, brand | Include unit info and shipping/return timelines. |
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.