DocumentaciónCommerceGuía del usuario de Commerce Intelligence

[Solo PaaS]{class="badge informative" title="Se aplica solo a proyectos de Adobe Commerce en la nube (infraestructura PaaS administrada por Adobe) y a proyectos locales."}

Analizar niveles de inventario

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

Creado para:

  • Principiante
  • Intermedio
  • Administrador
  • Desarrollador
  • Usuario

En este tema se muestra cómo configurar un tablero que proporciona información sobre el inventario actual y contiene instrucciones para los clientes sobre la arquitectura heredada o la nueva arquitectura. Se encuentra en la arquitectura heredada si no tiene la opción Data Warehouse Views en el menú Manage Data. Si usa la arquitectura heredada, envíe una nueva solicitud de soporte técnico con el asunto INVENTORY ANALYSIS una vez que llegue a la sección designada en las instrucciones de Columnas calculadas a continuación.

Columnas para rastrear:

Columnas para seguir instrucciones

  • cataloginventory_stock_item tabla:

    • item_id
    • product_id
    • qty

  • catalog_product_entity tabla:

    • entity_id
    • sku
    • created_at

Columnas calculadas:

Nueva arquitectura

  • catalog_product_entity tabla:

    • 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
      • Seleccionar un(a) 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
      • Seleccionar un(a) column: created_at
      • Filters:
        • [A] Ordered products we count

    • Seconds since product's most recent order date

      • Column type: Same Table
      • ​
        Column equation: AGE
      • Seleccionar 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
      • Seleccionar un(a) 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:

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

      • ​
        Datatype: Decimal

      • Definición:

        • Caso de uso cuando A es nulo o B es nulo y luego nulo más redondo(A::decimal/(extract(epoch from (current_timestamp - B))::decimal/604800.0),2) final

  • cataloginventory_stock_item tabla:

    • Sku

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

    • Weeks on hand

      • Column type: Same Table

      • ​
        Column equation: CALCULATION

      • Column entradas:

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

      • ​
        Datatype: Decimal

      • Definición:

        • caso cuando A es nulo o B es nulo o B = 0,0 entonces nulo otro redondeo (A::decimal/B,2) fin
Arquitectura heredada

  • catalog_product_entity tabla:

    • 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
      • Seleccionar un(a) 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
      • Seleccionar un(a) column: created_at
      • Filters:
        • [A] Ordered products we count

    • Seconds since product's most recent order date

      • Column type: Same Table
      • ​
        Column equation: AGE
      • Seleccionar columna 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
      • Seleccionar un(a) column: qty_ordered
      • Filters:
        • [A] Ordered products we count

    • Avg products sold per week (all time)

      • Creado por un analista cuando envía su solicitud de soporte de [ANÁLISIS DE INVENTARIO]

  • cataloginventory_stock_item tabla:

    • Sku

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

    • Weeks on hand

      • Creado por un analista cuando el archivo envía su solicitud de soporte de INVENTORY ANALYSIS

Métricas

Instrucciones de métricas

  • cataloginventory_stock_item tabla:

    • Inventory on hand: esta métrica realiza una

      • Sum en el
      • qty columna ordenada por
      • Columna [None]

Informes

Instrucciones del informe

  • Inventory on hand by sku

    • Metric: Inventory on hand

    • Time period: All time

    • Intervalo de tiempo: 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 tiempo: 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 tiempo: None

    • ​
      Agrupar por: Sku

    • ​
      Chart type: Table

Si tiene alguna pregunta al generar este análisis o simplemente desea contactar con el equipo de Servicios profesionales, póngase en contacto con el servicio de asistencia.

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