Design an inventory management software database program

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

The project is about designing a software database for managing our refurbishment inventory. I prefer the design of that software to be in the form of a website to add multiple users and to be able to monitor everything online. We may add an API integration to that software in the future so we would like the project to be more likely integrable with API if we were to do so in the future.

Project Details:

Project is about 2 databases which should be integrated with each other in a form of website.

First Database is for inventory in, where we post in new inventory (Requires most work). Second database is for Inventory-Out.

The Inventory-In part is detailed for each condition selected. The user has to enter some data in a shape of a form including product UPC , serial number , condition , and some information. Some extra fields are required to filled once a certain condition is selected.

After the form is filled, it should generate an item ID and an SKU for the product depending on a category selected and depending on UPC and condition selected, and printed out on a label with some date included.

Once a UPC of a product matches with another product, we check for the condition. If the condition matches as well, we have to put the same SKU for both products. If condition is different, different SKU is generated.

The word document will include full details of each condition selected and the fields that should be filled with it.

Second Database is for inventory out where we sell these products and therefore move OUT of our inventory. Both databases should be integrated with each other so we can have a report of quanities on hand , sold , inventory available , and serial numbers along with item Id.

The project will also require us to print a label for each form filled with specific requirements for the form and details listed below.

We prefer that project to be in a form of a website since each employee will have his/her own username to log in and so that SKU’S are not mixed with each other if 2 employees or more are working at the same time. Therefore, SKU’s and quantities along with item ID are not messed up with each other.

As well as only the administrator can have access to the final reports and quantities available along with being able to monitor everything online anywhere.

Full details of the project are within the attached word document. Additionally, there is a picture that shows flow chart of the inventory (very basic without details but to give you an insight about the project)

Data Mining Data Processing

Project ID: #14395450

About the project

11 proposals Remote project Active 6 years ago

11 freelancers are bidding on average €1119 for this job

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

€900 EUR in 20 days
(169 Reviews)
7.2
shahiddar

Hello sir I can scrape the websites. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.  Scraping/Crawlingworking experience of more then 8 year Analytics, More

€750 EUR in 5 days
(11 Reviews)
5.2
ManjulAwasthi

Hi I am an MBA, PMP and MS Computers. I have rich experience in developing software systems and have background in supply chain as well, . Together I can develop the database requirement posted by you. We can discuss More

€1250 EUR in 20 days
(3 Reviews)
2.3
TechNamrata09

Dear Sir, Please check MY Repeat Hire rate and Repeat & client reviews as i believe in long term business relationships. Technical Details. I have more than 10+ years of experience in wide range of web & mobil More

€1263 EUR in 30 days
(0 Reviews)
0.0
skilldev

Hello Sir, Thanks for project posting. We are an Indian based technical company. We have checked your complete requirement and have some query. So please message us to discuss on it. So after understanding it well w More

€805 EUR in 20 days
(0 Reviews)
0.0
chesslover

Thanks

€1200 EUR in 25 days
(0 Reviews)
0.0
tsft

I offer to deliver the right solution (its requirements) needed. I can do it for a hesting working with Linux or Windows software stack. Relevant Skills and Experience Software factory. Personalized service (I am just More

€888 EUR in 10 days
(0 Reviews)
0.0