• Hello. We export a number of website products daily.
    Our products are many and export takes a lot of time.
    Therefore, before exporting, it is better to filter the products.
    We do this filter based on sku.
    Unfortunately, we have to enter each sku manually.
    Is there no way to filter the skus at once?
    For example, should we put a comma between them, or anything else?
    By the way, our skus do not have a special rule. Therefore, we cannot use the “bigger” or “smaller” options.
    Forgive me for my poor English.
    Thank you so much

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WP All Import

    (@wpallimport)

    Hi @mehdinjm,

    Is there no way to filter the skus at once? For example, should we put a comma between them, or anything else?

    You could do that with the WP_Query Results option: https://www.wpallimport.com/documentation/wp-query-export-to-csv/. For example:

    "post_type" => array( "product", "product_variation" ),
    "meta_query" => array( array(
       "key" => "_sku",
       "value" => array( "SKURED", "SKUGREEN", "SKUBLUE" ),
       "compare" => "IN"
    ) )

    Just replace the SKUs in the “value” array with your SKUs.

    Thread Starter mehdinjm

    (@mehdinjm)

    Thanks a lot. This was a great solution

    Thread Starter mehdinjm

    (@mehdinjm)

    This query was excellent. Can you make a similar query about orders for me? For example, how many IDs should I order and get output from the orders?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘filter based bulk sku’ is closed to new replies.