Transcript

What's up both doers? I'm armed with a barcode scanner and not afraid to use it. We just got these babies over here set up at Stealthy Wood and our products don't have barcodes yet. Barcodes help companies stay organized by giving employees the ability to quickly scan those barcodes to perform various functions in the warehouse like receiving, picking, packing, and more. So join me as we look into the ways that you can add bar codes to the products in your database so that you too can have a warehouse full of scannable products that are ready for. Barcode based efficiency O To get started, let's take inventory of what we already have going on inside of our database. Now you see what I did there. We're using these well, actually we're using all of these Nettum 1 deed USB scanners, and that means that I can scan linear barcodes if I have a device that I can plug a USB into which my laptop happens to be such a device. To learn more about choosing and setting up a barcode scanner, check out our barcode basics video that I'm going to link below. Now the barcode application which you see right here is installed when you install the inventory app up here. So chances are if you have products in your database already, you also probably also. Have the barcode application. We actually don't even need to activate anything in settings to start using barcodes. So first let's jump into the inventory application, and then we're going to select Configuration and Settings. We need one handy feature, so let's actually Scroll down over here to our barcode section, and we're going to take the box next to * Barcode stock barcode database, and we're going to save. So what does that do? Well, this lets ODU connect to a database and automatically fill in information about products that you scan that are using GS1 standard barcodes. Now, once the you save, we're ready to add our barcodes. If you have products that already have barcodes like this, sorry for the ASMR garden veggie straws. Well, you're actually in luck because we can use the barcode scanner over here to input them even from the inventory application. So I'm going to select products up at the top and then products once again. Now I could look up an item like one of my products that I want to add a barcode for, or I can click on one of these, but I'm going to show you a quick little nice visual shortcut slash timesaver. OK, so here we are on an empty. Product form Now I want you to remember a barcode scanner is secretly just a keyboard, which means I could use it to enter text into any field to know to so I'm going to click on this barcode field over here and you see what I'm getting at I'm just going to give this a quick scan Maroo, I'm going to do it without even looking at it. I had to odo not only added my barcode, but it also added this handy image, our actual product name, a price and all of this description for us. Now, of course, I could also type it in. With my actual keyboard, but who wants to do that when you have one of these? And with what you just saw me do, like that was a lot of time savings. If we are going to type in all of our barcodes, we probably won't want to do it one product form at a time. It's gonna take a long time no matter what. So to get a list of all my products with the barcode field over here at the top, I'm going to select configuration and then once again, settings. It's going to take a second to Lotus in right there because we're saving a brand new product. OK, now we're going to Scroll down once again to our barcode. Section and we're going to select Configure Product Barcodes over here. OK so now I have a tidy list of all my products with their reference properties which is where we hear it. Stealthy would have added our stock keeping units or SKU if I already had a barcode for this. Drawer over here, I could just click into here in the bar code section, scan the barcode and that would be that. And if I wanted to use official GTI and barcodes for the products that we have here at Stealthy Wood, we would need to register each product with the GS1 organization. ODU does not generate those on its own, but we're still a small operation here. So this internal reference that we have right there is where we put the product SKUs. We can use these as our barcodes as well if we wanted to. So to copy the reference. That we have over here for this. Drawer, if we're going to use it, we would just kind of highlight it right there and like that we have it in and now our drawer has a barcode. But wait, I can hear you guys asking me, Jose, is there a way for us to copy that reference over to all of the products barcodes all at once without having to do them one at a time? Why So doers, indeed there is. We can do that through the power of imports. So to get started with that, I'm going to select products up at the top and then products once again. Great. We have a Kanban view. We're going to go into list view and then we're going to select our nice little settings change icon over here. And we want to make sure we only have internal reference. Barcode selected and there's going to be a reason for that. I did that ahead of time. If you haven't do that. So once that we do all of this, we also want to filter out all the products that already have barcodes. So I'm going to select inside of our search field, add a custom filter where it says ID. We're going to start typing in BAR and select barcode. We're going to change this equal to is not set and we're going to select add some items disappeared. Why? Well, that's because now that we've done that, we have a list of only the products. The database that don't have a barcode value set. Now let's export this. I'm also gonna tick this box over here to the left of product name. It's going to select all of the items that we have. We have 4D selected here, as you could tell just by that. Now we're going to select their nice little actions button and select export. Nice little intimidating area. We also need ODU to update the correct products when we import our changes. So to do that, I'm going to tick the box in the top left here that says I want to update data. Now we need to have three things in our export and that happens to be the skews happen to be in the internal reference property. We also have the blank barcode property and the name property as we have over there so that we know what product we're updating. Lastly, I'm going to change my export format over here to CSV. Both formats will work, but this one is a little more versatile, so I'm going to use that. Then I'm gonna hit export to modify the values I need to use a spreadsheet program here. I'm actually using Google Sheets, but Microsoft Excel or LibreOffice Calc will work just as well. I'm going to select File, and then we're going to select Import over here. I've already gone ahead and uploaded it, so we don't really have to do much, but once they're inside of here, the very first thing we need to do is under import location. We're going to select Insert New sheet, import data, and away we go. I'm going to drag some of these columns to be a little bit more open, just so that our visibility is a little bit nicer. I don't like when they get cut off. A little bit more. Alright, perfect. Now that we're done with that, if we take a look over here at our first column, now the ID column is the identifier Odo uses to make sure we update our existing products with new barcodes. And instead of making new copies of all these products in the database over here where it says name, this column is our product names. And the default code that we happen to have over here is, well, that's the SKUs that we currently use for products. It was called internal reference when we were in ODU. Now in column B, well, this is where our barcodes. Don't go, which we can see is blank, and I could just copy and paste those over, but there's a more magical way in the first empty cell for barcode, let's type in equal. We're gonna click inside of default codes first empty one over here, and then we're going to hit enter. And what you look at that now we have this nice auto fill option and voila, just like that, all of our barcodes have been covered. Alright, now that we're done, we're actually going to select right here where it happens to say. Product, and then we're going to hit rename. We're going to name this one as. Barcodes. OK, now that makes it a little bit easier. And let's also rename our spreadsheet to make it easier. Healthy wood bar codes? No, that doesn't work for US products. OK, we're done with both. Now finally we can go download this. So let's go over to file and download. And we're going to download this one. This time again, a CSV. So back inside of ODU, I need to upload this file to make the changes. I'm going to select products up at the top and then products once again. I'm going to change the view over here to list view very quickly, and you'll see why in a second. Now we're going to select this gear icon next to products, and we're going to select import records. Now I'm gonna click the upload data file option over here and we're going to take. Our product bar codes that we have. Awesome. OK, so here ODU gives us a preview of how each column of the spreadsheet is going to get converted to a value in the Odoo database. Everything looks good to me, very cursory look. So I'm going to select import in the top left. And with that, our whole inventory has barcodes, as you could tell. There you have it outdoors, three different ways to give the products in your inventory their very own bar codes. I'm going to see you in the next video. Till then, keep scanning.