Inventory & client Database & form site

DO NOT BID ON THIS PROJECT UNLESS YOU HAVE READ ALL SPECIFICATIONS AND ARE WILLING TO DO IT AT THE PRICE THAT YOU BID. ***If you bid low to get the project then try to get more money for it later I will report you to freelancer and remove you from the project*** ***Terms of payment are 10% up front, 40% when half done and remainder upon completion*** If you do not agree to these terms please do not bid. I run an online and physical discount store that buys product ina bulk mixed lot and then inventories the individual items tracking the retail value to determine our sales price. We sell on multiple channels and our prices often change for promotions and often while negotiating with our customer. I need an online Inventory tracker that calculates pricing and cost based upon a bulk mixed lot purchase and some data we enter. Data will be entered by 2 forms a “Pallet” form where we enter some information on the pallets we purchase and a “Item” Form where we enter the information for the items in the pallets. Pricing is negotiable on all of the items we sell so I need to be able to have a quick overview page that shows data at a quick glance as well as a search option for items. Once an item is purchased I will need to be able to mark it as such and set the price that it was sold at. I would also like to be able to enter some information about the person purchasing the item so that we have a customer database. This website should have an easy to use interface. More details are in the attached file.