Mystery - Products being disabled??

[rwoody]

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?

[birdoasis]

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

[rwoody]

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.

[Kim]

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

[rwoody]

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.

[Kim]

Gotta' love it!

On your mystery- are these products listed as specials

[birdoasis]

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

JP

[rwoody]

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.

[Ajeh]

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?

[rwoody]

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.