Bulk importing bundles
The import feature allows you to bulk import new bundles and edit existing bundles. Follow the steps below or watch the video walkthrough.
💡 Looking for an automatic way to bulk import and edit bundles? Contact our support team to get set up using Google Sheets.
Bulk import new bundles
- Create the product in Shopify that you want to convert into a bundle. Though optional, it's recommended to include variant SKUs for easier bundle creation and editing. Note: The products you assign as new bundles must already exist in Shopify. If they don't, you can use the bulk import functionality in Shopify to create them.
Go to the Bundles tab and select Import. On the import page, export the provided product variant ID/SKU file to find the ID/SKU for all your bundle products and variants.
3. Use the variant SKUs/IDs file to populate the provided sample CSV file.
- In the sample CSV file, add the bundle SKU to the bundle_variant_sku column (or use the bundle_variant_id column). If your bundle product in Shopify doesn't have SKUs, use the variant IDs from the variant export CSV.
- Add the product variants' SKUs to the bundle_item_variant_sku column (or use the bundle_item_variant_id column). For bundles with multiple product variants, create new lines with the same bundle variant ID/SKU and the new bundle item variant ID/SKU. If you don't have SKUs for your product variants, use the Variant ID in the column.
- Set the quantity of each product variant in the bundle by adding it to the bundle_item_quantity column. If not set, the quantity will default to 1.
- Optionally, you can set the sync_price column to "true" if you want to enable price syncing between the items and the bundle's total price. Leave it blank or set to false if you don't want to sync the price.
- Optionally, you can set the bundle_type column to either "simple bundle" or "infinite options bundle" to specify the bundle type. If left blank, the default will be "simple bundle." If there are multiple bundle types available, the first or top-most row for the bundle in the CSV will be selected as the bundle type.
- Optionally, you can set the bundle_discount_percentage between 1 and 99 to apply a discount to the bundle.
Optionally, if using infinite options bundles, set the infinite_option_names and infinite_option_values columns. For multiple options, separate the keys and values with commas. 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.
For example, if the options for the bundle are 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."
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 using Google Sheets, you can skip this step.
5. Upload the file on the Import page and click Import.
6. After the import is complete, you'll receive an email with the import status and any variant SKUs/IDs that failed to import. You can customize the staff notification email recipients from the Preferences page.
7. If you have enabled automatic inventory sync for bundle quantities, your bundle inventory should automatically sync after the import.
Bulk edit existing bundles
If you need to edit existing bundles, you can export the bundles and make changes to the required column values directly to the CSV file. Ensure that existing products in bundles are included to avoid overwriting them.
That's it! With these steps, you can efficiently manage your bundles through bulk import and editing. If you have any questions or need further assistance, please reach out to our support team.