bubba30 Posted March 4, 2003 Share Posted March 4, 2003 ? Guy / Gals Need to know if there is a way to make certian products in Can$ and some in USD$. Currently using paypal to process in USD$ So i Guess what i am looking for is for a customer in canada to pay in can$ funds and customers in the USA to pay in usd$ Funds Reason being company is canadian based and want to charge USD funds to US customers and in Canada must charge GST tax So it is hard to set a standerd price because of convertion. Hope that makes sense :roll: This coding is getting to me Link to comment Share on other sites More sharing options...
Georgewf Posted March 4, 2003 Share Posted March 4, 2003 It's a good question. I was about to ask the same. Now osc converts according to the currency exchange, but sometimes I have to sell at different prices/quantities in the 2 markets. Link to comment Share on other sites More sharing options...
Guest Posted March 4, 2003 Share Posted March 4, 2003 I'll try to explain what I have done, as I am based in Canada. For the tax issue, I've made a Canada zone and a US zone. Only shipments within Canada will be charged GST tax - any americans ordering from my site will not be charged GST (based on their delivery address zone information) As for currency, I've got both Canadian and American currencies available on my site, and I use primarily PayPal - the customer can choose on my site which rate to view, and then can be billed in that currency if it is set up for that currency in PayPal. You can set the conversion rates in the currency modules - you will need to update it manually or change some code to get it to automatically update. Anyhow, hope that clarifies some options available to you. I'm sure some of the more experienced coders can clarify the options more for you if need be. Link to comment Share on other sites More sharing options...
bubba30 Posted March 4, 2003 Author Share Posted March 4, 2003 Example I sell memberships to america customers at say 100 a year usd I sell memberships to canadian customers at say 60 a year Cnd Now are you saying i have the option of showing my US customers the canadian conversion of there membership and vi versa. And osc will convert the usd funds to CND$ and then i can charge GST one more thing when i go to paypal it's set to usd does that matter or is it just converted and billed to the shoppers cc. I am not sure if that make more sense If you have a link so i can see how yous site handles it (it would help) Thanks Link to comment Share on other sites More sharing options...
Ian-San Posted March 4, 2003 Share Posted March 4, 2003 Its a bit messy but I use this method all the time now: - create separate languages for US and Canada (say US is language id = 1 and Canada becomes language id = 2) - now just duplicate the products and manually change the language id for the unwanted version using phpMyAdmin to 3. So, prod 1 has ids of 1 and 3 and so will only show when site language is set to US. prod 2 has ids of 3 and 2 and so will only show when Canada is selected. The main problem is that unless you add language id to the queries for new products (not too difficult) etc. the dead product will still show in these boxes although it will say - not available etc - when you try to select it. One way around this is to rename the product for the unwanted language like - Sorry, Not available in Canada. Ian-san Flawlessnet Link to comment Share on other sites More sharing options...
Guest Posted March 4, 2003 Share Posted March 4, 2003 Sorry, I didn't realize you wanted two completely different prices depending on buyers location. I just have one price on my website that can be viewed in either Canadian or American funds. I don't think my site will do you much good. Hopefully the suggestion above with work with you. Good luck! Link to comment Share on other sites More sharing options...
bubba30 Posted March 4, 2003 Author Share Posted March 4, 2003 I think the USA language and CAN language will work. as i am running my Can products on one page and my USA products on a different. I'll try it and let you guys know if it works. Thanks to all bubba30 Link to comment Share on other sites More sharing options...
matbennett Posted May 13, 2003 Share Posted May 13, 2003 Out of interest, how did you get on with this? I just found this thread and found it interesting as I set-up a store a while ago that had 8 different regions, each with their own pricing. In my opinion the customer really needed 8 different stores, but didn't want to pay for them! My solution was a lot more long winded than the above (I think), but it was the best that I could think of. I used the top level categories as the region, and duplicated the sub-cats for each region below that. I converted the menu system never to show the top level, and set all the exchange rates to 1:1. I then had to modify the search and any links so that customers could not accidentally see products from the other region. After that it was simply a case of creating a doorway that set the customers currency if they changed regions. Fun huh? I'd be interested to see this other solution in action, as mine sucks! Link to comment Share on other sites More sharing options...
mstefa Posted May 25, 2003 Share Posted May 25, 2003 have them create different category for every country or different price so let them load products again, to all categories, and set up different prices, and subcategories.. Link to comment Share on other sites More sharing options...
halbert Posted May 26, 2003 Share Posted May 26, 2003 I'm trying to create a store that will allow the currency thing to show the price in local money, but then charge the customer in Canadian or US dollars. Why? Because if you have your own credit card gateway, you would need to get a different currency account for USD, CAD, EUR, JPY... and so on. And that's expensive and not very efficient from my end. For example I want to do this: you go to the site and look at the prices in EUR. Say, EUR15 for an item. When you go through the checkout, it tells you the full costs with shipping in EUR, say 18.50 (EUR3.50 for shipping). But then it also tells you what that is converted to CAD - C$29.60 (EUR1=C$1.6) and that is what will be billed to your charge card. The customer will see a charge of C$29.60 converted by their credit card company to EUR. Think of if you went on a vacation and charged something on your credit card. It's charged in local currency on your bill but is converted at the credit card rate to your own currency (which wouldn't be the same as the official exchange rate!). Anyone got a solution or comments about this one? Link to comment Share on other sites More sharing options...
mstefa Posted May 27, 2003 Share Posted May 27, 2003 You can have prices displayeed in any currency, but charge only in one , All of them will convert to that one through the bank Link to comment Share on other sites More sharing options...
halbert Posted May 27, 2003 Share Posted May 27, 2003 You can have prices displayeed in any currency, but charge only in one ,All of them will convert to that one through the bank Well, no... It doesn't work that way for merchants. For clients, yes, you can put charges in any currency on your card and the bank will convert. But have you ever tried to get CAD charged on your card when in the US, or Mexico, or any other country? They can't do it! They can only convert to the local currency, charge that local value to your card, and then pay you out in CAD (if they are able to). You don't see CAD charges on your card in the US, you see USD charges converted to CAD. The merchant can only charge in their local currency unless they get separate accounts for each different currency. For instance, I am selling stuff with USD as the default currency. Someone in Europe switches to view in EUR and proceeds to order a few items. When they go through checkout, the price is still displayed and passed through as the selected currency ie: EUR instead of the default currency USD. I tested this with the cheque/money order and Paypal modules, and that is how it goes. The customer sees their order placed in the selected currency. Unfortunately if I'm using my own credit card gateway, I can only charge them in CAD, not USD/EUR/JPY/SWF etc etc. This is the problem - OSC passes the displayed currency and amount, not the default. Try it if you've got a test environment set up. As a merchant I'd have to set up separate accounts with the gateway to accept payment in CAD, USD, EUR etc. I want to set up only one account, either CAD or USD, and need to ensure that OSC passes the correct currency and value to the gateway. I need this value so I can tell the customer that they will see their purchase charged in CAD converted at the xx.xxxx rate. *sigh* I thought computers were going to make life so much easier... :( -al Link to comment Share on other sites More sharing options...
mstefa Posted May 27, 2003 Share Posted May 27, 2003 Somebody asked the other day why is it every time they change currency and flip the page, goes back to default currency regardless of what they chose before. This may work for you since at time of checkout it should switch back to default currency.. ( admin/mystore/ switch to default language currency , true ) and there is no option to manually change it again for the customer.. BTW, who is yoor canadian pay gataway? Link to comment Share on other sites More sharing options...
halbert Posted May 27, 2003 Share Posted May 27, 2003 Yeah, I read that thing just a few minutes ago... that actually might be the short-term solution. The card gateway is called E-xact http://www.e-xact.com/ There isn't a contribution for them here but it shouldn't be hard to hack the authorize.net module. -al Link to comment Share on other sites More sharing options...
mstefa Posted May 27, 2003 Share Posted May 27, 2003 I just tried what you were saying with paypal and even tho they browse and shop in USD once it gets to paypal it's correct canadian amount. hope that helped, Link to comment Share on other sites More sharing options...
halbert Posted May 28, 2003 Share Posted May 28, 2003 Yes!! That's the ticket! :D :D :D I wonder why I missed this earlier? No matter, it works and it solves my problem. Well, at least one of them! Thanks! -al Link to comment Share on other sites More sharing options...
mstefa Posted May 28, 2003 Share Posted May 28, 2003 There isn't a contribution for them here but it shouldn't be hard to hack the authorize.net module. -al are you good in it? I've been trying to modify one for my pay gateway, with no success for a month now.. Link to comment Share on other sites More sharing options...
halbert Posted May 28, 2003 Share Posted May 28, 2003 ummmm, perhaps that was a bit of bravado! I haven't actually looked too closely at it... I've been working on more basic problems right now. You might be able to do a simple https: call from within your store to a pre-fab secure page such as how Paypal works. Otherwise you might want to bother your pay guys and see what they can do to assist. I'm amazed at how reluctant these companies are to create solutions that would expand their customer base! Perhaps your hosting company has a solution? Good luck. What pay gateway are you using? -al Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.