Help needed with OSC sites

[Carbon_Fibre]

Hi Guys

I'd appreciate if anyone has any suggestions on how I can do this:

Example: If I have 3 (or more) osCommerce sites (all seperate companies), but I want users to be able to register once and then be able to log in to any of the sites. What would be the best way of doing this and how would I be able to this:

Option 1: With a centralised registration page, which copies the form information into a "customers" row of a seperate MySQL table (i.e. Table 4)
(1 x MySQL database - but with seperate tables for each osc installation. Hence 4 tables <3+1>).
All osc sites run off the same MySQL database but from different tables. I then find a way to amend the sql osc file so that it queries the "user" row in Table 4 instead of the original row/table.


Option 2: With a centralised registration page
(3 x MySQL databases - 1 for each osc installation).
Is there then a way to create an automated process to run, so that the 'process' copies the user details into the "customers" row of the MySQL table of each osc installation; or


Option 3: Traditional osc registration page for each osc installation
But find a way to have the "customers" row copied to the other databases (or tables) by some automated process, everytime someone registers or on a daily basis


Any input or ideas on how I can do this will be really appreciated. Thanks in advance.

 

[frikkie6000]

Hi Guys

I'd appreciate if anyone has any suggestions on how I can do this:

Example: If I have 3 (or more) osCommerce sites (all seperate companies), but I want users to be able to register once and then be able to log in to any of the sites. What would be the best way of doing this and how would I be able to this:

Option 1: With a centralised registration page, which copies the form information into a "customers" row of a seperate MySQL table (i.e. Table 4)
(1 x MySQL database - but with seperate tables for each osc installation. Hence 4 tables <3+1>).
All osc sites run off the same MySQL database but from different tables. I then find a way to amend the sql osc file so that it queries the "user" row in Table 4 instead of the original row/table.


Option 2: With a centralised registration page
(3 x MySQL databases - 1 for each osc installation).
Is there then a way to create an automated process to run, so that the 'process' copies the user details into the "customers" row of the MySQL table of each osc installation; or


Option 3: Traditional osc registration page for each osc installation
But find a way to have the "customers" row copied to the other databases (or tables) by some automated process, everytime someone registers or on a daily basis


Any input or ideas on how I can do this will be really appreciated. Thanks in advance.

Have you looked at any shopping cart modules

As basically for me that will make sense is user registration fields are repeated in all db's (Insert statement)

If I may ask what products is it ? All part of a group for example car parts, computers etc ?

Writing this from scratch up would be a good idea and you would be able to achieve the control you require

On the other hand some basic php/ my sql knowledge is enough for working with a cart system like virtue mart, Os Ecommerce etc once again depending on what you require at the end of the day

 

[Carbon_Fibre]

Have you looked at any shopping cart modules

As basically for me that will make sense is user registration fields are repeated in all db's (Insert statement)

If I may ask what products is it ? All part of a group for example car parts, computers etc ?

Writing this from scratch up would be a good idea and you would be able to achieve the control you require

On the other hand some basic php/ my sql knowledge is enough for working with a cart system like virtue mart, Os Ecommerce etc once again depending on what you require at the end of the day

Thanks for the reply.

I need to quote for a company which has several divisions. They want to sell online, seperately for each division and need customers to be able to register once but shop on each site. They want it done in OS Commerce. I've checked the OSC add-ons/contributions but can't find anything as yet. It seems I would need to find a way from the 3 options above. But I'm not very good with PHP and SQL.

 

[frikkie6000]

Thanks for the reply.

I need to quote for a company which has several divisions. They want to sell online, seperately for each division and need customers to be able to register once but shop on each site. They want it done in OS Commerce. I've checked the OSC add-ons/contributions but can't find anything as yet. It seems I would need to find a way from the 3 options above. But I'm not very good with PHP and SQL.

I will have a look for you as well

3 different websites right ? all working with one gateway and then of course it will be 3 db's as products differ etc

 

[Carbon_Fibre]

I will have a look for you as well

3 different websites right ? all working with one gateway and then of course it will be 3 db's as products differ etc

Thanks

Yes. But I could use 1 database (instead of 3) with seperate tables for each OSC site.