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. |