Use OR and Null

  • Resolved stompie

    (@stompie)


    7 years, 10 months ago

    Your plugin is saving me, I have three questions,

    1. can I use the OR or some operator like this when indicating the price, we have two columns in our database of old prices and new prices but we dont have some products with a new price so I was wondering if i can use for example {column_17[1]} OR {column_17[1]} in the price.

    2. Also I was wondering when using child categories we got some products that have 3 levels and some that have 5 leves but this with 3 levels have those 2 last levels as null in the database example:
    cat1 > cat2 > cat 3 > cat 4 (some are null) > cat 5 (some are null), are this going show up? how do i indicate the importer to only import the categories that are not null?

    3. Can i map a boolean in tags, we have 3 tags as boolean in our products file, can i map them as like ({column_17[1]} = yes) = tag1

    Thanks a lot!

    • This topic was modified 7 years, 10 months ago by stompie. Reason: added tag question
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WP All Import

    (@wpallimport)

    Hi @stompie

    1) You can use a PHP function or an IF statement for this.

    For example, using an IF, you can check if the new price element is empty – if it isn’t, provide the new price, and if it is empty, provide the old price:

    [IF({newprice[1][.!=""]})]{newprice[1]}[ELSE]{oldprice[1]}[ENDIF]

    2) It’s fine to list all of the category elements, WP All Import will ignore the empty ones.

    3) There’s a mapping feature in our Taxonomies section that you can use for this ( see screenshot ).

    Thread Starter stompie

    (@stompie)

    1. Thanks a lot!
    2. Categories are not Empty we got about 175 categories and some child columns are “null” not empty, I want to dismiss all the nulls if posible
    3. We have 3 main tags and some products have two or three tags as “yes”, I was wondering if its posible to select the column in the mapper, not just the argument because all three may be “yes”.

    Thanks a lot ??

    • This reply was modified 7 years, 10 months ago by stompie.
    Plugin Author WP All Import

    (@wpallimport)

    Hey @stompie

    We’ll need to see your data to better advise on this. Can you please recreate this issue on our debug servers, then submit a support ticket about this here: https://www.wpallimport.com/support/

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Use OR and Null’ is closed to new replies.