Printable Receipts - Give me your recommendations

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=187982#187982
----------------------------------------------------------------

Gentlemen,

Please ignore my last post. Rather than sitting here and wishing for a proper receipt system, perhaps I should get off by duff and make one.

Before I proceed however, I would like to solicit input from everyone. I'd like it to be accomodating to all, and have it integrate well into osCommerce, perchance to have the authors adopt it.

To begin with, has anyone started on an Admin/Customer accessible receipt system which is slated to be integrated with an upcoming release?

If not, this comtribution would be simple, but definitely non-trivial.

A few requirements I can see right off the bat:

From the user's perspective:
- Have option to print receipt when instant payment process is used.
- Have same emailed during checkout process.
- View/print invoice/receipt at checkout and in order history

From the Admin's perspective:
- Add new status of 'Payment Received' to possible order states. This state would be modified directly by instant payment systems.
- Send receipt through email (triggered by state change)
- Add receipt view/edit/(re)send to administration screens

Changes required:

- Introduce new receipt.php in both catalog and admin (variation of invoice.php), introduce invoice.php into catalog
- Modification to admin/orders.php to show receipts support
- Add new tables in database to support variable transaction details. My bank mandates twelve variables be given to my customers). I would imagine other payment gateways are similar. These variables should be saved. Should this be a whole new table, or integrated with order related tables? The orders table is getting large, and people will tend to view their orders more than create them.
- Modify payment module interface to include payment transaction response values.
- Modify order_process.php to insert the successful transaction values into these tables.
- Modify order_success to display invoice/receipt links (which in turn provide print options).
- Possible state engine for order states? Instant payments such as credit cards will generate a receipt immediately, and must update the order status to some hybrid of 'paid, but pending'. Belated payments such as cheque, money order, or COD must only be updated after completion of payment - a mostly manual process.

More to come...

Comments, suggestions, anything, please.


Torin...