woocommerce csv import variable products are interested by many people because some logins do not support to import products including variables. However, lots of shops and suppliers sell products including variables. This article will help you.
Create Your Variations CSV
Firstly, you create a csv file which includes product information such as name, image, etc. to save in database. To make sure that you use a correct file and avoid errors, you should use the sample file of woocommerce or plugin.
In Product item, you see Export as below.
In the next window, you click on Generate CSV as below
If you are using plugins, there will more options forcsv files by selecting export fields to the file as below. The advantage, in this case, is that only necessary fields are exported, which makes the csv file simpler and more convenient for future editing.
To us, woocommerce csv import variable products will be perfect and work smoothly if you have a well-prepared file with the right format. Our experience is that you import one or two products perfectly. Then you export these data to the csv file to make a sample file other products. In order not to waste too much time on editing the csv file, you should try importing several products. If everything works well, you can start importing products in bulk.
Configure woocommerce csv import variable products
After having a correct csv file which matches with the sample csv file, we start to import products.
Step 1: Upload CSV file as below. We search for the file we have prepared. Then click on Continue
In addition, you can also click on “Show advanced option” to configure more highly. There is one option which you can use to update products. For example, you want to increase the price or other information of products from another csv file, you just need to click on Update existing products as below.
Step 2: In this step, you view the information on the left side and edit information on the right side. If your products include variables, you should pay attention to fields such as Attribute name, Attribute value as below.
After selecting and configuring the above fields, you click on Continue button. The process of importing products starts. Now, you just need to wait for products imported in bulk. You must be surprised when realizing that it takes only from five to seven minutes to import thousands of new products or update existing products. Comparing with importing manually, it is unimaginable.
Thanks for reading this article about import variable products in woocommerce. All source codes such as Shopify, Magento, Prestashop support to import products by default. However, import product modules and apps have more high-up features. If this article is helpful for you, please share it with others. If you have any comment, please leave a comment below or contact us.