Is there a way to have different prices for different batches?

[Marius]

Hello All

I have EspoCRM with a Sales Pack. My business has had it for about 3 months and it has been great! Super quick and responsive.

So much so that we want to include batches, as my business is working with pharmaceuticals, so we are dealing with perishables.
I would like to have different prices for different batches, as some deliveries from different suppliers can be more expensive than others and we pass that cost onto our customers.

Is there a way to achieve this? From my research there are a few way:


- Create different products for different batches, that way the price can remain in the product entity
= Link batches to price books (not viable, as the price book changes the prices for the whole order)
- Create custom entities with custom relationships

All of these solutions are not suitable to me.

Any help would be appreciated.

[yuri]

Hi Marius,

It's not currently possible. Currently the {product, quantity, account} set is used to determine the price. Adding the batch number into play would complicate things. Now, the quantity is checked per product, by adding the batch number, it becomes less straightforward.

It requires some effort to design it properly before implementing. Maybe you could share some ideas.

Regards

[jeffreysgrossman]

I will add this type of functionality is important. Yes it complicates things. However the batch and inventory number for that matter hold information that is important to pricing. I would argue this type of functionality "should" be investigated. I know our use cases would really appreciate it. I had asked a very similar question with Price Books being able to work on Inventory Number information. The biggest use case is when your selling things that have an expiration date with them That information is stored in the inventory number not the product. So having soon to be expiring products go on sale automatically is the biggest use case that would really benefit the entire community of perishable goods sellers using Espo.

As always very much appreciate everything you and the team do yuri!!!!!!!!!!!

Thank You!

[yuri]

I checked a few large ERP systems, and there were no such a feature out of the box. I'm sure we can not to hurry with this feature. Espo is not a fully fledged ERP.

[Marius]

I will add this type of functionality is important. Yes it complicates things. However the batch and inventory number for that matter hold information that is important to pricing. I would argue this type of functionality "should" be investigated. I know our use cases would really appreciate it. I had asked a very similar question with Price Books being able to work on Inventory Number information. The biggest use case is when your selling things that have an expiration date with them That information is stored in the inventory number not the product. So having soon to be expiring products go on sale automatically is the biggest use case that would really benefit the entire community of perishable goods sellers using Espo.

As always very much appreciate everything you and the team do yuri!!!!!!!!!!!

Thank You!

Hi Jeffrey

Fully agreed. Products (or batches) expiring soon going on sale automatically would be extremely useful, even if it is a merely manual control over prices.

Hi Marius,

It's not currently possible. Currently the {product, quantity, account} set is used to determine the price. Adding the batch number into play would complicate things. Now, the quantity is checked per product, by adding the batch number, it becomes less straightforward.

It requires some effort to design it properly before implementing. Maybe you could share some ideas.

Regards

Hi Yuri

Thank you for your response, and I do understand. The relationship structure within the sales pack is quite complicated and what I suggest would not make it any easier. Especially since batches are chosen after the Sales Order has been placed, so it is more pertinent for the delivery team, rather than a sales team.

Not only that, but we currently have 3 different prices in Price Books. Each Account is assigned a value from a Price Book. To add additional prices from batches is tricky.

I think the simplest solution would be to open up 'Product Price' entity so that we can make custom changes. Then it's just a case of making a formula
IF ==> Price Book == xxx ==> AND ==> BatchID == xxx ==> THEN ==> Unit Price = $100.
I am not a programmer, so forgive the crude syntax, but i hope that makes sense. The 'xxx' values would, of course, be set manually. I am not sure if that is feasible, but that would be my guess to solving it.

I checked a few large ERP systems, and there were no such a feature out of the box. I'm sure we can not to hurry with this feature. Espo is not a fully fledged ERP.

I can concur. We are also dealing with Sage Evolution (which we are phasing out in favour of Espo) and this feature is absent from that system too. Still... It's something that I will have to figure out as my business will implement the pricing strategy I mentioned.

I either case, I appreciate you looking into it.