Skip to main content

Hello all,

 

I am trying to automate/ organise/ consolidate the way i run my Shopify product information.

I use Airpower (a 3rd party API integrator) to sync Airtable to and from my Shopify.

I am trying to create a product description field (rich text/ HTML) then sync it to my Shopify product information field.

Currently:

  • My product information field is in Rich Text and will sync across to airtable.

 

What I want:

  • I wanted to split the field further - e.g. About The Item, In the Box, Compatibility
  • So that I can make the formatting more consistent
    ​​​​

The Result Format I want:
 

<h3>About The Item</h3>

  • This phone case is…
  • The colour is…
  • It is made of durable plastic etc...

<h3>Compatibility</h3>

  • iPhone 16 Pro
  • iPhone 16

<h3>In The Box</h3>

  • Phone
  • Charger
  • etc.

Is there a way to achieve that using formula (e.g. concatenate)?

 

Thank you!

How does this look?  I’ve set it up here for you to check out

 

CONCATENATE(
  '<h3>About The Item</h3>\n' & 
  '<ul>\n' &
  '<li>' & Blurb & '</li>\n' &
  IF(
    Color,
    '<li>The colour is ' & Color & '</li>\n'
  ) &
  '</ul>\n\n' & 
  '<h3>Compatibility</h3>\n' &
  '<ul>\n' &
  IF(
    Compatibility,
    '<li>' & 
    SUBSTITUTE(
      Compatibility,
      ', ',
      '</li>\n<li>'
    ) &
    '</li>\n'
  ) &
  '</ul>' 

)

 

Terms & ConditionsAccessibility statement