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

[ellivir]

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

So, even if I put in my tests the original Table Rate module as shipping module the failure in bank module makes the sum thousand times bigger.
In case the shipping is free or chosen Store Pick Up (0 euro) the sum in the bank comes correct.
I still think that the shipping module may add the shipping price in English settings like 1,000.00 euro style, so in that case for example price written 5,00 euro of shipping will be understood as thousands. On the other hand it is strange it indeed doesn't happen on the web site part yet but only is visible in the bank. The checkout success page looks fine.

[ellivir]

I forgot to tell I also tried to change the default language for English but the problem still occured. I even removed other languages and kept only the English but still I had the same problem.

[ellivir]

I forgot to tell I also tried to change the default language for English but the problem still occured. I even removed other languages and kept only the English but still I had the same problem.

Am I really alone here with my problems?
I tried to upgrade the webshop for this latest 1.3.5. version but the problem just persists.
I kept the shop as naked as possible to test the bank module functioning but no result. Of course I have the settings imported from the previous shop since I indeed made a proper upgrade process for it.

But my panic is deepening really...

Elli

[ellivir]

Am I really alone here with my problems?
I tried to upgrade the webshop for this latest 1.3.5. version but the problem just persists.
I kept the shop as naked as possible to test the bank module functioning but no result. Of course I have the settings imported from the previous shop since I indeed made a proper upgrade process for it.

But my panic is deepening really...

Elli

I noticed that all my "ä" and "ö" letters (Scandinavian characters) gets kind of corrupted when I make the SQL dump for the upgrade. Can this be a problem for the Wrong Sums in bank module as well? I corrected all the ä and ö by hand from the admin for the products. What kind of settings I should have for the SQL dump and what kind of ä and ö the system understands in database, for example ‰ or html code ä or pure ä?

Elli - in despair trying to find a solution