I require two modifications to an osCommerce system.
The first relates to the new products on the front page. I would like to the products displayed randomly rather then in order they were last entered. This should be just modifying the single sql statement.
The second relates to a successful transaction. Once the credit card details have been processed successfully we would need (via a variable passed form osCommerce) to update osCommerce with the result. As some users might close the page and osCommerce not know about the successful transaction. This is possible and documented via the Merchants API and should be straight forward.
You will need to have a very good understanding of OsCommerce and modules. It should not take more then a couple of hours.