DocumentazioneCommerceGuida utente di Commerce Intelligence

[Solo PaaS]{class="badge informative" title="Applicabile solo ai progetti Adobe Commerce on Cloud (infrastruttura PaaS gestita da Adobe) e ai progetti on-premise."}

Analizza livelli scorte

Last update: Mon Aug 18 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Creato per:

  • Principiante
  • Intermedio
  • Amministratore
  • Sviluppatore
  • Utente

In questo argomento viene illustrato come impostare un dashboard che fornisca informazioni approfondite sull'inventario corrente e contenga istruzioni per i client sia sull'architettura legacy che sulla nuova architettura. Se non si dispone dell'opzione Data Warehouse Views nel menu Manage Data, si utilizza l'architettura precedente. Se ti trovi nell'architettura legacy, invia una nuova richiesta di supporto con oggetto INVENTORY ANALYSIS una volta raggiunta la sezione designata nelle istruzioni Colonne calcolate di seguito.

Colonne da tracciare:

Colonne per tenere traccia delle istruzioni

  • Tabella cataloginventory_stock_item:

    • item_id
    • product_id
    • qty

  • Tabella catalog_product_entity:

    • entity_id
    • sku
    • created_at

Colonne calcolate:

Nuova architettura

  • Tabella catalog_product_entity:

    • Product's most recent order date

      • Column type: Many to One
      • ​
        Column equation: MAX
      • Path: sales_order_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: created_at
      • Filters:
        • [A] Ordered products we count

    • Product's first order date

      • Column type: Many to One
      • ​
        Column equation: MIN
      • Path: sales_order_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: created_at
      • Filters:
        • [A] Ordered products we count

    • Seconds since product's most recent order date

      • Column type: Same Table
      • ​
        Column equation: AGE
      • Seleziona DATETIME column: Product's most recent order date

    • Product's lifetime number of items sold

      • Column type: Many to One
      • ​
        Column equation: SUM
      • Path: sales_order_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: qty_ordered
      • Filters:
        • [A] Ordered products we count

    • Avg products sold per week (all time)

      • Column type: Same Table

      • ​
        Column equation: CALCULATION

      • Column input:

        • R: Product's lifetime number of items sold
        • B: Product's first order date

      • ​
        Datatype: Decimal

      • Definizione:

        • caso in cui A è nullo o B è nullo allora null altro round(A::decimal/(extract(epoch from (current_timestamp - B))::decimal/604800.0),2) end

  • Tabella cataloginventory_stock_item:

    • Sku

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: sku

    • Product's lifetime number of items sold

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: Product's lifetime number of items sold

    • Seconds since product's most recent order date

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: Seconds since product's most recent order date

    • Avg products sold per week (all time)

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: Avg products sold per week (all time)

    • Weeks on hand

      • Column type: Same Table

      • ​
        Column equation: CALCULATION

      • Column input:

        • R: qty
        • B: Avg products sold per week (all time)

      • ​
        Datatype: Decimal

      • Definizione:

        • caso in cui A è null o B è null o B = 0.0, quindi null altro round(A::decimal/B,2) end
Architettura legacy

  • Tabella catalog_product_entity:

    • Product's most recent order date

      • Column type: Many to One
      • ​
        Column equation: MAX
      • Path: sales_order_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: created_at
      • Filters:
        • [A] Ordered products we count

    • Product's first order date

      • Column type: Many to One
      • ​
        Column equation: MIN
      • Path: sales_order_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: created_at
      • Filters:
        • [A] Ordered products we count

    • Seconds since product's most recent order date

      • Column type: Same Table
      • ​
        Column equation: AGE
      • Seleziona colonna DATETIME: Product's most recent order date

    • Product's lifetime number of items sold

      • Column type: Many to One
      • ​
        Column equation: SUM
      • Path: sales_order_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: qty_ordered
      • Filters:
        • [A] Ordered products we count

    • Avg products sold per week (all time)

      • Creato da un analista quando si invia la richiesta di supporto per [INVENTORY ANALYSIS]

  • Tabella cataloginventory_stock_item:

    • Sku

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: sku

    • Product's lifetime number of items sold

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: Product's lifetime number of items sold

    • Seconds since product's most recent order date

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: Seconds since product's most recent order date

    • Avg products sold per week (all time)

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Seleziona column: Avg products sold per week (all time)

    • Weeks on hand

      • Creato da un analista quando si invia la richiesta di supporto di INVENTORY ANALYSIS

Metriche

Istruzioni sulle metriche

  • Tabella cataloginventory_stock_item:

    • Inventory on hand: questa metrica esegue un

      • Somma sul
      • qty colonna ordinata dal
      • [Nessuna] colonna

Rapporti

Istruzioni per il rapporto

  • Inventory on hand by sku

    • Metric: Inventory on hand

    • Time period: All time

    • Intervallo di tempo: None

    • Group by:

      • Sku
      • Weeks on hand

    • ​
      Chart type: Table

  • Inventory with less than 2 weeks on hand (order now)

    • Metric: Inventory on hand

      • Filters:
        • [A] Weeks on hand < 2

    • Time period: All time

    • Intervallo di tempo: None

    • ​
      Raggruppa per: Sku

    • ​
      Chart type: Table

  • Inventory with more than 26 weeks on hand (put on sale)

    • Metric: Inventory on hand

      • Filters:
        • [A] Weeks on hand > 26

    • Time period: All time

    • Intervallo di tempo: None

    • ​
      Raggruppa per: Sku

    • ​
      Chart type: Table

Per qualsiasi domanda durante la creazione di questa analisi, o semplicemente per coinvolgere il team Professional Services, contatta il supporto.

recommendation-more-help
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc