Categories
View Replies (4)

Resolved Limit export filter

  1. vasslis3
    vasslis3
  2. RO CSVI
  3. Monday, 26 June 2017
  4.  Subscribe via email
I have created an export template with http://prntscr.com/fo9av0 include sku filter "ec" (All my last imported SKUs starts with ec-)

This SQL is not very effective with strings. http://prntscr.com/fo9a8i
Please update it to
(`#__virtuemart_products`.`product_sku` IN ('ec') OR `#__virtuemart_products`.`product_sku` '%ec%' )

"IN ('ec') " means absolute value.


I want to export ALL products that contains "ec" in SKU filed
0
Responses (4)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The product SKU filter is to include or exclude absolute SKUs and not for part of SKU strings. If you want to skip the records with product_sku other than ending with "ec", you can use Skip rule plugin and set the text of skus which needs to be skipped during export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

"IN ('ec') " means absolute value.
Correct but please read the help text included in that field by clicking the Help button.

This reads:
Specify the filter to select products where the product SKU matches the filter. For example: AGH2% to match AGH2A, %AGH2% to match ZAGH2B, or AGH2 to match AGH2. Multiple SKUs can be entered but need to be separated with a comma. For example AGH2%,BFT.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
vasslis3
vasslis3
Accepted Answer Pending Moderation
I need the opposite,...

Skip rule will stop processing the line if matches the string.
I need to stop processing if NOT matches the string.

I need all that has the "ec-" word
  1. more than a month ago
  2. RO CSVI
  3. # 3
vasslis3
vasslis3
Accepted Answer Pending Moderation
Thanks rolandd, you have solved my issue adding ec%
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!