WooCommerce integration

The WooCommerce integration allows you to connect your WooCommerce online store to Gem Logic. Once connected, you can push products from Gem Logic to your WooCommerce store and pull orders from WooCommerce into Gem Logic. This keeps your product catalog and order management in sync across both platforms.

Configuration

Generate API keys in WooCommerce

Before connecting WooCommerce to Gem Logic, you need to generate API keys in your WooCommerce store.

  1. Log in to your WordPress admin panel.

  2. Navigate to WooCommerce ‣ Settings ‣ Advanced ‣ REST API.

  3. Click Add key.

  4. Fill in the details:

    • Description: enter a name to identify this key (e.g. Gem Logic Integration).

    • User: select the WordPress user that will be used for the API connection.

    • Permissions: select Read/Write. This is required so Gem Logic can both read orders and create/update products in your store.

  5. Click Generate API key.

  6. Copy the Consumer key and Consumer secret. These will only be shown once, so make sure to save them in a secure location.

Important

The consumer secret is only displayed once. If you lose it, you will need to revoke the key and generate a new one.

Connect WooCommerce to Gem Logic

  1. In Gem Logic, go to Configuration ‣ Sales channels.

  2. Open the sales channel you want to connect to WooCommerce, or create a new one.

  3. Enable the WooCommerce checkbox.

  4. Fill in the following fields:

    • URL: the full URL of your WooCommerce store (e.g. https://www.yourstore.com). Do not include a trailing slash.

    • WooCommerce Key: paste the Consumer key you generated earlier.

    • WooCommerce Secret: paste the Consumer secret you generated earlier.

  5. If you use the Perfect WooCommerce Brands plugin in your WooCommerce store, enable the WooCommerce brands plugin checkbox. This allows Gem Logic to sync product brands with WooCommerce.

  6. Save the sales channel.

Tip

Make sure your WooCommerce store uses HTTPS. The API credentials are encrypted and stored securely in Gem Logic.

Assign products to the sales channel

For products to be pushed to WooCommerce, they must be assigned to the WooCommerce sales channel.

  1. Go to Products.

  2. Open a product and go to its sales channels section.

  3. Add the WooCommerce sales channel to the product.

  4. Make sure the product has a pricing rule configured for that sales channel, so it has a price when pushed to WooCommerce.

Pushing products

You can push products from Gem Logic to your WooCommerce store. This creates or updates products in WooCommerce based on the data in Gem Logic.

Push a single product

To push a single product, open the product in Gem Logic and use the push action from the product sales channels section. The product will be created in WooCommerce if it does not exist yet, or updated if it already has a WooCommerce ID.

Push all products

To push all products assigned to a WooCommerce sales channel at once:

  1. Go to Configuration ‣ Sales channels.

  2. Open the WooCommerce sales channel.

  3. Click Push all products to WooCommerce.

This runs as a background task. You can track progress on the push history page.

What gets pushed

When a product is pushed to WooCommerce, the following data is synced:

  • SKU (used to match products between the two systems)

  • Name and description (based on the sales channel language)

  • Regular price and sale price (from the pricing rule for that sales channel)

  • Images (only re-uploaded if there are changes)

  • Categories and collections (created in WooCommerce if they don’t exist)

  • Attributes (created as global WooCommerce attributes)

  • Tags

  • Stock quantity

  • Brands (if the WooCommerce brands plugin is enabled)

  • Product type: simple or variable (with variants)

Variable products and variants

If a product in Gem Logic is marked as a parent product, it is pushed as a variable product in WooCommerce. All its child products (variants) are pushed as product variations. Each variant includes its own price, SKU, image, and attribute values (e.g. size, color).

Product deactivation

You can deactivate a product in WooCommerce from Gem Logic. This sets the product status to draft in WooCommerce, making it invisible on the storefront without deleting it.

Push history

Every push operation is logged. You can view the push history from the sales channel detail page. Each history record shows:

  • Start and end time

  • Status (started, completed, failed, or partial success)

  • Total products, successful, and failed counts

  • Success rate and duration

  • Detailed per-product results (click View details to see which products succeeded or failed)

Pulling products

You can pull products from your WooCommerce store into Gem Logic. This is useful for the initial import when you first connect your store.

  1. Go to Configuration ‣ Sales channels.

  2. Open the WooCommerce sales channel.

  3. Click Pull products from WooCommerce.

This runs as a background task and imports the following data for each product:

  • SKU, name, and description

  • Regular price and sale price

  • Categories and brands

  • Images (downloaded and stored in Gem Logic)

  • Tags

  • Stock quantities

  • Attributes and materials

  • Product variants (for variable products)

Note

Products that already exist in Gem Logic (matched by WooCommerce ID or SKU) are skipped during the import. Only new products are created.

Pulling orders

You can pull completed orders from WooCommerce into Gem Logic.

Pull orders manually

  1. Go to Configuration ‣ Sales channels.

  2. Open the WooCommerce sales channel.

  3. Click Pull orders from WooCommerce.

This runs as a background task. You will be redirected to the pull history page where you can monitor progress in real time.

Automatic order pulling

Orders can also be pulled automatically on a schedule using the background task system. This ensures new completed orders are regularly imported without manual action.

What gets imported

When orders are pulled from WooCommerce, the following data is imported:

  • Order key (used as the unique order identifier)

  • Customer contact information (name, address, email, phone) — a contact is created or updated in the CRM

  • Order date and currency

  • Line items: each order line includes the product (matched by WooCommerce ID or SKU), quantity, prices (excl. and incl. VAT), and VAT rate

  • Stock deduction: stock is automatically deducted for each order line item

Note

Only orders with the status completed are imported. Orders with other statuses (e.g. processing, on-hold, pending) are skipped.

Note

Orders that have already been imported (matched by order key) are skipped to avoid duplicates.

Pull history

Every pull operation is logged. You can view the pull history from the sales channel detail page. Each history record shows:

  • Start and end time

  • Status (started, completed, failed, or partial success)

  • Total orders processed, new orders created, skipped, and failed counts

  • Duration and any error messages