How to import an inventory count that was done outside of Vend


Latest update: - Lucia Palozzi

Objective

Adjust your inventory after an inventory count was done outside of Vend, or on the Scanner app without being logged in.  

Setup

  • Vend for Mac or PC
  • Open Office 

Steps

  1. In Vend, export your product list
  2. In Sheet 2 next to your product list, paste the your inventory count
  3. On the inventory count sheet, make sure you have two columns: SKU and quantity, in that order
  4. On your product sheet, insert this formula into the inventory column for the outlet you want to adjust: =VLOOKUP(C2;Sheet2.A$2:B$500;2;0). Change '500' to the total number of rows in your inventory sheet
  5. In the inventory column, you should now have the quantity for each SKU from your count. If any cells say N/A, this is because the SKU was not in your inventory count sheet
  6. If you do not want to change the inventory for products you did not count, remove them from the product list sheet
  7. If you want to bring the inventory to 0 for products you did not count, replace each 'N/A' with '0'
  8. Save the file as a .csv file
  9. In Vend, import your product list