> ## Documentation Index
> Fetch the complete documentation index at: https://help.vori.com/llms.txt
> Use this file to discover all available pages before exploring further.
# How to Format and Import INFRA Promotion Files
> Learn how to import an INFRA promotion file to upload hundreds of promotional prices, start dates, and eligible products.
***
### 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.
* **Date ranges:** Create separate files for each selected date range (e.g., 2026-04-09 to 2026-05-12, & 2026-04-09 to 2026-05-25).
✏️**Note:** Please ensure files are split by date range. The promotion import tool currently supports only one date range per upload.
***
### How to Format Your Promotion File
Headers must match the Vori template to enable auto-matching. Any additional columns can be removed. Refer to this guide for details:
| Column | Description | Format / Notes |
| -------------------- | -------------------- | --------------------------------------------------------------- |
| **UPC** | Product barcode | Required; cannot be blank |
| **Desc** | Product name | For reference |
| **Flyer \$** | Promotional price | Use Promotional Price(e.g., $3.79) or Mix and Match(e.g., 2/$4) |
| **Flyer Start Date** | Promotion start date | **YYYY-MM-DD** (e.g., 2026-03-01) |
| **Flyer End Date** | Promotion end date | **YYYY-MM-DD** (e.g., 2026-03-07) |
\*\*💡Tip:\*\*Open the [**Promotion Import Template**](https://docs.google.com/spreadsheets/d/10_io1FBNy-uErI5HhwNJwFadvlSwzG-WHiKvMJZifMI/edit?usp=sharing) in Google Sheets, select **File → Make a copy.** You can use this as a guide or enter your data directly to ensure the headers remain correctly formatted.
***
### How to Import Your Promotions
1. In **Back Office**, go to **Products** and select **[Promotions](https://app.vori.com/retail/promotions)** in the left-hand navigation.
2. Click **Import File** (top-right).
3. Drag & drop your **CSV** or select it from your computer.\\
4. **Select Stores:** Choose the stores where these promotions should apply (default: All Stores).\\
5. **Map Promotion Fields:** Ensure all columns are mapped correctly—do not skip any fields on this page. Map both **Offer Quantity** and **Offer Price** to **Flyer \$**, then review your selections and click **Next**.
6. **Review Linked Data:** Check the **Valid Rows** and **Invalid Rows** tabs to ensure everything links correctly.
7. **Review Linked Data:** Check **For Import** and **Unmatched** tabs to ensure everything links correctly. Select **Commit** when you're ready to save the promotion as a draft.
8. A confirmation page will appear.
9. In order to Publish the promotion, Return to Promotions, navigate to **Drafts.**\
Find the promotion and tap **Publish.\
**
💡**Tip:** Change the promotion name to easily identify the promotion.
✏️**Note:** Our system defaults Mix and Match promos to **No Minimum Required**. If you want to change the Condition, you will need to edit the offer after the import has been committed.
***
### Troubleshooting & FAQs
* **Why did my file fail to upload?** Check for blank rows or spreadsheet formulas in the **UPC** column.
* **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.
\\
