Group Pricing Per Item Issue

[DrByte]

It appears there's a piece of code missing in the contribution.

/includes/classes/shopping_cart.php

Go to line 1093.
Copy lines 1093-1101 to clipboard:

    if($_SESSION['customer_id']) {
      $customer_group_query = "select gp.group_name
                                from " . TABLE_CUSTOMERS . " cu
                                left join " . TABLE_GROUP_PRICING . " gp on cu.customers_group_pricing=gp.group_id
                               where cu.customers_id = " . $_SESSION['customer_id'];
      if($customer_group = $db->Execute($customer_group_query)) {
        $customers_group=$customer_group->fields['group_name'];
      }
    }

Go up to line 613 and paste it in there, right after this line

    if (!is_array($this->contents)) return 0;

[philnm]

THANK YOU, THANK YOU!

Working perfect now. Sure appreciate it!

[delia]

new issue!

I have a cart that used this last year and we are gearing up for this year but it no longer shows the group prices. Same files, same database but different server. I've got lots of sites on the new server and have had no problems with any of the zencarts except for the mysql 5 and php5 changes. Everything else in the cart is working fine.

Anybody got any idea why it wouldn't be working?

[delia]

well, I fixed the problem by upgrading the cart and putting in the 1.3.8 mod instead and now everything works after putting the shopping cart fix in. I'm going to package it back up and upload it to the contributions section so no one has to worry about this again.

[kwright]

Hi All,

I too just installed this mod to Zen 1.3.8a and I'm having the same issues as knights2!

I receive the below warning when adding or editing a product in admin and don't see where the other pricing info goes.

Warning: Invalid argument supplied for foreach() in ...\admin\includes\modules\product\collect_info.php on line 398

Any thoughts?

Thanks

[kwright]

OK,

It helps if one would finish reading the instruction (It's a guy thing!).

Once you add the group names (Group A, Group B, ...) to the group pricing module, the warning goes away and the pricing fields display!

Sorry for the interruption!

[kwright]

OK, I have an idea that others may be interested in!

I would like to add the ability so when a customer is logged in and viewing their group pricing a text label would appear next to their price.

Ex: Wholesale Price: $19.95

I guess this could be done a couple of ways...

1. Either change the Group A define text to the name you wish to display next to the price and add that define in the price display code. (I think this might be the easiest way, but would have to edit files)

OR

2. Create a method of adding the price labels within the group pricing admin module independent of the Group A defines, then add this to the price display code. (More user friendly, no files to edit, but more complex)

Either way, I don't mind doing the work (with help), I just need some suggestions / guidance as to where best to add such a mod and to which files?? I'm marginally familiar with the Zen structure and PHP/MySQL

May be I could also add code to display the regular non-group price along side the group price (including the text labels) as well!

Dr. Byte, what do you think?

Thanks

[HappyMom]

Hello,

Someone posted the thread/question below:

My discount prices with this mod work fine. However, what isn't working is that for anyone assigned to a group (I just have one group assigned right now - Group A), the Specials I've set are not working properly.

The Specials are not products that are affected by group pricing - they are separate products.

For those customers in Group A, the correct price shows up until they go to check out, at which point the price reverts back to the original price, rather than the sale price.

And I understand that this is how the group pricing was designed to work, but I actually want my Group A/B/ect to receive the sale discount on products for which they are not getting any special Group A/B/etc discount.

For instance:

Product 1:
Regular Price: 10.00
Sale Price: 8.00
Group A price: 5.00
In this case, my Group A customers gets the $5.00 Price. This is OK. No Change required here.

Product 2:
Regular Price: 20.00
Sale Price: 10.00
Group A Price - Does not exist -> revert to regular price In this case, I want my Group A customers to get the $10.00 Sale Price.

What files should I change? or where do I start?

Any help would be greatly appreciated it.

Thanks!

[mshultise]

-- Background --

The owner sells products within the state of Hawaii and most people will pick the items up at her physical address. Some people *may* have the products shipped within the state. Because of shipping costs, no shipments will happen outside the state.

There will be Retail and Wholesale customers with different prices.

I have configured this module and all seems fine but... (you knew there was a but coming, right?)

So I have Retail (regualr Prices) and a new group called WHOLESALE. Wholesale customers will be manually added to the group and will receive the lower price.

The problem is that Wholesale users pay a lower sales tax than Retail customers. retail tax is 4.1666 percent while Wholesale is .5 percent (point five percent).

Once I set the customer into the Wholesale group, how can I charge him a different sales tax? (By the way, I created 2 different sales taxes already) but how do I apply it here?

[FuzzyBunny]

setup two shipping zones / rates

one zone would be hawaii - retail
the other hawaii - wholesale

each zone would have a different tax rate

just treat it the same as a different state and when the customers are added the correct "zone" needs to be applied,

hope this helps