Skip to content
All articles

Zoho Inventory implementation: catalogue, orders and stock reconciliation

Warehouse worker scanning a container with a tablet
Photo by Tiger Lily on Pexels

Implement Zoho Inventory by defining product identities, stock-tracking choices and opening quantities before connecting daily transactions. Then test how the chosen workflow changes stock and records exceptions. Importing an item list is not the same as proving that orders, receipts and adjustments reconcile.

Zoho’s official item guide explains catalogue setup, while its inventory-adjustment guide distinguishes quantity corrections from value changes and supports serial- and batch-tracked adjustments. Use those documented behaviours to build an acceptance record for the actual organisation. They do not establish Zambian tax compliance or that every feature is included in every plan. Zoho item setup, inventory adjustments.

What should the catalogue contain before import?

Agree the product identifier, description, sales unit and stock-tracking method. Separate variants that need independent inventory records. Keep an existing SKU map so staff can connect historical documents with the new catalogue instead of relying only on similar names.

Identify which products are inventory-tracked and which represent services or other non-stock items. Zoho’s adjustment documentation explicitly limits stock adjustments to inventory-tracked items. A product record existing in the catalogue does not automatically mean every inventory operation applies to it.

For serial- or batch-tracked stock, collect the corresponding opening information before migration. A total quantity without its required tracking identities can leave staff unable to perform the intended operations. Do not invent batch references to make the import pass; record missing information as an exception that needs resolution.

How do stock transactions and adjustments differ?

Record type Intended meaning Evidence to preserve
Ordinary business transaction Receipt, sale or other defined workflow event Linked source document and stock effect
Quantity adjustment Correction where recorded quantity differs from available stock Warehouse, reason and quantity evidence
Value adjustment Change in recorded inventory value Approved valuation basis and affected item
Draft adjustment Proposed record not yet treated as adjusted Pending decision and responsible role
Converted adjustment Applied adjustment in the documented workflow Final reference and resulting balance

The table combines Zoho’s documented distinctions with editorial evidence requirements. It does not prescribe an accounting policy or claim that every unexplained difference should be repaired through an adjustment.

When is a quantity adjustment appropriate?

Zoho describes quantity adjustments for discrepancies outside ordinary business activity, including damaged goods, data-entry errors and write-offs. It asks the operator to select an account, reason, warehouse and affected items.

Use that structure to explain a correction rather than conceal a missing transaction. If a receipt or sale was never entered, investigate the source event before making a balancing adjustment. Otherwise the stock total may look right while the document trail remains wrong.

The adjustment form accepts a new available quantity or an adjusted quantity and calculates the related field. Record which value was entered and inspect the resulting stock position. A sign mistake can create a different result from the intended correction even when the form saves successfully. Quantity-adjustment workflow.

What changes for batches and serial numbers?

Zoho documents adjustment routes for serial- and batch-tracked items. For batches, the process includes selecting existing batches or adding batch numbers for the adjusted units. That means the overall quantity and its tracking allocation need to agree.

Test an adjustment using a controlled sample item and inspect the resulting batch quantities. Do not stop at the product total. An apparently correct total can conceal stock assigned to the wrong batch or location.

Keep the authoritative source of the tracking information. For a correction, retain the reason and supporting record rather than silently replacing the prior value. This is an editorial control requirement, not a claim that Zoho supplies every desired approval or audit field without configuration.

An original opening-stock reconciliation card

Complete this card for each representative product group:

Identity: old identifier, new item identifier and variant mapping.

Unit: receiving, storage and selling units with the approved relationship between them.

Location: warehouse and any required stock-location detail.

Tracking: untracked, serial-tracked or batch-tracked, with source evidence.

Opening position: counted quantity and the record supporting its valuation.

Import result: records accepted, rejected and requiring correction.

Transaction test: ordinary receipt or sale and its resulting stock movement.

Adjustment test: draft correction, applied correction and resulting quantity.

Exception: unexplained difference, missing identity or unsupported operation.

Acceptance: actual outcome and the role responsible for resolving remaining gaps.

The card is original implementation guidance. It does not establish an opening balance by itself or authorise a financial adjustment. The business must supply the source evidence and approved treatment.

How should order and stock reconciliation be tested?

Create a representative transaction in the authorised test organisation and follow its effect through the intended documents. Include a partial quantity, a return or correction and an item that should not affect physical stock. Record actual results rather than assuming the catalogue setting guarantees the whole flow.

The opened item and adjustment pages do not prove every order integration or fulfilment configuration. Obtain the applicable transaction documentation for the selected workflow and mark those capabilities unconfirmed until demonstrated. Do not use a general product feature list as evidence that a particular ecommerce connector is configured correctly.

After each test, compare the starting quantity, documented movements and ending quantity. Investigate a difference through the source records. Avoid repeatedly changing opening stock to make a report agree, because that can obscure the cause.

What should the handover explain?

Document who can create items, change tracking choices, enter adjustments and resolve import errors. Distinguish saving a draft from applying an adjustment. Keep the reasons list meaningful enough that reports can explain corrections later.

Also retain the catalogue mapping and migration boundary. Staff should know which historical records remain in the previous system and which are available in Zoho. A clean new item list does not prove all outstanding transactions were transferred.

Discuss the implementation through Spout’s web development service or start an enquiry with the catalogue map and reconciliation cards.

Include a rejected import row in the handover. Record the original value, rejection reason and correction applied. A successful re-import should be checked for duplicate item creation so an apparently clean catalogue does not conceal two identities for the same stock.

For any separately built stock connector, identify the hosting owner and recovery route alongside the Zoho item setup.

By Spout Team. Prepared with AI-assisted drafting using the linked primary documentation.

Make your next move.

A website, a store or a clearer digital plan. Let’s start with your business.

Start your brief