Are you still, entering your product SKUs manually in QuickBooks Commerce? QuickBooks has the feature of using bar code, during the time of creating a purchase or sales order. If you are not aware of this then read the article. In this article, we will discuss, how to create, and use barcodes in QuickBooks Commerce.
QuickBooks commerce barcode scanner is one of the most useful functions, by which we can easily scan any of the product details, and can analyze the sales transactions in a short time. You need a printer, scanner to generate barcodes.
How to Set Up barcode in QuickBooks Commerce
Follow the steps mentioned below to set up the bar code in QuickBooks for commerce.
Manual way to Create Barcodes in QuickBooks
QuickBooks has the option of adding or creating barcodes manually, in the case of a single product. So follow the procedure, if you want to add a single product;
- Go to the Inventory tab.
- Click Variants.
- Check and Click the variant your choice for assigning a barcode.
- In the Barcode field, enter a barcode number. (The recommended format is EAN13/UPC barcodes.)
- Select Save changes.
How to Add or Update Barcodes in Bulk
If you have multiple products and you need to add barcodes at once, then you can edit them in a .csv file and can upload them into QuickBooks. There are 3 ways to update barcodes in bulk for the existing products. read the following to know the ways;
Way 1: Update Barcode Individually
For an individual existing product, you can update the barcode, by following the below procedure;
- First, visit the Inventory.
- Click on Products.
- Select the product and variant you like to edit
- Under Variant Details, update the Barcode field.
Way 2: Update Barcode in Bulk Action
For multiple existing products, you can update the barcode in this bulk action method;
- In QuickBooks Commerce, Go to Inventory.
- Click on the Product
- Select the products you want to edit.
- Click Bulk Action.
- Open in Bulk Editor
- Click on Edit Columns and choose Barcode (UPC, GTIN, etc).
- Now start updating the Barcodes as your preference.
Way 3: Update Barcode Using CSV
Follow the procedure to update the barcode in the CSV method;
- In QuickBooks Commerce, visit Inventory.
- Select the products you need to replace
- Click on Bulk Manage.
- Update Existing Products
- Choose “No, I need to download a list of my products”.
- Choose Barcode (UPC, GTIN, etc) as the Product entities to update.
- Click on “Build Product Sheet”.
- Choose Barcode (UPC, GTIN, etc) as the Product entities to update.
- Click on “Build Product Sheet”.
- Upload the entire spreadsheet.
- Then follow the steps in updating products via CSV.
Use Barcodes for QuickBooks commerce
QuickBooks commerce support barcodes in both web, and mobile app. It needs a 6-digit barcode number to start running in different commerce.
Here are some of the ways to use barcodes in Quickbooks commerce:
- Scan items onto Sales & Purchase Orders
- Pack Sales Orders
- New Stock Transfers
- Search Products by Barcode
- Barcode Printing
- Perform a Stocktake
Start using the barcode scanner
To start the barcode scanner for the first time, follow the below procedure;
- Open a transaction in the QuickBooks Desktop.
- Scan the object using a barcode scanner connected to your computer. The item will appear in the transaction as a new item.
You can scan barcodes to fill out any of these transactions:
- Estimates
- Sales Orders
- Invoices
- Sales Receipts
- Refunds & Credits
- Purchase Orders
- Item Receipts
- Bills
- Write Checks
- Inventory transfers
It’s all about the QuickBooks Commerce barcode. Hopefully, this proves to be helpful for you. If you need further assistance then, feel free to dial our toll-free number +1-844-405-0904 to talk directly with our team of experts.