Mixing up new items and specials on our homepage.

[Guest]

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]

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]

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