Filter System Doesn’t Work in Some Prices

  • Resolved ibrahimpak

    (@ibrahimpak)


    3 years ago

    Hello,

    If there is a comma, the filter system will not work to show more prices.

    “10” works.

    “10.00” works.

    “10,00” does not work. “There are no elements to import based on your XPath.”

    Trieds: /item[price1[1] >= 10]
    /item[price1[1] >= 10,00]

    Below are a few sample products.

    <?xml version="1.0"?>
<Products>
<Product>
<Code>7410000428901</Code>
<ProductType>As?l</ProductType>
<MainProductCode/>
<Barcode>74100004289012</Barcode>
<UnitInStock>6</UnitInStock>
<IsActive>1</IsActive>
<ModelNumber>HBCV000013B5HJ</ModelNumber>
<Mark>ModaCar</Mark>
<ProductName>ModaCar Magnus Trafik Emniyet Seti 428901</ProductName>
<Description> </Description>
<Price>50,00</Price>
<Currency>YTL</Currency>
<Vat>18</Vat>
<Desi>1</Desi>
<MainGroupCode>21130</MainGroupCode>
<MainGroup>ARAC AKSESUAR</MainGroup>
<EndGroupCode>12954</EndGroupCode>
<EndGroup>Trafik Yol Yard?mc? ürünler</EndGroup>
<PictureCode>https://www.arabayaservis.com/productimages/175176/big/7410000428901.jpg</PictureCode>
</Product>
<Product>
<Code>7410000428899</Code>
<ProductType>As?l</ProductType>
<MainProductCode/>
<Barcode>74100004288991</Barcode>
<UnitInStock>12</UnitInStock>
<IsActive>1</IsActive>
<ModelNumber>HBCV00001338WW</ModelNumber>
<Mark>ModaCar</Mark>
<ProductName>ModaCar 7.9 mm 1 Metrekare Oto Ses Is? Yal?t?m Levhas? 428899</ProductName>
<Description> </Description>
<Price>40,00</Price>
<Currency>YTL</Currency>
<Vat>18</Vat>
<Desi>1</Desi>
<MainGroupCode>21130</MainGroupCode>
<MainGroup>Mutfak ürünleri</MainGroup>
<EndGroupCode>14735</EndGroupCode>
<EndGroup>Ara? Kap? Koruyucu</EndGroup>
<PictureCode>https://www.arabayaservis.com/productimages/175173/big/7410000428897.jpg</PictureCode>
</Product>
<Product>
<Code>7410000427620</Code>
<ProductType>As?l</ProductType>
<MainProductCode/>
<Barcode>7410000427620</Barcode>
<UnitInStock>1</UnitInStock>
<IsActive>1</IsActive>
<ModelNumber>HBV00000QJO5H</ModelNumber>
<Mark>ModaCar</Mark>
<ProductName>Modacar Vogue Spralli Aux Kablosu 427620 </ProductName>
<Description> </Description>
<Price>30,00</Price>
<Currency>YTL</Currency>
<Vat>18</Vat>
<Desi>1</Desi>
<MainGroupCode>21360</MainGroupCode>
<MainGroup>Mutfak ürünleri</MainGroup>
<EndGroupCode>21359</EndGroupCode>
<EndGroup>AUX Kablo ve D?nü?türücü</EndGroup>
<PictureCode>https://www.arabayaservis.com/productimages/175162/big/7410000427620.jpg</PictureCode>
</Product>
<Product>
<Code>7460000715810</Code>
<ProductType>As?l</ProductType>
<MainProductCode/>
<Barcode>7460000715810</Barcode>
<UnitInStock>6</UnitInStock>
<IsActive>1</IsActive>
<ModelNumber>7460000715810</ModelNumber>
<Mark>HomeCare</Mark>
<ProductName>HomeCare Rolland Lavabo A??c? Pratik 715810 6 l? ?ndirimli Paket</ProductName>
<Description> </Description>
<Price>20,00</Price>
<Currency>YTL</Currency>
<Vat>18</Vat>
<Desi>1</Desi>
<MainGroupCode>21141</MainGroupCode>
<MainGroup>Mutfak ürünleri</MainGroup>
<EndGroupCode>21248</EndGroupCode>
<EndGroup>Lavabo A??c? ve T?ka?lar</EndGroup>
<PictureCode>https://www.arabayaservis.com/productimages/184969/big/7430000715810.jpg</PictureCode>
</Product>
<Product>
<Code>7460000715493</Code>
<ProductType>As?l</ProductType>
<MainProductCode/>
<Barcode>7460000715493</Barcode>
<UnitInStock>6</UnitInStock>
<IsActive>1</IsActive>
<ModelNumber>HBCV000014GX1G</ModelNumber>
<Mark>Transformacion</Mark>
<ProductName>Transformacion Cecilio Saya?l? ?p Atlama Lasti?i 715493 6 LI ?ND?R?ML? PAKET</ProductName>
<Description> </Description>
<Price>10,00</Price>
<Currency>YTL</Currency>
<Vat>18</Vat>
<Desi>1</Desi>
<MainGroupCode>21201</MainGroupCode>
<MainGroup>Mutfak ürünleri</MainGroup>
<EndGroupCode>21107</EndGroupCode>
<EndGroup>Spor</EndGroup>
<PictureCode>https://www.arabayaservis.com/productimages/178027/big/7430000715493.jpg</PictureCode>
</Product>
</Products>
Viewing 5 replies - 1 through 5 (of 5 total)
  • Aakash

    (@aakash8)

    Hi @ibrahimpak

    I’d recommend editing the source XML file to use “.” instead of “,” as the separator, then your XPath will filter correctly.

    According to this post by WPAllImport and this by a WooCommerce dev, WooCommerce seems to prefer to have prices in this format.

    Then you could use a plugin (or maybe there’s even a built in WooCommerce setting) to display price with comma to your frontend visitors.

    Hope this helped

    • This reply was modified 3 years ago by Aakash.
    • This reply was modified 3 years ago by Aakash.
    Thread Starter ibrahimpak

    (@ibrahimpak)

    Hi @aakash8

    Your answer shows no problem. That’s why I guess “.” We have to get used to using separators.

    As another method, I did use filter “not contains” for example “1,00” prices like, sample: /Product[Price[1][not(contains(.,”1,”))]]

    But this time “11,00” , “21,00” , “31,00” , “41,00” , “51,00” etc. affected prices.

    Maybe it would be useful if the filter was limited to “1,00” prices only.

    • This reply was modified 3 years ago by ibrahimpak.
    Aakash

    (@aakash8)

    @ibrahimpak The “starts-with” XPath function may help you get a bit closer.
    /Product[Price[1][not(starts-with(.,"1,") )]]

    However, I believe switching to “.” for “cents” separator in the source file is the best method. Then use WooCommerce settings/a plugin to change it to “,” as needed on the frontend/admin dashboard.

    • This reply was modified 3 years ago by Aakash.
    Thread Starter ibrahimpak

    (@ibrahimpak)

    @aakash8

    I tried the following XPath way and it works perfectly.

    /Product[Price[1][not(starts-with(.,"1,") )]]

    In this way, prices such as “1.00”, “2.00”, “3,00” etc. can be excluded.

    This suggestion solved my problem and thank you for everything!

    Aakash

    (@aakash8)

    @ibrahimpak Excellent, glad you got it working to your liking!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Filter System Doesn’t Work in Some Prices’ is closed to new replies.