SPPC = 0

[jhsands]

I have searched for the answer... because someone sent it to me a long time ago...

but here is what I need... when I enter an item and do not uncheck "wholesale" price it enters a 0 into the database, and therefore shows 0 on the webpage.

 

What is teh script to remove all products with 0 as the price in the SPPC?

 

Also, what do I h4x0r to make the wholesale checkmark unchecked as default?

 

THX

JHS

[jhsands]

This is what the sql code gave me when I used phpMYadmin to delete the customers_group_price = 0.0000

DELETE FROM `products_groups` WHERE `products_groups`.`customers_group_id` = 0 AND `products_groups`.`products_id` = 574 LIMIT 1;
DELETE FROM `products_groups` WHERE `products_groups`.`customers_group_id` = 0 AND `products_groups`.`products_id` = 555 LIMIT 1;
DELETE FROM `products_groups` WHERE `products_groups`.`customers_group_id` = 0 AND `products_groups`.`products_id` = 554 LIMIT 1;
14 more lines...