Price rules based on last cost vs current sales price

Hello, Bigtrace.

Given that you have thousands of items, I know it hasn't been simple for you to adjust the prices of your products to their current rates.

The Price Rules feature allows you to charge a different prices for different types of customers. The sales price is based on the current pricing if you haven't changed it yet.

I recommend changing item prices by importing products and services. This process saves you time since you no longer need to change it individually. You can export your items from your account to have a copy of them.

Here's how:

1. From the Gear icon, choose Products and Services.
2. Select the Filter icon, choose Inventory from the Type drop-down arrow, and choose Apply.
3. Click on the Export icon.

After that, change the pricing for each item and save the file to your computer. Once done, you can import the data. 

1. Click on the Gear icon and select Import Data.
2. Select Products and Services.
3. On the Import products and services page, select Browse.
4. Choose the file and click on Open.
5. Select Next and map your fields to QuickBooks fields.
6. Click on Next and ensure to check the Overwrite all values for each product or service that you import with the identical name. (This can’t be undone.) box.
7. Once done, hit Import.

Be aware that there is a limit of 1000 rows at a time; to successfully change all of the items' prices to their current values, split your file into two or three.

You can learn more about this process through this link: Import products and services into QuickBooks Online.

Refer to this article if you need to merge duplicate items or remove ones that are no longer necessary: Remove or merge a product or service.

Keep us posted if you need anything else. We're here to help. Have a great day.

The main point BigTrace stated was that the price rules would be great if they were based off of Cost not adjusting the last price... Quickbooks, how can we have our price rule based off cost? Curious if we delete the price from the item, if by default QB will base it off cost? I plan to do some testing, but your expert advice is always appreciated. 

Hello there, @kpngtrak.

Allow me to share some information on how sales price/rate and cost work in QuickBooks Online (QBO).

First off, with regard to @Bigtrace's concern, basing the price rule on the sales price of a product on a markup percentage of cost is currently available in QBO. With this, I'd recommend leaving feedback to notify our engineers about the feature. This way, they can consider adding it in future updates. 

Also, I'd like to clarify that cost is the product's price when you purchased it from the manufacturer while the sales price/rate is the amount you're selling the product for.

Referring to your question, even if we delete the sales price/rate of the product/item, QuickBoks will still follow the last sales price unless you've changed it. You can refer to this article on how to properly set up your items: Add product and service items in QBO.

Additionally, refer to this article to learn how to set up alerts for low or out-of-stock products in QBO Plus or Advanced: Get alerts for low or out-of-stock products.

I'll be right here if you need further assistance in managing your products and services in QBO. Be safe.

lThats too bad that QB does not provide the option to base price off a % of cost and allow that to be a rule. It really is the only logical solution. I look forward to the engineers working through this and sending updates, I am not sure my company will be able to wait as that could take years for them to catch up. We will probably migrate to a new system that is capable now. Thank you for your quick response.