Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

carie

Pioneers
  • Posts

    70
  • Joined

  • Last visited

Profile Information

  • Real Name
    carie

carie's Achievements

  1. has anyone used this with sppc. carie
  2. does anyone have the additional code needed to run Easy populate with Quantity price breaks for sppc. the old code (2007) is all globals and beyond my ability to redo. I thought I could use EP to fill products then go in and edit products for price breaks and attributes, but the price break addition is throwing errors on upload. doesn't affect download. carie
  3. does anyone have the additional code needed to run Easy populate with Quantity price breaks for sppc. the old code (2007) is all globals and beyond my ability to redo. I thought I could use EP to fill products then go in and edit products for price breaks and attributes, but the price break addition is throwing errors on upload. doesn't affect download. carie
  4. Im sorry I meant this one Quick Group Discounts module for sppc http://addons.oscommerce.com/info/5569
  5. Quick Price Updates for SPPC will this update group prices for attributes as well? carie
  6. do i need to add something for easy populate now that i have QPB carie
  7. i installed QPB for SPPC and with it the add to cart button in package. now the add to cart button on product info page (only) is adding an extra item to cart. says1 adds 2, says 4 adds 5. now it only happens the first time for the item. if you have 3 in cart and add 1 more it only adds one. thanks carie i am almost out of your hair the site should have gone up last sat
  8. on upload i get 1136 - Column count doesn't match value count at row 1 INSERT INTO products_groups VALUES ( 1, 19, 97 ) i have sppc and have uploaded about 6 times successfully. then added quantity price breaks for sppc and i have errors. i havent changed any columns or settings. i exported my data to a new sheet and tried to upload it and still get error. running sppc support but not attributes or any others carie i did change my date product added from long to short in product listing or product info (dont remember exactly where) could that be it
  9. enter your product with price of zero attribute of "each" $13 attribute of "packet" = $34 you can set attribute "please select" so they must choose and use hide price if '0' so you dont have big zero in the corner carie
  10. I am also looking for something similar buy each for $10 or a bakers dozen for $120. should be a way the bakers dozen option is *12 not +/- whatever carie
  11. that works thank you dont know how i missed it (up too late) carie
  12. Iknow I have seen the answer but i can not find it now. the add to cart button on product info page (only) is adding an extra item to cart. says1 adds 2, says 4 adds 5. now it only happens the first time for the item. if you have 3 in cart and add 1 more it only adds one. thanks carie
  13. Im back again. spent hours on such a little thing. i need to sort my product option value by the value number. i already have must select installed with "please select an option" as the option value #1, and want it to be default. in product info everything i found is similar to this ( $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.attribute_sort, pa.options_values_price"); shouldn't it be by pa.products_options_values? and sppc is like this $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', attributes_hide_from_groups) = 0"); $list_of_prdcts_attributes_id = ''; $products_options = array(); // makes sure this array is empty again while ($_products_options = tep_db_fetch_array($products_options_query)) { $products_options[] = $_products_options; $list_of_prdcts_attributes_id .= $_products_options['products_attributes_id'].","; } if (tep_not_null($list_of_prdcts_attributes_id) && $customer_group_id != '0') { $select_list_of_prdcts_attributes_ids = "(" . substr($list_of_prdcts_attributes_id, 0 , -1) . ")"; $pag_query = tep_db_query("select products_attributes_id, options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES_GROUPS . " where products_attributes_id IN " . $select_list_of_prdcts_attributes_ids . " AND customers_group_id = '" . $customer_group_id . "'"); while ($pag_array = tep_db_fetch_array($pag_query)) { $cg_attr_prices[] = $pag_array; } // substitute options_values_price and prefix for those for the customer group (if available) if ($customer_group_id != '0' && tep_not_null($cg_attr_prices)) { for ($n = 0 ; $n < count($products_options); $n++) { for ($i = 0; $i < count($cg_attr_prices) ; $i++) { if ($cg_attr_prices[$i]['products_attributes_id'] == $products_options[$n]['products_attributes_id']) { $products_options[$n]['price_prefix'] = $cg_attr_prices[$i]['price_prefix']; $products_options[$n]['options_values_price'] = $cg_attr_prices[$i]['options_values_price']; } } // end for ($i = 0; $i < count($cg_att_prices) ; $i++) } } // end if ($customer_group_id != '0' && (tep_not_null($cg_attr_prices)) } // end if (tep_not_null($list_of_prdcts_attributes_id) && $customer_group_id != '0') for ($n = 0 ; $n < count($products_options); $n++) { $products_options_array[] = array('id' => $products_options[$n]['products_options_values_id'], 'text' => $products_options[$n]['products_options_values_name']); if ($products_options[$n]['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options[$n][' '] . $currencies->display_price($products_options[$n]['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } // EOF SPPC attributes mod if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> carie
  14. getting error Warning: reset() [function.reset]: Passed variable is not an array or object in /home/myacct/public_html/store2/includes/classes/payment.php on line 57 Warning: Variable passed to each() is not an array or object in /home/myacct/public_html/store2/includes/classes/payment.php on line 58 happens when an existing client enters their cart. new accounts are ok. I changed payment options and i assume it is checking past orders and seeing payments by method no longer allowed? following line 55-60 of includes/classes/payment.php $include_modules[] = array('class' => $module, 'file' => $module . '.php'); } else { reset($this->modules); while (list(, $value) = each($this->modules)) { $class = substr($value, 0, strrpos($value, '.')); $include_modules[] = array('class' => $class, 'file' => $value); carie
×
×
  • Create New...