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
      • Set up Wholesale Registration Form
      • Set up 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
      • Set 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 Price List rule
  • Step 1: Check your saved Price List rules
  • Step 2: Export your existing rules
  • Import Custom Pricing rule
  • Step 1: Head to Import/Export PL Rules
  • Step 2: Download sample file:
  • Step 3: Choose to override existing rules or not

Was this helpful?

  1. Wholesale Pricing
  2. Price List per Customer

Import/Export Price List rules

Last updated 5 months ago

Was this helpful?

You can automatically create Price List 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 Price List rule

Step 1: Check your saved Price List rules

Step 2: Export your existing rules

From Custom Pricing, head to Import/Export PL 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 PL Rules

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

Step 2: Download sample 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. status must be one of these values:

    • Enable

    • Disable

  2. apply_to must be one of these values:

    • All

    • Logged-in customers

    • Not logged-in customers

    • Specific customers

    • Customer tags

  3. exclude_from must be one of these values:

    • None

    • Specific customers

    • Customer tags

  4. exc_product_type must be one of these values:

    • None

    • Specific variants

  5. apply_at must be one of these values:

    • Product level

    • Variant level

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

  7. id, name, apply_to, product_titles, exclude_from and discount_type must not be empty

  8. If apply_to is Specific Customers, then the customer_emails must not be empty

  9. customer_emails must already exist in your Shopify store

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

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

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

  13. exc_customer_emails must already exist in your Shopify store

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

  15. If apply_at is Product level, then product_titles or SKU or BARCODE must not be empty. If you enter one of these 3 fields, it will be checked as product information.

  16. If apply_at is Variant level, then variant_ids or SKU or BARCODE must not be empty. If you enter one of these 3 fields, it will be checked as variant information.

  17. If exc_product_type is Specific variants, then exc_variant_ids or exc_sku or exc_barcode must not be empty.

  18. if product_titles, variant_ids, SKU, and BARCODE contain more than one item, then separate them with a comma and a space ", ".

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

  20. Import and Add Rules: Add new rules the existing PL rules

  21. Import and Replace Rules: Replace existing PL rules with imported rules from 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 Price List rules will be added to the existing Price List rules and displayed in the Price List rules grid.

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

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

support-sbc@bsscommerce.com
Live Chat