Regarding bulk uploading products having variations using CSV files

> The 3g and 4g and 5g variations did not show up in the user view but are in the database, as you can see in the exported data.

@fordtman You have set default variation in the edit screen. Click Clear when viewing the product then you will be able to select any variation.

Ron, Thanks for the reply, I appologise for taking so long to get back to you, a few other problems got in the road.

It was a misunderstanding on my part, I was assuming the default value applied to all of the variation and showing the default was a nice way of showing the customer the type of values to expect in the fields as well as setting a base selection for all the products. However I am now back to the original problem I had when I first started importing products.

In the folder: https://www.transfernow.net/fkToWg122020 there are two imports, one for 31 products and another for 32 products. The 31 product import works but the 32 product import doesn’t (see the videos). Can you tell me if there is a setting that determines the number of variations that are allowed or is it a “size if data” matter. 31 or 32 products to me does not seem to present much of a problem.

The 31 product import works but the 32 product import doesn’t (see the videos).

The second file is 33 lines

• 1 x Header row
• 1 x Variable product record
• 31 x variations

It imports correctly for me creating the variable product with 31 variations.

Hi Ron, did you use the file “wc-product-import-test5.csv” I sent to test for your result? I have just deleted and re-imported these products and still have the same error as shown in the file “Using input-test5.mp4” I sent (files were in https://www.transfernow.net/fkToWg122020). If you did not use my file could you please send me an exported copy of the data you were using or, if you did use my file could you tell me the version of Woocommerce you are using. Also have you modified your Woocommerce .PHP files to accept a larger number of variations?

did you use the file “wc-product-import-test5.csv” I sent to test for your result?

Yes, and it imported fine for me. Only WooCommerce and Twenty Nineteen was active.

@wpmuguru

We have upload the “wc-product-import-test4.csv” and we get the result that we want,(you can see that in the website https://www.goodsandchattels.com/newgood/product/brass-countersunk-screws/ ) but when we upload the “wc-product-import-test5.csv ” then we are not getting the same result. We have also increase the max limit of variations.But still we are not getting the expected result by uploading the “wc-product-import-test5.csv “. Can you please help us if there is any setting we need to do from back-end so that we can get the result.

Why it work for “wc-product-import-test4.csv” and not for “wc-product-import-test5.csv “?

• This reply was modified 3 years, 11 months ago by demon09876.

The 31 product import works but the 32 product import doesn’t (see the videos).

But still we are not getting the expected result by uploading the “wc-product-import-test5.csv “.

It looks like you are expecting 32 variations to be imported but the test5 file only has 31 variations in it.

Can you please help us if there is any setting we need to do from back-end so that we can get the result.

I used a new install with minimal setup to do the import test above.

We have also increase the max limit of variations.

Can you describe where you found this setting?

Hello,

We have increase the max size by adding one line code in function.php file.

define(‘WC_MAX_LINKED_VARIATIONS’, 100);

reference link : https://ideas.woocommerce.com/forums/133476-woocommerce/suggestions/2915157-increase-max-of-variations

• This reply was modified 3 years, 11 months ago by demon09876.

Your test file only has 31 variations which is less than the 50 described in that thread. Aside from that, the constant applies to the Create Variations from All Attributes button in the product edit screen vs the product import.

Hi @demon09876. We haven’t heard from you in a while so I’m going to go ahead and mark this thread as resolved. If you still need help with this issue or have any other questions about the WooCommerce plugin, please start a new thread.

Hello @wpmuguru , the issue is still there if you import the test4.csv file in the website it shows the expected result as it has 30 variations but when we add one more variation from backend i.e. from product page and update it the result gets change please tell us why it is happening,when we add more than 30 variation.
We have check this with the basic wordpress theme Twenty Nineteen and WooCommerce was active.

Please help us in this.

Please resolve this issue as we are not getting the expected result after uploading the csv file having more than 30 variations.

@demon09876 This thread was closed. You will need to start a new thread. It looks like your issue isn’t related to the import but an unexpected limit on the number of variations. When you create the new thread describe the details around that.