Project

General

Profile

Actions

Non-Function #78

closed

[API] 상품 재고량 처리 (product stock count process)

Added by Deca Park about 1 year ago. Updated about 1 month ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
07/27/2023
Due date:
% Done:

0%

Estimated time:
Spent time:

Description

1.ADMIN

  1) 온라인몰 관리 > 상품 등록 관리 (/onlineProduct) > 상세 (Modify)

  • Spec: p2 (attach ppt)

2.API

  1) [API] 쇼핑몰 상품 리스트 (GET /api/mall_product_list), 상품정보 (GET /api/mall_product)

    1-1) Response > sold_out_yn (logic change)
      a) if st_product.sold_out_yn = 'Y', set 'Y'
      b) else
        b-1) if stock_count is NOT NULL AND stock_count <= 0, set 'Y'
          (* if stock_count is NULL(empty), sold_out_yn is set by 'N' - because it means that the product stock is not managed)
      c) if NOT a) or b), set 'N' 

  2) [API] PG 결제 컨펌 (POST /api/pay_confirm)

    a) if PG pay confirm API is success
      - append common order's product stock count process

  3) [Common] order's product stock count process
    - make common service(function) (it's called on other process)

    [Logic]
    a) if st_mall.mall_type is NOT  'online' (with st_order.mall_code), SKIP
    b) if st_mall.mall_type = 'online'

      b-1) SELECT DB (st_order_product)
        - select: order_count
        - condition: order_no = {order_no param}
      b-2) decrease product's stock_count of b-1) selected product list
        UPDATE DB (st_product)
        - stock_count = stock_count - order_count
          (if stock_count is minus, set by 0)


Files

재고(현재고)_en.pptx (732 KB) 재고(현재고)_en.pptx Deca Park, 07/27/2023 08:39 PM
Actions #1

Updated by Toby Pham about 1 year ago

  • Status changed from New to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions #2

Updated by Deca Park about 1 year ago

  • Subject changed from 재고량 처리 (stock count process) to 상품 재고량 처리 (product stock count process)
Actions #3

Updated by Deca Park about 1 year ago

  • Description updated (diff)
  • Status changed from Resolved to In Progress
  • Assignee changed from Deca Park to bryant bryant
Actions #4

Updated by Deca Park about 1 year ago

  • Description updated (diff)
Actions #5

Updated by bryant bryant about 1 year ago

  • Status changed from In Progress to Resolved
  • Assignee changed from bryant bryant to Deca Park
Actions #6

Updated by Deca Park about 1 year ago

  • Description updated (diff)
Actions #7

Updated by Deca Park 8 months ago

  • Status changed from Resolved to Closed
Actions #8

Updated by Jisoo Choi about 2 months ago

  • Subject changed from 상품 재고량 처리 (product stock count process) to [API] 상품 재고량 처리 (product stock count process)
  • Status changed from Closed to In Progress

 

 

기존에 재고(현재 앱 재고=DB 재고)가 마이너스일 경우, 0으로 세팅되도록 개발해주셨는데, (if stock_count is minus, set by 0)

재고가 마이너스일 경우에 마이너스 값을 갖도록 수정 부탁드립니다.

 

*참고: 편의점 KRS 상품 정보 업데이트 시, 재고는 다시 KRS 값으로 세팅됨

**스토리 오더: (1)편의점: 재고를 KRS에서 가져옴 (2)전문점: 재고 없음 / 스토리 쇼핑: 재고를 쇼핑몰에서 직접 수정함(KRS와 완전히 무관)

 

 

 

Actions #9

Updated by Jisoo Choi about 2 months ago

  • Tracker changed from New Function to Non-Function
Actions #10

Updated by Deca Park about 2 months ago

  • Assignee changed from Deca Park to Toby Pham

[API] orderService.processMinusStockCount

1.As-is

  UPDATE DB (st_product)
  - stock_count = stock_count - order_count
    (if stock_count is minus, set by 0)

2.To-be

  • UPDATE DB (st_product)
    stock_count = stock_count - order_count
    (if stock_count is minus, set by minus value)
Actions #11

Updated by Toby Pham about 2 months ago

  • Status changed from In Progress to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions #12

Updated by Deca Park about 2 months ago

  • Assignee changed from Deca Park to Jisoo Choi
Actions #13

Updated by Jisoo Choi about 1 month ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF