Skip to main content

Shopify-Odoo Integration Troubleshooting

Connection Issues​

Cannot connect to Shopify store​

Checklist:

  1. Verify the store URL format: your-store.myshopify.com
  2. Confirm the API key and secret are from a Custom App (not a Public App)
  3. Check that the app has the required scopes: read_products, write_products, read_orders, write_orders, read_inventory, write_inventory

"SSL Certificate Error" during connection​

Solution:

  • Ensure your server's CA certificates are up to date
  • On Ubuntu/Debian: sudo apt update && sudo apt install ca-certificates
  • On CentOS/RHEL: sudo yum update ca-certificates

Sync Issues​

Products sync but variants are missing​

Cause: Odoo product attribute mapping not configured.

Solution:

  1. Go to Shopify Connector > Settings > Attribute Mapping
  2. Map Shopify options (Size, Color) to Odoo product attributes
  3. Trigger a full product sync

Order status not updating back to Shopify​

Cause: Fulfillment webhook not registered or Odoo delivery confirmation not completing.

Solution:

  1. Check Odoo delivery orders are validated (not just confirmed)
  2. Verify tracking numbers are entered in Odoo before validation
  3. Re-register webhooks if needed

Prices showing incorrectly after sync​

Cause: Currency or tax configuration mismatch.

Solution:

  1. Verify both systems use the same base currency
  2. Check tax-inclusive vs tax-exclusive pricing settings
  3. Odoo: Sales > Configuration > Pricelists
  4. Shopify: Settings > Taxes and duties

Performance​

Initial sync taking too long​

For stores with 1000+ products:

  1. Run the initial sync during off-peak hours
  2. Use batch mode: Shopify Connector > Settings > Sync Mode > Batch
  3. Expected times:
    • 1,000 products: ~5 minutes
    • 10,000 products: ~30 minutes
    • 50,000 products: ~2 hours

Webhook delivery delays​

Cause: Shopify webhook delivery can be delayed during high-traffic periods.

Solution:

  • Enable the "Polling Fallback" option to catch missed webhooks
  • Set polling interval to 15 minutes for near-real-time sync

Data Issues​

Customer data not matching between systems​

Solution:

  1. Set a matching field: email (recommended) or phone number
  2. Go to Shopify Connector > Settings > Customer Matching
  3. Choose "Match by Email" and enable "Create if not found"

Tax calculations differ between Shopify and Odoo​

Solution:

  1. Use Odoo as the source of truth for tax calculations
  2. Configure tax mapping: Shopify Connector > Settings > Tax Mapping
  3. Map each Shopify tax rate to the corresponding Odoo fiscal position