Sales tag displays when there is no sale

Site link? When you update the product itself, prices are synced

spiderflystudios.com

What do you mean by synced? They definitely didn’t sync in any way.

Again… The product was on sale. I edited it and removed all variations. When I completely redid all the variations, none of them had a sale price filled in. I saved the product and checked it out on the site. The sale tag was posted and the listed original prices were identical to the sales prices. The only thing that makes sense is that it is some kind of bug. I since had to set that product to be on sale so it wouldn’t cause issues. Looked odd being marked as in sale without actually being so.

Well can you remove that sale price and provide the link so I can check the source?

Sorry for the late reply…didn’t notice this…

I’m not new to this…I have removed the sale price. There’s nothing there. I have even deleted every single variation and create whole new ones. I even deleted the product and set it again via copy to new draft. Saved it as a different slug too. I have nothing set to be on sale for that product. I’m not getting this in any of my other products. It is only happening on this specific one. Like I mentioned before, it happened after I deleted variations that still had a sale price set in them. Logically all the info attached to them should have been gone as well. Then I created the new variations and boom….sale tag still there. Now, if I set a sale price for the new variations, that is reflected…but when I remove them to reset, it goes back to applying the sale tag and listing the sale price the same as the regular price. It’s like something is stuck in the database.

actually…now I am seeing it on more and more items. All have the sale tag without having a sale price or date or anything else in those fields set.

In my functions file, I do have code set to display things like that using $product->is_on_sale()

did something change so that no longer works and makes it look like things are on sale? That’s the only thing I can think of.

I hid that part of the code and the issue is still there. So things are still acting like everything is on sale despite not being on sale. :/

Ok….after I tried all that…the theme I was using finally updated so I could update WooCommerce to the new major update. If I go in and save the items it clears the issue. I’ll leave this open for a couple more days to make sure the issue is gone before marking it as resolved. Looks like the update cleared whatever was stuck in the database when it did the optimization after updating.

Hey Kahil,

Sounds like the theme may have had an issue in it and the update helped resolve it. Could you post what theme you are using for future reference?

It definitely wasn’t a theme issue as neither woocommerce nor the theme been updated or modified in any way when this happened. I think it was just a random bug where something in the database got stuck as marking products on sale. The moment it happened was when I deleted variations while they had sale prices and date ranges set. I updated the theme, Enfold, tonight first, then checked…issue was still there. Only after I updated woocommerce and did the database update it requested did the problem go away.

I’ve seen a similar issue like this in the past, but I can’t recall what fixed it.

Let me know if the issue creeps back up, otherwise feel free to mark this as resolved when you see fit ??

I upgraded to woocommerce 3.0.4 and now all my products are listed as “on sale” but the prices are all still the same, yet the sale badges are listed on all items. This happened directly after the woocommerce upgrade.