Creating bundles using a spreadsheet

Goal: Create product bundles

 

 

PRE-REQUISITE

Be sure to have proportionally scaled product images in your brand asset library before starting this.

 

 

 


Step 1: Download & open bundle CSV template

Download the bundle CSV template and open in your favorite spreadsheet editor. 

BundleCSVTemplate

Column definitions:

bundle_name

This is how you can define which products belong to which bundle. All products sharing the same bundle name, will be part of the same bundle. This column will also be used as the filename for the newly created bundle files.

image_filename

This is where the file names of products you wish to bundle together will be pasted. These filenames must match the actual filename you uploaded to the asset library. 

CopyFileNameFromAssets

quantity

Quantity is the number of times you want this product item repeated. 

inner_space

This is the space between individual products within on group

group_space

This is the space between groups of different products


Step 2: Copy and paste filenames from asset library to CSV

  • From the left-side navigation Brand settings > Image assets  and navigate to the products you wish to include in the bundle.
  • Click on the filename to copy the name to your clipboard.

 

TIP

Filenames do not necessarily need to be copied from the asset library, as long as the filename is correct, it can come from anywhere.

 

 

 

  • Paste the filename into the image_filename column of the CSV

Step 3: Enter content amount and adjust spacing

  • Under quantity, set the amount of instances each individual product should repeat
  • Adjust spacing as needed between individual instances of one product and between groups of products by adjusting inner_space and group_space respectively.
  • Once complete, export this spreadsheet as a CSV.

Step 4: Open bundle editor to create bundle files

  • Navigate to Brand settings > Image assets > Product bundles and from the flyout menu under the '+' icon, select Bundle from CSV.

CreateBundleButton

  • Either drag or click to browse the CSV we just exported and see a preview for the first bundle

UploadCSVtoPreviewBundles

  • Adjust spacing as needed and Save bundles as image assets

SavedBundles


 

 

TIP

While hovering each bundle, you can Edit, Duplicate, Download, Delete and Copy a link to it, to use in a content feed when bulk creating visuals.

 

Similar posts

Get notified on new marketing insights

Be the first to know about new B2B SaaS Marketing insights to build or refine your marketing function with the tools and knowledge of today’s industry.