I see a WooCommerce ID in most tables – what is the purpose of these fields?
Most tables that upload to WooCommerce will contain a “WooCommerce ID” field named:
_kf_WooCommerceID
These fields store the WooCommerce unique identifier for each Customer, Order, Product etc that you upload to WooCommerce or download from WooCommerce. The WooCommerce ID is generated automatically by WooCommerce - do not attempt to populate these fields with your own values here.
These operate in a similar way to a primary key field does in FileMaker. If there is a value in these fields that means that the Product, Category, Customer etc has previously been uploaded (or downloaded from WooCommerce) – i.e. that FileMaker record also exists in WooCommerce. When uploading to WooCommerce if the “WooCommerce ID” field is empty a new record will be created in WooCommerce and the WooCommerce generated ID will then be stored in the WooCommerce ID field in the FileMaker record, otherwise the WooCommerce record that matches the “WooCommerce ID” field will be updated.
The WooCommerce IDs are generated by WooCommerce - you cannot create a value for these in FileMaker to upload. The fmEcommerce Link will handle populating these fields when downloading new records from WooCommerce or uploading new records to WooCommerce.
N.B. as these WooCommerce ID values should be unique make sure if you duplicate a Product, Category, Customer etc that you clear out the value in these WooCommerce ID fields otherwise you will run into issues when uploading as it will be attempting to update that record in WooCommerce that matches the value in the WooCommerce ID field.