Find Jobs
Hire Freelancers

Build me a database with barcode function.

$250-750 AUD

Closed
Posted over 6 years ago

$250-750 AUD

Paid on delivery
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 7-7.30pm, 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.
Project ID: 14769223

About the project

33 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
33 freelancers are bidding on average $544 AUD for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $400 AUD - payment after work completion
$400 AUD in 4 days
4.9 (334 reviews)
7.9
7.9
User Avatar
Self-motivated professional, certified data entry specialist, a proficient web researcher and transcriber, blogger, web designer, Wordpress and various social sites marketer, knowledgeable in SEO. Relevant Skills and Experience Accounting/Bookkeeping, Data Entry Service, Data Processing Services, Data Conversion Services, Database Management, Spreadsheets, Articles writing and Web research. Proposed Milestones $300 AUD - Milestone for the project
$300 AUD in 10 days
5.0 (39 reviews)
5.8
5.8
User Avatar
Hi, I am furkan a CERTIFIED C Programming, Data Entry, Data Processing, Excel, Java , WEB SCRAPING EXPERT . I would love to Assist you in building a database that can calculate how much stock you have, what you have sold, and what the profit level is and all the information that you need about this project . i have already done such tasks ,would love to repeat it, will charge you low PRICE I have 5+ experience in C Programming, Data Entry, Data Processing, Excel, Java, Scraping expert, website scraping, screen scraping, internet research. I can do scarping using any language like ,Python,PHP,JAVA etc. I have successfully completed 100+ projects in C Programming, Data Entry, Data Processing, Excel, Java, web scraping, Data mining, web search, internet research etc YOUR JOB IS MY RESPONSIBILITY. YOUR SATISFATION IS MY GUARANTEE. You can test the quality of my work if needed, and provided that we can also show you my sample works. LOOKING FORWARD TO WORK WITH YOU. Regards... FURKAN WANI
$250 AUD in 1 day
4.8 (27 reviews)
5.6
5.6
User Avatar
Hello sir/ma'am.. I have gone through your project domain..and i want to complete your project. I have 5 years of experience and i can complete your project within your budget.. Relevant Skills and Experience i can do it Proposed Milestones $444 AUD - 1st milestone
$444 AUD in 10 days
5.0 (4 reviews)
4.8
4.8
User Avatar
C, C++, VB3, VB4, VB5, VB6, VB, VB.NET 2015, ASP.NET, MVC, WPF, XML, MSSQL 2014, HTML & CSS3, AWS(Amazon Web Service), Arduino programmer. Digital and analog electronics for 15 and 25 years... Relevant Skills and Experience 15 years of experience Proposed Milestones $250 AUD - To get error free application
$250 AUD in 30 days
5.0 (6 reviews)
4.6
4.6
User Avatar
I am an IITK graduate and I have 9 years of experience in software development. I have 100% completion rate and I have finished all the projects with the highest level of customer satisfaction. Relevant Skills and Experience I usually finish projects with ease on which other freelancers have already given up. I learn and understand new stuff very fast and finish the job with top quality and reliability. Proposed Milestones $555 AUD - test
$555 AUD in 10 days
4.0 (25 reviews)
5.6
5.6
User Avatar
Hi, I’m a Web Designer/Developer from the UK. My name is Mike. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. Relevant Skills and Experience UX/UI design, front end coding, WordPrss/PHP development. Proposed Milestones $555 AUD - project milestone Let me know when you have a minute for a quick chat.
$555 AUD in 10 days
5.0 (1 review)
3.2
3.2
User Avatar
hi.i have extensive database development experience using tools such as ms access,vba,ms excel.i would be happy to provide you with a solution .hope to chat soon
$250 AUD in 10 days
5.0 (3 reviews)
3.1
3.1
User Avatar
Hi, I am willing to work on your project. I had done similar work and get great feedback. Relevant Skills and Experience I will share my experience and work in chat. 1. Wordpress CMS 2. Magento CMS 3, Website design 4. Website development. 5. Php Thank You Christopher Cox Proposed Milestones $555 AUD - m
$555 AUD in 6 days
4.6 (1 review)
2.6
2.6
User Avatar
Hello, It's a pleasure dealing with you. I have 6 years of experience in data entry and processing. My key principle in doing such a job is to deliver it in its highest quality in the shortest time. Relevant Skills and Experience MS Excel - Data Entry and processing Stay tuned, I'm still working on this proposal.
$277 AUD in 2 days
4.9 (4 reviews)
2.3
2.3
User Avatar
Stock database with various utility functions Relevant Skills and Experience Programming Database-SQL,Postgresql,MongoDB Software architecture Algorithm Proposed Milestones $777 AUD - final
$777 AUD in 10 days
5.0 (1 review)
1.4
1.4
User Avatar
I am a professional in providing data entry services using Microsoft office applications. Focused and keen to details while typing any work, I deliver your work within the set timeline. Relevant Skills and Experience Relevant Skills and Experience I possess excellent typing speed, data saving and data processing. I worked as an enumerator for more than two years in data entry field. Proposed Milestones $444 AUD - data entry would you like to discuss the project with me|?
$444 AUD in 10 days
5.0 (1 review)
0.0
0.0
User Avatar
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. I am a serious bidder here and I have already worked on a similar project Relevant Skills and Experience I have checked your requirements. We have right skills to work on this assignment. We are a team of professionals experienced Proposed Milestones $568 AUD - kindly consider me for this work. I will give you quality work within deadline Why choose me: 1. 100% UNIQUE 2. Unlimited 24*7 support. 3. Quality work within deadline
$568 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, how’s it going? My name is Mike, I’m a Web Designer & Developer from Boston. I've had a look at your project description and feel that my skills match your requirements perfectly. Relevant Skills and Experience Graphic Design, Front End Development, PHP, WordPress Proposed Milestones $555 AUD - project milestone I recently did a very similar project which I can share with you.
$555 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$660 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have excellent knowledge of ms Excel macros with excellent typing speed. I can assist you with any kind of data entry work, Excel Data analysis. I assure you 100% Quality of work delivered. Relevant Skills and Experience I have three years of experience in working with ms office tools excel, power-point world etc. Proposed Milestones $288 AUD - complete work
$288 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Liverpool, United Kingdom
4.7
22
Payment method verified
Member since Feb 10, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.