Development of a database with graphical user interface

Σε Εξέλιξη Αναρτήθηκε Πριν 4 χρόνια Πληρώθηκε κατά την παράδοση
Σε Εξέλιξη Πληρώθηκε κατά την παράδοση

Please read carefully and quote for how much the WHOLE PROJECT would cost. I prefer to agree on a complete project price rather than an hourly rate.

What I need:

• I need you to build a plain stock database with GUI for my shop products. The database will need to contain simple tables to fill in information like manufacturer, product name, product categories, description, weight, barcode, etc.

• Additionally I will require the database to pull information from our current sales software (which uses SQL databases), such as current stock levels, current price, recommended retail price, special price, cost price and similar. This sync with the SQL database could be done manually or automatically (e.g. scheduled or whenever the database is opened).

• I will also need to attach an image to each product in the stock interface. We currently name images according to the product-ID and save them in a designated folder. I don't know if it is technically possible but it would be great to have a drag-and-drop function where we can just drag an image onto a field in the interface and the program automatically saves the image named as product-ID in a certain folder.

• The interface could/should include drop-down menus (e.g. for categories), tick boxes (e.g. for tax/tax-free items), text fields, pictures.

• Stock information will need to be entered in two languages - the GUI could have one tab for each language or both languages next to each other. I would prefer to have it set up so that when I enter the category or brand name in English it automatically fills in the translation in the second language (of course we would put the information into a table ourselves first).

• The finished database should include a simple search function and possibly search filters (for Name/part of name, Barcode, Brand) so that we can easily find certain items and change the data if required. I have attached

• If possible I would like to have two different user privileges (user and admin - with certain fields only usable when logged in as admin) so that the admin can have a final check prior to publishing the stock line.

• In regards to the database structure/software: I don't know which is best suited for this project (MySQL, NoSQLite,...?) so I am very open to your suggestion. The database our shop software uses is a SQL database running on the shop master computer (Windows 7). It would be great if we could put this new database on a cloud storage (Dropbox, Google Drive, etc) so that I can work on it from different locations.

• I have set up an excel spreadsheet that does most of this at the moment, I do however prefer to have a proper database for my stock so I can get other people to easily enter data/information with a simple and clean GUI. We currently have approximately 2500 items in the excel spreadsheet and you will need to import the current data into the new database (should be straight forward). The database should however be able to easily handle 20,000-30,000 lines.

What I want to do with it:

• This database will be used to create various forms and csv or excel files. We are running a small online shop and I will need to export some of the data so I can upload it to our web shop. I think I'm ok to set this up myself once the database is done.

• With the excel file I currently use I have a very simple 'Label' form which allows me to scan the barcode of various products and my labels are automatically populated with the corresponding information (Product name, price, RRP,...). I'm not sure if the database software can be set up to do something similar. Otherwise we might be able to pull the data from the database into an excel file and print off labels from there.

Attached files:

1) A sample excel to show what the database GUI could look like

2) A word document to explain each of the fields in this excel

3) A random sample of how I imagine the GUI could look

Microsoft Access MySQL SQL

Ταυτότητα Εργασίας: #19307205

Σχετικά με την εργασία

17 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 4 χρόνια

Ανατέθηκε στον:

xahirlehri

Hi, I'm professional database application developer, I found myself interested to assist you, I've already done this type of project for my one client please feel free to contact me I'll show you recent project that I Περισσότερα

$277 AUD σε 10 μέρες
(0 Αξιολογήσεις)
0.0

17 freelancers κάνουν προσφορές κατά μέσο όρο $351 για αυτή τη δουλειά

kipdev13

Nice to meet you. I've read the project description and can develop definitely. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, front & back-end web dev Περισσότερα

$100 AUD σε 3 μέρες
(58 Αξιολογήσεις)
6.7
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Περισσότερα

$250 AUD σε 3 μέρες
(66 Αξιολογήσεις)
6.8
idrisakano

Hi, kindly reach out to me. I can help you build a nice DBM app with GUI. I placed my bid at $250 as I don't like to over bid, I'd like to know if your budget is open to review Hope to read from you

$250 AUD σε 5 μέρες
(16 Αξιολογήσεις)
6.5
expertcoder1vw

Hi, I'm a professional software application developer, and can develop this database application for you. Will work with you to get the application working the way you require. Required time: 30 days. This is Περισσότερα

$1250 AUD σε 30 μέρες
(77 Αξιολογήσεις)
6.5
prakash2813

Hi there, I am java developer with 7+ years of experience in web and desktop app development. I have read all details and checked attached files for further details. This is an easy job for me as I have already deve Περισσότερα

$500 AUD σε 5 μέρες
(34 Αξιολογήσεις)
5.7
alaeddindhahri

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel Περισσότερα

$1111 AUD σε 15 μέρες
(72 Αξιολογήσεις)
5.9
xinglong717

Hello. I understand your job. I am confident you will be most satisfied with the work we do. Please come over chat for further detailed discussion to start working on it. I will show results with high skill and s Περισσότερα

$155 AUD σε 3 μέρες
(38 Αξιολογήσεις)
5.3
rinabuoy13

Hello, I am independent, experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$200 AUD σε 3 μέρες
(16 Αξιολογήσεις)
4.9
dionisiotumbaga

Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.

$250 AUD σε 5 μέρες
(9 Αξιολογήσεις)
4.8
PATechnology

Hi, I am interested in the task and can do it. Please ping me to discuss more. Thanks ,

$500 AUD σε 15 μέρες
(30 Αξιολογήσεις)
4.5
doxan

Hello. My name is Andrey. I am web developer and have extensive experience with various systems like CRM, accounting systems, web based databases, etc. I carefully read the description and 3 attached files Περισσότερα

$155 AUD σε 21 μέρες
(7 Αξιολογήσεις)
3.8
mfaisal902

Greetings Sir, I am Muhammad Faisal and we are professional Java Developer having almost 5 years of experience and we provide you quality work within your budget and time duration so, lets get started

$130 AUD σε 3 μέρες
(4 Αξιολογήσεις)
2.3
changiergroup

Hello, i have read requirements. I can do this using mysql database and i can create gui using PHP. I am sure i can do this. I have demo of importing 1 lac record. I can make import and export faster. Thanks

$300 AUD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
Farrukh009

I am Professional Windows Form Application designer and i make a best UI(user interface) application for you in just Five Days. For any kind of information feel free and contact me on Skype i will provide all inform Περισσότερα

$100 AUD σε 5 μέρες
(0 Αξιολογήσεις)
0.0