WooCommerce Export Integration

Audience: Administrators Difficulty: Intermediate Estimated Time: 30 minutes

Overview

The WooCommerce Export Integration allows dispensaries with existing WooCommerce stores to migrate their product catalog into TrafficPOS format. This intelligent export system automatically detects cannabis-specific attributes and transforms WooCommerce data for optimal POS operation.

Data Migration Made Easy: Preserve your existing product data while gaining all the benefits of an offline-first POS system.

Export Functionality

Comprehensive Data Mapping

  • Basic Product Info: Name, SKU, price, description, stock levels
  • Cannabis Attributes: THC/CBD content, strain type, effects
  • Category Structure: Complete hierarchical organization
  • Brand Information: Manufacturer and brand data
  • Pricing Models: Weight-based and tiered pricing

🧠 Smart Detection Features

  • Cannabis Category Detection: Automatically identifies flower, edibles, concentrates
  • Grade Extraction: Finds AAA, AA, A, Premium, Budget classifications
  • Pricing Type Detection: Determines weight-based vs. fixed pricing
  • Variation Handling: Converts complex variations to simple products
  • Compliance Mapping: Medical-only flags and lab testing status

Flexible Export Options

  • Product Status Filtering: Published, draft, or all products
  • Category Selection: Export specific product categories
  • Variation Handling: Include or exclude product variations
  • Category Structure: Maintain hierarchical organization
  • Image Preservation: Full URLs to product images

Intelligent Processing

  • ID Preservation: Maintains WooCommerce product IDs
  • Data Validation: Ensures export quality and completeness
  • Format Optimization: TrafficPOS-ready JSON structure
  • Error Handling: Graceful handling of missing data
  • Progress Tracking: Real-time export progress

Cannabis-Specific Data Mapping

WooCommerce Source TrafficPOS Field Detection Method
Product Category Category/Subcategory Keyword matching (flower, edible, etc.)
Product Attributes THC/CBD Content Custom attributes and meta fields
Product Type Strain Type Indica/Sativa/Hybrid detection
Variations Individual Products Converts variations to separate items
Custom Fields Effects & Terpenes Meta field mapping
Stock Data Inventory Levels Direct stock quantity transfer

Export Process

1

Access Export Interface

In WordPress admin, navigate to TrafficPOS → Export Products

  • Verify plugin is installed and activated
  • Ensure you have administrator privileges
  • Check WooCommerce product data is available
2

Configure Export Options

  • Product Status: Choose published products, drafts, or all
  • Category Filter: Select specific categories to export
  • Include Variations: Convert variations to individual products
  • Category Structure: Export complete category hierarchy
  • Image URLs: Include product image references
3

Execute Export

  • Click "Export Products" to begin process
  • Monitor export progress and status
  • Download generated JSON file when complete
  • Verify file size and content
  • Save file with descriptive name (e.g., woocommerce-export-2025-01-15.json)

Export File Structure

JSON Export Format

{
  "version": "1.0",
  "exported_at": "2025-01-15T10:30:00-07:00",
  "source": "woocommerce",
  "total_products": 156,
  "categories": [
    {
      "id": "flower",
      "name": "Flower",
      "displayName": "Flower",
      "color": "bg-green-600",
      "subcategories": [
        {
          "id": "indica",
          "name": "Indica",
          "displayName": "Indica"
        }
      ]
    }
  ],
  "products": [
    {
      "id": 123,
      "name": "Blue Dream - AAAA",
      "sku": "BD-AAAA-001",
      "base_price": 45.00,
      "category": "Flower",
      "subcategory": "AAAA",
      "brand": "Premium Farms",
      "stock_quantity": 250,
      "stock_unit": "grams",
      "thc_content": 22.5,
      "cbd_content": 0.5,
      "strain_type": "sativa",
      "effects": ["euphoric", "creative", "energetic"],
      "pricing_type": "weight_based",
      "price_per_gram": 12.00
    }
  ]
}

Import to TrafficPOS

1

Access Import Function

In TrafficPOS, navigate to Settings → Import/Export → Import Products

  • Ensure you have administrator privileges
  • Create backup of existing POS data
  • Prepare exported JSON file
2

Upload Export File

  • Click "Choose File" and select JSON export
  • System validates file format and structure
  • Review import preview and product count
  • Check for any validation errors or warnings
3

Review Import Preview

  • Product Summary: Total products to be imported
  • Category Structure: Review category organization
  • Data Mapping: Verify field mappings are correct
  • Conflict Resolution: Handle duplicate SKUs or IDs
4

Complete Import

  • Click "Import Products" to begin
  • Monitor import progress
  • Review import log for any errors
  • Verify products appear in POS catalog
  • Test product functionality and pricing

Handling Special Cases

Variable Product Conversion

WooCommerce Variations → Individual POS Products

Example: Variable Product Conversion

WooCommerce Structure TrafficPOS Result Naming Convention
Blue Dream
- Variation: 1g ($15)
- Variation: 3.5g ($45)
- Variation: 7g ($80) 		Three Individual Products:
- Blue Dream - 1g
- Blue Dream - 3.5g
- Blue Dream - 7g 		[Product Name] - [Variation]

Weight-Based Product Detection

Detection Criteria

  • Product Type: cannabis_weight custom type
  • Meta Fields: _price_per_gram custom field
  • Category-Based: Products in "Flower" category
  • Stock Units: Gram-based inventory tracking

Conversion Process

  • Pricing Type: Set to "weight_based"
  • Base Price: Calculated per-gram rate
  • Stock Unit: Converted to grams
  • Sellable Weights: Standard increments (1g, 3.5g, 7g, etc.)

Mix & Match Eligibility

Mix & Match Detection

Products eligible for bulk pricing are identified by:

  • Product Type: cannabis_mix custom product type
  • Category Membership: Products in mix-eligible categories
  • Custom Meta Flags: _mix_match_eligible field
  • Grade Classification: Products with AAA, AA, A grades
  • Weight-Based: Flower products with per-gram pricing

Integration Benefits

🛡️ Data Preservation

  • Complete Migration: No data loss during export
  • ID Maintenance: Preserves WooCommerce product IDs
  • Relationship Integrity: Maintains category structures
  • Custom Attributes: Cannabis-specific fields preserved

Operational Efficiency

  • No Re-Entry: Avoid manual product re-creation
  • Batch Processing: Export hundreds of products at once
  • Quick Setup: Rapid POS deployment
  • Error Reduction: Automated data mapping

Future Flexibility

  • Sync Foundation: Enables ongoing synchronization
  • Dual Management: Manage from either system
  • Backup Strategy: Multiple data copies
  • System Independence: Reduce vendor lock-in

Business Continuity

  • Offline Capability: POS works without internet
  • Online Presence: WooCommerce continues online sales
  • Unified Inventory: Prevent overselling
  • Compliance Ready: Cannabis-specific features

Post-Export Integration Steps

1

Test Import Results

  • Verify all products imported correctly
  • Check pricing calculations and tiers
  • Test weight-based product functionality
  • Confirm category organization
  • Validate cannabis-specific attributes
2

Configure POS Features

  • Set up mix & match pricing rules
  • Configure low stock alerts
  • Customize category colors and organization
  • Set up barcode generation if needed
  • Configure tax rates and compliance settings
3

Enable Ongoing Synchronization

  • Set up WooCommerce API connection
  • Configure sync intervals and preferences
  • Test real-time inventory updates
  • Monitor sync logs for errors
  • Establish backup and monitoring procedures

Troubleshooting Export Issues

Common Export Problems

Export Process Fails

  • Check WordPress memory limits and increase if needed
  • Verify plugin is activated and up to date
  • Test with smaller product batches
  • Check WordPress error logs
  • Ensure adequate server resources

Missing Product Data

  • Verify WooCommerce products have required fields
  • Check custom attribute configuration
  • Ensure products are published and visible
  • Review category assignments
  • Validate stock data and pricing

Import Problems

Import Validation Errors

  • Check JSON file format and structure
  • Verify all required fields are present
  • Resolve duplicate SKU conflicts
  • Check for invalid characters or formatting
  • Ensure file size is within limits

Incomplete Import Results

  • Review import log for specific errors
  • Check browser memory and timeout settings
  • Import in smaller batches if needed
  • Verify network connectivity during import
  • Clear browser cache and retry

Related Guides

WooCommerce Connection

Set up real-time synchronization between systems

Inventory Management

Managing imported products and stock levels

Mix & Match Pricing

Configure bulk pricing for imported flower products