Skip to main content
June 2, 2025
Question

Updating product prices in bulk

  • June 2, 2025
  • 1 reply
  • 0 views

Hi,

 

I need to update prices on 1500+ products and I'm facing issues with the up-loader tool.

I followed the instructions :
-export to excel file

-edit priced in said excel file

-upload said excel file with updated price (nothing else changed)

-made sure to click on the overwrite data box

 

Now half or so of my products updated correctly, however the rest created duplicates and they didn't update the matching existing product with the same product name and UGS (see attached screenshot).

 

I feel like this might be an error in the back endcode... In any case, I obviously need my products to update correctly as I am losing money daily till I get these updated.

 

Please let me know if there's a way for me to fix this.

 

Thank you.

1 reply

MsNorthPND18
June 2, 2025

Based on your screenshot, it seems that the duplicates are the prices but the names of each product are different, @Pompaleau.

 

You can review the items for duplicates. If duplicates exist, you can make those you no longer use inactive without permanently deleting them. This approach helps you preserve important information and avoid mistakes.

 

Here's how:

 

  1. Navigate to Settings by clicking the Gear icon, and then select Products & Services.
  2. Choose the items you wish to make inactive.
  3. From the Batch Actions dropdown, select Make Inactive.
  4. Click Yes to confirm.

 

 

I'm adding this information about ales transactions, like invoices, which are created through the sales section, while expenses are recorded by creating a new expense: Enter and manage expenses in QuickBooks Online.

 

Then, here's how you can use reports to see your sales and inventory status, your best sellers, the cost of goods, and more. 

 

If you have any further questions about updating your item prices in QBO, please don't hesitate to let me know. I am here to assist you further.