Margin Master

Epicor FTP/INFILE Single Main Table Support (Per-Store Grain)

Shipped in Margin Master 2026.914.29604 · September 14, 2026

The single main table option is now available for Epicor stores that import through the FTP/INFILE route. Like the MySQL/Compass route released earlier, this consolidates all store data into one table with one row per SKU per store, replacing the previous one-table-per-store approach.

What changed

Single Main Table for Epicor FTP/INFILE Import

If you use Epicor FTP import, you can now turn on "Use a single main table" under Tools > Options > POS/Connections > Epicor tab. This will rebuild your pricing data into one combined table instead of separate tables per store. Re-run your strategies after switching modes. (Note: Store grouping must be turned off first on the FTP import.)

Store Ignore List Applied to Single Main Table

Stores you've marked to ignore in Store Manager are now properly excluded when using the single main table, just like they are with separate tables per store.

Zone Pricing on Single Main Table Processes Store-by-Store

Zone pricing now correctly processes each store's data within the single main table, applying the same pricing rules you're used to with separate tables.

Unique Key Now Includes AltSku for Ace Direct Items

Ace Direct items with 'D' suffixes are now properly preserved as separate rows in the single main table, matching how they appear in your individual store tables.

Startup Reconcile and Mode Switch Handle Single Table

Switching between single and multi-table modes now properly rebuilds your Epicor data without accidentally removing tables you need.

See all Margin Master releases