Currency display problem

[dontom]

Hi,
just went from 2.4 to 3.01 and have one question - within the options "Default Currency" ist set to EUR (as it always was) - but the items are displayed with the $ symbol.
How can I solve this?
Thanks

[dontom]

Found it
PP added an new column "currency" in the products table and added the value USD everywhere

I fixed it by doing this:
update pp_products set currency = "EUR"

[Chuck S]

Yes I that could be a problem if you had it set to something else I will look at changing the upgrade to try and grab the currency and set it appropriately only issue is we only support certain currencies so I would need to see how to do that without messing things up thats why all ads where set to default.

[dontom]

ok, got it.

If automatically is not possible, perhaps adding a hint into the upgrade doc will do, so people know what they have to do...

[Chuck S]

Yeah the old classifieds you entered your own currency and then symbol whereas the new one you enter the currency and the currency table has the correct hex codes etc all we need and more streamlined. I would have to think on how to handle that but a note in the upgrade docs is probally easiest considering since we only support what like 15-20 currencies and there are tons more out there.

[Simka]

Hi Chuck.

I have the same problem, I want DKK as default, but new uploads still get $ when created.

I have run: update cp_products set currency = "DKK" (thats works for the old ads)

Then set the default currency in database to be DKK but new ads still being USD with the $ ???

[Chuck S]

well is there an actual DKK currency? I am not sure about that one

I just checked there is no DKK currency in our product so you would need to lookup the correct info for whatever currency that is and insert an entry into the cp_currency table.

[Simka]

Originally Posted by Chuck S

well is there an actual DKK currency? I am not sure about that one

I just checked there is no DKK currency in our product so you would need to lookup the correct info for whatever currency that is and insert an entry into the cp_currency table.

Yes there is,It was allready there, as ID 8
so thats not the problem :-(

[Chuck S]

Ok well what exactly is the issue?

If you truly set an ad to be the denmark croner by default it will be that but I would suspect you do not have it set correctly.

whats the currency you select when uploading?

If your uploading an ad as US then thats why its displaying as US.

[Simka]

Originally Posted by Chuck S

Ok well what exactly is the issue?

If you truly set an ad to be the denmark croner by default it will be that but I would suspect you do not have it set correctly.

whats the currency you select when uploading?

If your uploading an ad as US then thats why its displaying as US.

Yes, it is set correct in PP admin to denmark as default :-)

Problem is that new uploads get the dollar sign and not the (kr).

I have removed the currecy dropdown from uploadsproduct template (no need to be selected as DKK is the only option I want)

[Chuck S]

Well if thats the case then you must properly hard code a hidden input string with the currency set to the proper value.

[Simka]

So the default field in database have no effect?

[Chuck S]

If you have proper modified things it should however I would suspect this is not the case.

At any rate my product support answers are limited to the normal operation of the program. The default currency is US in the database. If you upload an ad and set the currency to be DKK it is most definately displayed with DKK as the currency.

You can remove the currency field if you choose in the uploadproduct template but you must put something like this in the uploadproduct template where noted

CODE MODIFICATION MUST ALWAYS BE DONE CORRECTLY. we dont really provide although this hint should help

Content visible to verified customers only.

[Simka]

Thanks, i try that.

[Chuck S]

no problem