Unified Marketplace — Complete Operating Flow Guide

How Unified Marketplace Works

Discover how Unified Marketplace unifies product catalogs, automates multi-warehouse inventory tracking, processes orders and shipping labels, inspects returns, and tracks true net profit across Amazon, Shopify, Flipkart, Meesho, and Google Sheets.

Step 1: Integration & Setup

Connect Sales Channels & Google Sheets

Log in to Unified Marketplace and authorize your seller accounts in minutes. Connect Amazon India, Shopify, Flipkart, Meesho, and Google Sheets using secure OAuth 2.0 protocols.

One-click OAuth 2.0 connection for Amazon SP-API and Shopify.

Google Sheets integration for live catalog imports & automated reporting.

Telegram Deal Bot integration for instant CSV & deal image ingestion.

AES-256 encrypted credential storage ensuring bank-grade data privacy.

Connected ChannelsReal-Time Sync

Amazon India SP-API

Seller ID: IN_SELLER_8892

Active

Shopify Storefront

mystore.myshopify.com

Active

Google Sheets Live Sync

Master_Catalog_2026.xlsx

Syncing

Step 2: Catalog Management

Master Product Catalog & Spreadsheet Sync

Maintain a single master catalog for all product variants, prices, descriptions, and images. Pushing edits updates all active marketplace listings and Google Sheets spreadsheets simultaneously.

Create master SKU records once and push listings to multiple marketplaces.

Two-way live synchronization with connected Google Sheets spreadsheets.

Automated price updates and promotional category mapping across platforms.

Telegram Deal Bot parser extracts products from images & text descriptions.

Master Catalog EditorSynced (4 Channels)

Premium Cotton Polo Shirt₹1,299

SKU

TSHIRT-POLO-BLK

Amazon ASIN

B089XK92L

Google Sheet

Row #142

Step 3: Inventory Control

Multi-Warehouse 8-Bucket Stock Lock

Eliminate stockouts and overselling. Track quantities across physical warehouses in dynamic buckets: Available, Reserved, Outgoing, Returned, Damaged, In Transit, Write-off, and Quarantine.

Orders lock stock instantly in the Reserved bucket, preventing double-selling.

Manage multiple physical fulfillment centers & warehouse locations.

Automatic low stock alerts & buffer controls protect seller account health.

Scan barcodes to adjust stock quantities directly from warehouse floors.

Warehouse Stock BucketsCentral FC

SKU: SNEAKER-WHT-42Available: 240 units

Reserved: 35 unitsDamaged: 2 units

Step 4: Order Fulfillment

Central Order Feed & Camera Label Scanner

View every customer order from Amazon, Shopify, Flipkart, and Meesho in one unified feed. Print shipping labels, scan barcodes using your smartphone camera, and auto-crop label PDF margins.

Unified order feed with status filters: Pending, Packed, Out for Delivery, Delivered.

Browser-native camera barcode scanner for high-speed shipment verification.

Auto-crop shipping label utility for Flipkart, Amazon, and Meesho PDF batches.

Bulk manual order creation for direct WhatsApp & offline phone sales.

Order Verification ScannerCamera Ready

Barcode Scanned: #ORD-991204

Status: Matched with Order Item TSHIRT-POLO-BLK

Ready to Ship

Step 5: Reverse Logistics

Customer Return Intake & Inspection

Efficiently inspect returned customer packages. Classify items into restockable or damaged buckets, auto-updating online inventory and tracking return losses by seller channel.

Intake workflow for customer returns and RTO (Return to Origin) dispatches.

Quality control inspection to classify items into Restockable vs Damaged buckets.

Automatic inventory restoration for verified restockable products.

Analytics tracking return rates and financial write-offs per marketplace.

Return InspectionIntake Log

Return #RET-4091 (Amazon)Restocked

Item: Premium Cotton Polo Shirt (Black - L)

Action: Re-allocated to Available Inventory Bucket (+1)

Step 6: Profit & Loss Analytics

True Landed Margin & Profit Analytics

Calculate exact net profit across all sales channels. Automatically deduct marketplace commission fees, fixed closing charges, shipping costs, and return write-offs to view true earnings.

Channel profit & loss (P&L) breakdown by marketplace, SKU, and date range.

Automatic fee calculation deducting commission, shipping & return penalties.

Export financial performance reports to Google Sheets for team accounting.

Margin optimization recommendations to identify profitable product lines.

P&L Profit SummaryNet Margin: 28.4%

Total Net Profit

₹1,84,250

Gross Sales: ₹6,50,000 | Fees: ₹1,42,000 | COGS: ₹3,23,750

Frequently Asked Questions

Everything you need to know about using Unified Marketplace

Connecting your seller accounts takes less than 2 minutes. You log in to Unified Marketplace, click "Connect Channel" in Dashboard Settings, and authorize via secure OAuth 2.0.

Unified Marketplace connects to your Google account using OAuth. You can select any Google Sheet to import product catalogs or set up automated live synchronization so sales data and inventory levels update in real-time.

When an order is placed on Amazon, Shopify, or Flipkart, Unified Marketplace immediately places those items into the "Reserved" inventory bucket. This instantly reduces the "Available" quantity pushed to all other connected marketplaces.

Yes! Unified Marketplace features a browser-native camera scanner that runs directly on your smartphone, tablet, or desktop webcam without requiring expensive handheld hardware.

Yes. All marketplace API keys and tokens are encrypted with AES-256-GCM before database storage. We never store raw passwords or sell seller data.

Ready to streamline your e-commerce with Unified Marketplace?

Connect your marketplaces and Google Sheets to Unified Marketplace today. Start free with zero commitments.