Bulk import lets you create or update many Candy Rack offers at once by uploading a CSV file. It's the fastest way to set up offers across a large catalog, migrate from another upsell tool, or make sweeping changes to existing offers without clicking through each one.
The import feature is currently in beta and handled by our team.
When to use bulk import
Setting up dozens or hundreds of offers in one go
Updating discounts, badges, or product targets across many offers at once
Migrating offers between stores
Preparing offers offline (e.g. in Google Sheets or Excel) before going live
For a handful of offers, the regular offer editor in Candy Rack is faster.
To get started:
Contact our support team to request a valid CSV template
Fill in the file with your upsell data
Send it back to us for review and import
Using the correct template is important, as the structure must match exactly.
Required structure
Your CSV file must:
Use the exact column names and order from the template
Do not rename, remove, or reorder any columns
Use valid values for each field
If the structure is incorrect, the import will fail.
Key fields to check
upsell_products (required)
This field defines which products are offered as upsells.
Format:
product-<product_id>(<variant_id1>,<variant_id2>)
Examples:
product-1234567890
product-1234567890(11111,22222)
product-1234567890;product-9876543210
Important:
You must use Shopify product IDs and variant IDs from your store
Do not use SKUs or IDs from another platform (e.g. WooCommerce)
Variant IDs must belong to the same product
Use a semicolon
;to separate multiple productsMaximum of 10 products per offer
targets (optional)
Defines where the upsell is triggered.
Examples:
product-1234567890
product-1234567890(11111,22222)
product-1234567890;collection-9876543210
placement
Defines where the upsell appears.
Example:
popup
Important:
Available values depend on your store setup
Using an unsupported value will prevent the import from working
Boolean fields
Fields such as:
enabledpreselectedquantity_selector
Must use:
TRUE or FALSE
After you send the file
Once you send the CSV to our team:
We will review the file
Import the offers into your store
If the file contains many offers (e.g. 100+), the import may be processed in multiple batches.
If you are unsure about your CSV file, contact our support team either via chat and we will help review and import it for you.