Paste your Google Sheet ID below. All price data and SE accounts will be loaded from your sheet — admin updates reflect instantly for all SEs.
1
Create a Google Sheet with two tabs: Products and SEs
2
In the Products tab, add headers: categorynamepacks1s2qs2s3qs3mrpgst
3
In the SEs tab, add headers: idnamepinterritoryisAdmin
4
Click Share → Anyone with the link → Viewer
5
Copy the Sheet ID from the URL — the long string between /d/ and /edit
Could not connect to this Sheet. Make sure it is shared as "Anyone with the link can view".
EZY Distribution
PRICEPORTAL
Sales Executive Login
Invalid SE ID or PIN
·
EZY PRICES
Shop tier:
EZY ADMIN
Data source: Google Sheets · All changes made in the sheet are reflected for SEs on their next load or refresh.
Sync from Google Sheets
Click to pull the latest data from your sheet right now. SEs always get fresh data on login.
——
To add or remove SEs: Edit the SEs tab in your Google Sheet, then click Sync. Changes reflect for all SEs immediately.
SE Sheet columns
id — e.g. SE001 name — Full name pin — 4-digit PIN territory — Territory name isAdmin — TRUE for admin access
SE Accounts—
Quarter Tier Report: Download every outlet's tier standing for any date range as Excel. Net collection = payments received minus customer refund/adjustment journal entries. Figures are recalculated live from ERPNext, so they can be cross-checked anytime.
📊 Quarter Tier Report (Excel)
Pick the quarter window. For the previous 2-month quarter, set the number of months to 2 so the monthly-equivalent (and tier) is correct.