1\begin{table}[htbp]\centering\small2\caption{Sample flow from database rows to the analysis samples}\label{tab:sample_flow}3\begin{adjustbox}{max width=\textwidth}4\begin{tabular}{lr}\toprule5Step & Listings \\\midrule6DB product rows (all statuses, all stores) & 465\,388 \\7active = 1 and listing\_status = 'published' & 390\,108 \\8\ldots of an enabled store with >= 1 published listing & 390\,108 \\9\ldots excluding store\_kind = hors\_mission & 390\,074 \\10\ldots keeping one representative per (store, normalised title) and non-empty title & 370\,828 \\11\ldots excluding mirror domains of the same business (sibling stores, non-representative) \textbf{[ASSORTMENT SAMPLE]} & 370\,054 \\12\ldots and CAD-priced store/listing & 369\,325 \\13\ldots and a positive listed price <= 50 000 CAD, not on request \textbf{[PRICE SAMPLE]} & 359\,612 \\14\bottomrule\end{tabular}15\end{adjustbox}16\begin{minipage}{0.95\textwidth}\vspace{2pt}\footnotesize\textit{Notes:} Snapshot of 2026-11-01T17:38Z. Nothing is deleted: each step is a flag in the cleaned listing table. The assortment sample is used for H1--H4 and H7; the price sample for H5.\end{minipage}17\end{table}18