Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Different Prices for Registered Users Vs Unregistered


mcritz

Recommended Posts

Basically the site owner wants to display different prices for Registered Users. How could this be accomplished. Any ideas or suggestions are very appreciated because we are on a deadline to accomplish this. Thank you in advance.

Link to comment
Share on other sites

ALWAYS BE SPECIFIC!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Go back to your boss and ask him TO BE SPECIFIC!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

 

Let's say we have these customers:

Alice is an un-registered customer

Bob is registered

Charles is registered.

And some products:

An Aardvark and

a Bat

 

Do you want:

SCENARIO A: A Flat-rate discount, e.g. 5% or 5c?

An aardvark will cost Alice $10 (0% discount)

An aardvark will cost Bob $9.50 (5% discount)

An aardvark will cost Charles $9.50 (5% discount)

A Bat will cost Alice $20 (0% discount)

A Bat will cost Bob $19(5% discount)

A Bat will cost Charles $19 (5% discount)

 

OR

 

SCENARIO B: Specific prices for registered customers in general, and NOT specific to a particular customer

An aardvark will cost Alice $10

An aardvark will cost Bob $9

An aardvark will cost Charles $9 (Bob and Charles both get the same 'registered' price)

A Bat will cost Alice $20

A Bat will cost Bob $19

A Bat will cost Charles $19 (Bob and Charles both get the same 'registered' price)

 

OR

 

SCENARIO C: Specific prices for specific registered customer

An aardvark will cost Alice $10

An aardvark will cost Bob $9 (Bob specifically gets a $9 price)

An aardvark will cost Charles $8 (Charles specifically gets a $8 price)

A Bat will cost Alice $20

A Bat will cost Bob $19 (Bob specifically gets a $19 price)

A Bat will cost Charles $18 (Charles specifically gets a $19 price)

 

ETC.

 

I could have helped you by now, instead I spent the last 25 minutes typing the above because YOU WEREN'T SPECIFIC!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Link to comment
Share on other sites

i appreciate the thorough response and i'm sorry i wasn't more specific. neither bob or alice are different, ALL REGISTERED USERS would see one price where all NON-REGISTERED users would see another. So from your post SCENARIO B would be correct.

 

im looking for a specific price for all registered users as well a specific price for all non-registered users.

 

thank you.

Link to comment
Share on other sites

First off I'd like to apologise for my response - it was more in a humurous light, I hope you can see the humorous side to it - I do silly thing sometimes late at night, especially as a frustrated developer :P

 

By the way, when an order takes place, to my knowledge it stores a 'final_price' for the item. So even though a widget may have price $50, it's possible to store the sale for $60 etc.

 

Anyways, when I get a chance I can have a quick search through the contributions/addons to see if something fits.

But after some initial thought I see one complication: Don't all users register at some point when they make their purchase?

That could be the difficulty here.

Even the contributions that allow you to purchase without an account just simply register an account for the customer with their shipping address. There are contributions that can do special things for user registration - stuff like where a user has to wait for his/her registration to be 'approved' etc -- so that could work.

 

So assuming that's the case, if there isn't already a contribution for it, you'd have to generally do these things:

1. an extra field in the product database. I imagine that the 'extra' field will be for the *unregistered* user price. That way, all the intricate processes that happen during checkout (for registered users) can remain unchanged.

2. fetching and utelising this field in the catalog editor inside the admin -- so that your client can edit each product and set the price. If your client imports products using a spreadsheet it would have to be altered to accommodate the extra field -- or if they use a software application.

3. Modify the shopping_cart.php in includes/boxes and in the shop's root to refer to the 'extra field'. It may not be as simple as that - you may have to look in includes/application_top.php or the order classes.

 

chances are you'll find something that's similar in addons.oscommerce.com

Link to comment
Share on other sites

i ended up installing and using http://addons.oscommerce.com/info/185.

 

Which allowed me to create members and give them a % off and reflect it within Check Out.

 

My problem is I need to be able to display the "discounted" price within the page and not only when checking out.

 

ie. NONREGISTER views item and it shows $200 while REGISTERED member sees it for $100.

 

this all would be seen before involving the cart or checking out

Link to comment
Share on other sites

theres a simple thing theres a simple way.

sppc is VERY complicated, and you have seen the problem of the dicount addon.

simple way:

1. modify categories.php and products table to add a login price; unless applying same percentage to all products or, in the case of not many products, make use of the special price.

2. then the key is customers_id. if registered and not null, then price = login price else price = normal price.

 

sorry i only have the time to offer tips, not all the detailed steps.

Ken

commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile).

over 20 years of computer programming experience.

Link to comment
Share on other sites

theres a simple thing theres a simple way.

sppc is VERY complicated, and you have seen the problem of the dicount addon.

simple way:

1. modify categories.php and products table to add a login price; unless applying same percentage to all products or, in the case of not many products, make use of the special price.

2. then the key is customers_id. if registered and not null, then price = login price else price = normal price.

 

sorry i only have the time to offer tips, not all the detailed steps.

Ken

 

 

that seems very helpful, im not sure how to tackle it though, can anyone expand on what they were saying.

 

Thank You.

Link to comment
Share on other sites

SPPC use it on a store that no discount applies. But if I have another store where discounts apply. I have not been seen since the case of this problem. Approximately 120 contributions are installed in each store, 95% are common in both stores.

 

At some points I struggled to integrate the contribution. Elsewhere it has been impossible to integrate, in particular there is a part product_info impossible. That part (attributes) is also amended by another contribution: QT Pro

 

Particularly not give greater importance is a very specific point that no one usually pay attention. Not what I mean.

 

Usually the customer does not pay attention, just interested to know how much you will pay eventually.

 

I have installed on the admin the option to choose the shipping method. If I do so the client always click continue and choose the most economical shipping available (default method osC: cheapest). When you want to make a mistake and want to rectify, it's late because it has been sent.

 

The cheapest shipping method available to me is ordinary mail. That is no guarantee that it is given or done on time. You can not claim from the postal service. From the following shipping methods if they can claim, so I have that contribution.

 

If something as fundamental as this, the client is pending... are you going to be that the price out correctly throughout the store? not

 

 

Sorry for my bad English. I use an online translator.

Link to comment
Share on other sites

SPPC use it on a store that no discount applies. But if I have another store where discounts apply. I have not been seen since the case of this problem. Approximately 120 contributions are installed in each store, 95% are common in both stores.

 

At some points I struggled to integrate the contribution. Elsewhere it has been impossible to integrate, in particular there is a part product_info impossible. That part (attributes) is also amended by another contribution: QT Pro

 

Particularly not give greater importance is a very specific point that no one usually pay attention. Not what I mean.

 

Usually the customer does not pay attention, just interested to know how much you will pay eventually.

 

I have installed on the admin the option to choose the shipping method. If I do so the client always click continue and choose the most economical shipping available (default method osC: cheapest). When you want to make a mistake and want to rectify, it's late because it has been sent.

 

The cheapest shipping method available to me is ordinary mail. That is no guarantee that it is given or done on time. You can not claim from the postal service. From the following shipping methods if they can claim, so I have that contribution.

 

If something as fundamental as this, the client is pending... are you going to be that the price out correctly throughout the store? not

 

 

Sorry for my bad English. I use an online translator.

 

 

I installed and ran Discount Members fine, however it wasn't what i needed. For Instance:

 

When you go to the site and ARE NOT logged in you would see a diamond ring for 200 dollars.

However, When you are logged in the SAME PRODUCT would show the price of 100 dollars.

Link to comment
Share on other sites

I understand that the problem is that without a price register shows and register shows another. Right?

 

That may be more off the mark applies. They may be two reasons.

 

One (unlikely). The price is not correct.

Two (very likely). Somewhere in this repeated a line that makes it more applicable discount.

 

In the Spanish forum there who had a similar problem. In the cart there were two units by default. The problem was that a line had doubled. Solution to the problem is eliminated.

Link to comment
Share on other sites

I understand that the problem is that without a price register shows and register shows another. Right?

 

That may be more off the mark applies. They may be two reasons.

 

One (unlikely). The price is not correct.

Two (very likely). Somewhere in this repeated a line that makes it more applicable discount.

 

In the Spanish forum there who had a similar problem. In the cart there were two units by default. The problem was that a line had doubled. Solution to the problem is eliminated.

 

 

do you know how to fix this. or what to add to be able to have a different product price for registered vs unregistered users.

 

thank you

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...