cookster32 Posted March 11, 2008 Posted March 11, 2008 Due to several abandoned orders at the checkout stage my order_ids are not in sequence, e.g. Order 405, Order 406 and then Order 411. The ofive order numbers (ids) inbetween were lost due to the abandoned orders. My accountant requests that I have the order numbers in a complete sequence without any gaps. I've tried to change the orders_id through the database but it will not accept the update command. Any ideas how i can go back and change the orders already made?
tapuahk Posted March 11, 2008 Posted March 11, 2008 Due to several abandoned orders at the checkout stage my order_ids are not in sequence, e.g. Order 405, Order 406 and then Order 411. The ofive order numbers (ids) inbetween were lost due to the abandoned orders. My accountant requests that I have the order numbers in a complete sequence without any gaps. I've tried to change the orders_id through the database but it will not accept the update command. Any ideas how i can go back and change the orders already made? Now, hold... I'm no accountant .... BUT you shouldn't be going back to change order numbers or you're defeating the reason your accountant wants them in sequence with no gaps, what you need to do is generate orders for the abandoned ones and mark them as NON PAYMENT. Inventory counts don't change and it reflects reality... you had a customer create an order then not pay for that order. I have other questions though... When you say abandoned orders... when did they abandon it... before or after the payment screen? Do you have supertracker mod installed so that you can answer my first question? If they abandon before... then a mod of OSCommerce would be temporary order numbers until they actually pay... then assign real PO numbers. Again I'm not an accountant ... ~~~Tapuahk but I am... the webmaster for DowPublishing.com :)
cookster32 Posted March 11, 2008 Author Posted March 11, 2008 Thanks for the info Tapuahk. Maybe i didn't make myself too clear about the abandoned part. I'm using Paypal IPN and on quite frequent occasions the customer will leave my site at checkout confirmation) and be redirected to Paypal and then they decide not to proceed with the order. It's at this very point that the order number is generated on the database and when a genuine order (paid and post data collected) is received it has skipped the sequence. They are abandoned before the payment screen. I think you have a very good point about the accounts part: I'm no accountant .... BUT you shouldn't be going back to change order numbers or you're defeating the reason your accountant wants them in sequence with no gaps, what you need to do is generate orders for the abandoned ones and mark them as NON PAYMENT. Inventory counts don't change and it reflects reality... you had a customer create an order then not pay for that order. I do have supertracker installed although i'm not sure which version it is. The mod thing sounds perfect - what's it called? Now, hold...I'm no accountant .... BUT you shouldn't be going back to change order numbers or you're defeating the reason your accountant wants them in sequence with no gaps, what you need to do is generate orders for the abandoned ones and mark them as NON PAYMENT. Inventory counts don't change and it reflects reality... you had a customer create an order then not pay for that order. I have other questions though... When you say abandoned orders... when did they abandon it... before or after the payment screen? Do you have supertracker mod installed so that you can answer my first question? If they abandon before... then a mod of OSCommerce would be temporary order numbers until they actually pay... then assign real PO numbers. Again I'm not an accountant ... ~~~Tapuahk but I am... the webmaster for DowPublishing.com :)
cookster32 Posted March 12, 2008 Author Posted March 12, 2008 Does anyone else know how I go about getting the mod that enables temporary order IDS (numbers) before a transaction is confirmed? Due to several abandoned orders at the checkout stage my order_ids are not in sequence, e.g. Order 405, Order 406 and then Order 411. The ofive order numbers (ids) inbetween were lost due to the abandoned orders. My accountant requests that I have the order numbers in a complete sequence without any gaps. I've tried to change the orders_id through the database but it will not accept the update command. Any ideas how i can go back and change the orders already made?
tapuahk Posted March 12, 2008 Posted March 12, 2008 Does anyone else know how I go about getting the mod that enables temporary order IDS (numbers) before a transaction is confirmed? There is a MOD called order editor http://addons.oscommerce.com/info/1435 To change order info, I don't think it changes order numbers. :( I guess an option is create a temporary order table in the database and use that table to pass the information to the real order table when the payment clears. the new temp_order table would be structured just like the real order table and would also allow you to put the temp orders in their account history, so they could complete the payment process later. Temp orders that are processesde completely would be removed form the temp order table get assigned/ moved to the real order table. Most of the mod would be changes in the database calls. Only problem is whether a temp_order_id is passed to PayPal? If you really need contiguous order numbers, ~~~Tapuahk
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.