Product
Overview
📥 Direction: Retail Express → Zudello
🔄 Sync Type: Incremental sync
🏷️ Categories: Auto-created from product type data
Product data flows from Retail Express to Zudello. This integration automatically creates item categories and maps comprehensive product information.
Product Features
✅ Two-Phase Processing - Creates item categories before products
✅ Automatic Categorization - Product types become item categories
✅ Price Management - Separate selling and purchase prices
✅ Barcode Integration - Supplier SKU mapping to barcode field
Key Behaviours
- Category Creation: The integration first extracts unique product types from the product data and creates them as item categories in Zudello.
- Product Processing: It then processes the product records, linking them to the corresponding item categories.
- Description Fallback: If a product's
short_descriptionis not available, a fallback description is created using the product ID. - Status Sync: The product's status is determined by the
disabledfield in Retail Express.disabledproducts are set toINACTIVE, otherwise they areACTIVE.
Field Mappings
Product Fields
| Zudello Field | Retail Express Field | Notes |
|---|---|---|
| SKU | id | The product ID from Retail Express. |
| Description | short_description | The product's description. A fallback is used if empty. |
| Barcode | supplier_sku | The supplier's SKU is used as the barcode. |
| Status | disabled | INACTIVE if disabled, ACTIVE otherwise. |
| Sell Price | sell_price_inc | The selling price, including tax. |
| Purchase Price | buy_price_ex | The purchase price, excluding tax. |
| Item Category | product_type.name | The product's category, derived from its type. |
Item Category Fields (Auto-created)
| Zudello Field | Retail Express Field | Notes |
|---|---|---|
| Name | product_type.name | The name of the product type. |
| Status | N/A | Defaults to "ACTIVE". |
Troubleshooting
| Issue | Cause | Solution |
|---|---|---|
| Product not syncing | The product has not been recently modified in Retail Express. | Check the product's modification date in Retail Express. |
| Missing categories | The product type is not set in Retail Express. | Verify the product type configuration in Retail Express. |
| Missing descriptions | The short_description field is empty. | Add product descriptions in Retail Express. |
| Status incorrect | The disabled flag is not set correctly. | Review the product's status in Retail Express. |
| Barcode missing | The supplier_sku field is empty. | Check the supplier SKU field in the product master data. |