Cannot delete Discount

@sorv Can you please make sure following:

1. There is no js error on your site in console.
2. You did not make active sale amount to 0 to remove discount.

If you need to restore prices before discount, then you can use this code:
https://gist.github.com/vidishpurohit/d1e5a9c7e486ee108bfc5ee20ad9c589

Put it on root of your site and then visit the page – https://yoursite.com/restore.php
and once the prices are restored, then you can delete this file.

Let me know if this helps.

Thanks,
Vidish

https://yoursite.com/restore.php

This Page is not found.

Once you upload restore.php on your server’s root, the yoursite.com will be url of your website.

Disccount is no more, but now there are some price crossed out.

https://www.weingut-herrenhof.de/produkt-kategorie/weisswein/

@sorv You can try clearing transients and regenerate product lookup tables under Woocommerce >> Status >> Tools

@vidish cleared Transients and regenerated Product lookip Tables. Still problem

@sorv Did you restored the prices using restore.php file? Because if that step was successfully done, then the simple products must have been fixed for sure.

Or otherwise, there could be multiple price/sale price entries in your database, which can cause this.

i did already the restore.php before

but why some of them are crossed out and other not?

This could be some issue in your database which is causing it to show discounted price. You need to check into postmeta table for any of the product with issue if you see multiple or sale prices with value.

Also, another thing, how are you appending “/l” after the price? May be that plugin or custom thing is causing an issue.

The same issue I had today and did all steps above and discounts not removed and after steps above
Products outside the selected categories have sale price with same product price and price crossed out.

Kindly provide fix even from database side.
I can see couple of reviews with the same issue.
I have big store and I can not edit products one by one.

Well, you should never change ongoing discount amount. You should first turn it off and then change it. If you don’t do it that way, then this issue could happen.

Anyways, this script should have taken care already, but may be because your store is too large, so the script might not have completed properly.

You can empty all “_sale_price” entries in postmeta table. – this will remove sale from all products.

Then try to regenerate product lookup tables.

I hope that helps.
Thanks,
Vidish

Hi,
Thanks for reply.
I didn’t change ongoing discount amount. I turn it off but it didn’t turn off. After restore.php I see products have 300 in regular price and 275 in sales in the backend but displayed on front end as both sale price and reguler price 300 with crossed out.

Would you advise remove all sale prices from all products or what the plugin changed only?

@ahmednhussein if you know which products are discounted by plugin(and if you wish to remove discount from those products only), then you can remove sale price from those products only else from all.

@vidish the plugin did something strange cross out even on product outside the discount category
Products have 300 in regular price and 275 in sale price in the backend but displayed to end user as both sale price and regular price 300 with crossed out.

I did mass update in db “_sale_price” entries in postmeta table to make it display the the correct sale price with no luck.
then did regenerate product lookup tables.

If no fix i will do full site restore from backup. but thats will be loss for data for few days.
how come plugin do action is not removable