cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
GeorgeR
Level 1

Can QR Codes be used for tracking Inventory in QB Online?

 
1 Comment 1
AlverMarkT
QuickBooks Team

Can QR Codes be used for tracking Inventory in QB Online?

There's indeed a great benefit in exploring modern inventory tracking methods, such as QR codes, to streamline your inventory process, @GeorgeR. I'd be glad to assist you with this.

As of now, QuickBooks Online (QBO) doesn't currently have a built-in feature for QR code scanning, but there are a couple of workarounds we can look on. I'll detail the information and steps below to accomplish either of them.

 

You can consider looking for a third-party application that integrates with QBO generating QR codes for your inventory items, scanning them, and automatically updating your stock levels in QBO. While I can't provide a specific name for an app, you can follow these steps to look for one:

 

  1. In your QBO account, go to Apps. Then, select Find apps.
  2. In the search box, type Inventory.
  3. Press Enter.
  4. Select an app and check out its Overview and Reviews.
    Reviews_thirdparty.png

 

Alternatively, consider maintaining a spreadsheet that maps each QR code to your items. For this, it's important to ensure that this spreadsheet is saved as a CSV file, as we will be importing it to QBO to update the quantity of your product and services on a weekly or daily basis, depending on your business needs and how often your stock changes. Here are the steps you can follow: 

 

  1. Export items if you've created them on the Products and services page. Update this spreadsheet on a daily or weekly basis.
  2. Go to the Gear icon.
  3. Select Import data
  4. Choose Products and Services.
  5. Hit Browse to upload the spreadsheet. 
  6. Map the fields to the QuickBooks fields. Then, click on Next
  7. Review inventory info. Then, scroll down and place a checkmark for Overwrite values for each product or service that you import with the identical name
  8. Hit Import.

    Import_inventory.png

For future reference, I'm adding this article about running inventory reports to get helpful insights on the things you buy and sell: Use reports to see your sales and inventory status.

 

With these information, you should be able to manage inventory tracking using QR codes in QBO. If you have more questions or clarifications about implementing it, we're here in the Community to help 24/7. Take care!