using multiple stores with one datbase

accessing the same same product page, but pullung up different links

[scato345]

Hello,

I am developing several websites that will all share the same data base. There will be an overlap of products - for example, let's say "shoes." Several sites will each sell some of the same products. Each of these products, ie;
"Doc Martens Purple Shimmer" Prod ID #126, will each have its own product ID and related inventory. A details page with photos, etc will be generated from the data base, and each sale will be deducted and new stock or returns will be added to the inventory of prod ID #126.

There are shopping carts that will allow a site to place a "buy anywhere button" before the database driven shopping cartcheckout pages. That is, a button activates the "add to shopping cart" step of the checkout procedure from the site (and not from the site's data base.)

In an event, once a customer has entered the shopping cart and has added an item, if the customer wants to continue shopping they can only go back to the last page visited, and not the previous previous page or to the particuar link previously embedded on the shopping cart page in HTML code).

I am wondering how to effect a "smart checkout page" that will know from which particular site a customer has come.

What I would like to happen is to have the basic selling template for a product, - which is tied to the product's ID# and is having its inventory modified in the {PHP / MSQL} data base, - insert the appropriate HTML created URL links information for that site onto the data base generated page.

As it is now, once a customer has entered the data base there is no way to get back to a page on a particular site or move to any other page but the one that was created in the displayed page.

I can't use "duplicate" pages of the product for each site because that would require different product IDs and the inventory for that product wouldn't be adjusted by a sale.

Maybe it can?

Still, I would prefer to have a single selling page per product in the data base, but with different URLS being attached to the HTML designed navigation elements on the page.

I am looking for guidance, since I am not sure if this would best be done by PHP or some other language or procedure.

Are there any shopping carts that accomodate this procedure; or are there any plugins that are available to accomplish this?

I am curently using LiteCommere, but am considering purchasing ShopRite because of their assistance availability.

Thanks,

Dorian