Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

carie

Pioneers
  • Posts

    70
  • Joined

  • Last visited

Everything posted by carie

  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
  15. I forgot this part. from a former post. Here is what you need to do. This is with the branched version of the short description that has the short_desc field in the products table. 1. Modify the catalog\includes\classes\shopping_cart.php In function get_products() there is a $products_array[] that returns all fields for manipulation. Add in this array a line like this: 'short_desc' => $products['short_desc'], In my case I have it below the products name. 2. Modify the catalog\shopping_cart.php Locate this code $products_name = '<table border="0" cellspacing="2" cellpadding="2">' . ' <tr>' . ' <td class="imageFrame" align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">' . tep_image(DIR_WS_IMAGES . $products[$i]['image'], $products[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>' . ' <td class="productListing-data" valign="top"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '"><b>' . $products[$i]['name'] . '</b></a>'; and replace it with this code $products_name = '<table border="0" cellspacing="2" cellpadding="2">' . ' <tr>' . ' <td class="imageFrame" align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">' . tep_image(DIR_WS_IMAGES . $products[$i]['image'], $products[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>' . ' <td class="productListing-data" valign="top"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '"><b>' . $products[$i]['name'] . '</b></a><br>' . $products[$i]['short_desc']; *****All I did was to Add the short_desc field at the end in a new line. In case you have other contributions installed just extract the last part of the code only (from the <br> tag) and append it on your custom code.
  16. this thread is listed on the very first version of that contribution. i would see about getting it removed. there are many posts on this thread concerning that one and it is really confusing. i am going to add to my last post ,i left something out. then im gone. carie
  17. for short description in shopping cart. http://www.oscommerce.com/community/contributions,3123 SHORT_DESCRIPTION_V2.2-RC2 with this additional download "put short desc in cart 25 Feb 2008" works. (even with sppc) carie
  18. this was taken from the osc contribution Products Short Description This will allow you to enter a short description of your products that can be viewed by your customers through the listing pages on OSC. It will add another feild to your database and your Product Edit page for you to fill in. Works great, you may need to modify the design for your likings, but there are no bugs that i can see yet Support Thread : http://www.oscommerce.com/forums/index.php?showtopic=145921&st=0&p=595307entry595307 Expand All / Collapse All Products Short Description v.2.2.1 for Featured Products 20 Jul 2009 .... SHORT_DESCRIPTION_V2.2-RC2 <---- this is what I installed so am i to understand by your "Hijacking threads " statement that this is no longer the support thread for this contribution? I included my major addons because they often will affect the answer to the question i am asking. post # 67 on this thread addresses what i am looking for. that was in 2005. does anyone have the above contribution working in their shopping cart? or has this thread been Hijacked? carie
  19. i hope that made you laugh. i was so very confused. i tried changing the 2 to a one yesterday but then uploaded the general file to admin so it really didnt work and i didnt find that error till this morning. thanks again. carie
  20. Ok this does work perfectly thank you question - in "my php admin" on the customers groups table 0=retail, 1=wholesale. in "osc admin" at bottom of customer list it says Customer Group No. Retail 4 Wholesale 2 what? how? where is 2& 4 used and obviously 0&1 are used in cat/incl/funct/general. I know the 2& 4 happened when i first started naming the groups and deleted and renamed ect. if i create a third group will it be 5 in admin and 2 in php table? carie
  21. the latest what? product short description v2.2.1 - i dont have featured items Product Description 1.3 - didnt find it till after the other was in, there is no mention of another version as seperate contribution, and i liked the seperate description rather than truncated version instructions for entering in cart - those were the latest i found carie
  22. I had no shipping mods show up, so I got the error. went back to admin and reselected shipping mods. and it worked fine. also had a problem in last few days, i dont remember specifics but I shut everything down and came back next day and it was gone. like when an error gets stuck in cache. Im sure you have tried these in the time since your post but it seems to be the easiest things that are hardest to get answers to. carie
  23. I have installed Version 1.2 on RC2a with SPPC, additional images, and a ton of little modifications. I have to say the instalation of this add on has been the easiest, pain free and completely error free of any i have done :thumbsup: having said that, I do not have any credit card or shipping mods operating with it which appears to be where problems arise. what i need is a print function at checkout success that prints whole order. any one have one installed that works? I am running out of time, store goes online this sat. thanks carie
  24. I have v.2.2 installedon RC2a with SPPC, Additional Images v2.1.1, and some others. It works great on my new products page. I have products list in columns and didnt want a desc so I didnt add it to that file. I need short description in shopping cart! I have installed the instructions from 2005 post #67. no worky >_< any ideas? my store goes online saturday and i need this to work. carie
×
×
  • Create New...