add pricing

n premier and enterprise price level lists are not limited to all or nothing

check mark the items to have the custom price set, set it, then uncheck those, check some others and set them differently

the issue I would like fixed is if the custom price is based upon the cost block on the item screen, then I would like the price level list to adjust when that price changes

Enterprise has Custom Pricing and you can make prices relative to cost. Price Rules are not the same as Price Levels and not the same as Custom Pricing. There are all sorts of functions and which to use typically depends on what and where you want to have this occur: At the point of the Sale, manually or automatically, or changed relative to Cost changes, etc.

"The only issue with that is we have to hand enter pricing for 1,800 items that have 3 price levels for each item.  Do you know of a way to upload via excel or csv file the prices into QB?"

You can use Add/Edit Multiple, from Lists menu. You can use .iif files. You can use Advanced Excel mapping. But that isn't going to populate Functions. Price levels and Price Rules are examples of Functions. Setting the price in Edit Item is only notating your starting point, if you intend to use the other functions. Setting a Cost in edit item is only notating the starting point and jump starting data entry in POs and purchases.

Hello William,

Like what qbteachmt said, you can use the Add/Edit Multiple List Entries, .iif files, or advance Excel mapping. Since the Add/Edit Multiple List Entries function doesn't work for you, you can try importing .iif files. 

First, you can export the price level list and use it for reference:

1. Click File at the top menu and select Utilities.
2. Select Export and choose Lists to IIF Files.
3. Put a check mark in the Price Level List box and click OK.

Second, open the .iif file to Excel and do the necessary changes.

Lastly, import the updated file to QuickBooks:

1. Click File at the top menu and select Utilities.
2. Select Import and choose Lists to Excel Files.
3. Put a check mark in the Price Level List box and click OK.

You can also use this article for more information about importing and exporting processes: Import/Export Overview.

Otherwise, you'll need to edit the price level one at a time manually.

We'll be around if you need any help.

I can't believe that this easy function can not be done with Quickbooks or exported to excel. I don't understand how all of Quickbooks customers can come up with these easy functions but their programmers can't or don't want to release it yet to make us customers pay more for it. Just stop and give use customers all the dang features. Either they have some of the worse programmers ever or something is wrong if customers are coming up with these functionalities before them. There are so many software programs that are so far ahead of them.