OnlineOff
Kidzink Distribution Centre

What do you want to do?

BackupEverything in one file: all lists, pallets, saved notes, stock, trucks, inspections, checklists. Excel: one sheet per module with every detail, easy to read, and it can be put back too. Keep it safe; put it back if something goes wrong. Photos stay in the storage bucket (the backup keeps their links).
Dispatch

Delivery note

Scan pallet

No pallets
Point the camera at the QR code

Details

Delivery

Truck

Customer

Our company

Logo on the document
LogoKidzink logo

Pallets

DO no —
Preview

Saved delivery notes & packing lists

Labels

Pallet label & add pallets

Scan and add pallets

No pallet

Labels

Pallet label

QR code label

Schools

Available pallets

Planning

Plan and book (outbound)

Warehouse

Storage

Scan to store

A pallet QR or a stock label
  1. Scan the pallet or the stock label.
  2. Click an empty box in a rack below.
  3. Done. The place shows on Available pallets and on Stock.
EmptySchool palletStockFound

Storage history

Warehouse

Stock

Scan a stock label

Count it (stock taking) or change its place

Changes save when you leave a box. Pallet no puts items on a pallet: Group by pallet shows each pallet with all its items. Pallet labels makes the two labels of a pallet (every item on it, with a QR code), like Pallet label & add pallets. Scan a label at the top of this page to count the pallet or change its place. The search looks through every page.

Fulfillment

Annual leave & holidays

Left = left of the year before + months earned × monthly accrual − taken. Months count only up to the end of the last completed month before the As-of date. ✓ = the joining month is not counted; Include = it is. ★ marks a name yellow.

Receiving

Receiving delivery notes

Ready

Saving to: receiving / supplier / date (asked when you capture)

Saved

Site

Receive pallets at site

1 · The DO, then scan each pallet

Site checks

Inbound

Inbound containers

Trucks

Trucks and drivers

Week

Delivery / loadOther jobDay offTruck offProblemPress a box to plan that driver on that day

Truck and container sizes

Inside size of the cargo space in cm and the most weight it takes. Change any number, rename, or add your own. Tick which ones each list uses (international: 20, 40 and 50 ft). Add a cost and the best load plan is picked by price.

TruckLengthWidthHeightMax kgCost (AED)DomesticInternational
Online

Saved notes

– notes – pallets – total qty – schools

Online settings

Type the URL and the anon key of the online database to share the data with the team.

Leave it as delivery_notes. The other tables have fixed names (see below).
First time? Set up the online database (all tables, one SQL)

This ONE script makes every table the app uses, plus the photo storage. Press Copy SQL, paste it in the SQL editor of the online database and press Run. You can run it again any time (it only adds what is missing, nothing is deleted). Anyone with the key can read the data, so keep it inside the company.


      
By Hannan Rasheed