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.

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.

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.

Thank you for sharing more details of your experience importing products and services in QuickBooks, @Pompaleau. Your efforts are greatly valued, and we appreciate your explanation as it provides important context to the situation. Let's find a solution to get everything back on track.

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. I also suggest clearing your browser's cache and cookies, as this can often resolve issues with web applications like QBO. Once done, retry the import process.

If the problem persists after trying these steps, I recommend contacting our Live Support team. They have specialized tools to address such issues, ensuring you receive the most appropriate and effective solution.

Here’s how:

1. Sign in to your QuickBooks account.
2. Click on the Help icon.  
3. Enter your concern and click Contact Us. 
4. Choose Chat or request a Callback from the next available expert.

For the most convenient support experience, please visit this guide to view our operating hours: Get Help with QuickBooks Products and Services.

Learning best practices for data import can streamline your workflow and make the process smoother. Feel free to review this article for detailed info: Common Questions about Importing Data to QuickBooks.

For future reference, here are some resources about recording customer payments and categorizing items, helping you maintain accurate and organized records:

• Recording Invoice Payments in QBO
• Group products and services into different categories in QBO

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!