BSS B2B Solution
  • 🚀Getting Started
    • App Overview
  • Wholesale Pricing
    • Quantity/Amount Break
      • Set different price for different quantity range
      • Settings for Quantity/Amount Break
      • Display discounted prices
      • Import/Export Quantity/Amount Break rules
    • Custom Pricing
      • Set different prices for Wholesale customers
      • Display Custom Pricing prices
      • Import/Export Custom Pricing rules
    • Price List per Customer
      • Set customized pricing per product per customer
      • Display Custom Pricing prices
      • Import/Export Price List rules
    • More
      • Shipping Rate
        • Set up your Wholesale shipping rate
      • Extra Fees
        • Add fee to your customer's orders
        • Settings for Extra Fee
  • Customer Management
    • Registration Forms
      • Create Wholesale Registration Form
      • Create Multi-step form
      • Publish form to the storefront
      • Manage, approve and notify your customers
      • Email sender settings
      • Import Customers
      • Translate form for cross-border wholesalers
    • Auto Tags Orders/Customers
      • Automatically tag orders and customers
  • Tax
    • Tax Incl/Excl Display
      • Display prices with and without taxes
    • Tax Exempt
      • Tax exempt for eligible customers and orders
  • Order management
    • Manual Orders
      • Create an order in Backend with discounts
      • Edit an order from Backend
    • Order Limits
      • Set minimum or maximum quantity/amount your customer can buy
    • Quantity Increments
      • Make your product buy-able in only increments
    • Orders Custom Fields
      • Allow customers to add custom notes to the orders
    • Net terms
      • Setting up Net terms
      • Email notifications
  • Other modules
    • Discount Code
      • Set Discount Codes on your orders
    • Buy One Get One
      • Set discounted price for a product when buying another product
    • Multi Currency
      • Show prices in different currencies
  • API Integration
    • Public APIs
      • Public APIs for Uploading
      • Public APIs for Quantity Breaks (QB)
      • Public APIs for Custom Pricing (CP)
      • Public APIs for Price List (PL)
      • Public APIs for Registration form (RF)
  • Integration
    • Shopify POS
    • Klaviyo
    • EasyCSV
    • Sufio
    • Order Printer Pro
    • Zapiet Pickup + Delivery
    • Shopify theme
  • Use case & FAQ
    • General
      • Can I get a discount on special cases?
      • Can I get a trial for the app?
      • Can I subscribe to an annual plan?
      • Can I cancel the app at any time?
      • How to uninstall the app and remove the code?
      • Can I request a refund?
      • Can I change my plan?
      • Do you offer free installation and support?
      • What are your supporting hours?
      • Does it cost an extra fee for support?
      • Does our app support all Shopify themes?
      • How to submit a request for additional customization?
      • How can I grant access to our app for BSS Commerce?
      • How to fix display problem in Dashboard?
      • How to see the store's collaborator code
    • Usecases
      • How do Quantity Increment Calculation and Quantity Limit work in your Shopify store?
      • How to calculate the total price when customers are qualified for Custom Pricing and Quantity Break?
      • How can I restrict customers to access the page? After approving, how can I show the custom pricing?
      • How to exempt tax for non-registered VAT customers?
      • Can my customers still use discount codes at checkout?
      • How to limit order quantity/amount and offer tiered pricing with Order Limit and Quantity Break?
      • How to add notes/additional information to Orders created by the B2B/Wholesale Solution app?
      • How to avoid duplicated discount if I create b2c discount rule with another app?
      • How to limit order quantity/amount and set product increment with Order Limit and Quantity Increment
  • Policy
    • Discount policy
Powered by GitBook
On this page
  • Export Custom Pricing rule
  • Step 1: Check your saved Custom Pricing rules
  • Step 2: Export your existing rules
  • Import Custom Pricing rule
  • Step 1: Head to Import/Export CP Rules
  • Step 2: Import file:
  • Step 3: Choose to override existing rules or not

Was this helpful?

  1. Wholesale Pricing
  2. Custom Pricing

Import/Export Custom Pricing rules

Last updated 4 months ago

Was this helpful?

You can automatically create CP rules by using the import/export function on the application. This is helpful when you have many rules that you want to simultaneously upload to your store without making them manually.

Export Custom Pricing rule

Step 1: Check your saved Custom Pricing rules

Step 2: Export your existing rules

From Custom Pricing, head to Import/Export CP Rules, and you can start exporting your rules.

You can locate the Export buttons on the bottom of the page:

Once downloaded, you can open the file and make changes to the rules.

Import Custom Pricing rule

Step 1: Head to Import/Export CP Rules

From Custom Pricing, head to Import/Export CP Rules:

Step 2: Import file:

On the top of the page, you can download a sample file to input all the fields, instead of making a file from scratch.

You can also use the guidelines (next to the Download Sample button) to be informed of what types of input is needed for each row.

Import guideline
  1. A maximum of 400 rules can be imported in one CSV file.

  2. Each CP rule must have a different ID.

  3. status must be one of these values:

    • Enable

    • Disable

  4. apply_to must be one of these values:

    • All

    • Logged-in customers

    • Not logged-in customers

    • Specific customers

    • Customer tags

  5. apply_to_markets must be one of the two values:

    • All markets

    • Specific markets

  6. exclude_from must be one of these values:

    • None

    • Specific customers

    • Custom tags

  7. product_condition_type must be one of these values:

    • All products

    • Specific products

    • Specific variants

    • Product collections

    • Product tags

  8. exc_product_type must be one of these values:

    • None

    • Specific products

    • Specific variants

    • Product tags

    • Product collections

  9. discount_type must be one of these values:

    • Apply a price to selected products

    • Decrease a fixed amount of the original prices of selected products

    • Decrease the original prices of selected products by a percentage

  10. name, apply_to, product_condition_type, exclude_from and discount_type must not be empty

  11. If apply_to is Specific Customers, then customer_emails must not be empty and customer_emails must be separated by a comma ","

  12. customer_emails must already exist in your Shopify store

  13. If apply_to is Customer tags, then customer_tags must not be empty

  14. If product_condition_type is Specific Products, please enter at least one of these fields:

    • product_titles

    • sku

    • barcode

  15. If product_condition_type is Specific variants, please enter at least one of these fields:

    • variant_ids

    • sku

    • barcode

  16. product_titles, sku, barcode, product_tags and product_collections must be separated by a comma ","

  17. If product_condition_type is Product tags, then product_tags must not be empty

  18. If exclude_from is Customer tags, then the exc_customer_tags must not be empty

  19. If exclude_from is Specific customers, then exc_customer_emails must not be empty

  20. exc_customer_emails must already exist in your Shopify store

  21. If exc_product_type is Specific products, please enter at least one of these fields:

    • exc_product_titles

    • exc_sku

    • exc_barcode

  22. If product_condition_type is Specific variants, please enter at least one of these fields:

    • exc_variants_id

    • exc_sku

    • exc_barcode

  23. If exc_product_type is Product tags, then exc_product_tags must not be empty

  24. If exc_product_type is Product collections, then exc_product_collections must not be empty

  25. exc_product_titles, exc_variant_ids, exc_sku, exc_barcode, exc_product_tags and exc_product_collections must be separated by a comma ","

  26. If exc_customer_emails contains more than one email, then separate each email with a comma and a space ", "

  27. If apply_to_markets is Specific markets, then specific_markets must not be empty

  28. specific_markets must already exist in your Shopify store (for example, if you have 2 markets called NA and EU in your Shopify Admin console, you should enter NA and/or EU in specific_markets)

  29. If specific_markets contains more than one market, then separate each market with a comma and a space ", "

  30. If start_date and end_date are to be set, the format in the CSV file must be carefully checked. It should be in the format "mm-dd-yyyy HH:mm:ss"

  31. Import and add rules: Add new rules on top of the existing custom pricing rules.

  32. Import and replace rule: Delete the existing custom pricing rules and replace them with the rules imported through the CSV file

If everything is correct to the guideline, a Success Message should pop up:

Step 3: Choose to override existing rules or not

In case you have existing rules on your store, you can choose if the imported rules should override the existing ones or not.

Import and Add Rules: If you choose this option, the newly imported CP rules will be added to the existing CP rules and displayed in the CP rules grid.

Import and Replace Rules: If you choose this option, existing CP rules will be replaced by the newly imported ones. It means that the old CP rules in your store will be deleted, and only newly imported rules will be displayed in your CP rules section.

If you need further assistance, please feel free to reach us at or .

support-sbc@bsscommerce.com
Live Chat