Wrong total in bank module

[ellivir]

I also noticed just now that if I have a sum of 39 euro, I will have the problem in bank side. If I have the sum over 100 euro, like I just tried 165,10 euro, it comes ok in the bank module side.

Can this clear anything for anybody?

[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.

[ellivir]

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.

Ok, I compared and BBEdit highlighted these all the lines of "Dumping data for table...".
I guess, these are not very private info, so I can put here.

FIRST ONE IS:

CREATE TABLE `ws130currencies` (
`currencies_id` int(11) NOT NULL auto_increment,
`title` varchar(32) NOT NULL default '',
`code` char(3) NOT NULL default '',
`symbol_left` varchar(24) default NULL,
`symbol_right` varchar(24) default NULL,
`decimal_point` char(1) default NULL,
`thousands_point` char(1) default NULL,
`decimal_places` char(1) default NULL,
`value` float(13,8) default NULL,
`last_updated` datetime default NULL,
PRIMARY KEY (`currencies_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ws130currencies`
--

INSERT INTO `ws130currencies` VALUES (1, 'US Dollar', 'USD', '$', '', '.', ',', '2', 1.28410006, '2006-09-04 22:24:10');
INSERT INTO `ws130currencies` VALUES (2, 'Euro', 'EUR', '', 'EUR', ',', '', '2', 1.00000000, '2006-09-04 22:24:11');

THE SECOND ONE IS:
-- Dumping data for table `oxf_currencies`
--

INSERT INTO `oxf_currencies` VALUES (1, 'US Dollar', 'USD', '$', '', '.', ',', '2', 1.19166994, '2006-03-09 08:13:24');
INSERT INTO `oxf_currencies` VALUES (2, 'Euro', 'EUR', '', ' EUR', ',', '', '2', 1.00000000, '2006-03-09 08:13:26');

The first one is from the "working ok" webshop.

I don't know if these reveals anything. I have also tried to change these settings and it makes no effect on either way.

[ellivir]

Hi,

is there any list that would tell what changes are needed for self-made Bank payment modules when transferring from previous versions to the newest one?

How it is possible that under 100 euro orders are not fine in the payment site of the bank but the over 100 euro ones go without problems? All the time the checkout success page shows all correctly.

If chosen shipping of 0 euro (Store Pickup) also the payment under 100 euro goes fine. With table rate shipping or any other comes a problem even if the price added for the sum would be small. What can be the link between these problems?

I already lost huge amount of money. Everything in my shop looked fine (tested the bank as well but with higher amounts), so I reserved one week more time to finetune in peace and should have had the Grand Opening today. It was advertised widely and I have got lot of contacts why I'm not online. So complete disaster!

Elli
-trying to work 24h for the issue (without proper knowledge)

[DrByte]

Judging by the silence, I think the answer is ... your guess is as good as anybody else's.

Without studying the code at length and comparing it with some other module that is known to work properly and which uses similar methods ... I can't answer your questions.

But that's what will have to be done for you to get to the bottom of the issue.

[DrByte]

But, as you mention there is another site using it without problems, this is another option:
http://www.zen-cart.com/wiki/index.p...Obscure_Issues
(using a copy of their "working" files as a base)

[ellivir]

But, as you mention there is another site using it without problems, this is another option:
http://www.zen-cart.com/wiki/index.p...Obscure_Issues
(using a copy of their "working" files as a base)

That's what I did already ones and I got the result that the files were identical (just small translation related differences that I also went through in case there would be something). There must be something in the database differently but I was trying to compare that info as well without finding the reason.

Would you like to test if the payment module (it has ready test passwords, no restrictions to use) would work in your installation, DrByte? You could easily look if the problem comes to you for example with the table rate combined with under 100 euro/dollar/whatever currency. If it occurs even to you, we can know more about the issue. The payment module can be configured to use English in the bank as language and the problem happens also when using that so it may be easier for you. Send me a PM where I can send to you the bank module in case you manage to look it quickly.

Many thanks in advance any case!

Elli

[ellivir]

Hi,

I think I found something interesting. In my non-working test and shop-to-be webshops I have this kind of settings in database:

orders_total_id orders_id	title	text		value	class	sort_order
1 	1 	Välisumma: 	88,00 EUR 	88.0000 	ot_subtotal 	100
2 	1 	Postipaketti (1 x 2.00kg): 7,10 EUR 	7.1000 	ot_shipping 	200
3 	1 	VAT tax: 		17,15 EUR 	17.1488 	ot_tax 	300
4 	1 	Yhteensä: 	95,10 EUR 	95.1000 	ot_total 	999
5 	2 	Välisumma: 	59.00 EUR 	59.0000 	ot_subtotal 	100
6 	2 	Postipaketti (1 x 2.00kg): 7.10 EUR 7.1000 	ot_shipping 	200
7 	2 	ALV/VAT 22%: 	11.92 EUR 	11.9193 	ot_tax 	300
8 	2 	Yhteensä: 	66.10 EUR 	66.1000 	ot_total 	999
9 	3 	Välisumma: 	29,00 EUR 	29.0000 	ot_subtotal 	100
10 	3 	Table Rate (1 x 0.00kg) (Best Way): 	1,40 EUR 	1.3980 	ot_shipping 	200
11 	3 	ALV/VAT 22%: 	5,48 EUR 	5.4795 	ot_tax 	300
12 	3 	Yhteensä: 	30,40 EUR 	30.3980 	ot_total 	999

As you can see, some of the sums have "a comma", some have "a dot" as decimal pointer. This may create the problem we have seen. I asked what they have in the working one in this same database table and they have only dots, although they have the same settings in admin to use "commas" as decimal pointers and "nothing" as thousand pointer.

How could I correct this thing and try if this is the real problem?

Elli

[DrByte]

the list of order_total details you supplied appears fine.
The "text" field is for display purposes. The "value" field is used for calculations.

Unless there's a locale difference between servers, this shouldn't be a problem.

[ellivir]

the list of order_total details you supplied appears fine.
The "text" field is for display purposes. The "value" field is used for calculations.

Unless there's a locale difference between servers, this shouldn't be a problem.

Ok, indeed, I got the answer from the other webshop people and they said commas appear when orders are made in Finnish (they use also English in their shop unlike these two other shops).

This is what I got from them:
31.00EUR 31.0000 ot_subtotal 100
5.59EUR 5.5902 ot_tax 300
4.27EUR 4.2700 ot_shipping 200
35.27EUR 35.2700 ot_total 999
Sub-Total: 57,00EUR 57.0000 ot_subtotal 100
Flat Rate (Best Way): 5,00EUR 5.0000 ot_shipping 200
10,28EUR 10.2787 ot_tax 300
62,00EUR 62.0000 ot_total 999

Would you be ready for my zipped bank module? I know, you have helped a lot already and you are busy with other things, so I'm really blushing here asking these things but I'm kind of locked and in bad situation with this problem.

Elli