How to add retail price to inventory on hand report?


Latest update: - Brendan

Question

How to add retail price to inventory on hand report by exporting and using a VLOOKUP formula?

Setup

  • Vend for Mac or PC
  • Excel, Open Office or Google Sheets

Steps

Inventory On Hand Report

  1. Click Reporting > Inventory Reporting > Inventory On Hand
  2. Click desired date
  3. Click drop down in the table and click SKU
  4. Click Export Data

Product Report

  1. Click Products in the Side Navigation
  2. Export Product List

Add retail price

  1. Open both reports
  2. Add a column to Inventory On Hand Report called "Retail Price"
  3. Delete everything on the Product CSV leaving only SKU and Retail Price
  4. Import this file as a second sheet on the Inventory CSV
  5. In the "Retail Price" column use a VLOOKUP formula to reference SKU and return retail_price from the exported product list
  6. Apply formula to all rows
  7. Copy all formulated data and paste values in cells

 

 

 

Powered by Zendesk