Create and Manage Pricelist 

Price lists control what your customers see and what they pay. Each price list represents a pricing tier — such as Wholesale, Distributor, or VIP- and is assigned directly to customer accounts. Only admins can create and manage price lists in WizCommerce.

A. Create a New Price List

1. From the left navigation, go to Organisational Settings, then open General Settings and click Price Lists.
2. Click +Add new
3. Enter a name for the tier (e.g., "Distributor" or "VIP")
4. Choose a creation method:
   • Manual Entry: Add products and prices one by one using Product Management
   • Import from Spreadsheet: Use import/export with all products and prices at once

B. Edit an Existing Price List

i) Update a Product Price

Use this when you need to update pricing for one or a few products, for example, adjusting the price of a specific SKU after a cost change.

1. From the left navigation, go to Product Tool
2. Locate the product you want to add using the search bar or filters
3. Click on the product to open it and navigate to the Pricing section
4. Click Edit next to the price list tier you want to update. In this example, we'll update the Wholesale tier to $60 and enter the new sales price.
5. Click Save

ii) Add or Remove Products to a Price List

1. From the left navigation, go to the Product tool
2. Locate the product using the search bar or filters
3. Click on the SKU ID of the product (or the edit icon under action column) to open it
4. Navigate to the Pricing section.
5. Find the price list you want to update
6. Toggle the product on to include it in that price list, or toggle it off to remove it

7. To update the price for that tier, click on Edit.

    
   
8. Click Save

C. Bulk Update Price Lists Using Import and Export

Use import and export when you need to make bulk pricing changes across many products at once — faster and more accurate than editing prices one by one.

"Steps to Perform Bulk Price Changes"

1. From the left navigation, go to Manage and click Import/Export. Select the Products tab and click Export. Choose the Price field to export only pricing data.

2. Open the exported file in Excel or Google Sheets. You will find three tabs: Instructions, Sample, and Data Sheet. If this is your first time, read the Instructions tab before making any changes. Navigate to the Data Sheet to make your updates.

   1. The Data Sheet contains the following columns for each price list tier:
      1. [Tier]_Include: Set to Y to make the product active and visible under that price list, or N to hide it from customers on that tier
      2. [Tier]_Base_Price: The standard price for the product on that tier
      3. [Tier]_Sale_Price: An optional sale price. When set, customers on that tier see the sale price instead of the base price
      4. [Tier]_MOQ:  Minimum Order Quantity. The minimum number of units a customer must order for this product
      5. [Tier]_IOQ: Incremental Order Quantity. The quantity increments a customer can order in (for example, an IOQ of 6 means customers can order 6, 12, 18, and so on)
      6. [Tier]_Max Qty: The maximum number of units a customer can order in a single order

3. Once your changes are complete, save the file and go back to Import/Export. Select the Products tab, click Import, and select only the Price field. Upload the updated file. 

Once imported, the system updates prices for all matching SKUs:

• Matched SKUs — Prices are updated immediately
• Unmatched SKUs — Skipped with a warning. Review and correct before re-importing
• Products not in the file — Left unchanged. The import only updates what is included

When to Use Each Method?