Campaign Maker
Paste SKU, Original Price and Campaign Price directly from Excel or Google Sheets.
Clear campaign sheet?
This removes all entered SKUs and prices. You can undo this action in the current session.
Campaign evaluations
Use ↑ ↓ to move between cells. Paste three columns to fill multiple rows.
| # | SKU Code | Original Price | Campaign Price | Product Name | Profit / Loss | Final Status | Submission Price |
|---|
WAREHOUSE OPERATIONS
Inventory Recount
Physical count verification and intelligent recount scheduling.
Counter Workspace
Blind counting queue with individual entry, printable PDF, and XLSX import/export.
| SKU | Product Name | Physical Qty | Status | Action |
|---|
Manual Push · Preview
Management request simulation. Actual Owner/Manager permissions will be enforced by the backend before this becomes operational.
Approver Desk
Submission-driven approvals, system-versus-physical variance, recount requests, and external-live confirmation.
Management Overview
Monthly physical attempts, unique SKU coverage, approved cycles, and performance by counter.
History
Last accepted count and next scheduled physical count for each SKU.
| SKU | Product Name | Last Accepted Count | Days Since | Next Scheduled Count | Status |
|---|---|---|---|---|---|
| No live recount records connected. | |||||
Immutable physical counting attempts, decisions, and timestamps.
SRS Settings
Unified risk-based priority, coverage target, and rolling-slot allocation.
How SRS prioritizes SKUs
Demand 40% (latest 30 days and prior months), Cavite stock 30%, time since accepted count 20%, discrepancy history 10%. Coverage urgency and cooldown protect fair rotation. No manual weighting sliders.
Magandang Araw, User 👋
Here’s what’s happening with your operations today.
Shipments
Today
Updated Today
Pending
Reconciliation Source
Choose where this invoice belongs. Nothing is updated until an approved, safe write is available.
Choose supplier, then select the exact invoice/batch.
Choose an existing supplier order from your live Master PO.
Encode invoice items directly, or upload a supplier invoice below. Manual entries do not create or modify a PO.
Choose a source to begin.
Upload Supplier Invoice
or click to browse · Excel, CSV, PDF, JPG, PNG
No invoice selectedFiles stay local in this UI stage; invoice extraction is not enabled yet.
Supplier Template Memory
Save verified column mappings for each supplier. Saved locally in this browser (cross-device sync not yet enabled).
Choose supplier to remember.
Image OCR — Review Text
Free browser OCR (Tesseract.js). OCR may misread SKU codes, columns and numbers. Correct the text below before extracting; no automatic PO changes.
Preparing OCR…
Verify each row against the image. Use Add Row if OCR missed an item.
| SKU | Supplier Ref | Description | Qty | Price |
|---|
Raw OCR text (advanced/manual fallback)
Invoice Extraction Preview
| SKU | Supplier Ref | Description | Quantity | Unit Price | Validation |
|---|
Live Reconciliation Report
Showing Master PO only. Once invoice rows are extracted, a read-only comparison will appear automatically. OCR results must still be verified.
| SKU | Supplier Ref | Status | QTY | PRICE | Actions |
|---|---|---|---|---|---|
| Select a supplier order above. | |||||
| SKU | Qty | Item | Winner | Original Quote | Original Total | Effective USD | Tier | Optimization | ||
|---|---|---|---|---|---|---|---|---|---|---|
| No order yet. | ||||||||||
| SKU | Product | Supplier | Tier | Item Cost PHP | CBM / pc | Freight / pc | Landed Cost / pc |
|---|---|---|---|---|---|---|---|
| Open Landed Cost to load data. | |||||||
Choose stores from the same Sales Orders list. Platform and store name are shown separately, e.g. Shopee · Midoko versus Lazada · Midoko. One active ladder per store.
Unassigned stores use the Default ladder.Bulk line requirement
Computed MOQ = max(minimum quantity, ceiling of minimum line value ÷ retail price). The examples below update automatically as you edit the ladder.
Protect gross margin
The system uses the SKU's current supplier cost in PHP and never discounts below this margin floor.
Qualifying total → discount-room share
| Tier | Qualifying total from | Discount-room share |
|---|
Only lines that meet their computed MOQ count toward the qualifying total. Discount-room share is applied per SKU, not as a flat discount off retail.
Profitability
JOIN only when Campaign Price × payout percentage exceeds the SKU cost. Missing cost always means DON'T JOIN.
Restricted brands
If the product name contains a restricted brand, the result is always DON'T JOIN.
Supplier Manager
| Supplier | Shipping Mark | Multiplier | Free Shipping | Shipping % | Ships From | Winning SKUs | Payment Accounts | ||
|---|---|---|---|---|---|---|---|---|---|
| Open Supplier Manager to load suppliers. | |||||||||
Inventory
Inventory at a glance
Loading latest snapshots…
Stock Risk
Capital Health
Building enough history for the 15-day no-movement signal.
Stock Risk Details
Active SKUs only.
| SKU | Product | Warehouse | Malabon | Katipunan | Incoming | Days Cover | Signal |
|---|---|---|---|---|---|---|---|
| Open details to load stock risk. | |||||||
Update Warehouse Inventory
Column A = Master SKU · Column G = Warehouse Stock
| SKU | Product | Warehouse Stock |
|---|
Today's Updates
Latest upload is always the current inventory.
Update Malabon Inventory
Paste 2 spreadsheet columns: SKU and Quantity.
| SKU | Product | Malabon Stock |
|---|
Malabon Format
No headers required.
Update Katipunan Inventory
UTAK Items file · Column G = SKU Code · Column H = Inventory
| SKU | Product | Katipunan Stock |
|---|
Katipunan File Format
UTAK Items export.
Current Warehouse Inventory
Latest timestamped snapshot.
| SKU | Product | Quantity |
|---|---|---|
| No inventory uploaded yet. | ||
Daily Inventory History
Multiple uploads stay as updates. Daily average is derived from all snapshots that day.
Product Photos
Product photo
External keeps the original host. Import copies the image into Enzalada cloud storage so the source website can disappear without breaking your catalog.
Reports
Know where attention is needed.
Automatic Inventory Out.
Uses your timestamped Warehouse + Malabon + Katipunan snapshots. Internal location transfers are neutralized by analyzing overall stock per SKU.
Capital still on the way.
Expected units, remaining units, in-transit value, CBM and supplier exposure.
Platform Profit Analyzer
Understand your margin after landed costs, commissions, ads, and order expenses.
Profitability assumptions
Adjust freely, then save to keep these assumptions locked in for future reports.
Landed cost per SKU = current winning supplier unit cost in PHP + product CBM × freight rate. Missing dimensions use supplier cost only (freight excluded); missing product cost prevents a complete total.
Drop your sales report here
Excel or CSV · Column C SKU · I Qty Sales · K Original Price Income · Orders entered manually above
What remains after COGS, platform commission, order operating expenses, and ads.
Consolidated SKU profitability
0 SKUs · 0 valid orders
| SKU | Product | Qty | Total sales | Landed COGS | Commission | Gross profit | Gross margin |
|---|---|---|---|---|---|---|---|
| Drop an Excel or CSV report to begin. | |||||||
Same SKU is consolidated across stores and listing suffixes. SKU gross profit uses sales less landed COGS less platform commission. Shared order expenses and ads remain only in the overall contribution analysis above.
Purchase Planner
Sales history
Add one 30-day sales period at a time. The latest 12 months form the active forecasting window; older periods stay archived for future seasonality and backtesting.
Tell us the goal. We’ll handle the math.
Set this once for the PO run. You do not need to configure every SKU.
Drop Excel file
We only read Column C for SKU and Column F for 30-day Demand.
Paste SKU + Demand
Copy two columns directly from Excel or Google Sheets.
Historical periods
Demand trend lookup
Search a SKU to inspect its observed 30-day demand history, average and trend. Analysis appears only when you search.
Demand analysis
30-day normalized forecast with low-demand anomaly suppression. This is a validation layer before inventory, incoming stock, buffer and PO quantity are connected.
| Add sales history to begin demand analysis. |
Known demand & lost-demand evidence
Human input is evidence, not an automatic +Qty to the PO. The engine weighs it against observed demand before forecasting.
Reseller Demand
Paste SKU + forecast quantity. This adds to demand requirement, then available inventory and incoming are still deducted.
| No reseller demand loaded yet. |
Lost Demand Adjustment
Paste SKUs downward. We show product, observed average, latest 30-day demand and a suggested gap. Your adjustment helps the engine interpret possible stockout/putol; it is not added directly to the PO.
| Paste SKUs above to review possible lost demand. |
What should I buy?
Uses your selected coverage date, 30-day forecast, summed Cavite + Malabon + Katipunan inventory and outstanding Suppliers Incoming. Auto Buffer changes by SKU uncertainty.
Waiting for coverage date
Current PO Cost · $0.00
| SKU | Product Name | 30-Day Forecast | On Hand | Incoming | Projected @ Arrival | Pre-arrival Risk | Auto Buffer | Reseller | Lost Demand Evidence | Recommended | Confidence |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Choose “I want stock to last until” above to calculate recommendations. | |||||||||||
Sales Orders
Work on multiple customer orders at once. Unrelayed orders save automatically as your private drafts.
My Orders 0
Customer
Order Details
Items
Consignment
Choose how this order should be processed.
Select one option only. Both require manager approval.
Tax summary
VAT is calculated on the total including shipping.
Pull Out Request
Create stock movement requests here. Fulfillment receives and processes them together with sales orders.
Recently Relayed
Movement Details
Items
Customer Database
Customer profiles, lifetime sales, and complete order history.
Fulfillment
Process Sales Orders and Pull Out Requests in one queue. Type and location badges keep every job easy to identify.
Manager Overrides
Review submitted orders before they reach Fulfillment.
Suppliers Incoming
| SKU | Qty | Item | Winner | Original Quote | Original Total | Effective USD | Tier | Optimization | ||
|---|---|---|---|---|---|---|---|---|---|---|
| No order yet. | ||||||||||
Product Master
| SKU | Product Name | Related Group | L (cm) | W (cm) | H (cm) | Weight (kg) | CBM | Image URL | Complete |
|---|---|---|---|---|---|---|---|---|---|
| Loading product master… | |||||||||