Import bundles in bulk to Simple Bundles 2.0 with CSV

The import feature allows you to bulk import new bundles and edit existing bundles. Follow the steps below or watch the video walkthrough.

• Bulk import new bundles
• Bulk edit existing bundles
• File size and trimming your CSV
• Google sheets automatic bulk import

Bulk import new bundles

1. 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.

2. 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.

• 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. Good news—bundle options no longer need to be manually configured in the app beforehand. When you import your bundles via CSV, the app will now automatically create the option groups within each bundle using the values you provide.

  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."

Optional fields

• 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.

4. Once all columns are populated, save the file as CSV.

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 in 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. More information here: Bulk edit, create, and delete bundles in Simple Bundles 2.0

File size and trimming your CSV

• bundle_variant_sku     (or bundle_variant_id    )
• bundle_item_variant_sku     (or bundle_item_variant_id    )
• bundle_item_quantity    
• infinite_option_names     and infinite_option_values    (Infinite Options Bundles only)
• bundle_type    , sync_price   , and bundle_discount_percentage    (only if you want these set)

Google Sheets automatic bulk import

Instead of manually uploading a CSV each time, you can connect a published Google Sheet so Simple Bundles automatically pulls in your latest bundle data once a day. Contact our support team with your published sheet link to get this set up. See steps below.

1. Set up your sheet using the same columns covered in "Bulk import new bundles" above. the automatic import reads the same format as a manual CSV upload.
2. In Google Sheets, go to File → Share → Publish to web.
3. In the dialog, select the specific sheet tab you want to publish (or "Entire Document"), then change the format from "Web page" to CSV.
4. Click Publish. Google will generate a public link that ends in something like .../pub?gid=0&single=true&output=csv  
5. Copy that link and send it to our support team. We'll register it on our end so the app can fetch your sheet automatically.
6. Once connected, your sheet is polled once daily (around 12 AM UTC) and your bundle data updates automatically.

If you make changes to your sheet, they'll be picked up on the next daily sync. If you need an update to apply sooner, you can still do a manual import by uploading the CSV file.

Note: If you're technical or have a developer on hand, our Simple Bundles API may be a better fit than the Google Sheets route. It lets you create or update bundles programmatically, without needing a published sheet or waiting on our daily sync. Available on Simple Bundles 2.0, paid plans only.