476680 Online Management Database for Tailor Shop
N/A
Teslim sırasında ödenir
I am looking to make an online order management system for my tailor shop. Below are the minimum requirements as well as what I need and the process.
Requirements:
1) System needs to have a sales record management which dispalys and can be organized by:
CLient first name, last name, cell number, order amount, amount outstanding, rep login that input the number,
2) Web based customer management system accessible on ipad
3) Measurement Storing, click on client order and can see order history and what measurements were input for that order
4) Ability to create different login names for users and recognize which store they are from .Each store assigned a code so that I can see orders from each store. Login name details just includes First Name, Last Name and Store Details
5) search function, Searching by Last Name, Cell Number
6) Print out order sheet and invoice if necessary. Order sheet can ideally show multiple orders.
7) Duplicate function, which basically can duplicate and add to current order a shirt/ suit order
8) Ability to setup items per invoice, enter the normal selling price, cost of goods, and also be able to tally up what is owed end of the month or specific dates.
9) Order sheet can take a picture of 3 fabrics using a webcam and auto attach each one to a specific spot with a textbox next to it. It must auto attach. ALSO need to have another option ihich is typical browse and attach file. Needs to have either option
10) needs to be able to accept and save chinese text, very important!
11) breakdown for sales per day and possibly for a certain period. Also sales by store. Store would be determined by a code I give each username for sales and we can track it as such. basically just to determine how many shirts / suits or whatever product is keyed in is sold each month/day.
12) For each product, sales needs to have a database they can use to track the normal cost of product, cost of good sold, and also ability to print an invoice for client, or print a cost of goods sold on my end for the company.
13) Print out the sheet without showing all the options I didn't tick or choose
================================================
Steps:
Input Client Name textbox
Sex of client (choose male / female)
Input Client Telephone textbox
Text box for address
After inputting client details, system will have dropdown menu with choice of new what
SHIRT:
Client Measurements input boxes (see sheet)
also need a textbox for addtl info
Shirt Fabric (ability to take picture and attach)
Textbox to write shirt fabric number
Lining Fabric (ability to take picture and attach)
Textbox to write fabric number
Textbox to write fabric type(ability to take picture and attach)
Textbox to write fabric number
Then need just textbox next to each header (header in bold):
Collar and then Textbox
Cuff and then Textbox
Placket and then Textbox
Pocket and then Textbox
Textbox for additional details
Button and then Textbox
Button Thread and then Textbox
Button Hole and then Textbox
Monogram and then Textbox
Large Textbox for additional details
**Once done, click complete and system will fwd you to choose new order for suit and shirt or Add order to database, at which point system will ask for an order number to be input
Also need to input total amount owed, deposit and amount outstanding
SUIT instructions
Client Measurements input boxes (see sheet)
also need a textbox for addtl info
Suit Fabric (ability to take picture and attach)
Textbox to write shirt fabric number
Lining Fabric (ability to take picture and attach)
Textbox to write fabric number
Then need just textbox next to each header (header in bold):
SUIT JACKET
Collar and then Textbox
Cuff and then Textbox
Buttons and then Textbox
Pocket and then Textbox
Textbox for additional details
SUIT PANTS
Button and then Textbox
Pleats and then Textbox
Pants style and then Textbox
Textbox for additional details
**Once done, click complete and system will fwd you to choose new order for suit and shirt or Add order to database, at which point system will ask for an order number to be input
Also need to input total amount owed, deposit and amount outstanding
Proje NO: #2222587