fmEcommerce Link (WooCommerce Edition) Version History

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