assortment-planning

Run the rationalize command with a revenue contribution threshold, such as the bottom 5 percent over a 90-day period. The report flags SKUs below the threshold and generates a proposed discontinuation list with projected impact analysis.

Use the category report command with a period and date to get sales, gross margin, and inventory turnover per category. Results can be filtered by store and compared against category targets like 40 percent margin and 6-12x annual turnover.

It tracks gross margin percentage, inventory turnover, SKU productivity, sell-through rate, weeks of supply, and category share. Each metric has configurable targets, for example sell-through above 70 percent and 4-8 weeks of supply.

Yes, category-specific targets are defined in a categories.yaml file with margin, turnover, and sell-through targets per category. Environment variables like ASSORTMENT_TURNOVER_TARGET and ASSORTMENT_SELL_THROUGH_TARGET set global defaults.

Avoid rationalizing seasonal SKUs based on off-season performance; use trailing 12-month data instead. Also check vendor minimum order quantities and potential cannibalization effects before discontinuing products.

The default evaluation window is 90 days, configurable via ASSORTMENT_NEW_PRODUCT_WINDOW. Categories with longer purchase cycles may need extended windows, so set category-specific evaluation periods based on buying behavior.