Price List Update

Hi there, @HollyNorth2021.

Thanks for visiting the Community today. I'd be glad to walk you through updating your price list. 

In QuickBooks, you can update companies with large inventory lists provided by a few vendors using an .IIF from your vendor. You can do this by importing the updated file into your company file to record the changes. However, this will erase the existing fields that you didn't update.

First off, we'll have to use the Add/Edit Multiple List Entries options. You can also copy your data from Excel then paste it into the Add/Edit Multiple List Entries window to expedite the process. 

Here's how:

1. Go to the List menu, then choose Add/Edit Multiple List Entries.
2. Click the List drop-down arrow, then select the list that you want to update.
3. Choose in any field and begin making changes, then copy (Ctrl+C) the data from Excel then paste (Ctrl+V) it into the Add/Edit Multiple List Entries window.
4. To copy the data in a specific field to the remaining records, simply highlight the desired field and right-click then choose Copy Down. If data is in any of those remaining fields, it will be overwritten.
5. To duplicate a row simply place your cursor in any row, right-click and choose Duplicate Row. The record is duplicated into the next row and is preceded with the word "DUP."
6. Click Save Changes when you're done.

Here's an article that will help you learn in case you'll need to track where your company stands in terms of expenses and accounts payable: Customize your vendor reports.

I'm always around here if you need help with anything else. Take care!

@HollyNorth2021 

Another option, prepare your Item List data with the following template

then utilize one of these importer tool

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

Hi there, @HollyNorth2021.

Hope you’re doing great. I wanted to see how everything is going about updating your price list concerns you had yesterday. Was it resolved?

Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!

Me too:

I am trying to update the price list from a specific vendor with more than 1000 SKUs. 

I have different cost price, list price and % of price increasing. How I can export my price list, update on excel and then upload it again in QB?

i have exported the item list as an excel document. 
saved item and cost on sheet 2

saved item and price on sheet 3

Table named columns A and B COST on sheet 2 and PRICE on sheet 3

i am using the =iferror(vlookup to match list numbers and find new cost and price by item. But the formula is defaulting to the old price and cost.

i need help with formatting or my formula?

thank you

katie