Vendor inventory management for Shopify merchants who need clean stock decisions from messy supplier data.
PowerSync AI helps ecommerce teams connect Shopify, import their product catalog, add supplier sources, map supplier fields, match supplier SKUs to Shopify variants, and review safe inventory recommendations before anything can change in the store.
Products, variants, vendors, locations, SKUs, and inventory quantities.
CSV/XLSX now, with AI-assisted website, portal, email, drive, PDF, and feed architecture prepared.
Dry-run proposals first. Human review stays in control before any Shopify write action.
From scattered supplier data to safe Shopify inventory decisions.
PowerSync AI collects authorized vendor files, websites, portals, emails, and feeds, uses AI to extract inventory signals, validates every row, matches those rows to Shopify variants, and creates reviewable actions before any live update is allowed.
Products, variants, vendors, SKUs, barcodes, inventory item IDs, locations, and current quantities.
Extracts supplier evidence, validates structure, scores confidence, matches variants, and writes an audit trail.
Tenant-aware imports, mappings, matches, decisions, logs, policies, and review states.
Duplicate conflicts, unmatched rows, and low-confidence decisions are held for review.
Exactly what would change in Shopify, held for merchant review.
Missing SKUs, duplicate conflicts, stale supplier data, and risky stock moves.
Supplier health, inventory exposure, and AI recommendations.
Audit-ready holds show what would change without writing to Shopify.
Read authorized supplier sources and the Shopify catalog.
AI turns messy pages, files, and messages into normalized inventory rows.
Strict schema checks reject malformed data and mark weak evidence for review.
SKU, model, barcode, and title signals connect supplier rows to Shopify variants.
Rules create AI PowerSYNC proposals, review holds, alerts, reports, and audit logs.
Shopify-changing actions stay as dry-run holds for merchant review.
How To Use PowerSync AI
Beginner-friendly setup flow from first install to first safe inventory check.
Install PowerSync AI, grant read permissions, and let the app read products, variants, SKUs, vendors, locations, and inventory quantities.
Bring your Shopify product and variant catalog into the local workspace so supplier data has something accurate to match against.
Start with merchant-uploaded CSV/XLSX supplier files. Gmail, website, portal, Drive, PDF, and API/feed sources stay locked as future connector previews.
Tell PowerSync AI which supplier columns mean SKU, model number, stock status, quantity, lead time, cost, discontinued, and product title.
The app compares supplier SKUs, manufacturer SKUs, model numbers, barcodes, and product names against Shopify variants.
Open /powersync, upload supplier CSV/XLSX evidence, then aim AI at a collection, product, SKU, vendor, or full store. Shopify catalog data is used as matching background, not as a supplier source.
What A Merchant Does Day To Day
PowerSync AI is meant to become the inventory control desk between Shopify and every supplier source.
Open Dashboard, review Alerts, run a sync check, and focus on products with stockouts, duplicate conflicts, or low confidence.
Upload the newest CSV or Excel file in PowerSYNC, let AI read the source artifact, and compare proposed changes before Shopify is touched.
Use Inventory and Search to find missing SKUs, weak matches, duplicate model numbers, and supplier rows that need manual approval.
Use Reports to see supplier health, current risk, proposed stock changes, and which integrations or plan limits are holding the workflow back.
What Happens During AI PowerSYNC
AI PowerSYNC is the safe preview layer for dry-run inventory decisions.
PowerSync AI reads Shopify catalog data and supplier inventory rows.
It matches supplier rows to Shopify variants using SKU, model, barcode, and title signals.
Rules calculate proposed inventory quantities, backorder zeros, discontinued zeros, and skipped review items.
The merchant sees exactly what would happen before any Shopify update can be enabled.
Current Launch Mode
The app is intentionally conservative while Shopify launch review is prepared.
Shopify writes stay disabled in this release. Merchants can review dry-run holds, supplier evidence, duplicate conflicts, and confidence thresholds before making manual changes in Shopify.
How The App Organizes Merchant Data
These are the plain-English building blocks behind the app. They help merchants understand why setup has several steps.
The Shopify shop, plan context, permissions, API version, latest import, and location used for inventory reads.
A Shopify product copied into the workspace so supplier rows can be matched without constantly rereading Shopify.
The exact sellable Shopify variant, including SKU, barcode, inventory item ID, location quantity, and status.
A merchant-uploaded vendor CSV/XLSX file in this release. Future connectors remain locked previews until they are enabled and reviewed.
The saved translation between supplier column names and normalized PowerSync AI fields like SKU, quantity, status, and lead time.
A timestamped copy of normalized supplier rows from one file or source run, preserved for auditing and comparison.
The link between one supplier row and one Shopify variant, with confidence, evidence, and review state.
An AI PowerSYNC proposal such as set inventory to zero, restock to a capped quantity, or skip because review is needed.
Supplier Source Types
PowerSync AI is designed as an AI inventory intelligence layer, not only a spreadsheet importer.
Upload a supplier spreadsheet in the browser. PowerSync AI extracts text into source artifacts, matches SKUs, and generates AI PowerSYNC proposals.
Future browser automation and AI may read authorized product pages, visible text, stock tables, and lead-time signals after review.
Future browser automation may collect allowed portal pages and pass evidence through strict validation after review.
Gmail OAuth is locked in this Shopify review build until Google verification is complete. Current AI PowerSYNC runs use merchant-uploaded CSV/XLSX supplier files.
Future connection for shared vendor price lists, stock sheets, Drive folders, and changing supplier links after review.
Future support may capture supplier PDF evidence with safe text/metadata fallback, deeper parsing, and OCR after review.
What AI Does And Does Not Control
The product is AI-assisted, but Shopify inventory control stays validation-first and merchant-controlled.
Suggest field mappings, read messy supplier text, propose SKU matches, explain confidence, summarize alerts, and draft extraction recipes.
Update Shopify by itself, override safety rules, archive products, bypass source access controls, or approve low-confidence decisions.
Deterministic checks validate schema, confidence, duplicate conflicts, source age, supplier status, and plan policy before actions are created.
Safety And AI Rules
AI can assist extraction and matching. Final inventory control remains rule-based and reviewable.
Example Inventory Decisions
These examples explain what merchants should expect when supplier rows turn into proposed Shopify actions.
Dry-run proposes a safe capped Shopify quantity, usually 5, so the store can sell without overselling.
Dry-run proposes setting Shopify inventory to 0 and records the supplier evidence for review.
Dry-run proposes 0 available quantity and marks the reason as backorder, without archiving the product.
The match is held as needs review because fuzzy matching alone should not drive inventory updates.
The action is skipped as a duplicate conflict so an operator can decide which supplier signal wins.
Dry-run proposes zero inventory, but product archiving stays disabled until a later controlled phase.
Review Build
Read-only Shopify import, supplier setup, and dry-run AI PowerSYNC proposals.
Free Access
The review build has no app charges, subscriptions, or checkout flow.
Connector Previews
Additional source types are visible as previews but cannot be activated in this release.
Private Access
Additional connectors and AI provider options are prepared for later release.
Common Terms
Plain-English definitions for the words merchants see inside the app.
In this review build, a merchant-uploaded CSV/XLSX file that contains inventory or pricing information from a vendor.
The saved recipe that says which supplier column maps to SKU, quantity, stock status, lead time, and other inventory fields.
The connection between one supplier row and one Shopify variant. Higher confidence means the app is more certain it found the right item.
The central merchant workflow. The merchant gives instructions, selects a source and Shopify target, and receives validated inventory proposals without automatic live changes.
A review pass that reads supplier information, matches products, and prepares inventory recommendations.
A match or inventory decision that should be checked by a human before any automated action can happen.
Where To Go From Here
Use these links when setting up or reviewing the app.
Shopify Reviewer Notes
Concise testing context for app review, demo walkthroughs, and merchant onboarding calls.
PowerSync AI is built to say: connect your store, connect your suppliers, and let AI extract inventory signals from supplier files, portals, websites, and emails. Then PowerSync AI safely turns verified availability into dry-run Shopify review proposals.