Hi, On Sun, Mar 8, 2015 at 9:31 PM, Riley Childs <rchilds@cucawarriors.com> wrote:
Is there a way to add a standard item price to all items? All of our items currently list $0.00, we would like them all to reflect a price of $20.
Yes there is. I understand you want to set the price of all items for all bibliographic records as $20. 1/ Generate a list of all the item barcodes and save the list as a text file The following SQL will get you there : SELECT items.barcode FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) 2/ Use the "Item batch modification" tool under Tools menu and load up the file with list of all barcodes that you wish to set to $20. Follow the wizard. It is self-explanatory. hope this helps -idg -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org