APL & Merchant Manager

Campaign

– lines

Check coverage

Is a product or a merchant covered for a client? A UPC is covered when it's on the client's APL. A merchant is covered when it's approved for the client and live on the network.

Client

UPCs / PLUs (one per line or comma separated)

Merchants (name or MID, one per line)

For integrations (e.g. Zendesk, later)

The same check is available as a web address that returns JSON:

Use several upc values separated by commas and merchant values separated by |. It also accepts a POST with {"client": "CNC", "upcs": [...], "merchants": [...]}.

Bulk changes

Upload an Excel/CSV file or paste lines copied from Excel. You'll see a preview before anything changes, and every applied change can be undone from History. Download a template.

Source

Choose a file or drop it here

.xlsx or .csv

Client

If the file has a Client column, that wins for each row.

What should happen

Reports

Counts grouped however you like. Uses the filters currently set on Browse:

Quick reports

Group by (in order)

Show as a pivot when grouping by two columns

Change history

Only this list

Every add, edit, delete and bulk change is recorded with who made it and the before/after values. Undo reverses a whole change.

When	Who	Change	Client	Lines

Clients

Code	Name	Description	Products	Merchants

Campaign codes

Give each APL campaign code a plain-English label; it shows next to the code everywhere.

Code	Label	Description	Lines

Backups

A backup is also taken automatically before "replace" uploads, very large uploads and client deletions. The newest 5 are kept in data/backups.