Importing and exporting wholesale pricing
Bulk manage pricing rules and volume tiers using CSV files.
Exporting your pricing data
CSV format
type — Either "rule" (pricing rule) or "tier" (volume tier).group_name — The customer group name.group_tag — The Shopify tag for the group.scope — store, collection, product, or variant.scope_id — The Shopify ID of the target (blank for store scope).scope_label — A human-readable label for the target.discount_type — percentage, fixed_amount, or fixed_price.discount_value — The discount value.min_qty — Minimum quantity (required for tiers, optional for rules).max_qty — Maximum quantity (optional).priority — Priority number.starts_at — Start date in ISO format (optional).ends_at — End date in ISO format (optional).Importing pricing data
Append mode — Adds the imported rules and tiers to your existing configuration. Existing rules are not modified or deleted. Use this when adding new pricing to your current setup.
Replace mode — Deletes all existing pricing rules and volume tiers, then imports the CSV data as the new configuration. Use this when you want to completely replace your pricing structure.
Import results
Created — The number of rules and tiers successfully imported.
Skipped — Rows that were skipped (e.g. duplicates in append mode).
Errors — Rows that failed to import, with error messages explaining why (e.g. invalid scope, missing required field, unknown group name). Review and fix any errors, then re-import the corrected rows.
Common errors and fixes
"Invalid scope" — The scope value must be exactly one of: store, collection, product, or variant.
"Invalid discount type" — Must be exactly: percentage, fixed_amount, or fixed_price.
"Missing min_qty" — Volume tiers require a min_qty value. Pricing rules can leave it blank.
"Scope ID not found" — The Shopify product, collection, or variant ID doesn't exist. Verify the ID in your Shopify admin.
FAQs
More in Wholesale & B2B
- Getting started with wholesale & B2B pricing
An overview of ShipWave's wholesale system and how to activate it for your store.
- Creating and managing customer groups
Organize your wholesale customers into groups with different pricing, limits, and payment terms.
- Setting up pricing rules
Override default group discounts for specific products, collections, or variants.
- Configuring volume (quantity break) pricing
Offer bigger discounts for larger orders with automatic quantity-based pricing tiers.
- Managing wholesale applications
Review, approve, and manage applications from potential wholesale customers.
- Adding wholesale blocks to your Shopify theme
Install the signup form, volume pricing table, quick order form, and more on your storefront.
- Setting up wholesale shipping rules
Offer free shipping, flat rates, or discounted shipping for your wholesale customer groups.
- Using net terms for wholesale customers
Offer deferred payment terms and track invoices with automated reminders.
- Creating wholesale draft orders
Create orders on behalf of wholesale customers with automatic discount application.
- Testing wholesale pricing with test mode
Safely verify your wholesale configuration before rolling it out to real customers.
- Migrating from legacy wholesale tiers to v2
Upgrade from ShipWave's original four-category system to the full multi-group pricing engine.