dipp | A centralized hub for your CreativeOps | Help Center

Efficiently automate product bundle creation with a spreadsheet

Written by Mikhail Abramov | Apr 2, 2024 5:57:29 AM

Creating product bundles can often feel like a time-consuming task, especially when dealing with multiple products and layouts. But what if you could simplify the process using just a spreadsheet? In this guide, we’ll walk you through a streamlined method to generate consistent and professional-looking product bundles efficiently. With a few easy steps and the right tools, you can save time and ensure your visuals are ready to make an impact.

Goal: Create product bundles

 

 

 

 

 

Step 1: Download & open bundle CSV template

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

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. 

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.

 

 

 

 

  • 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.

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

  • Adjust spacing as needed and Save bundles as image assets