ProductCart Shopping Cart Software Forums : Running multiple stores on one database

Running multiple stores on one database : Well hopefully you can work something...

Mon, 06 Oct 2008 00:01:12 +0000

Author: benpate
Subject: 2017
Posted: 06-October-2008 at 12:01am

Well hopefully you can work something out with EI Im sure that was a decent amount of work and probably a lot of thought to pull that off Kudos

Running multiple stores on one database : I could maybe dream of doing some...

Thu, 02 Oct 2008 17:15:20 +0000

Author: Justplaying
Subject: 2017
Posted: 02-October-2008 at 5:15pm

I could maybe dream of doing some customisations but sadly often my dreams turn into nightmares!

Therefore i like to try and keep things simple

Running multiple stores on one database : Cool! - Nice approach. I thought...

Thu, 02 Oct 2008 17:04:36 +0000

Author: Hamish
Subject: 2017
Posted: 02-October-2008 at 5:04pm

Cool! - Nice approach. I thought you had done some customisation to control what was shown on each store, but that's a good solution which keeps life simpler.

Running multiple stores on one database : Hamish the stores are the sameI...

Thu, 02 Oct 2008 16:46:50 +0000

Author: Justplaying
Subject: 2017
Posted: 02-October-2008 at 4:46pm

Hamish the stores are the same

I have altered the left menu system to make them look different and the path of the browse link but they are selling the same products

On Justplaying the priority is Toys but customers can also purchase educational material by following the path educational > teaching resources >

On Oceanlights the priority is Educational Material but the schools can also by the toys which are also educational

And if you actually think about it how can I be selling different products on each site, the customer only has to click on search and they can view all the products in the database therefore purchase any item on any site

The only changes are to the layout of the menu and the way the customer navigates the sites

Running multiple stores on one database : Hi, Yes, I think the licensing...

Thu, 02 Oct 2008 16:01:33 +0000

Author: Hamish
Subject: 2017
Posted: 02-October-2008 at 4:01pm

Hi, Yes, I think the licensing was revised, but it looks like your sites don't match the rules as layed out in Cedric's email anyway as it says "If you need stores with different products and categories, then you would need to purchase additional licences". Still, I can see from an admin and maintenance point of view that there could be advantages to running of a single DB and I don't believe an extra licence will prevent you from doing so.

Edited by Hamish - 02-October-2008 at 4:02pm

Running multiple stores on one database : Correct. The e-mail conversation...

Thu, 02 Oct 2008 15:53:52 +0000

Author: ProductCart
Subject: 2017
Posted: 02-October-2008 at 3:53pm

Correct. The e-mail conversation above is from 2007 and the change in licensing terms happened in 2008. Of course, we will respect whatever terms were in effect when you purchased ProductCart. I believe a message along these lines has already been sent to you in reply to your ticket.

Running multiple stores on one database : Interesting!Sadly I was unaware...

Thu, 02 Oct 2008 14:52:28 +0000

Author: Justplaying
Subject: 2017
Posted: 02-October-2008 at 2:52pm

Interesting!

Sadly I was unaware of this change in policy because when I purchased ProductCart we asked about the use of one database for 2 or 3 sites (I have enclosed a copy of the correspondence below)

Therefore when I purchased ProductCart did I not purchase a license which allowed the use of 1 database between 2 domains?
Also in the correspondence it mentions nothing of seperate domains

Finally I have submitted a ticket over this issue

Neil

From: "Justplaying Neil"
Sent: Tue, 17 Jul 2007 07:04:45 -0400
To: "'Early Impact Customer Service'"
Subject: RE: [367-0E2DD0D6-EB55] Early Impact - Request for more information

Hi Massimo
I suppose my final question is we currently have 4 ecomm sites all using the
same sql database - basically trying to promote the same products on
different domains - for this would we need 4 licenses or have I read it's
the database which is licensed?
Therefore we could use one license?

< ="-" ="text/; =utf-8">< name="ProgId" ="Word.">< name="Generator" ="Microsoft Word 12">< name="Originator" ="Microsoft Word 12">

From: Early Impact Customer Service [mailto:enquiries@earlyimpact.com]
Sent: 17 July 2007 18:15
To: neil@justplaying.co.uk
Subject: [367-0E2DD0D6-EB55] Early Impact - Request for more information

< ="-" ="text/; =utf-8">< name="ProgId" ="Word.">< name="Generator" ="Microsoft Word 12">< name="Originator" ="Microsoft Word 12">

Hi Neil,
Indeed.... ProductCart is licensed "per database" -- not perdomain. This means that you could have multiple domains pointing to thesame site/store... all the sharing the same database (products,categories, customers, etc.). If you need stores with different productsand categories, then you would need to purchase additional licenses. Asan end-user, here's what we can do for you in terms of discounts:
For licensees purchased separately (at different times), the 1st license wouldbe list price, the 2nd license would be 15% off, the 3rd license would be 20%off and additional licenses would be 25% off. If you purchase multiplelicenses up front, the discount would apply to the entire order (i.e. - 2licenses would be 15% off for both, 3 licenses would be 20% off for all 3,etc.)
Please let us know if you have any other questions.
Best regards,
Cedric Adams
Early Impact

Running multiple stores on one database : This is just a note to clarify...

Thu, 02 Oct 2008 05:36:54 +0000

Author: ProductCart
Subject: 2017
Posted: 02-October-2008 at 5:36am

This is just a note to clarify that multiple stores can no longer be run on the same ProductCart licenses, when the domain name is different. That is: ProductCart is licensed both on a domain-specific basis and a database-specific basis.

There can be exceptions to the rule, but you will need to contact Early Impact.

Read more details about how ProductCart is licensed. Here you can also find some frequently asked questions on the rationale behind our licensing model. If you have any questions, certainly contact us.

Edited by earlyimp - 02-October-2008 at 5:57am

Running multiple stores on one database : Its been a long night but I think...

Thu, 02 Oct 2008 05:10:13 +0000

Author: Justplaying
Subject: 2017
Posted: 02-October-2008 at 5:10am

Its been a long night but I think I have sorted it!

So for the record, here is what I have done:

In my MS SQL - table - dbo.Worldpay then add wp_id and installation ID

Next

Store\manager_admin\Gateways\RT_Worldpay.asp

line 6 where wp_id=1 change this to where wp_id=2
Same again on lines 24, 76 and 106

Store\pc\gwwp.asp

line 68 where wp_id=1 change this to where wp_id=2

These changes make the installation id visable in Admin and also work on the customer side

Running multiple stores on one database : Can anyone help?I have 2 sites...

Wed, 01 Oct 2008 20:03:39 +0000

Author: Justplaying
Subject: 2017
Posted: 01-October-2008 at 8:03pm

Can anyone help?

I have 2 sites setup and running off the same PC Database
We have managed to seperate the products and payments go through ok but and this is a big BUT!

We use Worldpay for our payment processor, on our main site- www.justplaying.co.uk (which sells traditional toys) when the customer has paid on Worldpay they are sent back to the site which verifies the sale in PC

On our other site www.oceanlights.co.uk (which sells educational products to schools) although this site does have its own installation ID from worldpay, only one can be used in the database. Therefore it uses our main sites ID and after the customer has paid instead of being returned to Oceanlights to verify purchase they are forwarded to Justplaying

Although the sale has been paid for it is left as an incomplete order on the Oceanlights site

Is there anyway to add 2 installations of worldpay so each site can use one?

Thanks

Neil