Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

shared customer data


jduer

Recommended Posts

Posted

I would like to create a separate OSCommerce web site for each of two stores, but would like to be able to keep the customer data in sync between to the two stores. These stores are separate entities maintaining separate inventories, but need to maintain a single customer file especially for combined mailings and to be able to access customer purchases in either store with a single transaction. Is it possible to run two copies of OSCommerce on a single web site or do I have to find some way to batch process updates between separate web sites? This is not an instance where two stores draw from the same inventory.

Posted

It is possible to run two copies of OSCommerce using two different directories.

 

MySql reports both _osc1 and _osc2 so at least this approach allows me to have the data in a single workspace. Next I am going to try to find a way to use a global variable to prefix all customer table references with _osc1 thus keeping all customer data in a single. Hopefully, I can do a global change to all php files containing customer references.

Posted

Have you thought of putting the second store's file in the main db prefixed with osc2_ Then edit both /includes/database_tables.php and add a prefix to all tables you do not want to share.

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted

Thanks for your reply.

 

Your approach seems to have some merit and I would like to pursue it, but I cannot find where the _osc1 and _osc2 tables reside. Any hints where they are located? They are not in any directories [hidden or not] in my server workspace. PHPMyAdmin provides easy access to them but gives no clue to their location.

Posted

Normally when you create an osc site a db is created and all the tables for the site are placed in the db.

 

If you create a second site you can not put the tables in the same db as they have the same names and would overwrite the original tables.

 

But you can if you prefix the table names with, say osc2_

 

This is not done automatically, you have to do this .......

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Archived

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

×
×
  • Create New...