Sync New Odoo Products to Etsy Draft Listings

This trigger checks your Odoo account hourly for any products that have been updated since the last check. When it detects changes to product records, it captures the product information including name, description, and list price, then passes this data to the next step. The hourly schedule balances keeping data current with system performance.

This step queries Etsy for all draft listings in your specified shop, retrieving up to 100 draft listings at a time with their titles and listing IDs. You need to configure your Etsy shop ID, which you can find in your Etsy shop URL or account settings. The draft listing data gets passed to the next step where it's matched against the Odoo product title.

This transform step uses custom JavaScript to compare the Odoo product name against all Etsy draft listing titles. If it finds an exact title match, it captures the Etsy listing ID for use in updating. If no match is found, the listing ID remains empty which triggers creation of a new listing. The matching happens automatically by iterating through all draft listings.

const Mesa = require('vendor/Mesa.js');
const Transform = require('vendor/Transform.js');

/**
 * A Mesa Script exports a class with a script() method.
 */
module.exports = new class {

  /**
   * Mesa Script
   *
   * @param {object} payload The payload data
   * @param {object} context Additional context about this task
   */
  script = (payload, context) => {

    // Adjust `payload` here to alter data before we transform it.

    // Get Odoo product
    const odooProduct = context.steps['odoo'];
    // Get Etsy listings
    const etsyDraftListings = context.steps['etsy'];
    // Storing the matching Etsy listing ID
    let etsyListingId;

    // Check if we have a matching titles between Odoo product and Etsy listing
    // If match, assign to Etsy listing ID to etsyListingId
    // Otherwise, leave as empty
    etsyDraftListings.results.forEach(listing => {
      if (listing.title === odooProduct.name) {
        etsyListingId = listing.listing_id;
        Mesa.log.info("Has matching Etsy listing ID");
        Mesa.log.info("Etsy listing id", etsyListingId);
      }
    });

    // Alter the payload data based on our transform rules
    const output = Transform.convert(context, payload);

    // Adjust `output` here to alter data after we transform it.
    output.etsy_listing_id = etsyListingId;

    // We're done, call the next step!
    Mesa.output.next(output);
  }
}

This rule examines whether the etsy_listing_id from the transform step is empty. If no matching listing was found during title comparison, this path activates and sends the workflow to the Create Draft Listing step. The check happens automatically using the matching results from the transform step.

This step creates a new draft listing in Etsy using the product name as title, description, and list price from Odoo. You need to configure several required Etsy fields: quantity (total available stock), who_made (i_did, collective, someone_else), when_made (time period like 2020_2025), taxonomy_id (Etsy's product category number), and shipping_profile_id (required for physical products). The draft listing appears in your Etsy shop manager where you can add photos and publish it when ready.

This rule checks whether the etsy_listing_id from the transform step has a value, meaning a matching draft listing was found during title comparison. If a match exists, this path activates and routes to retrieve and update the existing listing. The logic runs automatically based on the matching results.

This step queries Etsy for the complete draft listing record using the listing ID found in the matching step. It retrieves all listing details including the current title, description, price, and other fields. This complete listing information gets used in subsequent steps to verify required fields and update the listing accurately.

This filter examines the Odoo product data and only allows the workflow to continue if both the name and description_sale fields are not empty. If either required field is missing, the workflow stops here to prevent API errors from trying to update an Etsy listing with incomplete data. The comparison happens automatically using the Odoo product data from the trigger.

This step sends updated listing information to Etsy and overwrites the existing draft listing's title and description with the current values from Odoo. You can add other fields like price, quantity, or tags if you want to sync additional attributes beyond just title and description. The listing ID from the retrieve step tells Etsy exactly which draft listing to update.