Skip to main content
Solved

Markets Pro Shopify to Acumatica


K2a
Jr Varsity III
Forum|alt.badge.img
  • Jr Varsity III
  • 92 replies

Does anyone have experience with Markets Pro in Shopify?   It is supposed to allow us to bring in sales from other countries (CAD for example), however it looks like it brings it in with the Currency of the foreign country, and fails for us because we do not have MultiCurrency enabled. 


I was hoping it would perform the conversion of the currency and import as USD.   

 

It seems the JSON file contains the USD amount and the conversion: 

Are we supposed to MAP this in the connector?!

Cheers,

k2

Best answer by KarthikGajendran

@K2a  You can vote on this idea 

https://community.acumatica.com/ideas/ability-to-choose-whether-to-import-the-order-and-payments-using-base-currency-or-paid-currency-22571

 

View original
Did this topic help you find an answer to your question?

10 replies

simonliang91
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 79 replies
  • February 15, 2024

@K2a , we are using presentment currency to import the Order and Payment currently. It’s impossible to map it in the Entity mapping screen. 

But it may be a solution to add an option to let user choose which currency should be used. I think our BAs are working on it. @KarthikGajendran 


K2a
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 92 replies
  • February 15, 2024
simonliang91 wrote:

@K2a , we are using presentment currency to import the Order and Payment currently. It’s impossible to map it in the Entity mapping screen. 

But it may be a solution to add an option to let user choose which currency should be used. I think our BAs are working on it. @KarthikGajendran 

Thanks @simonliang91  - so I assume this means we’d HAVE to enable multicurrency accounting in order to process as of now?


KarthikGajendran
Acumatica Moderator
Forum|alt.badge.img+3

@K2a I assume your base currency is USD in Shopify and customer paid with CAD currency. 

In Acumatica Sales Order, we always display two currencies. 

  1. Order Currency

     

  2. Order Base Currency

     

 

In your case, in Acumatica Sales order, you would have Order Currency as CAD and Order Base Currency as USD and the exchange rate brought from Shopify.
Acumatica Payment will be created in CAD currency as well and applied against the Order created in CAD. 

Now, are you expecting the system to create the Acumatica Sales Order in USD? Meaning both the Order Currency and Base Currency to be USD? Please let me know. 


K2a
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 92 replies
  • February 15, 2024
KarthikGajendran wrote:

@K2a I assume your base currency is USD in Shopify and customer paid with CAD currency. 

In Acumatica Sales Order, we always display two currencies. 

  1. Order Currency

     

  2. Order Base Currency

     

 

In your case, in Acumatica Sales order, you would have Order Currency as CAD and Order Base Currency as USD and the exchange rate brought from Shopify.
Acumatica Payment will be created in CAD currency as well and applied against the Order created in CAD. 

Now, are you expecting the system to create the Acumatica Sales Order in USD? Meaning both the Order Currency and Base Currency to be USD? Please let me know. 

@KarthikGajendran  - we do not have MultiCurrency enabled, so would this functionality work as you describe without CAD enabled as a currency?  Because when I tried to import the Markets Pro order I get the following Commerce Error: 

 


K2a
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 92 replies
  • February 20, 2024

@KarthikGajendran - just want to confirm - we WOULD need to enable multicurrency to deal with this type of order?

cheers,

k2


KarthikGajendran
Acumatica Moderator
Forum|alt.badge.img+3

@K2a Yes, you need to enable multi currency because you are using multiple currencies. You have the ability to create the orders in CAD and also in USD. 

We are evaluating if we have to provide the user to choose to always import the orders with Base currency as the Order currency and base currency. 

Meaning, in this case, the Order currency will be USD, Base currency in the order will be USD and Payment will be in USD. 

Is this something you are looking for?


K2a
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 92 replies
  • February 20, 2024

@KarthikGajendran - I think that could help a lot of folks that are in the same boat as us.  If we have the ability to sell on shopify in multiple currencies but import to ACU without using multi-currency setup, that would be super!


K2a
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 92 replies
  • February 21, 2024

@KarthikGajendran - another comment on this, it looks like Markets Pro is handling all the currency conversion and even pays us in USD.   So again, I think it would be helpful to be able to import the order/payment in our base currency based on the daily spot rate:

 


KarthikGajendran
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • 279 replies
  • Answer
  • February 28, 2024

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 598 replies
  • May 16, 2024

@KarthikGajendran - This is a critical issue for one of our customers.  The scenario is exactly the same as what @k2a described.  They need the ability to import transactions in the paid currency.  

@K2a - Were you able to get this working using multicurrency as suggested?  We tried this but are having issues with the exchange rate on the payments.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings