Majority of Products suddenly marked as on sale

  • Out of nowhere, the majority of products have been marked as on sale, and because I never had a sale price inputted they just default to 0.00 dollars. Is there any easy way to fix this? Only solution I have found so far is setting the sale schedule to the past, but I have to do that on all 4 variations of products times 50 products.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter deserttech

    (@deserttech)

    link to site : https://www.desertvapors.com

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Are these products you’ve imported in the past? Sale price needs to be an empty string, not 0. Empty string is default however.

    If you look in the database at the postmeta table, and find the meta for your sale products with meta key _sale_price, what is the value? Let me know because if it’s not blank I may be able to add a workaround. You could also change them in bulk via sql query if needed.

    If they are empty in the DB, ensure a plugin is not making products on sale.

    Thread Starter deserttech

    (@deserttech)

    No, we built all these products on the site, weve been running woocommerce for about 4 years. I managed to set the sale prices to blank and it sort of works, it just displays a price between 0 – 49.95 even though the price of zero isnt even possible on any selection.

    I had the same problem. The fix is simple. Just set the range time of the sales to days before the actual date. For example set from 01/04/2017 to 02/04/2017

    Plugin Contributor Mike Jolley (a11n)

    (@mikejolley)

    Can you provide the system status report, and screenshot me your prices and variations. I wonder if there are some hidden variations with price 0 meta.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Majority of Products suddenly marked as on sale’ is closed to new replies.