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.