Trying to make our stock takes more user friendly and efficient by moving away from pens and paper and using a small webapp which update the main sheet on the fly to allow the inventory manager to see live results and send teams back to count locations where there may be a miscount or gap in quantities. Please my budget is not massive and i have found a way to use google sheets however I would rather have logins for each team and popup messages from the admin to send people back to recount. Please see the attachment of main sheets and count sheets.
Sku List - 6 Columns - ProductName, Description,ProductType,PalletQty,CaseQty,SingleQty
MainCountSheet - 14 columns - Location,SKU,WMS
Qty per Loc.,1st Count,2nd Count,3rd Count,Final Qty,Discrep,Remarks,Total WMS per SKU,Total Phys per SKU,WMS diff,Item Master,Product Type
Admin Feature -
Need to have an admin section where you determine how many teams there are and assign a group of locations to the teams.
Admin sheet will see the database update every 30seconds to see the counts being updated. If anything doesn't match what the main warehouse system shows as in stock then the admin will mark the count as problematic and a notification will be sent to the team who counted to recheck at the end of their workflow.
Login as Team1 and you will see all the locations that you have been assigned to count.
Count Sheet should show the following:
Location,SKU,Description,QtyPallets,QtyCases,QtySingles,Total(Sum of QtyPallets x SKUList_PalletQty,Sum of QtyCases x SKUList_CaseQTY,Sum of QtySingles x SKUList_SingleQty) = Total counted.
24 freelance font une offre moyenne de $168 pour ce travail
Dear Sir, Nice to meet you. Lets discuss more over chat. I am an expert mobile and web developer by profession from Poland. I have developed many apps for 7+ years and uploaded it on app store and play stor Plus
Hello hiring member i am bhavika i have 2.5+years experience in php ,laravel ,ajax,jquery , so i can do it and i have done many stock managents sites and i have good team who can manage this all things so please give u Plus
Hello, After going thru your job description, I feel as a good fit for this job, as I have hands on experience working on the PHP, Mysql, HTML, JQuery Frameworks, as well as Major CMS's like Joomla, WordPress and M Plus
• Identification and rectification content on the various pages. • Identification and removal of low quality pages that add no value to the website. • Identifying and eliminating redundancies in the content. • Creat Plus
Hi, Glad to have come across your job post. I have a lot of experience in web app development using Ionic, React and HTML5 I cannot show most of my previous work here because of strict NDA’s however you can get i Plus
Hello I can help you to get it done quickly. I have 10+ years experience in php/mysql development. Thanks Guru Venkat
Hi there Relevant Skills and Experience How are you? Proposed Milestones $800 USD - Completion I have been specializing in web design & development, including Angular, Node, JS, PHP, code igniter, Word Press Plus
I am having experience from past 4+ years & completed 120+ projects in PHP development. I can easily achieve the results that you are asking for. Looking forward to your end. Thanks Relevant Skills and Experien Plus
Hello, Are you looking for a help, for those one who will creat your website or will save your privite data. The official Polish firm aCreative will deal with it very quickly. We are professionals with high education Plus
This is really an interesting project. It’s a great opportunity to work with you. You can trust us over the entire process.
Hi , It’s great to meet you. I’m Somya Tripathi, co-owner of Arkss Technologies Private Limited. We develop: kickass, cutting-edge software for web applications, mobile apps, Blockchain, Cryptocurrency, Tra Plus
Dear Sir, I'm interested in your project. Please send me a message so that we can discuss more. 100% satisfaction, 100% on time. Thanks