Contact person: Clamsi Supplier-Customer Access & Analytics Update

Phone:Show

Email:Show

Location: Emrou 1, Cyprus

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Feature: Supplier–Customer Access Control, Invites, and Analytics

Overview
Suppliers on Clamsi manage which customers can view their shops.

Includes:

Invite to onboard via SMS or email

Auto-approval via mobile number

Customer catalogue (supplier-managed list of client numbers and emails)

Shop visit logging and analytics

Real-time email alerts

Core Points

Access Control

Permissions table links customer and supplier.

Approval methods: manual, invite link, or auto-approval via mobile number.

When a customer registers with a mobile number in supplier’s catalogue, the system auto-approves access.

Invite System

Sent via SMS or email.

Status tracked: sent, registered, expired or used.

Auto-grants access upon successful registration.

Customer Catalogue (New Requirement)

Each supplier can create and maintain a catalogue of customer mobile numbers.

Stored in a new table, for example supplier_clients with fields:
id
supplier_id
customer_mobile (unique per supplier)
status (pending, approved, revoked)
created_at / updated_at

When a buyer registers with a number found in this catalogue:
System auto-creates an approved access record.
Access is logged as auto-approved via catalogue.
Supplier and buyer may be notified.

Logging and Analytics

Every shop visit logged (timestamp, IP, device, customer ID).

Supplier dashboard shows total visits per day, visitor details, and filters by country, date, or buyer.

Alerts

Optional real-time email when a customer visits a shop.

Includes buyer name, company, timestamp, and link to analytics dashboard.

Security

Token expiry on invites.

Mobile numbers and emails validated and encrypted.

Unauthorized access blocked and logged.

Problem
The Supplier Onboarding Wizard is saving data in the suppliers table.
It should instead save into the sellers table (the correct vendor storage).

Required Fix

Update onboarding wizard to write into sellers (not suppliers).

Stop all new writes into suppliers.

Integrate catalogue checks into onboarding flow to auto-approve if number matches." (client-provided description)