![vori-logo-black-horizontal-01 (1).png]](https://help.vori.com/hs-fs/hubfs/vori-logo-black-horizontal-01%20(1).png?height=42&name=vori-logo-black-horizontal-01%20(1).png){kind=logo}
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.
Table of Contents
Before You Begin
Before uploading, make sure your file meets these standards. This keeps your import smooth and error-free.
-
File Format: Must be saved as a .CSV.
-
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 must match the Vori template exactly. 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 |
💡Tip: 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 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 will appear in the bottom-right corner.
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.
