Business Central Shopify Connector Inventory issues

[DRutstrom]

So we are trying out the Shopify connector in Business Central on a Shopify sandbox. We're getting almost everything to work except inventory.

On some products with zero (0) in stock, nothing inbound, it displays 55 in Shopify on one item, and 22 on another.

On one item that we have 30 in stock, 120 on order, it shows 150 in stock. It kind of makes no sense to me and I have a hard time finding any settings, and in my monkey brain, the displayed stock should reflect, well, the current stock level.

Anyone faced this issue or have any recommendations on where to start digging? Our BC partner is no help.

[D365BC_Shpfy · Accepted solution]

Hey DRutstrom,

You have probably already worked this out, however, I just recently completed this migration myself and I had the same issue.
I believe you need to set up the Shopify Shop Location via Shopify Shop --> Select the Shop --> Locations

Define the location of where your inventory is being managed and tick "Default Product Location"

 

Hope this helps

Thanks

D365BC_Shpfy

[DRutstrom]

Thanks for your reply! Yes, we figured out the stock solution. However, we're stuck at another problem with currency as all orders are imported in the Store base currency, which doesn't work out when we sell globally, with markets in different local currencies. LCY in BC just reverts to the base currency in the store. Even though you can see in the JSON data that the correct currency is imported, but it reverts to the base currency.

[D365BC_Shpfy]

Hey DRutstrom,

I have had a look at the code and can see it currently defaults to the "Currency Code" defined in the Shopify Shop.

If the "Currency Code" is blank, it will default to the "LCY Code" in your General Ledger Setup.

Can you please confirm the "Currency Code" is defaulting to the "LCY Code" upon synchronising from Shopify to Business Central "Shopify Orders"? (This is before the actual Business Central Sales Order is created)

If not, I would suggest the following BC customisation:

1) Add a new field "Country Code" in the Currency table and Currencies Page and map the corresponding Currency Codes with the Country/ Code.

2) Write code that when the Shopify Order is converted to a Business Central Sales Order, to check the country code and convert accordingly.

Of course, this will need to be thoroughly tested to confirm it works accordingly.

Hope this helps

Thanks

Jeremy

[DRutstrom]

Hi,

I really appreciate your reply! It defaults to the Shopify store base currency, not BC's base currency. We have basically all currency codes already setup in BC as we use a different connector right now but we'd like to go as "native" as we can since everything we need, other than the currency seem to be available in the built in solution.

We do not have any inhouse development so we're not that keen on doing any customisations ourselves, but from what I understand, you are a Shopify Partner? Is this a task you'd be interested in working out for us?

[D365BC_Shpfy]

Hey DRutstrom,

I have sent you a pm, I will take a look for you over the weekend.

Thanks
Jeremy