Price by Country not reconciling in Woocommerce Dashboard

  • Resolved dalilu

    (@dalillu)


    8 months, 2 weeks ago

    Hi Oscar,
    I have a client / family friend who has been using this plugin without issue for years. Recently we updated their website and imported a bunch of orders so that their sales numbers would align. This is when we started noticing the issue.

    All of the prices are set manually for US and Canada, and the dollar amounts are showing correctly but only in CAD rather than USD or CAD depending on the order location.

    So for example, product A is selling for 36.95 CAD in Canada and selling for $33.95 USD in the US. If someone based in the US buys the product, they are being charged $33.95 USD + Shipping which is correct, but the order is listed in the dashboard as selling for 33.95 CAD which will present huge problems for reconciling their books.

    I am wondering what I need to do in order to ensure the currency shows up correctly in both the payment gateway and the woocommerce dashboards.

    Thanks for you help

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Oscar Gare

    (@oscargare)

    Hi,

    A code snippet to change the currency symbol (or a plugin that does this) usually causes this problem.
    Are you using some code or plugin to change the symbol $ to CAD/USD?

    Thread Starter dalilu

    (@dalillu)

    The only other plugin that deals with Geolocation related stuff is WooCommerce Geolocation Based Products – this is another one that we have had in place for many years…

    I do have the following code in our child theme functions.PHP file:

    Do we think that might be the challenge?

    function addPriceSuffix($format, $currency_pos) {
    switch ( $currency_pos ) {
    case ‘left’ :
    $currency = get_woocommerce_currency();
    $format = ‘%1$s%2$s ‘ . $currency;
    break;
    }

    return $format;

    }

    add_action(‘woocommerce_price_format’, ‘addPriceSuffix’, 1, 2);

    function my_remove_variation_price( $price ) {
    $price = ”;
    return $price;
    }

    Plugin Author Oscar Gare

    (@oscargare)

    Hi, the callback function of the woocommerce_price_format filter (addPriceSuffix) causes the issue.

    In the WordPress admin, the get_woocommerce_currency() function always returns the shop base currency (CAD, in your case).

    the function addPriceSuffix is concatenating the current currency. This works on the front end, but in the WordPress admin (dashboard), it does not work because get_woocommerce_currency() returns “CAD”.

    It’s not a problem related to Price Based on Country.

    Modifying the currency format is a feature included in the PRO version. You can review it here: https://www.pricebasedcountry.com/docs/getting-started/settings-options/#section-1

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Price by Country not reconciling in Woocommerce Dashboard’ is closed to new replies.