Free restaurant resources

Restaurant order guide template

Download a DishCost CSV with four synthetic ingredients. Use it to see how item codes, case contents, and purchase prices map into ingredient costs. The file is free to download without an account.

Download the order guide template (.csv)

Map these five columns

ColumnMeaning
SKUStable item code. Keep it unchanged when you upload new prices.
DescriptionIngredient name. The example marks each name as synthetic.
Pack SizeCase contents, such as 4/5 LB for four 5 lb packs.
UOMPurchase unit. CS means that Unit Price is for the whole case.
Unit PricePrice per purchase unit, in USD here. Use plain numbers without currency symbols.

DishCost recognizes these headers and offers the matching columns. Review the mapping and the preview before you import. For chicken, 4 × 5 lb = 20 lb per case. A $60 case becomes $3.00 per lb. Rice is $1.00 per lb and eggs are $0.25 each. Oil is $12 ÷ 128 = $0.09375 per fl oz; the import rounds unit prices to four decimals, so the preview stores $0.0938. FLOZ is the fluid-ounce code used in this file.

For a per-pound quote, use 1 LB in Pack Size, LB in UOM, and the per-pound price in Unit Price. For a per-item quote, use 1 EA, EA, and the price for one item. Keep the pack contents consistent with the amount the price covers; changing UOM alone does not change a pack that already has a unit.

Upload new prices. Update the same saved dish.

In this 64-second test, a chicken case rises from $60 to $72. The second upload updates its existing ingredient price. The saved chicken rice bowl then changes from $1.75 to $2.05 per serving, with no recipe edit.

Actual app screenshots: the same saved chicken rice bowl costs $1.75 before the second upload and $2.05 after. A 20 lb chicken case rises from $60 to $72. The second upload adds zero ingredients and updates one price.
Open the image for a closer look. Both uploads leave four ingredients. The same vendor key and SKU point to the same ingredient; the second result is 0 added, 1 price update, and 3 unchanged.

Check the math: 4 × 5 lb = 20 lb per case.

First file: $60 ÷ 20 = $3.00/lb. Later file: $72 ÷ 20 = $3.60/lb.

The bowl uses 0.5 lb chicken and 0.25 lb rice at $1.00/lb. Its cost changes from (0.5 × $3.00) + $0.25 = $1.75 to (0.5 × $3.60) + $0.25 = $2.05. At an $8 menu price, food cost changes from 21.9% to 25.6%.

This is a local test with synthetic data, checked October 20, 2026. The recipe was prepared for the test. Both CSV uploads use the actual app import. This does not validate an official Sysco, US Foods, or other vendor export.

Download the later price file (.csv)

Import and update supplier prices

  1. In Ingredients, open the order guide import and select the distributor or vendor.
  2. Upload the CSV, review column mapping, and check each calculated unit and price.
  3. Confirm the first import, then save a dish that uses those ingredients. For this sample, use the vendor key synthetic-supplier.
  4. When you receive new prices, upload the later CSV manually. Keep the same vendor key and SKUs. Different keys or SKUs can create another ingredient instead of updating it.
  5. Review the preview, confirm the upload, and open the saved dish to see its new cost.

Persistent order guide import requires DishCost Pro ($39/month) or eligible access through an active distributor partnership. The free download does not include that app entitlement. Imports accept CSV files up to 5 MB and 10,000 data rows. Upload each new file yourself; DishCost does not fetch supplier prices on a schedule or scan invoices in this workflow.

This is a DishCost template with synthetic data, checked October 9, 2026. It is not an official Sysco, US Foods, or other distributor document. Review your actual export; vendors use different columns and pack formats.

Will your price file import?

Ask us to check a small sample before you pay for Pro. Remove account numbers, addresses, and other private details. We will check its columns, pack sizes, and price units and tell you what needs to change.

Check whether my price file will import

Plan your ordering and costing workflow

The restaurant order guide article explains the purchasing workflow. Use the recipe costing template to turn purchase prices into batch and portion costs.

See DishCost recipe costing software for saved ingredient prices and recipe updates. The demo lets you change sample prices and cost one dish; it does not import order guides.

Try the public recipe demo