Skip to main content

Automatic data export - import

To setup automatic actions (export of customer and items, and import of new sales orders or fulfillments):

  1. Choose the 🔎 icon, enter Shopify Setup, and then choose the related link.

  2. Press Action, then Functions, open group of actions Job Queue Entry

shopify-JQ-setup.png

  1. Select action then you want to setup as automatic regular job:

    1. Items - to sync item list with Shopify (direction depends on Sync Items setting)

    2. Customers – to send customer list to Shopify

    3. Orders – to import documents from Shopify (orders or fulfillments depending on Import Orders setting)

  2. In window Job Queue Entry, select how often job will run, and set status Ready.

    1. Set No. of Minutes between Runs = how often job will run (e.g., 15 for every 15 minutes)

    2. Or configure a recurring schedule using the Recurrence fields

    3. Set Status = Ready to activate the job

    shopify-JQ-recurrence.png

Job Queue Entry Details​

Items Sync Job​

Parameter String: SYNC_ITEMS

Behavior:

  • If Sync Items = To Shopify: exports items from Business Central to Shopify

  • If Sync Items = From Shopify: imports items from Shopify to Business Central

  • If Sync Items = Disabled: job does nothing

Typical Schedule: Every 30-60 minutes

Customers Export Job​

Parameter String: SEND_CUSTOMERS

Behavior:

  • Exports customers that have Customer Price Group matching WEB Customer Price Group in Shopify Setup

  • Only exports new or modified customers since last run

Typical Schedule: Every 30-60 minutes

Documents Import Job​

Parameter String: IMPORT_DOCUMENTS

Behavior:

  • If Import Orders = Orders: imports unfulfilled orders from Shopify as Sales Orders

  • If Import Orders = Fulfillments: imports fulfilled orders from Shopify as Sales Invoices

  • If Import Orders = Disabled: job does nothing

  • Uses Import Orders From DT field to filter orders by date

Typical Schedule: Every 5-15 minutes

Monitoring Job Queue Entries​

To monitor and troubleshoot job queue entries:

  1. Choose the 🔎 icon, enter Job Queue Entries, and then choose the related link.

  2. Find your Shopify job entries (filtered by Job Queue Category Code = SHOPIFY)

  3. Check the Status field:

    • Ready - Job is scheduled and will run

    • In Process - Job is currently running

    • On Hold - Job is paused

    • Error - Job failed

  4. If job status is Error:

    1. Select the job entry

    2. Press Log Entries to see error details

    3. Check Shopify Log Entries for API communication errors

    4. Fix the issue

    5. Press Set Status to Ready to restart the job

Important Notes​

  • Job Queue Entry functionality requires that Job Queue is running in your Business Central environment

  • Jobs run with the user credentials of the user who created the job

  • Make sure the user has appropriate permissions for Shopify connector

  • For production use, set Logging Mode = Error Only to reduce database size