AirQR
AirQR Routes

AirQR Routes, customers, route stops and regular orders

Add the shops and people you sell to, with an optional GSTIN for registered businesses, import your list from a sheet, put them on a route in visiting order, set what each usually takes, and note the empties and the balance they already hold. Each customer's page shows what they bought, their latest bills, top products and visits.

9 min read

Customers (called Shops for dairy, bakery, eggs, soda and FMCG; Restaurants for fresh supplies) is the list of everyone you sell to. It is a section of its own in the menu, with your fixed routes beside it as a second tab once you have one. Fixed routes are optional; use Set up a fixed route on Shops, or Settings → Drivers and vans → Optional fixed routes. Each customer has a name, a mobile number, an optional shop name, where they are, which route visits them, and what they usually take. The list shows each customer's Last bill (or Never) and can be ordered with Sort by name or Sort by last bill, so you can see who has not bought lately.

Add a customer

  1. Customers, then the add button, named with your word (for example Add shop).
  2. Type the name and mobile number. Those two are all it takes.
  3. Optionally add the shop name, the type (shop, business or home), the address, the route, tags such as cafe or weekly, and notes.
  4. If Credit is on and you may manage it, you can switch on Credit allowed: days to pay, a credit limit, and Already owes for the balance you are carrying over from your books. Credit allowed starts off: a new customer is cash only (a credit limit of zero) until someone with the Credit permission turns it on. On with the limit left blank means no limit, so it is only ever your choice.
  5. If you use empties (crates, jars, trays), type how many each customer already holds today.
  6. For a registered business, add the GSTIN (optional): For a registered business. Their bills become business (B2B) bills. Then fill in the Legal name (left empty it uses the shop name, otherwise the name) and check the State, which is filled in From the GSTIN. A GSTIN needs the address: without it the form says Enter the address. A bill to a registered business (GSTIN) needs it. AirQR checks the GSTIN's shape and check digit, and refuses your own outlet's GSTIN. Setting a GSTIN needs routes.manage, like any other edit, and works with Credit off.

A customer with a GSTIN shows Registered (B2B) on their page. Their next bill carries them as the buyer, as a business (B2B) bill. Bills already issued never change. To stop billing them as a business, clear the GSTIN on Edit; the next bill is then an ordinary one.

One mobile number can have two shops: the same owner with Raj Dairy and Raj Sweets is fine. The same mobile number with the same shop name is the same customer, so adding it again opens the one you have instead of making a duplicate, and changes nothing on it.

Import from a sheet

Import takes a CSV or an Excel (.xlsx) file. Download the template first: it has one column for each of your empties.

  • Columns: shop_name, name, phone, type, address, route_code, credit_days, credit_limit, opening_balance, one opening_… column per kind of empties, tags, and the optional gstin and legal_name (the last two columns of the template). Money is in rupees. A blank legal_name uses the shop name, else the name.
  • Before anything is saved you see every row: ready, with a note (for example, the customer is already in your list and is left as it is) or to fix (no mobile number, an unknown route code, a number that is not a number, Not a valid GSTIN, or A GSTIN needs the address). Rows to fix are skipped; the rest go in.
  • Credit is off for every row unless the sheet turns it on: a credit limit puts the customer on credit with that limit, and days to pay with no limit means credit with no limit. Without the Credit permission the credit columns are ignored (the preview says so) and every row is cash only.
  • Big files are saved in batches of 200. Importing the same file twice changes nothing: nobody is added twice and no balance or empties are counted twice.
  • When it finishes you can download the result.

The customer page

  • Call and WhatsApp buttons, the balance and what is overdue (with Credit on), the empties they hold, and their routes. A customer with a GSTIN shows it, with Registered (B2B).
  • What they bought: Total bought, Bills, Average bill, Last bill and No-sale visits, for the Last 90 days or All time (use the toggle). Last bill shows its date and Today, Yesterday, {n} days ago or Never, and always looks at all time. The note under it says what is counted: van and counter bills that were not cancelled, less money given back on them (credit notes). The figures, bills, top products and visits cover the outlets you can see: your current outlet, or every Routes outlet of the business if you may see reports across outlets (reports.consolidated). With more than one outlet in view, each bill row also shows its outlet, and the note says how many outlets are counted. Nothing is stored or re-counted by hand: they are worked out from the bills when you open the page.
  • Bills: the latest 20 bills for this customer, van and counter, cancelled ones included and marked. Each row shows the date, the bill number, the document type, the amount and how it was paid (Cash, UPI, Card, Credit, Split or Not paid), with Counter, Cancelled, Returned (goods were taken back) or Refund (money was given back without a return) markers, and opens the bill at its own outlet. See all bills opens the Bills list for your current outlet, filtered to this customer (when the business has more than one Routes outlet the button reads See all bills at this outlet); a chip with their name and × shows the filter, and × removes it. The bill rows and See all bills are for people who may sell or manage Routes (routes.sell, routes.load or routes.manage).
  • Top products: the five products they take most, by quantity, with photos where products have them. It follows the same Last 90 days / All time toggle.
  • Location (the pin that the far-from-shop check compares bills with): stand at the door and tap Use my current location (your phone asks permission only then), or paste a Google Maps link that has the place in it. Short links such as maps.app.goo.gl hide the place, so open one in Maps first and copy the long address. Open in Maps shows the pin.
  • Regular order: how much of each product this customer usually takes, for each named trip, or Each trip. You can add a custom trip name such as School run or Round 3. Tap Save regular order. If you have no history yet, it is empty and the section says so.
  • History: what was changed and when, including opening balances and credit entries, and the visits that ended with no sale (No sale: {shop} closed or No sale: no order today, with the driver and their note). A new customer shows Added to your list once. A customer with no changes yet shows Nothing yet. The times are in your outlet's time zone, on every device. The full account is under Payments → Dues.
  • Edit, and Hide. Hiding a customer is refused while they owe money or still hold empties, and says which; settle or write that off first. A hidden customer leaves every route, keeps their history, and can be brought back.

Route stops

Open a route (Customers → Routes, then the stops line under it).

  • The button named with your word, for example Add shops, ticks several at once from a search; Add new shop (or customer, or restaurant) makes one right there and puts them on this route.
  • Put them in the order you visit them: drag the row on a computer, or use the up and down buttons (on a phone too).
  • Edit stop sets which of the route's trips visit this customer, and whether they follow the route's days or have their own.
  • A customer can be on more than one route. Taking someone off a route keeps them in your customer list.
  • The summary at the bottom shows how many stops there are and, for each trip, the total regular order of the customers visited on it. It is the starting point for the load the driver takes out.

Who can do what

  • Owner: everything on this page.
  • Manager: can look at customers and routes; adding, editing, importing, hiding and changing stops or regular orders need the owner to allow routes.manage in Team → Staff → Roles. Credit fields need the Credit permissions as well.
  • Driver: gets their route's customers in the Driver app, with what each owes and holds, and can add a new customer while billing.
  • Counter staff (anyone allowed to sell at the counter): can add a new customer while billing, including a GSTIN, even without routes.manage. See Selling at the counter.

Good to know

  • To confirm filters the list to customers added by drivers who still need checking. The customer carries a New · confirm badge. Choose Confirm customer to clear the badge once you have checked the details. A driver adds a customer with a name and mobile number, and can give credit on the first bill only if the business allows credit for new customers. If the driver allowed location, the place where that first bill was made becomes the customer's pin; see Driver location, Last seen and privacy.
  • When the customer owes money and you have permission to see and collect dues, Collect opens the payment form with their balance filled in. It records an outlet collection and applies it to the oldest dues first.
  • Export downloads the customers on screen as a CSV.

New to AirQR?

Try everything free for 28 days, no card needed. Already a customer? Sign in to follow these steps in your dashboard.

Still stuck? Contact support at support@airqr.in.