To create a support ticket, start a search

Modifying the exported characters strings

You have the possibility to add one of this codes in the 'Modifications' column of your mapping to change the exported value (name, descriptions, etc):

  • Allows the decoding of html characters

  html_entity_decode

 

  • Allows to delete html elements of the exported string, obtaining only plain text without any formatting

   strip_tags

 

  • Changes the string to lower cases

   strtolower

 

  • Changes the string to upper cases

   strtoupper

 

  • Allows to export a limited number of characters. Here between 0 and 5

  =substr('(x)',0,5)

 

  • Adds text in the exported field. (x) is replaced by the field value

  ='(x)'.' My text'

 

  • Adds the reference to the exported field

  ='(x)'.' '.(isset($product_attribute['reference'])?$product_attribute['reference']:$p->reference)

 

  • Replaces a chain of character https to http in the exported field

  =str_replace('https','http','(x)')

 

  • Replaces the dot (.) by a comma (,) in price fields

  =str_replace('.',',','x')

 

  • Export the values of 'Condition' field in French (exported in English by default)

  =('(x)'=='"new"'?'"Nouveau"':('(x)'=='"refurbished"'?'"Reconditionné"':('(x)'=='"used"'?'"Occasion"':'(x)')))

 


 



Related articles