Skip to main content

InforLn - Item sync

InforLN - ItemUpdate This function syncs item data from the InforLN ERP system to App4Sales. It retrieves item details, including pricing,...

Updated over a week ago

InforLN - ItemUpdate

This function syncs item data from the InforLN ERP system to App4Sales. It retrieves item details, including pricing, stock, images, and attributes.

Data Source Configuration

The connector pulls data from an InforLN web service. It uses the A4SListItems endpoint to get item data and the GetFilterNames to get item classifications.

App4Sales Field

Source Field (API/Excel/DB)

Logic/Notes

ItemCode

ID (attribute of Entity node)

The unique identifier for the item.

EanCode

items.EanCode

The EAN barcode for the item.

Description

items.Description

The name or description of the item.

SalesPrice

items.SalesPrice

The base sales price of the item. Parsed as a decimal using an invariant culture.

PurchasePackageSize

items.PurchasePackageSize

The quantity per purchase package. Parsed as a decimal using an invariant culture.

VatPercentage

items.VatPercentage

The VAT percentage for the item. Parsed as a decimal using an invariant culture.

Currency

items.Currency

The currency for the base price. If empty, it defaults to "EUR".

VatIncluded

Hardcoded

Hardcoded to 'E'.

LastAvailableStock

items.LastAvailableStock

The available stock for the item. Parsed as a decimal using an invariant culture.

Price Logic

The connector supports a main sales price and up to three additional price lists.

App4Sales Field

Source Field (API/Excel/DB)

Logic/Notes

PriceListPrice.Price

items.Price_2

The price for "Pricelist 2".

PriceListPrice.PriceListId

Hardcoded

The ID of the price list, in this case '2'.

PriceListPrice.ItemCode

ID (attribute of Entity node)

The unique identifier for the item.

App4Sales Field

Source Field (API/Excel/DB)

Logic/Notes

PriceListPrice.Price

items.Price_3

The price for "Pricelist 3".

PriceListPrice.PriceListId

Hardcoded

The ID of the price list, in this case '3'.

PriceListPrice.ItemCode

ID (attribute of Entity node)

The unique identifier for the item.

App4Sales Field

Source Field (API/Excel/DB)

Logic/Notes

PriceListPrice.Price

items.Price_4

The price for "Pricelist 4".

PriceListPrice.PriceListId

Hardcoded

The ID of the price list, in this case '4'.

PriceListPrice.ItemCode

ID (attribute of Entity node)

The unique identifier for the item.

Image Handling

The connector can process a single image per item.

App4Sales Field

Source Field (API/Excel/DB)

Logic/Notes

Item.PicturesBytes

items.Picture

The image is provided as a base64 encoded string. The connector decodes the string and adds the image data to the item.

Matrix & Attributes

Item attributes are created based on the filters defined in the InforLN environment.

App4Sales Field

Source Field (API/Excel/DB)

Logic/Notes

ItemClass.Description

Caption (attribute of Entity node from GetFilterNames)

The name of the item attribute (e.g., "Color", "Size").

ItemClassValue.Value

ItemClassValue[ID] (e.g., "ItemClassValue1", "ItemClassValue2")

The value for the corresponding item attribute. The connector iterates through the filters and looks for a field with the pattern "ItemClassValue" + filter ID.

Did this answer your question?