Solved

Updating Item Prices

Forum|Forum|4 years ago
March 23, 2022
2 replies
0 views

General question and I think I know the answer. Is there a better way to update mass item prices in Quickbook desktop? We have over 5000k items in the system and there have constant price increases due to the issues in the world. I am pretty sure you can't do a load to update to change the price if the item name is the same. Having a logical computer programming background it would update the price based off the effective date of the load. I have tried the excel and a 3rd party load.

Thanks for any feedback.

QuickBooks Desktop

Best answer by Angelyn_T

Yep, they have a good way of deflecting and not answering the question on here . IMO

Hi there, @MatthewAccenttMarble. I'm stepping into the thread to share with you some insights about updating item prices in QuickBooks Desktop (QBDT).

Aside from modifying the prices of an existing item via the Add/Edit Multiple List Entries or by opening each item manually, you can also use the IIF file to move your updated item list to QuickBooks.

Prepare your file.
Back up your company file before you import IIF files. This way, you can use your backup to restore your data if you ever run into problems.
Sign in to your company file as an admin. If you’re in Multi-user mode, go to the File menu, then select Switch to Single-user Mode.
Go to the File menu, then select Utilities.
Click on Import, then select Import IIF.
Select the IIF file you want to import, then select Open.
Hit OK to confirm the import.

You can review this article for more information: Export, import, and edit IIF files.

For more hints while working with your inventory items in the future, you can also check out the resources from these links:

Let me know if you have any other questions while updating items' prices in QBDT. I'm just a post away to help. Keep safe!

katherinejoyceO

Hi there, @MatthewAccenttMarble.

Great to see your post today in the Community. Updating the item prices in QBDT will only affect your future sales and won't change your past rate.

Here's how:

From the Lists menu, then select Item List.
Double-click the item you want to change.
Enter your changes in the Edit Item window, then hit OK.

Once done, you'll want to pull up the Inventory Valuation Detail report to view your past and current sales for a specific inventory and verify their cost/selling price.

Just go to the Reports menu and select the Inventory option to do so.

I've got this article to guide you in managing your inventory items in QBDT: Add, edit, and delete items.

Feel free to come by and post again if additional concerns. I'll be there to help. Take care.

V

VanDavis

@katherinejoyceO , I'll reconstruct the question for you. Is there a better way than using Excel and third-party software? Opening each item is definitely not a better option.

M

mpeairs

I have a question about price updates. I updated the prices on several items individually but when I receive items the old price is showing on the voucher. Any idea why?

Candice C

Good morning, @mpeairs.

Thanks for chiming in on this thread.

Before digging further, let me gather some information from you:

Did you change the cost by editing the item itself or did you change it on the bill?

This will help me determine the best solution for your business. I'll be waiting for your response!

H

HiltonWiggins

every week the item cost changes on most of my items. In the old system hosted through rift networks when I put in a bill that would be the cost for that item until it changed again. With quickbooks online the only way to change the cost is to go in individually and edit the item. Why won’t it take the cost from the bill and keep it.

Sign up

Login with SSO

Login to the community

Login with SSO