Woocommerce CSV importer
[resolved] Sale Price not being updated unless manually publishing (7 posts)

  1. finleydesign
    Posted 3 years ago #


    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??


  2. allaerd
    Plugin Author

    Posted 3 years ago #

    Hi there,

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

  3. karacsi_maci
    Posted 3 years ago #

    +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.

  4. karacsi_maci
    Posted 3 years ago #

    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.

  5. karacsi_maci
    Posted 3 years ago #

    When i ordered your product 3 from...


    When i imported your product 3 from


  6. allaerd
    Plugin Author

    Posted 3 years ago #

    price is always the price

    for normal prices

    price = regelar price = 100

    for sales prices

    price = sales price < regelar price

  7. milindguitarist
    Posted 3 years ago #

    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 :)

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Woocommerce CSV importer
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.