WooCommerce variables update

  • Resolved mkadzinski

    (@mkadzinski)


    6 years, 9 months ago

    Hi,

    I have online shop with some bunch of products that have 2 attributes: “filling” and “colour”.
    Filling has 2 variables
    Colours have 9 variables

    The point is I want to add additional colours to all of the products(about 1000).
    So I need to change Colours attribute from 9 variables to 21 variables. I know I can do it manually one by one. I need solution to do this easier way because it will take ages.
    Thanks ??

    • This topic was modified 6 years, 9 months ago by mkadzinski.
    • This topic was modified 6 years, 9 months ago by mkadzinski.
Viewing 4 replies - 1 through 4 (of 4 total)

  • The only way that I’ve seen it done that works is to do an export of the existing products, and copy-and-paste the new items into that CSV file, then import it back into WooCommerce. We’ve got a client that does that, and it’s worked for them. As a note, they’ve got about 200 base products, and about 30,000 variations set upder those products so I’ve seen it work on the same sort of products that you’ve got.

    Thread Starter mkadzinski

    (@mkadzinski)

    I have to admit that I tried this, but I have no idea how to read this file I mean it opens in MS Excel but it’s really chaotic. I don’t know which line belongs to which product. That makes me look at this like I’m blind. :/

    The columns that you need to take the most notice of are the SKU and Parent ID. The product ID is relatively important if you’re updateing existing products, but it doesn’t help if you’re adding new products or variations.

    The basic process behind it is that you’d export the existing products, filter out pretty much everything that you don’t need (which willb e most of them), copy the variations that are set for a current product, and paste them with a new parent ID to match the new products. It’s not easy, and will take some time to get your head around, but that is really the only way I know of to do it in any sort of automated fashion.

    Thread Starter mkadzinski

    (@mkadzinski)

    Well, thanks a lot, it really works. I’m just using Libre Office to edit csv file and everything works fine. Thanks!!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WooCommerce variables update’ is closed to new replies.