Community Add-Ons

Sometimes cosmetics are important. So I added the lanquage defines. Also I added the links need to access basket.php in the customers box just under the orders link.

This is a full package with dutch transation and complete instructions.

you no longer have to look customer id, added a drop down list of customers to make it easier to find order
any problems with zip file contact me via oscommerce forums.

Simplace replace basket.php in admin with this one

* Made it more secured (fixed some security holes)
* Made it faster (reduced number of SQL queries)
* Changes all the php tags to be the lon version for higher compatibility with broader php configs (recommended to use longer tags (<?php instead of just <?)
* Made the template (HTML) easier to read and managed
* Moved the business logic (SQL) at the top of the file
* Kept some presentation logic in the HTML.
* Added Date Ordered field
* Made it easier to read and maintain by using an object with the name of fields instead of meaningless numbers ($row[0] vs. $product->products_name).

TODO:
* Display the basket entries grouped per date with a total
* Display the total of each entry (and handle special case with final_price field)
* Display last 5 baskets so you do not have to fetch the customer id.

If anyone wants to tackle the TODOs, that would be great! :)

Changed basket.php to use setting in configuration.php so that it is not site specific!

Added basket quantity.
Added "Customer ID" button label.
Moved function to more appropriate Customers session.

Code still needs product links to be non site specific.

The quantity of the basket is not indicated.

This contribution is basic. It contains one file. Simply add a link in tools to /admin/basket.php.

It works like this: If a paypal customer does not return to your site you can still lookup their cart by entering their customer ID number into this script and it will pull up their basket.

I am sure others in the community can improve on my work. I just wanted to get the ball going. This script does what I need it to do and will probably work for others as well. Others may want to tweak it a little more. If you do please update this contribution.