Odafim Planner

Odafim Planner Loading workspace…

Dashboard

Shared warehouse database. Import weekly orders and inventory reports.

Inventory Health — Healthy categories

Critical Categories — Stockout risk within target window

Healthy Categories — Enough cover for current demand

Warehouse Utilization — משטחים used vs capacity

Last Update — No imports yet

Critical Alerts

Categories where projected stock cover is low.

Import order and inventory files to see alerts.

Demand Trend

Total ordered קרטונים by order date.

Import orders to see demand trend.

Orders by Day of Week

Compare average and largest daily order totals by weekday.

Import orders from multiple dates to compare weekdays.

Upload Weekly Files

Use this page only to select and import Excel files. Settings, group categories, imported-file removal, and data cleanup are under Settings & Data.

⬆️

Drag & Drop Excel files here

Supported: .xlsx, .xlsb, .xls. Orders are in קרטונים; inventory is in משטחים and optional קרטונים.

No files selected.

Categories

Searchable and sortable inventory/demand table.

Print language Print current inventory with blank columns for updated location, pallets, and cartons.

Update Inventory on Website

Update one category without importing a new Excel file. The manual value overrides that category in the latest inventory snapshot.

Category Location Pallets Loose cartons

Cat.	איתור	Desc.	Pallets	Cartons	Demand	Weekly	Days	Health	Rec.	ABC

Store Profile

One selected store: totals, top categories, and daily cartons.

Total קרטונים—

Categories—

Last Order—

Top Categories

Cat.	Desc.	קרטונים

Select a store to see demand trend.

Demand History

View demand by category, by order day, or by store.

Select a category, order, or store to see demand history.

Replenishment

Recommended orders are shown in קרטונים and converted to משטחים.

All replenishment categories are visible; use Categories for broad search.

Prio.	Cat.	Desc.	Stock	Dem/day	Target	Rec. ctn	Rec. plt	Reason

Inventory Request

Build a request from critical categories, all categories, or a manually selected list.

Select	Cat.	Desc.	Location	Status	Cartons	Days Cover	Est. use / order	Empty pallet spaces	Requested cartons	Requested pallets

Order Print / Dispatch Plan

Select one imported order file and print it with totals by store, totals by category, shipping method, and estimated משטחים.

Import an order file first, then select it here.

Barcode PDF

Create scanner-friendly Code 128 labels as vector PDF files.

Barcode values Enter one barcode per line. Standard keyboard characters only.

How to use

Paste or type one value per line, choose a print preset, preview the first barcode, then download the PDF. Print at 100% / Actual Size.

Print preset

PDF bar thickness PDF barcode height PDF layout

Label text Placeholders: {value}, {index}, {date}

Text above Optional heading printed above each barcode.

Mode Above text template

Text below Optional caption printed below each barcode.

Mode Below text template

Barcode → Category

Scanner-first barcode/category entry with Excel export.

Ready to scan

Draft autosaves locally

Barcode Press Enter after scanning or typing.

Paste rows from Excel

Rows: 0 Unique barcodes: 0 Categories: 0 Top category: —

Barcodes (Column A)	Categories (Column B)	Actions

No entries yet.

Saved locally in this browser only.

Reports

Export current database and planning tables.

Activity Log

Review recent app changes: imports, settings, store directory edits, cloud uploads, and cleanup actions.

No activity recorded yet.

Settings & Data

Planning settings, group categories, imported file history, and cleanup are all managed here. All data is stored only in this browser.

Planning Settings

These values control pallet conversion, days of cover, and recommendations.

Planning cartons per pallet משטח range is usually 18–24 קרטונים. Default: 21. Target coverage days How many future days of demand the app tries to cover. Safety stock days Extra buffer beyond target coverage. Critical alert days Alert when projected cover is below this number. כץ cartons per pallet כץ orders can be combined. Maximum: 20 קרטונים per משטח. נהג cartons per pallet נהג orders stay separate by store. Maximum: 24 קרטונים per משטח. Default shipping method Used as the starting method for stores in a new order before you choose כץ/נהג. Interface theme Choose Light or Dark interface style. Printouts stay clean black and white. Table layout Expanded layout avoids scroll boxes where possible and lets the page itself scroll.

Hosted Sharing

Optional free Supabase sync so two devices can use the same inventory data. Local mode still works without this.

Shared data workflow

Sign in, then load the latest shared data. Normal changes auto-save after that.

Email Password

Connected operational data is loaded from Supabase.

DB-Only Migration Status

Operational data now comes only from Supabase. A legacy browser database is removed automatically only after an exact fingerprint match.

Checking DB-only migration status…

Not signed in

Store Directory

Assign store IDs by store name. New stores from uploaded orders appear here automatically. Dispatch method is selected per order in Order Print.

Store ID Store name Aliases / Excel names Comma-separated names that should match this store. Note

Known mappings are applied automatically during import. Unknown stores appear with “Needs ID”; edit the Store ID and save to re-match existing imported order rows.

Store ID	Store name	Aliases / Excel names	Total cartons	Note	Action

Group Categories

Use this when one physical stock pool covers several order categories. Demand is aggregated into the group category.

Add a new group or click Edit in the table below.

Group category The category shown in planning. Member categories Orders/inventory in these categories are treated as one pool. Manual משטחים Overrides imported stock for the group. Loose קרטונים Optional extra cartons. Name / note

Active grouping Hibernating / seasonal

Group	Members	Manual Stock	Mode	Note	Action

Imported Data

Remove one bad file from import history, or clear all imported order/inventory data. Settings and group categories stay saved.

Imported	File	Type	Rows	Status	Action