Analysera lagernivåer

I det här avsnittet visas hur du konfigurerar en instrumentpanel som ger insikter om ditt nuvarande lager och innehåller instruktioner för kunder om både den äldre arkitekturen eller den nya arkitekturen. Om du inte har Data Warehouse Views alternativ under Manage Data -menyn. Om du har en äldre arkitektur skickar du en ny supportförfrågan med motivet INVENTORY ANALYSIS när du har nått det avsedda avsnittet i Beräknade kolumner instruktionerna nedan.

Kolumner att spåra:

Kolumner som spårar instruktioner

  • cataloginventory_stock_item tabell:

    • item_id
    • product_id
    • qty
  • catalog_product_entity tabell:

    • entity_id
    • sku
    • created_at

Beräknade kolumner:

Ny arkitektur
  • catalog_product_entity tabell:

    • 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

      • Välj en 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

      • Välj en column: created_at

      • Filters:

        • [A] Ordered products we count
    • Seconds since product's most recent order date

      • Column type: Same Table

      • Column equation: AGE

      • Välj 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

      • Välj en column: qty_ordered

      • Filters:

        • [A] Ordered products we count
    • Avg products sold per week (all time)

      • Column type: Same Table

      • Column equation: CALCULATION

      • Column indata:

        • S: Product's lifetime number of items sold
        • B: Product's first order date
      • Datatype: Decimal

      • Definition:

        • case when A is null or B is null else round(A::decimal/(extract(epoch from (current_timestamp - B))::decimal/604800.0),2) end
  • cataloginventory_stock_item tabell:

    • Sku

      • Column type: One to Many

      • Column equation: JOINED_COLUMN

      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id

      • Välj en 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

      • Välj en 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

      • Välj en 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

      • Välj en column: Avg products sold per week (all time)

    • Weeks on hand

      • Column type: Same Table

      • Column equation: CALCULATION

      • Column indata:

        • S: qty
        • B: Avg products sold per week (all time)
      • Datatype: Decimal

      • Definition:

        • case when A is null or B is null or B = 0.0, then null else round(A::decimal/B,2) end
Äldre arkitektur
  • catalog_product_entity tabell:

    • 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

      • Välj en 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

      • Välj en column: created_at

      • Filters:

        • [A] Ordered products we count
    • Seconds since product's most recent order date

      • Column type: Same Table

      • Column equation: AGE

      • Välj DATETIME-kolumn: 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

      • Välj en column: qty_ordered

      • Filters:

        • [A] Ordered products we count
    • Avg products sold per week (all time)

      • Skapas av en analytiker när du skickar in [LAGERANALYS] supportförfrågan
  • cataloginventory_stock_item tabell:

    • Sku

      • Column type: One to Many

      • Column equation: JOINED_COLUMN

      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id

      • Välj en 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

      • Välj en 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

      • Välj en 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

      • Välj en column: Avg products sold per week (all time)

    • Weeks on hand

      • Skapas av en analytiker när du skickar in INVENTORY ANALYSIS supportförfrågan

Mått

Mätinstruktioner

  • cataloginventory_stock_item tabell:

    • Inventory on hand: det här måttet utför en

      • Summa
      • qty kolumn sorterad efter
      • [Ingen] kolumn

Rapporter

Rapportinstruktioner

  • Inventory on hand by sku

    • Metric: Inventory on hand

    • Time period: All time

    • Tidsintervall: 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

    • Tidsintervall: None

    • Group by: 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

    • Tidsintervall: None

    • Group by: Sku

    • Chart type: Table

Om du stöter på några frågor när du skapar den här analysen eller bara vill engagera Professional Services-teamet, kontakta support.

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