---
title: "Action: Serial-numbered items (product instances)"
description: "Imports individually tracked product instances (serialized units) into Sapera. Rows are matched on the instance Identifier; matched instances are updated and new ones are created. Run Compare first to preview the changes."
url: https://support.sapera.io/en/articles/587-action-serial-numbered-items-product-instances
collection: "SyncTool"
updated: 2026-09-25
language: en
alternates: [da]
---

# Action: Serial-numbered items (product instances)

Imports individually tracked product instances (serialized units) into Sapera. Rows are matched on the instance Identifier; matched instances are updated and new ones are created. Run Compare first to preview the changes.

Imports individually tracked serial-number items (serialized units) into Sapera. Rows are matched on the instance Identifier; matched instances are updated and new ones are created. 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 instance's **identifier** (Identifier). Matching instances are updated and new ones created.

-   Each instance belongs to a product (ProductIdentifier) and can carry a serial number and current owner.
    
-   Only the instances in your source are processed. Direction: from file/SQL into Sapera.
    

## Key parameters

<table data-id="2d8a5585-63e9-4525-be7a-983eed5b8a63" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="ccfc2d25-d2b6-4987-b602-cff64b5a2884" style="text-align: left;"><strong>Parameter</strong></p></td><td colspan="1" rowspan="1"><p data-id="0818dded-2f2f-41ee-8aa7-feb843994365" style="text-align: left;"><strong>Explanation</strong></p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="22151af1-eaee-4605-8017-d3f513914593" style="text-align: left;">AllowCreate</p></td><td colspan="1" rowspan="1"><p data-id="505e69d7-f001-41cd-883b-e6ab7e602c54" style="text-align: left;">When enabled, instances that do not yet exist are created.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="ac02405e-78a0-43be-80f2-baa415031ddc" style="text-align: left;">AllowCreateCatalogValues</p></td><td colspan="1" rowspan="1"><p data-id="2a580d37-8bea-4054-be68-afabd2f52587" style="text-align: left;">When enabled, missing catalog/attribute values are created during import.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="f215465a-58ee-4c19-bb45-f9103ae4276d" style="text-align: left;">AllowUpdate</p></td><td colspan="1" rowspan="1"><p data-id="4afe7e53-e695-48df-9c5e-da90b0fc07cb" style="text-align: left;">When enabled, existing instances are updated with the imported values.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="1099ad09-fa81-4fbc-9e4e-0973ff280d63" style="text-align: left;">InstanceTemplate</p></td><td colspan="1" rowspan="1"><p data-id="13462870-efc9-4c03-96e6-d7d5567b852d" style="text-align: left;">System name of the template used when creating new instances.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="b218fd6d-5a37-4f04-955c-c057239cba10" style="text-align: left;">StockDraft</p></td><td colspan="1" rowspan="1"><p data-id="cd164f31-00fd-4756-8c68-f46069c1b0d4" style="text-align: left;">Name of the stock draft used when stock counts are imported.</p></td></tr></tbody></table>

## Source fields

<table data-id="ff327dfb-104e-4b71-9530-a63fc0e52213" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="4f292c14-8d60-4053-9809-f993dfb60757" style="text-align: left;"><strong>Field</strong></p></td><td colspan="1" rowspan="1"><p data-id="393fb00f-bd2f-40c6-b0e6-440bcc6ee84c" style="text-align: left;"><strong>Explanation</strong></p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="b8d8b8f2-1070-4cf8-9330-b88a19210af1" style="text-align: left;">AddressLine1</p></td><td colspan="1" rowspan="1"><p data-id="64e8d935-1aa1-472e-97d8-118f1bd7f6c2" style="text-align: left;">First address line for the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="230e0960-ef8d-4748-b093-a30693d53068" style="text-align: left;">AddressLine2</p></td><td colspan="1" rowspan="1"><p data-id="c10b0054-7e8f-43e7-ac00-fc9b9116c637" style="text-align: left;">Second address line for the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="38f2ecd8-e29c-4886-957d-a05356647be0" style="text-align: left;">BarCode</p></td><td colspan="1" rowspan="1"><p data-id="65e49cc1-bfe3-4ecf-9300-f461f4de5f6f" style="text-align: left;">Bar code of the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="497f26c5-6fb5-44ec-bcfb-4f549a2f8d23" style="text-align: left;">Country</p></td><td colspan="1" rowspan="1"><p data-id="6b2f24d7-8a7d-4d17-8405-40d3a75fe5d1" style="text-align: left;">Country of the instance address.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="3922c7f7-51c3-4f2b-b4a2-dfa66335b74f" style="text-align: left;">CurrentOwnerIdentifier</p></td><td colspan="1" rowspan="1"><p data-id="6d7cdd23-0d12-4de6-a0b1-64f9e8848446" style="text-align: left;">Identifier of the actor that currently owns the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="d01a119f-0ad3-41f1-ade5-76c7dfc73e95" style="text-align: left;">DiscountPrice</p></td><td colspan="1" rowspan="1"><p data-id="353e7ee9-bdc4-4e7e-a020-7957af8a0b26" style="text-align: left;">Discounted sales price of the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="1afb7737-28c2-4f54-8203-a16be52cdd85" style="text-align: left;">DisplayName</p></td><td colspan="1" rowspan="1"><p data-id="3a10eb7c-d944-425b-ba32-998218aa65ae" style="text-align: left;">Name shown for the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="0f308cd8-d9f1-40e0-8006-e43b0921af90" style="text-align: left;">Identifier</p></td><td colspan="1" rowspan="1"><p data-id="d55a7e10-ab29-46b9-94d5-45ea6808521b" style="text-align: left;">Unique identifier of the serial-number item; used to match rows.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="c92931de-5ea2-4f28-ab7a-1d41fb88f393" style="text-align: left;">IsUsed</p></td><td colspan="1" rowspan="1"><p data-id="1e93c985-120d-40a8-9cbf-069555411f39" style="text-align: left;">Whether the instance is used (second-hand).</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="ab386131-764d-4abc-b114-7a0a920fcbae" style="text-align: left;">PostalCode</p></td><td colspan="1" rowspan="1"><p data-id="6c620bd6-e18e-41cb-a7e1-0f51a23f4a41" style="text-align: left;">Postal code of the instance address.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="c8e96ce4-7f8a-4c78-b2d7-b1484e2d5d9c" style="text-align: left;">PostalDistrict</p></td><td colspan="1" rowspan="1"><p data-id="d3c38a69-df7c-4922-baac-3e1b29168ada" style="text-align: left;">Postal district of the instance address.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="7f525efa-75fb-4906-a6c0-46225dcc364a" style="text-align: left;">ProductIdentifier</p></td><td colspan="1" rowspan="1"><p data-id="a032a805-c823-4a4a-9647-3c8918da77fc" style="text-align: left;">Identifier of the product this instance belongs to.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="0938ff50-bc01-4f4b-9da4-9271867f1287" style="text-align: left;">PurchasePrice</p></td><td colspan="1" rowspan="1"><p data-id="2eed2875-8c21-4a7f-a601-30828a175fc3" style="text-align: left;">Purchase price of the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="903884a8-b4fd-404b-ac08-97fdfb8c70d8" style="text-align: left;">RegistrationNo</p></td><td colspan="1" rowspan="1"><p data-id="7c9e17fa-1b4a-4747-9da6-2fcd0150ea38" style="text-align: left;">Registration number of the instance (for example a vehicle plate).</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="36a05521-743d-426e-bae8-6a68d9cd4a61" style="text-align: left;">Remark</p></td><td colspan="1" rowspan="1"><p data-id="ebefdb02-a72a-47bf-b12e-412d018522ce" style="text-align: left;">Free-text remark on the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="89cee086-b6ac-431d-aa09-180ebb150d47" style="text-align: left;">SalesPrice</p></td><td colspan="1" rowspan="1"><p data-id="8aff22bd-eba2-46a6-8e8a-69e90d0f7966" style="text-align: left;">Sales price of the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="47cfae4b-ada4-4d4a-b460-80390a92cd17" style="text-align: left;">SerialNumber</p></td><td colspan="1" rowspan="1"><p data-id="f00f2b22-23cd-4f32-a9a1-b0b7c38cf5fb" style="text-align: left;">Serial number of the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="6d777599-52fd-412b-85ba-0f41cae9a8d8" style="text-align: left;">SoldAt</p></td><td colspan="1" rowspan="1"><p data-id="f1a102a9-94e9-48dc-b0ba-841780a39be3" style="text-align: left;">Date and time the instance was sold.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="1f872217-2cc6-4bbf-8171-e2ea874e0db6" style="text-align: left;">State</p></td><td colspan="1" rowspan="1"><p data-id="f7b1212d-f7c5-4075-bc7d-c9e1501bb13b" style="text-align: left;">Current state of the instance.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="1fa36209-1402-4429-85f4-162481d3f35d" style="text-align: left;">WorkflowCommunicationInitiationDate</p></td><td colspan="1" rowspan="1"><p data-id="f63e2801-3c32-4a5a-9a1c-4945e750025c" style="text-align: left;">Date the workflow communication was initiated.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="a47faea7-55f7-4212-a1be-eb8ad9fd1dbf" style="text-align: left;">WorkflowCommunicationType</p></td><td colspan="1" rowspan="1"><p data-id="bd62f047-7204-498b-8af5-b838d84b1d64" style="text-align: left;">Type of workflow communication associated with the instance.</p></td></tr></tbody></table>

* * *

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)
