Featured Products

[chrissie]

Hi
I think I'm right in thinking that to make a product a 'featured' product, I need to tick the 'home' box on the product global information page (please correct me if Im wrong :roll:)
But is there not a simple way to add / remove products to / from the featured list? Is it necessary to go into every individual product and tick or clear the 'home' tickbox?
I bet this is really easy and I'm missing something.....?
If this has been asked about before I apologise, but I did look and couldn't find anything that matched what I was looking for.

[rocky]

You are right. The only way to add or remove featured products using the Back Office is to add or remove each of them individually to the Home category. The only alternative I can think of is to use phpMyAdmin to add or remove products from the database, but this isn't as safe as using the Back Office. You should back up `ps_category_product` before performing any queries on it, so you can restore it if something goes wrong, before attempting the below queries.

You can write an SQL query in the following format, where the first column is the id of the Home category, the second column is the id of each of the products you want to be in the Home category, and the third column is the position of the product, which allows you to change the order of products:

INSERT INTO `ps_category_product` (`id_category`, `id_product`, `position`) VALUES
(1, 1, 1),
(1, 2, 2),
(1, 3, 3),
(1, 4, 4);

If you wanted to remove all featured products and start over, you could write the following SQL query:

DELETE FROM `ps_category_product` WHERE `id_category` = 1;

[chrissie]

hmm, i think i might just do them individually. i'm not confident enough to mess around in phpmyadmin.
but thanks for your reply, appreciate it.

[allpointscovered]

Answered my question as well! They need to update the back office with a tool to turn on and off Featured Products!! Seems simple enopugh to create I would think !

New prestashop user & I love it except for little things like this ; )

Check us out: http://allpointscovered.com/catalog/