One Database but different product prices
 

Here is what we would like to have:

- Two storefronts on two different domain names
- Same products and categories for both stores which use the same database
- However different product prices and currency for each domain/storefront

Is there such a module or customization available? If not, how much would you charge to customly develop this for us?

Thank you.

Re: One Database but different product prices
 

What I understand from your post is actually you want to display xyz price for some country customers & abc price for some country customers. That means dual pricing method. And every other things will be same.

With default x-cart is not possible. But Qualiteam guys done custom work for me using GeoIP Country lite. So that you can configure price as per visitors country. To display currency as per country you can use multi currency module.

So instead of using x-cart on 2 different domains you can achieve your goal from single domain only which will be easy to manage

Re: One Database but different product prices
 

Thanks for the reply. This is not precisely what we are looking for.

We want to have two completely different websites - one for US and one for Canadian clients. Both sites must pull identical product information from a single database. The only difference is that each site will have different prices. And I don't mean "different" due to currency conversions - I mean completely different product prices. This is because we charge our US clients generally less than our Canadian clients.

We are not looking to auto-detect IP addresses, zip codes, etc. The limitation to this is that clients would need to first register or login before seeing their correct price. And we don't want that. We want them to see the different prices without loging in. We just want two different sites with two different prices, but one database to pull all the info from.

Re: One Database but different product prices
 

What i understood from your requirement is "since the product information is the same, you don't want to renter the information in second site". Since both sites are x-cart based Or similar system, you can simply export it in CSV and edit the price and import it. This is manual.

The automated solution is "Write a script that exports the products data from site 1 and import it into Site 2 automatically except the price data". In Site 2, if you have price already defined, don't overwrite it. If the data is empty, you can define it.

If need any help further, drop an email to sales@mercuryminds.com.

Re: One Database but different product prices
 

That's what I explained you. You will have 2 pricing field in your admin like USA Price & Canada Price. If you are using Geo Ip then customer of USA will be see price for US customer & vice vesra & this price will be show without login/register ;-)

Also pricing field can be avail in import/export fields of CSV files so you can upload in bulk also.