Mystery - Products being disabled??

This is the strangest thing I've ever seen. I have a customer site that without user intervention - products are randomly being disabled. I've checked all the stats and the server is not breached - We just did a complete inventory at 10:am and both of us checked the categories for # of products enabled. Within one hour two products were suddenly disabled - again. I feel sorry for the customer, as she was writing me she went back to the admin to grab the product ID to put in my email, another had been disabled. She's nearly in tears. It's as if there is a ghost in the system.

Has anyone ever heard of such a crazy thing? We initially built this system in 1.3.5 and all was well. Since we've upgraded to 1.3.7 this has been happening.

Originally I thought the store owner was clicking something in error, but today I am watching all the logs like a hawk and nothing in the admin logs even indicates that these products were edited.

Any ideas? :wacko:

Could this have anything to do with the inventory control system? So if the products are purchased, and the number in inventory go to 0 the product turns off???

JP

I would love it if it were that simple. First I have inv. control turned off, but in addition to that all products have an inventory quantity of 1000.

There were a lot of changes to how these products were setup, linked etc over the last couple of months. So I'm going to unlink everything. Run an optimize on the db and do an overall clean up and see if that stops it. The changes happen right before your eyes!! It's wild to watch....LOL... but the customer is having a breakdown so not so fun.

Thanks for the thought though... I do appreciate any thoughts towards this mystery.

( Ruth - totally OT - the dog's name is Zen? That's too cool! )

My husband said I spent so much time on my Zen-Cart shops it was only fitting... he's so cool... (the dog) He brings me his lead while I'm working...just cracks me up. It's only way to get me away from this computer.

:laugh:

Gotta' love it!

On your mystery- are these products listed as specials

Hello Zen. Such a handsome Zen. Yes you are....yes you are...

Sorry, I just couldn't help myself. Anyway, just as a test, change the password and see if it stops.

JP

By the way... he is a really pretty boy!!! Sweet too!!

Are you thinking someone "is" sneaking in? It's really driving me nuts. The only thing i can think of to do is delete all the products (and there are a ton) and re-input them.

By the way Kim... none are specials. First thing I looked at. Nothing set to expire. Like I said, its the strangest thing I've ever seen. I see nothing abnormal in the db, but I know things can get out of wack and you really can't see it looking at the data.

You don't have any play sites or anything that you test with that might be attached to that database ... correct?

No add-on programs to help manage stock or anything like that?

No this is a live customer site. It has its own db, not shared and no other apps running. It's just too weird.

I was working with her trying to create a reference list for myself on what was "on" and what was "off" she is the manufacturer so she can control her stock. If something is no longer available, she turns the product off until it is available again. A good example are seasonal products. We never had this issue at all until I upgraded her to 1.3.7. Prior to that all was good.

We had a lot of products cross linked into two different directories. I spent the afternoon removing all the links and verifying that the master ids were in fact correct. Two products were disabled in another directory right while I was working. I knew there were 90 enabled products and when I looked there were 88.

I'm going to optimize the db and making sure all is set perfect again and then check again in the am and see what we have.

Things seem to be stablizing. This is what I “think” was happening but still to be proved out over the day. This is what I wrote to my customer - thought I would post this for others.

"The system is very complex with a lot of code and instructions in the background telling it what to do. But just like anything else if we start to give it too much conflicting information, it can start to fail. Even though in “theory” this is possible, I don’t think the system really handles certain situations as well as we would like.

We had Seasonal candles as a category “turned off”, but we had selected items within that category linked and turned on in regular candles. Plus I have the scent filter working in the background. So …. It’s saying this item is turned off here, but on here – I think it just started to give the db a stroke…LOL

Now that doesn’t mean we can’t link products. But I think in the future, if we decide to re-link the seasonal products to the main, we should only link those that are going to be on or off per season. If a candle to be on all year round, the we will move it to the main and just during the season, link it to the seasonal candles while that category is “on”. When we turn it off, kill the link first. This is where custom coding can start to effect core code that we can’t see and as there are millions of lines of code, nearly impossible to know all the ramifications of our changes."

Now how that might be relevent to others here, is that I often see posts about hidden categories and can a category be turned off, but a product turned on - It is theoretically possible to do that, but be aware that too much conflicting information can start to create problems. I am a testiment to it. That is especially true if you have a lot of custom code and or modifications to the system. Custom features are great, we all love them, but sometimes there is a big price to pay. I always warn my customers... yes, it might be possible, but...problems in the future may arise that we just can't predict... thus my system randomly deciding to turn products on and off at a whim.

I will post one last report on this post at the end of today or tomorrow as to whether this was in fact the solution, but all has now been stable for the last two hours with no grimlins...:clap: