Zen Cart Logo
Forums / General Questions / phpMyAdmin to Feature Multiple Product at Once?

phpMyAdmin to Feature Multiple Product at Once?

Locked

Views: 486

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
1 Dec 2010, 6:38 PM
#1
limelites avatar

limelites

Totally Zenned

Join Date:
Jan 2009
Posts:
2,085
Plugin Contributions:
0

phpMyAdmin to Feature Multiple Product at Once?

I was about to start going through my products in admin and featuring them, one by one. However, maybe someone here knows of a quick way to do this using the product ID and a clever SQL QUERY?

I'm logged into phpMyAdmin and I've gone to the "Featured" link where I can see the ones I've featured manually from admin.

does anyone know how to add more products to the featured table using an SQL command and a list of product ID's?

I'm not looking to ad start or end times, or even price savings. Just purely wish them to be featured products, like these:

Full Texts featured_id products_id featured_date_added featured_last_modified expires_date date_status_change status featured_date_available

Edit 	Delete 	5 	961 	2010-12-01 12:50:31 	NULL 	0001-01-01 	NULL 	1 	0001-01-01
Edit 	Delete 	6 	1024 	2010-12-01 13:25:57 	NULL 	0001-01-01 	NULL 	1 	0001-01-01
Edit 	Delete 	7 	1174 	2010-12-01 13:26:07 	NULL 	0001-01-01 	NULL 	1 	0001-01-01