Guest Posted December 16, 2002 Share Posted December 16, 2002 :cry: Well it seems something has gone hay wire. For the past couple of days I noticed I was getting an email from Paypal telling me that there was a payment I go to the Orders in Admin and there is no order. Now luckly I have been able to send an email to the customer telling them I need to confirm there order and they send it to me. So with this problem I figured that people are not going back to OSC after submitting there order so I installed the Paypay IBN. Ran a test order and it seems to work fine. So these are the only changes. Now for the weird part, When someone places an order I get duplicate orders. Example: John Doe comes in and shops. (This is the only way I have been able to create the problem) Adds some stuff to his cart and maybe leaves or deletes these items from the cart. He then goes to checkout and lets say he orders 1 product for 15.00 + shipping equals 19.95. I get an email from Authorise.net that the payment was approved. I go and look at the order and there are duplicate orders. With some products that far exceed the paymnet amount. Example: Order View: 1 x Product 6% $26.69 $28.29 $26.69 $28.29 1 x Product 6% $16.69 $17.69 $16.69 $17.69 Sub-Total: $16.69 Sub-Total: $26.69 Discount Coupon: $2.67 Tax: $1.00 Tax: $1.44 USPS priority Mail 1 X 1: $4.85 UPS 1DP 1 X 1: $17.05 Total: $30.31 Total: $35.76 Notice coupon was not used on this order, duplicate tax (When they aren't even in Fla) Dulpicate Shipping. His credit card was approved for 35.76. The REAL order total is you add them up is 63.03. So I do not know what they guy ordered. Like I said I think it has to do with Shopping Carts info be retained and they have left or something. We do not use discount coupons even now it is installed. I have 15 orders from last night that this has happened. too. I am using 2.2 pre Nov. Any help would be greatly appericated kmcar Link to comment Share on other sites More sharing options...
Ian Posted December 16, 2002 Share Posted December 16, 2002 This may be related to the authorizenet payment module, and possibly the use of the credit class. IIRC authorizenet is unusual in it's use of the before_process method in the payment module. You say that this is a pre-november snapshot, which means it is not the new checkout. Have you made any modifications to the checkout pages (checkout_payment.php, checkout_confirmation.php, and checkout process.php) apart from those required for the credit class installation. Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Ian Posted December 16, 2002 Share Posted December 16, 2002 Just realised, at the top of your post you mention using paypal, paypal ipn, then later on you mention authorise.net. If it is paypal ipn you are using, which version have you installed. Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Guest Posted December 16, 2002 Share Posted December 16, 2002 Just realised, at the top of your post you mention using paypal, paypal ipn, then later on you mention authorise.net. If it is paypal ipn you are using, which version have you installed. Hi Ian, It seems to be happening on both Authorize and Paypal. Paypal I was not getting the orders. Now I am getting the orders but they are duplicated on both Authorize and Paypal. I installed v096. Also so you know this was based on your Loaed Snapshot v2. kmcar Link to comment Share on other sites More sharing options...
Ian Posted December 16, 2002 Share Posted December 16, 2002 kevin, Did the duplication problem only appear after you installed paypal IPN. Did you make sure you only installed IPN for old checkout (I believe there are 2 versions) Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Guest Posted December 16, 2002 Share Posted December 16, 2002 kevin, Did the duplication problem only appear after you installed paypal IPN. Did you make sure you only installed IPN for old checkout (I believe there are 2 versions) Yes I am sure I installed the one for the old version. I did have 1 or 2 dulpicates before using the IPN. I even did some test orders and following each step I did get the orders and payment with no problem. Could it be someone leaving the site then coming back in to purchase or losing the connection or deleting from the cart and it is not clearing. My MSN is km_carolan@hotmail.com. If you want I can give you the admin password so I can show you the exact problem. K Link to comment Share on other sites More sharing options...
Ian Posted December 16, 2002 Share Posted December 16, 2002 Kevin, I'm at work at the moment so it's a little difficult to test things here, I'll drop you a line later today when I'm back home on on my dev machine. Unless some one solves it before then :) Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Guest Posted December 19, 2002 Share Posted December 19, 2002 Kevin, I'm at work at the moment so it's a little difficult to test things here, I'll drop you a line later today when I'm back home on on my dev machine. Unless some one solves it before then :) Ian, I think I may have found the issue .. I hope. I have installed to new Loaded Snapshot with the New Check Out. I was running that with no problems untill I installed Discount Coupon. What I noticed is I placed an order via Authorize Net. When I went into the orders section of admin there were 2 orders attached to my name. One was for a product that wasn;t in my cart. I also noticed that order total had a bunch of entries for that order id. I am going to also switch over to the new Authorize script hoping maybe that will help. But it seems that it has happened in the older store via Paypal .. Any clues? Link to comment Share on other sites More sharing options...
Ian Posted December 19, 2002 Share Posted December 19, 2002 Kevin Which version of the Discount Coupon did you install. I've only just released a version of the discount coupon for the new checkout. Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Guest Posted December 19, 2002 Share Posted December 19, 2002 Kevin Which version of the Discount Coupon did you install. I've only just released a version of the discount coupon for the new checkout. I am using $Id: ot_coupon.php,v 1.1.1.1 2002/12/14 21:33:57 wilt Exp $ Link to comment Share on other sites More sharing options...
Ian Posted December 19, 2002 Share Posted December 19, 2002 Jeez, You would think I would no my own code :oops: Of course I bullt that into the L4 before I released a contribution. I'm about to email you anyway about this and something else. You should know that I have a growing dossier of problems with authorize.net. Although I don't think your problem is just related to authorize.net. I'm just about to start a new thread on this. Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
Guest Posted December 19, 2002 Share Posted December 19, 2002 Jeez, You would think I would no my own code :oops: Of course I bullt that into the L4 before I released a contribution. I'm about to email you anyway about this and something else. You should know that I have a growing dossier of problems with authorize.net. Although I don't think your problem is just related to authorize.net. I'm just about to start a new thread on this. :D Ok I shall await your email ... Link to comment Share on other sites More sharing options...
dreamscape Posted December 19, 2002 Share Posted December 19, 2002 I recently had this problem with double orders and "phantom products"... what happened was there were duplicate orders in the database... if you have phpmyadmin, goto it and look at the orders tables... if you see duplicate orders for the same ID, that is the problem... what happened was I installed something or did something that reset the next order ID to 1... since I only had 10 orders in the database, I just made 10 fake orders, and then deleted them from admin, which deleted all duplicate entries and all was fine... you could also fix it with myphpadmin to change the starting order ID to something higher than the current highest order ID if this is a live store... come to think of it, I believe it was paypal IPN that reset the next order ID to 1 when I installed it... let me see if I can find that thread The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
dreamscape Posted December 19, 2002 Share Posted December 19, 2002 here it is: http://www.oscommerce.com/forums/viewtopic.php...9103&highlight= it was a package tracking contribution that did it to me, because instead of just adding the newfields to the orders table, it dropped the entire orders table and re-created it... ok on a shop with no orders, but VERY VERY bad if you already have orders in the database The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
Guest Posted December 19, 2002 Share Posted December 19, 2002 here it is: http://www.oscommerce.com/forums/viewtopic.php...9103&highlight= it was a package tracking contribution that did it to me, because instead of just adding the newfields to the orders table, it dropped the entire orders table and re-created it... ok on a shop with no orders, but VERY VERY bad if you already have orders in the database Here I thought I was losing my mind . Now all I have to fingure out is how to make the order numbers in the 100's since this is a live shop. Now on my older shop (pre Nov) I had installed the tracking contro andf that is when it stated happening. But here it is happening without the tracking .. Hell I was just about to install it. any thoughts .. kmcar Link to comment Share on other sites More sharing options...
dreamscape Posted December 19, 2002 Share Posted December 19, 2002 Here I thought I was losing my mind . Now all I have to fingure out is how to make the order numbers in the 100's since this is a live shop. Now on my older shop (pre Nov) I had installed the tracking contro andf that is when it stated happening. But here it is happening without the tracking .. Hell I was just about to install it. any thoughts .. kmcar Hey I was loosing my mind too... does the new store use the same database as the old one?? that would explain it... to change the starting order id, it is easy using PHPmyAdmin... goto it and to your db, and in the table listings in the left colum, select "orders_total" and the orders_total table will come up... the 2nd entry will be "order_id"... click on change beside that and in the field default, put whatever starting number you want and hit save... if you don't have phpmyadmin, this SQL query should also do it: ALTER TABLE `orders_total` CHANGE `orders_id` `orders_id` INT( 11 ) DEFAULT '200' NOT NULL you can change the number 200 to whatever u want the starting number to be (just make sure its higher than your current highest order_id The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
dreamscape Posted December 19, 2002 Share Posted December 19, 2002 no that doesn't do it... here is how: using PHPmyADmin, goto the "orders" table and from the top tabs, pick "insert"... in the field "orders_id", put the starting ID you want and leave everything else blank... here is the query you can use too: INSERT INTO `orders` ( `orders_id` ) VALUES ( '2000' ); changing the number 2000 to whatever the new starting ID should be... yes this is how I did it... I just tested it again and this works... the above post doesn't. sorry for getting confused the 1st time round The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
Guest Posted December 20, 2002 Share Posted December 20, 2002 no that doesn't do it... here is how: using PHPmyADmin, goto the "orders" table and from the top tabs, pick "insert"... in the field "orders_id", put the starting ID you want and leave everything else blank... here is the query you can use too: INSERT INTO `orders` ( `orders_id` ) VALUES ( '2000' ); changing the number 2000 to whatever the new starting ID should be... yes this is how I did it... I just tested it again and this works... the above post doesn't. sorry for getting confused the 1st time round Well Dream .. I did as you suggested and it seems to have fixed the problem. Great hunting skills, I would have never thought of that. Thanks to you to Ian. kmcar Link to comment Share on other sites More sharing options...
Ian Posted December 20, 2002 Share Posted December 20, 2002 Cheers from me as well. one less thing on my todo list. :D Trust me, I'm an Accountant. Link to comment Share on other sites More sharing options...
dreamscape Posted December 20, 2002 Share Posted December 20, 2002 it just makes me wonder how many others out there have been running a shop for awhile and then installed that order tracking contrib... perhaps I should email the author and let him know of the problem so he can release a newer version that just inserts the new fields into the table instead of droping it and re-creating it... well glad you are back up and running normally! :D :) The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
wizardsandwars Posted December 20, 2002 Share Posted December 20, 2002 it just makes me wonder how many others out there have been running a shop for awhile and then installed that order tracking contrib... perhaps I should email the author and let him know of the problem so he can release a newer version that just inserts the new fields into the table instead of droping it and re-creating it... I just installed a version yesterday, and had not read this thread. However, in the installation instructions I read, it said that if you were a new customer, you should run the SQL that he included. However, if you have orders in your database, then you should just alter the table and add the columns. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
dreamscape Posted December 20, 2002 Share Posted December 20, 2002 I just installed a version yesterday, and had not read this thread. However, in the installation instructions I read, it said that if you were a new customer, you should run the SQL that he included. However, if you have orders in your database, then you should just alter the table and add the columns. that might be the one (it is HTML tracking for UPS, FedEx, and USPS), but I don't remember reading that in the readme.. I just remember reading to run the query... in any case, the query should be to alter the tables either way (because my stock OSC orders table was different from the orders table at the time the contribution was made) The only thing necessary for evil to flourish is for good men to do nothing - Edmund Burke Link to comment Share on other sites More sharing options...
wizardsandwars Posted December 20, 2002 Share Posted December 20, 2002 ... in any case, the query should be to alter the tables either way I'd have to agree with you, there. The author is aware of the issue, thought, at least. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. 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.