Import Etsy Orders In Odoo

  • The Etsy Odoo Connector allows you to import Etsy orders into Odoo. This can be a useful way to streamline your order management processes and keep your inventory and accounting data up-to-date.

  • Before importing orders, make sure to configure the order configuration and workflow configuration on the Instance.

  • You can import orders from Etsy to Odoo either manually or automatically.

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. Select Import as the operation type and then choose Import Orders.

    Etsy Order Import Screen
  4. Within the order import operation, you’ll encounter the following options:

    • Date Range: Etsy receipts created (or last modified) within the From Date and To Date are fetched.

    • Marketplace Order ID: You can import specific Etsy receipts by entering their Receipt IDs in the Marketplace Order ID field. Separate the IDs with a comma (‘,’) like this: 1234567890, 9876543210.

  5. Press the Process button.

This will start fetching orders from Etsy stores and add it to the Order Queue Job for processing. The order queue job will be processed automatically at a certain time interval. The orders will be created in Odoo based on the order workflow that you have configured based on payment gateway and financial status.

If some orders fail to import because a matching Etsy Financial Workflow is missing for the payment type, the error log shows a Configure Workflow shortcut that opens the right configuration form so you can add the missing workflow in one click.

Method - 2: Automatic Order Import

Order import from Etsy to Odoo can be automated using the Automatic Schedule action, which enables you to define a specific time interval for executing the import process. This automation ensures that the latest orders from your Etsy store is consistently and seamlessly created/updated in Odoo without requiring manual intervention. Here’s a breakdown of the process

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

  2. Open the Scheduled Actions tab. Configure the Import Order scheduled action by setting Interval Number, Interval Unit, and Active (default interval: every 15 minutes).

    Orders Automatic Import
  3. Once the scheduled action is active, Odoo automatically fetches new and updated receipts from Etsy and creates the matching Sale Orders.

Important

  • Receipts will only be imported based on their Receipt Status filter configured on the instance. You can configure the Receipt Status filter under Marketplaces ‣ Configuration ‣ Instance ‣ Orders tab.

  • If a receipt is already shipped on Etsy at the time of import, the connector auto-validates the Odoo delivery order and copies the Etsy carrier and tracking number onto the picking instead of leaving it pending.

  • If an existing order is found, any unfulfilled order in Odoo that is already shipped on Etsy will be marked as fulfilled in Odoo. The tracking reference on the delivery order will also be updated.

Canceled Orders

If an receipt has been canceled on Etsy, the connector automatically detects this and cancels the corresponding order in Odoo. The connector checks the cancelStatus of each order during import.

Order Workflow

When a receipt is imported, the connector picks the matching Etsy Financial Workflow line using the receipt’s Payment Type (e.g. Etsy Payments) and Order Payment Status (Open / Payment Processing / Paid / Completed / Canceled). The matched workflow can:

  • Confirm the Sale Order.

  • Create and validate the customer invoice.

  • Register the payment using the configured payment journal.

This behavior is controlled by the Workflow configuration on the instance.

Note

  • Existing orders are updated when re-imported (for example, payment status change, fulfillment update, or cancellation).

  • You can also mark a fully paid Odoo invoice as paid back on Etsy when Mark Order as Paid? is enabled on the instance.