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



