Promotions
      Back to home
      1. Vori Help Desk
      2. Back Office
      3. Promotions

      How to format a promotion file so it can be imported into the Promotions tool

      This article explains the formatting requirements for a promotion file so it can be imported in the Promotions tool

      Link to the template here

      Required Fields

      Column Description
      UPC The barcode of the product on promo.
      Desc     The barcode of the product on promo.
      Sale Mult     Quantity for the promotion. For single-item promotions, use 1. For mix & match promos (e.g., 2 for $4), enter 2.
      Sale SRP     Sale price of the product.
      Start     Promotion start date in the format YEAR-MO-DY (e.g., 2025-07-30).
      End     Promotion end date in the format YEAR-MO-DY (e.g., 2025-08-30).
      Type Enter “ADP” for all promotions.

      ✏️ Note - The field names in the file must match the template exactly (including spelling) to ensure a successful upload.

      ⚠️ Caution - Required fields cannot be blank or contain a value of 0. Any missing or zero-value data will prevent the file from uploading.

      Promotion Types Supported

      This import only supports these promotion types:

      • Price reduction

      • Buy X, get Y free

      • Mix and match (e.g., 2 for $4)

      ✏️ Note - Percent-off discounts (e.g., 10% off) cannot be imported using this process.

      Directions

      1. Open the Promotion Import Template - Google Sheets and select file > make a copy to edit the sheet. 

      2. Enter the required fields.

      3. Download the file as .CSV.

      4. Follow this article for instructions on how to upload the file.

      ✏️ Note:
      Only .CSV files can be uploaded.


      ✏️ Note - The uploaded file must be in .CSV format. Files in other format types cannot be uploaded.