Showing results for 
Search instead for 
Did you mean: 

Add or update prices in your price list

Learn how to update product prices in your price list using CSV files in QuickBooks Commerce.

If your price list has more than 1 variant, you can use a CSV template or your own CSV file to enter or update the prices all at once. Here’s how.

Step 1: Create or select a price list

Create a price list

If you don’t have one yet, you need to create a price list.

  1. Go to the Inventory menu, then select Price Lists
  2. Select Create New Price List
  3. Complete the price list details. For the type, select Sell for sales transactions and Buy for purchase order creation. 
  4. Select Create Price List.
  5. Select Proceed to Add Prices via CSV.

Select a price list

If you already have a list and want to update its prices, you can just select and open it. 

  1. Go to the Inventory menu, then select Price Lists.
  2. Select the price list you want to update.
  3. Select Update Price List via CSV.

Step 2: Create a CSV file

If you have a CSV file to upload, select Yes, I have a spreadsheet with updated price list ready for upload. Then, proceed to step 4.

If you don’t have a CSV file yet, you can use a template to update your prices.

  1. Select No, I need to download a template to fill in
  2. Select the Price Lists ▼ dropdown, then select the price list you want to update.
  3. Select the Product Attributes ▼ dropdown, then select the product details you want to show in the template.
  4. Select Build CSV Template, then select Download Product Sheet.

Step 3: Enter prices

  1. Open the CSV file. You can use Microsoft Excel or Google Sheets.
  2. In the last column, enter the prices for each product.
  3. Once you’re done, save it as a CSV file.

Step 4: Upload your price list

  1. In QuickBooks Commerce, select Upload Filled CSV.
  2. Find and select the CSV file, then select Upload.
  3. Check if the changes are all good, then select Yes, this is correct.
  4. Once it’s done, select View Price Lists.

If you set QuickBooks Commerce as the main source of your product details, it syncs the price updates to your sales channels as the default list.

Errors when you upload your updated price lists

Errors might appear when you upload your price lists using CSV files. QuickBooks lists the errors in the spreadsheet and lets you download the file to fix the errors.

  1. Select Download spreadsheet with errors
  2. Open the CSV file. You can use Microsoft Excel or Google Sheets.
  3. Make the necessary changes to the spreadsheet.
  4. Once you’re done, save the spreadsheet as a CSV file.
  5. Select re-upload the corrected spreadsheet.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up