Articles on: Pareto - Quantity Breaks

Import offers

Import Campaigns Using CSV

Use Import Campaigns to bulk create discount campaigns in Pareto by uploading a CSV file. This allows you to quickly create Quantity Breaks or One Discount campaigns without manual setup.


Step 1: Choose the import type

  1. Open Pareto – Quantity Breaks in your Shopify admin
  2. Go to Offers
  3. Click Import
  4. Select one of the following options:



Option A: Quantity breaks

Choose this option if your campaign has:

  • Tiered quantity rules (Buy 2+, Buy 5+, Buy 10+)
  • Multiple discount tiers under the same campaign
  • Free gifts triggered by quantity

Option B: One discount

Choose this option if your campaign has:

  • One main discount logic
  • Additional order-level discounts
  • Additional cross-sell discounts
  • Additional free shipping or free gift offers
Choose the import type that matches your campaign structure. The CSV template format is different for each type.


Step 2: Download the correct CSV template

  1. Click Download sample CSV for the selected import type
  2. Open the file using Google Sheets, Excel, or Numbers
  3. Do not rename or remove any column headers
Each template contains required fields and optional fields. Invalid or missing columns will cause import errors.


Step 3: Fill in campaign data in the CSV

General rules for all CSV files

  • For Quantity Breaks, multiple rows can share the same campaign_name
  • IDs must be numeric and comma separated
  • Do not leave required fields empty
  • Do not add extra columns


Step 4: Fill in Quantity Breaks CSV fields

4.1 Campaign identification

  • campaign_name

The campaign name shown in the app.

Use the same name for all tiers of one campaign.

  • campaign_type

Values:

    • buy_x_discount_y
    • quantity_break_amount


4.2 Product targeting

  • product_assign

Determines which products the campaign applies to:

    • 0 – All products
    • 1 – Specific variants (use variant_ids)
    • 2 – Specific collections (use collection_ids)
    • 3 – Specific products (use product_ids)
  • product_ids / collection_ids / variant_ids

Enter IDs based on the product_assign value.

Use comma-separated values only.

  • product_exclude

Variant IDs to exclude from the campaign.

  • all_product_rule

Defines how quantity is calculated:

    • all_product
    • each_product
    • each_variant
    • each_collection


4.3 Customer targeting

  • customer_assign

Controls which customers can see the discount:

    • 0 – All visitors
    • 1 – Logged-in customers with tag
    • 2 – Logged-in customers
    • 3 – Customers without tag
    • 4 – D2C customers (exclude B2B)
    • 5 – Logged-in B2B customers
  • customer_tag

Required when customer_assign is 1 or 3.

  • selected_countries

Target countries using ISO country codes (comma separated).


4.4 Discount rules

  • rule_buy_from

Minimum quantity required to trigger the rule.

  • rule_discount_value

Discount amount (numbers only).

  • rule_discount_unit
    • percent
    • price
    • fixed
  • rule_discount_type
    • per_item
    • total_order
    • free_gift
  • rule_product_get

Required when rule_discount_type is free_gift.

Format: variant_id:quantity


Step 5: Fill in One Discount CSV fields

5.1 Campaign basics

  • campaign_name

Unique name for the campaign.

  • product_assign

Same values as Quantity Breaks.

  • product_ids / collection_ids / variant_ids

Required based on product_assign.


5.2 Discount conditions

  • all_product_rule

Defines how quantity is calculated.

  • buy_from

Minimum quantity required.

  • discount_value

Discount amount.

  • discount_unit
    • default
    • percent
    • price
    • fixed
  • badge

Optional badge text shown on storefront.


5.3 Advanced discount options

  • Free gifts

Use free_gift_products

Format: variant_id:quantity

  • Cross-sell discounts

Use cross_products

Format: variant_id:min:max

  • Free shipping

Use free_shipping_option:

    • no_free_shipping
    • all_country
    • selected_country


Step 6: Upload the CSV file

  1. Return to the Import campaigns screen
  2. Drag and drop your CSV file or click to upload
  3. Click Upload and preview


Step 7: Review and confirm import

  1. Review detected campaigns and rules
  2. Fix any validation errors shown
  3. Click Confirm import


Step 8: Wait for import to complete

  • You can import up to 100 rules per import
  • Do not close or refresh the app while importing
  • Import may take several minutes depending on file size
The import will complete automatically once all campaigns are processed.


Step 9: Activate imported campaigns

  1. Imported campaigns are created as Inactive
  2. Open each campaign to review settings
  3. Click Activate when ready


Import limits and supported offer types

  • Maximum 100 rules per import
  • Only Quantity Breaks and One Discount campaigns are supported via CSV

If you need to:

  • Import other offer types
  • Import more than 100 rules at once
  • Migrate a large number of campaigns from another app

πŸ‘‰ Please contact support. Our team can help with assisted imports or custom migrations.


FAQ

Can I import more than 100 rules at once?

No. Each import supports up to 100 rules.

For larger imports, contact support for assistance.


Can I import other offer types?

Currently, CSV import supports only Quantity Breaks and One Discount campaigns.

For other offer types, please contact support.


Will imported campaigns be active automatically?

No. All imported campaigns are created as Inactive so you can review them safely before activation.


Can I leave the app while importing?

No. Please keep the app open until the import completes successfully.


What happens if I import overlapping campaigns?

Imported campaigns do not override existing active campaigns.

If multiple campaigns target the same products, Shopify discount combination rules apply.

Troubleshooting

Import fails or stops unexpectedly

  • Make sure the app remains open during import
  • Check that the CSV file is under the 100-rule limit
  • Retry the import with a smaller batch
  • Make sure the product information is correct


Campaign imported but discount does not apply

  • Confirm the campaign status is Active
  • Verify products, variants, or collections still exist
  • Check for conflicting discounts in checkout


CSV upload shows validation errors

  • Ensure required fields are not empty
  • Confirm IDs are numeric and comma separated
  • Make sure product assignment matches the correct ID column


Quantity tiers or discounts look incorrect

  • Review all_product_rule and quantity fields
  • Check discount unit and discount type values
  • Edit the campaign manually if fine-tuning is needed


Best practices

  • Import campaigns in small batches
  • Test discounts on a single product before activating
  • Avoid overlapping discounts on the same products
  • Keep CSV backups of successful imports



Updated on: 28/01/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!