--- title: "Action: Product suppliers" description: "Imports the link between products and their suppliers into Sapera. Rows are matched on product identifier together with supplier identifier; new links are created and existing ones updated. Run Compare first to preview the changes." url: https://support.sapera.io/en/articles/589-action-product-suppliers collection: "SyncTool" updated: 2026-09-25 language: en alternates: [da] --- # Action: Product suppliers Imports the link between products and their suppliers into Sapera. Rows are matched on product identifier together with supplier identifier; new links are created and existing ones updated. Run Compare first to preview the changes. Imports the link between products and their suppliers into Sapera. Rows are matched on product identifier together with supplier identifier; new links are created and existing ones updated. Run Compare first to preview the changes. ## How to use the action 1\. Select the action in the **Action** field. 2. Point to your data source – a **file** (CSV or Excel) or a **SQL query**. 3. Map the source columns to Sapera's fields in the column mapping (see _Source fields_ below). 4. Run **Compare** to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run **Update Sapera** to perform the import. Use the **Allow create** and **Allow update** parameters to control whether new rows are created and whether existing ones are updated. ## How matching and updating works Each row is matched on the combination **product + supplier** (ProductIdentifier + SupplierIdentifier). If the link does not exist it is created; otherwise the cost price, the supplier's own item number and the main-supplier flag are updated. - **Both the product and the supplier must already exist** in Sapera – otherwise the row is skipped with an error. - Mark a row for deletion to remove the link between product and supplier. Direction: from file/SQL into Sapera. ## Key parameters

Parameter	Explanation
AllowCreate	When enabled, product-supplier links that do not yet exist are created.
AllowUpdate	When enabled, existing product-supplier links are updated.

## Source fields

Field	Explanation
CostPrice	Cost price the supplier charges for the product.
IsDelete	When set, the product-supplier link is removed instead of created or updated.
IsPrimary	Whether this supplier is the primary (main) supplier for the product.
ProductIdentifier	Identifier of the product; part of the match key.
ProductSupplierIdentifier	The supplier's own item number for the product.
SupplierIdentifier	Identifier of the supplier; part of the match key.

* * * See also the overview [SyncTool – actions](https://support.sapera.io/en/articles/547-synctool-handlinger.md). * * * **Want to know more?** Read more in these related articles: [ Standard parameters for all actions The general parameters available on most SyncTool actions: step control, error handling, timeout, etc. ](https://support.sapera.io/en/articles/648.md)