📚 Product Modifiers

If your products offer multiple options for customers—such as fabric style, color, finish, nail trim, etc.—you’ll want to use RepZio’s product modifier functionality. Creating modifier menus is simple once you get the hang of it.

🎥 Product Modifiers Video Tutorial

👉 Due to the complex nature of product modifiers, we recommend watching our Product Modifier Tutorial first.

🔧 What You'll Need

To work with modifiers, you’ll use two additional spreadsheets:

• Modifier Lists (upload first) – Defines the dropdown options that will appear for selected products (e.g., Color, Fabric, Size).

• Product Modifiers (upload second) – Links the modifier menus to the appropriate products.

🔹 Note: Your main product must already be in the system before starting this process. If it isn't, you'll need to use the Import Products template as well.

📥 Download the ANDMORE Data Templates

To ensure you’re using the most current template versions, download the file from:
WebManager > Manage Data > Download Data Templates.

📘 Modifier List Spreadsheet Headers

Each column in the Modifier List spreadsheet serves a specific purpose:

• Modifier List Name – The name of the modifier menu (e.g., Choose a Color).

• Modifier List Key – A code that links the modifier to products later (e.g., Color1). This is used in the Product Modifiers spreadsheet.

• Modifier ItemID – Your internal SKU/ItemID for each option (e.g., R-10 for a red swatch). This value appears in the final ItemID.

• Modifier Item Name – The customer-facing name of the option (e.g., Red). This is what users will see in the app.

• Price – Enter any price adjustments here. For example, if a finish adds $30, enter 30. To reduce the price, enter a negative value (e.g., -30).

• PhotoName – The name of the image file associated with the modifier. If it doesn’t match the Modifier ItemID, specify the correct image name here.

• IsDeleted – Controls visibility in the app. This field is required:

  • Enter FALSE to show the modifier.

  • Enter TRUE to hide it.

📘 Product Modifiers Spreadsheet Headers

Each column in the Product Modifiers spreadsheet is defined as follows:

• ModifierListKey – Links the modifier to the product’s ItemID/SKU.

• SortOrder – Determines the display order of modifiers.

• IsDeleted – Required on every row:

  • Enter FALSE to display the modifier.

  • Enter TRUE to hide it.

🧩 Example Scenario

Let’s say you have the following furniture:

• An armchair available in Red, Blue, and Yellow

• A sofa with the same three color options

• A loveseat available in only Red and Blue

Here’s how to handle that:

• The armchair and sofa can share the same Modifier List Key (e.g., Color1) since they have identical options.

• The loveseat will require its own unique Modifier List Key (e.g., Color2), even if the color names are the same, because the available choices differ.

📄 Below is an example of what the Modifier List spreadsheet might look like once completed.

📄 Below is an example of what the Product Modifiers spreadsheet might look like once completed.

⬆️ Uploading to WebManager

Once your spreadsheets are complete:

1. Log in to WebManager

2. In the left navigation, go to Manage Data > Upload Data Sheets

3. Upload your files in this order:

   • Select Modifier Lists, upload your spreadsheet, and confirm

   • Select Product Modifiers, upload your spreadsheet, and confirm

4. Click My Data Looks Good

5. Click Push Data Live

✅ Verifying Your Modifiers

To confirm everything loaded correctly:

• Search for the product in WebManager and review the Item Display section

• Open the product in the RepZio iOS App on iPad to view the modifier menu

❓ FREQUENTLY ASKED QUESTIONS (FAQS)

Q. Why aren’t my modifiers showing up?
A. Ensure that you’ve synced your iPad after uploading your data. Additionally, double-check the Modifier List Key in your Product Modifiers spreadsheet—typos, extra spaces, or incorrect formatting can prevent modifiers from appearing.

🔹 Note: Modifiers are visible in the RepZio iOS App for iPad, B2B Direct, and the RepZio Web App. They are not supported on the iPhone version of the app.

Q. How many modifiers can I assign to a product?
A. There is no hard limit on the number of modifiers you can assign to a product. However, keep in mind that assigning a large number of modifiers can complicate both the setup process and the user experience when adding items to orders.

Q. How many options can each modifier menu have?
A. There is no limit—you can include as many options as needed within each modifier menu.

Q. Are there alternatives to modifiers that are easier to set up?
A. Yes. Depending on your needs, you may want to explore the following alternatives:

• Parent/Child Items – Ideal for variations like size or color.

• Related Items – Useful for suggesting add-ons or accessories.