Skip to main content
L
Lisalewisgale1
January 23, 2024
Question

Barcode Scanning

  • January 23, 2024
  • 1 reply
  • 0 views

Hi All

 

I have scanned barcodes on all my warehouse products that have barcodes on them into QB desktop Enterprise but l need QBs to make up barcodes for the rest of my items that don't have barcodes. If I ask qb to make the rest in the barcode wizard, will it wipe the barcodes that I have already scanned and replace it with QB's own barcodes?

1 reply

R
RCV
January 23, 2024

Thanks for checking in with us, Lisalewisgale1.

 

The best thing we can do in the Barcode Scanning Setup wizard is to select which item field you want to use for barcode tracking. If you’re not sure what to use, choose a field that will be unique for each item, such as the Item Name or Part Number. Here's how:

 

  1. In QuickBooks Desktop, go to the Edit menu and select Preferences.
  2. Choose Items and Inventory, then select the Company Preferences tab.
  3. Click Advanced Inventory Settings, then choose the Barcodes tab.
  4. Select Enable Barcode, then Open Barcode Wizard.
  5. In the Barcode Scanning Setup wizard, choose which item field you want to use for barcode tracking. If you’re not sure what to use, choose a field that will be unique for each item, such as the Item Name or Part Number. Then Next.
  6. Choose the types of items you want to generate barcodes for. The Next, then press Finish.

 

Since you already have a list of barcodes you've used, we can import them into QuickBooks Desktop. You need admin access to do this and it's always a good idea to back up your company file before you import. Just follow the steps and details in this article: Set up and use barcode scanning in QuickBooks Desktop. Then, go to How to import barcodes section. 

 

Feel free to visit these articles for more details about managing barcodes and warehouse on your business: These recommended articles are a good reference:

 

 

You're more than welcome to drop by if you have questions about managing your inventory. Do you need to run some payroll reports for the next current period? Or would you like to take care of taxes in QuickBooks? Let me know and I'll lend a hand again.

L
Lisalewisgale1Author
January 24, 2024

Hi

 

Thank you for your reply so to be clear turning on barcode wizard now will override barcodes I already have in the system and I will need import them?

R
rvrfrf
January 24, 2024

Thanks for following up with the Community, Lisalewisgale1.
 

When importing your list of barcodes from Excel, you can have up to 12 custom fields. If you're already using all of them, you'll have to replace one of the existing fields. In our Set up & use barcode scanning article, in Step 1 for importing barcodes shows an example with "Barcode 2" being used. When you reach step 4 and select Replace existing data with import data, ignoring blank fields, all existing items will be updated with the new values.
 

After following RCV's steps to set up your USB barcode scanner, you can begin importing barcodes by creating a custom field if you want to track additional items.
 

Here's how:
 

  1. In the top menu bar, go to File, then Switch to Single-user Mode.
  2. Use your Lists drop-down in the top menu and click Item List.
  3. Double-click an item, then hit Custom Fields.
  4. Select Define Fields. On a new line, enter a label name. For this example, I'll use "Barcode 2".
  5. In your Label field, select Use, then OK.

 

Next, you'll need to export your item list to Excel and edit it.
 

Please don't hesitate to send a reply if there's any additional questions. Have an awesome Wednesday!

Terms & ConditionsAccessibility statement