# Bulk Product Upload - How it works

Bulk product upload lets you instantly upload as many products as your premium plans allow in one shot.

%[https://www.youtube.com/watch?v=3U5OMZ8LsE4&t=3s&ab_channel=Blanxer] 

### Step 1 - Let's know about prerequisites

* First of all, you need to have pictures of all your products & variants in a folder
    
* All of the pictures must be in 1:1 aspect ratio (recommended size 1080x1080) so it will be a perfect fit on the website
    
* Secondly, to understand which image belongs to which product & variants, please name the picture file accordingly so it will be much easier for you to track
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701356497016/2d0fc2c0-670a-4585-b624-c69381822db8.png align="center")

### Step 2: Uploading your pictures to Blanxer

* Goto Media Management, click on `+ Folder` and create a folder (e.g. `Nov_30`)
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701356716961/7654092d-3999-4715-ab7d-83796ce443e5.png align="left")

* The added folder will look like below, now click on that created folder
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701356994623/c27faa07-b1c2-438a-938d-a6b70a1dbfff.png align="center")

* You will see empty folder like this
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701357051746/3f52ddab-d9f1-4272-b693-1322339e355a.png align="center")

* Now Drag and Drop all images from the folder we made in `step 1`
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701357303574/1d6f28e1-20fe-4e1a-9569-7e3c2bb2ad90.png align="center")

* After uploading completes it will look like below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701357225961/8cce2304-1f45-45d7-8a56-cc4a16665df7.png align="center")

* On Top Right, there will be a button named `CSV` Click on that button and download the CSV format of that folder
    
* CSV file will contain `file_name` and `file_url` as below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701360953769/a6f5a972-fcd8-4f8d-a603-20e0471defdd.png align="center")

* This CSV is required for us to do bulk upload
    

### Step 3 - Understanding bulk upload parameters

* Goto `Products > Add Product > Bulk Upload`
    
* Click on `Download Sample CSV`
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701361451179/83077950-2512-49d1-91ad-d56d769271c5.png align="center")

* Sample CSV contains the following fields, lets's understand these field first
    
* `product_name` This field holds the name of the product
    
* `variant` if any product has a different variant(i.e. Color, Type, Brand....) we include that detail in this field, if you are confused will be clear in a later process.
    
* `size` similar to the variant this field will have Size value if the product has multiple size options available
    
* `group` when we have multiple variants & sizes for a product, there will be multiple rows in the Excel file for that same product. the `group` helps the system to understand that these multiple rows belong to the same `product`
    
* `product_description` detailed description for the product in `HTML` format
    
* `price` selling price of the product
    
* `crossed_price` marked price of the product
    
* `your_buying_cost` actual cost at which the product is purchased (for the purpose of net profit calculation)
    
* `quantity` how many products are there in inventory
    
* `sku` unique identifier for product helps you to identify products at inventory
    
* `sell_after_out_of_stock` will make the product never go out of stock on the website even if all listed quantity is sold out. possible value for this field is `Y` or `N` default is `Y`
    
* `product_category` name of categories the product belongs to can be multiply separated by `/` (eg. `Chair/Sofa` adding two categories to the product)
    
* `status` which states the product will be after immediate bulk upload. Possible values are `Active` and `Draft` defaults to `Active`
    
* `image_1` .... `image_5` for adding the image URL
    
* Required fields
    
    * `product_namepriceimage_1`
        
    * `product_description` must contain at least 20 character
        
    * if it is non-empty `group` field, either `variant` or the `size` field is also required
        

### Step 4 - Creating a description for the product

* Visit [description.blanxer.com](https://description.blanxer.com)
    
* Write down the description for the individual product as shown below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701361230542/be529d17-068c-431e-8b34-f01014e634ba.png align="center")

* Click on `Show HTML Value` and copy that HTML
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701362970840/60fdc5c5-f70b-4e76-b0a5-4a0d2efa5d80.png align="center")

* This HTML value is required to be added within the bulk product upload CSV file in `product_description` field
    

### Step 5 - Creating categories ready for the products

* Goto `Categories` and add required categories as shown in the image below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701363077330/7b16f9d8-89be-49b4-bdda-62784f4b4cd6.png align="center")

* Remember the `name` of category as it is required to be added within bulk product upload CSV file in `product_category` field
    

### Step 6 - Preparing CSV file with appropriate data

* Firstly open both `CSV` files upload sample and folder CSV
    
* add `file_name` column from folder CSV to `product_name` field and `file_url` to `image_1` then CSV will look like below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701363431346/40a50aaa-c657-403e-8dfe-c594f5213751.png align="center")

* Now fill up other fields, after filling few fields CSV will look like the one below. Here I have added the name of the category as well that was created in `Step 5`
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701364045062/4cb50efa-9f5e-4615-b3c1-393fc2608a84.png align="center")

* Now add the description prepared in `Step 4` to the CSV and the file will look like below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701364167200/2a54a720-cad8-435d-8ce2-833ab9d9b21d.png align="center")

* At this point if we upload this `CSV` file we will have 4 products successfully uploaded. But let's say `Premium Sofa` and `Serenity Seat` products have different colors and sizes. Let's add that in `CSV` now. The file will look like below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701366226105/09ec4890-5a4a-47d0-885b-34e8504b5b0a.png align="center")

* Here for `Premium Sofa` we have two variants and two sizes we added that accordingly. And added group values in each product containing variant and size. The group field says all rows having a similar group belong to the same product.
    
* Now for the final step let's clear out the empty row in between, which I just added for proper visibility. Then the final CSV looks like the below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701366302175/bf3ccd69-be0e-473e-8f80-fbf52f4b1f60.png align="center")

* Here, I knowingly removed the `image_1` field for the product `Regal Retreat` which is a required field. so that i can show you how failure to add a product will result
    
* Currently, I have no products
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701365481319/0a83be97-58f8-483f-a45e-6b718165e66e.png align="center")

* Let's save the CSV and drag it to the bulk uploader now `Products > Add Product > Bulk Upload`
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701366831409/0ecbae9f-4951-45fe-8132-730070529153.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701366923011/c81109eb-a4b3-4b35-99be-560f80718b27.png align="center")

* YaY! You can see 3 products were added successfully but 1 was rejected as expected
    
* The system throws rejected files into another CSV for you to download
    
* Now let's save rejected uploads and see how the CSV looks
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701367092752/9af3af0e-9296-4189-8456-adf670322f09.png align="center")

* You can see the rejected reason. `Image 1 is required`
    
* We can now fix that error and reupload the CSV to have the remaining products live.
    

### Result Time

* Now 3 products have gone live
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701367259205/827b3188-9d2a-47d7-ae42-8e3dc700bb3e.png align="center")

* 2 of the products have 4 - 4 variants as expected
    
* `Luxe Lounge` which we added 2 categories has 2 categories as expected as shown below
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701367565969/ee894993-42d6-4241-91a2-8ea431b2217c.png align="center")

* Spent too much time with Dashboard. Now let's see products on the website, and how it looks
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701367744128/25c0d49f-9d10-463f-9e15-a5846412a5b0.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1701367765570/342750c0-7bc2-4110-9401-2e41b4a33010.png align="center")

**Note:** if your product needs to have custom fields like custom image, or custom text you need to manually add that property to required products after bulk upload

Hurreyyyyyyyyyyy 🥳 It's party time now. Throw me some beer 🍺 at `kiran@blanxer.com` 😜