์ฝ˜ํ…์ธ  ๋Œ€ํ‘œ ์ด๋ฏธ์ง€ - ๐Ÿ›’ ์ •๊ธฐ ๊ฒฐ์ œ & ๊ตฌ๋… ์„œ๋น„์Šค ๋ชจ๋ธ ๊ตฌํ˜„ ๊ธฐ๋ฒ•

๐Ÿ›’ ์ •๊ธฐ ๊ฒฐ์ œ & ๊ตฌ๋… ์„œ๋น„์Šค ๋ชจ๋ธ ๊ตฌํ˜„ ๊ธฐ๋ฒ•

์‡ผํ•‘๋ชฐ ๊ฐœ๋ฐœ์ž๋ผ๋ฉด ๋ฐ˜๋“œ์‹œ ์•Œ์•„์•ผ ํ•  ๊ตฌ๋… ๊ฒฝ์ œ์˜ ๋ชจ๋“  ๊ฒƒ ๐Ÿ”ฅ
์žฌ๋ฏธ์žˆ๊ฒŒ ๋ฐฐ์šฐ๋Š” ํ”„๋กœ๊ทธ๋žจ ๊ฐœ๋ฐœ ์ง€์‹ ๐Ÿ’ปโœจ

์•ผ ์†”์งํžˆ ๋งํ•ด์„œ ์š”์ฆ˜ ๊ตฌ๋… ์„œ๋น„์Šค ์—†๋Š” ์‚ถ์ด ์ƒ์ƒ์ด ๊ฐ€? ใ…‹ใ…‹ใ…‹
๋„ทํ”Œ๋ฆญ์Šค, ์œ ํŠœ๋ธŒ ํ”„๋ฆฌ๋ฏธ์—„, ์ฟ ํŒก ๋กœ์ผ“์™€์šฐ, ๋ฉœ๋ก ... ์šฐ๋ฆฌ ์ง€๊ฐ‘์—์„œ ๋งค๋‹ฌ ์ž๋™์œผ๋กœ ๋น ์ ธ๋‚˜๊ฐ€๋Š” ๋ˆ๋“ค ์ƒ๊ฐํ•ด๋ด ๐Ÿ˜…
์ด๊ฒŒ ๋ฐ”๋กœ ๊ตฌ๋… ๊ฒฝ์ œ(Subscription Economy)์˜ ์œ„๋ ฅ์ด์•ผ!

์‡ผํ•‘๋ชฐ ๊ฐœ๋ฐœ์ž ์ž…์žฅ์—์„œ ์ด ๊ตฌ๋… ๋ชจ๋ธ์„ ์ง์ ‘ ๊ตฌํ˜„ํ•ด์•ผ ํ•œ๋‹ค๋ฉด? ์ฒ˜์Œ์—” ๋ง‰๋ง‰ํ•˜์ง€... ๊ทผ๋ฐ ๊ฑฑ์ • ๋งˆ!
์˜ค๋Š˜ ์ด ๊ธ€ ํ•˜๋‚˜๋กœ ์ •๊ธฐ ๊ฒฐ์ œ & ๊ตฌ๋… ์„œ๋น„์Šค ๋ชจ๋ธ ๊ตฌํ˜„์˜ A to Z๋ฅผ ๋‹ค ๋ฝ‘์•„์ค„๊ฒŒ ๐ŸŽฏ

๊ธฐ์ˆ ์ ์ธ ๋‚ด์šฉ๋„ ๋นก์„ธ๊ฒŒ ๋‹ค๋ฃจ์ง€๋งŒ, ์ตœ๋Œ€ํ•œ ์‰ฝ๊ณ  ์žฌ๋ฐŒ๊ฒŒ ํ’€์–ด๋ณผ ํ…Œ๋‹ˆ๊นŒ ๋๊นŒ์ง€ ๋”ฐ๋ผ์™€๋ด ๐Ÿ’ช

๊ตฌ๋… ๊ฒฝ์ œ์˜ ํ•ต์‹ฌ ๊ตฌ์กฐ ๊ตฌ๋… ์„œ๋น„์Šค ํ”Œ๋žซํผ ์ •๊ธฐ๊ฒฐ์ œ ์ž๋™ํ™” ํ”Œ๋žœ ๊ด€๋ฆฌ ํšŒ์› ๊ด€๋ฆฌ ๊ฒฐ์ œ ์‹คํŒจ์ฒ˜๋ฆฌ 4๊ฐ€์ง€ ํ•ต์‹ฌ ์š”์†Œ๊ฐ€ ์œ ๊ธฐ์ ์œผ๋กœ ์—ฐ๊ฒฐ๋˜์–ด ๊ตฌ๋… ์„œ๋น„์Šค๋ฅผ ์™„์„ฑํ•ฉ๋‹ˆ๋‹ค

๐Ÿ“Œ ๊ตฌ๋… ์„œ๋น„์Šค ๋ชจ๋ธ์ด๋ž€? ๊ธฐ์ดˆ๋ถ€ํ„ฐ ์žก์ž

๊ตฌ๋… ์„œ๋น„์Šค ๋ชจ๋ธ์„ ํ•œ ์ค„๋กœ ์ •์˜ํ•˜๋ฉด?
"๊ณ ๊ฐ์ด ์ผ์ • ๊ธˆ์•ก์„ ์ฃผ๊ธฐ์ ์œผ๋กœ ๊ฒฐ์ œํ•˜๊ณ , ๊ทธ์— ๋งž๋Š” ์„œ๋น„์Šค๋‚˜ ์ƒํ’ˆ์„ ์ง€์†์ ์œผ๋กœ ๋ฐ›๋Š” ๋น„์ฆˆ๋‹ˆ์Šค ๋ชจ๋ธ"์ด์•ผ.

์‡ผํ•‘๋ชฐ ๊ด€์ ์—์„œ ๋ณด๋ฉด ํฌ๊ฒŒ 3๊ฐ€์ง€ ์œ ํ˜•์œผ๋กœ ๋‚˜๋‰˜์–ด:

๐ŸŽ ํ๋ ˆ์ด์…˜ํ˜• (Curation) ๋งค๋‹ฌ ํ…Œ๋งˆ์— ๋งž๋Š” ์ƒํ’ˆ์„ ๋ฐ•์Šค๋กœ ๋ฐฐ์†กํ•ด์ฃผ๋Š” ๋ฐฉ์‹.
์˜ˆ: ๋ทฐํ‹ฐ ๋ฐ•์Šค, ๋ฐ˜๋ ค๋™๋ฌผ ๊ฐ„์‹ ๋ฐ•์Šค, ์ฑ… ๊ตฌ๋… ์„œ๋น„์Šค ๋“ฑ

โ™ป๏ธ ๋ณด์ถฉํ˜• (Replenishment)
์†Œ๋ชจํ’ˆ์„ ์ •๊ธฐ์ ์œผ๋กœ ์ž๋™ ๋ฐฐ์†กํ•ด์ฃผ๋Š” ๋ฐฉ์‹.
์˜ˆ: ๋ฉด๋„๋‚ , ๋น„ํƒ€๋ฏผ, ์ปคํ”ผ ์›๋‘ ์ •๊ธฐ ๋ฐฐ์†ก

๐Ÿ”‘ ์ ‘๊ทผ๊ถŒํ˜• (Access)
ํ”„๋ฆฌ๋ฏธ์—„ ํ˜œํƒ์ด๋‚˜ ์ฝ˜ํ…์ธ ์— ๋Œ€ํ•œ ์ ‘๊ทผ๊ถŒ์„ ํŒ๋งคํ•˜๋Š” ๋ฐฉ์‹.
์˜ˆ: ์ฟ ํŒก ๋กœ์ผ“์™€์šฐ, ๋„ค์ด๋ฒ„ ํ”Œ๋Ÿฌ์Šค ๋ฉค๋ฒ„์‹ญ

๊ฐœ๋ฐœ์ž ์ž…์žฅ์—์„œ ์ด ์„ธ ๊ฐ€์ง€ ์œ ํ˜•์€ ๋ฐ์ดํ„ฐ ๋ชจ๋ธ๊ณผ ๊ฒฐ์ œ ๋กœ์ง์ด ์กฐ๊ธˆ์”ฉ ๋‹ฌ๋ผ์ง€๊ธฐ ๋•Œ๋ฌธ์— ์ฒ˜์Œ ์„ค๊ณ„ํ•  ๋•Œ ์–ด๋–ค ์œ ํ˜•์ธ์ง€ ๋ช…ํ™•ํžˆ ํ•ด์•ผ ํ•ด!
ํ๋ ˆ์ด์…˜ํ˜•์€ ๋ฐฐ์†ก ๊ด€๋ฆฌ๊ฐ€ ํ•ต์‹ฌ์ด๊ณ , ๋ณด์ถฉํ˜•์€ ์žฌ๊ณ  ์—ฐ๋™์ด ์ค‘์š”ํ•˜๊ณ , ์ ‘๊ทผ๊ถŒํ˜•์€ ๊ถŒํ•œ ๊ด€๋ฆฌ๊ฐ€ ํ•ต์‹ฌ์ด๊ฑฐ๋“  ๐Ÿ˜Ž

๊ตฌ๋… ์„œ๋น„์Šค์˜ ํ•ต์‹ฌ ์ง€ํ‘œ (KPI)

๊ตฌ๋… ์„œ๋น„์Šค๋ฅผ ๊ฐœ๋ฐœํ•˜๋ฉด์„œ ๋น„์ฆˆ๋‹ˆ์Šค ํŒ€์ด๋ž‘ ์†Œํ†ตํ•  ๋•Œ ์ด ์šฉ์–ด๋“ค์€ ๊ธฐ๋ณธ์œผ๋กœ ์•Œ์•„์•ผ ํ•ด ใ…‹ใ…‹

MRR (Monthly Recurring Revenue) - ์›”๊ฐ„ ๋ฐ˜๋ณต ๋งค์ถœ
โ†’ ๋งค๋‹ฌ ์•ˆ์ •์ ์œผ๋กœ ๋“ค์–ด์˜ค๋Š” ๊ตฌ๋… ๋งค์ถœ ์ดํ•ฉ

ARR (Annual Recurring Revenue) - ์—ฐ๊ฐ„ ๋ฐ˜๋ณต ๋งค์ถœ
โ†’ MRR ร— 12. ํˆฌ์ž์ž๋“ค์ด ์ œ์ผ ์ข‹์•„ํ•˜๋Š” ์ง€ํ‘œ ใ…‹ใ…‹

Churn Rate - ์ดํƒˆ๋ฅ 
โ†’ ๊ตฌ๋…์„ ์ทจ์†Œํ•œ ๊ณ ๊ฐ ๋น„์œจ. ๋‚ฎ์„์ˆ˜๋ก ์ข‹์Œ!

LTV (Lifetime Value) - ๊ณ ๊ฐ ์ƒ์•  ๊ฐ€์น˜
โ†’ ํ•œ ๊ณ ๊ฐ์ด ๊ตฌ๋… ๊ธฐ๊ฐ„ ๋™์•ˆ ๊ฐ€์ ธ๋‹ค์ฃผ๋Š” ์ด ๋งค์ถœ

CAC (Customer Acquisition Cost) - ๊ณ ๊ฐ ํš๋“ ๋น„์šฉ
โ†’ ์‹ ๊ทœ ๊ตฌ๋…์ž ํ•œ ๋ช…์„ ์œ ์น˜ํ•˜๋Š” ๋ฐ ๋“œ๋Š” ๋น„์šฉ
๐Ÿ’ก ๊ฐœ๋ฐœ ํŒ! ์ด ์ง€ํ‘œ๋“ค์„ ์‹ค์‹œ๊ฐ„์œผ๋กœ ๋ณผ ์ˆ˜ ์žˆ๋Š” ๋Œ€์‹œ๋ณด๋“œ๋ฅผ ์ฒ˜์Œ๋ถ€ํ„ฐ ์„ค๊ณ„์— ํฌํ•จ์‹œ์ผœ๋‘๋ฉด ๋‚˜์ค‘์— ์—„์ฒญ ํŽธํ•ด. ๋‚˜์ค‘์— ์ถ”๊ฐ€ํ•˜๋ ค๋ฉด DB ๊ตฌ์กฐ ๋œฏ์–ด๊ณ ์ณ์•ผ ํ•  ์ˆ˜๋„ ์žˆ๊ฑฐ๋“  ๐Ÿ˜…

๐Ÿ—„๏ธ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค๊ณ„: ๊ตฌ๋… ์„œ๋น„์Šค์˜ ๋ผˆ๋Œ€

์ž, ์ด์ œ ์ง„์งœ ๊ฐœ๋ฐœ ์–˜๊ธฐ ๋“ค์–ด๊ฐ€๋ณด์ž!
๊ตฌ๋… ์„œ๋น„์Šค์—์„œ DB ์„ค๊ณ„๊ฐ€ ์ œ์ผ ์ค‘์š”ํ•ด. ์ฒ˜์Œ์— ์ž˜๋ชป ์งœ๋ฉด ๋‚˜์ค‘์— ํ”ผ ๋ด„ ใ… ใ… 
ํ•ต์‹ฌ ํ…Œ์ด๋ธ” ๊ตฌ์กฐ๋ฅผ ์‚ดํŽด๋ณผ๊ฒŒ:

ํ•ต์‹ฌ ํ…Œ์ด๋ธ” ๊ตฌ์กฐ

๐Ÿ“‹ plans (๊ตฌ๋… ํ”Œ๋žœ ํ…Œ์ด๋ธ”) ๊ตฌ๋… ์ƒํ’ˆ ์ž์ฒด๋ฅผ ์ •์˜ํ•˜๋Š” ํ…Œ์ด๋ธ”์ด์•ผ.
CREATE TABLE plans (
  id          BIGINT PRIMARY KEY AUTO_INCREMENT,
  name        VARCHAR(100) NOT NULL,      -- ํ”Œ๋žœ๋ช… (๋ฒ ์ด์ง, ํ”„๋ฆฌ๋ฏธ์—„ ๋“ฑ)
  description TEXT,                        -- ํ”Œ๋žœ ์„ค๋ช…
  price       DECIMAL(10,2) NOT NULL,     -- ๊ฐ€๊ฒฉ
  currency    VARCHAR(3) DEFAULT 'KRW',   -- ํ†ตํ™”
  interval    ENUM('day','week','month','year') NOT NULL, -- ๊ฒฐ์ œ ์ฃผ๊ธฐ
  interval_count INT DEFAULT 1,           -- ์ฃผ๊ธฐ ๋ฐฐ์ˆ˜ (2๋ฉด 2๊ฐœ์›”๋งˆ๋‹ค)
  trial_days  INT DEFAULT 0,              -- ๋ฌด๋ฃŒ ์ฒดํ—˜ ๊ธฐ๊ฐ„
  is_active   TINYINT(1) DEFAULT 1,       -- ํ™œ์„ฑํ™” ์—ฌ๋ถ€
  created_at  DATETIME DEFAULT NOW(),
  updated_at  DATETIME DEFAULT NOW()
);
๐Ÿ‘ค subscriptions (๊ตฌ๋… ํ˜„ํ™ฉ ํ…Œ์ด๋ธ”) ์‹ค์ œ ๊ณ ๊ฐ์˜ ๊ตฌ๋… ์ƒํƒœ๋ฅผ ๊ด€๋ฆฌํ•˜๋Š” ํ•ต์‹ฌ ํ…Œ์ด๋ธ”!
CREATE TABLE subscriptions (
  id                  BIGINT PRIMARY KEY AUTO_INCREMENT,
  user_id             BIGINT NOT NULL,           -- ๊ตฌ๋…์ž ID
  plan_id             BIGINT NOT NULL,           -- ํ”Œ๋žœ ID
  status              ENUM(
                        'trialing',    -- ์ฒดํ—˜ ์ค‘
                        'active',      -- ํ™œ์„ฑ
                        'past_due',    -- ๊ฒฐ์ œ ์—ฐ์ฒด
                        'canceled',    -- ์ทจ์†Œ๋จ
                        'expired'      -- ๋งŒ๋ฃŒ๋จ
                      ) NOT NULL,
  current_period_start DATETIME NOT NULL,        -- ํ˜„์žฌ ๊ตฌ๋… ๊ธฐ๊ฐ„ ์‹œ์ž‘
  current_period_end   DATETIME NOT NULL,        -- ํ˜„์žฌ ๊ตฌ๋… ๊ธฐ๊ฐ„ ์ข…๋ฃŒ
  trial_start         DATETIME,                  -- ์ฒดํ—˜ ์‹œ์ž‘์ผ
  trial_end           DATETIME,                  -- ์ฒดํ—˜ ์ข…๋ฃŒ์ผ
  canceled_at         DATETIME,                  -- ์ทจ์†Œ ์š”์ฒญ ์‹œ๊ฐ
  cancel_at_period_end TINYINT(1) DEFAULT 0,     -- ๊ธฐ๊ฐ„ ์ข…๋ฃŒ ์‹œ ์ทจ์†Œ ์—ฌ๋ถ€
  payment_method_id   BIGINT,                    -- ๊ฒฐ์ œ ์ˆ˜๋‹จ ID
  created_at          DATETIME DEFAULT NOW(),
  updated_at          DATETIME DEFAULT NOW(),
  FOREIGN KEY (user_id) REFERENCES users(id),
  FOREIGN KEY (plan_id) REFERENCES plans(id)
);
๐Ÿ’ณ invoices (์ฒญ๊ตฌ์„œ ํ…Œ์ด๋ธ”) ๋งค ๊ฒฐ์ œ ์ฃผ๊ธฐ๋งˆ๋‹ค ์ƒ์„ฑ๋˜๋Š” ์ฒญ๊ตฌ ๊ธฐ๋ก์ด์•ผ.
CREATE TABLE invoices (
  id              BIGINT PRIMARY KEY AUTO_INCREMENT,
  subscription_id BIGINT NOT NULL,
  user_id         BIGINT NOT NULL,
  amount          DECIMAL(10,2) NOT NULL,
  currency        VARCHAR(3) DEFAULT 'KRW',
  status          ENUM('draft','open','paid','void','uncollectible') NOT NULL,
  due_date        DATETIME,                  -- ๊ฒฐ์ œ ๊ธฐํ•œ
  paid_at         DATETIME,                  -- ์‹ค์ œ ๊ฒฐ์ œ ์‹œ๊ฐ
  attempt_count   INT DEFAULT 0,             -- ๊ฒฐ์ œ ์‹œ๋„ ํšŸ์ˆ˜
  next_attempt_at DATETIME,                  -- ๋‹ค์Œ ์žฌ์‹œ๋„ ์‹œ๊ฐ
  pg_transaction_id VARCHAR(200),            -- PG์‚ฌ ๊ฑฐ๋ž˜ ID
  created_at      DATETIME DEFAULT NOW(),
  FOREIGN KEY (subscription_id) REFERENCES subscriptions(id)
);

๊ฒฐ์ œ ์ˆ˜๋‹จ ์ €์žฅ ํ…Œ์ด๋ธ”

CREATE TABLE payment_methods (
  id              BIGINT PRIMARY KEY AUTO_INCREMENT,
  user_id         BIGINT NOT NULL,
  type            ENUM('card','bank_transfer','kakao_pay','naver_pay') NOT NULL,
  pg_customer_key VARCHAR(200),    -- PG์‚ฌ์—์„œ ๋ฐœ๊ธ‰ํ•œ ๊ณ ๊ฐ ํ‚ค (๋นŒ๋งํ‚ค)
  card_last4      VARCHAR(4),      -- ์นด๋“œ ๋ 4์ž๋ฆฌ (ํ‘œ์‹œ์šฉ)
  card_brand      VARCHAR(50),     -- ์นด๋“œ์‚ฌ (์‚ผ์„ฑ, ํ˜„๋Œ€ ๋“ฑ)
  is_default      TINYINT(1) DEFAULT 0,
  created_at      DATETIME DEFAULT NOW()
);
๐Ÿ’ก ์ค‘์š”! ์‹ค์ œ ์นด๋“œ ๋ฒˆํ˜ธ๋‚˜ CVV๋Š” ์ ˆ๋Œ€ DB์— ์ €์žฅํ•˜๋ฉด ์•ˆ ๋ผ! PG์‚ฌ์—์„œ ๋ฐœ๊ธ‰ํ•ด์ฃผ๋Š” ๋นŒ๋งํ‚ค(Billing Key)๋งŒ ์ €์žฅํ•˜๋Š” ๊ฑฐ์•ผ. ์ด๊ฒŒ ๋ณด์•ˆ์˜ ํ•ต์‹ฌ์ด์•ผ ๐Ÿ”
๊ตฌ๋… ์„œ๋น„์Šค DB ๊ด€๊ณ„๋„ users id, email name, ... created_at plans id, name price, interval trial_days subscriptions id, user_id, plan_id status, current_period_start current_period_end cancel_at_period_end payment_method_id created_at invoices id, subscription_id amount, status paid_at, due_date attempt_count pg_transaction_id payment_methods id, user_id, type pg_customer_key card_last4 1:N 1:N 1:N N:1

๐Ÿ’ณ PG์‚ฌ ์—ฐ๋™๊ณผ ๋นŒ๋งํ‚ค ๋ฐœ๊ธ‰: ์ž๋™๊ฒฐ์ œ์˜ ํ•ต์‹ฌ

๊ตฌ๋… ์„œ๋น„์Šค์—์„œ ์ œ์ผ ์ค‘์š”ํ•œ ๊ฒŒ ๋ญ๋ƒ๊ณ ? ๋ฐ”๋กœ ์ž๋™ ๊ฒฐ์ œ์•ผ!
๊ณ ๊ฐ์ด ๋งค๋‹ฌ ์ง์ ‘ ๊ฒฐ์ œํ•˜๋Ÿฌ ๋“ค์–ด์˜ค๋Š” ๊ฒŒ ์•„๋‹ˆ๋ผ, ์‹œ์Šคํ…œ์ด ์•Œ์•„์„œ ๊ฒฐ์ œํ•ด์ค˜์•ผ ํ•˜์ž–์•„.
์ด๊ฑธ ๊ฐ€๋Šฅํ•˜๊ฒŒ ํ•ด์ฃผ๋Š” ๊ฒŒ ๋ฐ”๋กœ ๋นŒ๋งํ‚ค(Billing Key) ๋ฐฉ์‹์ด์•ผ ๐Ÿ”‘

๋นŒ๋งํ‚ค ๋ฐœ๊ธ‰ ํ”„๋กœ์„ธ์Šค

1
๊ณ ๊ฐ์ด ์นด๋“œ ์ •๋ณด ์ž…๋ ฅ
PG์‚ฌ๊ฐ€ ์ œ๊ณตํ•˜๋Š” ๊ฒฐ์ œ์ฐฝ(ํŒ์—…/iframe)์—์„œ ์นด๋“œ ์ •๋ณด๋ฅผ ์ž…๋ ฅํ•ด. ์ด ๊ณผ์ •์—์„œ ์นด๋“œ ์ •๋ณด๋Š” PG์‚ฌ ์„œ๋ฒ„๋กœ๋งŒ ์ „์†ก๋˜๊ณ , ์šฐ๋ฆฌ ์„œ๋ฒ„์—๋Š” ์ ˆ๋Œ€ ์•ˆ ์™€!
2
PG์‚ฌ๊ฐ€ ๋นŒ๋งํ‚ค ๋ฐœ๊ธ‰
PG์‚ฌ๊ฐ€ ์นด๋“œ ์ •๋ณด๋ฅผ ๊ฒ€์ฆํ•˜๊ณ , ์šฐ๋ฆฌ ์„œ๋ฒ„์— ๊ณ ์œ ํ•œ ๋นŒ๋งํ‚ค๋ฅผ ๋ฐœ๊ธ‰ํ•ด์ค˜. ์ด ๋นŒ๋งํ‚ค๊ฐ€ ๋‚˜์ค‘์— ์ž๋™๊ฒฐ์ œํ•  ๋•Œ ์‚ฌ์šฉ๋˜๋Š” ์—ด์‡ ์•ผ!
3
๋นŒ๋งํ‚ค๋ฅผ DB์— ์ €์žฅ
๋ฐœ๊ธ‰๋ฐ›์€ ๋นŒ๋งํ‚ค๋ฅผ payment_methods ํ…Œ์ด๋ธ”์— ์ €์žฅํ•ด. ์นด๋“œ ๋ฒˆํ˜ธ ์ž์ฒด๋Š” ์ €์žฅ ์•ˆ ํ•˜๊ณ  ์ด ํ‚ค๋งŒ ์ €์žฅํ•˜๋Š” ๊ฑฐ์•ผ.
4
์ž๋™๊ฒฐ์ œ ์‹คํ–‰
๊ฒฐ์ œ ์ฃผ๊ธฐ๊ฐ€ ๋˜๋ฉด ์„œ๋ฒ„์—์„œ ๋นŒ๋งํ‚ค๋ฅผ ์ด์šฉํ•ด PG์‚ฌ API๋ฅผ ํ˜ธ์ถœํ•ด์„œ ์ž๋™์œผ๋กœ ๊ฒฐ์ œ๋ฅผ ์ง„ํ–‰ํ•ด!

๊ตญ๋‚ด ์ฃผ์š” PG์‚ฌ ๋น„๊ต

๐Ÿฆ ํ† ์ŠคํŽ˜์ด๋จผ์ธ  (Toss Payments) โ†’ ๊ฐœ๋ฐœ์ž ์นœํ™”์ ์ธ API ๋ฌธ์„œ, ๋นŒ๋ง API ์ง€์› ์šฐ์ˆ˜
โ†’ ํ…Œ์ŠคํŠธ ํ™˜๊ฒฝ์ด ์ž˜ ๊ฐ–์ถฐ์ ธ ์žˆ์–ด์„œ ๊ฐœ๋ฐœํ•˜๊ธฐ ํŽธํ•จ
โ†’ ์Šคํƒ€ํŠธ์—…๋“ค์ด ๋งŽ์ด ์„ ํƒํ•˜๋Š” PG์‚ฌ

๐Ÿฆ ์•„์ž„ํฌํŠธ / ํฌํŠธ์› (PortOne)
โ†’ ์—ฌ๋Ÿฌ PG์‚ฌ๋ฅผ ํ•˜๋‚˜์˜ API๋กœ ํ†ตํ•ฉ ๊ด€๋ฆฌ ๊ฐ€๋Šฅ
โ†’ ๊ตญ๋‚ด PG์‚ฌ ํ†ตํ•ฉ ์†”๋ฃจ์…˜์œผ๋กœ ์œ ๋ช…
โ†’ ์นด์นด์˜คํŽ˜์ด, ๋„ค์ด๋ฒ„ํŽ˜์ด ๋“ฑ ๊ฐ„ํŽธ๊ฒฐ์ œ๋„ ํ†ตํ•ฉ ์ง€์›

๐Ÿฆ KG์ด๋‹ˆ์‹œ์Šค
โ†’ ๊ตญ๋‚ด ์ตœ๋Œ€ PG์‚ฌ ์ค‘ ํ•˜๋‚˜
โ†’ ๋Œ€๊ธฐ์—… ์‡ผํ•‘๋ชฐ์—์„œ ๋งŽ์ด ์‚ฌ์šฉ
โ†’ ์•ˆ์ •์„ฑ์ด ๋†’์ง€๋งŒ ๊ฐœ๋ฐœ ๋ฌธ์„œ๊ฐ€ ์กฐ๊ธˆ ๊ตฌ์‹์ธ ํŽธ

๐Ÿฆ NHN KCP
โ†’ ์ •๊ธฐ๊ฒฐ์ œ ๊ธฐ๋Šฅ ์ง€์›
โ†’ ๋Œ€ํ˜• ์‡ผํ•‘๋ชฐ ๋ ˆํผ๋Ÿฐ์Šค ๋‹ค์ˆ˜ ๋ณด์œ 

ํ† ์ŠคํŽ˜์ด๋จผ์ธ  ๋นŒ๋ง API ์˜ˆ์‹œ ์ฝ”๋“œ

์‹ค์ œ๋กœ ์–ด๋–ป๊ฒŒ ์ฝ”๋“œ๋ฅผ ์งœ๋Š”์ง€ ๋ณด์—ฌ์ค„๊ฒŒ! Node.js ๊ธฐ์ค€์ด์•ผ:

// ๋นŒ๋งํ‚ค ๋ฐœ๊ธ‰ ์š”์ฒญ (๊ณ ๊ฐ์ด ์นด๋“œ ๋“ฑ๋ก ํ›„ ์„œ๋ฒ„๋กœ authKey ์ „๋‹ฌ)
const axios = require('axios');

async function issueBillingKey(authKey, customerKey) {
  const response = await axios.post(
    'https://api.tosspayments.com/v1/billing/authorizations/issue',
    {
      authKey: authKey,
      customerKey: customerKey
    },
    {
      headers: {
        Authorization: `Basic ${Buffer.from(process.env.TOSS_SECRET_KEY + ':').toString('base64')}`,
        'Content-Type': 'application/json'
      }
    }
  );
  
  // ์‘๋‹ต์—์„œ billingKey ์ถ”์ถœ ํ›„ DB ์ €์žฅ
  const { billingKey, card } = response.data;
  
  await db.query(
    `INSERT INTO payment_methods 
     (user_id, type, pg_customer_key, card_last4, card_brand, is_default)
     VALUES (?, 'card', ?, ?, ?, 1)`,
    [userId, billingKey, card.number.slice(-4), card.company]
  );
  
  return billingKey;
}
// ์ž๋™๊ฒฐ์ œ ์‹คํ–‰ ํ•จ์ˆ˜
async function chargeSubscription(billingKey, amount, orderId, orderName) {
  try {
    const response = await axios.post(
      `https://api.tosspayments.com/v1/billing/${billingKey}`,
      {
        customerKey: customerKey,
        amount: amount,
        orderId: orderId,
        orderName: orderName,
        customerEmail: customerEmail,
        customerName: customerName
      },
      {
        headers: {
          Authorization: `Basic ${Buffer.from(process.env.TOSS_SECRET_KEY + ':').toString('base64')}`,
          'Content-Type': 'application/json'
        }
      }
    );
    
    return { success: true, data: response.data };
  } catch (error) {
    return { success: false, error: error.response.data };
  }
}
โš ๏ธ ์ฃผ์˜! ์‹ค์ œ ์„œ๋น„์Šค์—์„œ๋Š” Secret Key๋ฅผ ํ™˜๊ฒฝ๋ณ€์ˆ˜๋กœ ๊ด€๋ฆฌํ•˜๊ณ , ์ ˆ๋Œ€ ์ฝ”๋“œ์— ํ•˜๋“œ์ฝ”๋”ฉํ•˜๋ฉด ์•ˆ ๋ผ! GitHub์— ์˜ฌ๋ผ๊ฐ€๋Š” ์ˆœ๊ฐ„ ๋ณด์•ˆ ์‚ฌ๊ณ  ๋‚จ ๐Ÿ˜ฑ

โฐ ์ •๊ธฐ ๊ฒฐ์ œ ์Šค์ผ€์ค„๋Ÿฌ ๊ตฌํ˜„

๋นŒ๋งํ‚ค ๋ฐœ๊ธ‰๊นŒ์ง€ ๋์œผ๋ฉด ์ด์ œ ์ž๋™์œผ๋กœ ๊ฒฐ์ œ๋ฅผ ์‹คํ–‰ํ•˜๋Š” ์Šค์ผ€์ค„๋Ÿฌ๋ฅผ ๋งŒ๋“ค์–ด์•ผ ํ•ด!
์ด๊ฒŒ ๊ตฌ๋… ์„œ๋น„์Šค์˜ ์‹ฌ์žฅ์ด๋ผ๊ณ  ํ•  ์ˆ˜ ์žˆ์–ด ๐Ÿ’“

์Šค์ผ€์ค„๋Ÿฌ ๊ตฌํ˜„ ๋ฐฉ์‹์€ ํฌ๊ฒŒ ๋‘ ๊ฐ€์ง€์•ผ:

๐Ÿ• ๋ฐฉ์‹ 1: Cron Job (ํฌ๋ก  ์žก) ์„œ๋ฒ„์—์„œ ์ฃผ๊ธฐ์ ์œผ๋กœ ์‹คํ–‰๋˜๋Š” ๋ฐฐ์น˜ ์ž‘์—…์ด์•ผ.
๋งค์ผ ์ž์ •์— "์˜ค๋Š˜ ๊ฒฐ์ œํ•ด์•ผ ํ•  ๊ตฌ๋… ๋ชฉ๋ก"์„ ๋ฝ‘์•„์„œ ์ผ๊ด„ ์ฒ˜๋ฆฌํ•˜๋Š” ๋ฐฉ์‹.

๐Ÿ”” ๋ฐฉ์‹ 2: ์ด๋ฒคํŠธ ๊ธฐ๋ฐ˜ (Event-Driven)
๊ฐ ๊ตฌ๋…์˜ ๋งŒ๋ฃŒ ์‹œ๊ฐ์— ๋งž์ถฐ ๊ฐœ๋ณ„ ์ด๋ฒคํŠธ๋ฅผ ์˜ˆ์•ฝํ•ด๋‘๋Š” ๋ฐฉ์‹.
Redis, Bull Queue ๊ฐ™์€ ๋ฉ”์‹œ์ง€ ํ๋ฅผ ํ™œ์šฉํ•ด.

Cron Job ๋ฐฉ์‹ ๊ตฌํ˜„ (Node.js + node-cron)

const cron = require('node-cron');

// ๋งค์ผ ์˜ค์ „ 9์‹œ์— ์‹คํ–‰
cron.schedule('0 9 * * *', async () => {
  console.log('์ •๊ธฐ๊ฒฐ์ œ ์Šค์ผ€์ค„๋Ÿฌ ์‹œ์ž‘:', new Date());
  
  // ์˜ค๋Š˜ ๊ฒฐ์ œํ•ด์•ผ ํ•  ๊ตฌ๋… ๋ชฉ๋ก ์กฐํšŒ
  const dueSubscriptions = await db.query(`
    SELECT s.*, pm.pg_customer_key as billing_key, 
           p.price, p.name as plan_name,
           u.email, u.name as user_name
    FROM subscriptions s
    JOIN plans p ON s.plan_id = p.id
    JOIN payment_methods pm ON s.payment_method_id = pm.id
    JOIN users u ON s.user_id = u.id
    WHERE s.status = 'active'
      AND s.current_period_end <= NOW()
      AND s.cancel_at_period_end = 0
  `);
  
  for (const subscription of dueSubscriptions) {
    await processSubscriptionRenewal(subscription);
  }
});

async function processSubscriptionRenewal(subscription) {
  // 1. ์ธ๋ณด์ด์Šค ์ƒ์„ฑ (draft ์ƒํƒœ)
  const invoiceId = await createInvoice(subscription);
  
  // 2. ๊ฒฐ์ œ ์‹œ๋„
  const orderId = `SUB_${subscription.id}_${Date.now()}`;
  const result = await chargeSubscription(
    subscription.billing_key,
    subscription.price,
    orderId,
    `${subscription.plan_name} ๊ตฌ๋… ๊ฐฑ์‹ `
  );
  
  if (result.success) {
    // 3-A. ๊ฒฐ์ œ ์„ฑ๊ณต ์ฒ˜๋ฆฌ
    await handlePaymentSuccess(subscription, invoiceId, result.data);
  } else {
    // 3-B. ๊ฒฐ์ œ ์‹คํŒจ ์ฒ˜๋ฆฌ
    await handlePaymentFailure(subscription, invoiceId, result.error);
  }
}

๊ฒฐ์ œ ์„ฑ๊ณต/์‹คํŒจ ์ฒ˜๋ฆฌ ๋กœ์ง

// ๊ฒฐ์ œ ์„ฑ๊ณต ์ฒ˜๋ฆฌ
async function handlePaymentSuccess(subscription, invoiceId, pgData) {
  const now = new Date();
  const nextPeriodEnd = calculateNextPeriodEnd(subscription);
  
  await db.transaction(async (trx) => {
    // ์ธ๋ณด์ด์Šค ์ƒํƒœ ์—…๋ฐ์ดํŠธ
    await trx.query(
      `UPDATE invoices SET status='paid', paid_at=?, pg_transaction_id=? WHERE id=?`,
      [now, pgData.paymentKey, invoiceId]
    );
    
    // ๊ตฌ๋… ๊ธฐ๊ฐ„ ๊ฐฑ์‹ 
    await trx.query(
      `UPDATE subscriptions 
       SET current_period_start=?, current_period_end=?, updated_at=?
       WHERE id=?`,
      [now, nextPeriodEnd, now, subscription.id]
    );
  });
  
  // ๊ฒฐ์ œ ์™„๋ฃŒ ์ด๋ฉ”์ผ ๋ฐœ์†ก
  await sendPaymentSuccessEmail(subscription.email, subscription.price);
  
  console.log(`โœ… ๊ฒฐ์ œ ์„ฑ๊ณต: ๊ตฌ๋… ID ${subscription.id}`);
}

// ๊ฒฐ์ œ ์‹คํŒจ ์ฒ˜๋ฆฌ
async function handlePaymentFailure(subscription, invoiceId, error) {
  const attemptCount = subscription.attempt_count + 1;
  const maxAttempts = 3; // ์ตœ๋Œ€ 3ํšŒ ์žฌ์‹œ๋„
  
  if (attemptCount >= maxAttempts) {
    // ์ตœ๋Œ€ ์žฌ์‹œ๋„ ์ดˆ๊ณผ โ†’ ๊ตฌ๋… ์ƒํƒœ๋ฅผ past_due๋กœ ๋ณ€๊ฒฝ
    await db.query(
      `UPDATE subscriptions SET status='past_due' WHERE id=?`,
      [subscription.id]
    );
    await sendSubscriptionSuspendedEmail(subscription.email);
  } else {
    // ์žฌ์‹œ๋„ ์˜ˆ์•ฝ (1์ผ ํ›„)
    const nextAttempt = new Date(Date.now() + 24 * 60 * 60 * 1000);
    await db.query(
      `UPDATE invoices 
       SET attempt_count=?, next_attempt_at=? WHERE id=?`,
      [attemptCount, nextAttempt, invoiceId]
    );
    await sendPaymentFailedEmail(subscription.email, attemptCount);
  }
  
  console.log(`โŒ ๊ฒฐ์ œ ์‹คํŒจ: ๊ตฌ๋… ID ${subscription.id}, ์‹œ๋„ ${attemptCount}ํšŒ`);
}
๐Ÿ’ก ์‹ค๋ฌด ํŒ! ๊ฒฐ์ œ ์‹คํŒจ ์žฌ์‹œ๋„๋Š” ๋ณดํ†ต 1์ผ โ†’ 3์ผ โ†’ 7์ผ ๊ฐ„๊ฒฉ์œผ๋กœ ์ ์  ๋Š˜๋ ค๊ฐ€๋Š” ๋ฐฉ์‹์„ ๋งŽ์ด ์จ. ๋„ˆ๋ฌด ์ž์ฃผ ์‹œ๋„ํ•˜๋ฉด ๊ณ ๊ฐ ์นด๋“œ๊ฐ€ ๋ธ”๋ฝ๋  ์ˆ˜ ์žˆ๊ฑฐ๋“  ใ…‹ใ…‹
๊ฒฐ์ œ ์‹คํŒจ ์žฌ์‹œ๋„ ํ”Œ๋กœ์šฐ ๐Ÿ”„ ๊ฒฐ์ œ ์‹œ๋„ (D-day) ๊ฒฐ์ œ ์„ฑ๊ณต? โœ… ๊ตฌ๋… ๊ฐฑ์‹  ์™„๋ฃŒ ๊ธฐ๊ฐ„ ์—ฐ์žฅ + ์ด๋ฉ”์ผ ๋ฐœ์†ก YES NO โŒ 1์ฐจ ์‹คํŒจ ์‹คํŒจ ์•Œ๋ฆผ ์ด๋ฉ”์ผ ๋ฐœ์†ก +1์ผ ํ›„ ์žฌ์‹œ๋„ โŒ 2์ฐจ ์‹คํŒจ ์นด๋“œ ๋ณ€๊ฒฝ ์œ ๋„ ์ด๋ฉ”์ผ +3์ผ ํ›„ ์žฌ์‹œ๋„ ๐Ÿšซ 3์ฐจ ์‹คํŒจ โ†’ ๊ตฌ๋… ์ •์ง€ status = 'past_due' ์ฒ˜๋ฆฌ

๐Ÿ”„ ๊ตฌ๋… ํ”Œ๋žœ ๋ณ€๊ฒฝ (์—…๊ทธ๋ ˆ์ด๋“œ/๋‹ค์šด๊ทธ๋ ˆ์ด๋“œ)

๊ตฌ๋… ์„œ๋น„์Šค์—์„œ ์ƒ๊ฐ๋ณด๋‹ค ๋ณต์žกํ•œ ๊ฒŒ ํ”Œ๋žœ ๋ณ€๊ฒฝ ๋กœ์ง์ด์•ผ!
๊ณ ๊ฐ์ด ๋ฒ ์ด์ง์—์„œ ํ”„๋ฆฌ๋ฏธ์—„์œผ๋กœ ์—…๊ทธ๋ ˆ์ด๋“œํ•˜๊ฑฐ๋‚˜, ๋ฐ˜๋Œ€๋กœ ๋‹ค์šด๊ทธ๋ ˆ์ด๋“œํ•  ๋•Œ
์ด๋ฏธ ๊ฒฐ์ œํ•œ ๊ธˆ์•ก์„ ์–ด๋–ป๊ฒŒ ์ฒ˜๋ฆฌํ•  ๊ฒƒ์ธ๊ฐ€?๊ฐ€ ํ•ต์‹ฌ ๋ฌธ์ œ์•ผ ๐Ÿค”

ํ”Œ๋žœ ๋ณ€๊ฒฝ ์ฒ˜๋ฆฌ ๋ฐฉ์‹ 3๊ฐ€์ง€

๐Ÿ“… ๋ฐฉ์‹ A: ์ฆ‰์‹œ ๋ณ€๊ฒฝ (Immediate) ๋ณ€๊ฒฝ ์ฆ‰์‹œ ์ƒˆ ํ”Œ๋žœ ์ ์šฉ. ๋‚จ์€ ๊ธฐ๊ฐ„์— ๋Œ€ํ•œ ์ฐจ์•ก์„ ๊ณ„์‚ฐํ•ด์„œ ์ฆ‰์‹œ ์ถ”๊ฐ€ ์ฒญ๊ตฌํ•˜๊ฑฐ๋‚˜ ํ™˜๋ถˆ.
โ†’ ์—…๊ทธ๋ ˆ์ด๋“œ ์‹œ ๋งŽ์ด ์‚ฌ์šฉ

๐Ÿ“… ๋ฐฉ์‹ B: ๊ธฐ๊ฐ„ ์ข…๋ฃŒ ํ›„ ๋ณ€๊ฒฝ (At Period End)
ํ˜„์žฌ ๊ตฌ๋… ๊ธฐ๊ฐ„์ด ๋๋‚˜๋ฉด ์ƒˆ ํ”Œ๋žœ์œผ๋กœ ์ž๋™ ์ „ํ™˜.
โ†’ ๋‹ค์šด๊ทธ๋ ˆ์ด๋“œ ์‹œ ๋งŽ์ด ์‚ฌ์šฉ (์ด๋ฏธ ๊ฒฐ์ œํ•œ ๊ธฐ๊ฐ„์€ ํ˜„์žฌ ํ”Œ๋žœ ํ˜œํƒ ์œ ์ง€)

๐Ÿ“… ๋ฐฉ์‹ C: ์ฆ‰์‹œ ๋ณ€๊ฒฝ + ํฌ๋ ˆ๋”ง ์ ์šฉ
์ฆ‰์‹œ ๋ณ€๊ฒฝํ•˜๋˜, ๋‚จ์€ ๊ธฐ๊ฐ„์˜ ๊ธˆ์•ก์„ ํฌ๋ ˆ๋”ง์œผ๋กœ ์ ๋ฆฝํ•ด์„œ ๋‹ค์Œ ๊ฒฐ์ œ์— ์‚ฌ์šฉ.
โ†’ ๊ฐ€์žฅ ๊ณ ๊ฐ ์นœํ™”์ ์ธ ๋ฐฉ์‹

์ผํ•  ๊ณ„์‚ฐ (Proration) ๋กœ์ง

์—…๊ทธ๋ ˆ์ด๋“œ ์ฆ‰์‹œ ๋ณ€๊ฒฝ ์‹œ ์ฐจ์•ก ๊ณ„์‚ฐ ์˜ˆ์‹œ:

/**
 * ํ”Œ๋žœ ์—…๊ทธ๋ ˆ์ด๋“œ ์‹œ ์ผํ•  ๊ณ„์‚ฐ
 * ์˜ˆ: ๋ฒ ์ด์ง(์›” 9,900์›) โ†’ ํ”„๋ฆฌ๋ฏธ์—„(์›” 19,900์›)
 *     ๊ตฌ๋… ๊ธฐ๊ฐ„ ์ค‘ 15์ผ ๋‚จ์€ ์‹œ์ ์— ์—…๊ทธ๋ ˆ์ด๋“œ
 */
function calculateProration(subscription, newPlan) {
  const now = new Date();
  const periodEnd = new Date(subscription.current_period_end);
  const periodStart = new Date(subscription.current_period_start);
  
  // ์ „์ฒด ๊ตฌ๋… ๊ธฐ๊ฐ„ (์ผ)
  const totalDays = Math.ceil(
    (periodEnd - periodStart) / (1000 * 60 * 60 * 24)
  );
  
  // ๋‚จ์€ ๊ธฐ๊ฐ„ (์ผ)
  const remainingDays = Math.ceil(
    (periodEnd - now) / (1000 * 60 * 60 * 24)
  );
  
  // ํ˜„์žฌ ํ”Œ๋žœ์˜ ๋‚จ์€ ๊ธฐ๊ฐ„ ํ™˜๋ถˆ์•ก
  const currentPlanRefund = 
    (subscription.plan.price / totalDays) * remainingDays;
  
  // ์ƒˆ ํ”Œ๋žœ์˜ ๋‚จ์€ ๊ธฐ๊ฐ„ ์ฒญ๊ตฌ์•ก
  const newPlanCharge = 
    (newPlan.price / totalDays) * remainingDays;
  
  // ์‹ค์ œ ์ถ”๊ฐ€ ์ฒญ๊ตฌ์•ก (์—…๊ทธ๋ ˆ์ด๋“œ์˜ ๊ฒฝ์šฐ ์–‘์ˆ˜)
  const additionalCharge = Math.round(newPlanCharge - currentPlanRefund);
  
  return {
    totalDays,
    remainingDays,
    currentPlanRefund: Math.round(currentPlanRefund),
    newPlanCharge: Math.round(newPlanCharge),
    additionalCharge
  };
}

// ์‚ฌ์šฉ ์˜ˆ์‹œ
// ๋ฒ ์ด์ง 9,900์›, ํ”„๋ฆฌ๋ฏธ์—„ 19,900์›, 30์ผ ์ค‘ 15์ผ ๋‚จ์Œ
// currentPlanRefund: 4,950์›
// newPlanCharge: 9,950์›
// additionalCharge: 5,000์› ์ถ”๊ฐ€ ์ฒญ๊ตฌ!
๐Ÿ’ก UX ํŒ! ํ”Œ๋žœ ๋ณ€๊ฒฝ ์ „์— ๊ณ ๊ฐ์—๊ฒŒ "์ถ”๊ฐ€๋กœ X์›์ด ์ฒญ๊ตฌ๋ฉ๋‹ˆ๋‹ค" ๋˜๋Š” "๋‹ค์Œ ๊ฒฐ์ œ์ผ๋ถ€ํ„ฐ ์ƒˆ ํ”Œ๋žœ์ด ์ ์šฉ๋ฉ๋‹ˆ๋‹ค"๋ฅผ ๋ช…ํ™•ํ•˜๊ฒŒ ๋ณด์—ฌ์ค˜์•ผ ํ•ด. ์ด๊ฒŒ ๋ถˆ๋ช…ํ™•ํ•˜๋ฉด CS ํญํƒ„ ๋งž์Œ ใ…‹ใ…‹ใ…‹ ๐Ÿ˜…

๐ŸŽ ๋ฌด๋ฃŒ ์ฒดํ—˜ (Free Trial) ๊ตฌํ˜„

"์ฒซ ๋‹ฌ ๋ฌด๋ฃŒ!" ์ด๊ฑฐ ๊ตฌ๋… ์„œ๋น„์Šค์—์„œ ์—„์ฒญ ๊ฐ•๋ ฅํ•œ ๋งˆ์ผ€ํŒ… ๋„๊ตฌ์ž–์•„ ใ…‹ใ…‹
๊ฐœ๋ฐœ ๊ด€์ ์—์„œ ๋ฌด๋ฃŒ ์ฒดํ—˜ ๊ธฐ๊ฐ„์„ ์–ด๋–ป๊ฒŒ ๊ตฌํ˜„ํ•˜๋Š”์ง€ ์•Œ์•„๋ณด์ž!

๋ฌด๋ฃŒ ์ฒดํ—˜ ๊ตฌํ˜„์˜ ํ•ต์‹ฌ ํฌ์ธํŠธ:
  • โœ… ์ฒดํ—˜ ๊ธฐ๊ฐ„ ์ค‘์—๋Š” ๊ฒฐ์ œ๊ฐ€ ๋ฐœ์ƒํ•˜์ง€ ์•Š์Œ
  • โœ… ์ฒดํ—˜ ๊ธฐ๊ฐ„ ์ข…๋ฃŒ ์‹œ ์ž๋™์œผ๋กœ ์œ ๋ฃŒ ์ „ํ™˜ (๋นŒ๋งํ‚ค ํ•„์š”)
  • โœ… ์ฒดํ—˜ ๊ธฐ๊ฐ„ ์ค‘ ์ทจ์†Œํ•˜๋ฉด ๊ฒฐ์ œ ์—†์ด ์ข…๋ฃŒ
  • โœ… ๋™์ผ ์‚ฌ์šฉ์ž๊ฐ€ ๋ฌด๋ฃŒ ์ฒดํ—˜์„ ์ค‘๋ณต์œผ๋กœ ๋ฐ›์ง€ ๋ชปํ•˜๊ฒŒ ๋ฐฉ์ง€
  • โœ… ์ฒดํ—˜ ์ข…๋ฃŒ D-3, D-1์— ์•Œ๋ฆผ ์ด๋ฉ”์ผ ๋ฐœ์†ก
// ๊ตฌ๋… ์ƒ์„ฑ (๋ฌด๋ฃŒ ์ฒดํ—˜ ํฌํ•จ)
async function createSubscription(userId, planId, paymentMethodId) {
  const plan = await getPlan(planId);
  const now = new Date();
  
  // ์ด๋ฏธ ๋ฌด๋ฃŒ ์ฒดํ—˜์„ ์‚ฌ์šฉํ•œ ์  ์žˆ๋Š”์ง€ ํ™•์ธ
  const hadTrial = await db.query(
    `SELECT id FROM subscriptions 
     WHERE user_id = ? AND trial_start IS NOT NULL`,
    [userId]
  );
  
  const hasTrial = plan.trial_days > 0 && hadTrial.length === 0;
  
  let trialStart = null;
  let trialEnd = null;
  let periodStart = now;
  let periodEnd;
  let status;
  
  if (hasTrial) {
    // ๋ฌด๋ฃŒ ์ฒดํ—˜ ๊ธฐ๊ฐ„ ์„ค์ •
    trialStart = now;
    trialEnd = new Date(now.getTime() + plan.trial_days * 24 * 60 * 60 * 1000);
    periodStart = now;
    periodEnd = trialEnd;
    status = 'trialing';
  } else {
    // ์ฆ‰์‹œ ๊ฒฐ์ œ
    periodEnd = calculateNextPeriodEnd({ plan, current_period_start: now });
    status = 'active';
    
    // ์ฆ‰์‹œ ๊ฒฐ์ œ ์ฒ˜๋ฆฌ
    await chargeSubscription(/* ... */);
  }
  
  const subscriptionId = await db.query(
    `INSERT INTO subscriptions 
     (user_id, plan_id, status, current_period_start, current_period_end,
      trial_start, trial_end, payment_method_id)
     VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,
    [userId, planId, status, periodStart, periodEnd, 
     trialStart, trialEnd, paymentMethodId]
  );
  
  return subscriptionId;
}
// ์ฒดํ—˜ ๊ธฐ๊ฐ„ ์ข…๋ฃŒ ์ฒ˜๋ฆฌ ์Šค์ผ€์ค„๋Ÿฌ (๋งค์ผ ์‹คํ–‰)
cron.schedule('0 8 * * *', async () => {
  // ์˜ค๋Š˜ ์ฒดํ—˜ ๊ธฐ๊ฐ„์ด ๋๋‚˜๋Š” ๊ตฌ๋… ์กฐํšŒ
  const expiringTrials = await db.query(`
    SELECT s.*, pm.pg_customer_key as billing_key, p.price, p.name
    FROM subscriptions s
    JOIN plans p ON s.plan_id = p.id
    JOIN payment_methods pm ON s.payment_method_id = pm.id
    WHERE s.status = 'trialing'
      AND DATE(s.trial_end) = CURDATE()
  `);
  
  for (const sub of expiringTrials) {
    // ์ฒดํ—˜ ์ข…๋ฃŒ โ†’ ์œ ๋ฃŒ ์ „ํ™˜ ๊ฒฐ์ œ ์‹œ๋„
    const result = await chargeSubscription(
      sub.billing_key, sub.price, 
      `SUB_TRIAL_END_${sub.id}`, `${sub.name} ๊ตฌ๋… ์‹œ์ž‘`
    );
    
    if (result.success) {
      // ์œ ๋ฃŒ ์ „ํ™˜ ์„ฑ๊ณต
      await db.query(
        `UPDATE subscriptions 
         SET status='active', 
             current_period_start=NOW(),
             current_period_end=?
         WHERE id=?`,
        [calculateNextPeriodEnd(sub), sub.id]
      );
    } else {
      // ๊ฒฐ์ œ ์‹คํŒจ โ†’ ๊ตฌ๋… ๋งŒ๋ฃŒ
      await db.query(
        `UPDATE subscriptions SET status='expired' WHERE id=?`,
        [sub.id]
      );
    }
  }
});
โš ๏ธ ์ค‘์š”! ๋ฌด๋ฃŒ ์ฒดํ—˜ ์‹œ์—๋„ ๋ฐ˜๋“œ์‹œ ๋นŒ๋งํ‚ค๋ฅผ ๋ฏธ๋ฆฌ ๋ฐœ๊ธ‰๋ฐ›์•„์•ผ ํ•ด! ์ฒดํ—˜ ๊ธฐ๊ฐ„ ์ข…๋ฃŒ ํ›„ ์ž๋™ ์ „ํ™˜ํ•˜๋ ค๋ฉด ์นด๋“œ ์ •๋ณด๊ฐ€ ์žˆ์–ด์•ผ ํ•˜๊ฑฐ๋“ . "์นด๋“œ ์—†์ด ๋ฌด๋ฃŒ ์ฒดํ—˜" ๋ฐฉ์‹์€ ์ „ํ™˜์œจ์ด ํ›จ์”ฌ ๋‚ฎ์•„ ๐Ÿ˜…

๐Ÿ”” ์›นํ›…(Webhook) ์ฒ˜๋ฆฌ: PG์‚ฌ ์ด๋ฒคํŠธ ์ˆ˜์‹ 

PG์‚ฌ์—์„œ ๊ฒฐ์ œ ๊ด€๋ จ ์ด๋ฒคํŠธ๊ฐ€ ๋ฐœ์ƒํ•˜๋ฉด ์šฐ๋ฆฌ ์„œ๋ฒ„๋กœ ์•Œ๋ฆผ์„ ๋ณด๋‚ด์ค˜.
์ด๊ฒŒ ๋ฐ”๋กœ ์›นํ›…(Webhook)์ด์•ผ!
๊ตฌ๋… ์„œ๋น„์Šค์—์„œ ์›นํ›… ์ฒ˜๋ฆฌ๋Š” ์„ ํƒ์ด ์•„๋‹ˆ๋ผ ํ•„์ˆ˜์•ผ ๐Ÿ’ฏ

์ฃผ์š” ์›นํ›… ์ด๋ฒคํŠธ ๋ชฉ๋ก: ๐Ÿ“Œ payment.completed - ๊ฒฐ์ œ ์™„๋ฃŒ
๐Ÿ“Œ payment.failed - ๊ฒฐ์ œ ์‹คํŒจ
๐Ÿ“Œ payment.canceled - ๊ฒฐ์ œ ์ทจ์†Œ
๐Ÿ“Œ billing.key.issued - ๋นŒ๋งํ‚ค ๋ฐœ๊ธ‰ ์™„๋ฃŒ
๐Ÿ“Œ billing.key.deleted - ๋นŒ๋งํ‚ค ์‚ญ์ œ (์นด๋“œ ํ•ด์ง€)
๐Ÿ“Œ subscription.renewed - ๊ตฌ๋… ๊ฐฑ์‹  ์™„๋ฃŒ
๐Ÿ“Œ subscription.canceled - ๊ตฌ๋… ์ทจ์†Œ
// Express.js ์›นํ›… ์—”๋“œํฌ์ธํŠธ
const express = require('express');
const crypto = require('crypto');
const router = express.Router();

router.post('/webhook/toss', express.raw({type: 'application/json'}), async (req, res) => {
  // 1. ์›นํ›… ์„œ๋ช… ๊ฒ€์ฆ (๋ณด์•ˆ ํ•„์ˆ˜!)
  const signature = req.headers['toss-signature'];
  const webhookSecret = process.env.TOSS_WEBHOOK_SECRET;
  
  const expectedSignature = crypto
    .createHmac('sha256', webhookSecret)
    .update(req.body)
    .digest('hex');
  
  if (signature !== expectedSignature) {
    console.error('์›นํ›… ์„œ๋ช… ๊ฒ€์ฆ ์‹คํŒจ!');
    return res.status(401).json({ error: 'Invalid signature' });
  }
  
  // 2. ์ด๋ฒคํŠธ ํŒŒ์‹ฑ
  const event = JSON.parse(req.body);
  
  // 3. ์ด๋ฒคํŠธ ํƒ€์ž…๋ณ„ ์ฒ˜๋ฆฌ
  try {
    switch (event.eventType) {
      case 'PAYMENT_STATUS_CHANGED':
        await handlePaymentStatusChanged(event.data);
        break;
      case 'BILLING_KEY_ISSUED':
        await handleBillingKeyIssued(event.data);
        break;
      case 'BILLING_KEY_DELETED':
        await handleBillingKeyDeleted(event.data);
        break;
      default:
        console.log('์ฒ˜๋ฆฌํ•˜์ง€ ์•Š๋Š” ์ด๋ฒคํŠธ:', event.eventType);
    }
    
    // 4. ์„ฑ๊ณต ์‘๋‹ต (๋ฐ˜๋“œ์‹œ 200 ๋ฐ˜ํ™˜!)
    res.status(200).json({ received: true });
    
  } catch (error) {
    console.error('์›นํ›… ์ฒ˜๋ฆฌ ์˜ค๋ฅ˜:', error);
    // ์‹คํŒจ ์‹œ PG์‚ฌ๊ฐ€ ์žฌ์ „์†กํ•จ
    res.status(500).json({ error: 'Processing failed' });
  }
});
๐Ÿ’ก ์›นํ›… ์ฒ˜๋ฆฌ ํŒ! 1. ์›นํ›…์€ ๋ฉฑ๋“ฑ์„ฑ(Idempotency)์„ ๋ณด์žฅํ•ด์•ผ ํ•ด. ๊ฐ™์€ ์ด๋ฒคํŠธ๊ฐ€ ์ค‘๋ณต์œผ๋กœ ์™€๋„ ํ•œ ๋ฒˆ๋งŒ ์ฒ˜๋ฆฌ๋˜๋„๋ก!
2. ์›นํ›… ์ฒ˜๋ฆฌ๋Š” ๋น ๋ฅด๊ฒŒ 200 ์‘๋‹ต ๋จผ์ € ๋ณด๋‚ด๊ณ , ์‹ค์ œ ์ฒ˜๋ฆฌ๋Š” ๋น„๋™๊ธฐ๋กœ ํ•ด. ํƒ€์ž„์•„์›ƒ ๋ฐฉ์ง€!
3. ๋ชจ๋“  ์›นํ›… ์ด๋ฒคํŠธ๋ฅผ DB์— ๋กœ๊น…ํ•ด๋‘๋ฉด ๋‚˜์ค‘์— ๋””๋ฒ„๊น…ํ•  ๋•Œ ์—„์ฒญ ํŽธํ•ด ใ…‹ใ…‹

๐Ÿ“Š ๊ตฌ๋… ์ทจ์†Œ ๋ฐฉ์ง€ ์ „๋žต (Churn Prevention)

๊ฐœ๋ฐœ์ž๋„ ๋น„์ฆˆ๋‹ˆ์Šค ๋กœ์ง์„ ์ดํ•ดํ•ด์•ผ ๋” ์ข‹์€ ์‹œ์Šคํ…œ์„ ๋งŒ๋“ค ์ˆ˜ ์žˆ์–ด!
๊ตฌ๋… ์ทจ์†Œ์œจ(Churn Rate)์„ ๋‚ฎ์ถ”๋Š” ๊ฑด ๊ตฌ๋… ์„œ๋น„์Šค์˜ ์ƒ์กด๊ณผ ์ง๊ฒฐ๋ผ.
๊ฐœ๋ฐœ์ ์œผ๋กœ ๊ตฌํ˜„ํ•  ์ˆ˜ ์žˆ๋Š” ์ดํƒˆ ๋ฐฉ์ง€ ์ „๋žต๋“ค์„ ์•Œ์•„๋ณด์ž ๐Ÿ›ก๏ธ

๐ŸŽฏ ์ทจ์†Œ ํ”Œ๋กœ์šฐ ์ตœ์ ํ™” (Cancellation Flow) ์ทจ์†Œ ๋ฒ„ํŠผ์„ ๋ˆ„๋ฅด๋ฉด ๋ฐ”๋กœ ์ทจ์†Œ๋˜๋Š” ๊ฒŒ ์•„๋‹ˆ๋ผ, ๋‹จ๊ณ„์ ์œผ๋กœ ๋ถ™์žก๋Š” UI/UX๋ฅผ ๊ตฌํ˜„ํ•ด.

๋‹จ๊ณ„ 1: ์ทจ์†Œ ์ด์œ  ๋ฌผ์–ด๋ณด๊ธฐ (์„ค๋ฌธ)
๋‹จ๊ณ„ 2: ์ด์œ ์— ๋งž๋Š” ํ˜œํƒ ์ œ์•ˆ (์˜ˆ: "๊ฐ€๊ฒฉ์ด ๋ถ€๋‹ด์Šค๋Ÿฌ์šฐ์‹œ๋ฉด ํ• ์ธ ์ฟ ํฐ ๋“œ๋ฆด๊ฒŒ์š”!")
๋‹จ๊ณ„ 3: ์ผ์‹œ ์ •์ง€ ์˜ต์…˜ ์ œ์•ˆ (๊ตฌ๋… ์ทจ์†Œ ๋Œ€์‹  1~3๊ฐœ์›” ์ •์ง€)
๋‹จ๊ณ„ 4: ์ตœ์ข… ์ทจ์†Œ ํ™•์ธ
โธ๏ธ ๊ตฌ๋… ์ผ์‹œ ์ •์ง€ ๊ธฐ๋Šฅ ๊ตฌํ˜„ ์ทจ์†Œ ๋Œ€์‹  ์ผ์‹œ ์ •์ง€๋ฅผ ์„ ํƒํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ•ด์ฃผ๋ฉด ์ดํƒˆ๋ฅ ์„ ํฌ๊ฒŒ ์ค„์ผ ์ˆ˜ ์žˆ์–ด!
// ๊ตฌ๋… ์ผ์‹œ ์ •์ง€ ๊ธฐ๋Šฅ
async function pauseSubscription(subscriptionId, pauseMonths) {
  const subscription = await getSubscription(subscriptionId);
  
  if (subscription.status !== 'active') {
    throw new Error('ํ™œ์„ฑ ๊ตฌ๋…๋งŒ ์ผ์‹œ ์ •์ง€ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.');
  }
  
  const pauseUntil = new Date(subscription.current_period_end);
  pauseUntil.setMonth(pauseUntil.getMonth() + pauseMonths);
  
  await db.query(
    `UPDATE subscriptions 
     SET status='paused', 
         pause_until=?,
         updated_at=NOW()
     WHERE id=?`,
    [pauseUntil, subscriptionId]
  );
  
  // ์ผ์‹œ ์ •์ง€ ๊ธฐ๊ฐ„ ๋™์•ˆ ๊ฒฐ์ œ ์Šค์ผ€์ค„๋Ÿฌ์—์„œ ์ œ์™ธ๋จ
  // pause_until ์ดํ›„์— ์ž๋™์œผ๋กœ ์žฌ๊ฐœ
}

// ์ผ์‹œ ์ •์ง€ ํ•ด์ œ ์Šค์ผ€์ค„๋Ÿฌ
cron.schedule('0 9 * * *', async () => {
  const resumeSubscriptions = await db.query(`
    SELECT * FROM subscriptions 
    WHERE status='paused' AND pause_until <= NOW()
  `);
  
  for (const sub of resumeSubscriptions) {
    await db.query(
      `UPDATE subscriptions 
       SET status='active', 
           current_period_start=NOW(),
           current_period_end=?,
           pause_until=NULL
       WHERE id=?`,
      [calculateNextPeriodEnd(sub), sub.id]
    );
    // ์žฌ๊ฐœ ์•Œ๋ฆผ ์ด๋ฉ”์ผ ๋ฐœ์†ก
    await sendSubscriptionResumedEmail(sub.user_id);
  }
});

์ดํƒˆ ์˜ˆ์ธก ์•Œ๋ฆผ ์‹œ์Šคํ…œ

๋ฐ์ดํ„ฐ๋ฅผ ๋ถ„์„ํ•ด์„œ ์ดํƒˆ ๊ฐ€๋Šฅ์„ฑ์ด ๋†’์€ ๊ณ ๊ฐ์—๊ฒŒ ์„ ์ œ์ ์œผ๋กœ ์ ‘๊ทผํ•˜๋Š” ๋ฐฉ์‹์ด์•ผ.
์ดํƒˆ ์‹ ํ˜ธ ์ง€ํ‘œ๋“ค:

๐Ÿ“‰ ์ตœ๊ทผ 30์ผ๊ฐ„ ์„œ๋น„์Šค ์ด์šฉ ํšŸ์ˆ˜ ๊ธ‰๊ฐ
๐Ÿ“‰ ๊ฒฐ์ œ ์‹คํŒจ ์ด๋ ฅ ์žˆ์Œ
๐Ÿ“‰ ๊ณ ๊ฐ ์ง€์› ๋ฌธ์˜ ์ฆ๊ฐ€
๐Ÿ“‰ ๊ตฌ๋… ์ทจ์†Œ ํŽ˜์ด์ง€ ๋ฐฉ๋ฌธ ์ด๋ ฅ
๐Ÿ“‰ ์ด๋ฉ”์ผ ์˜คํ”ˆ์œจ ๊ธ‰๊ฐ

โ†’ ์ด๋Ÿฐ ์‹ ํ˜ธ๊ฐ€ ๊ฐ์ง€๋˜๋ฉด ์ž๋™์œผ๋กœ ํ• ์ธ ์ฟ ํฐ ๋ฐœ์†ก ๋˜๋Š” CSํŒ€ ์•Œ๋ฆผ!
๐Ÿ’ก ์žฌ๋Šฅ๋„ท ๊ฐ™์€ ํ”Œ๋žซํผ์—์„œ๋„ ๊ตฌ๋… ์„œ๋น„์Šค๋ฅผ ์šด์˜ํ•œ๋‹ค๋ฉด, ์ด๋Ÿฐ ์ดํƒˆ ๋ฐฉ์ง€ ๋กœ์ง์ด ํšŒ์› ์œ ์ง€์œจ์— ์—„์ฒญ๋‚œ ์ฐจ์ด๋ฅผ ๋งŒ๋“ค์–ด๋‚ผ ์ˆ˜ ์žˆ์–ด! ๋‹จ์ˆœํžˆ ๊ฒฐ์ œ ์‹œ์Šคํ…œ๋งŒ ๋งŒ๋“œ๋Š” ๊ฒŒ ์•„๋‹ˆ๋ผ ๋น„์ฆˆ๋‹ˆ์Šค ์ „๋žต๊นŒ์ง€ ์ฝ”๋“œ๋กœ ๊ตฌํ˜„ํ•˜๋Š” ๊ฑฐ์•ผ ๐Ÿ˜Ž

๐Ÿ” ๋ณด์•ˆ & ์ปดํ”Œ๋ผ์ด์–ธ์Šค

๊ตฌ๋… ์„œ๋น„์Šค์—์„œ ๋ณด์•ˆ์€ ํƒ€ํ˜‘์ด ์—†์–ด! ๊ณ ๊ฐ์˜ ๊ฒฐ์ œ ์ •๋ณด์™€ ๊ฐœ์ธ์ •๋ณด๋ฅผ ๋‹ค๋ฃจ๋Š” ๋งŒํผ
๋ฒ•์  ์š”๊ฑด๊ณผ ๋ณด์•ˆ ๊ธฐ์ค€์„ ๋ฐ˜๋“œ์‹œ ์ง€์ผœ์•ผ ํ•ด ๐Ÿ›ก๏ธ

PCI DSS ์ค€์ˆ˜

PCI DSS (Payment Card Industry Data Security Standard)๋Š” ์นด๋“œ ๊ฒฐ์ œ๋ฅผ ์ฒ˜๋ฆฌํ•˜๋Š” ๋ชจ๋“  ์„œ๋น„์Šค๊ฐ€ ์ง€์ผœ์•ผ ํ•˜๋Š” ๊ตญ์ œ ๋ณด์•ˆ ํ‘œ์ค€์ด์•ผ.

โœ… ์นด๋“œ ๋ฒˆํ˜ธ, CVV๋ฅผ ์ง์ ‘ ์„œ๋ฒ„์—์„œ ์ฒ˜๋ฆฌํ•˜์ง€ ์•Š๊ธฐ (PG์‚ฌ ์œ„์ž„)
โœ… HTTPS ํ•„์ˆ˜ ์ ์šฉ
โœ… ๊ฒฐ์ œ ๊ด€๋ จ ๋กœ๊ทธ์—์„œ ๋ฏผ๊ฐ ์ •๋ณด ๋งˆ์Šคํ‚น
โœ… ์ •๊ธฐ์ ์ธ ๋ณด์•ˆ ์ทจ์•ฝ์  ์ ๊ฒ€
โœ… ์ ‘๊ทผ ๊ถŒํ•œ ์ตœ์†Œํ™” ์›์น™ ์ ์šฉ

๊ฐœ์ธ์ •๋ณด๋ณดํ˜ธ๋ฒ• ์ค€์ˆ˜

๊ตญ๋‚ด ๊ฐœ์ธ์ •๋ณด๋ณดํ˜ธ๋ฒ• ๊ด€๋ จ ์ฒดํฌ๋ฆฌ์ŠคํŠธ: ๐Ÿ“‹ ๊ตฌ๋… ์‹ ์ฒญ ์‹œ ๊ฐœ์ธ์ •๋ณด ์ˆ˜์ง‘ยท์ด์šฉ ๋™์˜ ๋ฐ›๊ธฐ
๐Ÿ“‹ ๊ฒฐ์ œ ์ •๋ณด ๋ณด๊ด€ ๊ธฐ๊ฐ„ ๋ช…์‹œ (๋ณดํ†ต 5๋…„, ์ „์ž์ƒ๊ฑฐ๋ž˜๋ฒ• ๊ธฐ์ค€)
๐Ÿ“‹ ๊ตฌ๋… ์ทจ์†Œ ํ›„ ๊ฐœ์ธ์ •๋ณด ํŒŒ๊ธฐ ์ •์ฑ… ์ˆ˜๋ฆฝ
๐Ÿ“‹ ๊ฐœ์ธ์ •๋ณด ์ฒ˜๋ฆฌ๋ฐฉ์นจ์— ๊ตฌ๋… ์„œ๋น„์Šค ๊ด€๋ จ ๋‚ด์šฉ ํฌํ•จ
๐Ÿ“‹ ์ž๋™๊ฒฐ์ œ ๊ด€๋ จ ๋ณ„๋„ ๋™์˜ ํ•ญ๋ชฉ ์ถ”๊ฐ€

์ „์ž์ƒ๊ฑฐ๋ž˜๋ฒ• ์ค€์ˆ˜ ์‚ฌํ•ญ

๐Ÿ“œ ์ •๊ธฐ๊ฒฐ์ œ ๊ด€๋ จ ์ „์ž์ƒ๊ฑฐ๋ž˜๋ฒ• ์˜๋ฌด์‚ฌํ•ญ: 1. ๊ฒฐ์ œ ์ „ ๋ช…ํ™•ํ•œ ๊ณ ์ง€: ๊ฒฐ์ œ ๊ธˆ์•ก, ์ฃผ๊ธฐ, ์ทจ์†Œ ๋ฐฉ๋ฒ•์„ ๊ฒฐ์ œ ์ „์— ๋ฐ˜๋“œ์‹œ ํ‘œ์‹œ
2. ๊ฒฐ์ œ ํ™•์ธ ์ด๋ฉ”์ผ/SMS: ๋งค ๊ฒฐ์ œ ์‹œ ๊ณ ๊ฐ์—๊ฒŒ ํ™•์ธ ํ†ต๋ณด
3. ์ทจ์†Œ ๋ฐฉ๋ฒ• ๋ช…์‹œ: ์ทจ์†Œ ๋ฐฉ๋ฒ•์„ ์‰ฝ๊ฒŒ ์ฐพ์„ ์ˆ˜ ์žˆ๊ฒŒ ์ œ๊ณต
4. ์ฒญ์•ฝ์ฒ ํšŒ๊ถŒ: ๋””์ง€ํ„ธ ์ฝ˜ํ…์ธ  ์™ธ ์ƒํ’ˆ์€ 7์ผ ์ด๋‚ด ์ฒญ์•ฝ์ฒ ํšŒ ๊ฐ€๋Šฅ
5. ๊ฒฐ์ œ ๋‚ด์—ญ ์กฐํšŒ: ๊ณ ๊ฐ์ด ์–ธ์ œ๋“  ๊ฒฐ์ œ ๋‚ด์—ญ์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ์–ด์•ผ ํ•จ
โš ๏ธ ๋ฒ•์  ์ฃผ์˜! ์ž๋™๊ฒฐ์ œ ์„œ๋น„์Šค๋Š” ๋ฐ˜๋“œ์‹œ "์ž๋™๊ฒฐ์ œ์— ๋™์˜ํ•ฉ๋‹ˆ๋‹ค" ํ•ญ๋ชฉ์„ ๋ณ„๋„๋กœ ์ฒดํฌ๋ฐ›์•„์•ผ ํ•ด. ์ด๊ฒŒ ์—†์œผ๋ฉด ๋‚˜์ค‘์— ๋ถ„์Ÿ ์‹œ ์—„์ฒญ ๋ถˆ๋ฆฌํ•ด์งˆ ์ˆ˜ ์žˆ์–ด ๐Ÿ˜ฑ

๐Ÿ“ˆ ๊ตฌ๋… ๊ด€๋ฆฌ ๋Œ€์‹œ๋ณด๋“œ ๊ตฌํ˜„

๊ด€๋ฆฌ์ž๊ฐ€ ๊ตฌ๋… ํ˜„ํ™ฉ์„ ํ•œ๋ˆˆ์— ๋ณผ ์ˆ˜ ์žˆ๋Š” ๋Œ€์‹œ๋ณด๋“œ๋„ ํ•„์ˆ˜์•ผ!
์–ด๋–ค ๋ฐ์ดํ„ฐ๋ฅผ ๋ณด์—ฌ์ค˜์•ผ ํ•˜๋Š”์ง€ ์•Œ์•„๋ณด์ž ๐Ÿ“Š

ํ•ต์‹ฌ ๋Œ€์‹œ๋ณด๋“œ ์ฟผ๋ฆฌ๋“ค

-- MRR (์›”๊ฐ„ ๋ฐ˜๋ณต ๋งค์ถœ) ๊ณ„์‚ฐ
SELECT 
  SUM(
    CASE p.interval
      WHEN 'month' THEN p.price * p.interval_count
      WHEN 'year' THEN p.price / 12
      WHEN 'week' THEN p.price * 4.33
      ELSE p.price
    END
  ) as mrr
FROM subscriptions s
JOIN plans p ON s.plan_id = p.id
WHERE s.status IN ('active', 'trialing');

-- ํ”Œ๋žœ๋ณ„ ๊ตฌ๋…์ž ์ˆ˜
SELECT 
  p.name as plan_name,
  COUNT(s.id) as subscriber_count,
  SUM(p.price) as total_revenue
FROM subscriptions s
JOIN plans p ON s.plan_id = p.id
WHERE s.status = 'active'
GROUP BY p.id, p.name
ORDER BY subscriber_count DESC;

-- ์›”๋ณ„ ์‹ ๊ทœ ๊ตฌ๋… vs ์ทจ์†Œ ์ถ”์ด
SELECT 
  DATE_FORMAT(created_at, '%Y-%m') as month,
  COUNT(CASE WHEN status != 'canceled' THEN 1 END) as new_subscriptions,
  COUNT(CASE WHEN status = 'canceled' THEN 1 END) as cancellations
FROM subscriptions
WHERE created_at >= DATE_SUB(NOW(), INTERVAL 12 MONTH)
GROUP BY month
ORDER BY month;

-- Churn Rate ๊ณ„์‚ฐ (์ด๋ฒˆ ๋‹ฌ)
SELECT 
  (
    SELECT COUNT(*) FROM subscriptions 
    WHERE status = 'canceled' 
      AND canceled_at >= DATE_FORMAT(NOW(), '%Y-%m-01')
  ) / (
    SELECT COUNT(*) FROM subscriptions 
    WHERE status IN ('active', 'canceled')
      AND created_at < DATE_FORMAT(NOW(), '%Y-%m-01')
  ) * 100 as churn_rate_percent;

๊ณ ๊ฐ์šฉ ๊ตฌ๋… ๊ด€๋ฆฌ ํŽ˜์ด์ง€ ํ•„์ˆ˜ ๊ธฐ๋Šฅ

๊ณ ๊ฐ์ด ์ง์ ‘ ๊ด€๋ฆฌํ•  ์ˆ˜ ์žˆ์–ด์•ผ ํ•˜๋Š” ๊ธฐ๋Šฅ๋“ค:
  • โœ… ํ˜„์žฌ ๊ตฌ๋… ํ”Œ๋žœ ๋ฐ ๋‹ค์Œ ๊ฒฐ์ œ์ผ ํ™•์ธ
  • โœ… ๊ฒฐ์ œ ์ˆ˜๋‹จ ๋ณ€๊ฒฝ (์นด๋“œ ๊ต์ฒด)
  • โœ… ํ”Œ๋žœ ์—…๊ทธ๋ ˆ์ด๋“œ/๋‹ค์šด๊ทธ๋ ˆ์ด๋“œ
  • โœ… ๊ตฌ๋… ์ผ์‹œ ์ •์ง€
  • โœ… ๊ตฌ๋… ์ทจ์†Œ (์ทจ์†Œ ํ›„์—๋„ ๊ธฐ๊ฐ„ ์ข…๋ฃŒ๊นŒ์ง€ ์ด์šฉ ๊ฐ€๋Šฅ)
  • โœ… ๊ฒฐ์ œ ๋‚ด์—ญ ์กฐํšŒ ๋ฐ ์˜์ˆ˜์ฆ ๋‹ค์šด๋กœ๋“œ
  • โœ… ์ฒญ๊ตฌ์„œ ์ด๋ฉ”์ผ ์ˆ˜์‹  ์„ค์ •
๐Ÿ’ก UX ํŒ! ๊ตฌ๋… ์ทจ์†Œ ํ›„์—๋„ "๊ธฐ๊ฐ„ ์ข…๋ฃŒ๊นŒ์ง€ ์ด์šฉ ๊ฐ€๋Šฅ"์ด๋ผ๋Š” ๊ฑธ ๋ช…ํ™•ํžˆ ๋ณด์—ฌ์ค˜์•ผ ํ•ด. "์ทจ์†Œํ–ˆ๋Š”๋ฐ ์™œ ์•„์ง ๊ฒฐ์ œ๋˜๋ƒ"๋Š” CS ๋ฌธ์˜๊ฐ€ ์—„์ฒญ ๋งŽ๊ฑฐ๋“  ใ…‹ใ…‹ใ…‹ ๐Ÿ˜…

๐Ÿš€ Stripe ํ™œ์šฉ: ๊ธ€๋กœ๋ฒŒ ๊ตฌ๋… ์„œ๋น„์Šค

ํ•ด์™ธ ๊ณ ๊ฐ๋„ ๋ฐ›์„ ๊ณ„ํš์ด๋ผ๋ฉด? Stripe๊ฐ€ ์ตœ๊ณ ์˜ ์„ ํƒ์ด์•ผ!
Stripe๋Š” ๊ตฌ๋… ์„œ๋น„์Šค๋ฅผ ์œ„ํ•œ ๊ธฐ๋Šฅ์ด ์›Œ๋‚™ ์ž˜ ๊ฐ–์ถฐ์ ธ ์žˆ์–ด์„œ
์ง์ ‘ ๊ตฌํ˜„ํ•˜๋Š” ๊ฒƒ๋ณด๋‹ค Stripe๋ฅผ ํ™œ์šฉํ•˜๋Š” ๊ฒŒ ํ›จ์”ฌ ํšจ์œจ์ ์ผ ์ˆ˜ ์žˆ์–ด ๐ŸŒ

Stripe Billing์˜ ์ฃผ์š” ๊ธฐ๋Šฅ: ๐ŸŒŸ Products & Prices API: ๊ตฌ๋… ํ”Œ๋žœ ๊ด€๋ฆฌ
๐ŸŒŸ Subscriptions API: ๊ตฌ๋… ์ƒ๋ช…์ฃผ๊ธฐ ๊ด€๋ฆฌ
๐ŸŒŸ Customer Portal: ๊ณ ๊ฐ ์…€ํ”„ ๊ด€๋ฆฌ ํŽ˜์ด์ง€ (์ฝ”๋”ฉ ์—†์ด!)
๐ŸŒŸ Smart Retries: AI ๊ธฐ๋ฐ˜ ๊ฒฐ์ œ ์‹คํŒจ ์žฌ์‹œ๋„ ์ตœ์ ํ™”
๐ŸŒŸ Revenue Recovery: ์ดํƒˆ ๋ฐฉ์ง€ ์ž๋™ํ™”
๐ŸŒŸ Tax Automation: ๊ธ€๋กœ๋ฒŒ ์„ธ๊ธˆ ์ž๋™ ๊ณ„์‚ฐ
๐ŸŒŸ Dunning Management: ์—ฐ์ฒด ๊ด€๋ฆฌ ์ž๋™ํ™”
// Stripe๋กœ ๊ตฌ๋… ์ƒ์„ฑํ•˜๊ธฐ
const stripe = require('stripe')(process.env.STRIPE_SECRET_KEY);

async function createStripeSubscription(customerId, priceId, trialDays) {
  const subscription = await stripe.subscriptions.create({
    customer: customerId,
    items: [{ price: priceId }],
    trial_period_days: trialDays || 0,
    payment_settings: {
      payment_method_types: ['card'],
      save_default_payment_method: 'on_subscription'
    },
    expand: ['latest_invoice.payment_intent']
  });
  
  return subscription;
}

// Stripe ์›นํ›… ์ฒ˜๋ฆฌ
app.post('/webhook/stripe', express.raw({type: 'application/json'}), (req, res) => {
  const sig = req.headers['stripe-signature'];
  let event;
  
  try {
    event = stripe.webhooks.constructEvent(
      req.body, sig, process.env.STRIPE_WEBHOOK_SECRET
    );
  } catch (err) {
    return res.status(400).send(`Webhook Error: ${err.message}`);
  }
  
  switch (event.type) {
    case 'invoice.payment_succeeded':
      // ๊ฒฐ์ œ ์„ฑ๊ณต ์ฒ˜๋ฆฌ
      break;
    case 'invoice.payment_failed':
      // ๊ฒฐ์ œ ์‹คํŒจ ์ฒ˜๋ฆฌ
      break;
    case 'customer.subscription.deleted':
      // ๊ตฌ๋… ์ทจ์†Œ ์ฒ˜๋ฆฌ
      break;
    case 'customer.subscription.trial_will_end':
      // ์ฒดํ—˜ ์ข…๋ฃŒ 3์ผ ์ „ ์•Œ๋ฆผ
      break;
  }
  
  res.json({ received: true });
});
๐Ÿ’ก Stripe vs ๊ตญ๋‚ด PG์‚ฌ ์„ ํƒ ๊ธฐ์ค€: โ†’ ๊ตญ๋‚ด ๊ณ ๊ฐ๋งŒ ๋Œ€์ƒ: ํ† ์ŠคํŽ˜์ด๋จผ์ธ , ํฌํŠธ์› ์ถ”์ฒœ
โ†’ ๊ธ€๋กœ๋ฒŒ ์„œ๋น„์Šค: Stripe ์ถ”์ฒœ
โ†’ ๊ตญ๋‚ด+ํ•ด์™ธ ๋™์‹œ: ํฌํŠธ์›(๊ตญ๋‚ด) + Stripe(ํ•ด์™ธ) ์ด์ค‘ ๊ตฌ์กฐ

์žฌ๋Šฅ๋„ท์ฒ˜๋Ÿผ ๊ตญ๋‚ด ํ”Œ๋žซํผ์ด๋ผ๋ฉด ํ† ์ŠคํŽ˜์ด๋จผ์ธ ๋‚˜ ํฌํŠธ์›์ด ๊ฐœ๋ฐœ ํŽธ์˜์„ฑ ๋ฉด์—์„œ ํ›จ์”ฌ ์ข‹์•„!
๊ตฌ๋… ์„œ๋น„์Šค ์‹œ์Šคํ…œ ์•„ํ‚คํ…์ฒ˜ ๐Ÿ“ฑ ํด๋ผ์ด์–ธํŠธ (์›น/์•ฑ) ๐Ÿ–ฅ๏ธ API ์„œ๋ฒ„ ๊ตฌ๋… ๋น„์ฆˆ๋‹ˆ์Šค ๋กœ์ง ์›นํ›… ์ฒ˜๋ฆฌ ๐Ÿ—„๏ธ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค MySQL / PostgreSQL ๐Ÿ“ฌ ๋ฉ”์‹œ์ง€ ํ Redis / Bull โฐ ์Šค์ผ€์ค„๋Ÿฌ Cron Job ์ •๊ธฐ๊ฒฐ์ œ ์‹คํ–‰ ๐Ÿ’ณ PG์‚ฌ ํ† ์ŠคํŽ˜์ด๋จผ์ธ  / Stripe ๐Ÿ“ง ์ด๋ฉ”์ผ ์„œ๋น„์Šค SendGrid / SES ์›นํ›…

๐Ÿงช ํ…Œ์ŠคํŠธ ์ „๋žต: ๊ตฌ๋… ์„œ๋น„์Šค QA

๊ตฌ๋… ์„œ๋น„์Šค๋Š” ๋ˆ์ด ์ง์ ‘ ์˜ค๊ฐ€๋Š” ์‹œ์Šคํ…œ์ด๋ผ ํ…Œ์ŠคํŠธ๊ฐ€ ์—„์ฒญ ์ค‘์š”ํ•ด!
์–ด๋–ค ์‹œ๋‚˜๋ฆฌ์˜ค๋ฅผ ํ…Œ์ŠคํŠธํ•ด์•ผ ํ•˜๋Š”์ง€ ์ฒดํฌ๋ฆฌ์ŠคํŠธ๋กœ ์ •๋ฆฌํ•ด์ค„๊ฒŒ โœ…

๐Ÿ” ํ•„์ˆ˜ ํ…Œ์ŠคํŠธ ์‹œ๋‚˜๋ฆฌ์˜ค: [์ •์ƒ ํ”Œ๋กœ์šฐ]
โ˜‘ ์‹ ๊ทœ ๊ตฌ๋… ์ƒ์„ฑ (์ฆ‰์‹œ ๊ฒฐ์ œ)
โ˜‘ ๋ฌด๋ฃŒ ์ฒดํ—˜ ๊ตฌ๋… ์ƒ์„ฑ
โ˜‘ ๋ฌด๋ฃŒ ์ฒดํ—˜ โ†’ ์œ ๋ฃŒ ์ „ํ™˜
โ˜‘ ๊ตฌ๋… ๊ฐฑ์‹  (๋‹ค์Œ ์ฃผ๊ธฐ ๊ฒฐ์ œ)
โ˜‘ ํ”Œ๋žœ ์—…๊ทธ๋ ˆ์ด๋“œ (์ฆ‰์‹œ ๋ณ€๊ฒฝ)
โ˜‘ ํ”Œ๋žœ ๋‹ค์šด๊ทธ๋ ˆ์ด๋“œ (๊ธฐ๊ฐ„ ์ข…๋ฃŒ ํ›„ ๋ณ€๊ฒฝ)
โ˜‘ ๊ตฌ๋… ์ทจ์†Œ (๊ธฐ๊ฐ„ ์ข…๋ฃŒ ํ›„ ๋งŒ๋ฃŒ)
โ˜‘ ๊ตฌ๋… ์ฆ‰์‹œ ์ทจ์†Œ

[์˜ˆ์™ธ ํ”Œ๋กœ์šฐ]
โ˜‘ ๊ฒฐ์ œ ์‹คํŒจ ์ฒ˜๋ฆฌ
โ˜‘ ๊ฒฐ์ œ ์‹คํŒจ ์žฌ์‹œ๋„ (1์ฐจ, 2์ฐจ, 3์ฐจ)
โ˜‘ ์ตœ๋Œ€ ์žฌ์‹œ๋„ ์ดˆ๊ณผ โ†’ ๊ตฌ๋… ์ •์ง€
โ˜‘ ์นด๋“œ ๋ณ€๊ฒฝ ํ›„ ์žฌ๊ฒฐ์ œ
โ˜‘ ์›นํ›… ์ค‘๋ณต ์ˆ˜์‹  ์ฒ˜๋ฆฌ
โ˜‘ ์›นํ›… ์„œ๋ช… ๊ฒ€์ฆ ์‹คํŒจ
โ˜‘ PG์‚ฌ API ํƒ€์ž„์•„์›ƒ
โ˜‘ ๋™์‹œ ๊ฒฐ์ œ ์š”์ฒญ (Race Condition)

[์—ฃ์ง€ ์ผ€์ด์Šค]
โ˜‘ ์œค๋…„ 2์›” 29์ผ ๊ตฌ๋… (๋‹ค์Œ ๋‹ฌ ์ฒ˜๋ฆฌ)
โ˜‘ ์›”๋ง ๊ตฌ๋… (31์ผ โ†’ ๋‹ค์Œ ๋‹ฌ 28/30์ผ)
โ˜‘ ์‹œ๊ฐ„๋Œ€(Timezone) ์ฒ˜๋ฆฌ
โ˜‘ ๊ตฌ๋… ์ค‘ ํ”Œ๋žœ ๊ฐ€๊ฒฉ ๋ณ€๊ฒฝ ์‹œ ๊ธฐ์กด ๊ตฌ๋…์ž ์ฒ˜๋ฆฌ
// Jest๋ฅผ ์ด์šฉํ•œ ๊ตฌ๋… ๊ฐฑ์‹  ๋‹จ์œ„ ํ…Œ์ŠคํŠธ ์˜ˆ์‹œ
describe('๊ตฌ๋… ๊ฐฑ์‹  ํ…Œ์ŠคํŠธ', () => {
  test('์ •์ƒ ๊ฒฐ์ œ ์„ฑ๊ณต ์‹œ ๊ตฌ๋… ๊ธฐ๊ฐ„์ด ๊ฐฑ์‹ ๋˜์–ด์•ผ ํ•จ', async () => {
    // Given
    const mockSubscription = {
      id: 1,
      plan: { price: 9900, interval: 'month', interval_count: 1 },
      current_period_end: new Date('2024-01-31'),
      billing_key: 'test_billing_key'
    };
    
    // PG์‚ฌ API ๋ชจํ‚น
    jest.spyOn(pgService, 'charge').mockResolvedValue({
      success: true,
      data: { paymentKey: 'test_payment_key_123' }
    });
    
    // When
    await processSubscriptionRenewal(mockSubscription);
    
    // Then
    const updated = await getSubscription(1);
    expect(updated.status).toBe('active');
    expect(new Date(updated.current_period_end))
      .toEqual(new Date('2024-02-29')); // 2024๋…„์€ ์œค๋…„!
  });
  
  test('๊ฒฐ์ œ ์‹คํŒจ ์‹œ attempt_count๊ฐ€ ์ฆ๊ฐ€ํ•ด์•ผ ํ•จ', async () => {
    jest.spyOn(pgService, 'charge').mockResolvedValue({
      success: false,
      error: { code: 'CARD_DECLINED' }
    });
    
    await processSubscriptionRenewal(mockSubscription);
    
    const invoice = await getLatestInvoice(1);
    expect(invoice.attempt_count).toBe(1);
    expect(invoice.next_attempt_at).toBeDefined();
  });
});
๐Ÿ’ก ํ…Œ์ŠคํŠธ ํŒ! PG์‚ฌ์—์„œ ์ œ๊ณตํ•˜๋Š” ํ…Œ์ŠคํŠธ ์นด๋“œ ๋ฒˆํ˜ธ๋ฅผ ํ™œ์šฉํ•ด์„œ ์‹ค์ œ ๊ฒฐ์ œ ํ™˜๊ฒฝ๊ณผ ๋™์ผํ•˜๊ฒŒ ํ…Œ์ŠคํŠธํ•ด๋ด. ํ† ์ŠคํŽ˜์ด๋จผ์ธ ๋Š” ํ…Œ์ŠคํŠธ ํ™˜๊ฒฝ์ด ์ •๋ง ์ž˜ ๋˜์–ด ์žˆ์–ด์„œ ๊ฐœ๋ฐœํ•˜๊ธฐ ํŽธํ•ด ๐Ÿ‘

๐ŸŽฏ ๊ตฌํ˜„ ๋กœ๋“œ๋งต: ์–ด๋””์„œ๋ถ€ํ„ฐ ์‹œ์ž‘ํ• ๊นŒ?

์ž, ์ด์ œ ์ „์ฒด์ ์ธ ๊ทธ๋ฆผ์ด ๊ทธ๋ ค์กŒ์ง€? ใ…‹ใ…‹
์ฒ˜์Œ ๊ตฌ๋… ์„œ๋น„์Šค๋ฅผ ๊ตฌํ˜„ํ•œ๋‹ค๋ฉด ์ด ์ˆœ์„œ๋กœ ์ง„ํ–‰ํ•˜๋Š” ๊ฑธ ์ถ”์ฒœํ•ด!

1
๋น„์ฆˆ๋‹ˆ์Šค ๋ชจ๋ธ ํ™•์ •
์–ด๋–ค ์œ ํ˜•์˜ ๊ตฌ๋…์ธ์ง€, ํ”Œ๋žœ์€ ๋ช‡ ๊ฐœ์ธ์ง€, ๊ฐ€๊ฒฉ ์ •์ฑ…์€ ์–ด๋–ป๊ฒŒ ํ• ์ง€ ๋จผ์ € ํ™•์ •ํ•ด. ์ด๊ฒŒ DB ์„ค๊ณ„์— ์ง์ ‘ ์˜ํ–ฅ์„ ์ค˜!
2
DB ์„ค๊ณ„ ๋ฐ ๋งˆ์ด๊ทธ๋ ˆ์ด์…˜
plans, subscriptions, invoices, payment_methods ํ…Œ์ด๋ธ” ์„ค๊ณ„. ์ฒ˜์Œ์— ์ž˜ ์งœ์•ผ ๋‚˜์ค‘์— ์•ˆ ๊ณ ์ƒํ•ด!
3
PG์‚ฌ ์„ ํƒ ๋ฐ ๋นŒ๋งํ‚ค ๋ฐœ๊ธ‰ ๊ตฌํ˜„
๊ตญ๋‚ด ์„œ๋น„์Šค๋ฉด ํ† ์ŠคํŽ˜์ด๋จผ์ธ ๋‚˜ ํฌํŠธ์›, ๊ธ€๋กœ๋ฒŒ์ด๋ฉด Stripe. ๋นŒ๋งํ‚ค ๋ฐœ๊ธ‰๋ถ€ํ„ฐ ๊ตฌํ˜„!
4
๊ตฌ๋… ์ƒ์„ฑ API ๊ตฌํ˜„
๋ฌด๋ฃŒ ์ฒดํ—˜ ํฌํ•จ/๋ฏธํฌํ•จ ๊ตฌ๋… ์ƒ์„ฑ ๋กœ์ง ๊ตฌํ˜„. ์ฆ‰์‹œ ๊ฒฐ์ œ ๋˜๋Š” ์ฒดํ—˜ ์‹œ์ž‘.
5
์ •๊ธฐ๊ฒฐ์ œ ์Šค์ผ€์ค„๋Ÿฌ ๊ตฌํ˜„
Cron Job์œผ๋กœ ๋งค์ผ ๊ฒฐ์ œ ๋Œ€์ƒ ์กฐํšŒ ๋ฐ ์ž๋™ ๊ฒฐ์ œ ์‹คํ–‰. ์‹คํŒจ ์ฒ˜๋ฆฌ ๋กœ์ง ํฌํ•จ!
6
์›นํ›… ์ฒ˜๋ฆฌ ๊ตฌํ˜„
PG์‚ฌ ์ด๋ฒคํŠธ ์ˆ˜์‹  ๋ฐ ์ฒ˜๋ฆฌ. ์„œ๋ช… ๊ฒ€์ฆ ํ•„์ˆ˜!
7
๊ณ ๊ฐ ๊ด€๋ฆฌ ํŽ˜์ด์ง€ ๊ตฌํ˜„
ํ”Œ๋žœ ๋ณ€๊ฒฝ, ๊ฒฐ์ œ ์ˆ˜๋‹จ ๋ณ€๊ฒฝ, ๊ตฌ๋… ์ทจ์†Œ/์ผ์‹œ์ •์ง€ ๊ธฐ๋Šฅ.
8
๊ด€๋ฆฌ์ž ๋Œ€์‹œ๋ณด๋“œ ๊ตฌํ˜„
MRR, Churn Rate, ๊ตฌ๋…์ž ํ˜„ํ™ฉ ๋“ฑ ํ•ต์‹ฌ ์ง€ํ‘œ ์‹œ๊ฐํ™”.
9
ํ…Œ์ŠคํŠธ ๋ฐ QA
๋ชจ๋“  ์‹œ๋‚˜๋ฆฌ์˜ค ํ…Œ์ŠคํŠธ. ํŠนํžˆ ์—ฃ์ง€ ์ผ€์ด์Šค์™€ ๊ฒฐ์ œ ์‹คํŒจ ์ผ€์ด์Šค ์ง‘์ค‘ ํ…Œ์ŠคํŠธ!
10
๋ชจ๋‹ˆํ„ฐ๋ง ๋ฐ ์•Œ๋ฆผ ์„ค์ •
๊ฒฐ์ œ ์‹คํŒจ์œจ, ์ดํƒˆ๋ฅ  ๋ชจ๋‹ˆํ„ฐ๋ง. ์ด์ƒ ์ง•ํ›„ ๋ฐœ์ƒ ์‹œ Slack ์•Œ๋ฆผ ๋“ฑ ์„ค์ •.
๐Ÿ’ฐ ์˜ˆ์ƒ ๊ฐœ๋ฐœ ๊ธฐ๊ฐ„ (1์ธ ๊ฐœ๋ฐœ ๊ธฐ์ค€): โ†’ MVP (๊ธฐ๋ณธ ๊ตฌ๋… + ์ž๋™๊ฒฐ์ œ): 2~3์ฃผ
โ†’ ํ”Œ๋žœ ๋ณ€๊ฒฝ + ์ผ์‹œ์ •์ง€ + ๋Œ€์‹œ๋ณด๋“œ: +2์ฃผ
โ†’ ์ดํƒˆ ๋ฐฉ์ง€ + ๊ณ ๊ธ‰ ๋ถ„์„: +2~4์ฃผ
โ†’ ์ „์ฒด ์™„์„ฑ: ์•ฝ 6~9์ฃผ

โœจ ๋งˆ๋ฌด๋ฆฌ: ๊ตฌ๋… ์„œ๋น„์Šค ๊ฐœ๋ฐœ์˜ ํ•ต์‹ฌ ์ •๋ฆฌ

์™€, ์—ฌ๊ธฐ๊นŒ์ง€ ๋”ฐ๋ผ์™”๋‹ค๋ฉด ์ง„์งœ ๋Œ€๋‹จํ•œ ๊ฑฐ์•ผ ใ…‹ใ…‹ใ…‹ ๐Ÿ‘
์˜ค๋Š˜ ๋ฐฐ์šด ๋‚ด์šฉ์„ ํ•œ ๋ฒˆ์— ์ •๋ฆฌํ•ด๋ณผ๊ฒŒ:

๐Ÿ“Œ ํ•ต์‹ฌ ์š”์•ฝ 1๏ธโƒฃ DB ์„ค๊ณ„๊ฐ€ ์ „๋ถ€ - plans, subscriptions, invoices, payment_methods 4๊ฐœ ํ…Œ์ด๋ธ”์ด ํ•ต์‹ฌ

2๏ธโƒฃ ๋นŒ๋งํ‚ค๊ฐ€ ์ž๋™๊ฒฐ์ œ์˜ ์—ด์‡  - ์นด๋“œ ๋ฒˆํ˜ธ ์ €์žฅ ๊ธˆ์ง€, ๋นŒ๋งํ‚ค๋งŒ ์ €์žฅ

3๏ธโƒฃ ์Šค์ผ€์ค„๋Ÿฌ + ์›นํ›… ์ด์ค‘ ๊ตฌ์กฐ - ์Šค์ผ€์ค„๋Ÿฌ๋กœ ๊ฒฐ์ œ ์‹คํ–‰, ์›นํ›…์œผ๋กœ ๊ฒฐ๊ณผ ์ˆ˜์‹ 

4๏ธโƒฃ ๊ฒฐ์ œ ์‹คํŒจ ์ฒ˜๋ฆฌ๊ฐ€ ์ง„์งœ ์ค‘์š” - ์žฌ์‹œ๋„ ๋กœ์ง, ๊ณ ๊ฐ ์•Œ๋ฆผ, ๊ตฌ๋… ์ •์ง€ ์ฒ˜๋ฆฌ

5๏ธโƒฃ ๊ณ ๊ฐ ๊ฒฝํ—˜์ด ์ดํƒˆ๋ฅ ์„ ๊ฒฐ์ • - ์ทจ์†Œ ํ”Œ๋กœ์šฐ, ์ผ์‹œ์ •์ง€, ๋ช…ํ™•ํ•œ ์•ˆ๋‚ด

6๏ธโƒฃ ๋ณด์•ˆ๊ณผ ๋ฒ•์  ์š”๊ฑด ํ•„์ˆ˜ - PCI DSS, ๊ฐœ์ธ์ •๋ณด๋ณดํ˜ธ๋ฒ•, ์ „์ž์ƒ๊ฑฐ๋ž˜๋ฒ•

7๏ธโƒฃ ํ…Œ์ŠคํŠธ๋Š” ๋ชจ๋“  ์‹œ๋‚˜๋ฆฌ์˜ค๋ฅผ - ํŠนํžˆ ์—ฃ์ง€ ์ผ€์ด์Šค์™€ ์‹คํŒจ ์ผ€์ด์Šค ์ง‘์ค‘

๊ตฌ๋… ์„œ๋น„์Šค ๊ฐœ๋ฐœ์€ ๋‹จ์ˆœํžˆ "๋งค๋‹ฌ ๊ฒฐ์ œํ•˜๋Š” ๊ธฐ๋Šฅ"์ด ์•„๋‹ˆ์•ผ.
๊ณ ๊ฐ์˜ ์‹ ๋ขฐ๋ฅผ ๋‹ค๋ฃจ๋Š” ์‹œ์Šคํ…œ์ด๊ณ , ๋น„์ฆˆ๋‹ˆ์Šค์˜ ์ƒ๋ช…์ค„์ด์•ผ.
๊ทธ๋งŒํผ ๊ผผ๊ผผํ•˜๊ฒŒ, ๊ทธ๋ฆฌ๊ณ  ๊ณ ๊ฐ ์ž…์žฅ์—์„œ ์ƒ๊ฐํ•˜๋ฉด์„œ ๊ฐœ๋ฐœํ•ด์•ผ ํ•ด ๐Ÿ’ช

์ด๋Ÿฐ ๋ณต์žกํ•œ ๊ฐœ๋ฐœ ์ง€์‹์ด ํ•„์š”ํ•  ๋•Œ, ์žฌ๋Šฅ๋„ท์—์„œ ๊ตฌ๋… ์„œ๋น„์Šค ๊ฐœ๋ฐœ ๊ฒฝํ—˜์ด ์žˆ๋Š” ์ „๋ฌธ ๊ฐœ๋ฐœ์ž๋ฅผ ์ฐพ์•„๋ณด๋Š” ๊ฒƒ๋„ ์ข‹์€ ๋ฐฉ๋ฒ•์ด์•ผ!
ํ˜ผ์ž ๋‹ค ํ•˜๊ธฐ ํž˜๋“ค ๋•Œ๋Š” ๋„์›€์„ ๋ฐ›๋Š” ๊ฒƒ๋„ ํ˜„๋ช…ํ•œ ์„ ํƒ์ด๊ฑฐ๋“  ๐Ÿ˜Š

์ž, ์ด์ œ ์ง„์งœ ๊ตฌ๋… ์„œ๋น„์Šค ๋งŒ๋“ค๋Ÿฌ ๊ฐ€๋ณด์ž๊ณ ! ํ™”์ดํŒ…! ๐Ÿš€๐Ÿ”ฅ

๐Ÿ’ก ๋งˆ์ง€๋ง‰ ํŒ! ๊ตฌ๋… ์„œ๋น„์Šค๋ฅผ ์ฒ˜์Œ ๋งŒ๋“ ๋‹ค๋ฉด ์ฒ˜์Œ๋ถ€ํ„ฐ ์™„๋ฒฝํ•˜๊ฒŒ ๋งŒ๋“ค๋ ค๊ณ  ํ•˜์ง€ ๋งˆ. MVP๋กœ ๋น ๋ฅด๊ฒŒ ์ถœ์‹œํ•˜๊ณ , ์‹ค์ œ ์‚ฌ์šฉ์ž ํ”ผ๋“œ๋ฐฑ์„ ๋ฐ›์œผ๋ฉด์„œ ๊ฐœ์„ ํ•ด๋‚˜๊ฐ€๋Š” ๊ฒŒ ํ›จ์”ฌ ํšจ์œจ์ ์ด์•ผ. ์™„๋ฒฝํ•œ ์‹œ์Šคํ…œ๋ณด๋‹ค ๋™์ž‘ํ•˜๋Š” ์‹œ์Šคํ…œ์ด ๋จผ์ €์•ผ! ใ…‹ใ…‹ใ…‹ ๐Ÿ’ช
๋Œ“๊ธ€ ์ž‘์„ฑ

์ด ๊ธ€์— ๋Œ€ํ•œ ์—ฌ๋Ÿฌ๋ถ„์˜ ์ƒ๊ฐ์„ ๋“ค๋ ค์ฃผ์„ธ์š”

๋Œ“๊ธ€ 0
๋Œ“๊ธ€์„ ๋ถˆ๋Ÿฌ์˜ค๋Š” ์ค‘์ž…๋‹ˆ๋‹ค.

์•„์ง ๋Œ“๊ธ€์ด ์—†์Šต๋‹ˆ๋‹ค.