RE: Seperate Pricing Per Customer v3.5

This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=226989#226989
----------------------------------------------------------------

There do seem to be a few bugs in the install instructions..but nothing too difficult to work around ;)

Here, Clement itemized the bugs you're talking about the best...

[quote="Clement"]Hello everybody,

Here are some problems that I found into 3.5 version for different specials for each new group:


A. In the install instructions
------------------------------------

1. At catalog/specials.php changes:

[code]Around line 80

After

    $row = 0;
    $specials_query = tep_db_query($specials_split->sql_query);
    while ($specials = tep_db_fetch_array($specials_query)) {
      $row++;

Add 

          $customer_group_query = tep_db_query("select customers_group_id from " . TABLE_CUSTOMERS . "        where customers_id =  '" . $customer_id . "'");
          $customer_group = tep_db_fetch_array($customer_group_query);

    $row = 0;
    $specials_query = tep_db_query($specials_split->sql_query);
    while ($specials = tep_db_fetch_array($specials_query)) {
      $row++;

          $customer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . $specials['products_id'] . "' and customers_group_id =  '" . $customer_group['customers_group_id'] . "'");
          if ( $customer_group['customers_group_id'] != 0)
            if ($customer_group_price = tep_db_fetch_array($customer_group_price_query))
                $specials['products_price']= $customer_group_price['customers_group_price'];[/code]


I think there must be "replace" and not "add" because if I just add the seccond part of code then I've got an arror into specials.php file.




2. For catalog/includes/functions/general.php changes the instructions say that :

[code]Around 200

After

    $select_string .= '>';

Add .......[/code]


But "$select_string .= '>';" is only in admin/includes/functions/general.php , so I think at this point all changes must be swiched to the admin/functions/general.php 



A. Runing the script
------------------------------------ 


3. The special prices for "Resellers" - not the default group - arn't displayed from the catalog/includes/modules/new_products.php


4. If I setup a special price for "Reseller" as percent, then the special price is calculated based on the default group price not as a percent from the "reseller" price.


Thank you very much for this contribution,[/quote]

Hope this helps, of course all thanks should be directed towards Clement.  ;)