SQL question... help please!
In the SQL, what controls the turning on/off of product meta title and product name?
Here is a screen shot:
http://904roofing.com/metascreen.jpg
Can somebody show me how I could write a little script I could send thru the sql patch that would flip the switch to ON for all prod meta titles?
Then another script to for flipping on all the product names?
Thanks,
Mike
Re: SQL question... help please!
You really should fix your import problem instead: http://www.zen-cart.com/forum/showth...96#post1108596
This will turn the title/prod-name switches on for EVERY product in your database:
Code:
UPDATE products SET metatags_title_status = 1, metatags_products_name_status = 1;
Use with caution. Backup your database first.
Re: SQL question... help please!
DrByte,
Words cannot express how grateful I am! This worked perfectly! If you weren't a dude I'd kiss you!:D
I totally agree with you that it would be far better to fix the import problem, but for some reason Apsona forgot to include the metatags_products_name_status field in their ShopAdmin.
Thanks again,
Mike
Re: SQL question... help please!
:D You can kiss Ajeh instead. She fixed my typo :)
Re: SQL question... help please!
aaah yes, a much more pleasant idea! :yes: