CSV Import Variable Products – Cannot import “Used for variations” option

  • Resolved wazab

    (@wazab)


    5 years, 12 months ago

    So I’m trying to import a few variable products with the native Woocommerce CSV importer. Whenever I import variation products from and after the products are imported I find out that the option “Used for variations” is left unchecked on the attributes tab.

    I appreciate any help with this.

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Stef

    (@serafinnyc)

    5 years, 12 months ago

    Are you uploading Products and Variations separately as is advised?

    Did you make sure you uploaded products first?

    Can you share your spreadsheets?

    Thread Starter wazab

    (@wazab)

    5 years, 11 months ago

    Hi,

    Yes I am uploading products only now. Variable products that is.
    Here is the sheet I am using.

    https://we.tl/t-UTWCoDZ3MR

    Thanks

    version interactive

    (@version)

    5 years, 11 months ago

    I’m still working on auto generating the variations without going into each product – but you need to go in to upload images anyway – right?

    I solved the unchecked “used for variations” issue by running the following update in mysql/phpmyadmin

    UPDATE wp_postmeta 
SET meta_value = REPLACE( 
  meta_value, 
'is_variation";s:1:"0',
'is_variation";s:1:"1'
);

    I made a plugin so my client can do this easily each season.

    I also added a feature to globally apply parent prices to all child variations with one click. This was not straight forward because when variations are generated the original price is deleted. So I added a new meta value for parent price when globally checking the “used for variations” boxes.

    plugin screenshot

    Thread Starter wazab

    (@wazab)

    5 years, 11 months ago

    Wow, that’s great. Excellent work.
    Is this plugin now available for download? Can you share the download URL link please?

    Thanks

    Plugin Support EastOfWest a11n

    (@eastofwest)

    5 years, 9 months ago

    There hasn’t been any replies to this thread in a while, so I’ll go head and mark this thread as resolved. If you have any further questions, you can always start a new thread.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘CSV Import Variable Products – Cannot import “Used for variations” option’ is closed to new replies.