inventory management with scanner google sheets

Рет қаралды 4,767

10 ай бұрын

In this comprehensive tutorial, we'll show you how to revolutionize your inventory management using a scanner and Google Sheets. Say goodbye to manual data entry and hello to streamlined inventory tracking!
🚀 Start optimizing your inventory management process today! Watch the video and transform the way you track and control your inventory with Google Sheets and a scanner.
Don't forget to like, subscribe, and hit the notification bell for more informative tutorials on productivity and tech solutions. Share your thoughts and questions in the comments section below-we're here to help you succeed!

Пікірлер: 17

@user-ej3ee8el1g 3 ай бұрын

Hello thanks for your helpful video. I have a question regarding the outbound quantity. I noticed there are minus sign prefix in your LogDB. Please could explain.

@excelhighway3549 3 ай бұрын

These lines indicate outbound delivery, the negative sign will reduce the inventory.

@isabellefeyfant7577 4 ай бұрын

I am started from scratch. Do I need to make a list first like you did? Do you have a video explaining everything from the beginning. As I say in my previous comment I am a novice and need some guidance. Thank you so very much! Could you tell me what to do first?

@excelhighway3549 4 ай бұрын

Yes, you should create the same sheets and formulas I used.

@isabellefeyfant7577 4 ай бұрын

Another question. In the number of row cell I get 1 instead of 0. Is it what you wrote =counta(A:A)-1 Thank you!

@excelhighway3549 4 ай бұрын

That cell should count the number of rows to copy, I wrote -1 to ignore the header line.

@isabellefeyfant7577 4 ай бұрын

I really love your video but I am completely new and it would be really helpful if you explain the sheets you created. For ex when I go to app script (following your video) I do not have anything on it. Am I supposed to copy everything that is on yours for barcode? Thank you so much for being patient with me.

@excelhighway3549 4 ай бұрын

Thank you for your feedback. Your app script will be empty the first time you open it. You should copy everything so it will work as expected.

@isabellefeyfant7577 4 ай бұрын

Thank you!!!

@suryakanth6962 5 ай бұрын

Hi there, this is genius. However, I’m trying to connect multiple wireless scanners to a Google Sheet and each scanner should populate into separate column, how do I attain this feat ? Thank you in advance.

@excelhighway3549 5 ай бұрын

Thanks, I'm not sure if the scanner can be identified. Are items scanned by each scanner different?

@Fabfliq 5 ай бұрын

can i get the excel template

@excelhighway3549 5 ай бұрын

The file is available on my Patreon page: www.patreon.com/ExcelHighway

@mcwhitby 3 ай бұрын

Hi, I copied all of your code, but it doesn't work properly. I've checked it over 10 times now, and I've definitely typed exactly the same code as you show on the screen here. It prompts me to input the barcode and quantity, but then I don't get any changes appearing in the field L2. Also, when I click on the buttons, it doesn't trigger the questions to input barcode and quantity, that only happens when I first open the file, but not again Any idea why it won't work?

@excelhighway3549 3 ай бұрын

I'm not sure. I'd be happy to share the file with you. Please subscribe to my newsletter : excelhighway.ck.page/landingpage I will share the file after that.

@mcwhitby 3 ай бұрын

@@excelhighway3549 Thanks so much! I just subscribed now. Matthew

@manvithareddy2742 23 күн бұрын

@@excelhighway3549 I too have the same issue, and even I have subscribed, can you please help me out