Find Products using Barcodes

Use the UPC field when doing a find.

How to Find a Product using a Barcode

If you create a new product item in the Products file, then FrameReady automatically generates a new Item #.

If your retail product Item # is different from the UPC number (i.e. barcode), then you can change the item number by typing over it and entering the number you want to use. Then click in the UPC field and scan the barcode into it.

  1. On the Main Menu, in the Products section, click the Find Product button.

    The Enter Search Criteria screen appears with the cursor blinking in the Item/UPC field.

  2. Scan the barcode from the retail product into the UPC field.

  3. If no a match is found, then click Modify Find and scan the barcode in the Item field.

Tip: products can be added onto an Invoice using either the UPC number or the Item number.

When searching for a product, use the Item field to find an item # and the UPC field to find a barcode.

FrameReady Cannot Find a Barcode

If the barcode you scan is not in the Price Codes file, then a "No match can be found for this…" message appears on the Work Order.

  1. Click Revert Field then use the search button instead and enter the first few digits of the number.

  2. To resolve the missing barcode, go to the Price Codes file and perform a Find for the item using the number, e.g.  C1610  and then check the number in the UPC field.

  3. If the UPC field is blank, then put the cursor into the UPC field and scan the barcode number into it.

  4. If the UPC field contains a number, then make sure the barcode number in FrameReady matches the printed one. If not, then clear the UPC field and go to Step 3.

Note: the UPC field is not affected by vendor updates; if you change the barcode number, updating your vendors will not revert the field back to the original barcode (unless you use the Control key + Proceed button method).

The Barcode Shows the Wrong Item

If the barcode you scan onto a Work Order shows the incorrect item, then follow these steps:

  1. Search the Price Codes file for the UPC number and make sure that only one item is using that number.

    Are there multiple items using the same number?

  2. Search the Price Codes file for the correct item and then examine the UPC field.

    Does the UPC field match the barcode number on the sample?

  3. Open a generic text editor, click the cursor into it and scan the barcode; a series of numbers should appear.

    Do the scanned-in numbers exactly match the sample's number?

Cannot Find Barcode Number on a Corner Sample

If the UPC field is blank in FrameReady, but the sample has a manufacturer’s barcode attached, then you can scan in the barcode for that item.

  1. In the Price Codes file, do a Find for the item (by Item #).

  2. Click into the UPC field.

  3. Scan or type the barcode number from the back of the corner sample into the UPC field.

    Now you can either enter the moulding # or UPC number into on the Work Order. This method works for both moulding and matboard.

OR…

  • If there are a large number of records with blank UPC fields, then you may want to consider another method. UPC are entered automatically for new moulding/mats when you perform a vendor update (where applicable, see below for vendors that include UPC data). If the item is already in your file, then the UPC code will not be updated.

  • If you delete the records which do not contain UPC codes and then perform the update, the UPC code field will be updated. This option would not be advisable if you have inventory in stock for the items.

Vendors who Supply UPC Data

Subject to change:

  • Bainbridge

  • Crescent

  • Larson Juhl

  • Ludwidg

  • Nielsen

  • Nurre Caxton

  • Omega

  • Peterboro

  • Roma

 

© 2023 Adatasol, Inc.