PSP Weekly Order Builder

Upload this week's two reports, set the order maximum, and download the order. Files are read in your browser and are never uploaded anywhere.

1. Upload this week's reports

Drop both Excel files here, or tap to choose The PSP suggested order (Order Detail) and the 6-week Item Level View. Either order works.

Suggested order (Order Detail): not loaded

6-week sales (Item Level View): not loaded

2. Order limits

Order maximum (manager)

The order total will never go over this amount.

Weeks of supply to stock

Fast sellers topped up to

The base order covers every item to the first number of weeks. Any money left under the maximum raises the fastest sellers to the second number.

More options

Never order more than PSP suggested
Matches the other store's sheet. Untick to let fast sellers go above PSP's suggestion.

Money reserved for shelf holes

Buys 1 unit (cheapest first) of items PSP suggested that have zero stock and no sales in 6 weeks. 0 turns it off.

Leave these departments out of the order

Departments appear after the files are loaded.

3. Your order

-Order total

-Under the maximum

-Lines to order

-PSP originally suggested

Both downloads list every item from your Order Detail, including the ones set to order 0. The edited Order Detail keeps PSP's original layout with only the order quantities changed.

Search the order

Item ID	Description	Dept	Qty	Cost	Total	Sold 6 wk	On hand + on order	Wks cover after	Why

Method: weekly sales = 6-week units / 6; need = weekly sales x weeks of supply - (on hand + on order); order = need rounded up to whole cases, capped at PSP's suggested quantity. Items with no sales in 6 weeks are not ordered unless shelf-hole money is set.