import-if-syntax.md

WP All Import - IF/ELSE statement examples

Here are some example WP All Import [IF] statements. The criteria for an IF statment is written in XPath 1.0 syntax and can use XPath functions. Although powerful, XPath syntax can be quite complex. In many cases it might be easier to use a PHP function as shown here.

Note: The [ELSE]<something> part is optional

Number is equal to:

[IF({price[.=0]})]Zero[ELSE]Not Zero[ENDIF]

Number is greater than:

[IF({price[.>0]})]Greater than 0[ENDIF]

Text is equal to:

[IF({title[.='Foo']})]The title is Foo[ENDIF]

Text is not equal to:

[IF({title[.!='Foo']})]The title is not Foo[ENDIF]

Text is empty (see note below):

[IF({title[.='']})]The title is empty[ENDIF]

Text contains:

[IF({title[contains(.,’Foo')]})]Has foo[ENDIF]

Text length is:

[IF({title[string-length()>10]})]{title}[ENDIF]

IF/ELSE example:

[IF({title[.='']})]The title is empty[ELSE]{title}[ENDIF]

Note: You might have seen examples using not(text()) to check for empty fields. While this is valid XPath syntax, it seems to fail on some servers. The reasons are unclear. Just use the Text is empty syntax above instead.

Hello @m-thomson

Can you please help with this

/property[price[1] > 5000 and town[1][not(contains(.,"Gandía"))]]

I am trying to not import property with Gandía , but it is not working ,

If you need to check the value of an attribute, then put @ before the name.

I have an XML like this and only need to extract the ones with type=Location:

<categories>
	<category type="Location">
		<![CDATA[ London ]]>
	</category>
	<category type="Location">
		<![CDATA[ Manchester ]]>
	</category>
	<category type="Something Else">
		<![CDATA[ Whatever ]]>
	</category>
</categories>

Then process it like:

[FOREACH({categories/category})][IF({@type[.= 'Location']})]{.}[ENDIF][ENDFOREACH]