설명서CommerceCommerce Intelligence 사용 안내서

재고 레벨 분석

마지막 업데이트: 2024년 7월 15일
  • 주제:
  • 대시보드
  • 신고 수

작성 대상:

  • 초급
  • 중간
  • 관리자
  • 개발자
  • 사용자

이 항목에서는 현재 인벤토리에 대한 통찰력을 제공하고 기존 아키텍처 또는 새 아키텍처 모두의 클라이언트에 대한 지침을 포함하는 대시보드를 설정하는 방법을 보여 줍니다. Manage Data 메뉴 아래에 Data Warehouse Views 옵션이 없는 경우 레거시 아키텍처를 사용하는 것입니다. 기존 아키텍처를 사용하는 경우 아래 계산된 열 지침에 따라 지정된 섹션에 도달하면 제목이 INVENTORY ANALYSIS ​인 새 지원 요청을 제출하십시오.

추적할 열:

지침을 추적할 열

  • cataloginventory_stock_item 테이블:

    • item_id
    • product_id
    • qty

  • catalog_product_entity 테이블:

    • entity_id
    • sku
    • created_at

계산된 열:

새로운 아키텍처

  • 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

      • 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

      • column 선택: created_at

      • Filters:

        • [A] Ordered products we count

    • Seconds since product's most recent order date

      • Column type: Same Table

      • ​

        Column equation: AGE

      • 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

      • column 선택: qty_ordered

      • Filters:

        • [A] Ordered products we count

    • Avg products sold per week (all time)

      • Column type: Same Table

      • ​

        Column equation: CALCULATION

      • Column 입력:

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

      • ​

        Datatype: Decimal

      • 정의:

        • a가 null이거나 B가 null인 경우 다른 null은 round(A::decimal/(extract(epoch from (current_timestamp - B))::decimal/604800.0),2) 끝입니다.

  • cataloginventory_stock_item 테이블:

    • Sku

      • Column type: One to Many

      • ​

        Column equation: JOINED_COLUMN

      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id

      • 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

      • 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

      • 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

      • column 선택: Avg products sold per week (all time)

    • Weeks on hand

      • Column type: Same Table

      • ​

        Column equation: CALCULATION

      • Column 입력:

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

      • ​

        Datatype: Decimal

      • 정의:

        • A가 null이거나 B가 null이거나 B = 0.0일 때 null이거나 다른 round(A::decimal/B,2) 끝인 경우
레거시 아키텍처

  • 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

      • 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

      • column 선택: created_at

      • Filters:

        • [A] Ordered products we count

    • Seconds since product's most recent order date

      • Column type: Same Table

      • ​

        Column equation: AGE

      • 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

      • column 선택: qty_ordered

      • Filters:

        • [A] Ordered products we count

    • Avg products sold per week (all time)

      • [INVENTORY ANALYSIS] 지원 요청을 제출할 때 분석가가 생성함

  • cataloginventory_stock_item 테이블:

    • Sku

      • Column type: One to Many

      • ​

        Column equation: JOINED_COLUMN

      • Path: cataloginventory_stock_item.product_id => catalog_product_entity.entity_id

      • 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

      • 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

      • 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

      • column 선택: Avg products sold per week (all time)

    • Weeks on hand

      • INVENTORY ANALYSIS 지원 요청을 제출할 때 애널리스트가 만든 항목

지표

지표 지침

  • cataloginventory_stock_item 테이블:

    • Inventory on hand: 이 지표는 다음을 수행합니다.

      • 다음에 대한 합계
      • qty 열이 다음에 의해 정렬됨
      • [없음] 열

보고서

보고서 지침

  • Inventory on hand by sku

    • Metric: Inventory on hand

    • Time period: All time

    • 시간 간격: 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

    • 시간 간격: None

    • ​

      그룹 기준: 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

    • 시간 간격: None

    • ​

      그룹 기준: Sku

    • ​

      Chart type: Table

이 분석을 작성하는 동안 질문이 있거나 Professional Services 팀에 문의하려는 경우 지원 팀에 문의하십시오.

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