Zoho CRM does not natively store line items as a built-in feature within the standard Deals, Accounts, or Contacts modules. Line items are typically managed through integrations with e-commerce platforms or custom implementations using related lists and linked records.
Why this matters
If you're syncing orders from platforms like WooCommerce into Zoho CRM, you'll need to understand how to extract and organize individual line item data. This becomes critical when you want to track product details, quantities, and pricing at a granular level within your CRM records, rather than storing entire orders as single entries.
Step-by-step
Step 1. Understand where line items live in your integration
Line items from external sources like WooCommerce are typically stored within an array structure in the incoming data payload. When integrating e-commerce orders, each order contains a line items array that holds individual product records. You'll need to parse this array to extract each item separately rather than treating the entire order as a single record. [1]
Step 2. Use a workflow or automation to split array data
If you're using Zoho's native automation tools (Workflows or Automation Rules), configure a loop or iteration function to process each element in the line items array. For each iteration, create a new related record in a custom module or a line items list that captures the product name, quantity, unit price, and total for that specific item. This transforms the flat array into individual, queryable records within Zoho CRM.
Step 3. Create a related list or custom module for line items
Set up a dedicated module (for example, "Order Line Items") with fields matching your product data: Product Name, SKU, Quantity, Unit Price, and Total Amount. Link this module to your Orders or Deals module using a lookup or parent-child relationship. This structure allows you to view all line items associated with a single order and run reports across line item data. [1]
Step 4. Map incoming data to your line item fields
When data flows in from WooCommerce or another e-commerce platform, ensure your integration middleware (such as Zapier, Make, or a custom API call) maps each array element to the corresponding fields in your line items module. For instance, map lineitems[0].productname to the Product Name field, line_items[0].quantity to the Quantity field, and so on.
Step 5. Verify data integrity and test with sample orders
Before going live, run a test integration with a sample order containing multiple line items. Check that each line item appears as a separate record in your line items module and that the parent-child relationship correctly links them to the order. Confirm that totals and quantities are accurate and that no data is lost during the array parsing process.
Common pitfalls
- Treating the entire array as a single string: If you don't parse the array, you'll end up with unreadable, concatenated text instead of individual records.
- Losing data during mapping: Ensure every field in your line items array has a corresponding target field in Zoho CRM; unmapped fields will be discarded.
- Forgetting the parent relationship: Without linking line items back to their parent order, you'll lose the context of which items belong to which order.
What to check
- Verify that each line item from your source order appears as a separate record in Zoho CRM.
- Confirm that the parent-child relationship between orders and line items is correctly established and visible in related lists.
- Run a sample report filtering by line item fields (e.g., product name or quantity) to ensure data is queryable and properly structured.
---
*This article is provided by Beam Help — independent expert support for Zoho. We are not official Zoho support.*