- CSV — for promotions you build yourself from the Vori template.
- SIL (.txt) — for vendor-provided promotional SIL files from UNFI, AWG, and URM weekly TPRs/ADs. Download the SIL file from your vendor portal and import it directly into Vori — no formatting required in most cases. For edge cases where minor edits may be needed, see the troubleshooting notes below.
Before you begin
Before uploading, make sure your file meets these standards. This keeps your import smooth and error-free.- File format: .CSV (for self-built promotions) or .txt SIL files (for UNFI, AWG, and URM vendor-provided weekly TPRs/ADs).
- File size: Up to 500 lines per file. Got more? Split into multiple files.
- Supported promotions: Dollar Amount Price Reductions and Mix & Match (e.g., 2 for $4).
How to Format Your Promotion File
Headers should match the Vori template exactly for auto-matching. Use this guide:| Column | Description | Format / Notes |
|---|---|---|
| UPC | Product barcode | Required; cannot be blank |
| Desc | Product name | For reference |
| Sale Mult | Promotion quantity | Use “1” for single items, “2” for a 2-for-$4 deal |
| Sale SRP | Promotional price | Required; cannot be 0 |
| Start | Promotion start date | YYYY-MM-DD (e.g., 2026-03-01) |
| End | Promotion end date | YYYY-MM-DD (e.g., 2026-03-07) |
| Type | Promotion type code | Enter ADP for all promotions |
How to import a vendor SIL file (UNFI, AWG, URM)
If you’re importing a weekly promotional SIL file from UNFI, AWG, or URM, you can skip the formatting step entirely.- Download the promotional SIL file from your vendor portal the same way you do today.
- In New Back Office, go to Products > Promotions and click Import File.
- Drag and drop the SIL file (or select it from your computer). Vori detects the SIL format automatically.
- Select Stores where the promotions should apply.
- Review Linked Data: Check the Valid Rows and Invalid Rows tabs, then click Next and Commit.
Troubleshooting SIL imports
- If the upload times out: If the upload runs longer than 20 seconds, try the import again.
- If you receive an error referencing
0.00:- Open the SIL file in a plain text editor, such as TextEdit on Mac or Notepad on Windows.
- Search for
0.00. - Find the semicolon (
;) immediately before that0.00value. - Delete the text starting at that semicolon and continue deleting until the next semicolon that closes the same SIL section.
- Save the file and re-import it into Vori.
- If you are not sure which section to remove, stop editing the file and contact Vori Support for help.
How to import your promotions
- In New Back Office, go to Products and select Promotions in the left-hand navigation.
-
Click Import File (top-right).
-
Drag & drop your CSV or select it from your computer.
-
Select Stores: Choose the stores where these promotions should apply (default: All Stores).
-
Map Promotion Fields: Vori will match your file columns to system fields (e.g., UPC → Barcode). Review and click Next.
-
Review Linked Data: Check the Valid Rows and Invalid Rows tabs to ensure everything links correctly. Select Next, then click Commit once the file has been processed.
-
A confirmation page will appear.\
Troubleshooting & FAQs
-
Why did my file fail to upload? Check for blank rows, spreadsheet formulas, “0”, or non-hyphenated date values in the UPC, Sale SRP, or Start & End columns, as these will cause the upload to fail.
-
Do I need to publish for each location? If the UPC is in the product file for every location, selecting All Stores in step 2 of the Import Promotions process will automatically apply the promotion across your entire chain.
-
What if the promo price is higher than the retail price? Vori allows you to import these to save you time. However, to protect your shoppers, the POS is designed to ignore promotional pricing that is higher than the standard retail price.
