fmEcommerce Link (WooCommerce Edition) Version History

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