I have a client who has an existing website with an ordering system and here is what they would like to have below. Please let me know the cost and timeline to get this project completed. Also, if we need to convert their existing shoppping cart to ASP.NET 2.0 and a MS SQL database let me know as that would be an option if the winning bidder feels necessary. I know the client's current budget is in the $300 to $500 range but I will entertain all offers to get this project done ASAP. He would really like this up and running in the next two weeks. I will PM the website for review on your end. Thanks.
We want to allow our larger customers to enter their orders via a web interface. Order data consist of the products (in our case one of maybe 12 different types of baskets of chocolate), the sender’s info (name, contact person, address, phone, email, etc) and info on each recipient (name, address, phone number, delivery method, delivery date, and a personal message). Typically each customer/sender might order baskets for anywhere from 10 to 100 recipients. All payment would be offline, but it would be nice if the system could generate a bill, using our table of delivery prices. We’d like the ability to have some “same as prior” boxes to check so customers don’t have to retype all the messages if they are the same.
Project Scope
1. Customer has log-in code for their company. We should be able to generate and change codes as needed. We need a central file for recording and looking up codes, accessible only by a manager with a p/w.
2. Customer enters corporate information:
a. Company Name
b. Contact Person
c. Phone
d. Fax
e. e-mail address
f. Mailing address
g. Leave a box for billing information: customer can type in their Credit Card Information or billing info.
h. It would be nice if company should be able to access their prior orders. For example, in 2007 a company should be able to see their 2006 order and use it to pre-fill their 2007 orders (nice but not necessary feature)
3. For each basket ordered the following information is required: (each item should have the option to be repeated on each order or entered one at a time)
a. Occasion: (Thanksgiving, Christmas, Hanukkah, New Years, etc.)
b. Corporate Logo (extra charge of $4.50)
c. Dairy or Pareve
d. Week of Delivery –Should link to an actual calendar. (note: We will give a delivery date but that date is not guaranteed. I would like the estimated date to be a separate line that we enter. We need text to indicate this is an estimated delivery date, not a guarantee.) I’d like to have the option for a link to pop-up box that spells out our delivery policy.
e. Recipient’s Name
f. Recipient’s Address
g. Recipient’s Phone Number
h. Alternate Phone Number (optional)
i. Recipient e-mail (optional)
j. Message to Recipient (for greeting card)
k. Delivery Options (Pick-up, Local, Fed Ex, UPS, Air Borne) Include note that Wrong address that require the basket to be redelivered cost $10.00.
i. Local Delivery Fee based Zip codes on web-site. Multiple deliveries to the same address is $4.00 and multiple deliveries to the same address but different office is $8.00
ii. Fed Ex based on codes in web-site that need to be updated plus ($10.00)
iii. Basket weights need to be updated. They are incorrect on the web-site
iv. UPS & Air Borne customer must provide Air bill plus a $10.00 packing fee)
l. Once completed, customer should be able to print out an order summary that shows individual and total prices. Note that if we have to enter discounts via management override (like if the manager decides to give them say $100 off their order), the total will be initially incorrect, so customers will have to go back into system to get corrected invoice or we will have to email it.
4. Management override
a. Once the customer submits the order it cannot be modified by the customer. Any additional baskets will be treated as a new order.
b. We will need to be able to make changes to order in case there is a change in delivery address, basket size, etc.
c. We need to input the estimated delivery date, since this drives other reports.
d. An additional box for Management notes, for each individual basket order, with the option for it to automatically print on all orders and “same as previous” check box so we don’t have to keep retyping the note.
e. An override is needed for all prices (Baskets and Deliveries). If this is too difficult, we can settle for a discount line on the final summary/invoice page.
f. The ability to easily e-mail a final invoice to the customer after any management overrides.
5. Production Print Outs (see attachment order form)- This is generated from each customer (and will reflect multiple baskets to be delivered). I want to be able to have system print these decks by inputting either customer name or invoice number. I want to be able to recall these orders by date or name.
a. Triplicate Order Forms:
i. Each individual basket order generates a triplicate order form. Order form must contain all of the information from #2 & #3, with an individual and a master invoice number. Each of the three copies must clearly be very clearly identified (Accounting, Customer & Driver)
ii. Each order form should also have a box for Management notes. This can only be enter by manager with p/w. (see management override)
b. Each individual order also generates a greeting card (approximate size 8 inch Long and 4 5/16inches wide). We need to discuss paper issue and collating. 1 vs 2 tray printer or two printers.
i. Top part of Greeting Card has recipient’s name, address, phone number, alternate phone number and individual invoice #.
ii. The bottom of the card has the sender’s message.
c. A summary/invoice sheet with all of the customer’s information (from #2) and from #3, including basket fees, delivery fees and taxes, plus the total cost.
6. Office Reports
a. Delivery Report: We want to be able to print out a delivery report for our drivers that shows all the basket IS information and delivery addresses. Sort all deliveries by Zip Codes (all or selected Zip Codes) and delivery dates
b. Candy Production Report: Will need to create a table listing products in each basket (e.g., 45 cookies, 4 oreos, 6 fruit, 10 truffles, 7 pretzels). This report will tell how much candy we need on a given day to fill the ordered baskets. Need to sort by Delivery Dates and Products for the baskets (Ruggula, Cookies, Brownies, Pretzels, Oreos, candy & Fruit). For example, I’d like to know how much of each type of candy I need for Dec 12th. I’d also like to know how many truffles I will need for Dec 10-20th.
c. Basket Production Report: Sort by Date, Occasion and Basket Size/Type. Will tell us how many baskets of each type are due on each day.
d. We should also be able to readily access any order by inputting the customer or recipient name or phone number.
7. We do not want this system to be integrated with the website, other than that there could be a password protected tab on the website for customers. Given the trouble we’ve had with hackers, we can’t afford to have this system crash. I’d need to be able to mirror this data onto one of our local computers so if the web server had a problem (or our internet connection failed) we could still access our data. We need a simple way (p/w protected) for generating, recovering and changing customer passwords.
8. As an upgrade option, we’d like ability to enter actual deliveries at end of day (delivery day a.m./p.m.) and give customers a way of looking online to confirm that deliveries were made. Want to do it by scanning delivery receipt (bar code).
Nice to have: a way for clients to login and see a text only (non-editable) list of their orders from the last year, or several months, etc.
Need: to have a double backup of this system in case their server goes down, they can use a temporary area on their local computer (where one daily backup will be) and order in the same way they would have online, etc. then back that data up locally, as well as onto the server when the site is back up and running. We will assist with this by working with your current hosting provider.