Regarding bulk uploading products having variations using CSV files

@demon09876 Could you upload a copy of one of the CSV files to pastebin or similar you are having an issue with?

Hello,

Please open the below link :

https://www.goodsandchattels.com/newgood/wp-content/uploads/2020/11/Brass-slotted-countersunk-screws.csv

@demon09876 Thanks for uploading the file. If you

– make the Gauge and Length attributes local attributes instead of global attributes
– re-import the CSV file

When you view the product and select a Gauge the Length dropdown should update to only the lengths available in existing variations.

I hope this helps!

Ok, Thank You so much

We will try using this.

The solution did not work. I changed the “Gauge” and “Length” attributes to local by changing the “Attribute ? Global” column in both cases to a value of zero “0” (which I assume is the setting for “local”) and re-imported the CSV file but nothing changed. I exported the products to check that the Attribute ? Global column was still zero and it was. I tried removing the value of zero from the variation columns but sadly I got the same result. The length is not updated to reflect only that available for a particular gauge size.

@fordtman Try

– remove the variable products you imported
– creating a sample product with 2 variations using a local attribute
– export that product to see what your attribute columns look like
– delete the global attributes
– update your original import file
– import it

Hello @wpmuguru

we have tried the above solution but still we did not get the expected result,Can you please help us.

@demon09876 Can you post the file you exported with the sample product you created?

hello, @wpmuguru

Please find the below link of testing data and video files:

https://www.transfernow.net/SFLTQR112020

– creating a sample product with 2 variations using a local attribute
– export that product to see what your attribute columns look like

The file I’m looking for is this one.

please see the below link,

https://www.goodsandchattels.com/newgood/wp-content/uploads/2020/11/wc-product-export-21-11-2020-1605941573522.csv

I have add one product having 3 variations manually from backend and then export the file.

@demon09876 Thanks for providing the file. That product still has global attributes. Here’s a screenshot of a local attribute https://pasteboard.co/JBQNhnN.png .

Ron, @demon09876 is with the company who were developing my website for me but they seem to be having a bit of an issue with getting this variable/variation problem solve so I have decided to take over the discussion about the importing problem.

The first problem I would like to solve is that your https://pasteboard.co/JBQNhnN.png shows a different view than I am getting. I do not get the “Local” attribute setting field. What version of Woocommerce are you using? I have 4.6.1 installed and there does not appear to be any way to specify a “Local” attribute. I have changed the setting in the CSV file to zero but it does not change anything.

The second problem: I have transferred some files to the folder https://www.transfernow.net/PflSqk112020. Please ignore the “Import exported data global attribute zero (0)” file I used this to test the “Global Attribute” setting of zero because I could not set an attribute as “Local”. The setting of zero did not alter the result.

The following files were sent:

1. A video of a variable product with two variations added manually via the WordPress/Woocommerce dashboard. Note that there is no way to specify whether the attribute is global or local.

2. A Video of the user interface of the data (a variable product with two variations) after it had been added. Note that one of the variations (the 3g countersunk screws) cannot be seen. This issue was noted in a previous test where I added 0g, 1g, 2g, 3g, 4g, 5g screws, in this case the 3g and 5g screws were missing in the user view but were still on the database. The interesting thing is that ALL variations of the 3g and 5g screws were missing in the user view but NOT in the export file.

3. A .CSV file of the data exported after it had been added. Note that all variations are present.

There is definitely something wrong here because even though all data in in the database it does not show in the user view.

Can you help me with this please. If you want any more information please let me know and I will respond as quickly as possible as I would like to get this issue solved.

The first problem I would like to solve is that your https://pasteboard.co/JBQNhnN.png shows a different view than I am getting. I do not get the “Local” attribute setting field.

@fordtman Sorry for the misleading terminology. In the WooCommerce documentation they are called Custom Attributes. See the three steps in https://docs.woocommerce.com/document/managing-product-taxonomies/#add-custom-attributes to access the fields in my screenshot.

I have entered a variable product with 2 variations using the WordPress/Woocommerce “Add” new product interface. Data is in the folder https://www.transfernow.net/dqPZBn112020

This folder contains:

1. A .CSV file containing the exported data for the variable with 2 variations. NOTE that the 3g variation does not show in the user view even though it is in the database as shown in the exported data.

2. A video of the user view that shows that the 3g variation is missing.

3. As an extra test I added two more variations (4g and 5g) using the “Add” new product interface. 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.