Build a data integrity website

Concept: For a hardware store, want to create a tool that will allow us to see our inventory list in a web form, so we can filter through our various departments/categories and confirm that items have been assigned the right classification in our legacy POS system. Close to 30k items, and more added weekly


- [dynamic] an excel file (attached) of my inventory in a store

- [static - but editable on webserver] a folder of images, where files are labelled using the image SKU (item number)

- [static - but editable on webserver] a mapping of department code and department name (eg. Dept AA = "Plumbing")

- [static - but editable on webserver] a mapping of class code and class name (eg. Class AAA = "Sanitaryware")

- [static - but editable on webserver] a mapping of fineline codes and fineline name (eg. Fineline AAAAA = "Toilets")

"item number (SKU), price, department, class and fineline"....and more columns which will be needed for future extensions of the project form part of the excel

Department, class and fineline are ways of classifying the items. Finelines are within a class. Classes are within Departments. We have about 30 different departments, and several classes and finelines within them. Fineline is not always populated - but this tool that we will be developing will help us identify and fix those so we classify items correctly

I have a folder with images ( jpeg, png or gif) - it should be editable via ftp to add new images should the need arise and the tool detect any new images instantly

Requirement: Looking to viewing all items within a fineline, where we can navigate to the finelines using a tree like below. Click a node on the tree, and it will show you all the items that are part of that node and children nodes. Want to view the data provided in the excel in grid or list format but with the tree as filtering feature and image assigned to the item if it exists

Department A

-- class AA

---- fineline AAA

---- fineine AAB

-- class AB

---- fineline ABA

---- fineline ABB

Department B

-- class BA

---- fineline BAA

---- fineline BAB

The idea is to make sure items are in their right classification. Visually seeing these items (grouped up) is easier than just looking at text. So, as an example, if I found a plumbing fitting in the same fineline of screws, I would know something is wrong. Therefore this is a tool we will build to fix the data in our current system, but this tool allows us to see the data in a more visually friendly manner

In order to track completed work (classification of items), you would need to add a flag on your database (editable on the website) indicating whether the item has been manually "checked off" and is known to be in the right classification. This flag should be editable on the website per item and remembered in "memory"

When loading the page (list of items) we should be able to filter the data, whether we want to see "all items", only "checked off items" or "only non checked off items". This data must be maintained on the website (separate database) and memory remembered since the excel file (input file) will be edited in a different system and be different everyday, but our new data integrity website must be able to remember what items have been checked off and notice what items are new (and hence not checked off yet)

Web tool, should have a link to be able to upload the latest version of the excel file so that the data can be analyzed, and classified correctly (for any new items)

Always happy to discuss requirements further

Skills: Website Design, MySQL, .NET, ASP.NET, SQL

See more: job posting website requirements net, build data mining project, getafreelancercom bookstore project website requirements, build free mixtape website, lowest priced website maintenance flat fee, data feed website, build online recruit website, free product data feed website, build iphone compatible website dreamweaver, build website searches flat file, build data gathering website, build data driven website, need website build data base, looking for someone to build my shopify website, Looking for an experienced web designer to design & build me a website for my business. Must have excellent communication skills, I need someone to build me a website just like this:, I need my website re-configured.I already have a design, I just need you to build my personal website.

About the Employer:
( 0 reviews ) Providenciales, United States

Project ID: #20443851

33 freelancers are bidding on average $225 for this job


Hey Preferred Freelancer here! We are placing our bid so we can discuss the aspects in detail and we would love to help you with your project "Build a data integrity website". We are expert in PHP, Website Design, My More

$250 USD in 4 days
(273 Reviews)

Dear!,I am Jin.S__ . I'm interested in the project you recently posted. I'm a certificated freelancer with over 1350 good reviews from clients. I have experienced knowledge in every part of Web development. I never dis More

$200 USD in 5 days
(222 Reviews)

Hello there, I have around 9 years of in ASP.Net, MVC, .Net Core, Web API, AngularJS, Angular 6, Rest API, SQL technologies. I am ready for any kind of interview before start any job. Rate: 15$ per hour. Below are More

$140 USD in 7 days
(51 Reviews)

Hello, Greetings from Optisoft! Please check out Portfolio & Reviews: I have 10+ years of experience in web development have developed 150+ projects in WordPress. Once w More

$250 USD in 5 days
(82 Reviews)

100% Completion Rate and 5 Stars Dear, employer. My name is Lee, I am an experienced web developer, and web scraping expert. I have good experiences in web scraping using PHP, Python, Java and so on. I read you More

$155 USD in 3 days
(21 Reviews)

Hello Sir/Mam, I have read your post requirement for the " Department, class and fineline are ways of classifying the items. Finelines are within a class. Classes are within Departments. We have about 30 different depa More

$300 USD in 7 days
(109 Reviews)

Hi, Greetings !! :) We understood your requirements and ready to do work as per your requirements. We understand all the points you have mentioned in the project descriptions. But we have few more concern about some o More

$277 USD in 7 days
(30 Reviews)

Dear Client, Greetings!! We have few queries kindly ping us. Thanks for giving us the opportunity to bid over the requirement. As per your requirement, you would like to develop a Website. We would like to share that More

$140 USD in 7 days
(23 Reviews)

Hi there, I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like to make you an offer and some background so you can check my work out. Talking about me, I am a More

$350 USD in 8 days
(19 Reviews)

Hi, Hope you are doing well. I have understood your requirements. I can create database, search as per requirements. I do have experience of 10+ years in software/web development. Waiting for your response to disc More

$110 USD in 4 days
(45 Reviews)

Hi, I have done this before but I have a few questions, can we chat please? I have 10 years of experience in PHP.

$235 USD in 21 days
(64 Reviews)

Dear client, I read the requirements and I can develop solution for you. I have more than 9 years of experience in software development and web development using Microsoft technologies. I have expertise in ASP.N More

$200 USD in 7 days
(72 Reviews)

Hi Myself expert in Dot net technologies with 14 yrs of experience in software development. Developed various web and desktop based projects in Finance, Insurance, Research, Education , Research and Retail Domains. More

$250 USD in 30 days
(31 Reviews)

Hello sir, Hope you are doing well. i have 6+ years of experience in WordPress php codeigniter html css mysql javascript bootstrap graphic design website design etc. these job suitable for me Kind Regards, purvi

$140 USD in 7 days
(28 Reviews)

Hello sir, After reviewing your post, I am very interested in that due to my experience. I'm expertise in php, core php, CMS, HTML5, bootstrap, wordPress and many other technologies. I have 8+ year of experience in de More

$44 USD in 7 days
(42 Reviews)

Hello sir I'm professional,c#,nodejs,react/redux,google maps and google cloudfirestore/firebase developer having 5 years of experience please contact me. please check out my recent work. . .. https://revents2-a More

$80 USD in 3 days
(23 Reviews)

Greetings, my name is Ahmad. I am Head of Client Relations and a web-developer myself. I would love to have an opportunity to discuss your project with you. With over 5 years of experience in mobile/web design and dev More

$140 USD in 7 days
(4 Reviews)

Hi. I am very interested to your project and ready to start right now. I have read your project requirement carefully. I can meet your requirement Give me one chance to work for you, will sure give you 101% high quali More

$140 USD in 5 days
(15 Reviews)

Hi I am a professional Amazon expert. I have a huge experience on Amazon. I work on Amazon related tasks. I have been working online from five years in Amazon, eBay, Shopify, Magento, Big-commerce, SEO, SEM, SMM, E-co More

$30 USD in 30 days
(9 Reviews)

Feel fee to contact me for Build a data integrity website .Shoot me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment More

$140 USD in 3 days
(2 Reviews)