Inventory & Proposal

We wish to develop inventory + proposal software to pick, reserve, or replenish inventory from 4 warehouses, including part number, part name, weight and dimensions, and generate parts quotes for clients (from a client list) on a letterhead template, integrating logistics API's if possible to add freight to quotes. The client's previous orders should be accessible from search to check the last price sold.


We have an international business based in the US which is manufacturing and distributing equipment to the wastewater treatment market. We maintain stock in NL, UAE, KR, India and USA, and we have clients worldwide. Presently we employ 4 people in inside sales based in the US, plus people who do inside sales work at remote locations. We currently keep track of inventory manually on an Excel spreadsheet, and we categorize stock by part number, warehouse location, and in-stock (+), en route, and deficit (-). We currently write proposals from an email client, from a previous proposal in MS Word or from a blank sheet of e-letterhead in MS Word, and we manually enter the quantities, prices and tally the totals, then manually calculate weights and dimensions. Based on those values and the client location, we determine whether to ship via UPS, truck, air freight or ocean freight, and then we price accordingly, and manually add that to the proposal. Then we prepare an email, and attach the proposal together with supporting documents like product data sheets. All of this is done internally. European clients have limited access to inventory reports in Europe but not to other warehouses and other clients located elsewhere in the world do not.

Note: A non-disclosure agreement is required to accept this work.

Scope of Work:

Develop a web-based proposal and inventory tool with strong page-by-page security containing the following:

Prepare a database with the ability to enter the following fields:
Item #
Part #
Quantity in stock
Quantity in transit
Arrival date of quantity in transit
Quantity reserved from stock and in-transit
Product Description
Unit List Price

Prepare a GUI with the following pages:
User login with password
Administrative login with password
Administrative settings page with the following links:
Users (Administrator, Rep or Agent), Roles (discount codes from list price which may be a fixed discount, or a discount against a curve, just for one possible example 20% off a $500 order, 50% off a $100,000 order and a curve in between, location of customer, payment terms)
Counters (closure rate, usage tracking and pricing/total sales reports through this system)
Clients (End User – A User can sell to a Client, for example)
Input Container (incoming shipments entry, with targeted arrival date, model numbers, quantities and warehouse location)
Input New Items with auto-assigned item #, enter part #, description, unit list price, and initial in-stock, en-route and reserved inventory levels, weights and box dimensions, ideal stock quantity, alarm%)
Input part number or description, quantity, and client name and address (for all users). Multiple items can be priced or ordered at once. Offer warehouse choices from which to draw stock, possibly more than one, with check boxes. Pricing should be auto-generated for regular users, but for administrative users, offer the ability to modify the price.
Offer a button for a regular user to “Place order”

Algorithms and Functions:
Determine appropriate shipping method by weight and shipping volume.
Call API for appropriate freight estimate, where appropriate, in which case return price FOB Jobsite. Where a freight estimate is not possible, i.e. for big shipments or international shipments, quote FOB Factory.
Match required quantity of each part number by user to the available inventory. If there is enough inventory return ex-stock. If there is sufficient inventory for a partial shipment, return that quantity with a leadtime for the balance. If the balance is en-route, refer to the input arrival date and return that value for the balance. If the balance is not yet en-route, return 8-10 weeks, typically. Typically stock is requested within a geographical region, for example NL serves Europe, UAE serves MENA, India serves India only, USA serves N. and S. America, and Korea serves Asia (Korea also has a quicker build than 8-10 weeks for Asian shipments). It would be appropriate to offer stock from another location sometimes, for example if NL has stock but UAE does not, some clients in MENA will take from NL. Likewise if USA has stock but NL does not, some European clients will take from USA. But this should be optional.

Ups.com (box shipments, worldwide)
Freightquote.com (trucking – USA and Canada)
www.searates.com for pallet stuffing?

Preview the critical parts of the proposal on – screen.
Offer the administrative user an over-ride of the auto-generated quoted price and leadtime. Let them fill in their own prices in that case.
Offer over-ride of freight option where available (yes or no) to all users, and if no, quote FOB Factory. Maybe a check box? Offer a manual input for freight in case freight was not able to be auto-generated, and if there is an input, offer FOB Jobsite. As another option, offer freight “at acutals” at time of shipment which means to you, FOB Jobiste, and on the line item which says Freight on the quote, instead of a number, list AT ACTUALS , and we will update our accounting software later.
Show estimated weights and dimensions in the proposal. Assume full box quantity for dimensions (weight will be by units). Pallets vs boxes gets more complicated. Let’s talk about this. Is there an API for this? https://www.searates.com/reference/stuffing/ Have a look here.
Offer choice of Print or Email proposal. Auto-fill quotation, freight & leadtime info into quotation template. Auto-attach the corresponding product and system data sheets & terms and conditions of sale and warranty page to proposal for email offers. Quote validity should be 30 days but adjustable by administrative users.
If the user clicked “Place order” generate an email to company and pop that quantity from stock from the desired warehouse.
If the order <=$350 not incl shipping for US customers, add $75 handling fee. For $350-750 add $50 handling fee, for US & European customers. Administrative override is available. This can be an adder on a new line item. For MENA customers, we add for 0-$500 a $150 fee , 500-$1000 a $115 fee and for 1000-$1500 a $85 fee.
If the order is by cr.card, there is a 5% cr.card processing fee. This can be included as an adder on a new line item
If the value of the proposal is more than $100,000 only an administrator can issue the proposal. Authorized users should be given a screen saying, contact factory.
An alarm function should trigger a daily or weekly email (not each incidence) to the administrator when the stock level of an item(s) drops to alarm% of ideal stock quantity for each item kept in stock with report.

A demonstration of a similar PHP application which was developed for our system quotations is available. This program has very similar administrative settings and outputs to the software package we wish to develop now.
Sample parts quote templates from past offers are also available to give you an idea what we want to auto-populate.
The current XLS inventory sheet is also available to review.

Compétences : Django, MySQL, PHP, Python, Architecture Logicielle

en voir plus : integrating wordpress website template, integrating godaddy api, api template monster php, sample proposal inventory system, proposal inventory database, integrating bullhorn api, web site api template, sample project proposal inventory system, best api template, aspnet inventory tracking web site template

Concernant l'employeur :
( 0 commentaires ) Poughkeepsie, United States

Nº du projet : #8525292

43 freelance font une offre moyenne de $2785 pour ce travail


Hope you are well. We have some questions? Can we discuss in details before we start? Agile model of development to have the best deliverables for your [login to view URL] me know if we can connect on Freelancer chat to dis Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 55 jours
(325 Commentaires)

Hello. I am interested in your project. I am full-stack developer and my ranking is 6th in freelancer. When i work for this project, I can make good result more than you could guess :) I hope to work with you. Bes Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(434 Commentaires)

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors. see my recent Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(164 Commentaires)

Hi there, I have read your project description & understand the initial high level details but wondering if you have complete requirements? Once I have complete requirements or high level list of features, then I can e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 40 jours
(94 Commentaires)

Hi, We have read the project requirements in complete detail. We have noticed that you are seeking highly skilled and expert professional personnel to develop an inventory and proposal management system. We are a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 45 jours
(192 Commentaires)

Hello, We can build you the software that you’re looking for. We've built a backend automation system for this company. [login to view URL] It’s a business automation system that was created to help an ente Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(109 Commentaires)

Greetings, Kindly share some more details about your project , i also need to discuss the project in detail kindly inbox me so we may proceed further. I have 10 years of experience in web development and i am expert Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(150 Commentaires)

Hello Dear, Hope you are doing well!! We are in the top 10 freelancer here. I have gone through your project description and I come to know that you have required inventory + proposal software to pick, reserve, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 45 jours
(167 Commentaires)

Hi, I have read your post and understood your requirement. I have great experience in handling /PHP/MySQL/Python/Django/HTML5/jQuery/Wordpress/Magento/Joomla/Drupal/AngularJS/node.js/CSS3/Java/Javascript/iOS/Andr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(110 Commentaires)

Dear Client, As per the project requirement you are looking for a web developer to build an inventory management application. We would like to discuss further on this as we have prior experience in working on an inv Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(69 Commentaires)

Hello We went through project description very well .We are professional website design and development company operating in UK and India. We have 8 years of experience in web/mobile design and [login to view URL] provide Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 40 jours
(145 Commentaires)

Hello, My name is Faizan and I am a PHP developer. I have seen your project requirements and I am sure I can do it. Can we discuss in detail A little bit about me: I belong to a team of 3 developers and 2 designe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(113 Commentaires)

Hi, since I have experience in much big projects in ERP domain thus, Inventory business logic, I can describe in my own words as follows: 1. The warehouse management system ( WMS) have a production department, w Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(34 Commentaires)

1. Invoicing App We already designed and developed a complete online invoicing application in which currently we are handling these modules 1. Place New Order (phone order page from sample) 2. Pending Orders 3. Shi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 45 jours
(98 Commentaires)

Hello, I m Tahsinul Alam, completed Masters in Software Engineering now working as one of the project manager of Workspace Infotech, software/Outsourcing firm located in Dhaka, Bangladesh. We have 13 different team Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(56 Commentaires)

Hi, Mark here, I would be interested in discussing this project with you. Thanks for the consideration, I hope to hear from you soon Thanks, Mark

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(26 Commentaires)

Hi, I am managing a professional web agency for more than 8 years. You can check my Themeforest profile with ratings here: [login to view URL], as well as the marketplace I build recently for prom Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 33 jours
(46 Commentaires)

Hello We are a young offshore web design and development team with average resource experience of 10 years in PHP, MYSQL, Jquery, JS, XHTML, CSS3, AngularJS , NodeJS Twitter Bootstrap design framework with mobile re Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(42 Commentaires)

Hello There, We are subject matter experts for designing and developing system that connects with other offices/warehouse to manage inventory and payroll. We are working on point of sale portal for Spa that allows o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(22 Commentaires)

We are Israel based premier specialist IT solutions and services company, that combines core technical expertise with a global business perspective. The company's key offerings include product development, migration, p Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 60 jours
(13 Commentaires)