Buying into a membership group and discount pricing per item.

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.