Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 13, 2024
Question

We need to increase the selling prices of 5000 or so stock items. Any ideas to speed this up?

  • February 13, 2024
  • 1 reply
  • 1 view
No text available

1 reply

Level 5
February 13, 2024

I appreciate you posting here in the Community.

 

I'm here to provide the steps to ensure you can increase the selling price of stock items in QuickBooks Online (QBO).

 

We can update the selling price by exporting the product and services changing the pricing and importing it back to QBO. However, since you've mentioned that it'll be 5000 items, you might need to split it into a multiple Excel file since the limitation is only 1000 rows.

 

Here's how:

 

  1. Go to Sales.
  2. Choose Products and Services.
  3. Click the Export icon to export the Products and Services to Excel.
     

Once done, you can edit the pricing to Excel and import it to QBO.

 

  1. Go to Sales.
  2. Click Products and Services.
  3. Hit the drop-down arrow beside the New tab and choose Import.

 

Also, you can create and define each specific item price you charge or sell to your customers. For detailed information, I suggest following this article on how to add products and services, track the items you sell, as well as how to edit them: Mange Products and Services List.

 

In addition to that, I'll be sharing this link to help manually apply a discount to one or more items on your sales forms: Add a discount to an invoice or sales receipt in QuickBooks Online.

 

Fill me in if you have other questions about managing your stock items in QuickBooks. I'll be happy to help again. Stay safe!