Guide: Import variation product

Import variation product

Import product variation function allows you to import the variation product of a predefined product in case you create a product with manual variation outside the management screen but cannot create it (this is the case you declare properties from variation, and from these properties, too many variation products are generated, and the system cannot afford to generate all these variations, so the import function below must be used). Note: If your excel file has many lines of data, we recommend you to split the file into smaller files (maybe

• Step 1. You need to make the parent product available in the Items screen
• Step 2. From the properties declared for the product variation (width: 10,20, height: 30,40,length: 40,50), you need to determine what combinations of variation products will be generated from these above attribute product 1: width: 10; height: 30; length: 40 product 2: width: 10; height: 30; length: 50 product 3: width: 10; height: 40; length: 40 product 4: width: 10; height: 40; length: 50 product 5: width: 20; height: 30; length: 40 product 6: width: 20; height: 30; length: 50 product 7: width: 20; height: 40; length: 40 product 8: width: 20; height: 40; length: 50 To quickly generate a list of product variants in Excel, refer to the following link: https: //exceloffthegrid.com/list-of-all-possible-combinations-using-power-query/
• Step 3. To ensure successful import (correct format, full columns) you should download the template file by clicking Download a samplebutton.
• Step 4. Enter the data you need to import into the downloaded file and save it.Parent ID: the id of the parent product, you can see it on the link in the product detail page, it's a number Attributes: is a group of product attributes, where "name": "replace with attribute name", "option": "replace with attribute value", similar to the rest of the attributes of the product.
• Step 5. Click the Choose Filebutton under Choose excel fileand choose a file -> click Import It is necessary to ensure the accuracy of data before entering into the system, after successful import you can view the list of variants outside the Items managementpage or at thevariations tabin theproduct detailspage.