Configurable product looks like a single product with drop-down lists of options for each variation. Each option is actually a separate simple product with a unique SKU, which makes it possible to track inventory for each product variation. You could achieve a similar effect by using a simple product with custom options but without the ability to track inventory for each variation.
The following instructions take you through the process of creating a configurable product using a product template, required fields, and basic settings. Each required field is marked with a red asterisk (*). When you finish the basics, you can complete the advanced settings and other settings as needed.
For individual upload
Step 1: Select on products, and then click on add products for individual product upload.
Step 2: After clicking on Add Products, the page shown below opens. Here, you can select the product type by clicking on the dropdown option. As we are here trying to upload simple product so simply click on Simple and click on Continue to process further.
Step 3: Fill up the required fields with details like the product category, product name, description, SKU, weight,
images and Meta title, description and Keywords along with a number of quantities of product a customer can purchase,
just like how you’d do for simple individual product, then we need to set special attributes to create configurable
product. For that do as shown down below:
Step A: Click on Create Configurable Step B: Set special attributes as shown. You can customize, size color price brand based on the requirement Step C: Click on the box as per the requirement and click next as shown after you’re done selecting the attributes. Step D: Select by clicking on the round box on the left side and click on next to proceed further. Step E: After completing selecting the special requirement as per your requirement click on create configurable as shown. After this entire step, continue exactly like how you’d create a simple individual upload as shown:
For Mass Upload
Step 1: Select Mass Upload and click on Mass Upload Product.
Step 2: Download the CSV file for Simple Product Mass Upload. Click on ‘Sample Configurable Type CSV File’.
Step 3: Fill up the required fields with details like the product category, product name, description, SKU, weight, images and Meta title, description and Keywords along with a number of quantities of product a customer can purchase.
Detail information about the CSV file
Fill up the required fields with details like the product category, product name, description, SKU, weight, images and Meta title, description and Keywords along with a number of quantities of product a customer can purchase.
type: In configurable product, the details are almost the same except for the few more attributes are added. Here, we can see that simple product is also configurable product in itself.
In category, only the already existed category can be placed. Category should be placed in certain format:
1st level category>>2nd level category>>3rd level category
Note: Each category is to be place with >> and make sure there’s no space in between. Category should be placed in shown format:
In name just simply write the name of the product but make sure the product title/ name of the product is unique or else
the product want be uploaded as per the brand of the product name and generic name of the product.
Note: Make sure the initials of the name are written in capital so that it looks neat. Any special characters cannot be used (“? #!~*^). Product name can be lengthened up to 50 characters.; in case of more than 50 characters being upload the product will still be uploaded, however for mobile UI it will be distorted. So, length of the product name should be carefully added.
description: In description, the details of the product are written in long sentence or paragraph or in table format as per the requirement. Note: description should be in html code you can use https://html-online.com/editor/ for making description. We can also add images or videos’ link in the description.
short_description: In short_description, the details of the product is written but in points/bullet, making easier
for the viewer to go through. Note: description should be in html code, you can use https://html-online.com/editor/ for
making short description.
Note: We use UL tag and LI tag in highlights as shown down below:
sku: For sku in config product, let the config type SKU be the standard SKU and for simple type, customize it
according to the super attributes such as size, color and likewise. Also SKU should always be with the caracters of
less than or equals to 15.
Note: For Sku of config type make a base sku as shown G10203 then under simple customize it on the basis of special attributes shown but under 15 characters.
We can use formula in excel to find the exact length of the SKU: Length: =LEN(Row no.)
price, special_price, special_from_date and special_to_date: Price means the market price also known as MRP. For special price, write the discounted price for the customer if any (optional). Special date from is the date from when the special perice also known as offer price starts. Lastly, special to date is the date upto when you want to give the offer.
tax_class_id, is_in_stock, stock and weight: In tax class id, just write Taxable Goods or absolutely leave it blank as it is optional for every product. In is in stock write either In Stock or Out of Stock according to the availability/ requirement for simple type only, in config type is in stock should be kept blank. In stock write the quantity of product available in the store. For weight, write down the weight of the product converting it into kg.
_super_attribute_code and _super_attribute_option: In _super_attribute_code, color,size is written which can
further be clarified in _super_attribute_option whereas, In _super_attribute_option, the specified color (e.g., red,
blue), along with the sizes are mentioned. Similarly, in these also the super attribute code and super attribute option
for config type shouldn’t be mentioned.
Note: Make sure there’sno space in between and the initials are in capital letters
Also make sure only the colors already set in the admin should be mentioned in the file preparation.
images, manufacturer and return_exchange: For images, in config type only name the images which displays in product
listing page. But for simple type, all the images should be named as it will be displayed in product display page. In
manufacturer, mention the brand of the product, if there is no brand simply write Generic to it. In return exchange,
either write Upto 7 Days After Delivery or Refer to Return/Refund Policy
Note: Images should have no space in between the name. Videos can also be uploaded in place of base image.
Step 4: Upload the CSV file along with the zip.
Step 5: Select the required criteria and then upload the file. After uploading being done new tab opens informing the product being uploaded as shown. Then upload it along with the csv file