jschner Posted July 7, 2003 Share Posted July 7, 2003 Confirmation shows the right pricing but the invoice shows $0 Products------------------------------------------------------ 1 x SPENT T-Shirt (sp-t-r 01) = 0 ------------------------------------------------------ Sub-Total: 0 United Parcel Service (1 x 1.1lbs) (Ground): 0 Total: 0 Running msi 2.2. No mods. The pricing showed on the invoice in previous orders but now shows $0 in all. I searched for "invoice" "price" around here with no luck. Any help or ideas greatly appreciated. TIA! Jim Link to comment Share on other sites More sharing options...
jschner Posted July 7, 2003 Author Share Posted July 7, 2003 This has me pretty much baffled. The orders appear to go through just the pricing is made $0 on the order, email to customer, and the invoice. I don't have access to the Paypal account so I don't know if a customer was charged or not yet. Here is an example of a pending order looking through admin: Payment Method: PayPal Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc) 1 x OEM Fuel Filter P/N 5000544 0.0000% $0.00 $0.00 $0.00 $0.00 1 x OEM Paper Oil Filter P/N 5001740 0.0000% $0.00 $0.00 $0.00 $0.00 1 x TC4 Front Engine Mount Kit SB03-01 0.0000% $0.00 $0.00 $0.00 $0.00 Sub-Total: 0 United Parcel Service (1 x 4.862lbs) (Ground): 0 Total: 0 Date Added Customer Notified Status Comments 07/07/2003 13:39:04 Pending Tried searching half the day today. Any one have a guess or any clues where I should look? Jim Link to comment Share on other sites More sharing options...
Silencer Posted July 8, 2003 Share Posted July 8, 2003 Some glues: 1. Currency value zero. 2. Problems with payment module. Enable "cash on delivery" and make test order. 3. Solar emissions :) There is always more than one way to do it. And always Keep It Simple, Stupid. Link to comment Share on other sites More sharing options...
jschner Posted July 8, 2003 Author Share Posted July 8, 2003 Thank you for your reply, -Currency value =1.000 -Checks, COD and Paypal all do the same thing, setting everything to $0 -Solar Emissions? One more clue is that Paypal does bill and send the payment with the correct pricing so that part is good. I don't really understand the sequencing in OSCommerce but it seems the pricing info in orders is not reading the order info in the database correctly, here is a dump of one of my orders from my database. TABLE ORDER PRODUCTS(16, 13, 29, 'P/N 5000544', 'OEM Fuel Filter', '6.4900', '6.4900', '0.0000', 1), (17, 13, 28, 'P/N 5001740', 'OEM Paper Oil Filter', '16.0000', '16.0000', '0.0000', 1), (18, 13, 69, 'SB03-01', 'TC4 Front Engine Mount Kit', '29.9500', '29.9500', '0.0000', 1); TABLE ORDERS TOTAL(39, 13, 'United Parcel Service (1 x 4.862lbs) (Ground):', '0', '9.8200', 'ot_shipping', 2), (40, 13, 'Total:', '<b>0</b>', '61.8200', 'ot_total', 4), (38, 13, 'Sub-Total:', '0', '52.0000', 'ot_subtotal', 1); Even though it's $0.44 short on the subtotal I do see some pricing in there and Paypal is getting billed but the ADMIN and emails all show $0 in the order amounts. Real goofy problem. Jim Link to comment Share on other sites More sharing options...
Silencer Posted July 8, 2003 Share Posted July 8, 2003 Try disable ALL "Orders total" modules and make test order. There is always more than one way to do it. And always Keep It Simple, Stupid. Link to comment Share on other sites More sharing options...
jschner Posted July 8, 2003 Author Share Posted July 8, 2003 AH Ha! I got it. I lied when I said I didn't mod my OSC. I forgot I had to do this odd mod to get my orders to go through at one time. http://www.oscommerce.com/forums/viewtopic.php...ghlight=#183484 I reversed it and it started working correctly for new orders and the original problem hasn't shown up either. I edited the two tables above and now have all the bad orders corrected. So back on June 14th my Host did something to cause me to add the mod then on July 5th he undid it or unknowingly fixed something and all is well for the moment. Talked to him and he said the only thing he did two days ago was swap a harddrive. Corrupted file maybe? Man what a work out. Time for a break. :wink: Jim Link to comment Share on other sites More sharing options...
jschner Posted July 8, 2003 Author Share Posted July 8, 2003 Oh and maybe the harddrive was corrupted by them solar emissions. yes? :? Thanks for the help! Jim Link to comment Share on other sites More sharing options...
jschner Posted July 8, 2003 Author Share Posted July 8, 2003 Well it looks like my break is over. I just had one order go through all $0 again. I tried two test orders and they were all $0. Then I had another order go through by a customer and it worked fine except I didn't get an email for the order. I'm really at a loss at what is going on. :?: Any more ideas at all out there? Jim Link to comment Share on other sites More sharing options...
jschner Posted July 8, 2003 Author Share Posted July 8, 2003 Looks like the email finally came through so that is not an added problem. Can anyone tell me which file or step process how the information for pricing of ordered products are submitted into the datbase? As the data shows above the the totals between the bold tags are getting written as $0. TIA for any clues. Jim Link to comment Share on other sites More sharing options...
jschner Posted July 17, 2003 Author Share Posted July 17, 2003 This is related to another problem found here: http://www.oscommerce.com/forums/viewtopic.php...p=197711#197711 Jim Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.