Learn how to import a promotion file to upload hundreds of promotional prices, start dates, and eligible products in a single step.
Managing store-wide promotions shouldn’t eat up your day. With Vori, you can import a promotion file to upload hundreds of sale prices, start dates, and eligible products in one go. That means consistent pricing across your stores without the busywork.Vori supports two import paths:
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.
Date range: One start date and one end date per file. Promotions with different dates need separate 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
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
MM-DD-YYYY (e.g., 03-01-2026). Must be the same on every row
End
Promotion end date
MM-DD-YYYY (e.g., 03-07-2026). Must be the same on every row
Use one date range per file. Each import can only handle one start date and one end date. If your promotions run on different dates, split them into separate files, one for each date range, and import each file on its own.For example, if some items are on sale March 1–7 and others March 8–14, create two files: one for the March 1–7 items and one for the March 8–14 items.
Open the Promotion Import Template in Google Sheets, select File > Make a copy, and enter your data there to ensure the headers stay perfect.
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 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 that 0.00 value.
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 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, or “0” values in the UPC or Sale SRP 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.
