Skip to content
  • There are no suggestions because the search field is empty.

Set Up Product Modifiers

Product modifiers let buyers and sales reps customise a product at the time of ordering — without creating a separate SKU for every possible combination. Modifier options appear on the Product Detail Page (PDP) and the final price updates in real time as each option is selected.

Common uses include frame finishes, bead configurations, hardware types, fabric selections, engraving text, and mounting options.

Platform: WizOrder & WizShop      |      Who is this for: Admins

To Get There: Manage > Import/Export > Modifiers Setup

Note: Product modifiers are configured by admins only, from the web portal.


Before You Begin

  • Ensure you have Admin access before setting up modifiers.
  • Modifiers do not create inventory records. If you need to track stock at the option level, use variants instead.
  • Have your modifier groups, values, and pricing logic ready before starting the import.

A. When to Use Modifiers Instead of Variants

Use this table to decide which approach fits your product:

  Variants Modifiers
Creates a new SKU Yes No
Tracked in inventory Yes No
Best for Simple, pre-defined options with a limited number of combinations, such as a rug available in 3 colors and 3 sizes Complex customization with many possible combinations from a single base product
Example 3 colors × 3 sizes = 9 SKUs A chandelier with 7–8 option groups = 1,000+ combinations from one SKU

B. How Modifiers are Structured

Modifiers follow a three-tier hierarchy:

  1. Modifier Group: The category of customisation, such as Frame Finish or Hardware Type. A single product can have multiple modifier groups.
  2. Modifier Values: The individual choices within a group, such as Brass, Chrome, or Matte Black under Frame Finish. Each option carries its own price adjustment.
  3. Price Adjustment: The amount added to or subtracted from the base product price when a specific option is selected.

The final line price is calculated as:

Base Product Price + Sum of All Selected Modifier Option Adjustments = Order Line Total

Note: When a modifier group allows multiple selections, you can control how the price adjustment is calculated. SUM adds all selected values together, MAX uses only the highest, MIN uses only the lowest, and AVG uses the average. For single-select groups, only SUM applies. You can also add a percentage margin on top — SUM(20), for example, totals all selected values and adds a 20% margin before applying it to the base price.



C. Display Types for Modifier Options

Display types control how modifier options appear to the buyer on the PDP. Available display types depend on the modifier type selected.

For Single Select modifiers:
  1. Chip: Small selectable buttons arranged in a row. Use for short lists of text-based choices, such as Small, Medium, or Large.
  2. Dropdown: A single-select dropdown menu. Use when the option list is long and screen space is limited.
  3. Radio Button: A vertical list of options with a radio button beside each. Use when you want each option clearly laid out and only one can be chosen at a time.
  4. Swatch: Image-based selection tiles showing visual previews, such as fabric swatches or material textures. Each option includes a thumbnail image.
For Multi-Select modifiers:
  1. Swatch: Image-based selection tiles. Multiple tiles can be selected simultaneously.
  2. Dropdown: A multi-select dropdown. Buyers can select more than one value from the list.
For Counter modifiers:
  1. Counter: A numeric input field with increment and decrement controls. No other display type applies.

D. Understanding Modifier Sheets

The modifier import file has two sheets to work on — Modifier Definitions (Sheet 1) and Variant & Modifiers Mapping (Sheet 2).

Modifier Definitions (Sheet 1)

This is where you define all modifier groups and their individual options, including pricing, display settings, and any additional configuration.

SPM1

Column Description Example
Modifier ID Unique identifier for the modifier MOD-001
Modifier Name The group name shown on the PDP Hardware Finish
Modifier Type Single Select, Multi Select, Counter, or File Single Select
Modifier Display Type Chip, Dropdown, Radio Button, Swatch, or Counter Swatch
Modifier Pricing Logic SUM, MAX, MIN, AVG — or with margin e.g., SUM(20) SUM
Is Mandatory Yes or No Yes
Min Selection Minimum options required (Multi Select only) 1
Max Selection Maximum options allowed (Multi Select only) 3
Disclaimer Text shown to the buyer before selection Lead time is 5–7 days for this option
Modifier Value An individual option within the group Antique Brass
Modifier Image URL Image URL for Swatch options https://...
Suffix Value Appended to the base SKU for this option -BR
Is Default Option Yes or No; pre-selects this option on the PDP No
Catalog Price Price adjustment for this option per the price list 150.00
File Type Accepted file types (File modifier only) PDF, PNG
Max File Size (MB) Maximum upload size in MB (File modifier only) 10

Variant & Modifiers Mapping (Sheet 2)

This is where you map the modifiers you defined in Sheet 1 to the products they should appear on, using the product's Grouping Identifier.

Column Description Example
Parent ID The product's Grouping Identifier GRP-001
Modifier 1–5 ID Modifier IDs to assign to this product MOD-001

E. Set Up Modifiers in Bulk

For products with many modifier groups, or when applying the same modifiers across multiple products, use the Excel-based modifier import.

  1. Go to ManageImport/Export.
  2. Select Modifiers Setup from the dropdown, then click Modifier Import Template to download it. This is only required if you are setting up modifiers for the first time. 

    SPM2

    SPM3
  3. Fill in the Modifier Definitions Sheet with your modifier groups and values. Here is an example for a sofa:

    Modifier Group Modifier Type Display Type Options
    Sofa Fabric Choice Single Select Swatch Leather, Linen, Velvet
    Sofa Color Single Select Swatch Red, Brown, Purple
    Sofa Size Single Select Chip 3-Seater, 2-Seater, Loveseat
    Sofa Leg Style Single Select Radio Button Wooden Legs, Metal Legs
    Sofa Materials Single Select  Dropdown Metal, Steel, Wood
    Sofa Cushion Type Single Select Radio Button Memory Foam, Spring, Polyurethane

    You can also add more modifier groups — such as Arm Style, Back Style, Seat Depth, and Custom Engraving — depending on your product requirements.

  4. Once the Modifier Setup sheet is complete, upload it using Import/Export.

     

  5. Download the Variant & Modifiers Mapping sheet. Enter your product's SKU alongside the IDs of the modifier groups you set up in step 3. You can map one product to as many modifiers as needed — for example, the sofa can be connected to all six modifier groups at once. 

    SPM4
  6. Once both sheets are complete, upload them one at a time:
      1. Follow the video below to import the Modifier Setup Sheet.

         

      2. Follow the video below to import the Variant & Modifiers Mapping.

    • When the import is successful, the modifiers automatically appear on the relevant products and are ready for buyers to use.

      SPM5

    F. Set Up Dependent Modifiers

    Some modifier options depend on the buyer's earlier selections. When a buyer selects an option in one group, the next group updates automatically to show only the relevant choices for that selection.

    For example: A buyer may prefer a cushion material not listed in the standard options — such as Memory Foam, Polyurethane, or Spring. If they select Custom Cushion under Cushion Type, a text box appears for them to type in their preferred material. This way, buyers are not limited to available options and can specify exactly what they need.

    How to Add a Dependent Modifier

    1. Create the parent modifier group Cushion Type and add your standard options: Memory Foam, Polyurethane, Spring, and Custom Cushion.
    2. For the Custom Cushion option, create a new Modifier ID (e.g., Sofa Cushion Type 1). Set the Modifier Type to Text and the Modifier Display Type to Text Input. This opens a text box on the PDP for buyers to type in their preferred cushion material.

      SPM6
    3. In the Modifier Definitions Sheet, go to the Dependent Modifier ID column and enter the Modifier ID of the parent group — in this case, Sofa Cushion Type. Under Dependent Modifier Value, enter the specific option that triggers this dependency — in this case, Custom

      SPM7
    4. Go to the Variant & Modifiers Mapping Sheet and map the new Modifier ID to the relevant SKU. 

      SPM8
    5. Once both sheets are complete, upload them one at a time. The changes reflect on the product page once the import is successful.

    Note: Control the character limit for the text box using the Min Selection and Max Selection columns in the Modifier Definitions Sheet. WizCommerce recommends setting the maximum to 250 characters.

    FAQs

    1. Do modifiers affect inventory tracking?

    A. No. Modifiers do not create inventory records. If you need to track stock at the option level, use variants instead.

    2. Can I apply the same modifier group to multiple products?

    A. Yes. Use the Variant & Modifiers Mapping sheet to map the same Modifier ID to as many products as needed. Each product can be connected to multiple modifier groups at once.

    3. What happens if a buyer selects multiple options in a multi-select modifier group?

    A. The price adjustment depends on the pricing logic you set — SUM adds all selected values, MAX uses only the highest, MIN uses only the lowest, and AVG uses the average. You can also add a percentage margin on top using the SUM(n) format.


    Not finding what you need? Browse the WizCommerce Help Center, reach out to your Customer Success Manager, or contact our Support Team.