• Resolved Tim Gooch

    (@timthefoolman)


    Customers coming to my store from Canada are seeing price totals that are much higher than they should be. The current USD/CAD conversion rate is about 1USD/1.416CAD. A customer sent me a screen shot of their cart, and 10 items priced at $28.80CAD ($20USD) each shows a total of $410CAD, which is almost exactly 1.416 x $288CAD (what the total should be).

    I have been having this problem for over a year, and finally had a potential customer willing to spend the time to help me diagnose it, since it’s very difficult to recreate such scenarios by yourself, and my last exchange on this topic yielded… less than satisfactory results.

    I think we can all agree that 10 x 28.80 is not 410.00.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Zee

    (@doublezed2)

    Hello timthefoolman,

    Thank you for contacting WooCommerce support.

    I understand customers from Canada are seeing inflated price totals due to incorrect currency conversions.

    To help you resolve this, I need more details about your setup and how conversions are being handled. Could you share your site’s System Status Report?
    You can find it under WooCommerce > Status. Select “Get system report” and then “Copy for support” to share it with me.

    Looking forward to your response. 🙂

    Thread Starter Tim Gooch

    (@timthefoolman)

    ` WordPress Environment</p> <p>WordPress address (URL): https://itgooch-productions.com<br>Site address (URL): https://itgooch-productions.com<br>WC Version: 9.4.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ✔ 3.8.2<br>Log Directory Writable: ✔<br>WP Version: 6.7.1<br>WP Multisite: –<br>WP Memory Limit: 768 MB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: en_US<br>External object cache: ✔ Server Environment</p> <p>Server Info: Apache<br>PHP Version: 8.2.26<br>PHP Post Max Size: 256 MB<br>PHP Time Limit: 120<br>PHP Max Input Vars: 3000<br>cURL Version: 8.2.1<br>OpenSSL/3.1.4</p> <p>SUHOSIN Installed: –<br>MySQL Version: 8.0.39-30<br>Max Upload Size: 256 MB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔ Database</p> <p>WC Database Version: 9.4.3<br>WC Database Prefix: wpq2_<br>Total Database Size: 31.97MB<br>Database Data Size: 20.58MB<br>Database Index Size: 11.39MB<br>wpq2_woocommerce_sessions: Data: 0.23MB + Index: 0.02MB + Engine InnoDB<br>wpq2_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpq2_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_woocommerce_order_itemmeta: Data: 0.16MB + Index: 0.16MB + Engine InnoDB<br>wpq2_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpq2_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_actionscheduler_actions: Data: 2.05MB + Index: 0.91MB + Engine InnoDB<br>wpq2_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_actionscheduler_logs: Data: 1.38MB + Index: 0.53MB + Engine InnoDB<br>wpq2_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_comments: Data: 0.11MB + Index: 0.09MB + Engine InnoDB<br>wpq2_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_gla_budget_recommendations: Data: 0.19MB + Index: 0.14MB + Engine InnoDB<br>wpq2_gla_merchant_issues: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wpq2_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_hfcm_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_ifso_daily_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_ifso_local_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpq2_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_loginizer_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_mailpoet_automation_run_logs: Data: 0.08MB + Index: 0.05MB + Engine InnoDB<br>wpq2_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpq2_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>wpq2_mailpoet_newsletters: Data: 0.03MB + Index: 0.05MB + Engine InnoDB<br>wpq2_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_scheduled_tasks: Data: 0.38MB + Index: 0.27MB + Engine InnoDB<br>wpq2_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpq2_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpq2_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_mailpoet_subscribers: Data: 0.06MB + Index: 0.23MB + Engine InnoDB<br>wpq2_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_options: Data: 4.05MB + Index: 0.16MB + Engine InnoDB<br>wpq2_patchstack_event_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_patchstack_firewall_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_patchstack_logic: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_postmeta: Data: 2.34MB + Index: 1.94MB + Engine InnoDB<br>wpq2_posts: Data: 1.25MB + Index: 0.13MB + Engine InnoDB<br>wpq2_rio_process_queue: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpq2_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>wpq2_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB<br>wpq2_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wpq2_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_wc_order_addresses: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>wpq2_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_wc_order_operational_data: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>wpq2_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpq2_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_wc_orders: Data: 0.08MB + Index: 0.11MB + Engine InnoDB<br>wpq2_wc_orders_meta: Data: 2.52MB + Index: 2.94MB + Engine InnoDB<br>wpq2_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_wc_product_meta_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wpq2_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_wc_zapier_history: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wpq2_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_wcpdf_proforma_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_wdr_order_item_discounts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_yoast_indexable: Data: 0.06MB + Index: 0.09MB + Engine InnoDB<br>wpq2_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_admlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_aka: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_zbs_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpq2_zbs_contacts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_customfields: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpq2_zbs_event_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_events: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpq2_zbs_externalsources: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_zbs_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_invoices: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpq2_zbs_lineitems: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpq2_zbs_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_object_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_quotes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpq2_zbs_quotes_templates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_security_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_sys_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpq2_zbs_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_tags_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpq2_zbs_tax_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_temphash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zbs_transactions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wpq2_zbscrm_api_keys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpq2_zp_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts</p> <p>attachment: 93<br>awl-labels: 3<br>custom_css: 2<br>ifso_triggers: 1<br>igmap: 1<br>mailpoet_page: 1<br>nav_menu_item: 7<br>page: 12<br>post: 10<br>product: 9<br>product_variation: 38<br>revision: 82<br>shop_coupon: 7<br>shop_order: 240<br>shop_order_refund: 2<br>wp_global_styles: 1<br>wpcf7_contact_form: 1 Security</p> <p>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (36)</p> <p>Advanced Woo Labels: by ILLID – 2.07<br>Child Theme Configurator: by Lilaea Media – 2.6.6<br>Classic Editor: by WordPress Contributors – 1.6.7<br>Comment Link Remove: by QuantumCloud – 2.6.9<br>Contact Form 7: by Takayuki Miyoshi – 6.0.1<br>Cost of Goods for WooCommerce Pro: by WPFactory – 3.3.7<br>Disable auto-update Email Notifications: by Joltmailer – 1.4.1<br>Disable Comments: by WPDeveloper – 2.4.6<br>Facebook for WooCommerce: by Facebook – 3.3.1<br>Google for WooCommerce: by WooCommerce – 2.9.2<br>Header Footer Code Manager: by DraftPress – 1.1.39<br>If-So: by If So Plugin – 1.9.3<br>MapGeo – Interactive Geo Maps: by MapGeo – 1.6.21<br>Jetpack Boost: by Automattic – Jetpack Site Speed team – 3.6.1<br>Jetpack: by Automattic – 14.1<br>Loginizer: by Softaculous – 1.9.4<br>MailPoet: by MailPoet – 5.5.0<br>WooCommerce Merge Orders: by Vibe Agency – 1.3.11<br>Patchstack Security: by Patchstack – 2.2.13<br>Purchase Orders for WooCommerce: by McGregor Media Web Design – 1.11.1<br>Robin image optimizer: by Creative Motion – 1.7.2<br>Speed Optimizer: by SiteGround – 7.7.2<br>SmartCrawl: by WPMU DEV – 3.11.0<br>Sucuri Security – Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.9.6<br>WooCommerce Backorder Manager: by jeffrey-wp – 2.5<br>Discount Rules Core: by Flycart – 2.6.6<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>WooPayments: by WooCommerce – 8.6.0<br>WooCommerce PayPal Payments: by WooCommerce – 2.9.5<br>PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.9.0<br>PDF Invoices & Packing Slips for WooCommerce – Professional: by WP Overnight – 2.15.11<br>WooCommerce Shipping & Tax: by WooCommerce – 2.8.5<br>WooCommerce Shipment Tracking: by WooCommerce – 2.5.3<br>WooCommerce Shipping: by WooCommerce – 1.3.0<br>Zapier Integration for WooCommerce: by Tectalic (formerly OM4 Software) – 2.12.0<br>WooCommerce: by Automattic – 9.4.3 Inactive Plugins (1)</p> <p>Meta Tag Manager: by Pixelite – 3.1 Dropin Plugins ()</p> <p>advanced-cache.php: advanced-cache.php<br>object-cache.php: Memcached Must Use Plugins (1)</p> <p>_patchstack.php: by – Settings</p> <p>Legacy API Enabled: –<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)</p> <p>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)</p> <p>Connected to WooCommerce.com: ✔<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: ✔ Logging</p> <p>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 460 KB WC Pages</p> <p>Shop base: #62 – /shop/<br>Cart: #63 – /cart/ – Contains the [woocommerce_cart] shortcode<br>Checkout: #64 – /checkout/ – Contains the [woocommerce_checkout] shortcode<br>My account: #65 – /my-account/<br>Terms and conditions: #140 – /terms-conditions/ Theme</p> <p>Name: Twenty Seventeen Child<br>Version: 3.4.1700872641<br>Author URL: https://ww.wp.xz.cn/<br>Child Theme: ✔<br>Parent Theme Name: Twenty Seventeen<br>Parent Theme Version: 3.8<br>Parent Theme Author URL: https://ww.wp.xz.cn/<br>WooCommerce Support: ✔ Templates</p> <p>Overrides: – WooPayments</p> <p>Version: 8.6.0<br>Connected to WPCOM: Yes<br>WPCOM Blog ID: 205073484<br>Account ID: acct_1Klab52EAdjPEVvM<br>Payment Gateway: Enabled<br>Test Mode: Disabled<br>Enabled APMs: card<br>WooPay: Disabled<br>WooPay Incompatible Extensions: No<br>Apple Pay / Google Pay: Enabled (product,cart,checkout)<br>Fraud Protection Level: basic<br>Multi-currency: Enabled<br>Auth and Capture: Disabled<br>Documents: Disabled<br>Logging: Disabled MailPoet</p> <p>Sending Method: PHPMail<br>Send all site’s emails with: Default WordPress sending method<br>Task Scheduler method: WordPress<br>Cron ping URL: https://itgooch-productions.com?mailpoet_router&endpoint=cron_daemon&action=ping WooCommerce PayPal Payments</p> <p>Onboarded: ✔<br>Shop country code: US<br>WooCommerce currency supported: ✔<br>Advanced Card Processing available in country: ✔<br>Pay Later messaging available in country: ✔<br>Webhook status: –<br>PayPal Vault enabled: –<br>ACDC Vault enabled: –<br>Logging enabled: –<br>Reference Transactions: ✔<br>Used PayPal Checkout plugin: –<br>Subscriptions Mode: Disabled<br>PayPal Shipping Callback: –<br>Apple Pay: –<br>Google Pay: –<br>Fastlane: – Admin</p> <p>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store</p> <p>Disabled Features: product-data-views<br>experimental-blocks<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>blueprint<br>reactify-classic-payments-settings<br>use-wp-horizon</p> <p>Daily Cron: ✔ Next scheduled: 2024-12-12 14:49:49 +00:00<br>Options: ✔<br>Notes: 203<br>Onboarding: completed Action Scheduler</p> <p>Canceled: 2<br>Oldest: 2024-11-11 23:02:04 +0000<br>Newest: 2024-12-03 15:44:12 +0000</p> <p>Complete: 2,644<br>Oldest: 2024-11-10 15:13:05 +0000<br>Newest: 2024-12-11 14:48:47 +0000</p> <p>Failed: 104<br>Oldest: 2022-11-02 06:10:39 +0000<br>Newest: 2024-12-07 08:27:37 +0000</p> <p>Pending: 7<br>Oldest: 2024-12-11 15:27:39 +0000<br>Newest: 2025-01-05 17:32:31 +0000 WooCommerce Zapier</p> <p>Database Version: ✔ 21<br>Detailed Logging Enabled: Yes<br>SSL: ✔ Yes<br>REST API Authentication Key(s): ❌ 0<br>Task History Record Count: ✔ 445<br>Webhook #9: WooCommerce Zapier</p> <ul> <li>Status: active</li> <li>Trigger: order.paid</li> <li>Delivery Count: 137</li> <li>User: itgooch<br>Webhook #8: WooCommerce Zapier</li> <li>Status: active</li> <li>Trigger: order.paid</li> <li>Delivery Count: 221</li> <li>User: itgooch<br>Deleted Webhook Delivery Count: 87</li> </ul> <p>Status report information</p> <p>Generated at: 2024-12-11 15:04:57 +00:00<br>`

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    I have tried to replicate the issue on my site, and I can see that the issue is only occurring for products with quantity-based price discounts. For all other products, the order price total is working fine.

    It seems like the plugin you are using for quantity-based price discounts is causing the issue. For testing, could you please deactivate the plugin that adds the quantity-based pricing and see if that resolves the issue?

    If you prefer not to test on the live site, I would suggest creating a staging site and then deactivating the plugin that adds the quantity-based price to see if that resolves the issue.

    For more details on how to run a conflict test, you can refer to this article:
    How to Test for Plugin Conflicts

    Let me know how that goes!

    Thread Starter Tim Gooch

    (@timthefoolman)

    Unfortunately, the only way I’ve found to get valid test results is to ask for help from customers in the affected countries (that I know about only because of their feedback). It’s maddening.

    Do you have a recommendation for spoofing my IP address (I’m in the US) to successfully fool the browser (and plugins) into thinking that I’m in Canada, Australia, etc.?

    Thread Starter Tim Gooch

    (@timthefoolman)

    I disabled that plugin and began using Dynamic Pricing With Discount Rules for WooCommerce instead. It does exactly what I needed.

    Thankfully, my client in Canada was willing to test this out for me. Chrome spoofs the location intermittently, as different plugins use different methods for determining the current country/currency conversion to use.

    Also, it seems remarkable to me that when implementing rules for quantity based discounts, EVERY vendor seems to use “Fixed Discount” to mean “a fixed discount as a number,” and does not convert that value accordingly when the site is viewed from a different country. A $2USD discount is very different from a $2AUD or $2CAD discount.

    Thank you for your help!

    Hi @timthefoolman,

    Thank you for your detailed feedback and for your diligence in diagnosing the issue with currency conversion and quantity-based discounts on your WooCommerce store. I understand how challenging it can be to test from different international locations and navigate the complexities introduced by various plugins.

    To effectively test how your store handles currency conversion for customers in different countries, you can use a VPN. Services like NordVPN or ExpressVPN are reliable options.

    Additionally, Chrome offers a way to override geolocation settings for testing location-specific features. To do this:

    • Press Ctrl+Shift+I (Windows) or Cmd+Option+I (Mac) to open Developer Tools.
    • Navigate to the Sensors tab (you may need to enable it from the three-dot menu).
    • Set the desired location coordinates to simulate different regions.

    Regarding the issue you’re encountering, where fixed discounts don’t convert appropriately across currencies, this often occurs because many dynamic pricing plugins apply fixed discounts without accounting for currency conversion rates. This leads to inconsistencies for international customers.

    I recommend trying a plugin that supports currency-aware discounts, such as the Product Dynamic Pricing and Discounts extension.

    WooCommerce offers a 30-day refund policy, allowing you to test extensions to ensure they meet your needs. If you have any questions before purchasing, feel free to reach out via WooCommerce.com → My Account → Support (you’ll need to create an account if you don’t already have one).

    Additionally, I would also recommend checking if any manual rates have been added for CAD, as they might be affecting the correct rates from showing. You can do this by going to WooCommerce > Settings > Multi Currency > CAD > Manage, as shown in the screenshot below.

    Please let me know if there’s anything important I might have missed or if you need further assistance!

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘USD/CAD Doubled Conversion Charge’ is closed to new replies.