Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Aplikacije
    Finance
    • Knjigovodstvo
    • Obračun
    • Stroški
    • Spreadsheet (BI)
    • Dokumenti
    • Podpisovanje
    Prodaja
    • CRM
    • Prodaja
    • POS Shop
    • POS Restaurant
    • Naročnine
    • Najem
    Spletne strani
    • Website Builder
    • Spletna trgovina
    • Blog
    • Forum
    • Pogovor v živo
    • eUčenje
    Dobavna veriga
    • Zaloga
    • Proizvodnja
    • PLM
    • Nabava
    • Vzdrževanje
    • Kakovost
    Kadri
    • Kadri
    • Kadrovanje
    • Odsotnost
    • Ocenjevanja
    • Priporočila
    • Vozni park
    Marketing
    • Družbeno Trženje
    • Email Marketing
    • SMS Marketing
    • Dogodki
    • Avtomatizacija trženja
    • Ankete
    Storitve
    • Projekt
    • Časovnice
    • Storitve na terenu
    • Služba za pomoč
    • Načrtovanje
    • Termini
    Produktivnost
    • Razprave
    • Odobritve
    • IoT
    • Voip
    • Znanje
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industrije
    Trgovina na drobno
    • Book Store
    • Trgovina z oblačili
    • Trgovina s pohištvom
    • Grocery Store
    • Trgovina s strojno opremo računalnikov
    • Trgovina z igračami
    Food & Hospitality
    • Bar and Pub
    • Restavracija
    • Hitra hrana
    • Guest House
    • Beverage Distributor
    • Hotel
    Nepremičnine
    • Real Estate Agency
    • Arhitekturno podjetje
    • Gradbeništvo
    • Estate Management
    • Vrtnarjenje
    • Združenje lastnikov nepremičnin
    Svetovanje
    • Računovodsko podjetje
    • Odoo Partner
    • Marketinška agencija
    • Law firm
    • Pridobivanje talentov
    • Audit & Certification
    Proizvodnja
    • Tekstil
    • Metal
    • Pohištvo
    • Hrana
    • Brewery
    • Poslovna darila
    Health & Fitness
    • Športni klub
    • Trgovina z očali
    • Fitnes center
    • Wellness Practitioners
    • Lekarna
    • Frizerski salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Sistemi sončne energije
    • Izdelovalec čevljev
    • Čistilne storitve
    • HVAC Services
    Ostali
    • Neprofitna organizacija
    • Agencija za okolje
    • Najem oglasnih panojev
    • Fotografija
    • Najem koles
    • Prodajalec programske opreme
    Browse all Industries
  • Skupnost
    Learn
    • Tutorials
    • Dokumentacija
    • Certifikati
    • Šolanje
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Prenesi
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Dogodki
    • Prevodi
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Sklici kupca
    • Podpora
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Določanje cen
  • Pomoč

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Knjigovodstvo
  • Zaloga
  • PoS
  • Projekt
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
Pomoč

¿How can I display the total product quantity from different warehouses in Odoo e-commerce? V 16, 17

Naroči se

Get notified when there's activity on this post

This question has been flagged
inventoryecommercequickstartQuickstart
1 Odgovori
4096 Prikazi
Avatar
Jorge Iván Reyes García (jirg)

In Odoo's ecommerce, it is possible to display product stock levels in the warehouse so that customers can know how much they can purchase and if there are products still available in stock. 

Within the ecommerce configuration, you can only choose one warehouse location to associate with ecommerce. However, some companies have multiple locations or warehouses and need to show the total quantity of their products, so that later, they can define from which location to ship the products.


As is…

Website > Configuration > Settings > Shop - Products > Inventory defaults



At this point, you can only select one warehouse location to display your product quantities, but in many cases, businesses have multiple warehouses, and they want to show the total product quantities across all their warehouses to facilitate sales. The customer doesn't need to know the specific warehouse location; they simply want to make a purchase and receive their products.


For this case, here is the workaround in the standard solution:


  1. Create all your warehouses, for this example we will create 2 new warehouses:

Inventory > Configuration > Warehouses > New


Note that those new warehouses are in different physical locations.


  1. Create an additional warehouse where it will virtually consolidate the quantities from the other warehouses.


  1. When you create a new warehouse, Odoo automatically creates all the basic locations for the new warehouse, including a stock location configured by default as an intern location. 

For this case, you have to set the TOTWH/Stock location (“Stock location” of “Total Warehouse”) as a view type location. Inventory > Configuration > Locations > Select the TOTWH/Stock location > Change location type to “VIEW”


Set the TOTWH location as the parent location for the two real warehouses (north and south):

Inventory > Configuration > Location > Remove the “internal locations” filter > Select the location > Set parent location


4.1 Remove the internal location filter

4.2 Select the location “NRTWH” or “STHWH” this locations should be in blue and type “View” 

4.3 Set parent location “TOTWH” (total warehouse view location)


4.4 Repeat this step for all warehouses you want to include in the virtual warehouse.

  1. Now you have 3 warehouses, two physical (North and South) and one virtual (Total).




To validate that it works:


  1. Create one product and set quantities on the two physical locations


  1. Set the Total Warehouse as the warehouse of e-commerce. Total Warehouse, should summarize the quantities of both physical warehouses.
  2. Total Warehouse, should summarize the quantities of both physical warehouses.


  1. Create a sale of the test product (“Cool product” for this case) and make sure to enter a quantity that exceeds the units in one warehouse (100 units in north, 150 units in south) to demonstrate how the system utilizes both warehouses to supply the e-commerce.


  1. On the delivery form, you can select the internal location(s) where you want to take the products, in this case we will take 100 units from NRTWH/Stock and 75 units from STHWH/Stock:

 

3
Avatar
Opusti
Ricardo Gross

This description is better than the official Odoo documentation for the same solution, thanks!
https://www.odoo.com/documentation/17.0/applications/inventory_and_mrp/inventory/warehouses_storage/advanced_operations_warehouse/stock_warehouses.html#inventory-routes-link-to-vwh

Ricardo Gross

Is there a solution if the second Warehouse is from a "Branche" from the company? because when implementing the solution, the system gives an error saying that the Parent location belongs to another company.
Thanks

Avatar
Dorian Allard (doal)
Best Answer

Hello Jorge,

It seems that this configuration doesn't work on Odoo 17.

From what I have tested, it is impossible to do a transfer based on "view" location as the source location.

1
Avatar
Opusti
Jaideep

Yes, that seems to be the case.

If NRTWH and STHWH (location type 'view') are child locations of TOTWH (also type view), then the products aren't reserved within their stock locations.

The solution works if either the stock locations in the individual WHs(NRTWH/Stock and STHWH/Stock) are internal locations while being the child location of TOTWH/Stock.

Or if NRTWH and STHWH and type internal location

Jaideep

Or the option is to have the WHs (NRTWH and STHWH) as type view with parent location TOTWH/Stock type view (the stock location of virtual WH)

Note: To select the virtual warehouse’s stock location in the Parent Location drop-down menu, the parent warehouse stock location (TOTWH/Stock) must have its Location Type set to Internal Location.
Once the child WHs have been set, this location (TOTWH/Stock) type can be changed to 'view'

In the illustration above it seems the child WHs have been linked to a WH (TOTWH) rather than its stock location (TOTWH/Stock)

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
How do I connect the Epson TM-T88VII to Odoo?
quickstart Quickstart
Avatar
Avatar
2
okt. 25
928
How to Build Custom Forecasted Quantity Reports in Odoo Solved
inventory report forecast quickstart Quickstart
Avatar
1
sep. 25
1506
[✅ SOLVED] Transfers Between Branches / Multi-Company Operations
inventory quickstart multi-company Quickstart V17.4
Avatar
Avatar
Avatar
Avatar
3
nov. 25
15244
How to Set Customer-Specific Product Names Solved
quickstart Quickstart
Avatar
1
nov. 25
1413
✅ Odoo E-commerce: How to discriminate deliveries based on the type of clients
quickstart Quickstart
Avatar
0
avg. 25
1433
Community
  • Tutorials
  • Dokumentacija
  • Forum
Open Source
  • Prenesi
  • Github
  • Runbot
  • Prevodi
Services
  • Odoo.sh Hosting
  • Podpora
  • Nadgradnja
  • Custom Developments
  • Izobraževanje
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Sredstva blagovne znamke
  • Kontakt
  • Zaposlitve
  • Dogodki
  • Podcast
  • Blog
  • Stranke
  • Pravno • Zasebnost
  • Varnost
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now