order entry for custom products
$5000-10000 USD
Paid on delivery
We manufacture drawers ([login to view URL])
We use an excel (xlsm) program to enter sales orders.
We maintain a list of customers on a Client worksheet
The order entry sheet allows the user to choose a client
enter project desc, PO #, order date, requested date
enter general specifics about the order
material used for drawer sides
material used for drawer bottoms
various construction details
top edge detail (bullnose or flat)
notching/drilling requirements - undermount
etc etc
The next section is user input on the qty, and dimensions
QTY Width Depth Height Description Pullout (y/n) Scoop, Sloped side (front height)
5 34 21 4 Cab #23 N N N
2 22.5 18 7 Cab #4 Y Y Y 3
etc etc
200 rows
The above is very basic info - 90% of drawers are 'basic' material used, construction, and qty's and dimensions.
The web based order system will need to do the following.
Allow for 'guests' to choose a certain material - enter basic information and qty's and sizes.
To obtain a price - which they can request as a Quote -- or submit as an order.
Allow for existing clients (our wholesale trade clients) to login with their credentials to create an quote or an order. Also having the ability to create and retrieve stored 'product templates.
For example wholesale customer A - may have three templates that they often order from.
Template name "Oak Ply" created and saved for this particular customer.
Would consist of the following basis values
Side Material: 1/2" Oak Ply
Bottom Material: 1/2" Oak Ply
Bottom Construction : Let in 4
Bottom Recess : 1/2"
Top edge shape : Flat
Top edge corners : Stepdown Amount: 1/8"
Top edge treatment : Edge Banded -- Oak
Notch and Drill for Undermount glides: YES
Install Clips : YES Clips: Blum Std
Finish : Finished after assembly
The above information is a 'template' that contains general information about how they would like their drawers to be constructed.
The next step is to enter the Qty, Width, Height, Depth (description), and some basic 'special' characteristics.
____
Once this basic functionality is created -- then additional functionality will be added.
Email the quote or order confirmation
Create a new form (window) per line item for 'specialty drawer information.'
(file drawers, ILF (integrated lip fac drawers), drawers with dividers, trash container drawers,
hamper drawers, etc etc, ).
Most of the functionality listed above has been accomplished with our excel sheet - however, we need to allow customers and prospects the ability to generate their own quotes and orders.
Please contact me if you are interested and convinced that you can do what we are needing.
Project ID: #17736285
About the project
49 freelancers are bidding on average $17179 for this job
As as core developer i am good to design & develop the custom platform as per your needs (mention on your project description). can we discuss more on freelancer inbox to get detail understanding about project so ba More
Hello, We are IT-Engineers with higher education, having more than 15 years of experience, developing sophisticated CRM and ERP solutions from scratch. Our indicative time/cost estimation for your project relies More
order entry for custom products Dear sir I have completed projects similar to your requirement in the past. If you could share your project detail requirements, I will share relevant past work and demo. I alr More
Hello! This is vibrant webtech and I was glad to see that you're looking for help for project order entry for custom products. I've delivered more than 400 + projects in the last 5 years and this makes me very con More
Hi there, I can do order entry for custom products. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
Greetings Drawer Shop Admin/Manager, I'm specialist in making easy to use custom web-based system. I've read your requirements, checked website and I would like to review your excel file. Following is a summary and More
Hi there, I have read the details I am experienced with PHP, Software Architecture, Visual Basic. I can help you with this job, Please come to chat so we can discuss this job.
Hello, I have extensive experience in order processing. I have 3 years experience in working as a order administrator. I'm very much interested to do your project. Please allow me to discuss with you about the proj More
Hello, my name is Daniel, nice to meet you. I am an experienced freelancer and I`m really interested in your project. Quality and speed are my leading stars and I am one message away from being at your service. Regards More
Obviously, I would need more information before beginning work with you on this project but I get the general idea. I am willing to work with you to determine the requirements and provide a good solution for you.
Good morning, I am Inquiring about your project. Are you wanting a custom program built ? I feel like Microsoft access would be a perfect solution. I would like to build a custom program using access. Access can be More
I can build such Web Application which will provide all the data entry screen and take orders. I have build lots of Windows Application for example, Back Office, Inventory, Accounting, Hardware Controller System, etc. More
Hi, I am an excel VBA expert and have made many such similar applications. In my experience, VB.NET is the best way to go about it as you can have multiple logins on a shared network. I went through your project de More
Hello Sir/Madam, I would like to help you. I read your project details and able to start right now. so you can hire me to get a Quality Service. Thanks Tanay
Dear Project owner, This is Priyanka from AllCAD Services India, We are able to do this web development for you according to your requirement We have an excellent freelancers team to handle big & complex projects More