cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Pompaleau
Level 1

Updating product prices in bulk

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.

3 Comments 3
MsNorthPND18
QuickBooks Team

Updating product prices in bulk

You're on the right track with importing products and services, Pompaleau. However, it's important to note that QuickBooks Online can handle only up to 1000 rows of data at a time.

 

This could be the reason why only half of your items were updated.

 

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

 

image.png

 

Once done, I recommend splitting your spreadsheet into smaller files and importing them separately. Make sure that the names are correct and do not include the items that are already updated.

 

You can also 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 us know. We're here to assist you further.

Pompaleau
Level 1

Updating product prices in bulk

Hi,

 

thank you for your reply.

 

I did import my products in small batches of ~500 products per file and I know for a fact that all 

my products have their respective matching product names.

 

Also I had already made all the duplicates inactive.

 

Pretty sure the issue is with QB..

 

Please advise further instructions.

 

Thank you.

AdonL
QuickBooks Team

Updating product prices in bulk

Thank you for sharing more details of your experience importing products and services in QuickBooks, @Pompaleau. Your explanation is greatly appreciated, as it provides valuable context to the situation. Let's find a solution to get everything back on track. We're in this together!

 

If you haven’t already, I recommend importing a smaller batch of products (for example, 100-200) to see if the issue persists. This step can help identify whether specific products are causing the issue or if there's a broader problem with the import process.

 

Additionally, I suggest clearing your browser's cache and cookies, as this can often resolve issues with web applications like QuickBooks Online (QBO). Once done, retry the import process.

 

If the problem persists after trying these steps, I strongly recommend contacting the QuickBooks Live Support team. They can address complex issues that may be beyond the scope of community assistance, ensuring you receive the most appropriate and effective solution.

 

Here’s how to connect with our live expert:

 

  1. Sign in to your QuickBooks account.
  2. Click on the Help icon.
  3. Enter your concern and click Contact Us.
  4. Choose your preferred method of connection:
  • Start a Chat with a support expert.
  • Request a Callback from the next available expert.

 

To ensure you connect at the best times, please check this link for their support hours: Get help with QuickBooks products and services.

 

For detailed info, feel free to review this article: Common questions about importing data to QuickBooks.

 

Moreover, I will share these resources that will assist you in recording customer payments and categorizing your items to maintain organized records:

 

 

I want to see you succeed with QBO, and my goal is to support you as you navigate this process, @Pompaleau. If you encounter any further errors or challenges importing products and services in QBO, please leave a comment below. We're always here to help you!

Need to get in touch?

Contact us