BigCommerce Odoo Connector Catalog SCS
by Serpent Consulting Services Pvt. Ltd. https://www.serpentcs.com$ 80.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• eCommerce (website_sale) • Discuss (mail) • Website (website) • Invoicing (account) |
| Community Apps Dependencies | Show |
| Lines of code | 4296 |
| Technical Name |
bigcommerce_catalog_connector_scs |
| License | LGPL-3 |
| Website | https://www.serpentcs.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• eCommerce (website_sale) • Discuss (mail) • Website (website) • Invoicing (account) |
| Community Apps Dependencies | Show |
| Lines of code | 4296 |
| Technical Name |
bigcommerce_catalog_connector_scs |
| License | LGPL-3 |
| Website | https://www.serpentcs.com |
BigCommerce Odoo Connector Catalog
BigCommerce Odoo Connector will help you integrate and manage your BigCommerce products,brands,category,customers ,orders and inventory in Odoo.
Highlighted Features
Role-Based Connector Access
A dedicated BigCommerce User security group controls access to connector menus and configuration actions within Odoo.
Rich Product Catalog Import
Beyond just titles; import images, extra gallery images, attributes, and variants seamlessly from BigCommerce.
Comprehensive Entity Sync
Centralize your operations by importing your entire BigCommerce customers,brands,orders and inventory directly into Odoo.
Insightful Sync Dashboard
Monitor your integration at a glance with a dedicated dashboard that tracks all imported data and connection health.
Robust History & Logs
Maintain full transparency with detailed execution logs for every import process to troubleshoot and track changes.
Automated Data Sync via Cron
Set it and forget it! Automate the import of products, brands, categories, customers, orders and Inventory using scheduled Odoo Cron jobs.
Detailed Features
One-Click API Connection Test
Validate BigCommerce credentials directly from the instance form using the Test Connection action, which checks API access and shows instant success or error feedback.
Detailed Operation History Tracking
Maintain a centralized, read-only audit trail for import/export activities with operation type, object, timestamp, created/updated record counts, and processing messages per instance.
Advanced Product Lifecycle Management
Import complex product structures without losing data integrity. The connector handles:
- Variant Mapping: Matches BigCommerce product variants with Odoo's product template system.
- Media Gallery: Syncs the primary product image and all additional "Extra Images" to the Odoo gallery.
- Attribute Synchronization: Automatically creates and maps product attributes (size, color, etc.) between the two platforms.
Multi-Entity Import Support
The connector doesn't just stop at products. It creates a unified ecosystem by importing and synchronizing:
- Customer Profiles: Names, contact details, and addresses.
- Product Categories: Maintains the BigCommerce category tree structure within Odoo.
- Brand Directories: Links products to their respective brands for better filtering and management.
- Order Data: Seamlessly imports orders with details such as order ID, customer information, products, quantities, pricing, and order status—ensuring accurate synchronization and efficient order management within Odoo.
- Inventory Sync: Keeps product stock levels synchronized between BigCommerce and Odoo by automatically updating inventory during product import and order processing. Supports both scheduled cron-based updates and manual sync to maintain accurate stock quantities and prevent overselling.
Automated Scheduling (Cron)
Eliminate manual entry by configuring automated sync intervals. You can toggle specific Crons for:
- Real-time or scheduled Product and Category updates.
- Background Customer data fetching to keep your CRM up to date.
- Brand catalog synchronization.
Integrated Monitoring Dashboard
A central command center within Odoo that allows you to:
- View total counts of imported products, customers, and brands.
- Access quick links to specific BigCommerce records.
- Verify the status of the last sync at a glance.
Traceability and Error Handling
Never wonder if a sync failed. The module includes:
- Audit Logs: Detailed records of which items were created or updated.
- Error Reporting: If an import fails (e.g., due to a missing attribute), the log captures the specific API error for easy fixing.
Screenshots
Role-Based Connector Access
A dedicated BigCommerce User security group controls access to connector menus and configuration actions within Odoo.
BigCommerce Configuration Menu
Shows the BigCommerce root menu and configuration flow in Odoo, where users can navigate to Instances and manage connector setup from a centralized location.
BigCommerce Instance Form & Connection Test
Displays the instance setup screen with Store Hash, Access Token, and API Base URL, along with the Test Connection action to validate API credentials and confirm connectivity.
Flexible Product Synchronization
Streamline your inventory by bringing BigCommerce products into Odoo exactly how you need them.
- Bulk Product Import: Select your BigCommerce instance and the "Product" operation to sync your entire catalog in one click.
- Targeted ID Import: Use the "Import Product Using BigCommerce ID" toggle to fetch a specific product by its unique identifier, perfect for quick updates or testing.
- Rich Data Mapping: Automatically imports essential details including product names, variants, attributes, and primary images.
Intelligent Category Mapping
Maintain your storefront's organization by mirroring your BigCommerce category tree within Odoo.
- Hierarchy Preservation: Import categories while maintaining parent-child relationships for a consistent browsing experience.
- Instance-Specific Sync: Choose which store instance to pull categories from to keep multi-store environments organized.
- Individual Category Fetch: Directly import a single category using its BigCommerce ID for precise data management.
Dynamic Brand Management
Ensure your product branding remains consistent across platforms with dedicated brand synchronization.
- Complete Brand Catalog Sync: Import all associated brands from your BigCommerce store to Odoo with a single operation.
- Selective Brand Import: Enable the ID-based import option to sync specific brands without running a full catalog refresh.
Seamless Customer Data Integration
Keep your CRM updated by syncing your BigCommerce customer base directly into Odoo.
- Mass Customer Import: Sync all registered customers, including their contact information and basic profiles, from your selected instance.
- Specific Customer Fetch: Quickly pull a single customer record into Odoo using their BigCommerce ID for immediate order processing or support.
- Unified Records: Create a single source of truth for customer interactions across your e-commerce and ERP platforms.
Smart Order State Mapping
Configure BigCommerce order statuses to match Odoo order stages for accurate order processing, automated invoicing, and seamless shipping workflow management.
Efficient Order Import Management
Simplify your sales operations with flexible order synchronization between BigCommerce and Odoo, ensuring accurate order tracking and streamlined processing.
- Complete Order Import: Import all orders from your BigCommerce store into Odoo in a single operation for full order synchronization.
- Single Order Import: Use the Order ID-based import option to fetch and sync a specific order quickly without importing the entire order database.
- Date Range Order Import: Import orders within a selected date range to keep your system updated for specific periods and improve data control.
Smart Inventory Synchronization
Maintain accurate stock levels across BigCommerce and Odoo with seamless inventory synchronization, reducing manual effort and preventing stock mismatches for smoother order fulfillment.
- Complete Inventory Sync: Sync all product stock quantities from BigCommerce to Odoo in a single operation for full inventory alignment.
- Scheduled Inventory Updates: Automatically update stock levels using cron-based synchronization to ensure real-time inventory accuracy.
- Manual Inventory Sync: Trigger inventory updates manually whenever needed for instant stock reconciliation and better operational control.
Real-Time Operational Audit Logs
A detailed log system that tracks created/updated counts for products, variants, categories, and customers across all instances.
Multi-Instance Monitoring Dashboard
Centralize your e-commerce management with a high-level visual summary that tracks the scale and connectivity of your BigCommerce ecosystem directly within Odoo.
- Live Entity Statistics: Instantly view total counts for Products, Brands, Categories, Customers and Orders synced from each specific BigCommerce instance.
- Instance Connectivity Status: Monitor the "Connected" health of multiple store environments (e.g., "odooBigcommerce" and "SerpentCS") to ensure data pipelines are active.
- Segmented Data Insights: Manage multi-store setups through dedicated instance cards that segregate data totals, preventing cross-store confusion.
- One-Click Navigation: Use the visual counters as a jumping-off point to access filtered lists of records for each specific store instance.
Advanced Auto-Update Configuration
Keep your Odoo backend perfectly in sync with BigCommerce without manual intervention by leveraging robust automated update settings. This feature allows for seamless, background data refreshes based on your specific business requirements.
- Granular Auto-Update Controls: Individually toggle automatic updates for core entities including Products, Brands, Categories, Orders and Customers to control exactly what data syncs automatically.
- Intelligent Cron Scheduling: Once enabled, the module utilizes background scheduled actions (Crons) to fetch the latest changes from BigCommerce at regular intervals.
Automated Pricelist & Currency Resolution
The connector ensures every imported BigCommerce order is associated with the correct Odoo pricelist and currency, eliminating manual adjustments and preventing pricing or tax miscalculations. It provides:
- Three-Level Auto-Resolution: Resolves the pricelist through a prioritized lookup — first checking for an explicit pricelist override on the payment mapping row, then a currency override that finds the matching pricelist, and finally auto-detecting the currency from the BigCommerce order's default_currency_code field.
- Multi-Currency Store Support: Seamlessly handles stores selling in multiple currencies (USD, EUR, GBP, etc.) by automatically matching the order's currency to the correct Odoo pricelist — no manual intervention required for each order.
- Gateway-Specific Pricing: Allows you to pin a specific pricelist to a payment gateway — for example, routing all Stripe EUR orders to a "EUR Wholesale Pricelist" with gateway-specific discounts applied automatically on import.
- Refund Currency Consistency: Credit notes generated from BigCommerce refunds always inherit the original sale order's currency, ensuring the refund is posted in the same currency as the original transaction and reconciliation remains clean.
- Fallback Safety: If no pricelist is resolved through any level, the order gracefully falls back to the customer's or company's default pricelist, preventing import failures due to missing configuration.
Automated Refund Detection & Credit Note Generation
The connector goes beyond order import by fully managing the refund lifecycle — detecting refunds from BigCommerce and automatically creating the corresponding credit notes in Odoo without any manual steps. It handles:
- Reliable Refund Detection: Identifies refunded orders using three independent signals — a non-zero refunded_amount field (most reliable), status text containing "refund", or BigCommerce status IDs for Refunded (4) and Partially Refunded (14) — bypassing BigCommerce's inconsistent payment_status field.
- Full & Partial Refund Support: Classifies each refund as full or partial by comparing the refunded amount against the original order total. Partial refunds generate proportionally scaled credit note lines directly mirroring the original invoice, while full refunds reverse the entire invoice.
- Automatic Credit Note Creation: Fetches refund details from the BigCommerce /orders/{id}/refunds API and creates a posted out_refund credit note in Odoo, linked directly to the originating sale order and payment mapping journal for accurate accounting.
- Duplicate Prevention: Each BigCommerce refund ID is tracked in a dedicated bigcommerce.refund record with a unique constraint, ensuring the same refund is never imported twice even across repeated sync runs.
- Sync Status Tracking & Retry: Every refund record exposes a sync status — Pending, Synced, or Error — along with a detailed message for failed records. Failed refunds can be retried individually from the refund form without re-running a full import.
Checklist before going live
Create one bank/cash journal per payment gateway used in BigCommerce
Create one pricelist per currency your BC store sells in (even if prices are the same — currency matters)
Add a payment mapping row for each BC payment method (stripe, PayPal, Credit Card, manual, etc.)
Mark exactly one row per instance as Default to handle unknown methods
Enable currencies in Odoo (Accounting → Currencies → activate USD, EUR, GBP as needed)
Test import one paid order and one refunded order from BC before bulk sync
User Guide
BigCommerce API Accounts Page
Log in to BigCommerce and go to **Settings > API > Store-level API accounts**. This is where you create API credentials for Odoo integration
Create Store-Level API Account
Click Create API Account. Enter an account name (for example, Odoo) and continue to permission setup.
Configure API Path and Store Hash
In the API account form, note the API path like https://api.bigcommerce.com/stores/<store_hash>/v3/. The <store_hash> value is required in Odoo.
Set Required Permissions
Enable the required scopes (at minimum the resources your connector uses, such as catalog/product access). Save the API account.
Copy API Credentials
After saving, copy and securely store the generated credentials. For this base connector, keep Access Token and Store Hash ready.
Install module
BigCommerce Connector SCS
Give User Access
After installing the module go to the Settings --> Then go to the Users menu. select the specific user --> In Access Rights, check on the Bigcommerce User --> Save
Configure BigCommerce Instance in Odoo
In Odoo, open BigCommerce > Configuration > Instances and create a new record. Fill Instance Name, Store Hash, Access Token, and keep default API Base URL unless custom.
Test Connection in Odoo
Click Test Connection. If credentials are correct, Odoo shows a success notification and updates connection status/time.
FAQ
No, third-party apps can not be used on Odoo Online. Unfortunately, Odoo SaaS blocks such a possibility.
In many cases, yes. We offer Demo videos, Screenshots, Live demo links (for selected apps) If you need a personalized demo, you can contact our support team.
We request you contact our team via contact@serpentcs.com to discuss the features and customization required so that we can provide you assistance with your request.
Our Odoo Services
Odoo Consulting
Odoo Implementation
Odoo Development
Odoo Testing
Odoo Data Migration
Odoo Training
Odoo Support
Features
Screenshots
User Guide
FAQs
WhatsApp
Email
Website
Please log in to comment on this module