Skip to Content
Menu
This question has been flagged
2 Replies
1868 Views

Hello,
I was pointed out by someone on Odoo to use for order management and stock management and possibly also purchasing management.
Now I have a fairly specific situation:

I have 10 suppliers where I myself have very limited stock but only purchase the products from the relevant suppliers once I have sold the products.
In practical terms, I therefore have 11 warehouses, 1 of mine and the rest of suppliers.

Now it is possible that a product is available from 4 different suppliers and I still have 1 or more in my own warehouse.

So now I want to keep track of the inventory of all those suppliers whereby the inventory from the different suppliers is updated every 15 to 30 minutes.
The EAN number is the same for each supplier, but the following may differ per supplier:

* purchase price
* delivery time
* sku
* selling price (minimum sale)

It must then be possible to determine with rules when which product from which supplier is most interesting.
E.g. the offer from supplier 1 as standard, but if it does not have stock then from supplier 3 and if it does not have stock then from supplier 7.

and / or from 9:00 am to 1:00 pm use the supplier 1's offer and from 1:00 pm to 4:00 pm the supplier 2's offer and then supplier 6.

With the help of such rules, I want to be able to select the best offer and transfer it to external channels (via a link to a PIM).

Concerning purchasing, I want to be able to view / download a corpse several times a day, stating what I have to order there for each supplier (so it must be taken into account on the basis of what condition I sold it) so that I can purchase it from those suppliers. (I do that 1 to 3 times a day per supplier.

Now I wonder if such functionality is available in odoo or in extra plugins and if so which one.
I hope that someone can say something about this based on this fairly brief information.
Greeting

Daniel

Avatar
Discard
Author Best Answer

Hello Jordi
Thanks for your reply.
That is a pity, I am actually looking for a quick, simple solution that offers as much as possible of what I need and not that much time and money has to be spent on custom development.

I was pointed out by someone at odoo who thought that this should be possible to a large extent.

Also had contact with an employee of odoo but after that I had more questions than before.

My situation is that I am going to work with a kind of PIM system.
All product data from suppliers will be loaded into that system.
All offer info is also loaded there and from there all product info goes to external channels (market places and possibly web shops).
From the market places the order data is returned to that pim system.

That Pim system must then be linked to something for processing orders.

However, PIm cannot do everything, it can only add the different offers of 1 and the same product to different suppliers and display total stock.
So I need something that can process all those individual sacrifices and determine what is sold when.

I need something that I can use for the next 6 to 18 months, after that the intention is to build a whole new system where odoo is just a small part of the whole.

Avatar
Discard
Best Answer

Hi Daniel,

This function is not available in Odoo, nor in any odoo modules, as far as I know. You would need to build it.

In this sense it would involve a kind of Available to Promise check, whereby at the time of selling the system performs a check according to your rules and creates a reservation to the appropiate warehouse if it is able to find product availability. By placing a reservation other sales order won't 'steal' the stock of each other. You can run into exceptions, such as the supplier updating you with a new quantity on hand that results in you being unable to deliver some of the sales orders.

Regards,

Jordi.

Avatar
Discard