Subject: Fw: Changes
From: "Mike" <[email-masked]>
To: "Josh Bridges" <[email-masked]>
Cc: "Todd Young" <[email-masked]>
Date: Mon, 5 Oct 2009 10:00:15 -0400

Josh,
This is an up-to-date list of all of the requests we need in place for the files.  This includes a couple of things we spoke about last Friday.   I will need any previous files re-uploaded with these changes in place.  Call me if you any questions about any of these items.
Thank you,
Michael Bishop
Labor Law Poster Service
Phone 877-321-4144
Fax 888-442-4144
[email-masked] 
----- Original Message ----- 
From: Joey Sheets 
To: Mike 
Sent: Monday, October 05, 2009 9:42 AM
Subject: Changes

1. Change ProductID to correct ProductID currently it is the row number not the ProductID.

2. Remove extra comma at the end of the header row of the orders file.

3. Add Product Price (Unit Price) to the order table.

4. Add Shipping Price and Total Price to the leads table.

5. Add UniqueID ("A" code) to the leads table. I need this to track which campaign the order came from.

6. Move the shipping address, Call Date, and Confirmation Number to the leads file.  The orders file should only include OrderID (new field to connect Leads and Orders tables), ProductID, ProductName, Quantity, Price

7. Upload to our server instead of their server.

8. A four or five digit order number that was provided to customer that we can use to reference their order with the first digit starting with the letter "T". (i.e. T12345)  
Note: This number could also be used for requesting any recordings and/or verifying order info.

9. A contact name of the person who placed the order add  to the Leads table