Support » Plugin: Woocommerce CSV importer » Sale Price not being updated unless manually publishing

  • Resolved finleydesign



    After a few attempts, I got the CSV to import OK and its great, the only thing is the “sales_price” is working as in it enters the sale price in to the correct box and I can see it on the backend product page, but it makes no effect on the front end, the sale price is not applied

    The only way I could get it to work was to manually press “publish” it then all worked

    Any ideas??

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author allaerd


    Hi there,

    I am looking in to this right now. Will be solved soon!

    +1, but i checked, and it’s really intrestings.
    I compera an updated product, and an imported product, and i don’t see the difference between the post meta data.

    Ok, now i’ve got it…

    When i ordered your product 3 from the Settings sapmple csv, for product with ID 38, inserted this into the post meta:
    (138, 38, ‘_price’, ‘200’),
    (139, 38, ‘_regular_price’, ‘200’),
    (140, 38, ‘_sale_price’, ‘190’),

    When i save the product, the new meta will be this:
    (138, 38, ‘_price’, ‘190’),
    (139, 38, ‘_regular_price’, ‘200’),
    (140, 38, ‘_sale_price’, ‘190’),

    So as i see, regular_price stores the original price of the product, sale price is store the sale price, and _price strores the price to show.

    And, the price is for sale only, if the _price and _sale_price are equals.
    So if you overwrite the _price with 170 in the db, on the page, 170 will appear, but not as a sale price.

    Hope it helps to fix this.

    When i ordered your product 3 from…


    When i imported your product 3 from


    Plugin Author allaerd


    price is always the price

    for normal prices

    price = regelar price = 100

    for sales prices

    price = sales price < regelar price

    Was facing the same problem and got solution to it.

    Thanks to karacsi_maci for explaining how the things are working.

    so now this is what you have to do.

    _price means sales_price ( they both would be same )

    regular_price would be cost price ( original price)

    Hope this works for everyone 🙂

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Sale Price not being updated unless manually publishing’ is closed to new replies.