New: payments, credit notes, tax mapping and order reconciliation for Zoho Books — see all features
Product Sync

Selling Cases and Packs: Map One Shopify SKU to Many Zoho Units

Shopify sells a case, Zoho stocks the can. Learn how product mapping in Zync sends one Shopify SKU to a different Zoho item and quantity on orders and refunds, while the line total stays exactly as charged.

The unit mismatch

Your storefront and your back office count things differently, and both are right.

On Shopify, a product is whatever a customer adds to the cart. If you sell sparkling water by the case, the case is the product. It has its own SKU, its own price, and its own photo of a neatly stacked box.

In Zoho, the item is whatever you buy, store, and count. Your supplier invoices you per can. Your stock take counts cans. The purchase price, the valuation, and the reorder point are all per can. There may be no such thing as a case in Zoho at all.

Connect the two without thinking about this and every order line for a case tries to find an item for the case SKU. Either a new case item gets created that has no relationship to the cans it contains, or the line arrives with no item link. Your sales reports then show cases sold while your stock shows cans, and nobody can reconcile the two without a calculator.

What product mapping does

Product mapping is a small table that tells Zync how to translate a Shopify SKU when it builds an order document.

You will find it under Orders, on the Documents & Accounting tab, in the Items on orders card. The app describes it in one sentence: send a Shopify SKU to a different Zoho item and quantity, for example one case to 24 cans, and the line total stays as in Shopify.

Each row has three parts:

  • Shopify SKU, the SKU on the order line.
  • Zoho item, the item the line should use in Zoho.
  • Zoho units per Shopify unit, how many of that Zoho item one Shopify unit represents.

When an order contains a mapped SKU, the Zoho line is written for the mapped item, using that item's name, with the quantity multiplied by your units figure.

A worked example: one case, 24 cans

Say the case sells for 48.00 and a customer buys two.

In Shopify the line is two units at 48.00, for a line total of 96.00.

With a mapping of 24 Zoho units per Shopify unit, Zync writes the Zoho line as 48 units of the can item at a rate of 2.00, for a line total of 96.00.

The quantity went up by 24 and the rate went down by 24. The total did not move. This is the part that matters for accounting: the invoice in Zoho adds up to exactly what Shopify charged, so the order still matches when you reconcile the month, and the sale is now recorded against the item you actually stock.

Because the rate is the Shopify line amount divided by the new quantity, it follows the price on that order. Change the case price next month and the per-can rate on new documents changes with it. You do not maintain a second price list.

Setting up a mapping

  • Open Orders and go to the Documents & Accounting tab.
  • Scroll to Items on orders and find Product mapping.
  • Turn on the Apply product mappings switch.
  • In the empty row, type the Shopify SKU exactly as it appears on the variant.
  • In Search Zoho by SKU or name, type at least two characters and select Search. Pick the right item from the list that appears.
  • Set Zoho units per Shopify unit. It must be a whole number of 1 or more.
  • Select Add, then save the page.

The SKU comparison ignores upper and lower case, and each Shopify SKU can appear only once in the table. The search returns up to 20 matching Zoho items, so if the one you want is not in the list, search with its exact SKU or a more specific part of its name.

The switch is separate from the table on purpose. You can build out your rows, review them, and turn the feature on when you are ready. Turn it off and the rows stay saved but stop applying.

How it sits alongside item matching

The same card has two other settings that decide how an unmapped order line finds its item.

Match items by has three options: SKU, then name, which is the default; SKU only (strict), which never falls back to the name and so cannot pick up a same-named duplicate; and Name, then SKU. Whatever you choose, a variant that is already linked to a Zoho item always uses that link first.

Create the item in Zoho when none matches is on by default. Turn it off and an unmatched line is sent by name with no item link, which is the safer choice once your catalog is fully mapped and a new item would only ever be a mistake.

A product mapping takes priority over all of that. If the line's SKU has a row in the table and the switch is on, the line uses the mapped item, and no matching or item creation happens for it. That is also why product mapping is useful even at a quantity of 1: it is a direct way to say that this Shopify SKU is that Zoho item, whatever the names look like.

For a whole catalog that needs linking, that is a job for AI product matching, which links variants to items one to one. Product mapping is the tool for the cases where one to one is the wrong shape.

Refunds follow the same mapping

A mapping that only worked in one direction would make things worse. If the sale recorded 24 cans and the refund credited one case, your item reports would never net to zero.

Refunds use the same table. When a Shopify refund becomes a credit note in Zoho, a refunded case is credited as 24 cans of the mapped item. The app says so directly under the table: refunding one case credits 24 cans.

This means the sale and its reversal are always expressed in the same unit. The broader refund flow, including how the credit note is applied to the invoice, is covered in refunds to credit notes.

What product mapping does not touch: stock sync

This is the most important limit to understand, and the app states it under the table as well. Stock sync does not use this table.

Inventory sync works from the link between a Shopify variant and its Zoho item. It moves quantities between a variant and the item that variant is linked to. It has no idea that your case SKU means 24 of something else, and it does not convert.

So product mapping changes documents: sales orders, invoices, and credit notes. Whether and how Zoho reduces stock for those documents is up to your Zoho setup, in the same way it would be if someone had typed the invoice by hand.

In practice:

  • If the case variant in Shopify is not linked to a Zoho item, inventory sync leaves it alone, and you manage the case's available quantity in Shopify yourself.
  • Do not link the case variant to the can item for stock purposes. The numbers would be read as if one case were one can.
  • If you need Shopify's case availability to follow can stock automatically, that calculation has to happen outside this feature.

More on how stock moves is in the inventory sync guide.

Discounts and tax on mapped lines

Mapping changes the item, the quantity, and the rate. Everything else on the line is worked out from the Shopify line as usual.

  • Discounts are taken from the Shopify line. With discounts shown on each line item, the discount is applied to the mapped line as a percentage, so it scales correctly with the new quantity.
  • Tax comes from the tax Shopify charged on that line and goes through your tax mapping like any other line.
  • SKU on the line, if you have Show the SKU on each line turned on, shows the original Shopify SKU in the description. That is handy here, because it keeps a trace of what the customer actually bought next to the item you stock.

Common patterns

  • Cases and cartons. One case SKU to 12, 24, or 48 of the single unit.
  • Multipacks. A three-pack variant to three of the single item. Each pack variant gets its own row with its own units figure.
  • Several storefront SKUs, one stocked item. A gift-boxed version and the plain version both mapped to the same Zoho item at 1 unit each, when you do not track the box separately.
  • Renamed or legacy SKUs. A Shopify SKU that no longer matches Zoho, pointed at the correct item at 1 unit so orders stop creating a stray item.

One thing a row cannot do is split a single Shopify SKU across several different Zoho items. Each SKU maps to one item and one quantity. A hamper containing three different products is outside what this table expresses.

Test it with a dry run

Before you rely on a new mapping, check one order without writing anything. On the Backfill tab, choose By order numbers, enter an order that contains the mapped SKU, tick Dry run, and start it. The result is written to the Logs page and nothing is created in Zoho. Then sync that one order for real and open the document in Zoho to confirm the item, quantity, rate, and total. The process is described in backfilling historical orders.

Next step

List the Shopify SKUs that represent more than one stocked unit. For most stores it is a short list. Add a row for each under Orders, Documents & Accounting, Items on orders, switch on Apply product mappings, and sync one test order. The reference for every setting in that card is in items and product mapping, and the wider feature is described on the order sync page.

TopicsProduct SyncProduct MappingOrder SyncUnits of MeasureZoho InventoryZoho Books
FAQ

Common questions

What does product mapping do?
It sends a Shopify SKU to a different Zoho item and quantity when an order syncs. For example, one case sold in Shopify can become 24 cans of the single-can item in Zoho. The line total stays the same as in Shopify.
Does the price change when a line is mapped?
The line total does not change. Zync multiplies the quantity by the units you set and divides the unit rate by the same number, so the Zoho line adds up to what the customer was charged.
Do refunds use the mapping too?
Yes. Refunds use the same table. Refunding one case creates a credit note line for 24 cans of the mapped Zoho item.
Does product mapping change inventory sync?
No. Stock sync does not use the product mapping table. It follows the link between each Shopify variant and its Zoho item, so the mapping affects order and refund documents only.
Where do I set up product mapping?
Under Orders, on the Documents and Accounting tab, in the Items on orders card. Turn on Apply product mappings, enter the Shopify SKU, search for the Zoho item, set the Zoho units per Shopify unit, and select Add.
Can I use it to point a SKU at a different Zoho item without changing the quantity?
Yes. Leave the units at 1. The order line then uses the Zoho item you picked in place of whatever the SKU would have matched on its own.

Connect Shopify and Zoho in an afternoon

Start a free trial, connect your Zoho org, and run a dry-run backfill to see exactly what would land in Zoho. No engineering required.