Importing Bundles

Bundles are two or more items sold together. Creating a bundle allows you to group items that are exclusively sold together or group items that can be purchased together and separately.

This document covers the process of adding multiple bundles via CSV import. You can also add a single bundle.

​

CSV File Guidelines

You can import bundles using CSV files only; no other data or file formats are supported. Here are the key points to consider:

• Formulas in formula-driven attributes are executed automatically after bundles have been imported.
• If the CSV file doesn’t have an attribute that’s added to the category, you can add a new column in the CSV with the attribute name in the header. The upload process will populate the value for this attribute. Note that empty rows and columns are ignored.
• Each bundle should include a category node. If the category node is missing, the bundle won’t be created.
• Use the - > delimiter for category nodes. Incorrect mapping or absence of category nodes may result in bundle creation issues.
• The headers, represented in the first row of the CSV file, should match the attributes of the bundle. While attribute titles aren’t case-sensitive, maintaining case consistency with the original attribute titles is recommended.
• Empty rows and columns are ignored.
• When updating or upserting bundles, entering “NULL” in a spreadsheet cell will override existing values with blank values.
• The ActionTarget field determines what action is being taken for that row of data.

We recommend that you download the template file to use as a guide when creating your own CSV file for import to minimize errors during the import process.

​

Supported actions

• UPSERT: Creates a new bundle if the bundle doesn’t exist, or it updates an existing bundle.
• CREATE: Creates a new bundle.
• UPDATE: Updates existing bundle.
• PUBLISH: Publishes an existing bundle that was in draft state. The bundle is published to the storefront.
• UNPUBLISH_KEEP_DRAFT: Unpublishes an existing bundle. If the bundle already has a draft version, the live version is unpublished and discarded. If bundle doesn’t already have a draft version, the live version is unpublished and saved as a draft.
• UNPUBLISH_KEEP_LIVE: Unpublishes an existing bundle. If the product already has a draft version, the draft version is discarded.
• DELETE: Deletes the existing bundle.
• ATTACH_BUNDLE_PRODUCTS: Adds products to an existing bundle. The items column holds the bundle product’s SKU and quantity to be detached from the bundle SKU.
• DETACH_BUNDLE_PRODUCTS: Detaches products from existing bundles. The items column holds the bundle product’s SKU and quantity to be detached from the bundle SKU.
• CHANGE_CATEGORY: Updates the category of an existing bundle.
• ATTACH_CHANNELS: Appends listed channels to the bundle. The channels column holds the columns to be attached.
• DETACH_CHANNELS: Removes listed channels from the bundle. The channels column holds the columns to be attached.

​

Attribute data format

When preparing your CSV file for import, ensure that the attribute data format aligns with attribute type requirements. Different attribute types have specific formatting criteria:

• Text: Ensure the data is in text string format.
• Number: Only numerical data is imported; other data is ignored.
• Boolean: Use “TRUE” or “FALSE” only; other values will be ignored.
• Date: Format dates exactly as during attribute creation.
• List of values: Values must be an exact match to one of the list values.
• Serial: Leave this field blank.
• SKU: Must be provided for the bundle to be created.

The status attribute is imported as live only when all mandatory attributes are provided for the bundle. Otherwise, the status is automatically updated to draft, regardless of the value you provide in the file.

​

Prerequisites

Before initiating the bundle import, ensure that:

• You have created at least one leaf category with attributes assigned to it to add the bundle to. For more information about creating categories, see the Categories section.
• The CSV file adheres to the guidelines.

​

Procedure

1. In the left menu, click Product Catalog > List > Bundles.
   The Bundles page is displayed.

2. Click Import.
   The Select a leaf category window is displayed.

3. Select a Leaf.
   The root categories and leaf categories appear as they’re set up in Categories. Depending on your configuration, you may have to select one or more root categories before selecting a leaf category.

4. Click Next.
   The Import CSV file window is displayed. This window provides a link to download an example template for the CSV file.

5. To import a CSV file, do one of the following options:

   • Drag and drop the CSV file into the window.
   • Click Select a File from your computer.

6. Click Import file.

The CSV file is imported, and the bundles are added to your product list.

fabric stores the CSV files you upload to your account. You can view the status of the import and re-download the original files by visiting the Import History page.

​

Troubleshooting

Refer to the following table for a list of common errors when importing and how to correct them.

​

Related Topics

• Bundles Overview
• Adding a Bundle
• Viewing Bundle Import History
• Editing a Bundle
• Searching, Filtering, and Sorting Bundles