Woocommerce built in csv import/export fails to update prices

  • Resolved DyWi

    (@dywi)


    6 years, 5 months ago

    Hello,
    recently I had troubles updating product prices with woocommerce built in import/export tool. My import csv is fine, column mapping works fine, but when it comes to variable products, import ignores them. Products are matched with SKU (I cant tell ID in my prices export). In variable product, there are sometimes variants which inherits SKU from main variable tab. These products are ignored by csv import.
    I already tried allopwing multiple same SKU numbers in shop, and adding them to product variants, but importer always affects only one product.

    Does anyone have some experience with this? Could there be a way to update prices and settings for all variants of variable products?

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thomas Shellberg

    (@shellbeezy)

    Automattic Happiness Engineer

    there are sometimes variants which inherits SKU from main variable tab. These products are ignored by csv import.

    What exactly do you mean here? Are you saying that some of your variations have the same SKU? If that’s the case, that will not work; SKUs are, by definition, supposed to be unique.

    Thread Starter DyWi

    (@dywi)

    Well, this is my exact case. I took a screenshot. But woocommerce acts in this scenario the same asi having two same SKU numbers… So I guess we will need some kind of custom solution for price and stock updates.

    Thomas Shellberg

    (@shellbeezy)

    Automattic Happiness Engineer

    @dywi – your variations need to have their own unique SKU numbers different than the parent product. So, for instance, if I wanted to have a parent SKU for my t-shirt, I could call it 0001. The variations would need to be a child of that, so, something like 0001-M(for medium size) or 0001-L(for large size).

    Your parent product does not have to have a set SKU. In fact, if the parent product can’t be ordered by itself(without a variation selected), it makes sense for it not to have a SKU.

    Thomas Shellberg

    (@shellbeezy)

    Automattic Happiness Engineer

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    I am having an issue with the import tool. I am importing products through CSV, but some products dont import images in URL, some come ducplicate because of variation and all dont get all images it has. How do i fix this?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Woocommerce built in csv import/export fails to update prices’ is closed to new replies.