I have set up my public sales price list, most of the products have quantity price breaks e.g. 1+ = £10, 100+ = £9, 1000+ = £8 etc. This works well. However certain customers have their own pricing quantity breaks but typically for only a small number of products say 5 out of the 500 total products.

I set up a custom price list for each customer that needed one and added the 5 products where the pricing structure is different from the public price list.

When I create a sales order and associate the custom price list the price shows correctly for the products on the price list but when I enter a product that is not in the customers price list it does not pick up the public price it just shows 0.

I could enter all the products against all customers with a custom price list however this would be impossible to maintain. I'm obviously missing somethings as I'm sure Odoo would be able to handle this scenario. 

Can anyone point me in the right direction?