We’ve had many requests over the years to update our fmEcommerce Link (WooCommerce Edition) solution to allow you to just download Products that were updated recently by date range. A common use case is that you have updated a subset of products in WooCommerce and just need to get those updated products into FileMaker.
fmEcommerce Link does have the ability to update a product in FileMaker from WooCommerce, but you would need to have kept a track of the WooCommerce IDs for the products that were updated in WooCommerce and then find these in FileMaker and perform the update. Unfortunately the WooCommerce REST API didn’t support the ability to perform queries by modification date (only date published/created).
This functionality has been requested in the past for orders to save having to query for the whole set of WooCommerce orders just to retrieve the handful that were recently updated. Earlier this year I decided to also submit a feature request for the ability to query the products API endpoint using modified_before and modified_after query parameters that filtered using the date modified field. This request was well supported by other developers and I’m pleased to report that WooCommerce 5.8.0 and later now support this feature for the product, order and coupon API endpoints.
We’ve put out an update to fmEcommerce Link (WooCommerce Edition) v2 for downloading updated Products – v2.0.3 now lets you filter by date modified when downloading Products from WooCommerce: