Completed

inventory project

Hi there, my project is trying to save time on my inventory file. Currently once a week i add my stock order (additions) to my inventory, i then deduct all the items we have used for that week (deductions) from the inventory. to do this currently i just use ctrl f to find the relevant sku in the inventory then manually add or deduct the number received / used and then move to the next line of either the additions or deductions depending on which i am doing. so for the first line of additions sku - 4931465388, we have received 37, i then look up this sku in inventory to find a qty of 68 i then add 37 to this making it 105. Later i would run through deductions and find that sku 4931465388 has been used 32 times so deduct this from 105 making it 73 this is then our current stock level.

as you can imagine this is extremely time consuming and i am sure there must be a formula that could be written to do this automatically.

our inventory is kept in google sheets but can obviousy be moved to excel etc for the purpose of this.

I have attached a copy an example file for all i have spoken about above, really hope someone can help.

Kind regards

James

Skills: PHP, Excel, Data Entry, Software Architecture, Data Processing

About the Client:
( 1 review ) minster, United Kingdom

Project ID: #34029110

Awarded to:

(96 Reviews)
6.2

19 freelancers are bidding on average £559 for this job

(627 Reviews)
8.6
(23 Reviews)
7.6
suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp More

£300 GBP in 7 days
(107 Reviews)
7.0
ARTICLEYOUWANT

Hi, I have seen your project details for inventory project and completely understand the requirements. Kindly, award me this project so that we can discuss it briefly and start working.

£120 GBP in 5 days
(51 Reviews)
5.7
hamidr2020

Hello James, I am an Excel expert. I offer my services to help to automate this time consuming inventory file job. We can discuss further details over chat. You can check my reviews for quality of work and client satis More

£70 GBP in 1 day
(63 Reviews)
5.5
miroljubdjordje4

Hello, How are you? I have gone through your project requirement carefully and I am definitely sure that I am exactly confident to finish this project successfully. I am software engineer and also have ever used a lot More

£135 GBP in 1 day
(7 Reviews)
4.8
rabbiawebjuggler

Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!

£135 GBP in 1 day
(12 Reviews)
4.1
bhardwaj202

Hi there, Greetings❤️ I have read your project details that you need to design inventory project. Can we talk regarding this project and Thanks for the details and clear instructions. Much appreciated 150+ Projects D More

£250 GBP in 7 days
(11 Reviews)
4.3
(32 Reviews)
4.2
DominikKrivarics

Hi cjstechnical, I can help you with this project. What's your budget? BR, Dominik

£100 GBP in 2 days
(6 Reviews)
3.0
designertechpand

Hi There,✔ Warm Welcome Tell me more ? I can start right away and complete your project successfully. I am a Senior Full-Stack developer with over 8 years of experience . I specialize in Front-End and Back-End web dev More

£135 GBP in 7 days
(2 Reviews)
2.2
Infoneo

Dear Client, I hope you are doing well. I have seen your job requirement and found that you need someone who can do your task as per your given project detail. We have a skilled team of developers who can do this task More

£1035 GBP in 22 days
(2 Reviews)
1.8
jklh8

I can gurantee for good product. Hey I'm interested in your project, I have read out your requirements. We have 5+ years experience .We have worked on similar Projects to What You are Looking for. We Have A Variety of More

£135 GBP in 7 days
(0 Reviews)
0.0
jake66405

MASTERS IN COMPUTER SCIENCE AND SOFTWARE ARCHITECTURE Hi there, I’m a computer science, software architecture expert and I also specialize in workflow optimization and process automation. I will automate your excel o More

£350 GBP in 7 days
(0 Reviews)
0.0
Ili96

Hi, I'm able to do this task because I'm:- - Fast in copy pasting - Able to complete task based on clients time - Easy to discuss - Fast in typing

£100 GBP in 3 days
(0 Reviews)
0.0
vishalgupta40

i am expert in typing accuracy . and i will work faster. i need hire your work for my experience .

£228 GBP in 7 days
(0 Reviews)
0.0
wavesiyaram

Hey, I am an Excel expert. I offer my services to help to automate this time consuming inventory file job. We can discuss further details over chat. You can check my reviews for quality of work and client satisfaction. More

£20 GBP in 1 day
(0 Reviews)
0.0
mganhouegnon

I have read your job description and I'm interested to work with you. I am glad to inform you that we have a strong 5+ years of quality experience in Website and App Development. I do have the necessary skill set & res More

£155 GBP in 7 days
(0 Reviews)
0.0