Perlu data lebih baru dari jadwal 04.00? Need data fresher than the 04:00 run? Sinkron dataSync data ↗ (perlu login GitHub, data baru ±10 menit) (GitHub login needed, new data in about 10 min)
–
Periode tetap, tidak ikut filter periode. Perubahan dibanding periode sebelumnya yang sebanding.Fixed periods, not affected by the period filter. Change vs the comparable period before.
Periode terpilih, selalu online dan toko berdampingan (filter online/toko tidak berlaku di sini). Dari data rinci pesanan 90 hari terakhir.Selected period, always online and store side by side (the online/store filter doesn't apply here). From order-level data for the last 90 days.
Hari ini belum lengkap (lebih terang).Today is partial (lighter).
Minggu mulai Senin; minggu ini belum lengkap.Weeks start Monday; this week is partial.
Bulan ini belum lengkap.This month is partial.
Angka kunci dari semua tim, untuk periode terpilih dan stok saat ini.Key numbers from every team, for the selected period and current stock.
–
–
Periode terpilih vs periode sebelumnya. Batal = porsi pesanan yang dibatalkan atau diretur.Selected period vs the period before. Cancel = share of orders cancelled or returned.
Kolom Di toko = penjualan kasir (POS) di toko itu. Kolom Online = pesanan marketplace yang dikirim dari stok lokasi itu (mis. saat promo 10.10, toko ikut memenuhi pesanan online). ONLINE = gudang online pusat.In-store = POS sales at that store. Online = marketplace orders shipped from that location's stock (e.g. during the 10.10 promo, stores helped fulfil online orders). ONLINE is the central online warehouse.
Pendapatan per hari dan jam (WIB), 90 hari terakhir. Pilih lokasi untuk melihat satu toko (termasuk pesanan online yang dikirim dari toko itu). Makin gelap makin ramai: pakai untuk jadwal staf dan jam promo.Revenue by weekday and hour (WIB), last 90 days. Pick a location to see one store (including online orders shipped from it). Darker = busier: use it for staff rosters and promo timing.
90 hari terakhir. Pelanggan kembali = 2+ pesanan. Kasir toko tanpa data pelanggan tidak dihitung.Last 90 days. Repeat = 2+ orders. Store sales without a customer record are not counted.
Pendapatan = total pesanan di Jubelio (grand total; untuk Shopee sudah dipotong biaya layanan), tanpa pesanan batal/retur. Merek ditentukan dari toko penjual: Sinar Starbooks = toko marketplace Sinar Starbooks + Blibli + Lazada; Wonder Bookstore = toko Wonderstore + semua kasir toko (POS); Kikkerland = toko Kikkerland. Tanggal dalam WIB.Revenue is Jubelio's order grand total (for Shopee this is already net of the service fee), excluding cancelled and returned orders. Brand comes from the selling store: Sinar Starbooks = its marketplace shops + Blibli + Lazada; Wonder Bookstore = Wonderstore shops + all in-store POS; Kikkerland = the Kikkerland shops. Dates are WIB.
–
Pendapatan kasir per hari dan jam (WIB), 90 hari terakhir. Makin gelap makin ramai: untuk jadwal staf dan jam promo toko ini.POS revenue by weekday and hour (WIB), last 90 days. Darker = busier: for this store's rosters and promo timing.
Periode terpilih, transaksi kasir (POS) per toko. Klik judul kolom untuk mengurutkan; baris toko terpilih disorot. Filter merek dan online/toko tidak berlaku di halaman ini.Selected period, POS transactions per store. Click a column header to sort; the selected store's row is highlighted. The brand and online/store filters do not apply on this page.
Penjualan per barang (sebelum potongan marketplace) di periode terpilih. Kategori disimpulkan dari ISBN dan nama barang.Item-level sales (before marketplace deductions) in the selected period. Category is inferred from ISBN and item name.
Kenaikan unit terbesar vs periode sebelumnya: pastikan stok aman.Biggest unit increase vs the period before: make sure stock keeps up.
90 hari terakhir. Pemasok = pemasok pesanan pembelian (PO) terakhir untuk barang itu di Jubelio. Lead time = median jarak tanggal PO ke tanggal tagihan pembelian. Harga pokok tidak ditampilkan. Tidak ikut filter merek dan periode.Last 90 days. Supplier = the supplier on the item's most recent purchase order in Jubelio. Lead time = median days from PO date to purchase bill date. Cost prices are not shown. Not affected by the brand and period filters.
–
Data reseller Sinar Star berasal dari Reseller Recency Database dan Reseller Tracker (bukan Jubelio), per 14–22 Okt 2026. Filter merek dan periode tidak berlaku di sini.
Sinar Star reseller data comes from the Reseller Recency Database and Reseller Tracker files (not Jubelio), as of 14–22 Oct 2026. Brand and period filters don't apply here.
P1 jaga, P2 order kedua, P3 telepon sekarang, P4 hidupkan lagi, P5 menangkan kembali, P6 cuci gudang, P7 portal saja.P1 protect, P2 second order, P3 call now, P4 re-spark, P5 win back, P6 clearance offer, P7 portal only.
Beban akun, nilai 2026 dan progres kontak per PIC.Account load, 2026 value and outreach progress per PIC.
Akun bernilai yang mulai diam: P3 (60–180 hari tanpa order, 5+ invoice) dan P1 yang sudah 45+ hari tidak order. Diurutkan menurut nilai 2026.Valuable accounts going quiet: P3 (60–180 days without an order, 5+ invoices) and P1 accounts with no order for 45+ days. Sorted by 2026 value.
Jumlah akun dan penjualan 2025 vs 2026 YTD.Accounts and sales, 2025 vs 2026 YTD.
Semua akun, diurutkan menurut total Jan 2025 – Okt 2026.All accounts, sorted by total Jan 2025 – Oct 2026.
Transfer_Stok_Toko_Offline.xlsx seperti yang biasa dipakai tim toko: Ringkasan per toko, Rekomendasi Transfer (stok habis di toko tujuan tapi laku di sana, sampai 3 sumber), Daftar Transfer per Rute untuk dokumen transfer di Jubelio, dan Perlu Restock. Saran qty = ½ × penjualan POS 3 bulan. Dibuat ulang otomatis setiap pagi.Transfer_Stok_Toko_Offline.xlsx as the store team uses it: per-store summary, transfer recommendations (out of stock at the destination but selling there, up to 3 sources), a per-route list for Jubelio transfer documents, and a restock list. Suggested qty = ½ × 3-month POS sales. Regenerated automatically every morning.
–
–
Nilai stok dihitung dengan harga jual (Jubelio tidak menyimpan harga pokok). Umur = hari sejak barang itu terakhir terjual di lokasi tersebut. Sell-through = terjual ÷ (terjual + stok).Stock value is at selling price (Jubelio holds no cost price). Age = days since the item last sold at that location. Sell-through = sold ÷ (sold + on hand).
Hijau = laku dalam 30 hari; ungu tua = belum laku 180+ hari.Green = sold within 30 days; dark purple = unsold for 180+ days.
Terjual ≥1 per 10 hari, stok ≤21 hari (semua lokasi). Merah = ≤7 hari.Selling at least 1 every 10 days with 21 days of stock or less, all locations. Red = 7 days or less.
Oversold artinya barang sudah dipesan/terjual lebih banyak daripada stok fisik di lokasi itu, sehingga stok tersedia minus. Contoh: stok 4, dipesan 18 → tersedia −14. Pesanan belum bisa dikirim sampai barang datang atau ditransfer, jadi berisiko batal dan kena penalti marketplace. Penyebab umum: stok tidak sinkron antar marketplace, flash sale, atau penjualan pameran yang belum dicatat.Oversold means more units were ordered or sold than are physically on hand at that location, so available stock is negative. Example: 4 on hand, 18 reserved → −14. These orders can't ship until stock arrives or is transferred, so they risk cancellation and marketplace penalties. Common causes: stock not synced across marketplaces, flash sales, or exhibition sales not yet recorded.
Barang yang tidak laku 90+ hari di satu lokasi tetapi laris dan menipis di lokasi lain. Jumlah = kekurangan di tujuan, maksimal stok di asal. Diurutkan menurut nilai jual.Items unsold for 90+ days at one location but selling and short at another. Qty = the shortfall at the destination, capped at the source stock. Sorted by sales value.
Di bawah titik pesan ulang di lokasi itu, diurutkan menurut unit terjual.Below the reorder point at that location, ranked by units sold there.
Unit terjual terbanyak, semua lokasi (periode best-seller Jubelio). Merah = habis.Top sellers in units across all locations (Jubelio best-seller period). Red = none left.
Tidak terjual di lokasi mana pun 90+ hari, total semua lokasi (60 teratas).No sale at any location in 90+ days, totalled across locations (top 60). – judultitles, – unitunits.
Tidak laku 90+ hari di toko ini (bisa jadi masih laku di toko lain): kandidat transfer, bundling atau diskon.No sale in 90+ days at this store (it may still sell elsewhere): candidates to transfer, bundle or discount.
Stok dipakai bersama semua merek, jadi filter merek dan periode tidak berlaku di sini. Bahan kafe, tas belanja dan bahan kemasan tidak dihitung. Data dari peringatan stok Jubelio.Stock is shared across brands, so the brand and period filters don't apply here. Café ingredients, shopping bags and packing materials are left out. From Jubelio's inventory alerts.
–
90 hari terakhir. Nilai = penjualan kotor yang hilang.Last 90 days. Value = gross sales lost.
Diskon + biaya marketplace sebagai porsi penjualan kotor.Discounts + marketplace fees as a share of gross sales.
Rincian keuangan tersedia untuk 90 hari terakhir (data per pesanan dari Jubelio). Jubelio hanya mencatat biaya layanan untuk Shopee; biaya Tokopedia/TikTok belum tercatat sehingga uang diterima untuk kanal itu masih terlalu tinggi. Harga pokok (HPP) tidak diisi di Jubelio, jadi margin belum bisa dihitung di sini.Finance detail covers the last 90 days (order-level data from Jubelio). Jubelio only records the service fee for Shopee; Tokopedia/TikTok fees aren't recorded, so money received for those channels is overstated. Cost price (HPP) is empty in Jubelio, so margin can't be calculated here yet.
90 hari terakhir dari data rinci pesanan; tidak ikut filter periode. Belanja lagi = pelanggan yang sama memesan lagi dalam 7 hari setelah pembatalan. Benar-benar hilang = nilai batal dikurangi yang belanja lagi. Pembeli tanpa ID pelanggan (walk-in kasir) tidak bisa dilacak.Last 90 days from order-level data; not affected by the period filter. Bought again = the same customer ordered again within 7 days of the cancellation. Truly lost = cancelled value minus those who bought again. Buyers without a customer ID (till walk-ins) cannot be traced.
90 hari, per kanal. Judul yang sering batal biasanya soal harga atau stok yang ternyata kosong.90 days, per channel. Titles that keep getting cancelled are usually a price or an out-of-stock problem.
Pesanan online dikirim dari stok toko. Toko dengan pembatalan tinggi biasanya punya masalah stok tercatat vs fisik. Filter merek tidak berlaku.Online orders ship from store stock. A store with many cancellations usually has a recorded-vs-physical stock problem. The brand filter does not apply.
Oversold artinya barang sudah dipesan atau terjual lebih banyak daripada stok fisik yang ada di lokasi itu, sehingga stok tersedia menjadi minus.
Oversold means more units have been ordered or sold than are physically on hand at that location, so available stock goes negative.
Contoh: di PAMERAN ASHTA ada 4 Squishy Pao Mix di rak, tetapi 18 sudah dipesan. Tersedia = 4 − 18 = −14. Ke-14 pesanan itu belum bisa dikirim.
Example: PAMERAN ASHTA has 4 Squishy Pao Mix on the shelf, but 18 are reserved by orders. Available = 4 − 18 = −14. Those 14 orders can't ship.
Kenapa penting: kalau terlalu lama, marketplace membatalkan pesanan dan toko kena penalti (skor toko turun).
Why it matters: if they wait too long, the marketplace cancels the orders and the shop is penalised (lower shop score).
Penyebab umum: stok tidak sinkron antar Shopee/Tokopedia, flash sale atau promo tanggal kembar, dan penjualan pameran yang belum dicatat.
Common causes: stock not syncing between Shopee and Tokopedia, flash sales or double-date promos, and exhibition sales not entered in time.
Yang harus dilakukan: transfer stok dari toko lain, percepat penerimaan barang, atau hubungi pembeli sebelum dibatalkan. Lalu cek pengaturan sinkronisasi stok di Jubelio.
What to do: transfer stock from another store, speed up receiving, or contact the buyer before the order is cancelled. Then check stock sync settings in Jubelio.
Tombol Online + toko / Toko (offline) / Online di bawah judul memisahkan penjualan berdasarkan kanal:
The Online + stores / Stores (offline) / Online switch under the header splits sales by channel:
Penting: pesanan online sering dikirim dari stok toko (mis. PIM atau ASHTA). Di tabel Per toko, pesanan itu masuk kolom Online toko tersebut, bukan Di toko. Contoh 10.10: penjualan kasir normal (Rp 48,7 jt), tetapi online melonjak dan sekitar Rp 56 jt pesanan online dikirim dari toko.
Important: online orders are often shipped from store stock (e.g. PIM or ASHTA). In the By store table those orders count in that store's Online column, not In-store. On 10.10, cashier sales were normal (Rp 48.7jt) while online spiked, and about Rp 56jt of online orders shipped from stores.
Di grafik Tren pendapatan, pilih Toko vs online untuk melihat keduanya bertumpuk per hari.
In the Revenue trend chart, choose Store vs online to see both stacked per day.
Filter ini berlaku di Ringkasan, Penjualan & toko, dan Keuangan. Belum berlaku untuk data per judul (tab Produk).
The filter applies to Overview, Sales & stores and Finance. It doesn't apply to title-level data (Titles tab) yet.
Target bulanan per toko dari file Target Wonder Bookstore 2026. Aktual dihitung dari Jubelio untuk merek Wonder Bookstore: Toko = penjualan kasir di toko itu (target kopi Berawa digabung ke kasir Berawa), Shopee = pesanan Shopee yang dikirim dari stok toko itu. Baris ST di file (misalnya PIM ST) belum diketahui padanannya di Jubelio, jadi ditampilkan tanpa aktual. Seharusnya = bagian bulan yang sudah lewat. Hijau = di atas laju, kuning = sedikit di bawah, merah = jauh di bawah. Proyeksi = aktual sampai kemarin + perkiraan sisa hari dari rata-rata hari yang sama 8 minggu terakhir. Jika target berubah, kirim file baru; dashboard memuatnya ulang.
Monthly targets per store from the Target Wonder Bookstore 2026 file. Actuals come from Jubelio for the Wonder Bookstore brand: Store = till sales at that store (Berawa's coffee target is added to the Berawa till), Shopee = Shopee orders shipped from that store's stock. The file's ST rows (for example PIM ST) have no known Jubelio equivalent yet, so they show without an actual. On pace = the share of the month already passed. Green = ahead of pace, amber = slightly behind, red = well behind. Projected = actuals through yesterday plus the remaining days estimated from the same weekday's average over the last 8 weeks. If the targets change, send the new file and the dashboard reloads it.
Sinkron pagi menulis bagian data dari daftar beli mingguan. Perlu dipesan ulang: judul yang laku minimal 6 unit dalam 90 hari dan stoknya (tersedia + sudah dipesan) habis sebelum pesanan ulang bisa tiba. KRITIS = habis sebelum pesanan yang dibuat hari ini tiba (cukup kurang dari lead time); SEGERA = kurang dari lead time + 30 hari; PANTAU = kurang dari lead time + 60 hari. Saran pesan menutup lead time + 30 hari jualan. Untuk toko Wonder, pemasok di Jubelio hampir selalu PT. Sinar Star Books (gudang distribusi, lead time ±12 hari); penerbit dan lead time impor ada di sistem Sinar (Accurate). Lead time diukur per pemasok dari PO ke tagihan pembelian (minimal 2 PO), selain itu 90 hari. Lambat laku: stok ≥3 tanpa penjualan 90 hari, atau ≤2 unit dengan stok ≥15.
The morning sync writes the data half of the weekly buy list. Reorder: titles selling at least 6 units in 90 days whose stock (available + on order) runs out before a reorder can land. KRITIS = runs out before an order placed today can land (cover under the lead time); SEGERA = under lead time + 30 days; PANTAU = under lead time + 60 days. Suggested quantity covers the lead time plus 30 days of selling. For Wonder stores the Jubelio supplier is almost always PT. Sinar Star Books (the distribution warehouse, about 12 days); publishers and import lead times live in Sinar's system (Accurate). Lead time is measured per supplier from PO to purchase bill (at least 2 POs), otherwise 90 days. Slow movers: stock ≥3 with no sale in 90 days, or ≤2 units with stock ≥15.
Tautan tetap, diperbarui tiap pagi (dibaca Booky Scout):Fixed links, refreshed every morning (read by Booky Scout):
Satu halaman per toko fisik, angka kasir (POS) untuk periode terpilih, dengan peringkat di antara semua toko. Online dari toko = pesanan marketplace yang dikirim dari stok toko itu. Pelanggan terdata dan unit per struk berasal dari data rinci 90 hari, jadi periode lebih panjang dipotong. Stok menipis, stok mati, oversold dan usulan transfer adalah posisi saat ini, bukan periode.
One page per physical store, POS numbers for the selected period, ranked among all stores. Online from store = marketplace orders shipped from that store's stock. Known customers and units per ticket come from the 90-day order detail, so longer periods are clamped. Low stock, dead stock, oversold and suggested transfers are the current position, not the period.
Tidak semua pembatalan hilang: banyak pembeli yang "ubah pesanan" memesan ulang. Kartu ini mencocokkan ID pelanggan tiap pesanan batal dengan pesanan baru pelanggan yang sama dalam 7 hari. Yang tidak memesan ulang = benar-benar hilang. Judul dan toko pengirim menunjukkan di mana masalahnya: harga, stok kosong, atau pengiriman terlambat.
Not every cancellation is lost: many "modify order" buyers simply re-order. This card matches each cancelled order's customer ID with a new order by the same customer within 7 days. Those who didn't re-order = truly lost. Titles and shipping stores show where the problem is: price, stock-outs or late shipping.
Kartu Keranjang di Ringkasan membandingkan perilaku belanja online dan di toko untuk periode terpilih. Sumbernya data rinci pesanan Jubelio, yang hanya diambil untuk 90 hari terakhir; periode lebih panjang dipotong otomatis.
The Basket card on the Overview compares shopping behaviour online and in store for the selected period. It uses Jubelio order-level data, which is only pulled for the last 90 days; longer periods are clamped automatically.
| IstilahTerm | ArtinyaMeaning |
|---|---|
| PendapatanRevenue | Total pesanan di Jubelio (grand total), tanpa pesanan batal/retur. Untuk Shopee sudah dipotong biaya layanan.Jubelio order grand total, excluding cancelled/returned orders. For Shopee it is already net of the service fee. |
| Penjualan kotorGross sales | Harga barang sebelum diskon dan biaya marketplace (tab Keuangan).Item value before discounts and marketplace fees (Finance tab). |
| Uang diterimaMoney received | Kotor − diskon − biaya marketplace. Biaya Tokopedia/TikTok belum tercatat di Jubelio.Gross − discounts − marketplace fees. Tokopedia/TikTok fees aren't recorded in Jubelio yet. |
| Batal & returCancelled & returned | Porsi pesanan yang dibatalkan atau diretur dari semua pesanan.Share of all orders that were cancelled or returned. |
| Segera habisRunning out soon | Stok tersisa ÷ rata-rata terjual per hari ≤ 21 hari. Merah = ≤ 7 hari: segera pesan ulang.Stock left ÷ average daily sales ≤ 21 days. Red = ≤ 7 days: reorder now. |
| Stok menipisLow stock | Stok di bawah titik pesan ulang (ROP) yang diatur di Jubelio.Stock below the reorder point (ROP) set in Jubelio. |
| Stok matiDead stock | Barang yang tidak terjual 90+ hari. "Per toko" = tidak laku di toko itu; "per judul" = tidak laku di lokasi mana pun.Items unsold for 90+ days. "By store" = unsold at that store; "by title" = unsold anywhere. |
| Sell-through | Terjual ÷ (terjual + stok). Makin tinggi makin cepat stok berputar.Sold ÷ (sold + on hand). Higher = stock turns faster. |
| Nilai stokStock value | Unit × harga jual. Harga pokok (HPP) belum diisi di Jubelio, jadi margin belum bisa dihitung.Units × selling price. Cost price (HPP) is empty in Jubelio, so margin can't be calculated yet. |
| Usulan transferSuggested transfer | Barang mati di satu lokasi tetapi laris dan menipis di lokasi lain.Items dead at one location but selling and short at another. |
| P1–P7 (reseller) | P1 jaga, P2 order kedua, P3 telepon sekarang, P4 hidupkan lagi, P5 menangkan kembali, P6 cuci gudang, P7 portal saja.P1 protect, P2 second order, P3 call now, P4 re-spark, P5 win back, P6 clearance offer, P7 portal only. |
| MerekBrand | Dari toko penjual: Sinar Starbooks = toko marketplace Sinar Starbooks + Blibli + Lazada; Wonder Bookstore = toko Wonderstore + semua kasir toko; Kikkerland = toko Kikkerland.From the selling store: Sinar Starbooks = its marketplace shops + Blibli + Lazada; Wonder Bookstore = Wonderstore shops + all store cashiers; Kikkerland = the Kikkerland shops. |