Multivers - Item Update

This document describes the process of updating items, including their prices, stock levels, and other attributes from Multivers to App4Sales.

Data Source Configuration

The connector retrieves item data from the Multivers API. The following endpoints are used:

Products: /api/V3/Product
Product Groups: /api/V3/ProductGroup
Product Attributes: /api/V3/ProductAttribute
Product Attribute Values: /api/V3/ProductAttributeValue
Product Notes: /api/V3/ProductNote
Product Language Notes: /api/V3/ProductLanguageNote
Product Categories: /api/V3/ProductCategory
Product Classifications: /api/V3/ProductClassification
Product Sales Prices: /api/V3/ProductSalesPrice
Stock: /api/V3/StockForProduct/ByProductCodes
Price Lists: /api/V3/PriceList
Price List Prices: /api/V3/PriceListPrice or /api/V2/PriceListPrice
Tier Prices: /api/V3/DiscountProductDiscount
Customer Specific Prices: /api/V3/CustomerSpecificPrice

Data Mapping

App4Sales Field	Source Field (API/Excel/DB)	Logic/Notes
ItemCode	ProductCode, UnitCode	Concatenated from ProductCode and UnitCode if the setting 'ItemCode includes unit code' is enabled. For example: 'ITEM001_PCS'.
Name	Description	The description of the product.
Description	ProductNotes	Notes associated with the product.
Price	SalesPrice	The sales price of the product. The connector can be configured to divide the sales price by a factor.
VatPercentage	VatRates	The VAT rate is determined based on the VAT group of the product.
PurchasePackageSize	UnitRelations or ProductAttributes	Can be derived from unit relations or a specific product attribute.
IsActive	Blocked, Inactive	Items are marked as inactive if they are blocked or inactive in Multivers.

Matrix & Attributes

The connector synchronizes product attributes and attribute values from Multivers. These are used to create item classes and item class values in App4Sales, which can be used for filtering and creating matrix items.

App4Sales Entity	Source Entity	Logic/Notes
ItemClass	ProductAttribute	Each 'ProductAttribute' in Multivers is created as an 'ItemClass' in App4Sales.
ItemClassValue	ProductAttributeValue	Each 'ProductAttributeValue' is created as an 'ItemClassValue' and linked to the corresponding 'ItemClass'.

Price Logic

The connector supports various pricing scenarios:

Base Prices: Loaded from 'PriceListPrice' or 'ProductSalesPrice' endpoints.
Price Lists: Different price lists can be defined in Multivers and are synced to App4Sales.
Tier Prices: Quantity-based discounts are supported through the 'DiscountProductDiscount' endpoint.
Customer-Specific Prices: Prices specific to a customer are retrieved from the 'CustomerSpecificPrice' endpoint.
Customer Discounts: Discounts for specific customer groups can be configured.

App4Sales Field	Source Field	Logic/Notes
Code	PriceListCode	The code of the price list.
Description	Description	The description of the price list.

App4Sales Field	Source Field	Logic/Notes
ItemCode	ProductCode, UnitCode	Mapped to the App4Sales ItemCode.
Price	Price	The price for the item in the specific price list.

App4Sales Field	Source Field	Logic/Notes
ItemCode / ItemGroup	ProductCode / ProductGroupCode	Can be linked to a specific item or an entire item group.
CustomerCode	DebtorCode	Can be specific to a customer.
MinQuantity	QuantityFrom	The minimum quantity for the discount to apply.
Discount	DiscountPercentage	The discount percentage for the tier.

Stock & Availability

Stock information is retrieved from the /api/V3/StockForProduct/ByProductCodes endpoint. The connector can be configured to sync stock for specific warehouses.

App4Sales Field	Source Field	Logic/Notes
Stock	FreeStock	The available stock for the product. The connector can be configured with a stock formula to calculate the final stock value.
Warehouse	Warehouse	The warehouse for which the stock is synced.

Related Settings & Prerequisites

ItemCode includes unit code: Determines if the unit code is appended to the item code.
Sync tier prices: Enables or disables the synchronization of tier prices.
Use unit relations for purchase package size: Determines if the purchase package size is derived from unit relations.
Use product attribute for purchase package size: Specifies a product attribute to be used for the purchase package size.
Warehouse: Specifies the warehouse(s) to sync stock from.
Sync only items from product classification: Filters items based on their product classification.
Sync only items with attribute value: Filters items based on their attribute values.

Known Limitations

The documentation is based on the provided code and may not cover all configurations and edge cases.

Multivers - Item sync