cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
Kevin-Rodgers
Level 1

Does anyone know a way to set pricing brackets for a product based on amount ordered? Price Rules seems to be missing an IF condition or setting.

Example: <10 set price to $10 per item, 10-20 set price to $7.50 per item, 21-30 set price to $6.50 per item, >31 set price to $5.00 per item.
1 Comment 1
KenoLee_P
QuickBooks Team

Does anyone know a way to set pricing brackets for a product based on amount ordered? Price Rules seems to be missing an IF condition or setting.

Welcome to the QuickBooks Community, Kevin.

 

You can set up Price Rules based on quantity ranges; however, QuickBooks Online does not automate price changes dynamically based on tiers. Instead, you need to manually update them for each transaction.

 

Here’s how you can do it:

 

Step 1: Turn on Price Rules in Account and Settings

 

  1. Click on the gear icon and select Account and Settings.
  2. Navigate to the Sales tab.
  3. In the Products and Services section, click the Edit icon.
  4. Enable the Turn on Price Rules option.
  5. Click Save, then select Done.

 

Step 2: Create a Price Rule 

 

  1. Go to the gear icon and select All Lists.
  2. Choose Price Rules.
  3. Click Create a rule. After creating your first rule, select New Price Rule for additional rules.
  4. Give your rule a name.
  5. (Optional) Set the active period for the rule by entering the Start date and End date.
  6. By default, price rules apply to all customers. To make the rule specific to certain customers, use the Customer ▼, select Select Individually, and click + Add Customer.
  7. Price rules apply to all products and services by default. To restrict the rule to specific items, use the Products and services ▼ dropdown, select the applicable items, and fill in any required fields.
  8. Enter the adjusted price in the Products and Services section.
  9. Click Save or Save and Close.

Step 3: Apply the Price Rule to Transactions

 

After creating the Price Rule, you can apply it during transactions. To do this, simply select the correct rate that corresponds to the quantity from the Rate dropdown. 

 

By following these steps, you can implement customized pricing rules for specific quantity ranges while ensuring accuracy in your transactions.

 

If you have additional questions, feel free to reply on this thread.