I am now running into a much larger issue with this "feature" and can't figure out how to fix it without altering the table definition to 2 decimal places. This exact behavior occurred for my client's store today:
1) A customer enters and order with a subtotal of $209.90 and shipping cost of $7.50. 2) The tax % that applies for this order is 12.25%; resulting in a tax amount of $25.71275 (209.90 * .1225 = 25.71275) 3) The order total is $243.11275 (209.90 + 7.5 + 25.71275 = 243.11275) 4) Satchmo attempts to process the payment with Authorize.net for $243.11 and succeeds with a transaction approved response. 5) Satchmo now logs the message, "Order #103 not paid in full, sending to pay rest of balance". This is occurring b/c the order has a remaining balance of $0.00275. 6) Satchmo attempts to process the payment with Authorize.net for $0.00 and fails with the message, "A valid amount is required." 7) Satchmo logs the message, "Order 103 - skipping recalculate_total since product is partially paid." 8) Satchmo sets the order status to None opposed to Pending as is expected. This is causing an issue as my client sees the order as Authorized in Authorize.net, but not Pending in the Satchmo Admin. Furthermore, Satchmo is executing too many auths against the credit card. I don't want to alter the tables to only have 2 decimal places as this seems to have been implemented as a feature for tiered pricing, which makes sense and may be implemented for this store in the future. But this needs to get fixed so only 1 auth occurs and ideally the pricing displays in 2 decimal format in the admin order detail page. Does anybody have an opinion on this matter or could you tell me whether this is going to be fixed in the next version of Satchmo? Thanks, Trent On Apr 13, 10:28 pm, Evan LeCompte <[email protected]> wrote: > 0E-10 is scientific notation since somehow the database is using 9 > decimal places. > > To solve this quickly I just altered the database tables to use more > sane values, i.e. 2 decimal places for prices, and 1 decimal for > quantities. > > This seems to be working fine so far... > > But if this could cause problems, perhaps someone should inform me! > > On 4/1/09, Ned <[email protected]> wrote: > > > > > On Mar 9, 4:45 pm, Evanlec <[email protected]> wrote: > >> Also getting the 0E-10 numbers in my orders... > > > Looks like 0E-10 is not Postgres-specific. > > > I saw it on the Change Product Order screen running > > SVN-2015 and MySQL. > > > Ned --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en -~----------~----~----~----~------~----~------~--~---
