Hi all,
I'm having a problem with alot of products being disabled and having google send visitors to them which causes a redirect as the product no longer exists, I think google is penalizing me for this as traffic has haltered since disabling alot of products.
What I want to do is for all products that are disabled I want to enable them but set the quanity to '0' so that the product will exist but not allow the user to check out.
I have an idea of how to do it but i'm limited by my sql knowledge, the following in the query I want to run on all my products:-
Where product active = '0' set product active to '1' and quantity to '0'.
Can some zen cart wizard please help me out?
Bookmarks