Em Andamento

oscommerce: show previous orders on Orders sheets

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,




Order Number: 2937

Detailed Invoice: https://xxxxxxxxx/[url removed, login to view]

Date Ordered: Friday 28 September, 2007

Comments: Please let us know if any backorders as we need these soon.



1 x item XXXX = $29.95




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 :)

Habilidades: PHP

Veja mais: oscommerce previous orders, update oscommerce 2.2 to 2.3.1, time card example, thank you follow up email, test exchange email, sheets add, purchase order number example, online exchange account, how to send an invoice, follow up thank you email, oscommerce orders previous next, show orders oscommerce, show orders oscommerces, oscommerce order history show ship date, oscommerce order mail example, oscommerce view previous orders, oscommerce display number orders customer, oscommerce orders dont show, oscommerce doesnt show orders, modify oscommerce sub total, oscommerce repeated orders, oscommerce show orders, test https, https test, track credit

Acerca do Empregador:
( 32 comentários ) La Jolla, United States

ID do Projeto: #181253