Knowledge

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 <200 lines each), to ensure the file is successfully imported into the system.

• 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 sample button.
  
• 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 File button under Choose excel file and 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 management page or at the variations tab in the product details page.