Decimal Separator not Interpreted Correctly

  • Resolved woochilles

    (@woochilles)


    3 years, 6 months ago

    Hello,

    The decimal separator in Germany is “,”. When configuring the logic for the shipping price, I do something like (if sale price greater than…). This works on prices that do not have decimals. On prices with decimals it works only when not including variations (I have the paid version of WooCommerce Google Feed Manager). It seems that sale price / regular price of product variations are not treated the same way before evaluation when having “include product variations” checked/unchecked.

    BR Peter

    • This topic was modified 3 years, 6 months ago by woochilles.
Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    Hello Peter,

    I did some testing on my test servers, but it seems to work correctly here. Can you make a screenshot of the settings you use for the shipping price? I could use that to replicate the exact settings you’re using.

    Thread Starter woochilles

    (@woochilles)

    Hello Michel,

    Many thanks for analysing the problem immediately. Here is a screenshot for my shipping calculation.

    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    I see you’re not using the default “Sale Price” and “Regular Price” values but you are using “_sale_price” and “_regular_price”.

    When I test the settings with Sale Price and Regular Price it just seems to work ok. Do you know where these “_sale_price” and “_regular_price” attributes are from? I don’t have them in my source list so I assume they are from a third party plugin?

    Thread Starter woochilles

    (@woochilles)

    The funny thing is that if I change to “Sale Price” and “Regular Price” my input is changed back to “_sale_price” and “_regular_price” after saving. I think these attributes are probably coming from Germanized.

    • This reply was modified 3 years, 6 months ago by woochilles.
    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    Might be that the Germanized plugin has some influence on the calculations. On my servers I get the correct results.

    Could you try an alternative setup, not using the “edit values” option but only the filter options? So something like this: https://pasteboard.co/K1nTD6h.png

    Thread Starter woochilles

    (@woochilles)

    Thanks Michel, I tried the alternative setup but it produces the same results in the end. “Sale Price” and “Regular Price” are still changed back to “_sale_price” and “_regular_price” after saving. Actually something is even throwing out the second condition, so that I have to input “_sale_price” and “_regular_price” directly to make it stick.

    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    Strange as it seems to work correctly here. Could you send me an email to michel (at) wpmarketingrobot so we can share a link to the feed and I can have a better look at it?

    Plugin Contributor Michel Jongbloed

    (@michel-jongbloed)

    Handled through email.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Decimal Separator not Interpreted Correctly’ is closed to new replies.