Shopify Orders Date Filter

(2) Share

Report

Posted on by Sohail Ahmed

10,977 Super User 2025 Season 2

Maybe someone here has come across this issue.

I'm using the default Shopify connector in Business Central, and I want to fetch orders for a specific date range from Shopify to BC.

On the "Sync Shopify Orders" request page, I see filter fields like Created Date and Order Date, and I’ve tried entering a date range (e.g., '01/05/2025..10/05/2025'). But it doesn’t seem to work correctly — instead of fetching only orders within the range, it brings in older backorders too.

Has anyone managed to get the date filters to work properly on this sync function? Am I missing a format or step?

Thanks in advance!

Categories:

Dynamics 365 Business Central

pastedimage167177...

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Khushbu Rajvi. 18,966 Super User 2025 Season 2 on at

Like (1)

Report

Shopify Orders Date Filter

Adding it: https://learn.microsoft.com/en-us/dynamics365/business-central/shopify/synchronize-orders

Was this reply helpful? Yes No
Sohail Ahmed 10,977 Super User 2025 Season 2 on at

Like (3)

Report

Shopify Orders Date Filter

Saif Ali Sabri
Thanks for your input, but I’d like to clarify a few points based on my own testing and a review of the system:

About filter timing:
You mentioned that filters (like Created Date) are applied after orders are fetched from Shopify. But in practice, the request page runs before the call to Shopify, and filters like Order ID work as expected during the sync. This indicates the filters are part of the request logic. So I'm not sure on what basis you're stating that date filters are applied post-fetch

Last Synced Date” on the Shopify Shop Card:
I’ve double-checked the Shopify Shop Card and even inspected the page — there is no field called "Last Synced Date" available for the user to modify. If this exists in your environment, it might be part of a customization, but it's not part of the standard connector.

Custom AL Code suggestion:
I also reviewed the Import Shopify Orders codeunit, and it doesn't provide a straightforward way to apply a Created Date range filter. So suggesting AL changes without pointing to the specific function or method that needs adjustment doesn’t help much in resolving the issue.

I appreciate the effort, but the solution doesn’t seem to reflect how the standard Shopify connector behaves or how the filters are actually processed.

If anyone has found a confirmed way to apply the date range filter reliably in standard BC + Shopify integration, I’d be happy to hear it.

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 22,524 Most Valuable Professional on at

Like (3)

Report

Shopify Orders Date Filter

Hi

You could also use Shopify's official Yammer/Viva Engage channel.

Viva Engage : Dynamics 365 Business Central Partner Community (Formerly: Development) : Shopify Connector for Business Central : Nuevas conversaciones

Best

GR

Was this reply helpful? Yes No
Suggested answer

Saif Ali Sabri 2,346 Super User 2025 Season 2 on at

Like (3)

Report
Shopify Orders Date Filter

Here's a solution-based response tailored for your situation with the Shopify connector in Dynamics 365 Business Central:

✅ Solution: Date Filter Issue in “Sync Shopify Orders” – Business Central Shopify Connector
Yes, this is a common confusion point when working with the default Shopify connector in Business Central. While the "Sync Shopify Orders" request page provides filter fields like Created Date and Order Date, applying date ranges such as '01/05/2025..10/05/2025' may not work as expected unless the filter is applied at the right stage and on the correct field.
🧩 Why the Filter May Not Work
The issue likely stems from how and where the filters are applied in the connector logic:

The filters you see are applied after the system fetches all new or changed orders from Shopify.

The Shopify API fetches orders based on last sync timestamp, not the BC request page filters.

🛠️ Steps to Correctly Apply a Date Range Filter
To fetch a specific date range from Shopify (e.g., for backfilling or testing), follow this approach:

🔄 Approach: Use the "Created At Min/Max" Filter in Shopify API via Customization
Option 1: Modify the Shopify Connector Codeunit (Advanced)
If you are familiar with AL development, you can extend the Shopify connector (typically codeunit ShopifyOrderImport) to:

Use Shopify API parameters like:

created_at_min

created_at_max

Construct the query in the connector to apply those directly on the API call, instead of filtering post-fetch.

🧪 Example: json CopyEdit
GET /admin/api/2023-01/orders.json?created_at_min=2025-05-01T00:00:00Z&created_at_max=2025-05-10T23:59:59Z
Option 2: Temporary Workaround Without Code Changes
If you can't modify the connector code:

Change the Last Synced Date in the Shopify Shop Card to just before your desired range.

For example, set Last Order Sync to 30/04/2025.

Run the Sync Shopify Orders job.

Then manually filter out older orders in BC post-import if needed.

This forces the connector to pull only newer orders (Shopify uses "created_at > last_synced" internally).

📌Key Notes

BC’s request page filters are not passed to Shopify API directly — they filter records after download.

The connector does not support native Shopify API filtering via the UI. That’s why customization or manipulating sync timestamps is needed for accuracy.

✅ Recommended Fix

Best Option (Long-term): Extend the connector to allow passing Shopify API filters.

Quick Fix (Short-term): Adjust "Last Order Sync" to before your range start date and let the connector pull forward.

Was this reply helpful? Yes No