top of page
Search

How to Bulk Update Prices in QuickBooks Online When Costs Change

Writer: The Pricing Assistant
The Pricing Assistant
Nov 5, 2025
5 min read

Updated: Nov 7

Promo graphic showing The Pricing Assistant and QuickBooks Online screens for bulk price updates, with checklist and laptop.

When supplier costs increase, your selling prices may need to change as well. For retailers, wholesalers, distributors, and other product-based businesses, keeping hundreds of product prices current can become a time-consuming task.


Updating products individually means repeating calculations, reviewing margins, and changing selling prices one item at a time.


This guide explains how to bulk update prices in QuickBooks Online when supplier costs increase, calculate revised selling prices, and update multiple products efficiently. Whether you manage pricing directly in QuickBooks Online or use a separate pricing tool, having a consistent process helps reduce manual work and protect profitability.


Whether you manage pricing directly in QuickBooks Online or use a separate pricing tool, having a consistent process helps reduce manual work and protect profitability.


1. Identify Which Product Costs Have Changed

Before changing selling prices, identify which products are affected by supplier cost increases.

Start by reviewing updated supplier price lists, purchase invoices, or other cost information. Compare the new costs against your existing product costs to determine which items need pricing adjustments.


Pay particular attention to:

  • Products with recent supplier cost increases.

  • Items with significant freight or shipping changes.

  • Products with outdated purchase costs.

  • SKUs with narrow profit margins.

  • Products that have not been repriced recently.


For businesses managing large product catalogs, even a relatively small cost increase can affect profitability across dozens or hundreds of products.

A spreadsheet can help organize this information, but the important part is keeping your product costs and selling prices current.


2. Calculate New Selling Prices Before Updating Your Products

Once you identify the affected products, determine what their new selling prices should be.

Simply increasing selling prices by the same percentage as supplier costs does not always preserve your desired profit margin.


There are two common ways to calculate selling prices.

Using a markup percentage Multiply the updated product cost by one plus your desired markup.


Formula:

Selling Price = Cost × (1 + Markup Percentage)

For example:

  • Updated product cost: $22.00

  • Desired markup: 40%

  • New selling price: $30.80


Using a target gross margin If you price based on gross margin, use a different calculation.

Formula:


Selling Price = Cost ÷ (1 − Target Margin)

For example:

  • Updated product cost: $22.00

  • Target gross margin: 40%

  • New selling price: $36.67


Markup and gross margin are not interchangeable. A 40% markup produces a different selling price and gross margin than a 40% target margin.


Choose the pricing method that matches your business objectives and apply it consistently across your products.


For additional information, see markup and markdown pricing.


3. Prepare Your Product Pricing Information

Before importing or updating product prices, organize your information so you can identify exactly which items need changes.

A typical product pricing spreadsheet should include:

SKU

Product

Current Cost

New Cost

Current Price

New Price

1001

Widget A

$20.00

$22.00

$33.33

$36.67

1002

Widget B

$15.00

$16.50

$25.00

$27.50

1003

Widget C

$40.00

$44.00

$66.67

$73.33

These examples assume a 40% target gross margin.


Organizing product information this way makes it easier to compare existing prices against updated costs and review the proposed selling prices.


Before making changes, check that:

  • Product names and SKUs match existing records.

  • Updated costs are accurate.

  • Selling price calculations are correct.

  • Required QuickBooks fields are included.

  • Only the products requiring changes are included in the update.


Keep a separate copy of your original product information before importing changes.


4. Import Updated Product Prices Into QuickBooks Online

How to Bulk Update Prices in QuickBooks Online


QuickBooks Online supports importing product and service information from Excel, CSV, and Google Sheets.


This provides a way to update multiple product records without manually opening every individual item.


Intuit is currently rolling out a newer batch-import interface, so the exact screens may differ between accounts.


The general process is:

Step 1: Open the import section

Sign in to QuickBooks Online.

Navigate to:

Settings → Import Data → Products and Services.

Step 2: Prepare your spreadsheet

Depending on your QuickBooks interface, you may see a new batch-import screen or the older file-upload interface.

Download the sample import file provided by QuickBooks and prepare your product information using its required column structure.

Step 3: Upload your spreadsheet

Select the appropriate CSV, Excel, or Google Sheets import option available in your account.

Follow the prompts to upload your product information.

Step 4: Map your product fields

Match the spreadsheet columns with the corresponding QuickBooks fields.

Pay particular attention to product identifiers and selling price fields.

Step 5: Review the overwrite option

When updating existing products, QuickBooks provides an option to overwrite existing product details.

Review the records carefully before selecting this option. Overwriting existing product information cannot be undone.

QuickBooks currently documents a limit of 1,000 rows per import, so larger product catalogs may need to be divided into separate files.


For the latest instructions, see Intuit's official guide:


5. Review Updated Prices and Profit Margins

After importing your changes, review the updated product information to make sure everything was applied correctly.

Do not assume that successfully importing a spreadsheet means every pricing calculation is correct.

Review several products from the updated list and compare their costs, selling prices, and resulting gross margins.


Pay particular attention to:

  • Products with the largest supplier cost increases.

  • Items with narrow profit margins.

  • Products with significant selling price adjustments.

  • Products with customer-specific or quantity-based pricing.


A selling price that looks reasonable may still produce an unacceptable profit margin.


Businesses using customer-specific pricing or volume discounts should also review those separate pricing arrangements when standard product costs change.


Maintaining consistent pricing rules helps prevent outdated prices and unexpected reductions in profitability.


6. Use Pricing Software to Simplify Recurring Bulk Updates

Importing spreadsheets can be useful when making occasional product price changes.

However, businesses that regularly manage hundreds or thousands of SKUs may find repeated spreadsheet preparation, pricing calculations, and manual reviews increasingly time-consuming.

The Pricing Assistant provides a dedicated workspace for managing product costs, selling prices, markups, markdowns, and bulk pricing calculations.


Features include:

  • Bulk Price Updates: Apply pricing changes across multiple products.

  • Markup and Markdown Automation: Recalculate selling prices using consistent pricing rules.

  • Cost Management: Review product costs and cost breakdowns.

  • Margin Visibility: Evaluate gross margin and gross profit calculations.

  • Margin Protection Alerts: Identify products with potential pricing and margin issues.

  • QuickBooks Online Integration: Optionally connect product pricing workflows with QuickBooks Online.


The Standard Plan includes core bulk pricing and margin visibility features.


The Plus Plan adds tier pricing, volume discounts, promotional pricing, and minimum margin and profit threshold management.


The Pricing Assistant can also be used independently without QuickBooks Online.


Final Thoughts

Supplier cost increases are a normal part of operating a product-based business. The challenge is making sure your selling prices keep pace without spending hours recalculating and updating individual products.


Start by identifying affected products, recalculating selling prices, reviewing gross margins, and updating your product records.


For businesses managing larger product catalogs or making frequent pricing adjustments, dedicated pricing software can simplify the process and reduce repetitive manual work.


The Pricing Assistant helps product-based businesses in the United States and Canada manage pricing, automate markup calculations, and maintain better visibility into profitability.


Price smarter. Protect profit.

 
 
 

Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
bottom of page