How To Set Up Modifiers

If your products offer multiple options for your customers to choose from such as fabric style, color, finish, nail trim, etc., then you may want to use RepZio’s modifier function. The process of creating modifier menus is easy once you get the hang of it.

The first step we need to take is to download the two spreadsheet templates that are required to create a modifier menu: The Modifier List and Product Modifiers. The Modifier List is the spreadsheet where you enter the details of your modifiers: menu names, prices, color names, and so on. The Product Modifiers spreadsheet is where you attach the modifiers to your products. Let’s begin with the Modifier List.

We will create one modifier menu for this example: “Choose a Color”.  The “Modifier List Name” column is where we will input the name of the modifier menu:

*image taken from Import Modifier Lists spreadsheet

The Modifier List Key column is where we create the code that we will use later to attach your modifiers to your products. For this example, we will use Color1. The Modifier ItemID column is where you enter your internal SKU/ItemID for that entry; it will be shown in the final ItemID for the product. In this example we use the color red, which we assign R-10 as the Modifier ItemID.

Modifier Item Name” is the actual name of the modifier option that will be shown within the App; in our example, we are offering red as a choice, so we will call it "Red" in the Modifier Item Name column. 

The “Price” column is used to enter pricing data for your modifier options. For example, if your company offered higher-quality finishes or fabric grades that cost more, then that data would be entered in the “Price” column. If a modifier option were to deduct from the overall cost of the product, then you would enter the value like the following example: -30.

The “Photoname” column is where you enter the name of the associated image for the modifier.

Finally, the “IsDeleted” column is where you decide if a modifier will be shown within the app or not: any modifier marked “FALSE” will be shown within the App.

The Product Modifiers spreadsheet is where you connect the modifiers you have created to your products: The “Modifier List Key” column is where you enter the modifier list keys for your modifiers. “ItemID” is where you enter the ItemID of the product that modifier belongs to.

*Image taken from Import Product Modifiers spreadsheet

Now that we have the basic functions of the Modifier List and Product Modifiers spreadsheets covered, let’s create some modifiers! Let’s suppose that you have an armchair that comes in three different colors: Red, Blue, and Yellow: 

*Import Modifier List 

Now let’s assume that you have a sofa with the same color options, and for the sake of clarity, let’s add a loveseat that only comes in two colors:


*Import Modifier List

Since the sofa and the armchair have the same color options, then they would have the same Modifier List Key attached to them. However, since the love seat only has two color options—even if those options are identical to those offered with other furniture—it would still require its own unique Modifier List Key.

This is what the Product Modifier Template will look once completed following the directions above:

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.