Special Products beforNew Products of the month and delete product with quantity zero

Question 1) I would like that in "Home Page" the Specials Products must position befor the new products of the month..... which file must change? and how it edit?

Question 2) I would like to delete from the database all products with quantity equal to zero.....exists a fast method?

P.S. Excuse me for any grammatical errors! I'm italian! :P

To sort the Centerboxes ... go to the Configuration ... Index Listing ...

There are "sets" of centerboxes that you can sort ...

0 means OFF and any other value is the Sort Order to display order of the centerboxes ...

To completely remove from the database all products with a products_quantity of 0 ... it is really safer to do via the Admin as there are many database tables associated with each Product and the Admin delete of a Product will manage this for you ...

How many Products do you have that you want deleted?

Our company has a supplier who will send us their database as a text file which contains many products with quantity equal to zero and i use EasyPopulate for to add the products in my database. Now, i would like to delete all products with quantity to zero..... it is possible to do via the Admin ??? or else, if i make a PHP programm for to delete all this products, which database tables i must consider?

I hope is all clear!

It would be best to write a program to delete the product based on the delete routine that a standard delete makes ...

If you are importing a file with quantity 0 ... can't you just delete those before you import? :unsure:

Ajeh:

It would be best to write a program to delete the product based on the delete routine that a standard delete makes ...

If you are importing a file with quantity 0 ... can't you just delete those before you import? :unsure:

:sleepy: Bhè! Yes! But i had to think to us before adding the products! By now i have make the damage! :P

You might peek at the file:
/admin/includes/modules/delete_product_confirm.php

NOTE: Backup your database before you try to apply your own script to clean up the database tables ...