Multicase - Item Update

This process syncs item information from the Multicase API to App4Sales. It retrieves product data, pricing, and stock levels, then maps them to the App4Sales item structure. The sync also handles warehouse information and various pricing models, including customer-specific price lists.

Data Source Configuration

The connector fetches data from several endpoints in the Multicase API:

Products: Data is retrieved from the /products endpoint using a SenderId.
Warehouses: Warehouse information is fetched from the /warehouses endpoint.
Stock Levels: Stock data is retrieved from the /warehouses/stocklevels endpoint.
Prices: Pricing information is obtained from the /price-rules/price endpoint.
Images: Product images are retrieved from the /products/images endpoint.

Data Mapping Table

App4Sales Field	Source Field (API/Excel/DB)	Logic/Notes
ItemCode	ProductNumber	Direct mapping.
InternalItemCode	ProductId	Direct mapping.
Description	Description	Direct mapping.
Unit	Unit	Direct mapping.
EanCode	Ean	Direct mapping.
CreatedDate	RegDate	Direct mapping.
ItemType	ProductType	Direct mapping.
PurchasePackageSize	UnitsPerPackage	Direct mapping.
SalesPrice	PriceExVat.Sum	The sales price is determined based on the default currency and warehouse settings. If a specific price is not found for the default warehouse, the first available price is used.
VatIncluded	'E'	The VAT status is hardcoded to 'E' (exclusive).
VatPercentage	PriceIncVat.Sum, PriceExVat.Sum	Calculated based on the difference between the price including VAT and the price excluding VAT.
LastAvailableStock	AvailableForSale	Represents the stock available for sale in the default warehouse.
Free Fields	Derived	If the `ItemPricesAsFreeFields` setting is enabled, volume prices (where the quantity is greater than 1) are added as free fields.

Image Handling

The connector retrieves all product images from the API and links them to the corresponding items in App4Sales.

App4Sales Field	Source Field (API/Excel/DB)	Logic/Notes
ItemCode	ProductNumber	The item code is used to link the image to the correct product.
ImageUrl	Url	The URL of the image from the Multicase API.

Stock & Availability

Stock levels are retrieved per warehouse and then aggregated. The main stock value displayed on the item card is from the warehouse designated as the default stock source.

App4Sales Field	Source Field (API/Excel/DB)	Logic/Notes
AvailableStock	AvailableForSale	Total stock available for sale across all warehouses.
ToBeReceived	AvailableFromPurchaseOrders	Total stock expected from purchase orders.
ShelfStock	AvailableInWarehouse	Total physical stock in the warehouse.
Total available	AvailableForSale + AvailableFromPurchaseOrders	The sum of stock available for sale and stock expected from purchase orders.

Price Logic

The connector handles complex pricing scenarios, including a baseline price and customer-specific prices. A "template customer" is used to establish default prices. Any customer-specific prices that differ from this baseline are stored, and price lists are generated accordingly. The system can also merge duplicate price lists and maintains a record of these changes.

Matrix & Attributes

Product attributes are mapped to item categories in App4Sales. This includes standard group levels as well as any custom fields defined in Multicase.

App4Sales Field	Source Field (API/Excel/DB)	Logic/Notes
ItemCategories	Level1Group, Level2Group, Level3Group, Description2	These fields are mapped to item categories. Additional custom fields from the product data are also included as categories.

Related Settings & Prerequisites

DefaultSenderId: The sender ID used for API requests.
ProductTypesToSkipWhileSync: A comma-separated list of product types to exclude from the sync.
DefaultWarehouseIdForStock: The ID of the warehouse to use for the main stock value.
FilterProductsOnDefaultWarehouseId: If enabled, only products available in the default warehouse will be synced.
TemplateCustomerId: The ID of the customer used to fetch default prices.
DefaultWarehouseIdForPrices: The ID of the warehouse used to determine the default sales price.
DefaultCurrencyCode: The currency code for the default prices.
ItemPricesAsFreeFields: When enabled, volume prices are added as free fields to the item.

Multicase - Item sync