Excel compatible stock keeping software

Closed

Description

Hello!

My name is Robin, and I work at an re-seller of electronical items in Norway. I have an idea that I would like to make. I'm just going to write what I want the sheet to do, and if someone could just give me a hint of what I need to read up upon, it would be much appreciated!

Everyday, we receive pallets with items from our major distributor. The same day the trailer with items arrive, we also get a packing-note. For every pallet we take apart, we need to find every item, and 'check' them of in the list. This is to ensure that we actually get what we are ordering, and to see what we have to report as missing.

This process it extremely time consuming, and is something that I would like to speed up. So here is my idea;

The first picture is what the packing note looks like.

Break down:

Red circle - This is the number(name) of the box, or pallet the items is in.

Green circle - This is the name of the item that should be in the pallet or box.

Blue circle - This is the amount of items like this we are waiting to receive.

What I would like to make in Excel, is a program that automatically takes the PDF document (pre-uploaded to a certain folder by user), breaks the information into separate fields that is pre-configured by me. For example like in picture number 2.

And when all the items on the pallets have been checked, the Excel document should automatically generate a new printable document with a complete list of everything that is either Missing or Too Much, see example in picture number 3.

Lets say there is a barcode named "1000000000XXXXXABC" on a BOX. I take the barcode scanner, and scan it. I need the program to automatically jump to that BOX on the list, and start checking the items. When all items in the box is emptied, the user can press enter, and you are ready to scan a new BOX or Pallet.

The IT department will help me connect the document to our systems, so that the document knows what barcode belongs to which item - connecting programs to our databases is very strict, and will have to be done by our IT department.

Skills: Excel, PHP, Programming, Software Architecture

See more: stock management excel software, stock control excel, google finance stock add excel, stock control excel sheet, basic stock control excel, stock price excel vba, warehouse stock control excel sheet, real time stock prices excel, google finance stock update excel, updated bse nse stock prices excel format click, software css explorer compatible, keeping hyperlinks converting excel pdf, india stock market excel real time, stock data excel, script excel, Copy Paste Excel, convert excel file address book, excel sheet cities world, client database excel, excel template service, customxml excel, creation excel file, excel keyword, office excel time management, excel macro fill empty cells

Project ID: #12245411

39 freelancers are bidding on average $599 for this job

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

$700 USD in 5 days
(376 Reviews)
7.7
$400 USD in 3 days
(255 Reviews)
7.6
pointlogic

Hello..I have done the similar work before , I have an experience of more than 8 years in web development and maintenance. I have in-depth knowledge of php, mysql,Angular.js,node.js,jquery, paypal integrations, API's, More

$526 USD in 10 days
(223 Reviews)
7.8
vishal817

Hello, We have expertise in such type of website. Please check work portfolio here : http://epagestore.com/portfolios/web-development.html http://epagestore.com/portfolios/iphone-application-development.html ht More

$500 USD in 10 days
(24 Reviews)
6.7
pytho

Hi, I am interested to work with you on this project, I reviewed the requests you listed and I would like to discuss further details with you. Since 2006 I am managing a Web Design Agency located in Romania, which cur More

$889 USD in 30 days
(39 Reviews)
6.9
someka

Hi there. First of all, processing the PDF and breaking it into Excel is not very stable method. It can be done but 1. PDFs should not be hand-written 2. They should be OCR compatible 3. They should always preserve the More

$1578 USD in 7 days
(112 Reviews)
6.7
Shopify

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customization, I want to discuss this project with you further More

$773 USD in 10 days
(17 Reviews)
6.8
developerhunk

Hello Sir, I Read Your Project Details and I want to say You That Its a Good project and in that Case We need to discuss About this Job. I got your Overall idea and I can Do it. So Kindly talk to me and Give me a Chanc More

$535 USD in 15 days
(79 Reviews)
7.2
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore More

$773 USD in 20 days
(49 Reviews)
6.9
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Plea More

$750 USD in 30 days
(136 Reviews)
6.3
SevenStarInfo

Hello, We are happy to discuss our proposal with you. KEY POINTS THAT MAKE US DIFFER FROM OTHERS: ~ We have 5+ years of experiences in Unity 3D, Xcode, CoCoa 2d, Phonegap and major iOS and Android developement. ~ More

$1000 USD in 10 days
(54 Reviews)
6.8
webprog4hire

hello robin how are you? i made same thing for a canada based packing company ckdpack with some more features and its made in .net technolgy i can give you demo also lets discuss here himanshu

$833 USD in 10 days
(72 Reviews)
5.6
macroPOL

Hello, I am Excel and VBA expert. Can you provide sample pdf file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$444 USD in 7 days
(51 Reviews)
5.3
$555 USD in 10 days
(48 Reviews)
5.4
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

$500 USD in 4 days
(70 Reviews)
5.3
suniljoshi151

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following sk More

$500 USD in 7 days
(50 Reviews)
5.9
binarycodersvw

Hi.I am a Visual Basic .NET programmer with 10 years experience(I know you hear things like these a lot but I can show proof). This is an automated robot placed bid but I have read the description of your project and I More

$740 USD in 7 days
(16 Reviews)
4.4
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating strings between sheets. I have also expertise in exchangi More

$250 USD in 5 days
(31 Reviews)
4.3
vermadeepika

Hi, Firstly a BIG thank you for putting forward a work opportunity :) I am a full time freelancer and ensure quality work and on time delivery. I have 5+ years of experience in the required skills, can show you few sam More

$250 USD in 10 days
(12 Reviews)
4.5
Brijrajs76

Hello, I am very interested in the project and I would like to apply to it. I'm a web developer with 7 years experience in PHP, MySQL, CSS3, HTML5 and deep knowledge WordPress, WP plugins, development issues and More

$555 USD in 10 days
(19 Reviews)
4.2