shopify-admin-skills

Aggregate abandoned checkout data for a time range, broken down by cart value bucket and hour of day (UTC).

Read-only: identifies products with high single-purchase rates that could benefit from cross-sell pairing based on category and price affinity.

Compare redemption rates and revenue performance across two or more discount codes over a specified date range.

Read-only: calculates the true ROI of each discount code and automatic discount by comparing incremental revenue against discount cost.

Read-only: mines order history to find product pairs and triplets frequently purchased together, generating cross-sell and bundle recommendations.

Issue Shopify gift cards (store credit) to customers as a goodwill gesture, post-return incentive, or loyalty reward.

Read-only: extracts gift messages, gift recipients, and gift flags from order custom attributes and notes for fulfillment teams to print on packing slips.

Read-only: identifies orders 7–14 days post-fulfillment that are eligible for a post-purchase survey campaign, excluding refunded or cancelled orders.

Rank products by revenue, units sold, and refund rate over a date range by aggregating order line items.

Report sessions, conversion rate, and bounce rate for every product and collection page using Shopify's analytics API — surfaces which pages earn eyeballs and which convert them.

Read-only: lists B2B company accounts with locations, catalogs, and payment terms for wholesale management.

Identifies customers with disputed or charged-back orders and tags their customer record for proactive review on future orders.

Read-only: scores customers by churn probability based on purchase recency, frequency decay, and expected repurchase intervals.

Read-only: estimates customer acquisition cost (CAC) per traffic source by joining order count per landing site / referrer with configurable ad spend.

Read-only: groups customers by first-purchase month and tracks repeat purchase rate and revenue per cohort.

Adds internal notes to customer records in bulk — useful for post-campaign flags, import annotations, or support context.

Calculates lifetime spend per customer and applies tier tags (Bronze/Silver/Gold/Platinum) based on configurable thresholds.

Read-only: finds likely duplicate customer records by matching email, phone, or name combinations.

Read-only: scans the customer database for malformed emails, role accounts, disposable domains, and bounce-suspect patterns to protect sender reputation.

Read-only: audits email and SMS marketing consent status across the customer base for compliance and segmentation.

Read-only: scores every customer on Recency, Frequency, and Monetary value to segment them into actionable groups (Champions, Loyal, At-Risk, Lost).

Update the shipping address on an unfulfilled order before it ships.

Adds and/or removes tags across a filtered set of customers — supports query-based selection, explicit ID lists, and union/replace tag modes.

Merges duplicate customer records: invokes Shopify's native customer merge API where supported, otherwise consolidates the loser record's tags and notes into the winner via customerUpdate.

Read-only: exports a complete chronological history for a single customer — orders, refunds, returns, addresses, notes, tags, marketing consent, and lifetime spend — as one consolidated CSV.

Retrieve and summarize full order details for a customer by email, order number, or phone number.

Process a full or partial refund on an order and optionally create a replacement draft order for the customer.

Create a formal Shopify Return record for an order, specifying line items, quantities, and return reason — the first step in the native returns workflow.

Identify orders at risk of generating WISMO support tickets: shipped orders with stale tracking, and unfulfilled orders past their SLA window.

Read-only: tracks AOV over time buckets and segments by new vs. returning customers.

Read-only: tracks total discount dollars given over configurable time buckets (week/month/quarter), broken down by discount type and code.

Read-only: lists all active gift cards with remaining balance, expiry, and last-used date for liability tracking.

Read-only: calculates total outstanding gift card balance as a financial liability, broken down by issue cohort and remaining balance band.

Read-only: reconciles Shopify Payments payouts against the order transactions that funded them and flags amount discrepancies.

Read-only: calculates true net profit per order and per product by factoring in COGS, shipping costs, transaction fees, discounts, refunds, and taxes.

Read-only: calculates refund rate by product, collection, or period — identifies quality and listing issues.

Read-only: breaks down revenue by fulfillment location for multi-warehouse P&L and location performance.

Read-only: breaks down revenue, units, and AOV by sales channel (Online Store, POS, Draft Orders, etc.).

Read-only: aggregates shipping revenue charged to customers vs. actual shipping line costs by carrier and method.

Read-only: for stores with subscription products, calculates MRR, ARR, active subscriber count, and rolling churn rate from subscription contracts.

Read-only: aggregates tax collected by jurisdiction from order tax lines for filing prep.

Batch-fulfill open fulfillment orders with tracking numbers. Supports partial fulfillment and customer notification toggle.

Read-only: for native bundle products and metafield-defined bundles, verifies every component variant has sufficient stock to fulfill the bundle's effective availability.

Cancel an unfulfilled order, optionally restock inventory, and optionally notify the customer — all in a single validated workflow.

Read-only: compares delivery times and shipping costs across carriers used in fulfillments to inform carrier mix and contract decisions.

Read-only: calculates average time from fulfillment creation to delivery by carrier using fulfillment and order data.

Reassign fulfillment orders from one location to another for warehouse overflow or regional routing.

Generate a daily fulfillment triage digest: all open orders segmented by fulfillment age and flagged for holds or exceptions.

Place or release fulfillment holds on open orders in batch — with a stated reason and optional expiry date.

Read-only: walks every delivery profile and zone to verify each has at least one valid shipping rate, surfacing zones with no rates or only manual rates.

Splits a multi-line fulfillment order into separate shipments for partial or location-specific shipping.

Batch-update tracking numbers and URLs on existing fulfillments when a carrier reassigns tracking IDs.

Query checkouts abandoned in the last N days, generate unique discount codes per customer, and tag them for re-engagement.

Identify customers who have not ordered in N days, export a re-engagement list, and tag them in Shopify.

Identify high-LTV customers by order count and lifetime spend, tag them, and export a loyalty-ready contact list.

Bulk-creates a batch of unique discount codes for campaigns, giveaways, or partner distributions — each code is its own DiscountCodeBasic with single-use limit by default.

Read-only: parses each order's landing site and referrer URL to break down orders, revenue, and AOV by traffic source — direct, organic, paid, social, email, or referral domain.

Identifies top-spending customers (top N% by lifetime value or order frequency) and exports a VIP candidate list; optionally tags qualified customers as VIPs.

Query products by collection or tag and update all variant prices by a percentage or fixed amount, with optional floor/ceiling constraints.

Read-only: identifies products and variants that are missing inventoryItem.unitCost so margin and inventory valuation reports stay accurate.

Read-only: lists orphan products (in zero collections) and over-collected products for catalog hygiene.

Reorder products in a manual Shopify collection by inventory level, moving in-stock products to the top and out-of-stock to the bottom.

Removes stale compareAtPrice values where current price >= compareAtPrice (no real discount) or compareAtPrice has been set for over a configurable age threshold.

Read-only: cross-references inventory levels with order velocity to flag items with positive stock but zero sales in N days.

Read-only: forecasts demand per SKU using sales velocity and seasonality, then calculates reorder points and suggested purchase order quantities.

Read-only: finds duplicate SKUs or barcodes across all product variants.

Apply inventory quantity adjustments to specific variants at specific locations — after a cycle count, 3PL return batch, or sync discrepancy correction.

Read-only: categorizes inventory into aging buckets (0-30, 31-60, 61-90, 90+ days) based on time since last sale or receipt.

Moves inventory units from one location to another by decrementing the source and incrementing the destination.

Read-only: calculates total inventory value (quantity × cost) per location and per vendor for accounting and insurance.

Query all tracked product variants below a stock threshold and export a restock list grouped by vendor.

Bulk set or delete metafields on products, variants, or customers filtered by tag or collection.

Audit inventory levels across all active locations, flagging variants where Available quantity is negative or Committed exceeds On Hand — a signal of inventory sync drift.

Read-only: analyzes the relationship between product pricing and sales velocity to identify optimal price points and price-sensitive products.

Read-only: scores each product on data completeness across description, images, SEO, weight, barcode, cost, and metafields.

Read-only: flags products and variants with missing images or fewer than a minimum number of images.

Bulk transition products through DRAFT → ACTIVE → ARCHIVED status for seasonal launches and sunsetting.

Add or remove tags on all products matching a collection, existing tag, or search query — for campaign setup, teardown, or catalog organization.

Read-only: scans products, collections, and pages for missing SEO titles or meta descriptions.

Read-only: calculates days-of-supply and sell-through rate per SKU and location for replenishment planning.

Detects inconsistent variant option naming (Sm vs Small vs S) and bulk-corrects to a standard set.

Rank every product variant by revenue, units sold, and refund rate, then cross-reference against current inventory to identify dead weight vs. top performers.

Read-only: detects vendor field typos, casing variants, and trailing-whitespace duplicates across the catalog and proposes a canonical merge per cluster.

Mutation: applies tags to orders based on configurable rules (geography, value, product type, risk level, customer tier).

Tags orders flagged as high-risk for manual review and optionally places fulfillment holds to prevent shipping.

Read-only: parses UTM source/medium/campaign from order landing site URLs to attribute revenue, AOV, and conversion volume to marketing channels.

Read-only: tracks cancellation rate over time and breaks down cancelled orders by cancelReason to surface fraud, inventory, customer, and declined-payment patterns.

Read-only: extracts and tabulates order notes and custom attributes for ops review of gift messages and special instructions.

Read-only: lists orders by fraud risk level with indicator details for building a manual review queue.

Read-only: surfaces orders with multiple partial refunds or unusually high partial-refund-to-total ratios that may indicate fraud, chronic complaints, or process gaps.

Mine order history to find which products are most frequently bought together, then rank pairs by support, confidence, and lift to power bundles and cross-sell recommendations.

Read-only: calculates what percentage of customers place 2+ orders within N days, segmented by product or collection.

Read-only: tracks what percentage of returns become exchanges vs. refunds vs. store credit — measures revenue recovery rate.

For approved/closed returns, restocks inventory at the return location by adjusting on-hand quantities for each returned line item.

Read-only: calculates the true cost of returns by reason and product — refund dollars, restocking impact, shipping cost lost, and COGS impact for items written off.

Read-only: identifies customers with abnormal return behavior — high return rate, wardrobing patterns, or serial returner profiles — for manual review.

Read-only: measures average time from return request to refund completion, surfacing SLA breaches.

Read-only: aggregates return reasons across orders to identify product quality or listing issues.

Finds expired, zero-usage, or duplicate discount codes and optionally deactivates or deletes them.

Finds stale draft orders older than N days and optionally deletes them to reduce admin clutter.

Read-only: lists every file in CDN storage, cross-references usage on products, pages, and articles, and flags orphaned/unreferenced assets.

Read-only: enumerates every metafield definition across all owner types and flags unused, undocumented, or duplicate-key definitions.

Read-only: lists all pages and blog posts, flags empty or short content and missing SEO fields.

Read-only: shows which products are published to which sales channels and flags unpublished active products.

Read-only: reviews staff accounts for stale logins, inactive status, and overpermissioned roles to surface security and access hygiene issues.

Read-only: lists all URL redirects, flags redirect chains (A→B→C) and duplicate targets.