Is there a way to do this in mass for all the colors? Do I just copy the statement over and over in the .sql file and change the colors for each line?
Is there a way to do this in mass for all the colors? Do I just copy the statement over and over in the .sql file and change the colors for each line?
Set up 1 UPDATE statement per color ...
Change the options_values_id and the attributes_image ... assuming the options_id stays at 1 ...
Once you have made up your attributes_image_colors.sql file, you can load that any time ... it is pretty fast, btw, and it will update all of your attribute images for the colors ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
YOU ARE AN ABSOLUTE GENIUS!!!! You have my vote to be support guru of the century!!!
Thank you from the bottom of my heart!!!![]()
You are most welcome ... remember us on the Zen Cart Team when you are rich and famous!![]()
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
I would just like to thank Ajeh for the fantastic information and detailed steps on this subject. I am a beginner and followed Ajeh's instructions here and BAM I got exactly what I wanted. Thanks sooo much I am loving Zen Cart even though it's tough to learn I'm happy to be here because there is so much valuable and positive support.
Cheers!
~Cdnbride~
You are most welcome and thanks for the update that this was able to help you ...![]()
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!