Items and product mapping
How an order line finds its Zoho item, and how to send one Shopify SKU to a different Zoho item and quantity.
Each line on a Zoho sales order or invoice should point at a Zoho item, so sales and stock are reported correctly. Open Orders → Documents & Accounting and find Items on orders.
How a line finds its item
Zync uses the first of these that applies:
- Product mapping. A row for the line's SKU in the product mapping table (when it is switched on).
- Existing link. The variant is already linked to a Zoho item, from a product sync or an AI match. This link is always used.
- Search Zoho, using Match items by.
- Create the item, or send the line by name. See below.
When a search finds the item, Zync saves the link on the Shopify variant, so the next order with that variant needs no search.
Match items by
| Option | Zync searches Zoho by |
|---|---|
| SKU, then name | The SKU. If nothing matches, the product name |
| SKU only (strict) | The SKU and nothing else |
| Name, then SKU | The product name. If nothing matches, the SKU |
SKU only (strict) never falls back to the name, so it cannot pick up a different item that happens to have the same name. Choose it when your SKUs are reliable.
Create the item in Zoho when none matches
| Setting | What happens to a line with no match |
|---|---|
| On (default) | A new item is created in Zoho and used on the line |
| Off | The line is sent with its name and price but no item link |
Turn it off if your Zoho item list is controlled and should not gain items from orders.
Product mapping
Use product mapping when what you sell in Shopify is not the unit you stock in Zoho. The classic case: Shopify sells a case of 24, Zoho stocks single cans.
Turn on Apply product mappings, then add rows:
| Shopify SKU | Zoho item | Zoho units per Shopify unit |
|---|---|---|
COLA-CASE-24 | Cola 330ml Can | 24 |
COLA-6PK | Cola 330ml Can | 6 |
To add a row:
- Type the Shopify SKU.
- Type part of the Zoho item's SKU or name in Search Zoho by SKU or name and click Search.
- Choose the item from the list.
- Enter the number of Zoho units in one Shopify unit.
- Click Add, then save.
What a mapped line looks like
An order for 2 cases at 480.00 each is sent to Zoho as:
| Quantity | Rate | Line total | |
|---|---|---|---|
| Shopify | 2 × Cola Case of 24 | 480.00 | 960.00 |
| Zoho | 48 × Cola 330ml Can | 20.00 | 960.00 |
The line total stays as it is in Shopify. Only the quantity and the unit rate change.
Good to know
- Refunds use the same mapping. Refunding one case credits 24 cans.
- Stock sync does not use this table. Inventory sync works on the direct link between a Shopify variant and its Zoho item.
- One Shopify SKU can have one row. Several SKUs can point at the same Zoho item.
- A mapping wins over the variant's own Zoho link, so you can map a SKU even if its product has synced.
- Switch Apply product mappings off to pause all rows without deleting them.