AbanteCart – UPDATE products SET status=0;

UPDATE products SET status=0;

to show on front page, set status to 1

UPDATE products SET status=1;

SELECT * FROM `products` ORDER BY `products`.`status` DESC