Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

URGENT Incorrect Order additions


dnoone

Recommended Posts

When a customer places an order through the site all seems fine however when trying to checkout they are asked to confirm twice. This then appears at the end after the order is placed.

Sub-Total: $20.00

Sub-Total: 54.68EUR

Flat Rate (Best Way): $5.00

Flat Rate (Best Way): 12.15EUR

IE TAX 21.5%: 11.83EUR

Total: 66.83EUR

Total: $25.00

 

It seems to be charging twice for some other items not ordered at all and in dollars.

 

ANy ideas

Link to comment
Share on other sites

In data base Your order total configuration values are dumped twice.

 

Chek this thru PhpMyAdmin.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

You need url of cpanel.

Login thru cpanel then there will be some icons for mysql and then for PhpMyAdmin.

Now thru PhpMyAdmin You will be able to open mysql data abse.

 

 

Go to table configuration and in configuration table for configuration_key fire a query

 

select * from configuration where configuration_key like '%MODULE_ORDER_TOTAL%'

if You find some repeated configuration_value then You need to remove those.

 

MODULE_ORDER_TOTAL

 

Satish Mantri

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

This is what I get

 

Showing rows 0 - 11 (12 total, Query took 0.0013 sec)SQL query:SELECT *

FROM configuration

WHERE configuration_key LIKE '%MODULE_ORDER_TOTAL%'

LIMIT 0 , 30 [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

 

Query results operationsPrint view Print view (with full texts) Export

row(s) starting from record #

in horizontal horizontal (rotated headers) vertical mode and repeat headers after cells

Sort by key: PRIMARY (Ascending) PRIMARY (Descending) None configuration_id configuration_title configuration_key configuration_value configuration_description configuration_group_id sort_order last_modified date_added use_function set_function

68 Installed Modules MODULE_ORDER_TOTAL_INSTALLED ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_tota... List of order_total module filenames separated by ... 6 0 2008-06-25 05:41:28 2006-01-18 07:19:45 NULL NULL

87 Display Shipping MODULE_ORDER_TOTAL_SHIPPING_STATUS true Do you want to display the order shipping cost? 6 1 NULL 2006-01-18 07:19:45 NULL tep_cfg_select_option(array('true', 'false'),

88 Sort Order MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER 2 Sort order of display. 6 2 NULL 2006-01-18 07:19:45 NULL NULL

89 Allow Free Shipping MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING false Do you want to allow free shipping? 6 3 NULL 2006-01-18 07:19:45 NULL tep_cfg_select_option(array('true', 'false'),

90 Free Shipping For Orders Over MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER 50 Provide free shipping for orders over the set amou... 6 4 NULL 2006-01-18 07:19:45 currencies->format NULL

91 Provide Free Shipping For Orders Made MODULE_ORDER_TOTAL_SHIPPING_DESTINATION national Provide free shipping for orders sent to the set d... 6 5 NULL 2006-01-18 07:19:45 NULL tep_cfg_select_option(array('national', 'internati...

92 Display Sub-Total MODULE_ORDER_TOTAL_SUBTOTAL_STATUS true Do you want to display the order sub-total cost? 6 1 NULL 2006-01-18 07:19:45 NULL tep_cfg_select_option(array('true', 'false'),

93 Sort Order MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER 1 Sort order of display. 6 2 NULL 2006-01-18 07:19:45 NULL NULL

94 Display Tax MODULE_ORDER_TOTAL_TAX_STATUS true Do you want to display the order tax value? 6 1 NULL 2006-01-18 07:19:45 NULL tep_cfg_select_option(array('true', 'false'),

95 Sort Order MODULE_ORDER_TOTAL_TAX_SORT_ORDER 3 Sort order of display. 6 2 NULL 2006-01-18 07:19:45 NULL NULL

96 Display Total MODULE_ORDER_TOTAL_TOTAL_STATUS true Do you want to display the total order value? 6 1 NULL 2006-01-18 07:19:45 NULL tep_cfg_select_option(array('true', 'false'),

97 Sort Order MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER 4 Sort order of display. 6 2 NULL 2006-01-18 07:19:45 NULL NULL

Check All / Uncheck All With selected:

row(s) starting from record #

in horizontal horizontal (rotated headers) vertical mode and repeat headers after cells

 

 

 

 

You need url of cpanel.

Login thru cpanel then there will be some icons for mysql and then for PhpMyAdmin.

Now thru PhpMyAdmin You will be able to open mysql data abse.

 

 

Go to table configuration and in configuration table for configuration_key fire a query

 

select * from configuration where configuration_key like '%MODULE_ORDER_TOTAL%'

if You find some repeated configuration_value then You need to remove those.

 

MODULE_ORDER_TOTAL

 

Satish Mantri

Link to comment
Share on other sites

Sub-Total: $20.00

Sub-Total: 54.68EUR

Flat Rate (Best Way): $5.00

Flat Rate (Best Way): 12.15EUR

IE TAX 21.5%: 11.83EUR

Total: 66.83EUR

Total: $25.00

 

 

You have two currencies in store.

Just for testing remove one and then test.

Very strange.

 

 

Satish

 

It appears that code is taking both currencies and then displaying.Ver

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

I have now removed the other currencies but I am still getting the dollar entry and the weird item added. Two totals etc.

 

Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)

1 x sportwear 0.00% 34.00EUR 34.00EUR 34.00EUR 34.00EUR

1 x Midland 42KM GXT700 Walkie Talkie 2 Two Way Radio Midland 42KM 21.50% 45.00EUR 54.68EUR 45.00EUR 54.68EUR

1 x Sony - DSC-S730/7.2Mpix 3xZoom 2.4" LCD 1487069 21.50% 78.00EUR 94.77EUR 78.00EUR 94.77EUR

Sub-Total: $34.00

Sub-Total: 149.45EUR

Flat Rate (Best Way): $5.00

Flat Rate (Best Way): 18.23EUR

IE TAX 21.5%: 29.68EUR

Total: $39.00

Total: 167.68EUR

 

Help please driving me mad the email I receive from the site is correct though,

 

 

 

 

Sub-Total: $20.00

Sub-Total: 54.68EUR

Flat Rate (Best Way): $5.00

Flat Rate (Best Way): 12.15EUR

IE TAX 21.5%: 11.83EUR

Total: 66.83EUR

Total: $25.00

 

 

You have two currencies in store.

Just for testing remove one and then test.

Very strange.

 

 

Satish

 

It appears that code is taking both currencies and then displaying.Ver

Link to comment
Share on other sites

Getting desperate now, any ideas on how to resolve this. Customers not purchasing now as a result.

This is what they are getting.

 

Sub-Total: $20.00

Sub-Total: 54.68EUR

Flat Rate (Best Way): $5.00

Flat Rate (Best Way): 12.15EUR

IE TAX 21.5%: 11.83EUR

Total: 66.83EUR

Total: $25.00

 

 

Help please.....

 

 

I have now removed the other currencies but I am still getting the dollar entry and the weird item added. Two totals etc.

 

Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)

1 x sportwear 0.00% 34.00EUR 34.00EUR 34.00EUR 34.00EUR

1 x Midland 42KM GXT700 Walkie Talkie 2 Two Way Radio Midland 42KM 21.50% 45.00EUR 54.68EUR 45.00EUR 54.68EUR

1 x Sony - DSC-S730/7.2Mpix 3xZoom 2.4" LCD 1487069 21.50% 78.00EUR 94.77EUR 78.00EUR 94.77EUR

Sub-Total: $34.00

Sub-Total: 149.45EUR

Flat Rate (Best Way): $5.00

Flat Rate (Best Way): 18.23EUR

IE TAX 21.5%: 29.68EUR

Total: $39.00

Total: 167.68EUR

 

Help please driving me mad the email I receive from the site is correct though,

Link to comment
Share on other sites

Getting desperate now, any ideas on how to resolve this. Customers not purchasing now as a result.

Help please.....

 

Just a thought, have you checked the MODULE_ORDER_TOTAL_INSTALLED setting in your configuration table. Perhaps you've got some fields added twice somehow? It should read something like: ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php

 

Also check your default currency is set properly: DEFAULT_CURRENCY in the configuration table. It looks like you should have that set to "EUR" in your case?

Link to comment
Share on other sites

Both of these entries in the configuration table seem fine.

 

???

 

 

 

 

Just a thought, have you checked the MODULE_ORDER_TOTAL_INSTALLED setting in your configuration table. Perhaps you've got some fields added twice somehow? It should read something like: ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php

 

Also check your default currency is set properly: DEFAULT_CURRENCY in the configuration table. It looks like you should have that set to "EUR" in your case?

Link to comment
Share on other sites

Ok managed to sort this problem, I seemed to have the incorrect entries in the orders_totals table and also in the

Orders_products table, once removed all is fine.

 

One last question wehn purchasing and paying via the paypal option the amount passed to paypal for payment is the total minus the

shipping and tax why is this....

Rgds

 

 

 

Both of these entries in the configuration table seem fine.

 

???

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...