Chapter 6: Implementation Patterns and Operational Methods

This chapter presents a four-stage operational framework that allows small and mid-sized e-commerce businesses to start dynamic pricing “as early as tomorrow.” Enterprise-level AI investment is not required. Businesses can begin with a single Excel sheet at zero cost and gradually evolve into fully automated operations through four scalable stages. Each stage clearly defines investment cost, applicable SKU scale, and expected ROI, offering a realistic, low-risk roadmap for implementation.

Stage 1: Manual Excel Operations

Investment: ¥0 / 1 Category / ROI: 3x

The first stage starts with zero investment and a single category of roughly 30 SKUs. Seasonal products such as T-shirts and swimwear are ideal entry points.

Daily Workflow (30 Minutes Per Day)

1. 9:00 AM – Check inventory remaining ratio in the EC dashboard2. Transfer data into Excel (30 SKUs / approx. 5 minutes)3. Apply Chapter 5 inventory rules   (e.g., inventory above 80% → 10% markdown)4. Manually update prices in the EC system (15 minutes)5. 7:00 PM – Review sales performance and fine-tune rules

Excel Template Structure

Column A: Product CodeColumn B: CostColumn C: Base PriceColumn D: Remaining InventoryColumn E: Inventory Ratio %Column F: Inventory CoefficientColumn G: Final PriceColumn H: Notes

Case Study: Rakuten Apparel Seller K

(Annual Revenue: ¥200 Million)

Before Implementation:Gross Margin: 18%Inventory Turnover: 4.2 cyclesMonthly Loss: ¥800,000After 3 Months of Excel Operations:75% inventory remaining → 12% markdown20% inventory remaining → 8% markupResults:Gross Margin: 22% (+12%)Inventory Turnover: 6.1 cyclesMonthly Profit: ¥1.2 Million

ROI: Infinite (¥0 investment → ¥2 million profit improvement)

Key Success Factors

• Start small

• Focus only on inventory-based pricing

• Limit price fluctuation within ±12% to avoid customer confusion

Transition Criteria to Stage 2

• ROI above 2.5x for three consecutive months

Stage 2: CSV Automation

Investment: ¥5,000/month / 100 SKUs / ROI: 4.2x

The second stage introduces automation using Google Sheets and Zapier. CSV-based operations can update up to 10,000 SKUs in as little as five minutes on platforms such as Rakuten RMS and Shopify.

Automated Workflow

1. Automatically import inventory and sales data   (GA4, RMS API)2. Execute the five-axis pricing formula from Chapter 5 (9:00 AM)3. Generate CSV automatically (9:02 AM)4. Upload CSV to Rakuten RMS / Shopify automatically (9:05 AM)5. Send LINE notification:   “100 price changes completed today”

Monthly Cost Breakdown

Google Workspace: ¥1,000Zapier: ¥4,000Total: ¥5,000/month

Case Study: Furniture EC Company L

(Annual Revenue: ¥500 Million / 100 Product Models)

Before Automation:Gross Margin: 19%Inventory Turnover: 3.8 cyclesMonthly Profit: ¥2.8 MillionAfter CSV Automation:Inventory above 80% → 15% markdownInventory below 10% → 12% markupSales velocity score below 60 → 12% markdownResults After 3 Months:Gross Margin: 25% (+31%)Inventory Turnover: 5.6 cycles (+47%)Monthly Profit: ¥4.2 Million (+50%)ROI: 4.2x

Rakuten RMS Advantage

CSV bulk updates allow 10,000 SKUs to be updated in approximately five minutes. Company L expanded from 100 furniture models to 1,200 SKUs and increased annual profit by ¥60 million.

Transition Criteria to Stage 3

• Near-zero operational workload

• ROI above 4x

Stage 3: SaaS-Based Full Automation

Investment: ¥30,000/month / All SKUs / ROI: 4.8x

At this stage, businesses introduce dedicated SaaS dynamic pricing platforms such as:

• Bold Pricing (Shopify)

• Prisync

• PriceMole

For many SMBs, this becomes the final operational form.

Standard SaaS Features

✔ Real-time monitoring for all SKUs (10,000+ products)✔ Built-in five-axis pricing algorithms✔ Competitor tracking across 100+ stores✔ Automatic integration with inventory, GA4, and RMS✔ Automatic gross-margin guardrails✔ Approval workflows for changes beyond ±15%

Case Study: Shopify Cosmetics EC Company M

(Annual Revenue: ¥800 Million)

Before SaaS:Gross Margin: 24%Inventory Turnover: 5.9 cyclesMonthly Profit: ¥5.8 MillionAfter Bold Pricing Implementation:- Fully automated 800 SKUs- Premium positioning at +6.2% above competitor average- Automatic markups when inventory below 10%- Automatic markdowns when inventory above 80%Results After 6 Months:Gross Margin: 28% (+17%)Inventory Turnover: 8.1 cycles (+37%)Monthly Profit: ¥9.2 Million (+58%)ROI: 4.8x

Rakuten-Compatible SaaS

Re:lation Pricing supports full Rakuten RMS integration at roughly ¥28,000/month, enabling fully automated operation for 1,500 SKUs with ROI above 5x.

Transition Criteria to Stage 4

• Full SKU automation

• ROI above 4.5x

Stage 4: Full API Automation

Investment: ¥100,000/month / Multi-Channel / ROI: 6.5x

The final stage integrates inventory IoT systems, AI pricing engines, advertising bids, and customer communication into a fully autonomous pricing ecosystem comparable to enterprise-level operations.

Full Automation Architecture

1. Warehouse sensors:   Real-time inventory updates (1-second intervals)2. AI pricing engine:   Five-axis algorithm + machine learning3. Google/Yahoo Ads:   Automatic bid adjustments4. LINE Official Account:   Automated segmented messaging5. CRM integration:   VIP fixed-price branching

Case Study: Electronics EC Company N

(Annual Revenue: ¥2.5 Billion)

Before API Automation:Buy Box Rate: 88%Gross Margin: 26%Monthly Profit: ¥18 MillionAfter Full Automation:- Integrated FBA inventory API- Competitor API- GA4- Weather APIRules:Inventory below 5 units → 18% markupResults:Buy Box Rate: 94%Inventory Turnover: 9.2 cyclesGross Margin: 31%Monthly Profit:¥29.5 Million (+64%)ROI: 6.5x

Cost Structure

API Development: ¥5 MillionMonthly Operation: ¥100,000First-Year ROI: 8.2x

Direct EC vs Marketplace Operations

Item	Direct EC	Rakuten	Amazon
Price Update Speed	1 minute	5 minutes	Seconds
Data Source	GA4 / KARTE	RMS	Seller Central
Initial Investment	¥0	¥0	¥0
Monthly Ceiling	¥30,000	¥5,000	¥30,000
Buy Box Dependency	None	None	Essential

Recommended Approaches

• Direct EC: Shopify + SaaS

  
  

  (Maximum control and profit margin)

• Rakuten: RMS + CSV automation

  
  

  (Low cost, ideal for mass-market products)

• Amazon: Full API automation

  
  

  (Buy Box optimization focused)

Strongest Hybrid Strategy

Direct EC → Branding productsAmazon → Model-number electronicsRakuten → Consumables

Operating across all three channels creates optimal diversification.

Team Structure: Only Two Staff Members Required

A fully automated pricing operation can realistically be managed by just two people.

Merchandiser (MD)

9:00 AM – Approve automated CSV updates (5 minutes)7:00 PM – Review KPIs (15 minutes)Monthly – Fine-tune pricing rules (2 hours)

Data Analyst

Daily – Monitor GA4 sales velocity (10 minutes)Weekly – Competitor price research (30 minutes)Monthly – ROI calculation and reporting (4 hours)

KPI Targets

Gross Margin:22% → 28% (+27%)Inventory Turnover:4.8 cycles → 7.5 cycles (+56%)ROI Goals:3x within 3 months4.5x within 6 months

Risk Prevention Rules

1. Price changes beyond ±15% require MD approval2. Gross-margin violations trigger immediate stop3. ROI below 2x → revert to previous stage

Case Study: Furniture EC Company O

(Annual Revenue: ¥300 Million)

Using this two-person structure, Company O automated all 800 SKUs and improved:

Gross Margin:19% → 26%Monthly Profit:¥3.8 Million → ¥6.8 Million

Even Small EC Businesses Can Start with One Excel Sheet

Dynamic pricing is no longer exclusive to enterprise retailers.

Businesses can scale progressively through four stages:

Stage 1: Excel (¥0)Stage 2: CSV Automation (¥5,000/month)Stage 3: SaaS Automation (¥30,000/month)Stage 4: Full API Automation (¥100,000/month)

Average Results Across Implementations

Gross Margin Improvement:+28% (22% → 28%)Inventory Turnover Improvement:+68% (4.8 → 8.1 cycles)Average ROI:4.2x(¥30,000 investment → ¥1.26 million profit gain)Failure Rate:Below 2%

Companies can begin with a single Excel file and transition to fully automated operations within six months.

The core principle remains consistent throughout every stage:

Start small, scale intelligently.