Wrong total in bank module

[ellivir]

Hi,

we have a problem that a total sum of the order calculated properly in checkout process ends up in the bank thousand times bigger sum! So, if we pay 52,90 euro, we get in the bank a payment for 52.897,00 euro! That would be nice for the shopkeeper but the customers may not like...

I think this is something do with the fact that in Europe we use commas instead of dots and other way round compared to USA and ZC has always some "hidden" settings for US shops... ;) So, we are using the proper set_local in finnish.php that the system understands for example to put the dates in our language but the commas and dots may have other settings somewhere...

I was trying to search for the solution being sure somebody would have asked about commas and dots but could not get any real results.

Elli

[ellivir]

Hi again,

I found a working shop that is also using the newest ZC (or actually 1.3.0.2) and it has been upgraded to use that version, not fresh install. So, it has got the settings of the earlier versions as well and it works perfectly for the bank modules! But in the same version the fresh install (I have tried 2 of them) won't work!

I've been comparing all the settings like Localization, there Currencies and Languages both, no changes there affects on anything in this issue. Neither the setlocal value ISO8859-1 should affect this since it is working for the dates etc.

I would just need to find out what it makes this thing to make the prices 1000 times bigger, moving commas or dots and making 52.897,00 euro out of 52,90 euro!

Please, help, I should have gone online with my new versions of ZC already.

Elli

[ellivir]

Nobody knows anything about this total sum problem?

[DrByte]

No idea.
If you've already compared every database-setting, then check your files
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

[ellivir]

No idea.
If you've already compared every database-setting, then check your files
http://www.zen-cart.com/wiki/index.p...Obscure_Issues

Could I somehow cleverly compare the database settings? I've been trying to compare with admin settings by going one by one in all navigation links through. Some settings were of course differently but by changing them didn't make any difference. If I make a SQL dump then I have lots of different things due to different products there.

I compared the folders and files of ZC in all three installations and they were identical. Only some translation package had different sentences but not different settings in setlocal or so on.

I guess I should just find where are the places that somehow guide the commas and dots, since that may give the answer... quite in panic over this matter anyway.

Elli

[ellivir]

Could I somehow cleverly compare the database settings? I've been trying to compare with admin settings by going one by one in all navigation links through. Some settings were of course differently but by changing them didn't make any difference. If I make a SQL dump then I have lots of different things due to different products there.

I compared the folders and files of ZC in all three installations and they were identical. Only some translation package had different sentences but not different settings in setlocal or so on.

I guess I should just find where are the places that somehow guide the commas and dots, since that may give the answer... quite in panic over this matter anyway.

Elli

Hi, more information:
it is strange but if I choose Store Pickup for shipment the bank module gets the right total sum, for example 49 euro to be paid.
If I choose Post Office delivery, and it adds some sum for the total and shows in checkout page for example 52 euro, it will be in bank module 52000 euro! So it is something to do with the shipping module calculations then. Now we have to just find out what it could be... anybody has any idea?

Elli

[DrByte]

Could I somehow cleverly compare the database settings?

You could compare the settings in the "currencies" table. Easiest way would be to do an export of the table and then use a diff tool like WinMerge to compare the output.