Welcome backDAILY FOCUS

Consistency is what makes a process trustworthy.

Worth KnowingSource

New knowledge, one small discovery at a time.

Gross SalesLive OrderWise sales value (today)

TODAY (LIVE)

—Live

Last updated: —

Waiting for live sales…

This Period Last Week Last Year

Daily SalesLive Delivery History orders printed

7 Days

TODAY (LIVE)

—Live

Last updated: —

Waiting for Delivery History…

Orders printedNo of parcels

Amazon Delivery Snapshot

Today’s Prime, Non-Prime, Business delivery promise and UK courier coverage.

LIVE—

Loading saved Amazon records...

Loading saved courier coverage...

Checking shared save status...

👥

Scheduled Today—From final rota

●

On Shift Now—Live by rota time

⏱

Late Today—Employee reported

▦

Groups Working—Scheduled today

Staff by Group (Today)

Scheduled staff and who should be on shift right now.

● Live

Loading today's rota…

On Shift Now

Live group-level staffing based on rota start/end times.

—

Group	Scheduled	On now	Late
Loading…

Today's Late Reports

Live employee notifications sent to HR.

0

No late reports today.

Live rota dashboard waiting for HR data…

Shared Data Hub

Upload reference files here once for the entire DIVA GROUP workspace.

Orderwise Data

Live inventory from OrderWise via the Supabase mirror. Used by Ordering, Overall Stock Movement and Amazon Stock Movement.

Live OrderWise Feed

Waiting for Supabase...

All Variants ● Live SQL

Automatic OrderWise main and alternate variant mappings from Supabase.

Live OrderWise Feed

Connecting to Supabase…

Loading live mappings…

Purchase Orders

Goods In now reads active purchase orders directly from the OrderWise mirror in Supabase. No Purchase Order Excel upload is required.

Live OrderWise Feed

Live from Supabase

Courier Integration

Live despatch / courier tracking from OrderWise via the Supabase mirror. TEMU Orders reads this automatically; no tracking file upload is required.

Live OrderWise Feed

Waiting for OrderWise courier data...

TEMU Store Product Exports

Upload each store's TEMU Product Data Export here once. The file is saved to the shared cloud and remains available until you replace it.

0 / 9 stores configured

How it works: OrderWise inventory, active Purchase Orders and Courier Integration tracking are live from Supabase and refreshed by the local OrderWise connector. All Variants remains a shared upload. TEMU store product exports are stored in the shared Data Hub and stay saved until replaced. After an authorised user signs in, the live OrderWise dataset is loaded automatically and passed to the dependent workspace modules.

Supplier Price Comparison

Compares products that share the same EAN across your saved supplier price files.

0 comparable EANs0 suppliers loaded

Total Stock	Total Sales	On Order	Code	To Order Qty	Supplier Name	Description	Est Cost	EAN	Cheapest Price	Cheapest Supplier	All Supplier Prices

Upload supplier price files from the Supplier List. Products sold by two or more suppliers with the same EAN will appear here automatically.

The comparison uses each supplier's effective saved selling cost: if a valid Promo / Clearance price is lower than the normal Item Cost, the promo price is used. Only valid EAN / barcode values shared by at least two suppliers are included.

Supplier Order

Supplier price file, promo / clearance file and order quantities

Shared cloud save

Supplier Price File

Upload or replace the latest supplier price list whenever it changes. The newest file replaces the previous one for this supplier.

Upload Supplier File

No supplier file saved.

Promo / Clearance File

Optional. Only rows with an actual promo / clearance price update the Promo Cost. Blank prices never replace the normal cost.

Upload Promo / Clearance

No promo / clearance file saved.

Invoice PDFs

Upload one or many supplier invoice PDFs. Each new PDF is added to this supplier's saved invoice history.

Upload Invoice PDF(s)

No invoice PDFs saved.

Purchase Order Form

Upload one or many purchase order forms for this supplier. New files are added to the saved purchase order history and compared with the invoice quantity and unit cost.

Upload Purchase Order Form(s)

No purchase order forms saved.

PO Upload

Upload a purchase order or delivery note PDF. The document is read automatically and its item lines are saved for shared review. Excel and CSV are also supported.

Upload PO / PDF

No PO upload saved.

Item Code	Item Description	Barcode	Inner	Outer	Item Cost	Promo Cost	Quantity to Order in Box	Total Order Value

Choose a supplier file above to create the order sheet.

Invoice Price Review

Matches invoice lines by Item Code and compares the agreed piece cost against the invoice piece price. For 151 Products Ltd, Case Price is divided by Pack Qty. Any unit-cost difference is marked REVIEW.

0 invoices

Code	Description	Agreed Cost	Invoice Price	Difference	Status	Second Verification

Upload invoice PDF(s) to compare invoice prices.

Purchase Review

Matches purchase lines to invoice lines by manufacturer part number / code. For 151 Products Ltd, invoice quantity is converted to singles (Order Quantity × Pack Qty) and invoice price is converted to piece price (Case Price ÷ Pack Qty). Quantity and unit cost must both match; any difference is highlighted red.

0 lines

Code	Description	EAN Code	Quantity Ordered	Invoice Quantity	Unit £	Invoice Price	Status

Upload purchase order form(s) and invoice PDF(s) to compare quantity and unit cost.

Purchase Order

Shared PO Upload preview. Use the separate PO Upload control above to load the purchase-order file without changing Purchase Review history.

0 lines

Code	Description	EAN Code	Quantity	Unit Cost	Total

Upload a PO file using PO Upload to create the Purchase Order view.

Final Order

Forecast uses live OrderWise OUT sales history and live stock. BUFFER sales and DUPLICATE sales are excluded; BUFFER stock remains usable. Promo price is ignored.

Order value £0.00

Item Code	Item Description	EAN Code	Price	Order Qty	Total Order Value

Choose the forecast period and click Calculate Forecast. Results are cached briefly for faster repeat calculations.

151 Products - Weekly Order

Connected OrderWise demand + saved 151 supplier stock/ETA/floor allocation. Column Z FULL PALLET PRICE prioritises complete pallets (53 boxes needed / 90 per pallet = 90 boxes). Supplier Free Stock (G) is in BOXES. Excel/PDF exports show a short pallet count in Notes and supplier-stock requests in the next cell. These notes are not displayed in the Weekly Order table; order quantities are unchanged.

Week commencing Checking OrderWise feed...

Automatic from Order Check

Review — OrderWise items not on the 151 order

Matches the live 151 OrderWise MPN/EAN groups against the saved 151 supplier price/order form. No extra file upload. Missing or excluded items do not get silently added to the supplier order.

Waiting for connected OrderWise data...

Show

OW Item / MPN	Description	30D Sales (pcs)	OW Stock + On Order (pcs)	Need (pcs)	Reason not in 151 order	Action

This is a review list, not a purchase order. Supplier-only products with no OrderWise record are not counted as missing OW products. Any manual supplier-code match must be verified against the supplier file before saving.

Floor Allocation column J unitsSupplier Free Stock G is confirmed BOXES (fixed). J units remain separately configurable in shared Supabase; do not change J without confirmation.

Connected OrderWise data

Order prepares automatically when Weekly Order opens.

Suggested order lines0

Suggested boxes / cases0

Suggested full pallets0

Estimated total order value£0.00

The weekly recommendation is calculated automatically using connected OrderWise data.

Swipe the table sideways to view suggested boxes and estimated value. Amber rows need supplier stock confirmation.

Item Code	Item Description	EAN Code	Price	Order Qty	Total Order Value

Reading connected OrderWise data...

Calculation & review

Why is an item missing from my order?

Search an item to see its exact live OrderWise shortfall, supplier mapping, decision and reason.

Item Code	30D Sales + Unallocated (pcs)	Free units	On order units	Stock + On order (pcs)	Required pcs	Units / box	Boxes / pallet	Order boxes	Supplier Free G (boxes)	Floor Allocated J (pcs equivalent)	Expected date	Decision	Reason	Actions

Shared weekly decision history

Time (UK)	User	Item	Action	Details

Last week — not marked ordered

Last week	Item / MPN	Last status	Suggested boxes	Current status	Current reason

Weekly recommendations are saved as snapshots, not treated as placed purchase orders. Only the explicit “Mark as manually ordered” action records that staff placed an order outside this website.

Order Check formula & box / pallet rules

Automatic source: The existing OrderWise file connected to this website, exactly the source supplied to Order Check. No weekly Excel upload or forecast setting is used. The old uploaded workbook remains untouched but is no longer used for this tab.

Order Check demand: For each OW manufacturer part number: SUM((Total 30Days Sales + Sales unallocated) × Pack Quantity). Available stock = SUM((Free stock quantity + On order) × Pack Quantity). Required pieces = MAX(0, demand - available stock).

One item row: Variants are combined in physical pieces. Repeated EAN/orderable rows do not multiply the requirement. No new BUFFER/DISC exclusions are applied. Blank or ambiguous MPN groups are flagged for review.

Boxes: Required pieces divided by supplier case size, rounded to whole boxes. Zero shortage = 0. Normal box orders: 1 box for 1-box need, 2 for 2, otherwise 5/10/15... FULL PALLET PRICE items (column Z) prefer complete pallets when at least half a pallet is required, so 53 boxes required and 90 per pallet means one 90-box pallet (extra stock carries into next week). Smaller requirements use normal box quantities, not zero.

Examples (12 pcs per box): 0 pcs needed = 0 boxes; 11 pcs needed = 1 box / 12 pcs; 37 pcs needed = 5 boxes / 60 pcs; 61 pcs needed = 10 boxes / 120 pcs. The original Final Order tab is unchanged.

Pallets: When the requirement reaches a full pallet, order only complete full pallets, rounded to the nearer full-pallet quantity for this weekly purchase. Never mix full pallets and loose boxes. Recheck the leftover against LIVE OrderWise demand next week rather than ordering a larger pallet quantity for the entire 30-day shortage. For FULL PALLET PRICE rows, do not defer a required order to zero just because a complete pallet is not justified: at least half a pallet becomes a complete pallet, smaller requirements stay ordinary boxes. Non-tagged items retain their existing verified-discount/warehouse-cover decisions. A deferred item is reviewed from fresh live OrderWise demand next week; a staff-confirmed ORDER_BOXES override remains available for exceptional cases. Only a verified pallet-specific price is used for discounted pallet calculations.

Supplier availability: Supplier Free Stock and Floor Stock Allocation are read from the saved 151 Supplier Price File. The shared stock-unit setting (pieces or cases) determines conversion to pieces. Supplier Free Stock G indicates supplier availability, NOT the requested buying quantity. Whether G is positive, zero or negative, display normal box/pallet order quantities calculated from current OrderWise demand. If G is zero/negative or lower than the proposed quantity, keep the requested quantity and total cost and add "Could you please arrange some stock for us?" in the exported Stock Request column; confirm availability before placing the PO. Missing G remains UNVERIFIED, rather than assuming stock. Inactive or discontinued supplier products are still excluded. Full pallet and loose-box quantities are not mixed in one automatic pallet order.

Shared history & OOS: Staff can record supplier-out-of-stock expected dates, item review corrections, pallet deferrals and explicitly marked placed orders. Recommendations are snapshots (not automatically placed orders). Deferred items and availability dates are saved in Supabase when its setup SQL has been installed.

Prices and quantities: Saved 151 Supplier Price File supplies case sizes, pallet size and normal piece price. Pallet prices come from the marked FULL PALLET PRICE row in column Z (or an unambiguous established two-price catalogue pair). Full pallet boxes use verified pallet rate; loose cases use normal piece rate. Total and blended unit price reflect that split.

Scope: 151 Weekly Order only. Purchase Order, Final Order and other suppliers unchanged. “Mark ordered” records a human confirmation; this website does NOT send POs to OrderWise.

always uses the cheaper valid price between Item Cost and Promo Cost. Promo Cost is green when cheaper and red when higher than Item Cost. Supplier layouts may differ: the importer detects common item-code, description, barcode, pack and currency/cost patterns, including pack-net pricing. Quantities are saved separately for each supplier.

Existing file import tools · Diva Gift / OVOVO

TikTok connection and schedule

B&Q connection and import tools

ADMINISTRATION

Users & Permissions

Raj admin can add login users and control which DIVA workspace modules each user can open.

Add new user

Email

Temporary password

Starting permissions

Existing users

Choose a user, change access, then press Save permissions.

DIVA GROUP · ADMINISTRATION · V402

Master Diagnostics

Health visibility for OrderWise, HR, permissions, application files and browser Realtime channels. Tests are manual, read-only and limited to what this account can actually verify.

Waiting for verified administrator access. No tests have run.

0Verified checks

0Need review

0Failed probes

0Info / not checked

0 / 19 checks completeNever run

Permissions & October 30 Supabase change

The browser cannot inspect every database GRANT, policy or privileged function. For a genuine permissions audit, use the separate read-only SQL audit in the Supabase SQL Editor. Do not apply blanket GRANT statements or change RLS based on these browser checks.

Open Purchasing SQL Editor ↗

What a green check means

Authenticated API read/file availability or timestamp was verified.
It does not prove OrderWise automatic uploads, rota correctness, customer delivery, or notification delivery.
Realtime channel count is local to this browser, not Supabase billable usage.
No background polling, new Realtime channels or data writes are added by this page.

Access control: the existing diva_strict_admin_status() Supabase RPC must confirm this session. All database reads still respect current Supabase RLS. Results stay in this browser until you choose to download/copy them; no diagnostic results are stored remotely.

Staff Rota Manager

Collect employee availability, plan weekly shifts, review drafts and share one permanent employee portal link.

No week selected

Add / Edit employee

User ID

Name

WhatsApp number (country code)

Employee portal password

Employment type

Staff access role — HR controls accessTeam Leader and Supervisor have identical rota visibility and permissions.

Password is only used for the permanent employee portal. Leave it blank when editing if you do not want to change it.

Employee Portal

This is the one permanent employee portal link for all staff. It never needs to be generated again.

https://www.divaapp.co.uk/?employee=1

Employee details Loading employees...

Search by employee ID, name or WhatsApp number.

Search employees

Bulk employee password setup

Upload the DIVA employee password sheet, preview it, then apply the new PINs securely through the existing Supabase HR password function. Passwords are not saved in the website code.

Choose password sheetNo file selected.

No employees yet.

Availability Window Control

HR decides whether employees can submit availability. Auto mode opens next week availability every Thursday to Sunday and closes it Monday to Wednesday. A finalised rota closes that week automatically.

Checking...

HR decision

Selected week

—

Loading availability window...

Availability received

Week commencing (Monday)

Search employee

Select a week to view availability.

Weekly rota planner

Groups appear directly between employee names, like the existing rota. HR can create group names, drag employees into groups and assign shifts from available cells. Save & Open Draft moves straight to the shared Draft page; edits made by any authorised HR/DIVA user update live for everyone.

Week commencing

Search employee

Full-width rota plannerAll seven days · Drag teams · Save to shared draft

AvailableUnavailableNo responseShift assignedDrag employee names onto a group heading to move them★ Important employee

Draft Staff Rota

Grouped rota layout matching the existing rota sections. Group heading, employee rows and group TOTAL rows print in the same order. Monday–Sunday columns. Green = working, red = off, blue = evening. Click any day cell to add, edit or remove that employee shift.

WorkingOff / no shiftEvening shiftTip: click a cell to edit

Draft save only

Employees will not be notified from this page.

Save your changes, then use Final Rota when it is ready to notify employees.

Staff Rota · Draft & Save

Click a shift cell to edit. Drag the rota table horizontally to see all days.

Live shared rota

Historical printed totals and scheduled staffing load when you open Draft & Save.

Edit employee shift

Start

Finish

Note / Area (optional)

Final Staff Rota

Review the saved rota here. Employees receive the rota only after you click Notify Employees.

WorkingOff / no shiftEvening shift

Ready to send?

Each employee receives one full-week rota notification for this week. Re-sending updates the same weekly notice instead of creating duplicate rota notifications.

No notification has been sent from this screen yet.

DIVA GROUPEmployee WorkspacePEOPLE FIRST · STRONGER TOGETHER

D

MY DIVA WORKSPACE

Hi,

Full-time Live rota

❝

Consistent effort today creates bigger opportunities tomorrow.

KEEP GOING!

DIVA PEOPLE PORTALYour week. Your team. Your workspace.

Your local workday

Enable alerts once on this device to receive rota and HR updates.

Next shift—No upcoming shift

This week0scheduled shifts

Hours0hscheduled this week

Availability—Not submitted

WEEKLY ROTA

My schedule

No shifts loaded.

QUICK ACTIONS

Need something?

TODAY

Today

Checking your rota…

AVAILABILITY

Next week availability

Checking

Loading availability...

TIME OFF

Leave request

Send a leave request to HR and track the decision here.

From

To

Reason / note

DIVA MEETING

Meeting with Manager

Request form

Complete the meeting request form. HR will print it for Diva. If the manager approves, HR will add the meeting date/time and it will appear in your rota with a notification.

Date

Department / Role

Purpose of Meeting

Explanation

Discussed with Supervisor / Manager?

If yes, outcome

HR SUPPORT

Chat with HR

No messages yet.

HR Notifications & Requests

Live employee alerts, HR chat, leave requests and manager meetings — in one dedicated workspace.

HR access only

HR OPERATIONS / INBOX

Everything that needs a decision, in one place.

Live employee messages, leave approvals, late arrivals and manager meeting requests. Protected for HR users.

Waiting for HR connectionSign in with an authorised HR account

Find employee, request or note

Prioritise view

No records loadedFilters do not delete data

Open a message for chat, amend a leave request, or review a manager meeting. Statuses update from Supabase.

HR Notifications, Employee Chat, Leave & Manager Meetings

Employee messages, leave requests and Meeting with Manager requests appear here live. HR can print the meeting form, record Diva's decision and schedule the approved meeting.

Notifications

Latest employee messages, requests and alerts

Sign in with HR access to load notifications.

Employee chat

Select an employee

Start a new chat

No employee selectedChoose a notification or search above

Select an employee to view the conversation.

Amend employee leave

From

To

Decision

HR note / reason

Optional: schedule a shift during approved leave

Use only when HR has confirmed the employee can work. The amendment is audited; the employee receives an update.

Shift date (leave blank for no shift)

Start

Finish

DIVA GROUP / HR ACTIONS

Staff Data

Employee directory and confidential staff records.

DIVA GROUP / PEOPLE OPERATIONS

Staff Intelligence Centre

Employee rota, leave, punctuality and confidential performance development records.

HR ACCESS · PRIVATE

LIVE HR RECORDS

Europe/London

Active employees—Employee accounts

Scheduled shifts this month—Planned, not attendance

Approved leave requests—Overlapping this month

Data checked—Latest verification

STAFF DIRECTORY

Find an employee

Search by name or employee ID to open their record.

Only HR users can access
employee records.

Employee ID or name

Search by ID or name, or filter using the options below.

Month

Employment type

Department

Work status

—

Total employeesAuthorised employee directory

—

Full-time— of total

—

Part-time— of total

Selected monthSelected report month

Sign in with authorised HR access to load employee records.

EMPLOYEE RECORD

Employee report

Select a metric to open its detailed records below. Attendance requires HR confirmation; scheduled shifts alone do not prove presence.

HR history & performance evidence

Build an evidence-based employee history: record achievements, coaching, conduct discussions, development, agreed actions and review outcomes. Saved as confidential HR review records.

History category

Event date

Factual observation / supporting evidence

Impact / performance area

Case status

Evidence / examples (optional)

Employee response / context (optional)

Agreed next steps / measurable goal (optional)

Reviewer / action owner

Record purpose

Follow-up / review date (optional)

Assessment (optional)

Pay review decision support

Use documented achievements, scheduled responsibilities, role expectations, training and consistent performance over time. HR makes the final decision; this page does not calculate or automatically approve a pay rise. Do not use protected characteristics, leave entitlement or unsupported behaviour labels as a proxy for performance.

Leave history

HR performance review (private)

Review rating (optional)

HR assessment and feedback

Welcome Back

Staff by Group (Today)

On Shift Now

Today's Late Reports

Shared Data Hub

Orderwise Data

All Variants ● Live SQL

Purchase Orders

Courier Integration

TEMU Store Product Exports

Supplier Price Comparison

Supplier Order

Supplier Price File

Promo / Clearance File

Invoice PDFs

Purchase Order Form

PO Upload

Invoice Price Review

Purchase Review

Purchase Order

151 Products - OrderWise Purchase Order

Final Order

151 Products - Weekly Order

Review — OrderWise items not on the 151 order

Review item

Users & Permissions

Add new user

Existing users

Master Diagnostics

Permissions & October 30 Supabase change

What a green check means

Staff Rota Manager

Previous week rota

Add / Edit employee

Employee Portal

Employee details Loading employees...

Bulk employee password setup

Availability Window Control

Availability received

Weekly rota planner

Draft Staff Rota

Staff Rota · Draft & Save

Edit employee shift

Final Staff Rota

Hi,

Who's working today

My schedule

Need something?

Today

Report late

Next week availability

Leave request

Meeting with Manager

Chat with HR

Everything that needs a decision, in one place.

HR Notifications, Employee Chat, Leave & Manager Meetings

Notifications

Employee chat

Amend employee leave

Optional: schedule a shift during approved leave

Staff Intelligence Centre

Employees (—)

Employee Documents

Employee report

HR history & performance evidence

Leave history

Employee Documents

HR performance review (private)