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.

Please let me know if you were able to resolve this.  I am in the same boat!  9500 items with custom wholesale prices and I cannot import the wholesale price!  Very frustrating!  Does not show in edit multiple items.  I cannot believe that people are even suggesting you try things that do not exist.

I am in the exact same boat year in and year out. I can import my standard price but then left manually updating a 2nd price one by one. We to do not have pricing set to change based off of cost and etc. We price each item separately with a 1-9 quantity pricing and then a 10+ price. SO TIME CONSUMING that I dont know why QB hasn't done a better job of this. I have already submitted feedback online for multiple similar things to this and never hear back or see implementation. 

@MickeyK 

Prepare the Price Level List data with the following template

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

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

Thanks for this. Just to clarify, I am speaking of the "Qty Discount" tab under Item > Edit. This item below is $10.15 for 1-9 qty and $9.15 for 10 or more qty. Not every item has the same qty discount or else we would use the pricing feature.

We have Quickbooks Enterprise Solutions 2020 and the Price Level List option does not show under Utilites -> Export

We have 5 different pricing levels and would love to know how to export and import excel files with all the levels.

Thank you

I appreciate you following this thread. @inayat.

One of my colleagues mentioned above that you can use the Add/Edit Multiple List Entries, .iif files, or advanced Excel mapping. Since the Add/Edit Multiple List Entries functions don'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 checkmark 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 checkmark 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.

@inayat 

If you are not familiar with IIF, utilize the migration tool as I mentioned in earlier post to import/export the Price Level List.