Margin Master
Single Main Table Framework with Mi9 Support (Phase 1-2)
Shipped in Margin Master 2026.914.13400 · September 14, 2026
Introduced a new single-table architecture option for Mi9 stores, consolidating all store data into one Mi9_mainTable instead of separate per-store or per-team tables. This reduces database complexity, improves query performance through better indexing, and simplifies multi-store operations while maintaining full backward compatibility with existing multi-table configurations.
What changed
Mi9 stores can now enable Single Main Table mode in Options, which combines all store data into one Mi9_mainTable. This improves performance for selections and reports across multiple stores, though individual stores can continue using the traditional separate-table approach.
Pricing updates now run significantly faster, especially when working with stores that have large inventories, through internal calculation improvements.
Mi9 users can now switch between single-table and multi-table modes directly in the Mi9 Options screen, with the system automatically rebuilding the database structure safely.
Store and group selections now work correctly whether you're using single-table or multi-table mode, ensuring pricing changes only affect the intended stores.
Resetting future prices now correctly affects only the active store or group selection without unintentionally clearing other data in the same table.
Pricing strategy steps now correctly track which items they processed, even when all store data lives in a single table.