In Progress

Build a data integrity website -- 2

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

Inputs:

- [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: .NET, ASP.NET, MySQL, SQL, Website Design

See more: build data mining project, build free mixtape website, data feed website, build online recruit website, free product data feed website, build iphone compatible website dreamweaver, build ecommerce shirt website, website concept idea, build data gathering website, build data driven website, need website build data base, Build a Website -- 2, Build a Website --2, build a website -2, build a website 2, build a website-2, build a website------2

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

Project ID: #23782062

Awarded to:

CodeazeUK

Hi, I hope you are doing well. I’ve been developing custom websites and web applications for the past 6+ years and have satisfied clients all over the world. I went through your work description and I have done similar More

$300 USD in 25 days
(1 Review)
3.9

22 freelancers are bidding on average $298 for this job

raju51279

hello sir, kindly check our service related sites [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] More

$1400 USD in 47 days
(840 Reviews)
8.4
junkyfunky

Hello, I've read your project description and I want to tell you that I can build a Professional and High Quality data integrity Website for you as per your [login to view URL] have a quick chat to discuss this projec More

$90 USD in 10 days
(165 Reviews)
7.3
mascotindia123

Hello ! Hope you are doing well! can you please come in chat box to discuss the project i am available and ready to start the project I am good at : - Custom PHP, Laravel, CI, NodeJs - HTML5 + CSS3 Styling, More

$1250 USD in 4 days
(216 Reviews)
7.3
techplusintl

Hi there, I'm ready to build a data integrity website. 17+ years experience and expertise in : CMS (Wordpress, Magento, Shopify, OpenCart, Joomla, Drupal, Prestashop, Wix, SquareSpace, Weebly) PHP Frameworks (Laravel, More

$200 USD in 5 days
(134 Reviews)
6.9
kgsolutions

# data integrity website Hi there, Greetings!! Please Check my Profile. I am a Full-Stack Web Engineer specialized in C# (10+ years ’ experience); ASP.NET, Dot net core 2,3 / MVC WebAPI, REST API; Azure, Azure L More

$140 USD in 7 days
(25 Reviews)
6.6
jyotivmsoftsolut

Hello !!! I am specializing in Wordpress, Wordpress themes, Blog, Woo-commerce HTML/CSS, UI/[login to view URL] refer to my portfolio of work on Freelancer https://www.freelancer.com/u/jyotivmsoftsolut I am highly proficient More

$200 USD in 2 days
(41 Reviews)
5.8
Webguru71

Hi, I have read your project description. I am full stack developer having six years working experience and I am very confident to build your website in PHP, WordPress, Laravel. I am an experience in front end design More

$140 USD in 7 days
(58 Reviews)
5.9
arnoldb

Hi, I am an experienced web developer from Poland.I will build data integrity website that will allow you to see your inventory list in a web [login to view URL] discuss more over this when you are available. I have reviewed y More

$180 USD in 6 days
(9 Reviews)
5.2
sharesoft

Hello, Hope you are doing well!!! Thank You for Sharing your project requirement with Us, its our Pleasure to work on your project. ShareSoft Technology was established in 2011 by executive management professionals fro More

$140 USD in 3 days
(23 Reviews)
5.4
udalsoft

Respected Sir, Greetings of the Day ! I am Udal Bharti . I have 9+ years of competitive experience in web application development using asp.net MVC and SQL server. I have 9+ years of experience in Database developm More

$250 USD in 15 days
(16 Reviews)
5.3
hsh564cf84accd96

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si More

$100 USD in 7 days
(17 Reviews)
3.8
amitchoudhry

i have already build a data integrity website so i can develop website for u ready to start work from now

$300 USD in 3 days
(5 Reviews)
3.9
nusystec

Dear Customer Greetings for the day!!! I am Agnesh Arya an experienced .NET professional with 10+ years of experience based in India. I have developed various .NET based applications using latest framework like MV More

$140 USD in 7 days
(5 Reviews)
3.7
waseemsaleemg

Hi Dear, Our best concern is to follow your requirement and deadline and we will do our best for the success of your project. Feel free to send message to discuss your project with us. Thank you very much! Surely, we'r More

$246 USD in 5 days
(7 Reviews)
3.7
webtheorems

Hi, I am an Expert Software achitect (12+ Years) and 100% confident to presentthe Possible Cheapest Solution for this work post. -I am ready for Technical Discussion/Interview -Available as per your time zone - More

$240 USD in 4 days
(8 Reviews)
3.2
mobileappsites

Dear Client, Hope you are doing great. I have a Classified application for all the three platforms with source code that i made before. As per my understanding that you want to get develop Classified solution. it ha More

$140 USD in 7 days
(4 Reviews)
2.0
datotahost

Hi, I will build the custumize application using the .bet framework and custumize it as per the [login to view URL] the excel and categories and data storage data

$500 USD in 15 days
(0 Reviews)
0.0
olnmrktdunitech0

Hey There !! FULL STACK DEVELOPER I have read the job description of yours and ready to start work with you as i am having major 11+ years experience in Asp.net, Asp.net Core,Angular Js Angular2 ReactJs ,Noode Js mssq More

$140 USD in 7 days
(0 Reviews)
0.0
kiteszones

Thank you for taking the time to review my bid! I am really eager to work on your project. I believe in ORIGINAL and QUALITY work since Work is my solo identity. I am a highly motivated logo designer so I can deliver More

$200 USD in 5 days
(0 Reviews)
0.0
AMARRKO

HI, Greetings! I have read your project description in carefully and I am really glad to work with you. I can work in your project in budget and will deliver my best work. - 5 years of Extensive experience in Developm More

$112 USD in 7 days
(0 Reviews)
0.0