ChannelEngine: create product bundles in bulk via CSV upload

About this article

This article describes the process involved in the creation of product bundles in bulk, using a CSV file.

Introduction

While it is possible to create individual product bundles step by step via the ChannelEngine web interface, it is also possible to create basic bundles via the upload of a CSV file. If you need to add a lot of product information to your bundles, use an additional feed to enrich them – or manually update them via the regular bundle management on ChannelEngine.

Requirements

The following requirements must be met for you to successfully create new bundles in bulk.

• The CSV must have a comma as separator. Separators such as semicolons, pipes, or tabs cannot be used.
• The CSV must contain the following columns, be it in upper or lower case, with the following headers names. Note that the locations of the headers and their values are fixed. I.e.: Column #1 needs to contain a unique Merchant product number for your bundle, column #2 must contain a unique EAN, etc.
• MPN_BUNDLE - the bundle's unique Merchant product number.
• EAN_BUNDLE - the bundle's unique GTIN/EAN. Note that it cannot yet be known on ChannelEngine.
• NAME_BUNDLE - the bundle's title.
• IMG_LINK - the bundle's main image.
• PRICE - the bundle's price.
• PRODUCT1_MPN - the Merchant product number of the bundle's first product. This product has to be known on ChannelEngine.
• PRODUCT1_QTY - the quantity of your first product you want the bundle to contain.
• PRODUCT2_MPN - the Merchant product number for the bundle's second product. This product also has to be known on ChannelEngine.
• PRODUCT2_QTY - the quantity of your second product you want your bundle to contain.
• and so on.

Process

Once you select the CSV file for upload, it creates a separate task that processes the file. If all goes well, the task is marked as a success. You can see the status of this task on ChannelEngine by going to Settings > Scheduled tasks.

If the processing of the file fails, the task is given the label 'FAILED' – and a notification is shown. Note that you may need to enable Product bundles import failed notifications, under the Product message settings, to receive notifications of this kind. More information on enabling notifications can be found in the article ChannelEngine: how to configure notifications.

The error in the notification should state that a definition cannot be found, which either means that one of your column headers is named incorrectly or the EAN/Merchant product number for the individual parts of the bundle cannot be found. If the error is unclear, please contact ChannelEngine's Support team – and make sure to have your CSV file ready.

Example file

To download an example of CSV template, click here.