Buying into a membership group and discount pricing per item.

I am trying to set up the site to have 2 user group levels (public w/no discount & member w/discount) which have group pricing on a per item basis. Ideally, the website would sell the membership and handle the user groups automatically. Im trying to avoid reinventing the wheel here and did some minimal poking around and found several threads where such functionality had been asked for, however, Ive not found a definite answer. If there is something anyone can point me to it would be greatly appreciated.

Currently I am looking at using the Group Pricing (per item) add on to set this up. One problem is that it would leave the admin to setup the user groups, and it creates a delay between purchase of the membership and the time they get a discount. I had thought of a potential solution to this by creating a downloadable file for a one month temporary membership card that would have a discount code they could use to get the member price. Am I going down the right path with this or am I chasing my tail?

I second that request.

I'm trying to accomplish something similair. I'd need the groups to be set automatically when the customer enters a number (which they get from a membership card) and their name.

Then they should automatically be added to a certain group discount.

Any easy way to accomplish this??

Tino

I am looking for this also. I am doing it manually right now and also need a way to leave out some catagories.

I have been looking around here and have NOT found anything that involves "Buying a membership" feature. Below is what I want the area to do.

What I would like to do is have a retail that you don't need a membership and a wholesale area that you need a membership. Is there a feature that I can automaticely have the wholesale area created when payment is taken for the membership. I want to have a login in area for the wholesale membership.

Does anyone know where I can find this on Zen Cart if we have it?

Thank you very much

:smile:

Quote:

---

Originally Posted by Omen3891

I am trying to set up the site to have 2 user group levels (public w/no discount & member w/discount) which have group pricing on a per item basis. Ideally, the website would sell the membership and handle the user groups automatically. Im trying to avoid reinventing the wheel here and did some minimal poking around and found several threads where such functionality had been asked for, however, Ive not found a definite answer. If there is something anyone can point me to it would be greatly appreciated.

Currently I am looking at using the Group Pricing (per item) add on to set this up. One problem is that it would leave the admin to setup the user groups, and it creates a delay between purchase of the membership and the time they get a discount. I had thought of a potential solution to this by creating a downloadable file for a one month temporary membership card that would have a discount code they could use to get the member price. Am I going down the right path with this or am I chasing my tail?

---

I need exactly the same thing too. I am also doing it manually, but I need this to be automatically, once they purchase the membership.

I was thinking that to do this, I would had to add code that basically says: if the product that you purchase is "BLA", then update the customer's group pricing. The problem I have is that I am not very familiar with how checkout process.

Is this a buy once and forever in the Group?

Or, is this based on buy once and in the Group for a time period?

Quote:

---

Originally Posted by Ajeh

Is this a buy once and forever in the Group?

Or, is this based on buy once and in the Group for a time period?

---

would be nice to have it set to a time period, but a buy once would work for me.

For right now, "Buy once" and forever in the group would be good.

At some point, I would also like to automatically deactivate the memberships, since my memberships last for one year, but I know that this will also require changes to the customer tables (additional tables to set the time frame for their membership), but if you could give me some ideas, e.g. list of files to look into, that would also be great.

Thanks!

You can customize the purchases on the orders class where the stock is adjusted and when someone buys a given product they are added to a Group ...

You can also customize the function for adding to the cart to disable the ability to buy a Product based on the fact it was already purchased so someone cannot buy twice ... if that is needed ...

Where would I find this "orders class"? or which file is it? :smile:

I am assuming that this is the page where customers are redirected once their paypal payment was received.


Also - can you give me an idea as where in the file I would make my changes? Sometimes is hard to figure out what is going on the code w/o any comments.

I am currently using zen 1.3.7
Thanks!:smile:

I know this is off subject, but i need to ask a question and i can't find the post button or how to start a post at all! I am know for not spotting things in plain site ;P

If you can help me, please message me at [email protected]

Quote:

---

Originally Posted by Ajeh

You can customize the purchases on the orders class where the stock is adjusted and when someone buys a given product they are added to a Group ...

You can also customize the function for adding to the cart to disable the ability to buy a Product based on the fact it was already purchased so someone cannot buy twice ... if that is needed ...

---

could you point us to directions on adding someone to a discount group after purchasing a product. Using the latest zen cart.

Around line 702 in the:
/includes/classes/order.php

you will see the line:

Code:

---

          $db->Execute("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

---

Here you can check for the products_id with the:
zen_get_prid($this->products[$i]['id'])

If the products_id matches the products_id on the Product for the membership you can then update the table for:
customers

and the field for:
customers_group_pricing

for the customers_id from:
$_SESSION['customer_id']

Thank you so much. I will take a look and let you know how it goes.:lookaroun

You are most welcome ... let us know what customizations work best for you to manage this ... :cool:

sure!:smile:

I have a buy once - forever in group membership, I use the Group Pricing per item mod giving 2 groups of members 100% free products.

It works fine, except now I have 2 categories that I don't wish the group members to receive free but to purchase at the normal price.

When I price items for group members to receive free I use

Group B Price (Net): 0.0001
Group B Price (Gross): 0.0001
Group A Price (Net): 0.0001
Group A Price (Gross): 0.0001

Now with the 2 categories I wish for them to purchase I have tried

Group B Price (Net): 0.0000
Group B Price (Gross): 0
Group A Price (Net): 0.0000
Group A Price (Gross): 0


and even putting the actual price to no avail.

Either way it shows unit price/subtotal on 'Your Shopping Cart Contents' page, but when I go to checkout it shows discount of 100%

Does anybody know how I can fix this please?
Thank you in advance

That is what the Group Discount does ...

It takes all of the Products ordered and applies the Discount for that Group ... in this case 100% ... to all of the products ...

To have it behave otherwise, you will really be needing to customize the code to work with exclusions and exceptions to the concept of the "over all discount" that Group Discount was built to support ...

Quote:

---

Originally Posted by Ajeh

That is what the Group Discount does ...

It takes all of the Products ordered and applies the Discount for that Group ... in this case 100% ... to all of the products ...

To have it behave otherwise, you will really be needing to customize the code to work with exclusions and exceptions to the concept of the "over all discount" that Group Discount was built to support ...

---

ohh pooh lol thank you for reply I understand :bigups:

Quote:

---

Originally Posted by Ajeh

You are most welcome ... let us know what customizations work best for you to manage this ... :cool:

---

Quote:

---

Originally Posted by Ajeh

Around line 702 in the:
/includes/classes/order.php

you will see the line:

Code:

---

          $db->Execute("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . zen_get_prid($this->products[$i]['id']) . "'");

---

Here you can check for the products_id with the:
zen_get_prid($this->products[$i]['id'])

If the products_id matches the products_id on the Product for the membership you can then update the table for:
customers

and the field for:
customers_group_pricing

for the customers_id from:
$_SESSION['customer_id']

---

Not to be obtuse but can you spell this out a little better as to what the lines would actually be to code this? Such that all I'd need is the product ID? Likely simple but I am at a loss.

Could you give an example of what Group ID should be applied to the customers table and for what products_id this is to be applied for ...

Is doing this automatically based on a Product purchase going to mess up a customer if they already have a customers_group_pricing applied to their account?

Sorry for the delay Linda and thanks. I had a baby boy (my wife did) Yeah:clap:

Here is what I'd like to work if possible.

Using group pricing as the basis so that I can have 4 or more price level discounts on all items

Person signs up and is given standard discount which is not part of any group.

Person pays "x" dollars to be part of a steeper discount group "group a" in group pricing setup

Person pays "y" dollars to be still more discounted "group b"

And so on up to 4 groups if possible but I can make it work with just one and have the increases/logic be to sell the code again to bump them from group a to b.

Any upgrades from null to a,b,c,d would be 4 codes total all different priced and would automatically change their customer discount pricing group accordingly

The current Group Pricing is designed to give a fixed Percentage off on order and shows in the checkout ...

If you are trying to setup 4 Pricing Groups with different prices for Products on a per Product basis for each of the 4 groups you are going to have to do a lot more work than just assign a Group Price to the customer ...

I am sorry let me clarify. I have exist operating zencart system with 5 price levels. Works fine no problems with anything along that line

What I would like to do is allow for purchase of a member code of some kind that will automatically upgrade the purchaser from one discount level to a steeper discount.

The discount per item would already exists so to go back

I want to set up 4 codes that will allow a purchaser to upgrade into the steeper discount AUTOmatically.

So what is needed is a sales code that will alter the customers discount pricing group setting in admin customer area.

Right now I have a manual system where I sell them and manually change them to the next level up.

This could then be done by writing a routine to check the contents of the completed order where the stock is managed in the order class to change the Group Discount for the customer from one Group to the next ...

Do you have built in that once a customer is in Group 3 that they cannot buy Group 1 or Group 2 membership?

Sadly no I don't have that in there.

I thought I was doing nearly the same as this thread essentially resolved but I am now unsure what to do to get it automated.

I would need to sit down and write all of this code to explain how to sell 5 Products for the 5 memberships and automatically update them to the Pricing Group based on the Product that they purchased ...

Are you in Zen Cart v1.3.9b for this shop?

It would be a onetime sale into the higher discount group. All the pricing is already coded and is determined by the setting in the admin customer screen. Each sku has 6 prices that are set using ezpop. So it is code that alters the group price level of customer automatically if "x" sku is sold.

No I am not live with 1.3.9b yet because the site is very busy and I can't risk it. I am actually building a clone with the upgrade for a launch once I am sure all the stuff works. Plus the new one will allow me to eliminate the myriad of mistakes I likely made over the past few years building the current site

Are the memberships individual Products or 1 Product with individual Attributes for each of the membership groups?

None of my products have any attribute settings they are straight products with a given price which is controlled by group pricing.

Group pricing in turn has several levels which allows me to code each item to an exact price.

Currently I charge 10,20,30 etc dollars to "upgrade" to a higher discount level. People buy stuff daily or multi times per week so getting to a new level is a no-brainer for them.

That said without an automated upsell method it is very difficult to educate the consumer of the advantage. If I can make these codes featured items on the homepage I expect folks will quickly see the logic behind upgrading.

So John Might buy a Light Fixture for $20. If he upgraded he would pay 15. If he upgrades again then he pays 10 for same item. If he goes again he pays 5 being most aggressive level.

If I get it working somehow I'd probably thin down the levels to 3 instead of 5 with non-member currently being $25 price.

Does that help? To upgrade you do it one time and you always get the lower level pricing. Or I may do it annually still undecided. If annual the price would be lower v one-time.

I go to your store and want to get into the first Group Pricing ...

What do I do? Do I call you or do I buy a Product, that "looks" like an upgrade to the First Level Group Pricing?

I have been added to the First Level Group Pricing ...

I want to get Upgraded to the next level ...

What do I do? Do I call you or do I buy a Product, that "looks" like an upgrade to the Second Level Group Pricing?

Is this "upgrade", if a Product that "looks" like an "upgrade" the same Product or a different Product?

NOTE: pretend I have never ever seen your site and haven't a clue how you have it setup nor what it looks like to the customer ...

You are amazing!

If given access to the website you are therefore at the base level pricing.

Theoretically I place a cross-sell or featured item that they can easily find and/or purchase using the standard method that will alter their membership to preferred and then again to premium or you can upgrade to the max (premium) all at once. So 3 codes total each one alters the admin customer area based on above.

Beyond that it does not need to be a tickle sale or anything like that. If they choose to upgrade great if not fine too but just want to make it easier and more obvious to customers so they can just use their CC at time of purchase of something else.

And even during that purchase it would not matter if they got the lesser discount because language could be written to say the lower prices would be honored at time of shipment with approved CC charge.

So I come to your site to buy a $100 product ...

I see these Products (memberships) that I can purchase to save on future orders ... or I can buy these Products (memberships) in a separate order ... or, I can buy these Products (memberships) in the same order and you will credit me back the $$$ saved based on the membership ...

Meanwhile, the goal here is to adjust in the customers table the field customers_group_pricing to automate things so that all future orders would give the customer the discount purchased ...

Or ... get really trickie in the code and see if customer:

1 has no previous membership extend the new membership to the current order and update their membership upon completion of the order

2 has a previous membership extend the new upgraded membership to the current order and upgrade their membership upon completion of the order

That would be then avoid the need of a refund if you are offering a Group membership/upgrade in an order that can be applied to the immediate order ... :smile:

How good are your coding skills ... while not difficult to write, you are still getting into some sticky bits of code here to manage the discounts and upgrades etc. , especially if you would like the added benefit of having this all magically work from the order in which it is purchased and not include the membership as part of the membership discount ...

The good news is that the code needed for your current version will pretty much be the same as that for v1.3.9b ...

The bad news is that I would still have to sit down and write all of this code to be able to fully explain how to write all of this code ...

Have you got your coders hat on ... or find something burning a hole in your pocket? :smartalec:

Yes I think that is about right. And no I have no idea how to code such a thing. I can code if the core structure is exist I am not a true coder I can only cheat off others abilities.

It is something I'd be happy to have written if you are willing to do it send me a PM if this is something you have time for. Pockets are not an issue:wink: