​

Safe Mass Operations, Visual Diff Staging & Rollback 🛡️

┌─────────────────────────────────────────────────────────────────────────────┐
│ 💬 TELEGRAM CHAT PROMPT:                                                    │
│ "Apply a 15% discount on all Winter Jackets with stock > 5 units and        │
│ generate catchy AI SEO product descriptions"                                │
├─────────────────────────────────────────────────────────────────────────────┤
│ 🤖 WOOPILOT AI RESPONSE:                                                    │
│ 🛡️ I have staged 28 product modifications. Inspect the changes below:     │
│ [ 🔍 Review & Apply Changes (28 items) ] <-- (Opens TMA Visual Diff)       │
└─────────────────────────────────────────────────────────────────────────────┘

​

🧭 How Visual Diff Staging & Rollback Works

​

🔍 Key Safety Guarantees

1. High-Contrast Visual Diff (~~Old~~ ➔ New):
   • Unaltered metadata (ID, SKU, Title) is locked to the left.
   • Modified fields are highlighted on the right with clear strikethrough comparison badges: ~~$120.00~~ ➔ $102.00.
2. Optimistic Concurrency Control & Conflict Detection:
   • Before applying any mutation, WooPilot AI runs a pre-flight verification against your live store database.
   • If a product’s price, stock, or status changed in WooCommerce while the staging card was awaiting approval (e.g. by another store manager or sales sync), an interactive Conflict Warning appears.
   • You can choose to Refresh Table (re-calculating values on live data with zero AI token cost) or Overwrite Anyway.
3. 1-Click Rollback & Untrash Recovery:
   • Every executed mutation artifact stores an exact deterministic inverse patch in PostgreSQL.
   • If you want to revert a promotional repricing or undo an accidental bulk edit, tap Rollback in the Mini App (0ms AI generation delay, 0 token spend).
   • Deleted products, variations, or orders moved to the WordPress trash are cleanly restored via the dedicated untrash gateway (WooPilot_REST_Untrash), recovering true original statuses (publish, draft) and purging temporary trash meta.
4. Chunked Execution (50 items / 100ms):
   • Large operations (e.g. 500+ items) are executed in non-blocking batches of 50 items with 100ms pauses to prevent PHP script timeouts or server CPU spikes.
5. Official WooCommerce API Execution (rest_do_request):
   • Mutations are never executed via raw SQL. They pass through official WooCommerce REST controllers in memory, guaranteeing that stock status changes, HPOS synchronizations, cache invalidations, and native hooks fire cleanly.
6. Stepper Multi-Step Sequences:
   • Complex workflows (Step 1: Set discount $\to$ Step 2: Move items to Sale category) are organized into structured Stepper sequences, guiding you step-by-step with live checklist updates in Telegram (🔘 ➔ ✅).

​

💬 Example Bulk Actions

​

1. Catalog & Pricing Operations

"Increase prices by 8% across all products in 'Supplements' and round to .99"
"Move out-of-stock items (stock = 0) older than 6 months into Draft status"
"Add tag 'Summer-Sale' to all items with regular_price > $50 and stock > 10"

​

2. Order Workflow & Status Management

"Change status to 'Completed' for all Processing orders with tracking numbers"
"Add private note 'Fraud Check Passed' to all orders from today > $500"

​

3. Coupon & Promotional Generation

"Create a 20% discount coupon 'VIP-MARCH' valid for 5 days with minimum spend $100"
"Generate a personal $10 fixed cart coupon for customer@email.com expiring in 48 hours"