Hello All,
Does anyone have experience with Netsu...
# integrationse
Emily S
04/22/2024, 1:38 PMHello All,
Does anyone have experience with Netsuite Connector <-> Shopify and currency mappings? Our Shopify is set to Canadian Dollars and we recently activated USD payouts to a separate USD bank account. The orders on shopify are still showing currency = Canadian Dollars (and syncing to NS as CAD) even though they are placed in USD, paid by customer in USD, and paid out to us in USD.
Is there a straightforward way to map the correct currency?
e
eminero
04/22/2024, 3:02 PMI'm not an expert on the NetSuite Connector, however the currency is tied to a subsidiary, if your customer subsidiary = USA, then the currency on the transactions (sales orders) will be equals to = USD, same logic for customer subsidiary = Canada, then transactions will be placed using CAD. I would suggest to review that part.
e
Emily S
04/22/2024, 3:14 PM@eminero the issue is happening before the order hits Netsuite though, will their subsidiary currency settings affect an order which is being sent from web services with currency CAD?
e
eminero
04/22/2024, 3:19 PMYeah, review if you are sending the subsidiary as well, for example if you are displaying everything on USD on your website (I'm not sure on what depends this on Shopify) and you are sending USD but the customer has a subsidiary = Canada, then the currency sent does matter because NetSuite is automatically setting the currency based on the customer subsidiary. Probably there might be an option on the connector to set/send the correct subsidiary but make sure the customer you are using for testing matches that.
e
Emily S
04/22/2024, 3:23 PMI see, thanks for the advice, I'll have to do some testing!
✅ 1
t
thhtev
04/24/2024, 10:01 PMI don't have experience with the NetSuite connector, but the price object in the Shopify API has the values in the shop_money and presentment_money. In your case, the presentment_money is USD. You need to map the correct field in the integration.
e
Emily S
04/25/2024, 2:15 PM@thhtev the issue is specifically with connector mapping. I know the order has presentment currency on shopify, it's getting that correctly through the connector.
Right now what I have is an order paid by customer $80 USD ($109 CAD) syncs to Netsuite as $109 USD. Not exactly what I'm after.
✅ 1
s
Stewart
04/25/2024, 2:38 PMHi. You might need to set the primary currency on Shopify to USD. It looked as though the Shop currency was CAD. Worth asking Shopify support, if that is the case.
e
Emily S
04/25/2024, 2:40 PM@Stewart CAD is correct for our primary shop currency - we are located in Canada and primarily deal in CAD. Changing storefront currency is not the issue nor is it a potential solution. We are trying to map multi-currency. Both shopify and netsuite support multi-currency, I just need the two systems to talk to each other correctly.
s
Stewart
04/25/2024, 2:44 PMHi Emily,
In most places, Shopify doesn't support multiple currency as such. There is a 'home' or 'shop' currency for the store which never changes.
For us, it's GBP regardless of how the customer pays.
Presentment currency is what the customer uses, which can be EUR, USD, AUD etc. etc. for us but that's converted to GBP for our store.
I know it's a bit different for Canada where they support CAD and USD. Presumably one is the 'primary' though.
e
Emily S
04/25/2024, 2:46 PMIn this case shopify supports multi currency. Customers can pay in CAD or USD and we get paid out in CAD or USD respectively (to different bank accounts).
Like I said, shop primary currency is not the issue. It's mapping the numbers in the connector. See the image attached. I just need to configure the connector to grab the presentment currency numbers in certain cases, and I cannot figure out how to do that.
s
Stewart
04/25/2024, 2:49 PMAh... interesting. I think they're rolling out multi-currency more globally later this year, great to see it in action.
That use-case sounds like it might be beyond the Netsuite connector. I believe it's quite locked down. Though maybe worth making a support call to them.
e
Emily S
04/25/2024, 2:52 PMYeah I've got a support case open. At least the order is in netsuite in USD... since you can't edit currency on an order after it's saved, worst case I can just edit the order totals to match what the customer actually paid. But that's definitely not something I'm willing to do manually for every damn USD order 😆
Emily S
04/26/2024, 3:18 PMIf anyone is interested in the solution here, the response from support was:
> After checking this request, we have identified that our ACS/PS team best handles it. They have the knowledge and tools for the implementation and testing.
> Our ACS/PS team can be reached through your Account Manager to assist with implementing this request.
Instead of dealing with more BS via ACS I've started a quick and simple shopify app which I can send https.get() requests from a suitescript to retrieve order information. Then I can use the JSON response to update order values where needed, to match the presentment currency paid by the customer.
🙏 1
netsuite 1
✅ 1
9 Views