DocumentaçãoCommerceGuia do usuário do Commerce Intelligence

[Somente PaaS]{class="badge informative" title="Aplica-se somente a projetos do Adobe Commerce na nuvem (infraestrutura do PaaS gerenciada pela Adobe) e a projetos locais."}

Analisar Níveis de Inventário

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

Criado para:

  • Iniciante
  • Intermediário
  • Administrador
  • Desenvolvedor
  • Usuário

Este tópico demonstra como configurar um painel que fornece informações sobre o inventário atual e contém instruções para clientes sobre a arquitetura herdada ou a nova arquitetura. Você está na arquitetura herdada se não tem a opção Data Warehouse Views no menu Manage Data. Se você estiver na arquitetura herdada, envie uma nova solicitação de suporte com o assunto INVENTORY ANALYSIS assim que chegar à seção designada nas Colunas calculadas instruções abaixo.

Colunas a rastrear:

Colunas para rastrear instruções

  • Tabela cataloginventory_stock_item:

    • item_id
    • product_id
    • qty

  • Tabela catalog_product_entity:

    • entity_id
    • sku
    • created_at

Colunas calculadas:

Nova arquitetura

  • Tabela 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
      • Selecione um 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
      • Selecione um column: created_at
      • Filters:
        • [A] Ordered products we count

    • Seconds since product's most recent order date

      • Column type: Same Table
      • ​
        Column equation: AGE
      • Selecionar 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
      • Selecione um column: qty_ordered
      • Filters:
        • [A] Ordered products we count

    • Avg products sold per week (all time)

      • Column type: Same Table

      • ​
        Column equation: CALCULATION

      • Column entradas:

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

      • ​
        Datatype: Decimal

      • Definição:

        • caso em que A é nulo ou B é nulo, senão nulo round(A::decimal/(extract(epoch from (current_timestamp - B))::decimal/604800.0),2) end

  • Tabela cataloginventory_stock_item:

    • Sku

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Selecione um 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
      • Selecione um 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
      • Selecione um 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
      • Selecione um column: Avg products sold per week (all time)

    • Weeks on hand

      • Column type: Same Table

      • ​
        Column equation: CALCULATION

      • Column entradas:

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

      • ​
        Datatype: Decimal

      • Definição:

        • caso em que A é nulo ou B é nulo ou B = 0.0, então nulo senão round(A::decimal/B,2) end
Arquitetura herdada

  • Tabela 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
      • Selecione um 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
      • Selecione um column: created_at
      • Filters:
        • [A] Ordered products we count

    • Seconds since product's most recent order date

      • Column type: Same Table
      • ​
        Column equation: AGE
      • Selecionar coluna 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
      • Selecione um column: qty_ordered
      • Filters:
        • [A] Ordered products we count

    • Avg products sold per week (all time)

      • Criado por um analista quando você envia sua solicitação de suporte da [ANÁLISE DE INVENTÁRIO]

  • Tabela cataloginventory_stock_item:

    • Sku

      • Column type: One to Many
      • ​
        Column equation: JOINED_COLUMN
      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id
      • Selecione um 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
      • Selecione um 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
      • Selecione um 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
      • Selecione um column: Avg products sold per week (all time)

    • Weeks on hand

      • Criado por um analista quando você arquiva e envia sua solicitação de suporte do INVENTORY ANALYSIS

Métricas

Instruções de métricas

  • Tabela cataloginventory_stock_item:

    • Inventory on hand: essa métrica executa uma

      • Soma em
      • qty coluna ordenada por
      • Coluna [Nenhuma]

Relatórios

Instruções do relatório

  • Inventory on hand by sku

    • Metric: Inventory on hand

    • Time period: All time

    • Intervalo de 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

    • Intervalo de tempo: None

    • ​
      Agrupar por: 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

    • Intervalo de tempo: None

    • ​
      Agrupar por: Sku

    • ​
      Chart type: Table

Se você tiver dúvidas ao criar esta análise, ou se quiser simplesmente envolver a equipe de Serviços Profissionais, contate o suporte.

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