Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

fritzsmith

Archived
  • Posts

    2
  • Joined

  • Last visited

Profile Information

  • Real Name
    Fritz Smith

fritzsmith's Achievements

  1. 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
  2. Setting the category not to default to "inactive" after editing. Monika's code seemed to have been modified from the original. Mine looked like the below. // ####################### Added Categories Enable / Disable ############### // $sql_data_array = array('sort_order' => $sort_order); $categories_status = tep_db_prepare_input($HTTP_POST_VARS['categories_status']); $sql_data_array = array('sort_order' => $sort_order, 'categories_status' => $categories_status); // ####################### End Added Categories Enable / Disable ############### I commented out all the lines and it seems to work fine now. // ####################### Added Categories Enable / Disable ############### // $sql_data_array = array('sort_order' => $sort_order); // below 2 lines commented out to default for category status to remain the same // $categories_status = tep_db_prepare_input($HTTP_POST_VARS['categories_status']); // $sql_data_array = array('sort_order' => $sort_order, 'categories_status' => $categories_status); // ####################### End Added Categories Enable / Disable ############### I've been looking for how to do it for weeks. All credit goes to Monika. Thank you, Thank you
×
×
  • Create New...