Has anyone worked with the Shopify connector. What exactly is the difference between the Date Filter

lemon76

I am struggling to get all the fulfillments data in. Whenever the order seems to have a later updated date than when the dataset updates, the connector isn't bringing the order in. If I stick to the created date in the date filter the order should be in the dataset. That doesn't seem to be the case.

ArborRose

If you are filtering on created date, all orders created on that date (10/18) should show up regardless of updates.

Domo and Shopify may have different time zones. If Shopify are in UTC and Domo uses local time zone, some orders may fall outside the range. You may also encounter issues due to delayed order updates. The duration of the connector, if it runs a long time, might also affect things.

ArborRose

There are two date filters in the Shopify connector. Created date and updated date.

The created date gets all the orders that were placed with the date range you request. But it won't include updates if the fulfillment occurred after the dataset refreshed. You miss the updates to the order, such as fulfillment statuses that were created after the order was created.

The updated date filter captures data based on most recent update to the order. This includes updates or changes. Filtering on the updated date will get order that were created new or modified during the period you specified.

Using the updated date filter to get order that have changed since the last refresh. And incrementally refresh to pull orders that were updates since the last update. You may be able to combine…using created to get the new orders and then update them using updated date. Make sure you check your time zone settings also.

lemon76

Hey there!

Thanks so much for the detailed explanation. We are missing the orders that were created a day or two ago and maybe had an update after the connector has finished running for that date no matter what we filter on. Is there any way even if we missed the updates for these orders to show up in the datapull? If we filter on created date for '10/18' all the orders created for 10/18 should at least show up right?

ArborRose

If you are filtering on created date, all orders created on that date (10/18) should show up regardless of updates.

Domo and Shopify may have different time zones. If Shopify are in UTC and Domo uses local time zone, some orders may fall outside the range. You may also encounter issues due to delayed order updates. The duration of the connector, if it runs a long time, might also affect things.

lemon76

Thanks so much! I will check on these!