Member Site Question

[kevin60]

Hi All,

 

I am a newbie and have been working with osCommerce Online Merchant v2.2 RC 2a provided by my server hosting company for a few weeks.

 

I appreciate the questions everyone has answered when previous posts that, I have tried to read diligently, didn't compute!

 

My basic site is coming along well and now I guess I'm ready for my first attempt at adding contributions.

 

I have looked through the many contributions in the payment section but I was hoping someone could point me in the right direction vs. trial and error.

 

What I’d like to accomplish is:

 

1) My site to function at normal retail prices for non members. (But for them to see Member Pricing as a selling point for membership)

1a) I currently can put in, example: 20% off and it will show the reduced price with a line through the retail, but how do I LABEL this as "Member Only Price" and then exclude this discount for non members at checkout or conversely give members the discount at checkout?

 

2a) Be able to sell a membership to a new customer and add them dynamically to a list (i.e. hands off 24 hr service) so they can then come back in and benefit from the membership (i.e. discount savings & other perks) immediately?

2b) To go along with this I assume I would need to assign a "random generated" 6digit or ? membership number from the table? If Random generation on the fly is too complicated I could generate the numbers and copy them in the table manually for future customers!

2c) And I’d like to have the capability to pre assign a "hard" membership numbers ie for (Gift Memberships) so when the recipient of the Gift membership comes to the site they can Register on their 1st visit and type in their "gift" member number thus not paying the fee?

 

I know I am probably asking for the moon but I was just hoping there is something close for the version I’m using.

 

Thanks in Advance,

Kevin

[Jan Zonjee]

1) My site to function at normal retail prices for non members. (But for them to see Member Pricing as a selling point for membership)

1a) I currently can put in, example: 20% off and it will show the reduced price with a line through the retail, but how do I LABEL this as "Member Only Price" and then exclude this discount for non members at checkout or conversely give members the discount at checkout?

Separate Pricing Per Customer can be used for different pricing for customer groups. Of course normally you wouldn't want to show e.g. the wholesale price to your retail customers but with some custom coding on product_info.php this is certainly possible.

 

2a) Be able to sell a membership to a new customer and add them dynamically to a list (i.e. hands off 24 hr service) so they can then come back in and benefit from the membership (i.e. discount savings & other perks) immediately?

Can be done in the admin after installing SPPC.

2c) And I’d like to have the capability to pre assign a "hard" membership numbers ie for (Gift Memberships) so when the recipient of the Gift membership comes to the site they can Register on their 1st visit and type in their "gift" member number thus not paying the fee?

Some custom code in create_account.php to put them in the correct group without having to do that manually (using the gift code) should do the trick.

[kevin60]

Separate Pricing Per Customer can be used for different pricing for customer groups. Of course normally you wouldn't want to show e.g. the wholesale price to your retail customers but with some custom coding on product_info.php this is certainly possible.

 

 

Can be done in the admin after installing SPPC.

 

Some custom code in create_account.php to put them in the correct group without having to do that manually (using the gift code) should do the trick.

 

 

Thanks Jan!

 

I appreciate the help.....I'll work on it.

 

Kevin

[kevin60]

Jan,

 

Sorry to be a pest .....

 

On your last comment:

 

"Some custom code in create_account.php to put them in the correct group without having to do that manually (using the gift code) should do the trick."

 

I was trying to figure out which Gift code it is as i saw several in the contributions. Is it the one called "09-Feb-09 Gift Vouchers for SPPC ver. 4.22" ? And if so Do i need to intall this after installing SPPC ver 4.22 as it looks like the author has 2 versions one for existing shop and one for a new shop? Since i havent modified my shop to the extreme yet I was thinking about starting fresh with SPPC ver 4.22 and testing it. So in this case what would be the best to use?

 

And what program do you prefer for offline development? To date i have been doing everything on the sever...oops I know this isn't a good practice.

Thanks,

Kevin

Edited May 19, 2009 by kevin60

[kevin60]

Jan,

 

I found XAMPP and loaded onto my box which has Vista. Followed the instalation instructions and I believe it is working as expected when after following the instructions below. And i checked it using http://localhost/xampp/index.php. and it showed the databases where working.

>>>>>>>>>>>>>>

QUICK INSTALLATION:

 

[NOTE: Unpack the package to your USB stick or a partition of your choice.

There it must be on the highest level like E:\ or W:\. It will

build E:\xampp or W:\xampp or something like this. Please do not use the "setup_xampp.bat" for an USB stick installation!]

 

Step 1: Unpack the package into a directory of your choice. Please start the

"setup_xampp.bat" and beginning the installation. Note: XAMPP makes no entries in the windows registry and no settings for the system variables.

 

Step 2: If installation ends successfully, start the Apache 2 with

"apache_start".bat", MySQL with "mysql_start".bat". Stop the MySQL Server with "mysql_stop.bat". For shutdown the Apache HTTPD, only close the Apache Command (CMD). Or use the fine XAMPP Control Panel with double-click on "xampp-control.exe"!

 

Step 3: Start your browser and type http://127.0.0.1 or http://localhost in the location bar. You should see our pre-made

start page with certain examples and test screens.

 

Step 4: PHP (with mod_php, as *.php, *.php3, *.php4, *.php5, *.phtml), Perl by default with *.cgi, SSI with *.shtml are all located in => C:\xampp\htdocs\.

Examples:

- C:\xampp\htdocs\test.php => http://localhost/test.php

- C:\xampp\htdocs\myhome\test.php => http://localhost/myhome/test.php

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

 

However I'm not sure where to go from here? How do i install the new shop so the test data base will recognize it. I've tried looking at various posts on new installation however what i have tried so far has not been succesful so I must be doing something wrong.

 

Thanks Again,

Kevin