Attention: We are moving offices on february 22, the customer service will be affected during that day
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

         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)')))

 


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