Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Shopify Connector and Currency

Posted on by 5
So, we're looking to shift from an third party connector to the /native/ Shopify connector between our BC and Shopify Plus stores.
 
I've been able to get everything to sync, products and what have you, but I have some trouble with the currencies.
 
Quick fact:
BC base currency is SEK (Swedish Krona)
Shopify base currency is USD since we work mostly internationally.
 
But we do run Shopify markets and currently customers can check out in whatever currency they want, and multicurrency is crucial for us, even if we would need to settle for USD, SEK, EUR and CAD. However, all orders coming into BC are reverted back to USD for some reason.
 
In the transaction and JSON data I can see that both the Shopify base currency and the checkout currency tags along. Is there a setting i am missing, or is it just not possible to have the checkout currency to tag along to BC and create invoices in the same?

Example of JSON data where both currencies are visible (this one from a test where i placed the order in USD but had the Shopify base currency set to SEK);
    /amount/: /1792.00/,
    /currency/: /SEK/,
    /payment_id/: /rTFl81lhyoYrgky9Q5p7lRrF4/,
    /total_unsettled_set/: {
        /presentment_money/: {
            /amount/: /0.0/,
            /currency/: /SEK/
        },
        /shop_money/: {
            /amount/: /0.0/,
            /currency/: /USD/
        }
    },
Categories:
  • DR-17051303-0 Profile Picture
    DR-17051303-0 5 on at
    Shopify Connector and Currency
    I've read all the documentation I can find, and it seems like a bit of a grey area.
     
    "Shopify can be configured to accept different currencies. However, imported orders into Business Central use store currency." 
     
    It does not explicitly say that it's the Base currency and not the Checkout currency. I've spoken to a few people running this setup; about half of them say it works out of the box, and the other half say they need custom development. 
     
    And in the transactions tab in the Shopify connector (in BC), the order does come in the checkout currency, but when it becomes a sales order, well, then it turns into the store base currency.
     
     
     
    With this in mind, if it's limited to store base currency by design, it feels like they had to put in the extra work to make it less usable. But at first glance, it does look like they may refer to store base currency but not saying so explicitly.
     
     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 7,792 Super User on at
    Shopify Connector and Currency
    According to the documentation it looks like thats by design, imported orders use the store currency.
     
     
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans