Item

Overview

📥 Direction: Sage X3 → Zudello
🔄 Sync Type: Incremental sync
⏱️ Frequency: Based on _updateStamp

Item/product data flows from Sage X3 to Zudello to provide comprehensive product catalog information with pricing and status details.

Key Benefits

✅ Product Catalog Integration - Complete product information synchronization
✅ Pricing Structure - Include both purchase and selling prices
✅ Multiple Descriptions - Support for multiple description fields with localization
✅ Status Management - Active/inactive product status tracking

Field Mappings

Zudello Field	Sage X3 Field	Data Type	Notes
sku	code	String	Product code
short_description	description1 or localizedDescription1	String	Short description with fallback
description	description1 or localizedDescription1	String	Same as short description
purchase_price	purchaseBasePrice	Decimal	Base purchase price
sell_price	basePrice	Decimal	Base selling price
status	productStatus	String	ACTIVE if "active", INACTIVE otherwise
document_type	N/A	String	Always "ITEM"
module	N/A	String	Always "INVENTORY"
submodule	N/A	String	Always "CATALOGUE"

Configuration Requirements

Global Product Import

Product synchronization has no legislation filter and imports all products from Sage X3. This supports comprehensive inventory management.

Processing Logic

Sync Behavior

• Global Products: No legislation filter - imports all products from Sage X3
• Multiple Descriptions: Supports multiple description fields (description1, description2, description3) with localization
• Incremental Updates: Uses _updateStamp to fetch only changed records

Data Handling

• Status Mapping: Maps Sage X3 productStatus "active" to "ACTIVE", others to "INACTIVE"
• Description Fallback: Uses description1 or localizedDescription1 as primary description
• Pricing Integration: Includes both purchase and selling price information
• Cost Type Reference: Includes cost type relationships for advanced categorization

Status Logic

Product status is determined by Sage X3 productStatus field:

• "active" → ACTIVE in Zudello
• Any other value → INACTIVE in Zudello

Product Structure

The integration supports complex product information:

• Multiple Descriptions: description1, description2, description3 with localized versions
• Pricing Tiers: Both purchase and selling prices included
• Alternate Products: Query includes alternate product information
• Cost Type Relationships: Links to cost type classifications

Troubleshooting

Issue	Cause	Solution
Product not syncing	_updateStamp not updating	Verify modification tracking in Sage X3
Missing descriptions	Empty description fields	Check product descriptions in Sage X3
Incorrect status	Product status misconfigured	Review productStatus field in Sage X3
Pricing issues	Empty price fields	Verify purchase and selling prices in Sage X3

Related Documentation

• Supplier - Vendor product relationships
• BP Supplier Invoice - Product usage in invoices
• Currency - Multi-currency product pricing
• Account - Product account assignments