Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

One Database but different product prices

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 01-10-2013, 07:07 AM
 
CCP CCP is offline
 

Member
  
Join Date: Jul 2012
Posts: 16
 

Default 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.
__________________
Version 4.2.3
X-Cart Gold

Add-on: X-FeatureComparison
Add-on: X-Magnifier
Add-on: X-AOM (Advanced Order Management)
Reply With Quote
  #2  
Old 01-10-2013, 07:24 AM
 
anandat anandat is offline
 

X-Adept
  
Join Date: Jan 2004
Posts: 914
 

Default 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
__________________
X-Cart: 4.7.7 LIVE
Skin:Ultra by xcartmods.co.uk
X-cart Modules: | ACR, Rich Google Search, Customer Testimonials | Cloud Search, | Websitecm: CDSEO (2.1.9)
---------------
Server: Linux
php: 5.3
mysql: 5.0.89
----------------
Reply With Quote
  #3  
Old 01-10-2013, 07:37 AM
 
CCP CCP is offline
 

Member
  
Join Date: Jul 2012
Posts: 16
 

Default 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.
__________________
Version 4.2.3
X-Cart Gold

Add-on: X-FeatureComparison
Add-on: X-Magnifier
Add-on: X-AOM (Advanced Order Management)
Reply With Quote
  #4  
Old 01-10-2013, 07:50 AM
  Dongan's Avatar 
Dongan Dongan is offline
 

X-Wizard
  
Join Date: Jul 2005
Location: www.mercuryminds.com
Posts: 1,531
 

Default 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.
Reply With Quote
  #5  
Old 01-10-2013, 08:28 PM
 
anandat anandat is offline
 

X-Adept
  
Join Date: Jan 2004
Posts: 914
 

Thumbs up Re: One Database but different product prices

Quote:
Originally Posted by CCP
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.

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.
__________________
X-Cart: 4.7.7 LIVE
Skin:Ultra by xcartmods.co.uk
X-cart Modules: | ACR, Rich Google Search, Customer Testimonials | Cloud Search, | Websitecm: CDSEO (2.1.9)
---------------
Server: Linux
php: 5.3
mysql: 5.0.89
----------------
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 04:50 PM.

   

 
X-Cart forums © 2001-2020