# Importing Product

How to access on Fynd Commerce 
Commerce Panel → Products → My products → Bulk Action → Import → Product

## Introduction

More often than not, products are created in bulk, and so is its inventory. Describing your product and all its attribute will thereby form a catalogue. Maintaining its price and quantity will constitute an inventory.

Instead of manually taking the efforts to create your products one-by-one, you can choose to do it all together in bulk.

## Access the bulk import panel

When you'll click on Import, you’ll see three import options:

* Product – for importing product listings
* Assets – for uploading product media (images)
* Inventory – for uploading stock quantities


We’ll begin with **Product**.

## Steps to Import product listings in bulk

### Step 1: Select import type

1. Click **Product** under the **Bulk Import** section.
2. On the upload screen, select the following:
  * **Product Type** (Standard, Set, Composite, or Digital)
  * **Department**
  * **Template** based on the department and product category
3. Click **Download Template** (choose CSV or Excel) to get the file format you need to fill.


### Step 2: Fill in product details

Let's assume you have downloaded an Excel file for creating a product, start filling all the product details, similar to what we saw in the [previous section](/commerce/docs/products/catalogue/creating-product).

You will get drop-down boxes for certain columns in the Excel file. Example: Brands, Tax Rule Name, GTIN type, Country of Origin, Currency, etc.

| Field | Description | Example |
|  --- | --- | --- |
| `Name` | Product name | Black Cotton Shirt |
| `Item Code` | Unique product identifier | SHIRT-1001 |
| `Brand` | Brand name associated with the product | FashionPlus |
| `Category` | Product category | T-Shirts |
| `Description` | Full product description | A breathable cotton shirt for men. |
| `Short Description` | A brief summary of product | Cotton shirt with slim fit |
| `Tax Rule Name` | Select tax rule from the dropdown | 5%,12%, etc. |
| `HS Code` | Enter HS/HSN code of product | 6109, 55101190 |
| `Country of Origin` | Country of manufacture | India, Bangladesh |
| `Media` | URLs or filenames of product images | image1.jpg,image2.jpg |
| `Gtin Type` | Type of product identifier (EAN, UPC, etc.) | EAN |
| `Gtin Value` | Value of the identifier | 8901234567890 |
| `Selling Price` | Sale price shown to customers | 999 |
| `Actual Price` | Original price before discount | 1299 |
| `Size` | Size value if applicable | M |
| `Available` | Quantity available | 50 |
| `Highlights` | Key features (comma separated) | 100% cotton, Slim fit |
| `Variant Type` | If product has variants like colour or size | Additional Colours |
| `Marketer Name` | Legal marketer name | FashionPlus Marketing Pvt. Ltd. |
| `Package Contents` | What's included in the package | 1 Shirt |


![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/Updates-to-docs/Documentation-update/Products/Import-catalogue/fig-7-fields.png)

center
em
Figure 1: Excel sample file content
br
The first row highlights the headers. Hovering over any of them with your mouse pointer will show a brief description. The columns that are highlighted in green are mandatory to fill. It's recommended that you also fill the optional fields (field that has no colour) as it enhances the product description.

details
summary
Guide to Tax Rule Name
When filling in the Tax Rule Name field:

- Click the dropdown to see the tax rules you have already created. Similar to what do while [creating individual product](/commerce/docs/products/catalogue/creating-product#step-6-tax)
- You can select an existing tax rule from the list, or create a new one and then repeat the bulk import process for the product.
- To learn how to create a new tax rule, [click here](/commerce/docs/products/taxation/product-taxation).


details
summary
Guide to Product identifier (GTIN Type)

Product has only one identifier (GTIN Type), e.g. EAN. Enter the identifier (also referred to as the seller identifier).

If product has more than one identifier, e.g. EAN, SKU, UPC, etc, we have seen in the [previous section](/commerce/docs/products/overview-product-creation#sizes) that if a product has multiple identifiers, one of the identifier has to be made **PRIMARY**.

In the Excel file, primary identifier is known as **Seller Identifier**.

* **Product Dead Weight** is the actual weight of the product in grams.
* If you want to add slug for each product manually, you can enter a **Slug** attribute at the end (preferably) of the file. Refer **Adding Slug Attribute** section to learn more.


### Step 3: Upload the file

1. After filling in your template file, return to the **Upload Bulk Products** screen.
2. Click **Select File** and upload your spreadsheet.
3. Your file will be validated and displayed under **File Data**.
4. Click **Upload** to initiate the import.


### Step 4: Check status in upload history

Once submitted:

* Go to the **Upload History** section.
* View the status of your batch:
  * **Pending** – Processing
  * **Completed** – Successfully imported
  * **Failed** – Errors encountered (click to view)


You can filter uploads by template name, date range, or stage.

## Adding Slug Attribute

Fynd Commerce  allows you to manually add slug for all the products while importing a catalogue. Please refer the table below to understand the use cases while entering slug value in a file.

![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/platform-panel/products/new-catalogue/slug-use-cases.png)

center
em
Figure: Slug Attribute Value - Use Cases
br
Points to be noted -

* Attribute name should be **Slug**, not **slug** or **SLUG**. It is a case-sensitive.
* If you add **Slug** column in a file then you should not keep it blank while uploading catalogue.
* Duplicate slug values are allowed. System will append product UID at the end of each slug converting it to a unique value.