Import BigCommerce Orders In Odoo

  • The BigCommerce Odoo Connector lets you import BigCommerce orders into Odoo as Sale Orders. This keeps inventory, accounting, and fulfillment data centralized in Odoo and eliminates manual re-entry.

  • Before importing, configure the relevant Order Configuration and Workflow Configuration on the instance.

  • You can import orders manually from the operations wizard or on schedule through the Import Order automatic job.

Method - 1: Manual Order Import

  1. Go to the Marketplaces ‣ Overview menu in Odoo.

  2. Click on the Operations button from the instance record.

  3. Choose Import as the operation type, then from Import Operation, select Import Orders.

    Order Import Screen
    • The wizard exposes the following options:

    • Date Range — Orders corresponding to the dates specified in the Date Range field will be retrieved from BigCommerce.

    • Marketplace Order ID — Import specific BigCommerce orders by entering their numeric IDs. Separate multiple IDs with a comma, for example 5869502038181, 9869502038181, 4586950203818.

  4. Click PROCESS.

The connector fetches orders from BigCommerce and adds them to the Order Queue Job visible at Marketplaces ‣ Queues. The queue job is then processed automatically; each order is created in Odoo following the Marketplace Workflow matched to the order’s Payment Gateway and Payment Status.

If some orders fail because no matching financial workflow is configured, the queue line writes a log entry with a Configure Workflow shortcut. Click the shortcut to open the financial workflow form pre-filled with the missing payment gateway and payment status combination, complete the line, then retry the failed queue line.

Method - 2: Automatic Order Import

Order import from BigCommerce to Odoo can be automated using the Automatic Schedule action, which allows you to set up a predefined time interval for the execution of the import process. This automation ensures that the latest orders from your BigCommerce store are consistently and seamlessly created or updated in Odoo without requiring manual intervention. Here’s how the process works:

  1. Go to your BigCommerce instance setting by navigating to Marketplaces ‣ Configuration ‣ Instance.

  2. Open the Automatic Jobs tab. In that tab you can configure the Import Order automatic action by setting Interval Number, Interval Unit, and then enable Active.

    Orders Automatic Import
  3. Once the schedule action is active, Odoo automatically triggers the BigCommerce order import at the specified time intervals, fetching the latest orders from your store and processing them according to the configured order workflow.

Important

  • Orders are imported only when their BigCommerce status is included in the instance’s Order Status filter. Configure the filter at Marketplaces ‣ Configuration ‣ Instances, on the Orders tab.

  • If a BigCommerce order is partially or fully refunded and the matched workflow validates the invoice, a credit note is created automatically in Odoo.

  • If an order already exists in Odoo, the connector updates it in place — fulfillment, tracking number, and BigCommerce payment status are refreshed from the latest BigCommerce data.