It is a system that takes order from sales person and the system will email back to office. First, we will need to export ms excel file into mysql database, this might be a routine job, means they will need to upload excel file every day. So this needs to be built in. They will have, SKU, product name, stock level, size, how many units in one box, carton price, unit price etc. So now the system have the stock details right? So salesperson has an account each one. They will use the website to key in order. They just key in partial sku, or product name, some choice will come out now. After they select the item, price will show, so now they input qty to be order. Then key in next products, on and on. Then after done, once press submit, the system will deduct the stock level, and write to an excel file, and email back to office.
4 Interface
4.1 Admin Panel
• Create and manage salesperson
• Upload Excel
• View and edit order
• View and manage products
4.2 Salesperson Panel
• Create order(Input products name or SKU code and QTY)
• View and edit delete order(when edit and delete, needs send email back to office)
Hardest part:
- Upload excel and update mysql table
- When create sales order, it will turn the order into excel and attached into email. Format will be given.
Please bid on your lowest possible budget according to this requirement. We will contact the lowest bid first and move up.
I will send you more detailed document when we discuss.
Hello,
Ready to start and complete, please do send the document.
And never prefer for low bid, think of project requirements and look for worth of paying
Hi, we have a team of designers, developers, and online marketers who are in this field for more than 10 years. We have gone through the requirements and ready to complete your work upto your satisfaction. We provide Web Applications Development, Huge web portals, CMS-based websites, eCommerce website..etc. Kindly check our profile & reviews for our work expertise and customer satisfaction from our work.. Thanks
hi there, I can handle your job. Please gimme more details about the project. As I've read on your description, you need an excel(xls or csv?!?) importer first and then few other small tasks related to admin area. I'm ready to start at any time!
hello sir / madam,
i have read your project description and i can do the project.
i have expertise on PHP, Mysql, AJAX, OOPS, html, dhtml, designing [ LAMP/WAMP ] and i have best programmer and designer skills. i can provide you the best services and make you experience the fastest development for your project.
i hope you will revert to me positively soon.
thank you.
with regards,
zub.
Hello There
I think i can help you out to achieve this task..
However need more details for the same..
Do you have a readymade template or should i start from scratch??
Hoping for ur prompt reply
An interesting project. I can give you exactly what you require as we have done several similar projects. Some of my customers do this slightly differently. Instead of sending sales data via excel sheet, they had asked us to build a web based system so that office staff can view all the orders and edit/delete as required. For stock control, office records how much was dispatched to each sub-office and it automatically gets reduced when salesman puts in order.
Now our customers have started the ask us for Android phone software to enable sales people put in order that saves in database on web server automatically for further processing.
In our system, there is no dependency on excel output and email etc. Every thing is directly handled by salesperson and office.
If you are interested, let us talk.