Getting Started - Additional currency

Print Page | Close Window

Additional currency

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4104
Printed Date: 30-November-2024 at 6:06pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Additional currency

Posted By: stevejebson
Subject: Additional currency
Date Posted: 28-October-2010 at 11:19am

Hi,

Seriously looking at switching to PC now, just need to know if it's possible to have an additional Price for Euro for both Retail and Wholesale. We're UK based and trade mostly in europe as well as the uk but have different prices. We also switch product descriptions based on language, i.e French, Italian & English.

On current site we just have a couple of flag icons that store cookie info and then display product description and price depending on cookie setting.

can we do this out of the box or could we customise fairly easily ?

thanks

Steve

Replies:

Posted By: Greg Dinger
Date Posted: 28-October-2010 at 12:47pm

That's a tough one Steve. Out of the box, you can only have one currency and one language. The effort needed to do what you are asking would likely be surpassed greatly by the easier alternative - just having one store in Pounds, and one in Euros. You may be able to use Google's translation service for multile language choices, if that seems workable.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: stevejebson
Date Posted: 29-October-2010 at 4:36am

Ideally would not want to use the translation service as we have all our product descriptions translated locally so would prefer to have custom fields to hold the Italian/French versions.

The only problem i can see with multiple sites for euro/sterling is the initial cost i.e. license fee, especially if we go with the BTO. Still not sure if we will need that or not...

So this is gonna be tricky, 'cos i can't see the source and work out if i can fiddle, I'm a programmer by trade, more asp than .net, and i've looked at a lot of carts and this ticks so many boxes for me.... decisions, decisions !!

Posted By: Greg Dinger
Date Posted: 29-October-2010 at 9:51am

Here's the issue Steve. There are 3 languages files in the system, two for the front end and one for the admin. Those files contain tokens such as this one:

dictLanguage.Add "english_advSrca_1", "Search our product catalog"

Clearly those can be translated. Not a big deal. But there is no built-in support for flipping "english" to "french", based on some switch setting. There is simply a point in the "start session" module that does this:

session("language")=Cstr("english")

So the first thing you have to do is to esablish logic to identify language preference and set that value. I have never gone down this road, so I don't know where the gaps are exactly. But I do know there are points, particularly (but not exclusively) in the admin, where there are strings of text that don't take their input from these languages files and would therefore have to be coded on a page-by-page basis. (Future upgrade maintenance alert!)

There are also a couple common error message files, like msg.asp, that have strings of text. Again, one would do something to detect language preference and alter these scripts to somehow work in a multi-language environment. (msg.asp is called from all over the place - lot's of difficult testing required after doing this because this is typically sending errors to the screen where something has gone wrong, thus you are looking for ways to create problems in order to force the necessary tests to take place.)

If the above was all that had to be dealt with, that might be easy - or at least doable. But it is not. The tough part is that there is only one set of fields in database tables such as the category and product tables. All of those product and category names, short descriptions, long descriptions, and so on - those are there in one language alone, and would therefore have to be duplicated to contain individually translated copies of each field. And this is where it really gets muddy. You start down this path, and you end up with a store that cannot realistically receive upgrades because the breadth of the changes are going to be so wide, once you are done you won't want to migrate the changes to a new version. It is going to cost a fortune.

So when you push back on the basis of cost of extra licenses (even BTO), that is NOTHING compared to the vortex you will enter when you start to alter the system for multi-language support. I bid a project for a Canadian shop that required French/English and the price was around $20k if I recall.

ProductCart is awesome. Look at the variety of stores in http://www.greatonlinestores.com - www.greatonlinestores.com . We're able to make it stand on its head, literally. But trying to do the above would make my head explode. It would be so much work. Rolling out multiple stores would be SO much easier, and SO much less expensive - both inititially as well as in the future.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: stevejebson
Date Posted: 29-October-2010 at 10:03am

Thanks for the thoughtful and comprehensive reply. I'm pretty sure we are gonna go down the PC route and i just know i'm gonna see what i can do, won't be able to help myself ;-)

I won't be looking for complete language support, just need to display product descriptions in french/italian which is why i was thinking of custom product fields and then displaying those or overwriting original description with custom field version. Same thing possibly with the Euro price.

I'll let you know as soon as i fail ;-)

Steve

Posted By: stevejebson
Date Posted: 29-October-2010 at 10:03am

oh, and all the admin will be in english

Posted By: Greg Dinger
Date Posted: 29-October-2010 at 10:12am

I don't want you to fail, I just want you to recognize what a challenge this is. Not only are you confronted with adding new fields for the product names and descriptions (that alone is not that tragic an effort), then you have to look beyond the product pages where that gets displayed. There are a number of pages in the shopping section that will need to be dealt with, plus the saved cart and view cart pages, then go have a look at the checkout process. With that done, do you also have to deal with the e-mails that are sent, because there you go diving deeper.

Give me a shout over at my site directly if you want to talk about hosting, assistance, etc.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: netprofits
Date Posted: 29-October-2010 at 10:31am

Hi Steve,

I have thought through this before and here are the issues/ideas I found:

1. Product Cart has three main “languages” files, one for the main site, one for the one-page checkout and one for shipping. The main file is included on every page of the front end of the site. It includes 100s of text labels in English. In order to use a different language, someone (the merchant) would need to duplicate all of those labels, change the variable names from English to the new language and then translate all of the labels to that language. All of the labels for all languages would need to be included in this same file which would get quite large. Fortunately it is processed on the server so it is pretty quick but the file will increase in size with each new language. I would recommend customizing this as well so that the dictionary only loads the elements for the language specified.

2. The template (header/footer) files will need to NOT use any language specific text, i.e. all text such as navigation links, titles, section headings, etc. would need to be added to the languages file.

3. PC uses multiple button images/icons throughout the site. These are only defined in one place, i.e. using one language. Different sets of images would need to be loaded/displayed based on the selected language.

4. The email content sent to customers when orders are placed is only defined for one language. There would need to be a way to edit those emails for each language and the email sending routines would need to select the correct language.

5. All categories and products are defined in only one language. Our initial thoughts would be:
Create top level categories for each required language. The subcategories would be duplicated under each language where the merchant can enter different translation of the categories for each language. Each product would need to be duplicated for each language and linked to the correct subcategory for that language.

The product categories navigation on the site would need to be customized to only show product subcategories under the main category for the selected language.

6. Content Pages: Merchant would need to create a language specific content page for each page of content. We'd need to designate which language the page links to and then only show content pages for the selected language in the navigation.

7. Biggest issues are how to handle multiple currency formats, weights (lbs vs. kilo), etc. by country.

Hope that sheds some more light on the subject.

As Greg mentioned, in the end, multiple sites is probably the quickest and least expensive route especially when considering upgrades.

-------------
NetProfits Internet Consulting

Certified ProductCart Developer

http://www.nicwebdesign.com" rel="nofollow - Our Site

Posted By: Greg Dinger
Date Posted: 29-October-2010 at 10:48am

Dan is precisely correct on this - and I didn't even think about the buttons, the content pages, the e-mail message settings in the admin, and so on. You can see why I raise the red flags on this - it's almost impossible to do it well, and to end up with anything that can be managed in terms of installing future upgrades.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |