Skip to content

Customer and Member

“We filled in the IC on the membership — why is Customer Maintenance blank?” The answer is that a member and a customer are two records. The membership card is what the loyalty side reads: points, class, labels. The customer is the account you bill, and it is what finance reads: credit terms, the statement, the tax identity that goes on an e-invoice. The two are linked when the card is made. After that, each keeps its own details, except for the two edits described below. This page is for whoever enrols members at the counter or keeps the member list, and for whoever is asked why the buyer’s IC is blank on an e-invoice.

Meet the example

GadgetSphere Sdn Bhd runs one loyalty programme across its 22 branches and its online store. A shopper can join at the till in GS-KV-01, on the GadgetSphere Online website, or through an import from the old loyalty system. Each of those routes attaches the new member to a customer differently, and that is where most of the surprises on this page start.

What each record holds, and which one a bill reads

One bill uses both records, for different jobs:

  • The member earns and spends the points. A bill awards points to the member named on it, and only when the bill is the document type and status your company set for points (an internal sales order at FINAL unless somebody changed it). The balance the till offers is a stored running total on the card, added to as each points line is written. It is not worked out from the customer.
  • The customer is billed. The customer is charged for the sale. When the bill is saved, the buyer’s name, ID type and number, phone and e-mail are copied onto it from the customer record. That copy stays on the bill, so correcting the customer next week does not change a bill already saved. The member’s own IC is not read for the e-invoice.
  • Picking a member at the till picks their customer. At the counter, choosing a member loads the customer linked to that card as the bill’s customer. On a till set up the default way, the lines already rung up, the settlement and the document links are cleared at the same moment. So pick the member before you scan the first item, unless your till’s settings keep the item list when the customer changes.

So a member’s points and a customer’s statement are two different figures, kept on two different records. A customer’s statement shows every bill charged to that customer, whichever card was on it. A card’s balance counts that card’s points only.

How each route attaches a member to a customer

RouteWhat it does about the customer
Membership Admin + (create), the Upload Membership CSV, the API’s plain createLooks for an existing record and takes the first it finds: one linked to the member’s login, then one with the same phone, then one with the same e-mail. If none matches, it creates a new customer with the member’s name, IC, phone and e-mail
POS General’s member addShows Possible Duplicate Found with every record that has the same phone or e-mail. The cashier picks one to link, or chooses Proceed Create New, which always makes a new customer. The till then writes the address and e-invoice details from its form onto whichever customer the card got
The API’s with customer route (integrations, migrations)Matches by customer code only, creates one when there is none, and writes the member’s name, IC, phone, e-mail and address over what the customer held
Storefront sign-up (CP Commerce Admin’s post-registration setting)Create membership and customer links the shopper’s customer. Create membership without customer leaves the card with none
ENTITY_LINKING_FOR_MEMBER_PROCESSOR, if you schedule itGives every member with no customer a brand-new one. It does no matching, and names the new customer from the part of the e-mail before the @, without the member’s name or IC. It is not a default clock

Three details of the first row decide whether a match is the one you meant:

  • “First” is the lowest internal record number. It is not the oldest customer, and not the most recently used one. When three records share a phone number, which one you get is effectively chance.
  • The phone and e-mail are compared character for character. A customer keyed as 012-345 6789 does not match a member keyed as +60123456789, so you get a second customer for the same person.
  • Any record counts, not just customers. A supplier or a staff record with the same phone or e-mail can be the one picked up, and so can a customer marked inactive.

A customer found this way keeps its own details: the member’s IC is not written onto it. That is the question at the top of this page. The new member at GS-KV-01 gave her IC, but her phone number already belonged to a customer with no identity fields, and that customer is the one her bills go to.

To re-point a card later, open the member in Membership Admin and change Customer Name on the Details tab. Saving the card does not repeat the matching.

Where each figure and detail comes from

On the screenRead fromWhen it is taken
Points balance on the card and at the tillThe card’s stored running totalUpdated as each points line is written
A customer’s statement, credit limit, outstandingThe customerLive, across every bill charged to that customer
Buyer name, ID type and number, phone and e-mail on a billA copy of the customerWhen the bill is saved, and only if the bill does not already have one
Customer Maintenance → Membership tabEvery card whose customer is this oneLive, each time the tab opens
The customer’s name and IC, when the customer was made for this memberThe member, copied onceAt the moment the card was created

The two edits that do cross over

Most edits stay on their own side. The Details tab’s IC, phone and e-mail change the card only. Two edits reach the other record, and both can reach further than you expect:

  1. A change of name, date of birth or gender on the card is copied onto the matching customer records, up to five individual ones that share the member’s e-mail or phone. It is also copied onto every card linked to those customers. The intent appears to be keeping one person’s name in step across their login, their customer and their card. Where a family shares one mobile number and one customer, though, renaming one card renames the customer and the other cards as well, and nothing tells you it happened. Before you rename a member who shares a phone or e-mail with someone else, give the card its own phone and e-mail, save, and then change the name.
  2. The E-Invoice tab on the member form appears only when the card has a customer. It reads that customer’s record and saves onto it: buyer name, phone, e-mail, ID type and number, and the tax fields. This is the quickest place to put a member’s IC where the e-invoice will find it. But if several cards share that customer, the change applies to all of them, because they are all billed to the same account.

Several cards on one customer, one card per person

Each card is one member, and the card has no “programme” field. What varies per member is the point currency: a card keeps a balance and a set of lots for each currency it has earned in.

The other direction is looser. Several cards can share one customer. A household on one mobile number does it naturally. A placeholder phone number, such as a branch’s own line keyed for shoppers who would not give theirs, can gather dozens of cards onto a single customer. Every bill for every one of those members is then charged to that account, and they all share its e-invoice identity.

When it goes wrong

What you seeWhyWhat to do
The till says The member card is not linked to any customer! and the member is not put on the billThe card has no customer. Usually it is a storefront sign-up made without a customerIn Membership Admin, open the member and choose a Customer Name. Scheduling the back-fill job instead creates customers named from e-mail addresses (see the table above)
The IC is on the member, but the e-invoice has no buyer identityThe card matched an existing customer by phone or e-mail, and that customer kept its own blank fieldsFill the member form’s E-Invoice tab, or the customer in Customer Maintenance. A bill already saved keeps its copy, so correct the buyer on that e-invoice in My E-Invoice Admin
A customer’s statement shows bills from people you do not recogniseSeveral cards are attached to that customer through a shared or placeholder phoneOpen the customer’s Membership tab to see every card on it, then re-point the cards that belong elsewhere
A household’s names all changed at onceA name was edited on one card that shares a phone or e-mail with the othersCorrect each record. Next time, separate the contact details before renaming
A customer whose name is the start of an e-mail addressThe back-fill job made it from the e-mailRename it, and add the IC before anyone bills it
The items you scanned disappeared when you picked the memberPicking a member changes the bill’s customer, and the till clears the linesPick the member first
A supplier or staff record has been billed for a shopper’s purchaseIts phone or e-mail matched the new memberRe-point the card to the right customer, and keep shared numbers off supplier and staff records

What the link will not do

  • It does not keep the two records in step. Apart from the two edits above, nothing passes between them after the card is made. A phone number changed on one side is still the old number on the other.
  • It does not merge. BigLedger has no button to merge two cards, or to move points between cards in one step. Merge two cards for one person gives the order to do it by hand.
  • It does not put a member on a till bill without a customer. The till refuses the card, so you link it first.
  • It does not check that the person is the same. Matching is by login, phone or e-mail and nothing else, not by name or IC.

The job that stays with you

These decisions are yours to make. The product does not make them for you:

  • Decide how strangers’ purchases are billed. You have three options: one customer per member (clean statements and e-invoices, more customer records); one shared walk-in customer (fewer records, one statement nobody can read); or no member for a shopper who will not give details. Write the choice down for the tills, because the phone number a cashier keys is the choice.
  • Keep phone formats the same everywhere. Agree one format for Customer Maintenance and the tills. Every difference produces a duplicate customer and nothing warns you.
  • Before you schedule the back-fill job, decide whether the members without a customer should get properly named customers instead. The job makes one for each of them, named from the e-mail, and somebody then has to rename every one before it is billed.
  • Once a month, check your largest customers’ Membership tab. A customer that has quietly collected dozens of cards is a statement and an e-invoice identity that belong to nobody.

How you know it is right

Run this in under a minute on a member who joined at the till this week:

  1. Open the member in Membership Admin. Customer Name is filled, and it is the person, not a placeholder or a supplier.
  2. Open that customer in Customer Maintenance. The Membership tab lists only the card or cards you expect.
  3. If this member will want e-invoices, the ID type and number are filled on the customer. The member form’s E-Invoice tab shows the same values.

Where this sits

  • What must exist first: a customer record, or a route that makes one. Without a customer, the till will not bill the member. The company’s points setting decides which bills earn.
  • What becomes possible: points that follow the person while the bills follow the account. A company account can hold cards for six staff, and a child’s card can sit on a parent’s account.
  • Its sibling: a storefront login. The login is how a shopper signs in, and the card is their loyalty record. A shopper who registers online has a login and, depending on your storefront setting, a card. A shopper who joins at the till has a card and no login.
  • What breaks if the link is wrong: the statement of account, credit control and the e-invoice buyer identity, all on the finance side, while the points look perfectly fine.
  • What it is used alongside: Membership Admin and Customer Maintenance, opened side by side. And at the counter, POS General’s member add, where most links are made.

Read next

Member creation shows how to set the card-number rule and how to create members in the right order. After that, where the points on a bill come from explains how earning works.

To enrol a member start to finish, follow Registering a Loyalty Member. When the e-invoice is already missing the buyer’s IC, go to Chase a missing identity number in membership, not in e-invoice.