Products Live in Your Store. Visibility Lives in Your CRM.
Your WooCommerce store has hundreds — maybe thousands — of products. Categories, tags, variations, attributes. Your team manages them in WooCommerce. But when sales needs to reference a product in a proposal, or accounting needs to verify an invoice line item, they have to log into the store.
Product data shouldn’t be locked inside one system.
Full Catalog Synchronization
WooSync doesn’t just sync product names and prices. It synchronizes your complete product taxonomy:
Products
Every product synced with full detail:- Name, slug, type (simple/variable/grouped), status
- SKU, regular price, sale price, current price
- Stock quantity and stock status
- Weight, length, width, height
- Description and short description
- Permalink and product images (JSON)
- Full meta_data storage
- Parent product ID for variations
Categories
Full category hierarchy preserved:- Category name and slug
- Parent category relationships
- Product count per category
- Maps to Perfex item groups
Tags
Product tags synced independently:- Tag name and slug
- Product count per tag
- Product ↔ Tag pivot relationships maintained
Attributes & Terms
Complete attribute system:- Attribute name, slug, type (select/text)
- Individual terms per attribute (e.g., Color → Red, Blue, Green)
- Term counts and slugs
Relationship Integrity
WooSync maintains pivot tables that preserve the many-to-many relationships between products and their taxonomy:
woosync_product_categories— which products belong to which categorieswoosync_product_tags— which products have which tags
When you sync, these relationships are rebuilt to match your WooCommerce store exactly. Delete a tag from a product in WooCommerce, and the pivot record disappears from Perfex on next sync.
Delta Updates, Not Full Imports
After the initial sync, WooSync uses delta updates — only products modified since the last sync are fetched. This means:
- Minimal API calls to WooCommerce
- Fast sync times even with large catalogs
- No unnecessary database writes
- Server resources used efficiently
Multi-Store Product Visibility
With multiple stores connected, WooSync gives you a centralized product view across all stores. Filter by store to see each catalog independently, or browse the full combined inventory.
Why Product Sync Matters
- Invoice accuracy: Line items reference correct products with SKUs
- Sales enablement: Your team can search products without leaving the CRM
- Inventory awareness: Stock levels visible in one dashboard
- Reporting: Combine product data with order data for sales analytics
Complete Data, Always Current
Your product catalog changes daily — new products, price updates, category reorganization. WooSync keeps your CRM copy perfectly synchronized through webhooks and delta sync.
Your catalog, everywhere it’s needed.
Leave a Reply