Reflecta Connector - Item Update
This document describes the process for updating items, including their prices, stock levels, and attributes, from the Reflecta ERP system into App4Sales. The process involves downloading XML files from an FTP server, mapping the data to App4Sales items, and updating the database.
Data Source Configuration
The connector retrieves item and stock data from two XML files located in the /export directory on the configured FTP server:
Item Data:
itemdata.xmlStock Data:
stock.xml
The FTP connection details (host, username, password) are configured on the administration page for the Reflecta connector.
Data Mapping Table
The following table outlines the mapping from the source XML files to the App4Sales item fields.
App4Sales Field | Source Field (API/Excel/DB) | Logic/Notes |
ItemCode | ItemCode, ColorCode, SizeCode (from | Concatenated with underscores. Format: |
Description | ItemDescr (from | Direct mapping. |
SalesPrice | SalesPrice (from | Direct mapping. |
LastAvailableStock | AvailableStock (from | Matched based on ItemCode, SizeCode, and ColorCode. Defaults to 0 if no match is found. |
ItemClasses | ItemMainGroupDescr, ItemSubGroupDescr (from | Creates an ItemClass with the description from |
ExtraData | Multiple fields (from | A JSON object stored as a string, containing key-value pairs for additional item properties. See the "Extra Data" section for more details. |
FreeItemFields | Dynamically mapped (from | Created based on the ItemCategory configuration for free fields. |
Extra Data
The ExtraData field stores a JSON string with the following key-value pairs from the itemdata.xml file:
BrandCode
BrandDescr
ColorCode
ColorDescr
ItemDimensionSize
ItemDimension
SegmentCode
SegmentDescr
SizeCode
UnitOfMeasureCode
UnitOfMeasureDescr
ItemCode
Special Logic & Filters
Item Categories
Before processing items, the connector ensures that a specific set of 15 item categories exists in App4Sales. These categories are used for classifying and filtering items, and for creating free fields. The categories are:
BrandCode
BrandDescr
ColorCode
ColorDescr
ItemDimensionSize
ItemDimension
ProductGroupCode
ProductGroupDescr
SegmentCode
SegmentDescr
SizeCode
UnitOfMeasureCode
UnitOfMeasureDescr
ItemCode
ItemDescr
These categories can be configured as filters or free fields in the App4Sales CMS. When a category is marked as a filter, the connector will create a corresponding ItemClass. When marked as a free field, the data is stored in the FreeItemFields XML.
Related Settings & Prerequisites
The following settings must be configured for the item update to work correctly:
FTP Server Address, Username, and Password: Must be correctly configured to allow the connector to download the XML files.
Company Code: Required for sending orders, but not for item updates.