Guest Posted January 29, 2007 Posted January 29, 2007 We just finished entering a bunch of new products in our site. We had done it a catagory at a time and when we finished, all of the items displayed on our homepage in the What's New Box, in the New Products for January Box, and it the Specials Box are all from the same category! We would like this to display a mix of other catagory items that we carry. Is there a way to select what dislpays in these boxes? If so, how is it done?
davidinottawa Posted January 29, 2007 Posted January 29, 2007 We just finished entering a bunch of new products in our site. We had done it a catagory at a time and when we finished, all of the items displayed on our homepage in the What's New Box, in the New Products for January Box, and it the Specials Box are all from the same category! We would like this to display a mix of other catagory items that we carry. Is there a way to select what dislpays in these boxes? If so, how is it done? well - without messing around with the select statement from the includes/modules/new_products.php file, you could update the table products_date_added, and products_last_modified within the products table to insert different/random dates : update products set products_date_added = '2006-11-29 08:48:58' where products_id between 1 and 20 next statement : update products set products_date_added = '2006-12-01 08:48:58' where products_id between 21 and 40 and so on, and so on, and so on, and so on. david
satish Posted January 29, 2007 Posted January 29, 2007 Add a field in the admin saying flagforhome. In admni modify code for products that will allow it to be set to 0 or 1. In user change the query a bit so that it takes products with flagforhome as 1. Regards, Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.