Syntha Lab RU

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.

Open interactively →

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