Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

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

Subscribe

Get notified when there's activity on this post

This question has been flagged
inventoryecommercequickstartQuickstart
1 Reply
4077 Views
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
Discard
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
Discard
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!

Sign up
Related Posts Replies Views Activity
How do I connect the Epson TM-T88VII to Odoo?
quickstart Quickstart
Avatar
Avatar
2
Oct 25
904
How to Build Custom Forecasted Quantity Reports in Odoo Solved
inventory report forecast quickstart Quickstart
Avatar
1
Sep 25
1444
[✅ SOLVED] Transfers Between Branches / Multi-Company Operations
inventory quickstart multi-company Quickstart V17.4
Avatar
Avatar
Avatar
Avatar
3
Nov 25
15099
How to Set Customer-Specific Product Names Solved
quickstart Quickstart
Avatar
1
Nov 25
1377
✅ Odoo E-commerce: How to discriminate deliveries based on the type of clients
quickstart Quickstart
Avatar
0
Aug 25
1414
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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