FIX PRICING AND CURRENCY PROBLEM

[scott_white85]

Hi all,

im new to oscommerce and i have this problem. my current website have 2 currencies: singaporean dollar as default currency and another one is the US dollar. i need to set fix pricing in USD for one of my categories and the rest categories is singaporean dollar. how can i fix this? thanks a lot for your inputs.

[Guest]

Scott,

 

 

There is no current method to set a currency per category.

 

 

 

 

Chris

[scott_white85]

ok not in category but for every products. please help.

[satish]

You can not have prices in two currencies.

 

The other option is that you need to add a field to each product for currency default to be used.

 

Follow this by making modification in template / function to display price using field associated with that product.

 

But when add to cart is done it will use any one currency.

 

Satish

[scott_white85]

hi satish did you try this one? kindly see this link : http://www.oscommerce.com/community/contributions,4445/

thanks.

[satish]

That will not allow products to be shown with cost of specified currency( prod 1 usd, prod 2 GBP not possible with that).

 

Satish

[scott_white85]

so what will i do now to have this one = prod 1 usd, prod 2 GBP with my own coding..? thnx

[satish]

How do you look into this scenario.

Say a customer adds product 1 as well as product 2 which currency will cart calculate its total.

 

Satish

[scott_white85]

hey satish i think you are right.. but what if they have different containers that will hold the total for SGD and total for USD? is that possible?

[scott_white85]

or i will create two different stores that will hold for products in USD and SGD?

[satish]

hey satish i think you are right.. but what if they have different containers that will hold the total for SGD and total for USD? is that possible?

This is not possible with oscommerce.

 

Satish

[scott_white85]

can you give me enough reason why it is not possible so that i can explain it well to the client.

 

But what if we alter the database? make a column that will hold a currency symbol for SGD and USD, concatenate it to the products_price to make a final_price. then call it to your php code to add all the values for SGD and USD to make a separate total for each? is my logic correct? are all these possible? please advise me. thanks a lot for your help.

[Guest]

Scott,

 

As Satish explained, the core code of osCommerce cannot process two currencies upon checkout. Even if it could, your payment processor could not process two currencies when they receive the payment information.

 

It is not possible to process two currencies with one transaction even if you could assign products individual currencies.

 

 

 

Chris

[MrPhil]

What is your client trying to accomplish here? What is the purpose of having two or more currencies in play at one time? How do you add SPD and USD prices and come up with a result that makes sense? osC will let a customer see everything in one or the other, but not both at the same time. You would have to convert one to the other anyway, to come up with a total. Look at it from the viewpoint of a customer -- who is going to want to juggle two different currencies at once?