Hello and thank you for considering bidding on this job. Be
advised that this is a serious tender and that work will be awarded.
I have a suite of florist websites currently that I need to replace.
I need complete code and database installed and configured
for a suite of e-commerce sites to sell Flowers using the same database.
Separate database is ok if it is populated using the inputs from a lead control
panel.
In addition to common features, a few additional order
management features are also required. The site must go close to passing validation
(below 50 warnings) and should be SEO friendly.
An auto script to make dynamic pages static with descriptive
text is required
In terms of layout and function, I am looking for something
like a combination of www.ftd.com and www.1800flowers.com
The home page layout and functions should be like ftd
however the product review/order process should look and operate like
1800flowers.
Requirements
- The list below is not exhaustive. Reference to ftd, 1800flowers and www.rosetime.com.au and it will make it clear.
- Accept Order
- Process order.
- Send email confirmation to customer and my own email address
- Route order to florist shop via
- Email (the email should have a link that allows acceptance or rejection of order….
- Possibly by Returning florist to our site (login page that pre-enters their member number) where they enter password to login and reject or accept the order.
- If the order is rejected or not accepted with 2 hours then it is to be reallocated to another florist.
- If reallocated, the original florist is to receive an email advising that the order was reallocated and has been cancelled.
·
Ability to manually accept or reject via control
panel is also required)
- and/or fax (like protofax) Assume faxed orders are always accepted unless rejected via control panel or florist login. (on rejection, the order is re-allocated) and a fax is sent to the original florist advising them that the order was cancelled and re-allocated.
- All routed orders must be reduced in price by an administration fee and a selling commission able to be calculated either as a percentage or fixed amount. (set these in control panel)
- Shopping Cart.
- Allow the adding of shipping cost (call them “Delivery Fee”) based upon postcode. Depending on which florist is selected.
- If the postcode is within any florist (A) Local Area, then add (A) shipping, (note the areas are explained below)
- If the postcode is within any florist (B) extended area then add (B) shipping
- If the postcode is within any florist C area then add C shipping cost
- If the postcode is not included in any florists A, B or C area then advise purchaser to telephone 1800 137673 to discuss delivery options.
- A full database of postodes is required.
- Accept Quantity and have ability to remove item.
- Store message to attach with shipment.
- Communication payment gateway to Paypal and my St George bank (Australia) API payment gateway.
- Customer should be able to login and see their info and (check order status (this function should be able to be disabled).
- Should be able to edit Main and Sub categories on front page tags. (vertical only).
- Site map
- Affiliate code . third party code to be placed on payment confirmation page.
- Login for users to track order status.
- Login allows members to receive discounts
- 4 membership levels
- Member
- Gold member
- Platinum Member
- Corporate Member
- With each receiving various discounts able to be set and varied at control panel. Calculation would be to deduct shipping cost, then deduct applicable discount then add back shipping.
- Login for florist shop to accept/reject order and update order delivery status.
- If they make a comment, this should be saved and sent via email to admin email address.
Shops should be able to login and
also be able to order and send flowers for allocation to other florists at a
reduced price.
Calculation would be to deduct
shipping cost, then deduct 30% (able to change this from control panel) then
add back shipping cost.
Engine should have:
- Database
- Save Item Number, Name, Description, Picture1, Picture2, Price, Add, Cost, Category, and Type), which will be used by the site.
- Save City, Code, Postcode Shipping, and E-mail which will be used to route the order to shops.
- Save customer info, shop info, order info, and status.
- If Login is from customer then tracking info to show including the florist name and phone number.and delivery status
- If Login is from shop then show outstanding orders for rejection or acceptance; delivery status update input. ..and database search of orders sold and provided/received by them shown over selected date range.
When florists join up they must complete the following
fields
Password: Minimum 6 characters including at least 1 digit
Florist Name
Florist Address
Suburb
State
Postcode
Phone 1
Phone 2
Fax
Email
Contact1
Contact2
Credit card fields, type, name, number, expiry, ccv
(cards are optional fields, though if they put in detail
here, when they login to make an order, the card should be pre-filled. If they
don’t fill it in, then only the other details being sender details should be
filled in)
Register as (radio buttons)
Place
orders Only
Receive
Orders Only
Place and
Receive Orders
If the florist is a service provider and receives orders
then specify postcodes that they service. 3 classifications
(A) (B) (C)
Local Area Extended
Area Wider Metro
Minimum 3 no
minimum Yes or No button
No maximum No maximum
Operating Days
Weekdays Yes No
Saturday Yes No
Sunday Yes No
Public Holidays Yes
No
Comment Field
Submit (on submit, they are allocated a membership number
which is shown on screen) They receive an email advising them that their
application has been received, and that we will respond shortly. Show Referance
Number (member number)
We then get to choose to accept or reject membership request
from control panel settings.
Send email on processing membership, advising of acceptance
or rejection, detailing their membership
number and login and order procedure.
From the control panel, I have some other inputs to apply to
florists.
For service providers (those that receive orders), we can
grade them as Active or Suspended.
All are pre-selected as Active as default
When an order comes in the system must randomly select an
active florist from A list for particular postcodes. If that florist rejects
the order or if they don’t accept it within 2 hours it goes to the next A list
florist until there are none, then it goes to B list. If all B list have been
tried it goes to a randomly selected Wider Metro Florist (C list).
Of course, the system would need to check that the florist
is open for delivery on the day specified. I.e./Sunday
We would need to also have certain dates able to overide the
florist selection regarding day open. E.g./ Christmas day may be on a weekday,
though we would set this as all florists closed. Also, we would set all
florists open on Sunday mother’s day and for other days like valentine’s day
that fall on a Sunday.
All products added to the database are automatically added
to all receiver florists available inventory, however the ability to remove the
product from the particular florist inventory is required.
Eg, they might provide basket but not fruit basket.
Summary
So, in summary. When an order comes in for a particular
product, the system Searches for open, active (not suspended) provider/receiver
florists with the postcode in the A Local area that has that product in their
inventory. Then randomly allocates. If none, Then moves to B postcodes, then C
postcodes and if none available advises the purchaser that the product is not
available in that area, and requests them to select from a page of other
products available. If no products are available, they are advised that we do
not deliver to that location.
So,
look first for all florists with the product in inventory,
then look for florist open on the requested delivery day,
then look for A area
or if none B
or if none C
Allocate to florist
or if none providing the product in the area, show purchaser
a page with items that can be delivered to the area. And then repeat the
process when they select a new product.
If no products are available tell them we cant deliver to
postcode area xxxx (Ringwood)
Delivery Time
Also prior to the purchaser confirming the order, we need to
be able to advise them when the order will be delivered.
If the order will go to an Area A florist, then we can
accept the order as late as 2.00pm for same day delivery on weekdays or 12 noon
on saturday or Sunday
If the order will go to an Area B florist, then we can
accept the order as late as mid-day on weekdays and 11 am on Saturday or
Sunday.
If the order will go to an Area C florist then we can accept
the order as late as 10 am on any day.
If it has come in too late for delivery same day, then the
system tests for next day delivery and then the following day and then the
following day up to 4 days. This is required due to holiday, weekend hours etc.
I need to be able to adjust the times in the control panel.
I also need to be able to turn off all new orders for
delivery on a certain day at any time.
Eg. On valentines day, we may wish to terminate taking new
orders at 11.am even though it is a weekday.
Developers with examples of relevant e-commerce sites will
have advantage.
Slight variations are considered if functionality remains
the same.
Also, as a suite of sites will operate.. Require that
products can be added to the different sites at the control panel with
different prices possible for the different sites.
Some products will be available for delivery overseas so
purchasers should be able to select country from drop down menu. All overseas
orders will be allocated to Head Office Florist
The website should include the following sections:
- Front Page (Page 1 - Required)
- Header (should be dynamic link back to home page)
i.
Phone Numbers
ii.
Logo
iii.
Search Bar
iv.
Account Login
- Top Bar (no particular order)
i.
Home
ii.
About Us
iii.
Contact Us
iv.
Delivery Information
v.
Our Guarantee
vi.
Privacy, Disclaimer, Terms and Conditions (see Cicek)
vii.
Best Sellers and Specials
viii.
Flower Care
- Side Bar
i.
Occasions
1. All
Occasions
2. Birthday
3. Romance
4. Anniversary
5. New
Baby
6. Funeral
7. Weddings
8. Congratulations
9. Thankyou
10. Get well.
ii.
Price Range
1. $40-$59
2. $60-$79
3. $80-$109
4. $110
plus
iii.
Arrangements
1. Bouquet
2. Baskets
3. Plants
iv.
Variety
1. Roses
2. Gerberas
3. Lilies
4. tulips
v.
Site Info.
1. Flower
Care
2. Etc.
etc.
- Center Page
i.
I large image like ftd.com
ii.
4 Boxes below
iii.
4 boxes below them
iv.
Selected product includes:
1. Flower
Name
2. Flower
Picture
3. Item
Number
4. Flower
Description
5. Flower
Price (Small-Default, Medium, and Large)
6. Zoom-In
button.
7. Purchase/Details
button.
- Bottom Bar
i.
Privacy and Security
ii.
Delivery Information
iii.
Contact Us
iv.
About Us
v.
Home
vi.
Our Guarantee
vii.
Privacy, Disclaimer, Terms and Conditions (see
www.rosetime.com.au)
- Product Detail Page. (Page 2 - Required)
- Contact Us (Page 3 – Required)
- About Us (Page 4 - Required)
- Account Information and order tracking. (Page 5 – Required)
- If user is not a shop.
i.
If there is no active orders then the bottom half
(tracking) will be empty
- If user is a shop then outstanding order status.
i.
To Be Delivered.
ii.
Delivered.
iii.
Returned.
- Shopping Cart, Payment, and Confirmation. (Page 6, 7, and 8)
- The Shopping Cart is combined with Checkout and Order Review and should contain:
i.
Quantity
ii.
Selectable City to Ship. (adds shipping cost on the
spot)
iii.
Message to attach to flower for sender.
iv.
Item Charge, Shipping, Total Charge
v.
Remove Icon (X)
vi.
Username(Email) and Password.
- Show Step #1, Step #2, and Step #3 of the process.
- Other Requirements
- SSL Secure ( I will have a specific URL with shared SSL for all sites)
- Do multiple currencies which are update automatically.
- Allow currency exchange rates.
- Add language selection to at least one other language
Support for 12 months.
Note that the code must be fast,
Choose asp.net or php
Your choice of db
Make sure sufficient connections
can be made for high volume times.
Thanks
Owen
