Hello I need a database that can calculate how much stock i have, what i have sold, and what the profit level is. I need it to be idiot-proof. So i need it to be very simple. EACH QUERY FORM IS ON A SEPARATE PC. I press one button for each product, and it prints a barcode. -I need to be able search products -I need to be able to add products. I scan the barcode on one query form, it adds new stock to the database. it needs to ask when putting new stock in: -What price bought at (this will be in CNY, not GBP) -What was the exchange rate from GBP to CNY was exchanged. Shipping and Tax fees -How many piece bought? -What was the Shipping? (this will be in CNY) -What was the Taxes? -What is the Shipping tracking number? -What box it is stored in? -Asset Worth? - Most important needs to be verified by only a boss. after it has all this information with shipping and taxes, it needs to calculate shipping and taxes cost per piece. for example I order -100 pcs umbrellas@20 CNY. -the exchange rate is 8.900 -the shipping is 2000 CNY for the total 100 pcs -The tax is £30. it needs to calculate the cost per pc for this batch. -20 CNY/8.9=2.24719 GBP (cost of product) -2000 CNY (DHL shipping cost)/100 pcs= 20 CNY each (for shipping) shipping exchange rate calculation 20 CNY/8.9=2.24719 GBP (shipping) Taxes £30 taxes/100 pcs=0.3 GBP per pc taxes 2.24719+2.24719+0.3=4.80 total cost per pc. I scan the barcode on a different query form, it says sold, when a product is sold the database needs to -minus from stock -Customer name -Customer address -Customer contact number -Ticket number -ask what price it was sold at -record date -ask wether it was cash paid, bank transfer, or Trade credit. --If trade credit it needs to ask what date they plan on paying. -verification required by a boss Returns I scan on a different query it says return. -minus from cash flow -What box it is in? -What is the fault --if customer cannot pay, it must add to stock again. --If has a problem, ---it needs to be put with returns ---What box is it in? ---(Not add to stock) to be sent to China. ---If it was replaced, or refunded. Wages Everybody has there own pass card. when i add a new employee, it need to ask --Name? --Address? --Position in the company? --What there hourly wage is? --working hours? -I need to know what my profit is after all wages are paid, it needs to minus from profit in real time. -need them to be able to scan there card at the start and end of each day? --employees need to log in between 9.30 and 10am. if not requires verification from boss and ask penalty charge?. --employees leave at [url removed, login to view], any earlier requires boss verification. and ask penalty charge? --needs to automatically log out all employees at 7.30, if not logged out, boss needs to know. Miscellaneous company cost Cash needs to be claimed back, if employee spent money. - for example petrol. --It needs to ask ---Employee scan ---What it was? ---Cost of item? ---picture of receipt? (not sure if possible) ---Boss Verification -minus from profit. Simple inquiry this is for 2 purposes, Find where the stock is, and if they scan a barcode, it gives them information on that product. -simple search --search for product. for example, I type umbrella, It tells me stock level and box number The second one is barcode scan --I scan a barcode it tells me if it is return, stock, what product it is, where it should be stored. Partners page - I only need to show financial information here --So the Profit and loss. --estimated profit on a different section --Asset Worth ---1 day ---1 week ---30 day ---3 month ---1 year --How many LCDs sold.
19 freelancer bu iş için ortalamada 216$ teklif veriyor
I have good knowledge about core php and wordpress and mysql Relevant Skills and Experience core php , mysql Proposed Milestones $77.5 USD - milestones $77.5 USD - milestones