Any easy way to print thousands of barcodes?

I am opening a new store and I need to print barcodes for everything. I have about 20,000 items in the database and I expect to print barcodes for 2,000. There are too many unused items to print all items in database and too many items to individually add each to the list. Is there any easy way to accomplish this?

Reply to
Tony McLaughlin
Loading thread data ...

Go to each item that you do not want to print. In the Items Note [in theSpecial Tab] place a unique entry like "discontinue"

Then go to the Wizards ==> Label Wizards ==> Select the last option called print from Filter In the Label Filter select the Item notes that contain "discontinue" - and also mark the option that says negate and add

This will then give you the list of all items that do not have "discontinue" to print the labels. Hope this helps

Afshin Alikhani - [ afshin:@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = "Tony McLaughlin" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Afshin Alikhani

I think his problem is there's just too many items for a manual entry.

If you're not using subdescription 1-3, you may want to use these fields temporarily for filtering purposes in the label wizard;

go to administrator and run the following query

UPDATE ITEM SET subdescription3 = 'is' WHERE quantity 0

this will add the words "is" (in stock") into the subdescription 3 field of all items that have a quantity other than zero; then go to the label wizard, select the bottom option (print labels for items that satisfy the following filter) - create a filter that reads subdescription3 equals is - then ADD ALL, select STOCK ON HAND, then SET QUANTITY - the qty of tags to print should match your On Hand Qties;

BACKUP FIRST...!

"Afsh> Go to each item that you do not want to print. In the Items Note [in

Reply to
convoluted

Reply to
Tony McLaughlin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.