To create a support ticket, start a search

Modifying the exported characters strings

The CSV export tool included in Store Commander allows you to export very precise data, simply by using various formulas in the mapping, to be inserted in Modifications column:


  • Allows the decoding of html characters



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



  • Changes the string to lower cases



  • Changes the string to upper cases



  • Allows to export a limited number of characters. Here between 0 and 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



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



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



Download our themed Guides to learn how to manage your shop at lightning speed with Store Commander.