Scenario - I have about 160 product codes that I need to update the sales price for - how can i do a bulk update please?
Solved! Go to Solution.
Hi there, Jane. I'd be glad to share some information about how products and services work in QuickBooks Online and offer some steps so we can achieve your goal which is to bulk-edit the sales price of your products.
For now, we can only update a product's sales price in QuickBooks Online individually. However, you don't have to worry as we can bypass the process in two ways. First is to export your products, updating the price outside QuickBooks then importing it back. I've included the process for you:
Next, revise the cost of each item and store the file on your computer. Once completed, you can proceed to import the data.
Another option is to make use of the price rules functionality, which allows you to specify a percentage (either decrease or increase) for any or all of your products and services. However, it is important to keep in mind that applying a price rule will not update the sales price of your products on the Products and Services page unless you create a transaction. For more information about this, feel free to check out this article: Set price rules in QuickBooks Online.
Should you have additional questions about managing your products and services in QuickBooks Online, please don't hesitate to reply to this post. I'll be willing to lend a hand. Have a wonderful day.
Hi there, Jane. I'd be glad to share some information about how products and services work in QuickBooks Online and offer some steps so we can achieve your goal which is to bulk-edit the sales price of your products.
For now, we can only update a product's sales price in QuickBooks Online individually. However, you don't have to worry as we can bypass the process in two ways. First is to export your products, updating the price outside QuickBooks then importing it back. I've included the process for you:
Next, revise the cost of each item and store the file on your computer. Once completed, you can proceed to import the data.
Another option is to make use of the price rules functionality, which allows you to specify a percentage (either decrease or increase) for any or all of your products and services. However, it is important to keep in mind that applying a price rule will not update the sales price of your products on the Products and Services page unless you create a transaction. For more information about this, feel free to check out this article: Set price rules in QuickBooks Online.
Should you have additional questions about managing your products and services in QuickBooks Online, please don't hesitate to reply to this post. I'll be willing to lend a hand. Have a wonderful day.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here