Legacy bridge

Role: Migrate and transform data from the Optimizers-platform into the OCP, ensuring compatibility and data integrity.

Table of Contents

1. Overview
2. Item Migration
   • Stocks
   • Prices
   • ItemImages
3. Customer Migration
   • Customer Attributes
   • Contact-person Attributes
   • Address Attributes

Overview

The LegacyBridge is a data-migration component responsible for:

1. Extracting records from the Optimizers-platform
2. Converting them into a format the OCP accepts
3. Applying corrective rules to satisfy OCP’s stricter validation

The LegacyBridge runs after every synchronization cycle, ensuring that any changes in the Optimizers-platform are reflected in the OCP.

Item Migration

Stocks

• Default Warehouse: All stock records are assigned to the "General" warehouse.
• Negative Quantities: Any negative stock levels are reset to 0 to prevent validation errors.

Prices

• Default Pricelist Creation: For each currency detected in the Optimizers-platform, the LegacyBridge generates a corresponding default pricelist in OCP.
• Price Assignment: Each item’s price in OCP is initialized from the default price in the Optimizers-platform.

ItemImages

• Format Conversion: Optimizers-platform exports images as optimized JPGs (no alpha channel).
• Transparency Limitation: PNGs or formats with transparency cannot be generated—images remain opaque.

Item Attributes

The LegacyBridge transfers additional item-specific metadata into OCP via the Attributes system when present:

Attribute	Source Field	Description
PurchasePackageSize	item.PurchasePackageSize	Package size quantity for purchase.
EanCode	item.Eancode	European Article Number (barcode).
ItemType	item.ItemType	Classification or category of the item.
MinimumOrderQuantity	item.MinimumOrderQuantity	Smallest allowable order quantity per item.

Stocks

• Default Warehouse: All stock records are assigned to the "General" warehouse.
• Negative Quantities: Any negative stock levels are reset to 0 to prevent validation errors.

Prices

• Default Pricelist Creation: For each currency detected in the Optimizers-platform, the LegacyBridge generates a corresponding default pricelist in OCP.
• Price Assignment: Each item’s price in OCP is initialized from the default price in the Optimizers-platform.

ItemImages

• Format Conversion: Optimizers-platform exports images as optimized JPGs (no alpha channel).
• Transparency Limitation: PNGs or formats with transparency cannot be generated—images remain opaque.

Customer Migration

OCP models customers, contacts, and addresses via a flexible Attributes system. The LegacyBridge copies relevant fields into these attributes if present.

Customer Attributes

Attribute	Source Field
Fax	Customer fax number
Website	Customer website URL
CustomerManager	Assigned account manager
CustomerClassification	Tier or segment classification
PaymentConditionCode	Payment terms code
DeliveryMethod	Default delivery method code

Contact-person Attributes

Attribute	Source Field
Function	Job title/role
MiddleName	Second given name

Address Attributes

Attribute	Source Field
AddressLine2	Secondary street line
AddressLine3	Tertiary street line
Fax	Fax number at address