Create a gist now

Instantly share code, notes, and snippets.

Embed
What would you like to do?

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.

@m-thomson

This comment has been minimized.

Show comment
Hide comment
@m-thomson

m-thomson May 10, 2017

Compare two fields within the file like this:

[IF({sku[.=../parentsku]})]The fields are equal[ELSE]They're not equal[ENDIF]
Owner

m-thomson commented May 10, 2017

Compare two fields within the file like this:

[IF({sku[.=../parentsku]})]The fields are equal[ELSE]They're not equal[ENDIF]
@m-thomson

This comment has been minimized.

Show comment
Hide comment
@m-thomson

m-thomson Jul 13, 2017

Tip: You can often simplify your XPath statements by removing the [1] notations. That's only needed if there are multiple nodes with the same name (to indicate the one you want). By default the first one is grabbed so [1] is unnecessary. These are functionally equivalent if there is only one title field:

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

Owner

m-thomson commented Jul 13, 2017

Tip: You can often simplify your XPath statements by removing the [1] notations. That's only needed if there are multiple nodes with the same name (to indicate the one you want). By default the first one is grabbed so [1] is unnecessary. These are functionally equivalent if there is only one title field:

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

@m-thomson

This comment has been minimized.

Show comment
Hide comment
@m-thomson

m-thomson Aug 17, 2017

Nested IF statements are allowed:

[IF({color[.= '']})]
  [IF({size[.= '']})]
   One size fits all. Color is as pictured.
  [ELSE]
  One size fits all. Color: {color}
  [ENDIF]
[ELSE]
  Size: {size} Color: {color}
[ENDIF]

Note #1: This is written on multiple lines here for readability but can be placed on all a single line in your import.
Note #2: Just because you can nest IF statements doesn't always mean that you should :-). A custom PHP function is usually a cleaner solution... especially in single line fields.

Owner

m-thomson commented Aug 17, 2017

Nested IF statements are allowed:

[IF({color[.= '']})]
  [IF({size[.= '']})]
   One size fits all. Color is as pictured.
  [ELSE]
  One size fits all. Color: {color}
  [ENDIF]
[ELSE]
  Size: {size} Color: {color}
[ENDIF]

Note #1: This is written on multiple lines here for readability but can be placed on all a single line in your import.
Note #2: Just because you can nest IF statements doesn't always mean that you should :-). A custom PHP function is usually a cleaner solution... especially in single line fields.

@jonasskafte

This comment has been minimized.

Show comment
Hide comment
@jonasskafte

jonasskafte Apr 6, 2018

Hi there @m-thomson,

Thanks for sharing this, I've found it really useful! 😃

Am I right that it's not possible to use native XPath functions in WP All Export's 'Custom XML Feed'?

It doesn't seem to work when I try. I've followed your advice and tried to find a solution with a PHP function instead (example A here). However, there isn't a good example for when you want to return a different value from your import file depending on whether another field in the file is empty or not. In other words, I cannot work out how to recreate this IF/ELSE statement with PHP:

[IF({value_1[.='']})]{value_2}[ELSE]{value_3}[ENDIF]

I don't know if you're involved with WP All Import, but it would be great to have an example of that in the documentation as well.

Anyway, thanks again for this great resource!

Hi there @m-thomson,

Thanks for sharing this, I've found it really useful! 😃

Am I right that it's not possible to use native XPath functions in WP All Export's 'Custom XML Feed'?

It doesn't seem to work when I try. I've followed your advice and tried to find a solution with a PHP function instead (example A here). However, there isn't a good example for when you want to return a different value from your import file depending on whether another field in the file is empty or not. In other words, I cannot work out how to recreate this IF/ELSE statement with PHP:

[IF({value_1[.='']})]{value_2}[ELSE]{value_3}[ENDIF]

I don't know if you're involved with WP All Import, but it would be great to have an example of that in the documentation as well.

Anyway, thanks again for this great resource!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment