Import bundles in bulk to Simple Bundles 1.0 with CSV
This article applies to Simple Bundles 1.0. If you're using Simple Bundles 2.0, refer to Import bundles in bulk to Simple Bundles 2.0 with CSV.
To import bundles in bulk to Simple Bundles 1.0, fill in the sample CSV file with your bundle and item variant SKUs or IDs, then upload it on the Import bundles page. When the import is complete, you get an email with the import status and any variant SKUs or IDs that failed to import.
Bulk import is available on paid plans. Having trouble with your file? See FAQ: Importing bundles using CSV (troubleshooting) for common errors, required columns, and Excel fixes.
Step 1: Create the bundle products in Shopify
Step 2: Export your product variant IDs and SKUs
Step 3: Fill in the bundle import CSV
Step 5: Check the import results
How do I edit existing bundles with a CSV?
Step 1: Create the bundle products in Shopify
Create the products in Shopify that you want to turn into bundles. You can use Shopify's product CSV import to add them in bulk. Variant SKUs are optional, but SKUs make it easier to build and edit bundles.
Step 2: Export your product variant IDs and SKUs
- In Simple Bundles, go to Bundles v1.0 and click Import.
- Click Export product variant IDs/SKUs. The file is emailed to your staff notification recipients. It lists the IDs and SKUs for all product variants in your store, including the products you created in Step 1.
Step 3: Fill in the bundle import CSV
Use the variant IDs/SKUs file to fill in this sample CSV file. You can also download it from the Import page with Sample file for import. Each row is one item in a bundle, so a bundle with three items takes three rows.
Required columns
- Add the bundle variant SKU to the bundle_variant_sku column, or its ID to bundle_variant_id. If the bundle product doesn't have SKUs in Shopify, use the variant ID from the variant export.
- Add the SKU of the product variant inside the bundle to bundle_item_variant_sku, or its ID to bundle_item_variant_id. For each additional item, add a new row with the same bundle variant SKU or ID and the new item's SKU or ID.
- Add how many units of the item are in the bundle to bundle_item_quantity. If it's blank, the quantity defaults to 1.
Optional columns
- To set the bundle type, enter Single-price bundle or Infinite options bundle in bundle_type. Leave it blank to default to Single-price bundle. If a bundle's rows have different types, the first (top-most) row for that bundle sets the type. The importer still accepts Separately-priced items, but that type is deprecated and we don't recommend it.
- Set sync_price to true to sync the bundle price with the prices of the items in it. Leave it blank or set it to false to keep price sync off.
- Use bundle_item_price to give an item its own price inside the bundle when price sync is on. The price must be lower than the item's regular variant price. If it's blank, or equal to or higher than the variant price, the regular variant price is used.
Infinite options bundle columns
For infinite options bundles, fill in infinite_option_names and infinite_option_values on each item row. You don't need to set up the options in the app first. The import creates the option groups in each bundle from the values you provide.
For items linked to more than one option, enter the option names and values as comma-separated lists in the same order. For example, if a customer selects T-Shirt color: Red and T-Shirt size: Small, set infinite_option_names to "T-Shirt color, T-Shirt size" and infinite_option_values to "Red, Small".
Note: Automatic option mapping won't apply to bundles that already use combined option groups (for example, a single option like "Color / Size").
Step 4: Upload the CSV file
- Save the file as CSV. If you use Excel, format the ID columns as Number with 0 decimal places first, so long IDs don't turn into scientific notation. If you use Google Sheets, skip this step.
- On the Import bundles page, upload the file under Upload CSV file and click Import. The file must be under 5 MB.
Step 5: Check the import results
When the import is complete, you get an email with the import status. It lists any bundle SKUs or IDs that weren't found in Shopify (those bundles aren't created) and any item SKUs or IDs that weren't found.
To change who gets this email, see Edit app notification email recipients.
If Enable automatic inventory sync for bundle quantities is turned on, your bundle inventory syncs automatically after the import.
How do I edit existing bundles with a CSV?
Export your bundles, change the values or add rows in the CSV file, then import it again.
Note: Importing a bundle replaces all of its items with the rows in your file. Include every item you want to keep in each bundle, or the missing items are removed.
The export lists custom item prices in the custom_bundle_item_variant_price column. Copy them into a bundle_item_price column before you import, or those item prices are cleared.
Related articles
FAQ: Importing bundles using CSV (troubleshooting)
How to bulk export bundle data