KORAIL_STORE

[ADMIN] Scheduler > schedulerKRSSaleitem
[ADMIN] 스토리 오더 관리 > 상품 관리(/storeProduct) > 전문점 KRS 수동 업데이트 (saleitem KRS manual update)

1.Logic (change)
  1) SELECT KRS DB (VI_APP_SALEITEM_STORY)
    - DEL_YN (add)
  2) if DEL_YN = 'Y'
      a) if the product was alredy registered into DB(st_product)
          a-1) check if the product exists on DB (st_order_product)
              - if YES, SKIP
              - else, DELETE st_product (with the product_code)
      b) else, SKIP (don't inser/update)
 3) else (DEL_YN='N')
    - same as current