If this is your first visit, check our documentation. To post, register or login.
Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / Buying into a membership group and discount pricing per item.

Buying into a membership group and discount pricing per item.

Locked

Started by omen3891 on 11 Jan 2008, 7:03 PM · Views: 11,280

Results 21 to 34 of 34
This thread is locked. New replies are disabled.
27 Apr 2010, 2:49 AM
#21
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

4 May 2010, 8:34 PM
#22
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: Buying into a membership group and discount pricing per item.

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

4 May 2010, 11:29 PM
#23
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Buying into a membership group and discount pricing per item.

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 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

5 May 2010, 12:04 PM
#24
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: Buying into a membership group and discount pricing per item.

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.

5 May 2010, 2:58 PM
#25
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Buying into a membership group and discount pricing per item.

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?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 May 2010, 12:13 AM
#26
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: Buying into a membership group and discount pricing per item.

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.

6 May 2010, 12:30 AM
#27
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Buying into a membership group and discount pricing per item.

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?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 May 2010, 6:57 PM
#28
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: Buying into a membership group and discount pricing per item.

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

6 May 2010, 7:16 PM
#29
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Buying into a membership group and discount pricing per item.

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

6 May 2010, 10:53 PM
#30
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: Buying into a membership group and discount pricing per item.

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.

6 May 2010, 10:58 PM
#31
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Buying into a membership group and discount pricing per item.

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 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

7 May 2010, 3:15 AM
#32
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: Buying into a membership group and discount pricing per item.

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.

7 May 2010, 3:41 AM
#33
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Buying into a membership group and discount pricing per item.

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:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

7 May 2010, 2:53 PM
#34
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: Buying into a membership group and discount pricing per item.

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: