I've read in the forums that some people have had a problem with an order not being logged at their site because the customer did not click the appropriate button to return to the site after they entered their credit card at their payment processor's site (e.g. 2Checkout).
I use 2Checkout for my payment processor and have had this problem several times. I've had to go back to several customers to ask them what they ordered. This is not a good situation.
This contribution logs the order, products ordered and order total in three holding tables triggered at the checkout_confirmation.php page before the customer is passed to the payment processor. The process is seamless and doesn't interfere with the regular checkout process.
Access to the order information in the holding tables is through phpMyAdmin (or your db tool of choice) at this time.
Install is very easy. Create 3 new tables (table defs provided), add Defines to app_top, and short code insert into checkout_confirmation.php.
Mark
Legend: 
Download
Report
A minor fix to v 3.1. products_id was not recorded in TABLE_ORDERS_PRODUCTS. This has now been rectified in this file.
A big thanks to Irin who pointed this issue out and provided the solution.
With this new file, you are able to convert a holding order to a real order in the click of a button!
Attached is the changed file. Lines 36-102 and 153-161 have been added to the previous file.
Only ordersholding.php is included to replace in the previous package.
Now OSC compliant
register_globals on/off compatible
Multilingual support (english only)
Compatible with rc versions and non rc versions
New install.txt
Added upgrade file
Added all files, existing and new
Combined admin/ordersheld.php and admin/ordersholding.php into 1 file
Tested on php 4.4.7 and mysql 4.1.2
Major upgrade....
Major changes
-added support for product attributes
-orders holding display table now shows customer with email link and phone, order date and time, total amount, and payment method with links for view and delete
-displays most of the information about an order including customer info, shipping info, and all products details with attributes, quantities, and prices
-allows the admin to easily delete the orders in holding with a confirmed click
-more or less printable
BUG fixes
-now stores the order totals correctly
-now stores the products correctly
-eliminated code that looked for order by customer and reported a hit as a successful order. Fact is that was very unreliable.
Added a bunch to the install.txt....
My first submission so bear with me.
I had a nightmare getting this mod to work but something click and i removed the _(underscore) from the orders_holding.php file name, and of course made the relevant amendment to admin/includes/boxes/customers.php file.
Now seems to be working fine.
TABLE_HOLDING_ORDERS' doesn't exist was corrected.
the install file was modified.
This is a stable version, complete zip file
Installed this contrib but when i go onto the orders_holding.php it says:
TABLE_HOLDING_ORDERS' doesn't exist
Hi, I found a simple solution this also I want to share. Attached is a simple text doc telling you about how to change COD module and use it to complete the checkout for your customer.
Is there anyway of getting the products attribute options that the customer selects to be added to the database?
Instructions to fix 2 minor issues when applying Nick Weisser's patch (below) to a stock MS2 install.
- Add database entries to catalog/admin/includes/database_tables.php
- Properly format link array in catalog/admin/includes/boxes/customers.php
See install.txt instructions in attached file for full details.
This is in the install file:
5. Add a link to the admin section:
In catalog/admin/includes/boxes/customers.php
After line:
'<a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '</a><br>' .
Paste the following:
'<a href="' . tep_href_link('orders_holding.php', '', 'NONSSL') . '" class="menuBoxContentLink">Orders Holding</a><br>' .
This is what the customers.php looks like:
'<a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '</a>');
So doing a link to the admin that way is impossible. Anyone else have any clues?
I've included the text file so everyone can see. Everthing else in the contrib below works, so if someone can just figure that out this contribution will be complete.
Added accessibility to holding orders via admin section:
This contribution is for shops that use a payment processor's site (e.g. 2Checkout, Protx, PayPal). When an order is not being logged at ones site because the customer did not click the appropriate button to return to the site after they entered their credit card at their payment processor's site, the logged orders can be very useful to avoid going back to customers to ask them what they ordered.
This contribution logs the order, products ordered and order total in three holding tables triggered at the checkout_confirmation.php page before the customer is passed to the payment processor. The process is seamless and doesn't interfere with the regular checkout process.
You can access these tables via the admin section under Customers/Orders Holding. Unsuccessful orders are marked correspondingly.
I've read in the forums that some people have had a problem with an order not being logged at their site because the customer did not click the appropriate button to return to the site after they entered their credit card at their payment processor's site (e.g. 2Checkout).
I use 2Checkout for my payment processor and have had this problem several times. I've had to go back to several customers to ask them what they ordered. This is not a good situation.
This contribution logs the order, products ordered and order total in three holding tables triggered at the checkout_confirmation.php page before the customer is passed to the payment processor. The process is seamless and doesn't interfere with the regular checkout process.
Access to the order information in the holding tables is through phpMyAdmin (or your db tool of choice) at this time.
Install is very easy. Create 3 new tables (table defs provided), add Defines to app_top, and short code insert into checkout_confirmation.php.
Mark
Add file to this package