Articles on: Shopify

Custom Text Formatting in Matching Column (Step 2)

To add custom text to the beginning or end of any field in the mapping section, see the instructions below.


Once use the curly brackets and commas in the mapping section, multi-columns, and labels will no longer be supported.


  1. Custom text can be added to the mapping section alongside the column field name, and the tag can be double-clicked to edit.



Example of custom text in the Description Field:



Result showing in Online Store:


{{Description}}

Ingredient:{{ingredient}}

Weight:{{weight}}(ml)




  1. Use a custom text format to include HTML links in the description.


Example of custom text in the Description Field with HTML:



Result showing in Online Store:


<a href = {{Description}} target =_blank> {{Description}}</a>



All the description values become a link, which is clickable when set as this. 



  1. To format the XML node as a table, refer to the example below:


Example of XML file node:



You should map it as this in Description field to get the table format:



<div>{{description}}</div>
<table>
<tr>
<td>{{./features/feature[1]/name}}</td>
<td>{{./features/feature[1]/value}}</td>
</tr>

<tr>
<td>{{./features/feature[2]/name}}</td>
<td>{{./features/feature[2]/value}}</td>
</tr>

<tr>
<td>{{./features/feature[3]/name}}</td>
<td>{{./features/feature[3]/value}}</td>
</tr>

<tr>
<td>{{./features/feature[4]/name}}</td>
<td>{{./features/feature[4]/value}}</td>
</tr>

<tr>
<td>{{./features/feature[5]/name}}</td>
<td>{{./features/feature[5]/value}}</td>
</tr>
</table>


Result showing in Online Store:




  1. To format the description as bullet points.


Example of file:



You should map it as this in Description field to get the bullet format:



<ul>
<li>Length: {{Length}}cm</li>
<li>Weight: {{Weight}}kg</li>
<li>Height: {{Height}}cm</li>
</ul>


Result showing in Online Store:




  1. Enclose custom text containing commas in quotation "" marks.


Example in Description Field:




  1. It's only supported in Shopify store. If the Shopify store's description is empty, it will be updated; otherwise, the existing value will be retained. This logic applies to all fields.


Example in Description Field:


{{ product.descriptionHtml | default: data.desc}}




  1. It's supported in Shopify store. You can create dynamic date and time formatting in metafield (custom data) with your feed file data. Learn more about the dynamic value. For non-CSV files, use column index; for CSV files, use column name.


Example in Metafield (Custom data) Field:


{{ data[2] | add_day_to_date:%d.%m.%y %H:%M, data[1] }}



  1. It's supported in Shopify store. You can create dynamic mappings by combining Shopify product attributes with data from your feed file.


Shopify ID: {{product.id}} - Description: {{data[2]}}




This feature can be used in the field mapping of


Shopify

WooCommerce

BigCommerce

Wix

✔️ Description

✔️ Tag

✔️ Product Image

✔️ Product Image

✔️ Vendor

✔️ Weight

✔️ Weight

✔️ Weight

✔️ Title

✔️ Description

✔️ Description

✔️ Description

✔️ SKU

✔️ Product Image

✔️ Vendor

✔️ Title

✔️ SEO Page Title

✔️ Stock Status

✔️ Title

✔️ Ribbon

✔️ SEO Meta Description

✔️ Title

✔️ Custom Field

✔️ Brand

✔️ Barcode

✔️ Variant Option

✔️ MPN

✔️ Collection

✔️ Inventory Policy

✔️ Metadata

✔️ Bin Picking Number

✔️ Variant Option

✔️ Metafield

✔️ Width

✔️ Variant Option

✔️ Product Category

✔️ Height

✔️ Brand

✔️ Product Type

✔️ Length

✔️ Category

✔️ Publish

✔️ Category

✔️ Availability Description

✔️ Shipping (Physical)

✔️ Product Attribute

✔️ SKU

✔️ Tags

✔️ Preorder Message

✔️ Taxable

✔️ Preorder Date

✔️ Theme template

✔️ Purchasability

✔️ Weight

✔️ Barcode

✔️ URL & Handle

✔️ Product URL

✔️ Status

✔️ Product Image

✔️ Variant Option


The rest of the field that needs to be mentioned above is NOT able to add the text at the beginning of the column value or the end of the value.


Updated on: 08/09/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!