ishtek Posted July 16, 2005 Share Posted July 16, 2005 Thanks for the info. This should help. Would I make the change in all files or just the product_info.php file? Quote Link to comment Share on other sites More sharing options...
wheeloftime Posted July 16, 2005 Share Posted July 16, 2005 Thanks for the info. This should help. Would I make the change in all files or just the product_info.php file? <{POST_SNAPBACK}> As you described it only in product_info.php but you should just check if the display_price() function is used anywhere else also with this contrib. If that is the case make sure the productid is added as first parameter. Quote Link to comment Share on other sites More sharing options...
ishtek Posted July 16, 2005 Share Posted July 16, 2005 Nevermind. I tried it and it worked. Thanks! This was a HUGE help. Quote Link to comment Share on other sites More sharing options...
EidolonNight Posted July 27, 2005 Share Posted July 27, 2005 Hello, Can anybody tell me how to prevent one group of items (such as a gift certificates) from being discounted for my wholesale group. They may be purchaced by anyone but their value must stay the same no matter who is logged in. I am also trying to figure out how to give a price break like this: Item = $18.00 similar item = $18.00 when purchased together each one would be $15.00 I would like this to be true if any number (more that 1) of these same or similar items are purchased at once. Quote James Tomasello Link to comment Share on other sites More sharing options...
Dr. DK Posted July 29, 2005 Share Posted July 29, 2005 I have installed the contrib, but I am having problems where in my ADMIN I only see TotalB2B under configuration and once I click it it's empty??? Any suggestions??? Am I supposed to get it somewhere else? I am also using STS on MS2. HELP PLEASE! :-) Thanks in advance! Quote ----------------------------------------------------------------------- Sincerely, Dr. DK Link to comment Share on other sites More sharing options...
Versandhaus Posted August 22, 2005 Share Posted August 22, 2005 Hi, is it possible to be switch during registration as austria on price 2 and during registration as switzerland on price 3 and so on... an maybe is it possible to switch on price xx if i changend the language from default to xx (default price = 1 , default language = german , if i change to austria then switch default price 1 to price 2) Thank you to everyone olli Quote Link to comment Share on other sites More sharing options...
Versandhaus Posted August 28, 2005 Share Posted August 28, 2005 hi, i just tried to update from 1.2b to 1.4 i have the following mods: ship2pay_1.5 (so my groups settings wont work right in Version 1.4) ship in cart 1 alpha and there is the prop now in version 1.4 with this mods. in ship in cart1 shows me an error if the customer is not in the default group: include/functions/general on line 42 : return htmlspecialchars($string); Does anybody ve an idea what can i do? Please help me.... thanx Oliver Quote Link to comment Share on other sites More sharing options...
deeltje Posted August 29, 2005 Share Posted August 29, 2005 as soon as i want to add an item to the shoppingcart it gives me the following error: Fatal error: Call to undefined function: tep_xppp_getproductprice() in /var/www/html/product_info.php on line 78 can anyone help me with that? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 1, 2005 Share Posted September 1, 2005 How long did it take for you guys to install this mod? I started to install it but gave it up, I've got a heavily modded shop and just got errors. Is there any plans to make a more user friendly install sheet? Quote Link to comment Share on other sites More sharing options...
wheeloftime Posted September 1, 2005 Share Posted September 1, 2005 as soon as i want to add an item to the shoppingcart it gives me the following error: Fatal error: Call to undefined function: tep_xppp_getproductprice() in /var/www/html/product_info.php on line 78 can anyone help me with that? <{POST_SNAPBACK}> Have you added //TotalB2B start function tep_xppp_getmaxprices() { //max prices per product return 10; } function tep_xppp_getpricesnum() { $prices_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'XPRICES_NUM'"); $prices = tep_db_fetch_array($prices_query); return $prices['configuration_value']; } function tep_xppp_getpricelist($ts) { $prices_num = tep_xppp_getpricesnum(); for ($i=2; $i<=$prices_num; $i++) { if ($ts != NULL) $price_list .= $ts . ".products_price_" . $i . ","; else $price_list .= "products_price_" . $i . ","; } if ($ts != NULL) $price_list .= $ts . ".products_price"; else $price_list .= "products_price"; return $price_list; } function tep_xppp_getproductprice($products_id) { global $customer_id; $customer_query = tep_db_query("select g.customers_groups_price from " . TABLE_CUSTOMERS_GROUPS . " g inner join " . TABLE_CUSTOMERS . " c on g.customers_groups_id = c.customers_groups_id and c.customers_id = '" . $customer_id . "'"); $customer_query_result = tep_db_fetch_array($customer_query); $customer_price = $customer_query_result['customers_groups_price']; $products_price_list = tep_xppp_getpricelist(""); $product_info_query = tep_db_query("select products_id, " . $products_price_list . " from " . TABLE_PRODUCTS . " where products_id = '" . $products_id . "'"); $product_info = tep_db_fetch_array($product_info_query); if ($product_info['products_price_' . $customer_price] == NULL) { $product_info['products_price_' . $customer_price] = $product_info['products_price']; } if ((int)$customer_price != 1) { $product_info['products_price'] = $product_info['products_price_' . $customer_price]; } return $product_info['products_price']; } //TotalB2B end to your catalog/includes/functions/general.php ? Quote Link to comment Share on other sites More sharing options...
danthman Posted September 13, 2005 Share Posted September 13, 2005 I installed Total B2B in a fresh install and get the following or similar message in several areas of the admin section such as Customers>Orders, Customers>Manu Discount, Reports>Products Purchased, Reports>Customers, Reports>Products Purchased, Reports>Customers Orders Total What did I do wrong? I am very new at MySQL and would appreciate some advice. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1 select o.orders_id, o.customers_name, o.customers_groups_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 [TEP STOP] Quote Link to comment Share on other sites More sharing options...
hozone Posted September 13, 2005 Author Share Posted September 13, 2005 I installed Total B2B in a fresh install and get the following or similar message in several areas of the admin section such as Customers>Orders, Customers>Manu Discount, Reports>Products Purchased, Reports>Customers, Reports>Products Purchased, Reports>Customers Orders TotalWhat did I do wrong? I am very new at MySQL and would appreciate some advice. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1 select o.orders_id, o.customers_name, o.customers_groups_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 [TEP STOP] <{POST_SNAPBACK}> several version of MYSQL doesn't support the sintax LIMIT -20, 20 to fix there are 2 way: 1) uprade mysql 2) just REPLACE LIMIT $value_page_start, $per_page (or other variables names) with LIMIT $per_page . so that u will have 1 variable. :thumbsup: Quote osCommerce Italia support: http://www.oscommerceitalia.com Link to comment Share on other sites More sharing options...
danthman Posted September 13, 2005 Share Posted September 13, 2005 several version of MYSQL doesn't support the sintax LIMIT -20, 20to fix there are 2 way: 1) uprade mysql 2) just REPLACE LIMIT $value_page_start, $per_page (or other variables names) with LIMIT $per_page . so that u will have 1 variable. :thumbsup: <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
danthman Posted September 13, 2005 Share Posted September 13, 2005 Where do I do that? I cannot find that text on the admin/orders.php page? Quote Link to comment Share on other sites More sharing options...
danthman Posted September 13, 2005 Share Posted September 13, 2005 several version of MYSQL doesn't support the sintax LIMIT -20, 20to fix there are 2 way: 1) uprade mysql 2) just REPLACE LIMIT $value_page_start, $per_page (or other variables names) with LIMIT $per_page . so that u will have 1 variable. :thumbsup: <{POST_SNAPBACK}> Where do i do that? Which page? I have searched the pages in Total B2B and cannot find that text. I am new to php and Mysql. Quote Link to comment Share on other sites More sharing options...
hozone Posted September 20, 2005 Author Share Posted September 20, 2005 Where do i do that? Which page? I have searched the pages in Total B2B and cannot find that text. I am new to php and Mysql. <{POST_SNAPBACK}> u have not to search totalb2b, but your standard osc shop code. Quote osCommerce Italia support: http://www.oscommerceitalia.com Link to comment Share on other sites More sharing options...
hozone Posted September 20, 2005 Author Share Posted September 20, 2005 unfortunatly this contribution has no longer downlodable, cause i make uncorrect references to oscommerceitalia.com in readme files of this contribution. does someone of you know where can i find the rules to write contributions Readme files? i've to rewrite it, and then i'll repost the cotribution thank you all Quote osCommerce Italia support: http://www.oscommerceitalia.com Link to comment Share on other sites More sharing options...
Cowzor Posted September 20, 2005 Share Posted September 20, 2005 I sure hope so, I was just going through my page-long list of contributions to add and found it wasn't there anymore! Quote Link to comment Share on other sites More sharing options...
Jeppe Jensen Posted September 25, 2005 Share Posted September 25, 2005 I just checked, but I cannot find any rules regarding the readme files on the osCommerce site. I am sure they are there somewhere, maybe in the GNU licence? Please let me know when you repost this... Quote Link to comment Share on other sites More sharing options...
hozone Posted October 3, 2005 Author Share Posted October 3, 2005 this contribution is again in downloads @ this link: http://www.oscommerce.com/community/contributions,3613 :thumbsup: Quote osCommerce Italia support: http://www.oscommerceitalia.com Link to comment Share on other sites More sharing options...
shaytaan Posted October 3, 2005 Share Posted October 3, 2005 this contribution is again in downloads @ this link: http://www.oscommerce.com/community/contributions,3613 :thumbsup: I'm sooo glad it's back again..thanks I wanted to download/install it but it was gone.. Before starting with installation I have some questions: Will it work correctly? I have these contributions installed on standard ms2 : * Credit Class & Gift Voucher * POINTS AND REWARDS MODULE * Purchase Without Account * Anti Robot Registration Validation * and some others... THanks again Quote ?,???`???,?? God must love stupid people, he made so many ??,???`???,? Link to comment Share on other sites More sharing options...
hozone Posted October 6, 2005 Author Share Posted October 6, 2005 I'm sooo glad it's back again..thanksI wanted to download/install it but it was gone.. Before starting with installation I have some questions: Will it work correctly? I have these contributions installed on standard ms2 : * Credit Class & Gift Voucher * POINTS AND REWARDS MODULE * Purchase Without Account * Anti Robot Registration Validation * and some others... THanks again thanks to u. i suppose it can work with the cntribution u tell me, without big problems, but i don'tknow all the contributions you ask me, so i can't be sure of this. anyway, i think with a little coding it can works! B) good luck :thumbsup: Quote osCommerce Italia support: http://www.oscommerceitalia.com Link to comment Share on other sites More sharing options...
Guest Posted October 13, 2005 Share Posted October 13, 2005 Hi The conribution Total B2B is working fine on my test site. No problems there. But in my shop, I have two diffrent types of discount calulations. The first is the standard from the Total B2B contribution with fixed discount value connected to the client and product group. This is used for my special clients. This discount have 0% - 25% - 30% - 35% - and 40% values The second is the regular clients. They should have a discount % depending how many items they order. For example: 1 pc = 20% 2 pc = 25% 5 pc = 30%. Is this possible to solve and mixeing together with Total B2B? thanks Quote Link to comment Share on other sites More sharing options...
hozone Posted October 13, 2005 Author Share Posted October 13, 2005 HiThe conribution Total B2B is working fine on my test site. No problems there. But in my shop, I have two diffrent types of discount calulations. The first is the standard from the Total B2B contribution with fixed discount value connected to the client and product group. This is used for my special clients. This discount have 0% - 25% - 30% - 35% - and 40% values The second is the regular clients. They should have a discount % depending how many items they order. For example: 1 pc = 20% 2 pc = 25% 5 pc = 30%. Is this possible to solve and mixeing together with Total B2B? thanks if i remember well, there should be a ot_total contribution to calculate this type of discount. the problem doing this with totalB2B is: image i buy 1 mouse and i see it at 8USD (with 20% discount) now i buy 1pen XUSD (25% discount). now i see the mouse price, and it's 7.5USD (cause now i've 25% discount), this would be "strange". Quote osCommerce Italia support: http://www.oscommerceitalia.com Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2005 Share Posted October 20, 2005 Hozone... Been looking at the admin side: invoice, packing slip, order history, .... Seems more complex to get the prices AND product atributes discounted by a group discount. Thinking about making some test mods (backup first!), and actually put the discounted price of products & products attributes into the orders tables in the data base intead of applying the discount every place an order is displayed. It seems that this would be more accurate. It reflects the prices charged to a customer at his group discount rate at the time of his order instead of his rate at the time of display (I think)... I would then remove all mechanism where the discount is applied to the price displayed (currencies->display_price(...) ) Your thought????? Has anyone ever got this issue resolved? I have Group Discount installed and have the same issue where it shows the discounted price in the Product Info page, but the e-mail invoice and Admin invoice both show the attributes at the regular price. Total calculated price is correct. Maybe I just need to figure out how to NOT show the attribute price in the e-mail or Admin invoice. Sure would be nice though. :) If anyone has solved it for B2B, I'm pretty sure the changes would be similar in Discount Groups, as the code is similar for much of this. Thanks for any help you can provide! John Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.