Creating Pricing Labels for Showroom

Creating Pricing Labels for Showroom
There are many integrated label printing applications that can be used to print labels for your showroom, but the process begins with making sure your A-J Pricing is set up in the system and then using the Excel export process from the Print Price List option to bring the data into Excel where it can be organized to export to any label printing software that integrates with Excel. Attached to this KBA is an article covering setting up A-J pricing in BMS. Below is the Print Price List screen (also covered in the attached). Ideally, you will click the Only Print Sample Items (pulls from Sample Size checkbox in Catalog Mtc.) to only get data on showroom items, and then the Only Print Items with a Price Change Since for pricing updates. You can determine which levels to export as well in the screen below.

1.png


Most label printers have software that integrates with Excel. This includes barcode printers. Using a 2" barcode label printer from BMS and the BarTender integration is the most advanced process. BarTender can also be used with Avery Design Online if you don't have the barcode printer.

Using a combo of Excel and Word, you can facilitate a mail merge using that data and then use any label application plugin, like Avery Design Online to design and print the labels. See this article for details: https://www.lifewire.com/make-labels-with-excel-4157653
Was this article helpful?
0 out of 0 found this helpful