Inventory count with Magento and cobby

First open Inventory Scanner 2015, open Settings (1) in the group Dropbox choose Link Dropbox. Allow access from Inventory Scanner to your Dropbox (2).

It’s time to prepare our current inventory. First we load all Products into a new workbook with cobby. To be able to scan the products we need the sku, a barcode and the name of the product. A good idea is to order these columns directly behind each other in the AllProducts sheet. Save this layout as a preset for later use.

Now we set a filter on quantity so that only products with a stock greater than 0 are displayed. Mark the three attributes copy and paste them into a blank sheet. Finally we add the correct column headers before we save the file as CSV into our Dropbox.

To load the current inventory we start the Inventory Scanner App on our iPhone. Navigate to Import (3) > Data Import (4) > Import from Dropbox (5). Now we select the previously saved CSV file (6). A data import dialog shows up, change the option Master Data only to inactive (7) and start the import.

All preparations have been made and we are ready to count our inventory. In the group Inventories we choose Open. You’ll see an entry named Import followed by the current date tap on it. A list showing the current inventory is displayed, now tap on the camera icon to begin the scan.

Once all stocks are taken we choose Export > Upload to Dropbox (8) and the count is directly  transferred to Excel (9).

To update our stocks in Magento we first open the just exported list.

Now we start the Import mode of cobby. This is located in the extended Load products menu. To updates stocks we move the Quantity coulmn within the first attributset sheet beside the SKU column. All other attribute columns should be hidden. (By hiding these columns they are not transferred to Magento.) Now we copy the SKU and the counted stock from our inventory sheet and paste them into the first attributset sheet. As Website – Storeview we use the All Store Views value. Click Save products to update Magentos stocks.

In the final step the current inventory should be valuated for your accountant. A common valuation approach is to use the purchase price. To determine the current value of our goods we first Load products with cobby and add a new column valuation in the AllProducts sheet. In this column we add a formula that multiplies the Quantity with the purchase price. With the SUM formula we calculate the valuation of all our products. Now we hide the columns we don’t want to see and print the evaluation.