Almost every product we buy these days has a barcode attached to it. For retailers and manufacturers, it's an easy way of keeping track of what's been sold and what needs to be re-ordered. What, then, do you do if you make your own products? Do you use a barcode or a QR code? How do you get barcodes? How do you batch generate QR codes? What interface can you use when you're out and about to scan the barcode or QR code and have it update your stock levels? And can all this be done on a budget?
Barcode or QR code, that is the question
A quick Google search and it didn't take me long to discover that the barcode route was going to cost. EAN and UPC barcodes consist of a series of numbers, 5 of which identify the manufacturer, the
rest identify the product. Scannable barcodes, it seems, need to be authorised by GS1 in the UK, as they need to be on a central database and this, of course, incurs an annual subscription fee. The QR code route, however, was a lot more appealing. QR codes can hold a lot more information than the humble barcode for a start, and a QR code is a lot more accessible when it comes to generating one. But what happens if you have several hundred products that need identifying? How do you go about creating a unique QR code for each and every product?
QR code plus Google chart API equals streamlined spreadsheet stock control
There are an increasing number of websites that allow you to generate a QR code for yourself or your business. QR codes are often used on promotional flyers, business cards and posters, but when it comes to batch generating 400 or so QR codes, individual generation using one of these websites would be a very time consuming proposition indeed. A bit more research led to the Google chart API, which is, essentially, a URL that you can add to the end of to create different QR code images. With very little experience of APIs and whether what I wanted to do was possible, it was clear that I needed help at this stage, so I put a call out on Facebook. After a few emails backwards and forward, Karl, a former financial trader and Excel expert, came up with a solution.
I'd found an Android app called Inventory Droid that I'd used as a base for a spreadsheet. Inventory Droid allowed me to download a csv which listed the name, category, brand, location, cost, retail cost, quantity, UPC and date entered into stock of all the items that I'd manually entered into the app. Of course, at this stage, as I didn't have the UPC, I was unable to use the full functionality of the Inventory Droid app, which would have allowed me to scan the products and adjust the stock levels as I sold or made them. From this csv, Karl created a formula in a spreadsheet that joined the name (including the size, colour etc) and category of the product to a URL that related to my website. This URL was then added to the Google chart API.
Another column of the spreadsheet used a formula to add the html for "image source" to the full URL so that this column could be uploaded to a website. The QR code images could then be saved, along with their name and category in text as a title of the image.
Although this latter stage involved a fair amount of right click, save as, I soon got into the swing of it, and I discovered I could used keyboard shortcuts with one hand and the mouse with the other hand. As a result, I now have over 400 QR codes, that relate to the items I make, in a folder on my desktop ready for cardboard tags to go on freshly made garments.
Importing the information into the Inventory Droid app to make QR code stock control possible
Now that all the stock was tagged with QR codes, it was a case of importing the csv from the spreadsheet back into the app on my Android phone, including the QR codes in the UPC column. And this is where I got stuck again,
with an error message coming up when I scanned my first item and the app wanting to force quit. I emailed the developer of Inventory Droid, sending him my csv and what had happened. He got back to me within a couple of hours and, after a few emails, we'd sorted the problem out.
I can now scan an item when I sell it and, with a touch of a button, move it from "In Stock" to "Sold". Using the same technique, I can increase the number of a particular item I have in stock when I make a new garment. I can check whether I have something in stock when I'm away from the stock room. And I can download the csv from both "In Stock" and "Sold" to add to my accounts. The cost? A bit of time, some tags, inkjet labels, and £3.04 for the app.
(Just a little word of advice, though - make sure you leave out the commas and apostrophes from the URLs!)