Editing Single-Line List of Text String Metafields

There are several types of metafield definitions you can create and the Single Line Text (String) Metafields are helpful to store additional information for your products like keywords, or categories for products.

You can use Ablestar Bulk Product Editor to modify these metafields in bulk. Choose if you prefer the 'In-App Edit' or 'Spreadsheet' method:

1. In-App Edits

Once you have Metafields defined for your products, there are several options available to bulk edit your data.

In this example, we are using our 'Material List' single-line text definition that we created previously. From the 'Configure modifications' view, there are several 'How to edit' options available to bulk edit your product vendors:

• Set to new value: Replaces all existing list data with the new value specified.
• Add item to the start of the list: Adds the specified list item to the beginning of the list.
• Add item to the end of the list: Adds the specified list item to the end of the list.
• Remove item(s) from the start of the list: Removes the specified item from the beginning of the list.
• Remove item(s) from the end of the list: Removes the specified item from the end of the list.
• Search and replace: Replaces any specified text, spaces, HTML code or punctuation (considering case syntax). If case syntax doesn't match exactly, nothing will be updated.
• Set from prefixed tags: Extracts the tag portion of any prefixed tag. For example, from the prefixed tag 'Size=XL' only 'XL' would be extracted and added to your list.
• Delete metafield: Removes the value completely.

Some options will allow you to 'Add dynamic value' and pull in other data from your store, instead of manually inputting the term to be replaced. For example, if you want the material name to always match another variant name.

Learn more about Dynamic values here.

2. Spreadsheet Edits

Single Values

Prep your spreadsheet to include new metafield list data to replace existing data, formatted as:

For a spreadsheet edit you need to specify an identifier in the first column and the action items in the 2nd and subsequent columns, similar to:

• An identifier column (SKU, Handle, Product ID, etc.)
• An action column that contains the text you want to change

Multiple Values

For multiple values in the list column, there are three formats you can use:

• JSON Format: no spacing required around punctuation formatted as: ["Leather upper", "EVA", "Rubber"]
• Comma-separated: with spacing Leather upper, EVA, Rubber
• Pipe-separated: with spacing Leather upper | EVA | Rubber

Click the related article to see more advanced spreadsheet detail.

✅ Tips and Troubleshooting

• Confirm metafield definitions are created before bulk editing. If you do not see the metafields in the app refresh the data in Settings → Shopify data.
• Skipping unchanged rows is a great way to increase the speed of the upload if your spreadsheet data has a lot of unchanged rows

(04.266)