Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Order editor with ToTalB2B please help!


Recommended Posts



order editor is a very usefull contribution, but I use ToTalB2B. This means special prices/discount per customer.


The order editor contribution only works with Separate Pricing Per Customer.


Can anybody help me out to change that part of SPPC (Separate Pricing Per Customer. ) into the TotalB2B query?



if (ORDER_EDITOR_USE_SPPC == 'true') {


// first find out the customer associated with this order ID..

$c_id_result = tep_db_query('SELECT customers_id

FROM orders

WHERE orders_id="' . (int)$oID . '"');


$cid = tep_db_fetch_array($c_id_result);

if ($cid){

$cust_id = $cid['customers_id'];

// now find the customer's group.

$c_g_id_result = tep_db_query('SELECT customers_group_id

FROM customers

WHERE customers_id="' . $cust_id . '"');


$c_g_id = tep_db_fetch_array($c_g_id_result);

if ($c_g_id){

$cust_group_id = $c_g_id['customers_group_id'];

// get the price of the product from the products_groups table.

$price_result = tep_db_query('SELECT customers_group_price

FROM products_groups

WHERE products_id="' . $add_product_products_id . '"

AND customers_group_id="' . $cust_group_id . '"');


$price_array = tep_db_fetch_array($price_result);

if ($price_array){

// set the price of the new product to the group specific price.

$product['products_price'] = $price_array['customers_group_price'];





//end sppc patch




This is a part out (product_info.php) about the TotalB2B code. Is is possible to integrade this into my order editor?




//TotalB2B start

$product_info['products_price'] = tep_xppp_getproductprice($product_info['products_id']);

//TotalB2B end


if ($new_price = tep_get_products_special_price($product_info['products_id'])) {


//TotalB2B start

$query_special_prices_hide = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " WHERE configuration_key = 'SPECIAL_PRICES_HIDE'");

$query_special_prices_hide_result = tep_db_fetch_array($query_special_prices_hide);

if ($query_special_prices_hide_result['configuration_value'] == 'true') {

$products_price = '<span class="productSpecialPrice">' . $currencies->display_price_nodiscount($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';

} else {

$products_price = '<s>' . $currencies->display_price($product_info['products_id'], $product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price_nodiscount($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';


//TotalB2B end



} else {

//TotalB2B start

$products_price = $currencies->display_price($product_info['products_id'], $product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));




Sorry for my bad english!


but thanks a lot for helping me!!!!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...