kamkaz Posted December 7, 2005 Posted December 7, 2005 Hi people. I have a intresting problem with my store. The amount shown on account differs from the amount charged on their CreditCard. When a customer buys something we both get an email for the final amount charged, say $328.00 taxes and shipping in. Then, I go to check to see if my PSI Gate stuff was working and I noticed that it had charged the customer's card a little less, ie $321. I can only assume the store is getting it right becuase the amounts add up, the shipping and taxes are calculated correctly and finally the confirmation email is right aswell. I also check double check the orders in the admin section. All orders so far have had this problem. By assuming the store is right, the error must lie in the transmitting to PSI Gate. M store is simple and close to a bare bone install. The only contrbutions I have installed is: *for shipping: http://www.oscommerce.com/community/contri...ons,1333/page,4 *I have done some intresting work to get taxes to work for the canadian laws *I use PSI XML: http://www.oscommerce.com/community/contri.../search,psi+xml Any ideas? Best Regards
bobg7 Posted December 7, 2005 Posted December 7, 2005 I'm just wondering if perhaps your payment module is sending the total without shipping and taxes, would the total sent be correct then? Installed Contributions: CCGV, Close Popup, Dynamic Meta Tags, Easy Populate, Froogle Data Feeder, Google Position, Infobox Header Entire Row, Live Support for OSC, PayPal Seal with CC images, Report_m Sales, Shop by Price Revised, SQL Updater, Who's Online Enhancement, Footer, GNA EP Assistant and still going.
kamkaz Posted December 7, 2005 Author Posted December 7, 2005 No that is no the case. This is what I have Admin | Reports | Orders section: a item: $259.99 Sub-Total: $259.99 Shipping Rate for this item (Shipping Rate): $20.00 PST + GST $39.20 Total: $319.19 ---------- Then wen I go to secure.psigate.com the amount shown is 316.39
kamkaz Posted December 7, 2005 Author Posted December 7, 2005 I should add that the ratio of the amounts is not the same for all amounts. Meaning it is not a 2% differance all the time. The amounts vary.
Guest Posted December 22, 2005 Posted December 22, 2005 kamkaz, I have the same problem... Did you check into your "orders_total" table? Search for tax rows... probably they are not really included in the final total, so real amounts pass to your creditcard module do not include taxes.... Are you using such contribution like Canadian Taxes Display? I am, so probably the problem comes from that contrib... Jeff I should add that the ratio of the amounts is not the same for all amounts. Meaning it is not a 2% differance all the time. The amounts vary.
kamkaz Posted December 29, 2005 Author Posted December 29, 2005 Thank you for your reply. I checked the 'orders_total' and here is the output: orders_total_id | orders_id | title | text | value | class | sort_order41 | 12 | Sub-Total: | $139.98 | 139.9800 | ot_subtotal | 1 42 | 12 | Shipping Rate for this item (Shipping Rate): | $40.00 | 40.0000 | ot_shipping | 2 43 | 12 | 7.0% Tax GST#866037682RT: | $12.60 | 12.5986 | ot_tax | 3 44 | 12 | Total: | <b>$192.58</b> | 192.5786 | ot_total | 4 Then for this particular order on secure.psigate.com it says the persons card was charged: $189.78 not sure where else to look. Thanks kamkaz, I have the same problem... Did you check into your "orders_total" table? Search for tax rows... probably they are not really included in the final total, so real amounts pass to your creditcard module do not include taxes.... Are you using such contribution like Canadian Taxes Display? I am, so probably the problem comes from that contrib... Jeff
kamkaz Posted January 3, 2006 Author Posted January 3, 2006 Did you have any success in fixing it? I am not sure where to start looking. I am using Canada Tax Zones Setup notes ( http://www.oscommerce.com/community/contributions,1124 ) for taxes. Any help would be great. Thanks kamkaz, I have the same problem... Did you check into your "orders_total" table? Search for tax rows... probably they are not really included in the final total, so real amounts pass to your creditcard module do not include taxes.... Are you using such contribution like Canadian Taxes Display? I am, so probably the problem comes from that contrib... Jeff
kamkaz Posted February 3, 2006 Author Posted February 3, 2006 networkdad has been really nice in helping me. This is what he wrote: Ok, i got it partially figured out. Whats going on, is that the tax rates are not being applied to the shipping fee. I am not sure why though. Look at the order on 12/08/2005 for $192.58 The subtotal is $139.98 Shipping is $40.00 Tax @ 7.00% - $12.60 Total - $192.58 The total for him actually charged $189.78 - A difference of $2.80 $2.80 is the exact amount of tax on the shipping fee of $40.00 So..the problem is not my module, but rather the cart. The module relies upon the cart to send the value. Here's the line of code i use to send the total $psi->setSubTotal(number_format($order->info['total'] * $currencies->get_value($currency), 2)); Take the total of the order, and multiply it by the currency rate, out to 2 decimal places. If the cart sends $189.78 as the order total, then thats what the module uses. We need to find out why the shipping is not being taxed into the calculation..I'll poke around and see what i can come up with Jason So I have started to look but I don't think I am in the proper file/place.
crashwave Posted February 4, 2006 Posted February 4, 2006 shipping is not taxed. If YOUR cart is showing you total with taxed shipping yours is wrong remove tax from shipping. q_|_|| _|9~~J >-o>-o q_|_|| )| q_|| )
crashwave Posted February 4, 2006 Posted February 4, 2006 Don't know how it is with the canada contribution. Do they charge taxes on shipping there. In US (as far as I know) Shipping is not taxed and the payment system you use (in us)will not add the % amount from shipping to final price only % of item...Unless, with some and if they offer it, you specifically add that option. q_|_|| _|9~~J >-o>-o q_|_|| )| q_|| )
kamkaz Posted February 4, 2006 Author Posted February 4, 2006 Ok that is fine. I can calc the taxes right into the feild.... BUT the problem is that on the final amounts on checkout, it looks like they are being charged taxes on shipping. So it looks like this if they buy two items: item + item = Subtotal (Subtotal + Shipping) * taxes = Total But if you look at what their credit card is being charged you see: item + item = Subtotal (Subtotal * taxes) + Shipping = Total Which is how the contrib works. So why is it displaying the one way and charging the other?
flying_kites Posted July 21, 2006 Posted July 21, 2006 Did you ever work out your PSIGate totals problem? We have it too. Not for every order - just one every so often. So far we can't work out a pattern and why it is happening.
cinolas Posted December 7, 2006 Posted December 7, 2006 Same problem here (Client is not charged tax on shipping as he/she should and as reported by osCommerce). I would really appreciate a solution here, I bet you guys have figured it out since 2005. Thanks!
mikeshantz Posted December 18, 2006 Posted December 18, 2006 I have suggested a fix in the main support thread
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.