Just to let anyone know who may have the same problem.
With my SPPC, if no price is set for that SPPC customer group, it will automatically revert back to the standard OSC price. The problem I ran into with this contrib. is that if I updated a collection that didn't have an entry for a certain customer group, the page would load "0" into each item and then put a "0" in the database for that item and customer group.
I had to change:
if ($HTTP_POST_VARS['product_new_price'][$id] != $HTTP_POST_VARS['product_old_price'][$id] && $HTTP_POST_VARS['update_price'][$id] == 'yes') {
to:
if (($HTTP_POST_VARS['product_new_price'][$id] != $HTTP_POST_VARS['product_old_price'][$id] && $HTTP_POST_VARS['update_price'][$id] == 'yes') || (trim($_POST['product_new_price'][$id]) == 0)) {
and
if (trim($_POST['product_new_price'][$id]) == '') {
mysql_query("DELETE FROM " . TABLE_PRODUCTS_GROUPS . " WHERE products_id='" . $id . "' AND customers_group_id = '" . $_POST['customers_group_id'] ."'");
to
if ((trim($_POST['product_new_price'][$id]) == '') || (trim($_POST['product_new_price'][$id]) == 0)) {
mysql_query("DELETE FROM " . TABLE_PRODUCTS_GROUPS . " WHERE products_id='" . $id . "' AND customers_group_id = '" . $_POST['customers_group_id'] ."'");
Hope this helps someone else!.
Thanks to everyone that created it.
This has saved me "HOURS AND HOURS" on updating.
Fritz