oscommerce: show previous orders on Orders sheets

oscommerce: show previous orders on Orders sheets is project number 181253 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider netsolve
Budget:	$30-100
Created:	09/28/2007 at 12:34 EDT
Bidding Ends:	10/03/2007 at 12:34 EDT
Project Creator:	islandman   Buyer Rating: (20 reviews)
Description:	I want to have immediate knowledge of whether an osCommerce order is a repeat customers when the order email enters our store's inbox. Modify the standard osCommerce platform to create code which will allow order pages to show previous orders from that customer. The Orders page, both the admin online and emailed versions should include the following previous orders fields: 1. Prev Order Date: 2. Prev Order Invoice No.: 3. Prev Order Total$: For clarification, below is an example order sheet which osCommerce sends to the store's email account. I would like that modified to add in the details of any previous orders from the customer. =================================================================== Thank you for your purchase from xxxxxxx! Our products are 100% guaranteed. If you do not like any product, return it to us for a full refund. Your order will be shipped via USPS Priority Mail. You will receive an email when you order is processed for shipping. The message will come with a USPS Track and Confirm number which can be used to track the order. Please let us know if you have any questions or would like to add something to your order. We hope you will enjoy our products and will shop with us again! Warm regards, xxxxxx 1-877-xxxxxx ------------------------------------------------------ Order Number: 2937 Detailed Invoice: https://xxxxxxxxx/account_history_info.php?order_id=2937 Date Ordered: Friday 28 September, 2007 Comments: Please let us know if any backorders as we need these soon. Products ------------------------------------------------------ 1 x item XXXX = $29.95 Color XXXXX ... ------------------------------------------------------ Sub-Total: $149.80 USPS Priority Mail to USA destinations (US Priority Mail (3-5 days shipping to USA addresses).): $14.95 Total: $164.75 Delivery Address ------------------------------------------------------ [ address here ] Billing Address ------------------------------------------------------ [ address here ] Payment Method ------------------------------------------------------ Credit Card =================================================================== I need the same changes to show on the online Orders form which is accessed from osCommerce's Admin interface. Your deliverable should be in the format of "How to modify existing code" as seen in most osCommerce contributions. I'll use those instructions to add in this feature to an existing code base. I'll be adding in the code myself on the store platform. ********************************************** You will modify a fresh oscommerce package add the code into it and test. Then send me the contribution changes and instructions so that I can update my codebase. *********************************************** Final payment will be released when the code is up and running on my store. If this exchange is successful there will be a follow-on project which involves similar reporting, but for sales from osc-Affiliates. Please enquire if you have any questions. ** Convince me that you know what you're doing so we both save time. ** Please reply with "REPEAT CUSTOMER" included in bid title. I get to many generic replies to posts like this and want to ignore them more easily :)
Job Type:	PHP
Database:	MySQL
Operating system:	(None)
Bid count:	8
Average bid:	N/A