How to display Stock Levels per Stock Location?

Created on 15 March 2021, about 4 years ago
Updated 20 September 2024, 7 months ago

I'm building a store with two fulfilment partners and have created two stock locations for that purpose and was planning on creating some rules that dictated when fulfilment notifications should be triggered to one fulfilment partner and not the other.

I'm aware that I can move/add/remove stock from specific locations at /admin/commerce/config/stock/transactions1 (btw. what up with the "1" in that url:)?) but I can't find anywhere to view stock levels per location. Am I missing something?

On the product variation itself only the accumulated stock across locations and commerce_reports doesn't include stock levels. I've also tried building a report via Views but I can't find a way to expose stock levels in a location-based way...

💬 Support request
Status

Active

Component

User interface

Created by

🇩🇰Denmark kristofferrom

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • 🇨🇭Switzerland DamienMo

    Hi, have you found any solutions for this problem ?

  • 🇦🇺Australia imclean Tasmania
  • 🇦🇺Australia imclean Tasmania

    This is possible by creating a view. There are a number of ways but I've used a view of "products".

    - Add a relationship to Product Variation
    - Add a relationship to Stock Location using the above relationship
    - Add required fields (Product title, Stock Location: Name, Local Stock Location Level: Quantity)

    Make sure you've run cron after stock transactions as that's when the data gets added to the commerce_stock_location_level table.

Production build 0.71.5 2024