Pretty Little Customs

Inventory Hub – Pretty Little Stock

Inventory, simplified

Capture our stock items, record movements, and see what we have, what’s on order, and what it’s worth at any date for Pretty Little Customs.

Today’s position

On hand

All stock lines

On order

Awaiting delivery

Stock value

£0.00

Based on last cost

New stock line

SKU / Code

Description

Supplier Ref (optional)

Unit

Default location (optional)

Used as the default location when recording movements if no location is specified.

Cost per unit

Reorder level

Package size

Minimum selling price (£)

Current selling price (£)

Target selling price (auto): £0.00

Import initial stock (CSV)

CSV required columns: sku, name, unit. Optional: category (supplier ref), default_unit_cost, reorder_level, package_size (large_letter / parcel), min_selling_price, current_selling_price, opening_on_hand.

Save from Excel as “CSV (Comma delimited)”. Opening balances are recorded as adjustments dated today. The category column is used as your supplier reference in Inventory Hub.

Stock catalogue

Search stock

SKU	Item	Pkg	On hand	On order	Unit cost	Target	Min	Current	Actions

No stock lines yet – start on the left.

Record a movement

Stock line

Type

Quantity

Date

Location (optional)

Leave blank to use the stock line’s default location.

Unit cost

Reference

Notes

Import order movements (CSV)

CSV required columns: sku, quantity. Optional: date (yyyy-mm-dd), unit_cost, reference, note.

Save from Excel as “CSV (Comma delimited)”. Each row is recorded as an “On order” movement for the matching SKU. You can use this file multiple times during the year to add new orders.

Recent activity

Date	Item	Type	Quantity	Unit cost	Actions

No movements yet – record your first delivery or usage.

Snapshot by date

As at date

Reports are calculated from all movements up to and including this date.

Lines

Active stock items

On hand

All units

Stock value

£0.00

At last known cost

Stock position

Item	SKU	Package Size	Target Price	Min Price	Current Price	Location	On hand	On order	Reorder @	Days of stock remaining*	Value	Total value (incl on order)

Position as at selected date.

Backup & restore

Download a JSON backup of all stock lines and movements, or restore from a previous backup file.

Restore from backup

Restoring will replace your current stock lines, movements and favourites with the data in the file.

Locations