Dropshipping Integration

Dropshipping Integration

Overview

A dropshipping integration routes customer orders automatically to supplier warehouses, syncs supplier inventory to your storefront, and tracks your margin on every sale. Done right, customers receive their products on time without you ever touching physical inventory. Done poorly, oversells and fulfillment failures destroy your reputation.

This skill walks through setting up dropshipping on your platform using the right tools, then covers custom/headless implementations for those building from scratch.

When to Use This Skill

• When launching a store without physical inventory by routing orders directly to supplier warehouses
• When adding a dropship-fulfilled product category alongside your own inventory
• When building a multi-supplier routing engine that picks the best supplier per order based on price, stock, or location
• When you need to keep your storefront inventory in sync with supplier availability feeds (CSV, EDI, API)
• When tracking dropship margins for accounting and vendor performance reporting

Core Instructions

Step 1: Determine your platform and choose the right integration approach

Step 2: Set up inventory sync

Keeping your storefront stock levels in sync with supplier availability is the most critical piece — oversells damage customer trust immediately.

Shopify

Using DSers (AliExpress dropshipping): 1. Install DSers from the Shopify App Store 2. Connect your AliExpress account in DSers settings 3. Import products from AliExpress via DSers → Products → Import 4. DSers syncs stock levels automatically every few hours 5. Enable "Auto-update inventory" in DSers → Settings → Supplier to push supplier stock to Shopify inventory

Using Spocket (US/EU suppliers): 1. Install Spocket from the Shopify App Store 2. Browse the Spocket marketplace and import products to Shopify 3. Spocket syncs inventory changes automatically — no manual configuration needed 4. Enable "Auto-fulfill orders" in Spocket settings to route new Shopify orders to suppliers automatically

Using AutoDS (multi-supplier): 1. Install AutoDS from the Shopify App Store 2. Add suppliers (AliExpress, Amazon, Walmart, etc.) and import their products 3. AutoDS monitors supplier prices and stock, updating your Shopify listings automatically 4. Configure price rules in AutoDS → Settings → Price Rules to set your markup automatically

WooCommerce

Using AliDropship plugin: 1. Purchase and install the AliDropship plugin 2. Use the Chrome extension to import products from AliExpress directly into WooCommerce 3. Enable automatic price and inventory updates in AliDropship → Settings → Auto-update 4. For order routing: AliDropship auto-places orders on AliExpress when you approve them in the plugin dashboard

For non-AliExpress suppliers: 1. Install the WooCommerce Zapier extension or use n8n (free, self-hosted) to connect WooCommerce order webhooks to supplier systems 2. Go to WooCommerce → Settings → Advanced → Webhooks, create a webhook for "Order created" events 3. Point the webhook URL at your automation workflow (Zapier/n8n) that formats and forwards the order to your supplier 4. For inventory sync, schedule a daily WP-Cron job to pull the supplier's CSV feed and update WooCommerce stock via the REST API

BigCommerce

Using Modalyst: 1. Install Modalyst from the BigCommerce App Marketplace 2. Browse Modalyst's supplier catalog and import products to BigCommerce 3. Modalyst handles inventory sync and order routing automatically once connected

Using Spocket: 1. Install Spocket from the BigCommerce App Marketplace 2. Import products and enable auto-fulfillment in Spocket settings 3. New orders with Spocket products are routed to suppliers automatically

Custom / Headless

For headless storefronts, build a supplier integration layer:

// Supplier product and inventory schema
interface SupplierProduct {
  supplierId: string;
  supplierSku: string;       // supplier's own SKU
  internalProductId: string; // your product ID
  costPriceCents: number;    // what you pay the supplier
  stockQty: number;
  lastSyncedAt: Date;
}

// Route an order line to the best available supplier
async function selectBestSupplier(
  productId: string,
  requiredQty: number
): Promise<SupplierProduct | null> {
  // Pick the cheapest in-stock supplier with enough quantity
  return db.supplierProducts.findOne({
    internal_product_id: productId,
    stock_qty: { gte: requiredQty },
    is_active: true,
  }, { orderBy: ['cost_price_cents', 'asc'] });
}

// Sync supplier inventory from CSV feed
async function syncSupplierInventoryFromCsv(
  supplierId: string,
  csvContent: string
): Promise<void> {
  const rows = parseCsv(csvContent); // [{sku, qty, cost}]
  for (const row of rows) {
    await db.supplierProducts.upsert({
      supplier_id: supplierId,
      supplier_sku: row.sku,
      stock_qty: parseInt(row.qty),
      cost_price_cents: Math.round(parseFloat(row.cost) * 100),
      last_synced_at: new Date(),
    });
  }
  // Zero out SKUs not in the feed (discontinued)
  const activeSKUs = new Set(rows.map(r => r.sku));
  const allProducts = await db.supplierProducts.findBySupplierId(supplierId);
  for (const sp of allProducts) {
    if (!activeSKUs.has(sp.supplier_sku)) {
      await db.supplierProducts.update(sp.id, { stock_qty: 0 });
    }
  }
}

// Submit a dropship order to a supplier API
async function submitDropshipOrder(params: {
  supplierApiEndpoint: string;
  supplierApiKey: string;
  orderReference: string;
  shippingAddress: Address;
  items: { supplierSku: string; quantity: number }[];
}): Promise<string> {
  const response = await fetch(params.supplierApiEndpoint + '/orders', {
    method: 'POST',
    headers: {
      'Authorization': `Bearer ${params.supplierApiKey}`,
      'Content-Type': 'application/json',
    },
    body: JSON.stringify({
      reference: params.orderReference,
      ship_to: params.shippingAddress,
      items: params.items,
    }),
  });
  if (!response.ok) throw new Error(`Supplier API error: ${response.status}`);
  const result = await response.json();
  return result.order_id; // supplier's order reference
}

Step 3: Configure automated order routing

Shopify

• DSers: Go to DSers → Settings → Automatic Actions and enable "Auto-sync tracking number to Shopify" and "Auto-fulfill Shopify orders"
• AutoDS: Enable Auto-Orders in AutoDS → Settings. Orders paid in Shopify are automatically placed with the supplier, and tracking numbers sync back to Shopify fulfillments
• If a supplier order fails (out of stock), DSers and AutoDS alert you via email so you can manually reroute

WooCommerce

• For AliDropship: approved orders in the AliDropship dashboard are auto-placed. Go to AliDropship → Orders and confirm pending orders, or enable full automation in settings
• For custom supplier integrations: use the WooCommerce webhook to trigger your supplier order submission, then use a second webhook or polling to receive tracking numbers and mark orders fulfilled via the WooCommerce REST API (POST /wp-json/wc/v3/orders/{id})

BigCommerce

• Modalyst and Spocket both handle order routing automatically. Monitor BigCommerce → Orders and check the "Fulfillment" column — orders routed to suppliers show the supplier name
• For tracking numbers: both apps sync tracking back to BigCommerce orders automatically and trigger BigCommerce's built-in shipment notification emails

Step 4: Track dropship margins

Margin tracking is critical — your cost price can drift from your selling price without you noticing.

Shopify

• Use the Shopify Analytics → Profit report (requires entering your costs in Shopify admin)
• Go to each product's variant in Shopify admin and enter the "Cost per item" — Shopify calculates margin automatically
• For multi-supplier tracking: export orders and costs from DSers/AutoDS and use a Google Sheet or QuickBooks to calculate margin per order

WooCommerce

• Install the WooCommerce Cost of Goods plugin (SkyVerge) to track per-product costs and automatically calculate margin in WooCommerce reports
• AliDropship shows cost vs. selling price in its analytics dashboard

BigCommerce

• Enter cost prices on each product variant in BigCommerce admin → Products → [Product] → Variants → Cost
• BigCommerce's built-in Insights report (available on Plus and above) shows margin by product

Best Practices

• Sync inventory at least every 4 hours — supplier stock changes frequently; for high-velocity SKUs, sync every hour if the supplier's API allows it
• Keep a stock buffer — don't sell the last 3–5 units per supplier; stock can change between sync cycles and your "in stock" data may be stale
• Store the supplier's order reference — always save the supplier's order confirmation number so customer service can contact the supplier directly about specific shipments
• Track lead times per supplier — different suppliers have different fulfillment speeds; display accurate delivery estimates by using each supplier's lead time, not a generic estimate
• Send tracking numbers to customers as soon as the supplier ships — most supplier apps sync tracking automatically; enable this in your app settings and test it with a sample order
• Reconcile supplier invoices monthly — compare what you were charged against what you recorded at order time; pricing discrepancies accumulate into meaningful losses

Common Pitfalls

Related Skills

• @order-fulfillment-workflow
• @vendor-management
• @shipment-tracking
• @multi-channel-selling
• @order-management-system

Dropshipping Database Schema

Problem/Feature Description

A growing home goods retailer is expanding into dropshipping to offer a wider product range without holding additional inventory. The engineering team needs to design the persistence layer for this new dropshipping capability. The store already has products and orders tables in PostgreSQL.

The dropshipping system needs to track: which suppliers exist and how to connect with them, which products each supplier can fulfill (along with their own internal SKU references and pricing), and the lifecycle of orders that have been routed to suppliers for fulfillment. Suppliers use a variety of integration methods — some have REST APIs, others use email, EDI, or CSV files over FTP. API credentials must be stored securely. The schema should also support computing accurate delivery estimates for customers based on each supplier's typical fulfillment time.

Output Specification

Write a SQL migration file named migration.sql containing the CREATE TABLE statements for all the new dropshipping-related tables. Use PostgreSQL syntax. Add comments where appropriate to explain design decisions, especially around sensitive fields and data types.

Dropship Inventory Sync and Margin Reporting

Problem/Feature Description

A sporting goods retailer has been running a dropshipping operation with multiple suppliers for six months. Some suppliers provide their inventory data through a REST API, while others upload a CSV file to an FTP server each morning. The ops team has been burned twice recently: once when a product showed as available on the storefront but the supplier had already sold out (the inventory sync was too infrequent), and once when a product was discontinued by a supplier but continued to show in-stock because the old record was never cleared.

The finance team also needs a monthly vendor performance report showing gross margin by supplier so they can negotiate better pricing with underperforming partners. The existing codebase already has database access helpers (a db object), an downloadFtpFile(ftpConfig, filename) utility, and a decryptApiKey(encryptedKey) function available.

Output Specification

Produce the following files:

1. inventorySync.ts — A TypeScript module implementing:

• A syncSupplierInventory(supplierId) function that handles both API and CSV/FTP feed sources
• A scheduled job that automatically syncs all active suppliers on a regular cadence

2. marginCalculation.ts — A TypeScript module implementing:

• A calculateDropshipMargin(orderId) function that returns revenue, cost, gross margin in cents, and gross margin percentage for a given order

3. marginReport.sql — A SQL query that produces a per-supplier margin summary, returning supplier name, order count, total revenue, total cost, gross margin amount, and gross margin percentage. Only include fulfilled orders and limit to recent activity.

You may use stub database access patterns (e.g., db.suppliers.findAll(...), db.raw(...)) for the TypeScript code.

Supplier Order Routing Engine

Problem/Feature Description

A furniture retailer operates a dropshipping model with five active supplier partners. When a customer places an order containing multiple products, each product may be fulfilled by a different supplier depending on who has stock and at what cost. The platform needs a routing engine that automatically assigns each order line to the best available supplier and then dispatches the order to that supplier through whatever integration method the supplier supports.

Some suppliers offer a REST API for order placement, while others use email. The company has experienced occasional timeouts when contacting supplier APIs, and a handful of duplicate orders have already been sent to suppliers as a result of retry attempts — causing costly double-shipments to customers. Supplier API credentials are sensitive and must not be used or stored in plaintext anywhere in the codebase.

Output Specification

Write a TypeScript module named orderRouting.ts that exports:

1. A selectBestSupplier(productId, requiredQty) function that picks the optimal supplier for a given product and required quantity 2. A routeOrderToSupplier(orderId) function that groups all order lines and creates the appropriate dropship order records 3. A submitDropshipOrder(dropshipOrderId) function that sends a pending dropship order to the supplier

You may use stub implementations for database access (e.g., a db object with methods like db.supplierProducts.findOne(...)) and for any helper functions like decryptApiKey or submitViaEmail. The logic and structure of the code is what matters.

Include a brief DESIGN.md explaining your approach to preventing duplicate submissions.