Flowpeak ConsultingFlowpeak Logo Mark

Zoho implementation for Supermarkets and Grocery

Zoho for supermarkets and grocery: manage multi-store stock, suppliers, expiry, loyalty and daily accounting.

Business process workflow

How supermarkets and grocery work flows in Zoho

Manage multi-store stock, suppliers, expiry, loyalty and daily accounting.

Common problems we fix

  • Expiry losses are high
  • Store stock differs from books
  • Supplier orders are placed manually

The process, step by step

  1. 1

    Item and price master

    SKUs, prices and promotions.

  2. 2

    Purchase and receiving

    Orders and goods receipt.

  3. 3

    Store stock

    Counts, transfers and expiry.

  4. 4

    Sales posting

    Daily sales into accounts.

  5. 5

    Loyalty

    Offers to repeat customers.

  6. 6

    Store reports

    Margin and stockouts.

Department by department

How every department of a supermarkets and grocery business works in Zoho

A supermarket or grocery chain buys thousands of fast-moving items, receives them daily, sells at the till and online, and fights shrinkage and expiry. In Zoho category buying, the warehouse, stores, online orders, accounts and HR share one item master and one price list, so stock and margin are the same number everywhere.

How the departments hand work to each other

Each arrow is a handover. Because every team works on the same Zoho records, the next department picks up the work without re-entering it.

  1. 1Category Management and Buying to Replenishment and Purchasing: Approved range, suppliers and order rules
  2. 2Category Management and Buying to Store Operations: Price changes and promotions to set on shelf
  3. 3Replenishment and Purchasing to Distribution Centre: Expected deliveries and slots
  4. 4Replenishment and Purchasing to Finance and Accounts: Purchase orders for bill matching
  5. 5Distribution Centre to Store Operations: Transfers with crates and delivery note
  6. 6Distribution Centre to Finance and Accounts: Goods receipts for three-way match
  7. 7Store Operations to Replenishment and Purchasing: Store sales and stock levels for reorder
  8. 8Store Operations to Finance and Accounts: Daily sales and banking
  9. 9Online Orders and Home Delivery to Finance and Accounts: Online sales, payment gateway settlements and refunds
  10. 10Online Orders and Home Delivery to Store Operations: Picks drawn from store stock
  11. 11Customer Service and Loyalty to Category Management and Buying: Buying patterns of loyal customers
  12. 12Customer Service and Loyalty to Store Operations: Store complaints to fix
  13. 13Finance and Accounts to Management and Reporting: Store and category profit and cash
  14. 14HR and Payroll to Finance and Accounts: Payroll totals by store
  15. 15Management and Reporting to Category Management and Buying: Category targets and margin goals
  16. 16Management and Reporting to Store Operations: Store targets

Each department in detail

Open a department to see its workflow, its own entity diagram, who does the work, what needs approval, the reports it watches and what it hands over.

Category Management and BuyingDecides what to stock, at what price and from whom, and negotiates terms with suppliers.

Workflow

  1. 1

    Maintain the item master

    Each SKU has barcode, category, pack size, tax rate, shelf life and supplier in Zoho Inventory.

  2. 2

    Negotiate supplier terms

    Supplier terms such as margin, credit days, display fees and return rules are recorded per supplier.

  3. 3

    Set prices and promotions

    Regular prices and weekly offers like buy one get one or price cuts are set by store group with start and end dates.

  4. 4

    Review range

    Slow-moving and low-margin SKUs are reviewed monthly for delisting.

Entity diagram: Category Management and Buying

The records this team creates and updates, their key fields, and how they link.

supplies (N:N)priced in (1:N)applies to (N:N)SKUInventoryBarcodeCategoryShelf lifeTax rateSupplierBooksNameCredit daysReturn policyPrice ListInventoryStore groupPriceEffective datePromotionCreatorTypeStartEndFunded by
  • Zoho Inventory
  • Zoho Books
  • Zoho Creator
Read the relationships as text
  • Supplier supplies SKU (N:N)
  • SKU priced in Price List (1:N)
  • Promotion applies to SKU (N:N)
Who does the work
  • Category manager
  • Buyer
  • Pricing analyst
Approvals and controls
  • Prices below cost or margin floor need category head approval
  • New SKU listings are approved in the monthly range meeting
Reports they watch
  • Sales and margin by category
  • Promotion lift and cost
  • Slow movers and delist list
Hands over to
  • Replenishment and Purchasing: Approved range, suppliers and order rules
  • Store Operations: Price changes and promotions to set on shelf
Replenishment and PurchasingKeeps shelves full without overstock by ordering the right quantity for every store and the warehouse.

Workflow

  1. 1

    Calculate reorder needs

    Reorder points use recent sales, lead time and minimum display stock per store.

  2. 2

    Raise purchase orders

    Purchase orders go to suppliers for warehouse delivery or direct store delivery.

  3. 3

    Book delivery slots

    Suppliers get delivery slots at the warehouse dock to avoid queues.

  4. 4

    Chase short supply

    Fill rate is tracked and short deliveries are followed up with the supplier.

Entity diagram: Replenishment and Purchasing

The records this team creates and updates, their key fields, and how they link.

triggers (1:N)booked in (1:1)measured in (1:N)Reorder RuleInventorySKUStoreMinMaxPurchase OrderInventoryPO noSupplierDelivery toDelivery SlotBookingsDockDateSupplierFill RateAnalyticsSupplierOrderedReceived
  • Zoho Inventory
  • Zoho Bookings
  • Zoho Analytics
Read the relationships as text
  • Reorder Rule triggers Purchase Order (1:N)
  • Purchase Order booked in Delivery Slot (1:1)
  • Purchase Order measured in Fill Rate (1:N)
Who does the work
  • Replenishment planner
  • Purchase executive
Approvals and controls
  • Orders above the auto-order limit or for seasonal stock need buyer approval
Reports they watch
  • Out-of-stock by store and SKU
  • Days of cover
  • Supplier fill rate
Hands over to
  • Distribution Centre: Expected deliveries and slots
  • Finance and Accounts: Purchase orders for bill matching
Distribution CentreReceives supplier stock, stores it by expiry and ships accurate orders to stores.

Workflow

  1. 1

    Receive and check

    Deliveries are checked against the PO for quantity, batch and expiry, and short or damaged goods are noted.

  2. 2

    Store by expiry

    Stock is put away so the earliest expiry goes out first.

  3. 3

    Pick store orders

    Store indents are picked, packed in crates and loaded by route.

  4. 4

    Ship and transfer

    Transfer orders move stock to stores and the van trip sheet is closed on delivery.

Entity diagram: Distribution Centre

The records this team creates and updates, their key fields, and how they link.

fulfilled by (1:N)stocks (1:N)carries (1:N)Goods ReceiptInventoryPO refQty receivedBatchExpiryStore IndentInventoryStoreLinesRequired dateTransfer OrderInventoryFromToStatusRoute TripCreatorVanStoresDeparted
  • Zoho Inventory
  • Zoho Creator
Read the relationships as text
  • Store Indent fulfilled by Transfer Order (1:N)
  • Goods Receipt stocks Transfer Order (1:N)
  • Route Trip carries Transfer Order (1:N)
Who does the work
  • DC manager
  • Receiving supervisor
  • Picker
Approvals and controls
  • Receiving goods with less than the minimum remaining shelf life needs buyer approval
Reports they watch
  • Receipts versus PO
  • Pick accuracy
  • Store orders shipped on time
Hands over to
  • Store Operations: Transfers with crates and delivery note
  • Finance and Accounts: Goods receipts for three-way match
Zoho apps for this team:Zoho InventoryZoho Creator
Store OperationsRuns each store day to day, from receiving and shelf filling to billing and closing.

Workflow

  1. 1

    Receive and fill shelves

    Store teams receive transfers and direct deliveries and refill shelves using the planogram.

  2. 2

    Sell at the till

    POS sales post item-level stock reductions and payments by mode to Zoho Inventory and Books through an integration.

  3. 3

    Manage expiry and markdowns

    Near-expiry items are marked down or pulled, and waste is recorded with reason.

  4. 4

    Count stock

    Cycle counts on high-value and high-shrink items find variances early.

  5. 5

    Close the day

    Cash, card and wallet totals are reconciled with POS and banked.

Entity diagram: Store Operations

The records this team creates and updates, their key fields, and how they link.

records (1:N)logs (1:N)runs (1:N)submits (1:N)StoreCreatorCodeFormatManagerDaily SalesBooksStoreDateNet salesTender mixWastageCreatorSKUQtyReasonStock CountInventorySKUSystem qtyCounted qtyDay CloseCreatorCashCardVariance
  • Zoho Creator
  • Zoho Books
  • Zoho Inventory
Read the relationships as text
  • Store records Daily Sales (1:N)
  • Store logs Wastage (1:N)
  • Store runs Stock Count (1:N)
  • Store submits Day Close (1:N)
Who does the work
  • Store manager
  • Shift supervisor
  • Cashier
Approvals and controls
  • Markdowns beyond the set percentage need area manager approval
  • Cash variances above the limit are investigated before the day is closed
Reports they watch
  • Sales by store and hour
  • Wastage and shrink by category
  • Cash variances
Hands over to
  • Replenishment and Purchasing: Store sales and stock levels for reorder
  • Finance and Accounts: Daily sales and banking
Online Orders and Home DeliveryTakes app and website orders, picks them from store or dark store and delivers in the promised slot.

Workflow

  1. 1

    Take online orders

    Orders come from the web store with delivery slot and payment status.

  2. 2

    Pick and substitute

    Pickers collect items and record substitutions or shortages, and the customer is told.

  3. 3

    Dispatch and deliver

    Riders are assigned by area and slot and mark delivery with proof.

  4. 4

    Handle returns and refunds

    Damaged or missing items are refunded or credited through the support desk.

Entity diagram: Online Orders and Home Delivery

The records this team creates and updates, their key fields, and how they link.

picked in (1:1)delivered by (1:1)may raise (1:N)Online OrderCommerceOrder noSlotPayment statusPick TaskCreatorPickerSubstitutionsStatusDeliveryCreatorRiderAreaDelivered atRefund RequestDeskReasonAmountStatus
  • Zoho Commerce
  • Zoho Creator
  • Zoho Desk
Read the relationships as text
  • Online Order picked in Pick Task (1:1)
  • Online Order delivered by Delivery (1:1)
  • Online Order may raise Refund Request (1:N)
Who does the work
  • Online operations lead
  • Picker
  • Delivery rider
Approvals and controls
  • Refunds above the set value need the online operations lead to approve
Reports they watch
  • Orders by slot and on-time delivery
  • Substitution and short-pick rate
  • Refunds by reason
Hands over to
  • Finance and Accounts: Online sales, payment gateway settlements and refunds
  • Store Operations: Picks drawn from store stock
Zoho apps for this team:Zoho CommerceZoho CreatorZoho Desk
Customer Service and LoyaltyRuns the loyalty programme and answers customer feedback from stores and online.

Workflow

  1. 1

    Enrol members

    Customers join the loyalty programme at the till or online with consent for messages.

  2. 2

    Track points and tiers

    Purchases earn points and members move between tiers by spend.

  3. 3

    Send targeted offers

    Offers go to members based on what they buy and how often.

  4. 4

    Handle complaints

    Store and online complaints are logged and resolved with an owner.

Entity diagram: Customer Service and Loyalty

The records this team creates and updates, their key fields, and how they link.

accrues (1:N)targets (N:N)raises (1:N)MemberCRMPhoneTierPointsPoints LedgerCreatorEarnedRedeemedDateOffer CampaignCampaignsSegmentOfferRedemptionsComplaintDeskStoreCategoryStatus
  • Zoho CRM
  • Zoho Creator
  • Zoho Campaigns
  • Zoho Desk
Read the relationships as text
  • Member accrues Points Ledger (1:N)
  • Offer Campaign targets Member (N:N)
  • Member raises Complaint (1:N)
Who does the work
  • CRM executive
  • Customer care executive
Approvals and controls
  • Goodwill points above the limit need the customer care lead to approve
Reports they watch
  • Active members and repeat rate
  • Offer redemption
  • Complaints by store and type
Hands over to
  • Category Management and Buying: Buying patterns of loyal customers
  • Store Operations: Store complaints to fix
Finance and AccountsPays suppliers correctly, reconciles daily takings and reports margin by store and category.

Workflow

  1. 1

    Match supplier bills

    Supplier bills are matched to PO and goods receipt, with short and damaged items debited.

  2. 2

    Claim supplier support

    Promotion funding, display fees and returns are raised as claims or debit notes on suppliers.

  3. 3

    Reconcile takings

    Store cash, card and wallet settlements are reconciled with bank statements.

  4. 4

    File taxes

    Sales and purchases feed GST returns in India or VAT returns in the UAE and UK.

  5. 5

    Report margin

    Gross margin by store and category is reported after wastage and shrink.

Entity diagram: Finance and Accounts

The records this team creates and updates, their key fields, and how they link.

adjusted by (1:N)feeds (1:N)costs (1:N)Supplier BillBooksSupplierPO refAmountDebit NoteBooksReasonAmountSupplierSettlementBooksModeExpectedReceivedStore P&LAnalyticsStoreSalesMargin
  • Zoho Books
  • Zoho Analytics
Read the relationships as text
  • Supplier Bill adjusted by Debit Note (1:N)
  • Settlement feeds Store P&L (1:N)
  • Supplier Bill costs Store P&L (1:N)
Who does the work
  • Accounts payable executive
  • Reconciliation executive
  • Finance manager
Approvals and controls
  • Supplier payments above the limit need finance manager approval
  • Bills without a matching goods receipt are held
Reports they watch
  • Payables due by supplier
  • Unreconciled settlements
  • Margin by store and category
Hands over to
  • Management and Reporting: Store and category profit and cash
HR and PayrollStaffs stores and the warehouse across long trading hours and pays them correctly.

Workflow

  1. 1

    Hire store staff

    Openings for cashiers, shelf fillers and pickers are tracked by store.

  2. 2

    Roster shifts

    Shifts are planned around trading hours, peak days and festivals.

  3. 3

    Track attendance

    Attendance and overtime are recorded per store.

  4. 4

    Run payroll

    Wages, overtime and incentives are paid in Zoho Payroll where it is available, or your local payroll provider.

Entity diagram: HR and Payroll

The records this team creates and updates, their key fields, and how they link.

works (1:N)records (1:N)receives (1:N)EmployeePeopleNameRoleStoreShiftShiftsStoreDateHoursAttendancePeopleDateOvertimeStatusPayslipPayrollMonthGrossNet
  • Zoho People
  • Zoho Shifts
  • Zoho Payroll
Read the relationships as text
  • Employee works Shift (1:N)
  • Employee records Attendance (1:N)
  • Employee receives Payslip (1:N)
Who does the work
  • HR executive
  • Area HR manager
Approvals and controls
  • Overtime beyond the store budget needs area manager approval
Reports they watch
  • Staff cost as share of sales by store
  • Roster coverage at peak hours
  • Attrition by store
Hands over to
  • Finance and Accounts: Payroll totals by store
Management and ReportingGives leaders a daily view of sales, stock, shrink and margin across all stores.

Workflow

  1. 1

    Combine data

    POS sales, stock, purchases and accounts sync into Zoho Analytics.

  2. 2

    Review daily trading

    Leaders check yesterday's sales, basket size and out-of-stocks.

  3. 3

    Review monthly

    Monthly reviews cover margin, shrink, wastage and staff cost by store.

  4. 4

    Act on alerts

    Alerts for high shrink, low stock on top SKUs and cash variances go to area managers.

Entity diagram: Management and Reporting

The records this team creates and updates, their key fields, and how they link.

triggers (1:N)triggers (1:N)Store KPIAnalyticsStoreMetricActualCategory KPIAnalyticsCategorySalesMarginAlertAnalyticsRuleOwnerStatus
  • Zoho Analytics
Read the relationships as text
  • Store KPI triggers Alert (1:N)
  • Category KPI triggers Alert (1:N)
Who does the work
  • Managing director
  • Head of retail
  • Finance head
Approvals and controls
  • New store openings and capital spend are approved by the board
Reports they watch
  • Like-for-like sales growth
  • Shrink and wastage percent
  • Sales per square foot
Hands over to
  • Category Management and Buying: Category targets and margin goals
  • Store Operations: Store targets
Zoho apps for this team:Zoho AnalyticsZoho FlowZoho Cliq

What to expect when you start

A typical plan for a focused project of one to three apps. Larger scope or messy data takes longer; we confirm the timeline after discovery.

  1. Week 1 to 2

    Map and agree

    We walk through your supermarkets and grocery process from "Item and price master" to "Store reports", list the records and fields you really need, and agree the scope.

  2. Week 3 to 4

    Build the core

    We configure Zoho Inventory and Zoho Books with your stages, roles, approvals and templates.

  3. Week 5 to 6

    Connect and migrate

    We clean and import your data, connect email, payments or other tools, and build the reports you will use every week.

  4. Week 7 to 8

    Test and go live

    Your team tests with real cases, we train each role, and we cut over with a checklist.

Mistakes to avoid

  • Copying the old spreadsheet column for column. Keep only the fields that help someone decide or act.
  • Leaving out exceptions such as returns, changes and cancellations. Model them early so the team does not work around the system.
  • No owner per stage. Name one person for "Item and price master" and one for "Store reports".
  • Going live without checking reports against numbers you already trust.

A good first win

Start with the problem that hurts most: Expiry losses are high. Fixing one visible problem in the first month builds trust and adoption for everything after it.

What you can measure

  • Stockouts
  • Expiry loss
  • Gross margin

Questions about Zoho for supermarkets and grocery

Which Zoho apps suit supermarkets and grocery businesses?

A typical supermarkets and grocery setup uses Zoho Inventory, Zoho Books, Zoho CRM, Zoho Campaigns, Zoho Analytics. We confirm the exact apps after mapping your own process in a discovery call.

How does the business process flow in Zoho for supermarkets and grocery?

1. Item and price master; 2. Purchase and receiving; 3. Store stock; 4. Sales posting; 5. Loyalty; 6. Store reports.

Which departments does a Zoho setup for supermarkets and grocery cover?

A full setup covers Category Management and Buying, Replenishment and Purchasing, Distribution Centre, Store Operations, Online Orders and Home Delivery, Customer Service and Loyalty, Finance and Accounts, HR and Payroll, Management and Reporting. Each department works in its own Zoho screens, but they share the same customer, order and finance records, so work moves from one team to the next without being retyped.

Zoho apps we set up for supermarkets and grocery

  • Zoho Inventory
  • Zoho Books
  • Zoho CRM

Not sure which apps fit your business? Book a free 30-minute call or see all Zoho products we implement

Book a free callWhatsApp