Zen Cart Logo
Forums / General Questions / Different prices for different countries

Different prices for different countries

Locked

Views: 2,778

Results 1 to 13 of 13
This thread is locked. New replies are disabled.
13 Mar 2007, 12:18 PM
#1
intelcos avatar

intelcos

Totally Zenned

Join Date:
Apr 2004
Location:
Montreal
Posts:
584
Plugin Contributions:
0

Different prices for different countries

Hi all,

Is there a way or a mod that allows for pricing by country or ip locations.

In our case, our products can have different prices depending of country thus the need to detect by ip and country for other pricing.

Thanks in advance

13 Mar 2007, 2:16 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Different prices for different countries

Now that would be a great mod...:thumbsup:

I think you'll have to build it from the ground up, though!

14 Mar 2007, 9:08 AM
#3
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,690
Plugin Contributions:
56

Re: Different prices for different countries

IntelCos:

Hi all,

Is there a way or a mod that allows for pricing by country or ip locations.

In our case, our products can have different prices depending of country thus the need to detect by ip and country for other pricing.

Thanks in advance

Why not hide prices until login and then display based on country?

14 Mar 2007, 10:44 AM
#4
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Different prices for different countries

swguy:

Why not hide prices until login and then display based on country?

I think the idea is to have different prices (not just display the appropriate currency)

For example: Product A is priced at:-

$10 in the USA,
$8 in Argentina,
$5 in Brazil.

...So even if you want it to display in the relevant CURRENCY, it must still convert the set VALUE.

To me, the way to build this Mod would be to apply a price offset factor (a percentage), that kicks in relative to the Country ISO code.

In the same way that ZONE RATE shipping can be configured to allow additional ZONES, the store owner can set up :-

pricing zones
insert ISO codes relevant to each zone
insert the offset factor (as a %) relevant to each zone

You would then have to base your regional pricing policy on a percentage offset, rather than an actual "amount off". Doing the latter would probably require major tabular additions to the database and a whole lot of complex php too!

Linda... Kim... Steve... Chris ???? Anyone... ?

This one would be really nice!

14 Mar 2007, 2:15 PM
#5
intelcos avatar

intelcos

Totally Zenned

Join Date:
Apr 2004
Location:
Montreal
Posts:
584
Plugin Contributions:
0

Re: Different prices for different countries

Now were getting somewhere.

One of the reasons for such a request is the factor of import/export. For some countroies the export duties need to be offset in order for the dealer/distributor to hae a healthy return on investment.

I agree with the logic as mentioned in the last post, hiding pricings is not the route, allowing ip detection to have option for different pricing is a real plus.

So, guru's, here's a good project mod which I'm sure will be most welcomed.

14 Mar 2007, 4:57 PM
#6
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Different prices for different countries

Have you looked at Group Pricing? Here you can configure your customers into groups that enjoy discounts. We use this for our trade customers. We have 4 discount levels and allocate new trade customers to the appropriate discount group.

14 Mar 2007, 7:06 PM
#7
rstevenson avatar

rstevenson

Totally Zenned

Join Date:
Nov 2006
Location:
Dartmouth, NS Canada
Posts:
2,400
Plugin Contributions:
0

Re: Different prices for different countries

Hi,

I posted a similar question in the Currencies... forum last week but got no replies at all. Since we're talking about it here, let me enter my question as an elaboration of the OP's question, since I think we're on the same wavelength on this -- that is, percentage isn't going to do it. There really are different prices for different countries.
................
Our retail site (link below) sells all our greeting cards in CDN $, so any conversion to the buyer's currency occurs at their CC processor. This works fine for retail. I'm about to start to set up site #2 which will be for our wholesale company. That site will sell only to authorized accounts.

What I'd like is a way to set -- either automatically based on the buyer's country code or manually by asking them to select a 'flag' -- which currency/price to show them.

The catch is that we do not convert a single price from one currency to another. We have 2 separate price points based on what cards commonly sell for in the target markets. A card that sells for $3.25 in Canada (in CDN$) will sell for $2.95 in the US (in US$).

The wholesale buyer pays 1/2 retail, so we need to show the price as 1.625 for the Canadian buyer or 1.475 for the American buyer. (By the way, the 3 digits after the decimal are important to avoid rounding errors.)

I believe this is not possible with Zen Cart as it stands. The Dual Pricing mod appears to be for showing either wholesale or retail prices, but doesn't have anything to do with 2 separate prices for 2 countries.
..............
I hope this stands as another instance of what the Op was asking about, and that I have not hijacked the thread. If I have, just ignore me. :laugh:

Rob

14 Mar 2007, 8:28 PM
#8
intelcos avatar

intelcos

Totally Zenned

Join Date:
Apr 2004
Location:
Montreal
Posts:
584
Plugin Contributions:
0

Re: Different prices for different countries

No, your on the same wavelength.

The need for prices by country is just as that. A product from one country to another varies depending on many factors.

The need for detection by ip and country to a price match that is set for the market is required.

Thus, in fact a full blown wholesale mod that allows for multiple pricing base on country location without a conversion of currencies on the FP which sets the visitor's view(wholesale or retail) to the price of their country as well based on the preset values and conditions.

14 Mar 2007, 9:57 PM
#9
rstevenson avatar

rstevenson

Totally Zenned

Join Date:
Nov 2006
Location:
Dartmouth, NS Canada
Posts:
2,400
Plugin Contributions:
0

Re: Different prices for different countries

Hi again,

We may have to just talk to ourselves. :laugh:

I just took another look at the readme for the Dual Pricing mod. It looks to me (but I'm nothing like competent in PHP) that a good deal of the work we'd need for our mod has been done there already.

All we need to add is a conditional statement to catch the country code for logged in visitors and then show them one or the other price (I just need 2, so far). For me the pseudo code is "IF country code is US, THEN price is 1.475 ELSE price is 1.625". Your case would be similar but more of it.

The required modifications to the database and the core code seem to be taken care of in the Dual Pricing mod -- again you'd need more of them. OR I don't know what I'm talking about!

Rob

14 Mar 2007, 10:10 PM
#10
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Different prices for different countries

To me it would be easier to have a price factor do the job, but for lots of people this is impractical because they can't apply a global % to all products.

To build a mod that applies prices-per-product according to ISO zones is going to be a lot of work and will require additions to the dbase tables in a rather complex way.

Other thoughts
Before you display any prices, customers will have to register, because you don't know where they are UNTIL they register and so you won't want to show prices that may scare them off.

If you try to base the price on browser's IP, you run into problems too. My neighbour lives in Hertfordshire, England - but uses AOL. When he looks at my shop, his IP address is identified as USA.

Not an easy one this...

14 Mar 2007, 10:36 PM
#11
intelcos avatar

intelcos

Totally Zenned

Join Date:
Apr 2004
Location:
Montreal
Posts:
584
Plugin Contributions:
0

Re: Different prices for different countries

I think it needs to be looked in a sense that country detection is a basic need prior to anything, from that the store directs to as many structures as one requires from a global point.

Example

Distribution vs Wholesale vs Retail

Retail price is determined on a world scale meaning products sold in Japan made in Canada would most certainly be taken into effect as well. In many cases an import product carries 30 to 50 % retail pricing increases if not more(again depends on product and market, I'm not talking selling comic books)

Thus, Say we have 4 global retail prices set.

We also have a wholesale levels (say 30 40 & 50)

and

Distribution (40 and 50, say a gold level and a silver level)

that means my break done on one region would be as follows

Retail - 20.00
W 15 12 and 10
D 6 and 5

as examples(don't get snicky on my math example, it's an example only)

I can see where group pricing is one part to set my Wholesale levels based on one retail price. But, the missing link is the retail price based on the global setting as mentioned above plus the optional distribution hook as well.

Distribution I think in this case is a long shot setting to add on as well as the math and logic behind it would be a task in a half, but what a beauty of a mod it would be.

You have the full capacity to easily set wholesale/distribution and global pricing with attribute options to set what ever discount structure you use.

I've seen many addons that come up part way, but never to this level of use and it would be a great feat for any guru out there, just don't ask me how to program it, but test it and help with the logic towards it, no problem.

10 Apr 2007, 10:17 PM
#12
currell avatar

currell

New Zenner

Join Date:
Apr 2007
Posts:
1
Plugin Contributions:
0

Re: Different prices for different countries

Nettwerk Music Group http://www.nettwerk.com/ is looking for somebody with Zen Cart programming experience to build us a module simmilar to what is laid out in this thread. Basically imagine something simmilar to how iTunes works.

You choose your country. That determines a currency and a pricing structure. eg. In the UK you get charged 7 pounds for a CD and it actually dumps a real 7 pounds into a UK bank account without conversion. In Canada you get charged in Canadian funds and the money goes into a Canadian account without conversion, etc...

Small countries without large sales numbers (eg. Iceland) would get dumped into one US dollar over-ride account.

Willing to pay anybody with previous Zen Cart module writing experience. Anybody interested give me a shout: [email protected].

26 Apr 2007, 10:50 PM
#13
minnie_mouse avatar

minnie_mouse

Zen Follower

Join Date:
Jun 2005
Posts:
119
Plugin Contributions:
0

Re: Different prices for different countries

hi there, did you ever get someone to make this module? i am interested in this as well.

however, mine gets more complicated. i have two zones (customer groups) to sell in with different prices/product. i am only selling wholesale, but then each product will have a 4 tier quantity discount as well.

i am almost thinking what is required is two zen stores / database setups one for each zone. when you enter a login it shunts you to the right store.

any thoughts on that. (of course the two store solution only makes sense if you only have two zones.)