Import Products from a spreadsheet for a promotion.

Macro Instructions for carrying Article Information through to Feature List






Business Function

CMS Category




Feature Description

(Written for our customers and can be pasted into comms sent to them)

Additional info


Self Configurable

Ballpark Hours
From CV

(if opting for CV to complete self config component)

Ballpark Hours
From CV

(in addition to any self config required)

Third Party Costs

Instructions for carrying Excerpts through from this page to the Feature List

Article Page:

Add macro  / Multiexcerpt (or copy and existing excerpt and edit) or (Copy existing page and place content into existing excerpt macros)

On Features List page:

Click in the Cell to be populated  / add macro /  Multiexcerpt Include / Select the Article page and the excerpt (or copy another feature line and edit the 'Article page' source.


Free Product promotions can be configured in a few different ways, one of them being the requirement to purchase from a pool of eligible products in order to receive the free item. If your eligible product pool contains scores of product codes, you may wish to import them from a spreadsheet when creating your promo code in the CMS.

This guide assumes you have already saved your list of eligible products in a .csv file. Products can be specified by Product Code, Category, or Stock Group (or a combination of all 3!).

Step-by-step guide 

Follow the Free Product Promo guide to create your promotion code. When you get to the step where you specify the Eligible Products, it's time to take advantage of the import feature. 

  1. Click 'Import Eligible Products'

  2. Use the dropdown to select the import type you'd like to use: 
    • Append - add products on the sheet to any existing products in the promo, or 
    • Overwrite - replace any existing products with the ones on the sheet. 

  3. Click 'Select Files' to browse to your saved .csv file. The import will begin immediately on selection of your file. 

  4. The notification at the top right will let you know whether the import was successful or not.


  5. If there are errors, the Import Log will detail which lines have failed and why. 

  6. When you're happy with the import, click 'Back' to return to the Promo Code edit page.

  7. Finish configuring your promotion (i.e. enter the code for the free product, the quantity to be given and so forth) and click 'Save' when complete.

And that's it! Your promotion is all ready to go.

Nice work, you.

Additional Information

Importing Products to a Promotion

Minimum Version Requirements




Self Configurable


Business Function


BPD Only?




Ballpark Hours From CV (if opting for CV to complete self config component)

Contact Commerce Vision

Ballpark Hours From CV (in addition to any self config required)

Contact Commerce Vision

Third Party Costs


CMS Category

 Campaigns & Promotions → Promotion Codes

Related help