Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Automatically select nearest from multiple warehouses

By
Michael Scorpio
on 9/4/15, 11:12 AM 670 views

HI,

I'm trying to understand something in the Odoo documentation;

A company has a warehouse in Paris and in Bordeaux. For some orders, you have to deliver the products from Paris, and for others from Bordeaux. But you should also specify a fictitious warehouse that OpenERP uses to calculate whether it should deliver products from Paris or from Bordeaux. To do this in OpenERP, you would create a third warehouse ‘France’ which consolidates the warehouses in Paris and Bordeaux. You create the following physical locations:

Company

    Output

        Warehouses France

            Warehouse Paris

            Warehouse Bordeaux

OpenERP will then deliver the goods from the warehouse that has the ordered product in stock. When products are available in several warehouses, OpenERP will select the nearest warehouse. To formalize the notion of distance between warehouses you should use the geographic co-ordinates (X, Y, Z) of the different stores to enable OpenERP to search for the nearest goods. The same co-ordinates could also be used to structure the shelves, aisles and interior rooms in a warehouse.

This would seem to state quite expicitly that I can have multiple warehouses and choose which one to fulfil from based on location. I want UK orders to be fulfilled by a UK warehouse and US orders to be fulfilled by a US warehouse. The question is; how do I implement this?

0
Michael Aigner
On 5/10/16, 1:35 PM

Michael, did you get this sorted out somehow? I'm also stumbling across this problem at the moment!

0
Nimesh
On 11/6/15, 1:33 PM

Hello Michael Scorpio,

Following is my suggestion :

On stock warehouse add three fields.

1) field country_group_ids (res_country_group)

2) field country_ids (res_country)

3) field state_ids (res_state)

  • state_ids has a domain on res_country

  • country_ids has a domain on res_country_group

Write a your logic onchange of shipping address in sale order, that select the Warehouse automatically based on the state and country of the shipping address


Thanks,

Nimesh.

contractornimesh@gmail.com

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 9/4/15, 11:12 AM
Seen: 670 times
Last updated: 6/9/16, 11:18 AM