I’m happy to walk you through the steps on how to price increase from an excel sheet so you’ll be able to import it into your QuickBooks Desktop, @Jim-FVF.
Companies with large inventory lists that are provided by a small number of vendors can typically update these lists with an.IIF from your vendor. We can easily record the changes by simply importing the updated file into your company file. Thus, this will modify the existing fields that you didn't update.
To update the pricing of your items, we can use the Add/Edit Multiple List Entries option. Please know that we can also copy your data from Excel and paste it into the Add/Edit Multiple List Entries window to expedite the process.
Here’s how:
- Go to List from the top menu bar, then choose Add/Edit Multiple List Entries.
- Tick the List drop-down arrow, then select the list that you want to update.
- Choose any field and begin making changes.
- You can copy the data from Excel and then paste it into the Add/Edit Multiple List Entries window.
- 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.
- 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."
- Click Save Changes when you're done.
You can now import your data with an MS Excel file to update the items from there. Check out this article for further guidance: Import MS Excel files.
If you'll need to track where your company stands in terms of expenses and accounts payable, we can customize your vendor reports. For the detailed step-by-step process, here’s a handy article you can follow: Customize vendor reports.
I’m always ready to assist you if you have any other questions or concerns about managing your items in QBDT. Tag me in your reply, and I’ll sprint back into action. Have a good one, and keep safe.
