Import Price Data — Overview#

Import Price Data is a tool in the Fillet web app for importing ingredient prices in bulk. Instead of entering prices one by one, you prepare a CSV file and upload it. Fillet reads the file and creates the prices for you.

It is available on the web app only.

When to use it#

• Setting up Fillet for the first time — if you have prices from a supplier price list, an existing spreadsheet, or an invoice, Import Price Data lets you get everything in quickly.
• Updating prices from a supplier — when a vendor sends you a new price list, you can import it rather than updating each ingredient manually.

How it works#

The import process has four steps:

1. Select your locale

Fillet auto-detects your locale based on your browser and location. If the suggestion is wrong, you can select a different one manually. The locale determines how numbers in your file are interpreted — for example, whether a comma is a thousands separator or a decimal separator. Make sure the locale matches the number formatting in your file.

2. Download the sample file

Fillet provides a sample CSV file formatted for your selected locale. Download it and use it as your starting point.

3. Enter your data

Open the sample file in any spreadsheet application — Numbers, Excel, or Google Sheets all work. Fill in your ingredient names, amounts, units, and prices. When you are done, export the file as CSV.

4. Upload and import

Select or create a vendor, upload your file, and start the import. Fillet will process the file and report any errors.

One vendor per file#

Each import file is for one vendor. If you have prices from multiple vendors, prepare a separate file for each one. You can run the import multiple times.

How ingredients are matched#

When Fillet processes each row, it checks if an ingredient with the same name already exists in your account. The match is exact and case-sensitive — “Chicken Breast” and “chicken breast” are treated as different ingredients.

• If the ingredient exists, Fillet adds the price to it.
• If the ingredient does not exist, Fillet creates a new ingredient with that name and adds the price to it.

If your account has multiple ingredients with the same name, Fillet adds the price to the first one found.

Duplicate prices are skipped#

If a row in your file would create a price that already exists for the same vendor, ingredient, unit, amount, and price value, Fillet skips it. No duplicate price is created. This means you can safely re-import the same file without creating duplicate data.

After importing#

Once the import completes, Fillet shows a summary of what was created: the number of ingredients inserted, prices inserted, custom units inserted, and prices deleted (if you used the “delete all prices” option). Refresh the page in the Fillet web app to see your new prices.