Skip to main content

Feed Optimization - Optimizing Product Data

P
Written by Prerna Setia

The tool is currently in beta and available on request. Please contact support@optmyzr.com to request access.

Feed Optimization gives you different ways to change your product data, from a single correction to logic that populates an entire product attribute. This article explains in detail three ways in which you can optimize your product data in the Feed Optimization tool.

Single Cell Edits

You can use inline editing to change the value on one product. Use AI suggestions when you want to help generate the value instead of writing it yourself.

  1. Hover over the cell you want to change. A pencil icon appears on the right of the cell.

  2. Click the icon and an editor opens showing the attribute name and the current value.

  3. Type your new value or use AI to get suggestions.

  4. Click Update to keep the change, or Cancel to discard it.

Once you’ve made the edit, you can:

  • See the original value and option to revert inside the edit dialog. Revert returns the cell to the original value from your source feed.

  • See an i icon on hover of the cell that helps you debug the transformation, telling source and final value

Bulk Edit

To update multiple products' data at once, use the bulk edit option in the tool.

  1. Click Bulk Edit.

  2. Select the products you want to change. Tick individual rows, use the header checkbox for the current page, or click Select All Rows to select every product in the current view.

  3. Choose Set Value or Suggest With AI.

  4. When you are done, click Exit Bulk Mode.

Options under Bulk Edit:

  1. Set Value writes the same value to the same attribute on every selected product.

  2. Suggest With AI writes a different, product-specific value for each selected product, based on an instruction you give it. Describe what you want in plain language — for example: Use xyz attributes to create a detailed description.

Note: AI suggestions can be generated for up to 100 rows at a time for all attributes. For Google Product Category only, you can generate AI suggestions for more than 100 rows at once.

Column Rules and Dynamic Values

A column rule tells Optmyzr how to populate an entire attribute, instead of you editing products one by one. You define what the value is built from, what should be done to it, and which products it applies to. Everything else falls back to a default you set.

Rules are the right choice when you want a fix to hold as your feed changes, because they can be re-applied every time Optmyzr refreshes your published feed.

To open the rules panel, click the gear icon in any column header. The Configure value panel opens on the right.

The panel has four parts, top to bottom:

  1. The AI prompt box"Tell us how you want '[Attribute]' populated". Describe what you want in plain language and Optmyzr builds the rule for you.

  2. Set Column — the value the column is built from.

  3. Column modifications — what to do to that value.

  4. Conditions — which products the rule applies to, plus a Default Mapping for everything else.

You can use the prompt box, or build the rule manually with the controls below it.

Tip: Narrow the table first by clicking an audit on the left or using the row filter. This ensures that your edits and Select All apply only to the products you want to change.

How Column Rules Work

Step 1: Set the Base Value

The Set Column "[Attribute]" = field defines what the value starts as.

  • Type { to insert an attribute from your source feed. For example, {Source.Title} uses the product's existing title.

  • You can combine attributes and static text in the same field.

Click Add modification to change the base value. Choose from:

  1. Append

  2. Prepend

  3. Find And Replace

  4. Convert To Lowercase

  5. Convert To Uppercase

  6. Convert To Titlecase

  7. Custom Formula

You can stack several modifications on one rule; they are applied in the order shown. Use the bin icon on the right of a modification to remove it.

Step 2: Add Conditions

Click Add condition to apply the rule only to specific products. In simple terms, this lets you make modifications only when the conditions you set are met.

Set the following:

  • Attribute — the feed field you want to check, such as Brand, Color, or ID

  • Type — the type of data, such as Text

  • Condition — how to compare the value, such as Is Equal To

  • Value — the value to look for

Use + to add conditions that must all be true. Use Add New OR Condition to add another set of conditions. The rule applies when either set is true.

Example: To add “Sale” to the specific brand products, set Title to {Source.Title} and choose Append with the value Sale. Then add the Brand value in the condition. Only products of the specific brand will have “Sale” added to their titles.

Step 3: Add More Rules

Click Add Another Mapping to add a second rule to the same column, with its own modifications and conditions. Rules are evaluated in order, and the first one a product matches is the one that applies.

Step 4: Set the Default

Expand Default Mapping and fill in Set Column "[Attribute]" =. This is the value used for every product that matches none of your rules.

Note: The default is required. Save is disabled until it has a value.

Step 5: Preview Before You Save

Click Preview at the bottom left. A dialog shows sample products with their final value, and a Matched column telling you which rule produced it — Rule 1, Rule 2, or Fallback for the default.

Click Save, and the values in the product table update to reflect the rule.

Reviewing What You Changed

Turn on Show only edited columns above the table. The table shows only those columns you have touched, leaving just Id and the attributes you edited — a quick way to sanity-check a large batch of changes before publishing.

Turn the toggle off again to bring back the full table.

To learn more about publishing the changes you made, read Feed Optimization - User Guide.

Did this answer your question?