Product Management
      Back to home
      1. BeerBoard Knowledge Base
      2. Bars and Restaurants
      3. Product Management

      Import/Export PLU Prices

      How to pull Import/Export PLU Prices excel in SmartBar

      Export PLU Prices spreadsheet


      • Click Import/Export PLU Prices button
      • Click Download button to export Beer, Liquor, and Wine products in your inventory to view all PLU and prices associated with a product

      If you are pulling this report for larger concepts with 20 or more locations, the file will be too big to export. It will take some time to generate and the report will be sent to the email address on file.

      • Open the excel to view the export
      • PLU and price columns can be located to the right of the export

      If PLU and/or prices are missing in Product Management, this report will show those missing items. Prices will show as "0" and missing PLU will be blank in this export.

      Add new products

      Products can be added to the spreadsheet for Import

      Do not delete an columns (vertical) from this spreadsheet if there are intentions to upload any updates.


      • Store number, Division and Location can be copy/pasted from the location you want to add new products. Store information must already be in SmartBar to add new products.
      • Select Product Type from the dropdown in the spreadsheet to match the product that is being added - Draft Beer, Bottle Beer, Liquor, Wine

      • Size and corresponding Ounces should match what is already available in SmartBar. If new size is needed, that must be added in SmartBar first.
      • Add PLU
      • Add Price

      Import PLU Prices spreadsheet

      • PLUs and/or Prices can be added or updated for bulk updating using this spreadsheet
      • Update the cells for the corresponding products to be updated
      • Click save in the Excel spreadsheet on your desktop device
      • Click Import/Export PLU Prices button
      • Click Choose File to import
      • Select your file from the folder on your desktop device where your excel was saved & click Open
      • Once the correct file is attached, click Upload
      • When upload is accepted, a success message will appear in the upper right hand corner
      • You will receive a notification to the email address on file when the upload is complete



      Note: Rows (horizontal) can be deleted from the spreadsheet but this will not delete products, PLUs, or prices when uploaded