Zync Docs
Orders & Accounting

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:

  1. Product mapping. A row for the line's SKU in the product mapping table (when it is switched on).
  2. Existing link. The variant is already linked to a Zoho item, from a product sync or an AI match. This link is always used.
  3. Search Zoho, using Match items by.
  4. 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

OptionZync searches Zoho by
SKU, then nameThe SKU. If nothing matches, the product name
SKU only (strict)The SKU and nothing else
Name, then SKUThe 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

SettingWhat happens to a line with no match
On (default)A new item is created in Zoho and used on the line
OffThe 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 SKUZoho itemZoho units per Shopify unit
COLA-CASE-24Cola 330ml Can24
COLA-6PKCola 330ml Can6

To add a row:

  1. Type the Shopify SKU.
  2. Type part of the Zoho item's SKU or name in Search Zoho by SKU or name and click Search.
  3. Choose the item from the list.
  4. Enter the number of Zoho units in one Shopify unit.
  5. Click Add, then save.

What a mapped line looks like

An order for 2 cases at 480.00 each is sent to Zoho as:

QuantityRateLine total
Shopify2 × Cola Case of 24480.00960.00
Zoho48 × Cola 330ml Can20.00960.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.