I see a Shopify ID in most tables – what is the purpose of these fields?
Most tables that upload to Shopify will contain a “Shopify ID” field named:
_kf_ShopifyID
These fields store the Shopify unique identifier for each Customer, Order, Product etc that you upload to Shopify or download from Shopify. The Shopify ID is generated automatically by Shopify - 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, Order, Customer etc has previously been uploaded (or downloaded from Shopify) – i.e. that FileMaker record also exists in Shopify. When uploading to Shopify if the “Shopify ID” field is empty a new record will be created in Shopify and the Shopify generated ID will then be stored in the Shopify ID field in the FileMaker record, otherwise the Shopify record that matches the “Shopify ID” field will be updated.
The Shopify IDs are generated by Shopify - you cannot create a value for these in FileMaker to upload. The fmEcommerce Link will handle populating these fields when downloading new records from Shopify or uploading new records to Shopify.
N.B. as these Shopify ID values should be unique make sure if you duplicate a Product, Variant, Customer etc that you clear out the value in these Shopify ID fields otherwise you will run into issues when uploading as it will be attempting to update that record in Shopify that matches the value in the Shopify ID field.