Data templates (CSV)
Ready tables for exchanging data: product master data, stock, sales, purchasing, income statement, cash flow, unit economics and size runs. Each template has columns, validation rules, example rows and a CSV file.
Core data exchange 6
Product master data
One row per SKU: style, color, size and code. The base for stock, sales and marking.
15 columns · CSV
Stock snapshot
Stock by SKU and location on a date: warehouse, store, in transit.
7 columns · CSV
Sales by SKU and day
Sales and returns by SKU, store or channel and date; price and discount separate.
8 columns · CSV
Purchase orders
Order lines to a factory or supplier: SKU, quantity, price, dates and delivery actuals.
10 columns · CSV
Supplier terms
Minimum order, lead time, payment and currency by supplier.
8 columns · CSV
Customers and points of sale
A reference of wholesale customers and stores: code, type, channel, region, payment terms.
8 columns · CSV
Layouts for documents 14
Open-to-buy (OTB) by category and month
One row per category and month: sales plan, price reductions, weeks of cover, opening stock and orders. The output is OTB at retail and at cost.
11 columns · CSV
Assortment matrix (SKU: role, price, cost, sizes)
One row per style: category, role, price and cost excl. VAT, size range, colors and the buy plan in units.
12 columns · CSV
Stock balance by category
Stock movement at cost for a month: opening, receipts, supplier returns, cost of sales, write-offs, closing.
8 columns · CSV
P&L by channel
One row per channel and month: revenue, returns, cost of sales, variable costs, marketing, contribution and fixed costs.
10 columns · CSV
Cash flow by month (direct method)
One row per month: opening cash, receipts, payments by line and closing cash.
11 columns · CSV
Payment calendar
One row per payment: date, payee, basis, type, priority, amount, status and how many days it can be deferred.
9 columns · CSV
Sales plan by store
One row per store and month: area, traffic, conversion, average ticket, planned revenue and growth over last year.
10 columns · CSV
LFL: like-for-like store sales
One row per store and period: comparability status, sales this and last year, trading days and LFL.
9 columns · CSV
Marketplace unit economics
One row per SKU and platform: price, VAT, commission, logistics, storage, return logistics, cost, buyout, advertising and contribution per sold unit.
13 columns · CSV
Landed cost calculation
One row per batch SKU: quantity, FOB price, rate, freight, insurance, duty, broker and other costs. The output is customs value, duty and full unit cost.
14 columns · CSV
Promo calendar
One row per promotion: dates, channel, category, mechanic, discount depth, baseline sales, expected uplift and the supplier funding share.
12 columns · CSV
Supplier terms comparison
One row per supplier and SKU: price, rate, delivery, MOQ, lead time, prepayment, credit, defects and the cost of money. The output is the unit cost with financing and defects.
17 columns · CSV
Season plans
One row per season and category: buy, planned sell-through, price, cost, average discount and drop. The output is units sold, revenue, cost and margin.
12 columns · CSV
Measures and dimensions reference
One row per measure: group, grain, unit, whether it adds up across slices, the currency conversion rule, the source and the owner. Needed so that the buying plan is fed with agreed facts.
8 columns · CSV
Size runs 2
Footwear size run 36–41 with half sizes
A split of 330 pairs of one style across EU sizes 36–41 in half steps: foot length, share, pairs in total and pairs per color (3 colors).
7 columns · CSV
Kids size run 80–164
A split of 1200 units of one style across heights 80–164 in 6 cm steps: age, girths, share and units.
8 columns · CSV