Importing bundles using a CSV
If you would like to bulk import bundles into the app, follow the steps below:
1. Create the product in Shopify that you would like to convert to a bundle. You can use the bulk import functionality in Shopify to add the new bundle products. Although variant SKUs are optional, using SKUs will make it easier to build and edit bundles.
2. Navigate to the Bundles page in the Simple Bundles app and click on Import. Export the product variant IDs/SKUs file where you can find the ID/SKUs for all your product variants on your store. You should see the products created in Shopify in Step 1.
3. Use the variant SKUs/IDs file to populate this sample CSV file:
- Add the bundle SKU to bundle_variant_sku column (optionally you can use bundle_variant_id column as well). If you don't have SKUs on the bundle product in Shopify, use the variant IDs from the variant export CSV.
- Add the product variants SKU to bundle_item_variant_sku column (optionally you can use bundle_item_variant_id column as well). If you have multiple product variants in a bundle, create a new line with the same bundle variant ID/SKU and the new bundle item variant ID/SKU. Again, if you don't have SKUs for your product variants, use the Variant ID in the column.
- Add the product variants quantity in each bundles to bundle_item_quantity column. If this is not set, the quantity will default to 1.
- Optionally, you can set the sync_price column to true if you want to enable syncing of prices between the items and the bundle total price. Leave this blank or to false if you don't want to sync the price between the items and the bundle.
- Optionally, you can also set bundle_type column to either Single-price bundle or Separately-priced items if you want to set the bundle type. Leave this blank if you want to default to single-price bundle. If there are multiple types available for a bundle, the first or top-most row for the bundle in the CSV will be selected as the bundle_type.
- Optionally, you can also set bundle_item_price column to the bundle content price in decimal format. E.g. 4.95. This value must be between 0 and the price of the product variant in Shopify. This price will only be used if the bundle_type is a Separately-priced items type or sync_price column to set to true.
- Optionally, you can also set infinite_option_names and infinite_option_values if you are using infinite options bundles. Imports for bundle options are not supported and have to be manually done via the app. However, once the options are configured, you can import products with the corresponding product options keys and values as comma separate fields for multiple keys and values. E.g. if the customer must pick T-Shirt color: Red and T-Shirt size: Small as the options on the bundle, infinite_option_names will be set to T-Shirt color, T-Shirt size and infinite_option_values will be set to Red, Small.
4. Once all columns are populated, save the file as CSV. Make sure to format any ID columns as a number with 0 decimal places. To do this select the column and click on Format. If you are using Google sheets, you can skip this step.
5. Upload the file on the Import page and click on the Import button.
6. Once the import is complete, you will receive an email with the import status and any variant SKUs/IDs that failed to import.
7. If you have Enable automatic inventory sync for bundle quantities enabled, all your bundle inventory should sync automatically after import.
📝 If you would like to edit existing bundles, you can export the bundles and change the required column values or add new products directly to the CSV file. When editing make sure to include existing products in bundles, otherwise the products in the bundle will be overwritten.