fmEcommerce Link (WooCommerce Edition) Version History

v2.0.11 2024-04-23

Products Upload: updated to check for WooCommerce Meta Data ID and only include id object if present and also update Meta Data records after uploading
Customers Upload: updated to check for WooCommerce Meta Data ID and only include id object if present and also update Meta Data records after uploading
Product Variations Upload: updated to check for WooCommerce Meta Data ID and only include id object if present and also update Meta Data records after uploading
Coupons Upload: updated to check for WooCommerce Meta Data ID and only include id object if present and also update Meta Data records after uploading
Orders Upload: updated to check for WooCommerce Meta Data ID and only include id object if present

v2.0.10 2024-03-29

Coupons: fixed issue adding Products and Product Categories to a coupon

v2.0.9 2024-03-18

changed data type for OrdersShippingLines::Total field from text to number

v2.0.8 2023-03-01

- added support for Otto Webhooks
- updated cURL options to use trace-ascii instead of trace

v2.0.7 2022-08-09

Customers: added new example for deleting a Customer in WooCommerce

v2.0.6 2022-03-31

Get All Media: updated to use lowercase names for getting total pages and total from response headers

v2.0.5 2022-02-10

removed filteredCustomers option for downloading Customers from WooCommerce as not currently supported by WooCommerce REST API
added Update Customer Webhook example (PHP API and Data API)

v2.0.3 2021-11-20

added new script: Update Product Variation Stock Qty in WooCommerce
added new script: Update Product Variation Stock Status in WooCommerce
Get Products from WooCommerce: added new example for downloading Products modified between 2 dates (requires WooCommerce 5.8.0 or later)
Update Current Product from WooCommerce: updated to operate on the current record or the found set of records
miscellaneous bug fixes

v2.0.2 2021-01-19

removed references to ProductImages::Position and ProductVariations::ImagePosition fields as no longer supported in WooCommerce REST API v3

v2.0.1 2021-01-11

fixed issue with product name in Help menu
optimised processing of bulk downloads (Orders, Products etc) by breaking each individual record into a separate $record variable within the loop
added cascading delete to the following table occurrences: ProductDefaultAttributes, OrderItemTaxes, CouponsAllCategories, CouponsAllProducts
miscellaneous bug fixes

v2.0 2020-12-16

updated to use native FileMaker scripts and functions only (requires FileMaker v16 or later)
removed all references to the BaseElements FileMaker plugin functions
replaced DeclareVariables custom function with JSON functions for passing script parameters
updated all popup windows to Card windows
updated header navigation to use native Button Bar
updated ErrorDescription custom function for FileMaker Pro v19
Get All Products: now checks for existing Product by WooCommerce ID and only downloads if no existing record found

v1.694 2021-01-11

removed references to ProductImages::Position and ProductVariations::ImagePosition fields as no longer supported in WooCommerce REST API v3

v1.693 2021-01-11

fixed issue with product name in Help menu
optimised processing of bulk downloads (Orders, Products etc) by breaking each individual record into a separate $record variable within the loop
updated ErrorDescription custom function for FileMaker Pro v19
added cascading delete to the following table occurrences: ProductDefaultAttributes, OrderItemTaxes, CouponsAllCategories, CouponsAllProducts
miscellaneous bug fixes

v1.692 2020-11-27

changed Media::FileUpload container field from Open to Secure storage
updated Trim4 custom function to 1.0v3
removed OrdersShippingLines::MethodTitle auto-enter calculation
fixed bug when downloading Orders Tax Line Items
downloading Orders now downloads Shipping Item Taxes

v1.691 2020-10-17

Products and ProductVariations now reference the stock_status field instead of the in_stock field
ProductVariations: updated to reference the status field instead of the visible field

v1.69 2020-08-11

added new custom function: FMTimestampToWooCommerce
Create Product in WooCommerce script: fixed bug when uploading date_on_sale_from in native branch and changed date_on_sale_from/date_on_sale_to fields to use the FMTimestampToWooCommerce custom function to specify timestamps instead of dates

v1.68 2020-07-20

added new example: delete Order in WooCommerce

v1.67 2020-04-19

updated GetValueFromListJSON custom function
added Update Order Webhook example (PHP API and Data API)

v1.66 2020-03-01

updated Category upload to allow uploading Images by reference to WordPress Media ID only
updated Webhooks scripts for Data API script step compatibility
updated Webhooks privilege set to have read/write access to the OrdersMetaData table

v1.65 2020-02-10

updated to v3 of the WooCommerce REST API (requires WooCommerce 3.5.x)
updated Webhooks Privilege Set to include FileMaker Data API (fmrest) extended privileges
added Data API compatible versions of New Customer Webhook and New Order Webhook PHP files
updated Process Webhooks Order script to support Data API PHP file
updated Process Webhooks Customer script to support Data API PHP file

v1.64 2019-10-28

added New Customer Webhook example
Products: uploading a Product now includes the Slug field (was previously not editable via the API)

v1.63 2019-09-16

updated Update Order Status in WooCommerce script to also update the Date Completed
added script to update the Product Stock Quantity only in WooCommerce

v1.62 2019-09-13

fixed upload Coupons for found set button (was set to run the update script)
updated Update Order Status in WooCommerce script to operate on current record or found set of records

v1.61 2019-07-15

added Delete Media example
added Open Media in WordPress example
updated Update Current Media from WordPress script to check for WordPress website settings/application password instead of WooCommerce API keys
added missing Show Custom Dialog step for found set confirmation in upload scripts

v1.6 2019-07-02

added examples for uploading media files directly from container fields to the WordPress Media Library
set all Number/Currency fields to use System Settings on layouts
added Group All Orders button on Product Details layout
added Group All Orders button on OrderItems List layout
Product Variations: added Delete Product Variation in WooCommerce example
updated to BaseElements plug-in to v3.3.8 (Code Signed) for FileMaker Pro 18 compatibility
changed Trigger on OrdersDateTo field to OnObjectExit
updated Process Webhooks Order script to not install the plug-in under FileMaker Server v16 or later

v1.55 2019-01-28

fixed issue with Product Variations Meta Data upload using native functions

v1.54 2018-12-16

Orders: fixed issue with the Set Paid field on the Orders Form layout
added the $$fmVersion set variable step to the Process Webhooks Order script

v1.53 2018-12-12

Orders: now supports uploading Orders from FileMaker to WooCommerce
Customers: fixed bug with Shipping Address upload
Orders: updated to download the WooCommerce order_key and added script to open the Customer Payment Page

v1.52 2018-06-14

added new custom function httpResponseCode
updated scripts to use httpResponseCode Custom Function to get the HTTP Response Code for native branch

v1.51 2018-06-04

updated native version Customer Meta Data to use JSONNull when value is empty to permanently delete the Meta Data from WooCommerce
updated webhookNewOrder.php to fix issue with JSON structure
added new table occurrence OrderItemsOrdersMetaData to link OrderItems to related Meta Data for each line item
added new layout: OrderItemsMetaData Popup and button to add to Order Items portal if required to view Order Item Meta Data

v1.5 2018-05-14

updated for native FileMaker Pro v16 or higher functions/scripts
adjusted anchoring for Product Tags portal on Products Form layout
added upload Product using Perform Script on Server example
updated default value for empty Product Images array
moved Variations Visible checkbox from the Advanced tab to the General tab (this controls the enabled state of the Product Variation)
updated ‘Update Current Order from WooCommerce’ script to remove pagination loop for Order Notes and fixed bug when downloading Line Item Meta Data
when updating a Category from WooCommerce it now clears the Image container if empty in WooCommerce
removed ‘text’ option for Attribute Type value list as the “Type” column was removed by default in WooCommerce 3.3.2
Coupons: fixed issue with uploading/downloading excluded_product_ids
Product Variations: change Shipping Class to use slug instead of name value
Contacts: added conditional formatting to Customers Form layout to highlight mandatory fields
added new custom functions: Trim4 and GetValueFromListJSON
updated WooCommerceCategoryJSON calc to exclude Parent if empty (will likely be fixed in WooCommerce 3.4.0)
Categories: fixed issue with Image Title when updating Category from WooCommerce

v1.37 2018-05-01

fixed bug with Get Account Creation Settings script

v1.36 2018-02-19

remove pagination loop when downloading Payment Gateways as all Payment Gateways are always returned

v1.35 2018-02-03

updated upload scripts to check that the $parameters variable is not empty
when downloading Attribute Terms it first checks for existing Attributes
added new layout ProductCustomAttributeOptions Popup to demonstrate data entry of Custom Product Attributes
minor bug fixes

v1.34 2017-11-14

fixed privileges for Trial Version
updated Get Orders to check for existing Order by WooCommerce ID and skip if already exists
updated Product Update from WooCommerce script to delete related ProductMetaData before redownloading
download now only includes REST API v2 file

v1.33 2017-08-31

Products: added support for Grouped Products
Products: added Delete Product in WooCommerce example
Download Product Images now remains on the Images TAB when completed
add View Product Image Webviewer (don’t need to download Images into Container field to View them)
fixed bug during Orders download when attempting to link Order to existing Customer

v1.32 2017-06-13

fixed object anchor issues on Coupons Form layout
updated WooCommerceProductVariationJSON calculation to include reference to the FlagVisible field
updated scripts that download Variation/s to set the FlagVisible field

v1.31 2017-05-06

updated GET Product Attributes to not use pagination
minor changes to Get Account Creation Settings script

v1.3 2017-05-29

now supports the WooCommerce v2 REST API only
Product Variations are now stored in their own table to match the new Variations endpoint (you can now update Variations independently of their parent Product)
added support for new Payment Gateways endpoint
added support for new Shipping Methods endpoint
added support for new Shipping Zones endpoint
added support for new Shipping Zone Locations endpoint
added support for new Shipping Zone Methods endpoint
Get Product Categories now downloads the Image date_created_gmt and date_modified_gmt fields
Get Product Coupons now downloads the date_created_gmt, date_modified_gmt and ExpiryDateGMT fields and updated to get the date_expires instead of expiry_date
changed WooCommerceCouponJSON to reference date_expires instead of expiry_date
Coupons: added UsageLimitXItems field
Coupons: added Meta Data
Get Customers now downloads the date_created, date_modified , date_created_gmt, and date_modified_gmt fields
Customers: added Meta Data
OrderNotes: added DateCreatedGMT
changed OrderItemMeta table to OrderMetaData
Orders: added Meta Data
Orders: date_paid from WooCommerce is now converted from a WooCommerce timestamp
Products: now downloads the date_created_gmt, and date_modified_gmt fields
ProductImages: now downloads the date_created_gmt, and date_modified_gmt fields
added missing Set Variable $error step when there is an HTTP request error to all GET scripts
fixed issue when uploading a Product with no Images when Product previously contained images

v1.28 – 2017-05-25

remove pagination loop when downloading Order Notes as all Notes are always returned

v1.27 – 2017-05-05

updated to Base Elements plug-in v3.3.4
fixed bug in WooCommerceCategoryJSON calculation with empty Images
added “parent” element to WooCommerceCategoryJSON calculation

v1.26 – 2017-03-10

Orders: you can now update the Order Status in WooCommerce from FileMaker
Attributes: you can now create and update Attributes
Terms: you can now create, update and delete Terms
Tax Rates: you can now create and update Tax Rates
Tax Rates: changed Rate field from Number to Text data type
Tax Classes: you can now create Tax Classes
Product Tags: you can now create and update Product Tags
Product Categories: you can now create and update Product Categories
Shipping Classes: you can now create and update Shipping Classes
updated Get All Categories to also download Image details
updated all Update from WooCommerce scripts to check for existence of WooCommerce ID first

v1.25 – 2017-02-22

fixed bug with $url when updating Customer, Order and Coupon for non HTTP Basic Auth requests
changed update Product request to use PUT instead of POST
added FlagVariable to Products to identify which Product records are variations
added Default Attributes for Product Variations
updated Products upload to prevent uploading of child variation records
added Account Creation username/password flags in the Setup screen

v1.24 – 2017-02-06

updated ConvertBooleanFMtoWooCommerce custom function to encode a boolean not a string (true instead of “true”)
updated GET Customers script to check for existing Customer records with matching WooCommerce ID and update if already exists

v1.23 – 2017-01-31

when editing Product Attributes for Variations it now only lists the options available for the Parent Product
changed OrderNumber field from number to text data type

v1.22 – 2017-01-24

updated GET list requests to sort by WooCommerce ID

v1.21 – 2017-01-23

trial version modifications

v1.2 – 2017-01-20

added option to toggle between HTTP Basic Auth and query string parameters for servers that may not parse the Authorization header correctly
added Order Item Meta values to Orders Form and Order Items List layouts
added support for downloading, updating and creating Product Variations

v1.1 – 2016-12-21

added support for Order Created WooCommerce Webhooks
updated Order Update script to create/link to Customer record if exists
added Open Order in WooCommerce script
added Open Customer in WooCommerce script
fixed navigation from Customers to Orders

v1.0.1 – 2016-12-15

updated Get All Orders to set the FileMaker Customer ID into the Order record
updated Get All Orders to ignore WooCommerce Customer ID 0 (guest orders)

v1.0 – 2016-12-14

initial public release