Managing Sales Commissions During an Ecommerce Platform Migration

Moving an online retail operation to a new ecommerce platform can affect far more than product pages, payment settings and stock levels. Sales representatives may have built their income around order ownership, customer accounts, product categories or invoice values, so a change in order flow can quickly create confusion about who deserves commission.

This is especially important when a discontinued system is replaced by Magento, WooCommerce or another platform connected through an NCR Counterpoint partner. A successful migration should preserve the commercial rules behind each sale, even when order numbers, customer records and fulfilment processes change. Clear mapping, reliable data and written communication give Australian retailers a practical way to protect both margins and staff trust.

Audit The Existing Commission Rules

Begin by documenting how commissions are calculated before any data is moved. Record the rate or fixed amount, eligible products, discounts, refunds, freight, gift cards, GST, payment fees and the event that makes a sale commissionable. Some businesses pay when an order is placed, while others wait until payment clears, goods are dispatched or the return period expires.

Also list exceptions that may be hidden in spreadsheets or understood informally by managers. A representative may receive a different rate for wholesale customers, repeat buyers, clearance stock or large commercial accounts. An order containing several product categories might be split between representatives, while a customer who begins online and finishes by phone may still belong to the original salesperson.

Review historical statements from the old system and reconcile them against the general ledger. This helps identify whether commissions were based on gross sales, net sales or contribution margin. It also reveals edge cases, such as partially refunded orders or exchanges, that should be tested during migration rather than discovered in the first payroll cycle.

Define Who Owns A Migrated Order

A new platform may assign orders differently from the previous one. It might use a customer account, a sales-representative field, a coupon code, a staff login or a manually selected attribution value. Choose one primary rule and document it. If several rules apply, establish a hierarchy so that representatives are not competing over the same transaction.

For example, a retailer could credit the representative attached to the customer account unless another staff member records a formal sales interaction. Alternatively, it could award commission to the person who creates the quote, with a shared percentage when another representative completes the sale. The best method depends on the sales cycle, but it must be visible in the order record and easy to audit.

Pay close attention to abandoned carts, phone orders and click-and-collect transactions. A customer in Brisbane might research a product online, speak with a representative in Sydney and collect the purchase locally. Without a defined attribution rule, the migration can create disputes that have little to do with selling performance. A short, consistent policy is usually stronger than a complicated model that staff cannot interpret.

Map Data Between The Platforms

Create a field-by-field mapping document before importing customers and orders. Useful fields include the original order number, new order number, customer ID, representative ID, sales channel, order date, dispatch date, refund status, commission rate and commissionable amount. Retain the old identifier so that a representative or payroll manager can trace a migrated transaction back to its source.

Products need careful attention as well. SKU changes, bundled products and discontinued items can alter the basis of a commission calculation. A homewares retailer might sell a dinner set as a bundle in the new store while the old platform recorded each flatware range item separately. Decide whether the historical rate applies to the original lines or to the new bundled SKU, and keep that decision consistent across all affected orders.

Run a sample migration using different order types: paid and unpaid orders, discounts, refunds, split shipments, subscriptions and manual invoices. Compare the commission result produced by the new platform with the approved result from the old system. Testing should include Australian GST treatment, especially where staff are paid on net sales excluding GST but reports display tax-inclusive amounts.

Build Controls For Returns And Adjustments

Returns can create the largest disagreement after a platform change. A commission plan should explain whether a returned item reverses the original commission, reduces the next payment or is ignored after a specified period. It should also cover exchanges, store credit, damaged goods and refunds issued after the representative who made the sale has left the business.

Set up a monthly commission report with enough detail for representatives to verify their results. At minimum, show order number, customer or account reference, item value, discounts, GST treatment, commission rate, adjustments and final amount. Provide an exception report for missing representative IDs, duplicate order numbers, negative totals and transactions that have not reached the commission payment milestone.

Access controls matter when multiple systems are connected. A representative should be able to see relevant sales information without changing commission rates or assigning orders to themselves. Keep an audit trail for manual edits, and restrict changes to authorised managers. The broader NCR Retail Online transition guidance can help retailers understand why operational continuity and connected business systems matter during a platform change, even though commission rules still need to be configured for the chosen replacement.

Communicate And Reconcile The Change

Tell representatives what is changing, when the new rules begin and how older orders will be treated. A migration can involve a cutover date, a period in which both systems are used, and a backlog of orders that were placed before the change but dispatched afterwards. Publish examples showing the result for a standard order, a refunded order and a sale involving two representatives.

Use a temporary dispute process for the first two or three commission cycles. Give staff a deadline to report errors, identify the evidence required and name the person responsible for resolving each case. This is particularly useful around the Australian end of financial year, when payroll, reporting and stock reconciliation already place extra pressure on retail teams.

Reconcile the new commission report with sales revenue and payroll before payments are released. Compare totals by representative, channel, product group and week. Check that online orders, store orders and phone sales have not been counted twice. If the business sells products or digital services with different fulfilment patterns, keep the commission logic separate where necessary; a media-related purchase such as a streaming service may require a different payment or cancellation rule from a physical retail order.

A platform migration should leave behind a repeatable process rather than a one-off spreadsheet repair. Store the approved commission policy, field mapping, test results and sign-off records in a shared location. Review the rules after the first quarter to account for new sales channels, marketplace orders, loyalty programmes or changes in representative responsibilities.

The key point is simple: sales commission follows a commercial decision, not merely an order record. Preserve the evidence of who sold what, under which rule and at what stage payment became valid. When those details are mapped, tested and communicated before the new store goes live, representatives can be paid accurately while the retailer gains a cleaner, more dependable sales operation.