Product data spontaneously changes

Jack Handy asked on January 27, 2017 16:11

Using v8.0.19

Product data is sometimes changing. Looking at the version history doesn't show a change, but we're seeing the product names and prices occasionally change in the UI. The really weird thing is that if we look at the product fields in the backend, they appear correct and if we simply open and re-save a product, the Name and Price go back to normal for some period of time until they randomly change again (usually days or weeks - hard to see a pattern).

This is really frustrating! Customers are able to add mis-priced items (they always seem to change to $0) to their carts and buy them.

Is this a known bug or something unique to our environment?

sku price data

Recent Answers

Brenden Kehren answered on January 27, 2017 17:44

Seeing how you're on a version that is over 2 years old, it would be worthwhile to upgrade to at least v9.0.50. To get to your question, do you have any custom integrations or people accessing the database directly or indirectly from another system?

Secondly, are you using versioning and/or workflow?

0 votesVote for this answer Mark as a Correct answer

Jack Handy answered on January 27, 2017 17:56

We are using versioning but not workflow.

We do have quite a bit of custom code (the way customizations were done initially - directly in the Kentico code makes upgrading impractical). Maybe I will add some logging to that code so we get some extra information any time it updates a product.

0 votesVote for this answer Mark as a Correct answer

Trevor Fayas answered on January 27, 2017 19:47

Don't forget you can use Kentico's Global Event hooks to catch any object update, may help in debugging.

Sorry the builder did so much customization in the wrong places, that does make upgrades a nightmare. Kentico has standards on where and how to customize and when followed they make upgrading easy!

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on January 30, 2017 14:17

Knowing you have "quite a bit of custom code" makes me believe there is something going on there. Secondly, I don't believe Kentico ever recommended making customizations directly on the base code, it has always been a last resort if all other methods didn't work. So you might want to start with a clean install and merge code into the instance you have to eliminate this issue and any unseen issues you will have in the future. Check out a post about upgrading and following this approach.

0 votesVote for this answer Mark as a Correct answer