Export products CSV shows wrong prices in Sale Prices col.

  • Resolved illy

    (@myrightstuff)


    7 years, 10 months ago

    Hi Oscar,
    I set 1 Zone for a country that I need to have Sale prices. I have set manually the prices for this, with same regular price as the “Rest of the world” zone and I added the sale price.
    Everything seems to work fine (thank you by the way!).

    I want to be able to either bulk edit prices by using a plugin or make changes by exporting/importing products.

    I exported my (variable) products & variations via the built-in Woocommerce export with all the meta included. The CSV I got shows sale prices in the main “Sale price” column (which should be empty!).
    To see which info this column is using, I tried to change this price and re-import a CSV, but the “Rest of the world” price has not changed.

    I also manually added a different sale price for this variation, but the CSV does not change.

    – Is this some kind of bug you know of?
    – How can I check and bulk edit prices?

    thank you

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Oscar Gare

    (@oscargare)

    7 years, 10 months ago

    Hi,
    thanks for your feedback!
    Currently, the built-in WooCommerce import/export feature is not supported, so you’ll have to import the products using the “metadata”.

    You’ll find 2 metadata: “{slug}_sale_price” and “{slug}_price”, where {slug} is your zone slug.
    If you set the product price for the zone as “manual”, you must update the 2 metadata with the same value.

    Thread Starter illy

    (@myrightstuff)

    7 years, 10 months ago

    Hi, thanks for your reply.
    I already did that.

    What ‘s not working is the “Sale Price” column import / export.
    While it’s empty in WP admin, when exported it shows the “{slug}_sale_price”.

    Plugin Author Oscar Gare

    (@oscargare)

    7 years, 10 months ago

    Hi Illy,

    Download the sample csv file as reference.

    In the sample csv file you will find the columns: Meta: _euro-19_regular_price, Meta: _euro-19_sale_price or Meta: _euro-19_price_method. “euro-19” is the slug of the zone, you must replace “euro-19” for your zone slug. You’ll find the slug of the zone in your pricing zones table, hovering over zone name.

    E.g. If your zone slug is “spain” the field name to update prices for this zone must be: Meta: _spain_regular_price, Meta: _spain_sale_price or Meta: _spain_price_method

    Important! you must use the “.” as decimal separator.

    Hi hope this helps you.

    Regars,
    Oscar.

    Thread Starter illy

    (@myrightstuff)

    7 years, 10 months ago

    Hi Oscar,
    thank you but I already got that.

    I am asking about the “Sale price” that matches the “Rest of the world” zone price.
    As stated above, while there’s no sale price for the “Rest of the world” zone in WP admin, the exported CSV shows the sale price of my country’s zone in this column.

    Plugin Author Oscar Gare

    (@oscargare)

    7 years, 10 months ago

    Hi again!
    Sorry, I understand now!

    Yes I checked it and it’s a bug. I’ll fix it as soon as possible.

    Thank you for the feedback.

    Thread Starter illy

    (@myrightstuff)

    7 years, 10 months ago

    Superb 🙂

    Plugin Author Oscar Gare

    (@oscargare)

    7 years, 10 months ago

    Hi @myrightstuff
    I just released a fix to solve this bug.

    Thank you for your feedback! 🙂

    Thread Starter illy

    (@myrightstuff)

    7 years, 10 months ago

    Just tested it – it works perfectly, thank you 🙂

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

The topic ‘Export products CSV shows wrong prices in Sale Prices col.’ is closed to new replies.