Product variations not showing under Attributes and Filter by Attributes Widget

Hi @taylorclark,
I couldn’t find an Export products option in either platforms, printful or woocommerce.
Could you specify where?
Thank you!

• This reply was modified 4 years, 6 months ago by federicar.

@taylorclark first of all thanks!!

Mine is not working yet, when importing what to select in column mapping?

also even though when i only have 2 product but when i export the file it had about 100 lines because of different sizes and after changing when i import it shows over 200 products? please let me know what am i doing wrong here!

Very good solution from @taylorclark, thank you very much.
If many more products without attributes are imported, as it happens to @thsingh, it can be a problem with the cvs file, at least this way it happened to me, at the end I ended up editing the cvs in open office.
Another thing that happened to me is that when I changed the values of Attribute # global to “1”, when I imported it, I lost the variations of the products in woocommerce and I got a printfun alert about this. What I did to solve this and it worked, was at the end of the cvs I duplicated the columns that belong to each existing attribute and their values (Attribute # name, Attribute # value(s), Attribute # visible, Attribute # global, Attribute # default), then placing another consecutive “#” in the identifier in each of the columns of the new attribute, then I can create duplicates of existing attributes in the product, in those duplicates is where I changed the values of the column “Attribute # global” to “1”.
When I imported the cvs back into woocommerce of course I have those duplicate attributes, but by keeping the custom ones the product variations are kept.
The new duplicate attributes created are not used in the variations, nor do I make them visible in woocommerce (uncheck options), but they are used in the filters in the store, and in Printfun there are no alerts. I hope it can be useful to someone.

Hey!?
We recently changed product attributes to global attributes for all print and warehousing products.

All products that are pushed to the WooCommerce store will have this in effect already but existing products need to be updated manually on the WooCommerce store side.

thank you @edwardza !
That’s a great update.
Could you provide a SQL to find and replace all old attributes and remap them to global? It will take days of manual work to transfer all the old product variables one by one

something like
add global attribute to product
remap variables … “where name like _iphone11” to new global variable
delete old variable from product