Is it possible to set up an API or EDI for our shipping software (MercuryGate) so we can provide the most accurate shipping prices at check out?
1 Like
Could you elaborate on that, without making suggestions for solutions? Just tell us what you have, what you want to achieve (or, what the current problem is you are trying to solve) and then we might be able to help you. As for me, I haven´t got the foggiest what MercuryGate is).
Well… I don’t really know how to explain it because it’s way beyond my technical skill set, but I’ll try to explain!
We have products on our site that will require freight shipping because they are so large. Freight costs totally depend on the shipping destination, and can vary by hundreds of dollars, so we were hoping we could have a developer create a link from Wix Ecommerce to the shipping software, MercuryGate. We’re not even sure if this is possible with Wix Code, but the normal support line said to check in here to see if that ability is available at this time!
Hope that helps a little!
I think I understand: your current software (MercuryGate) does not offer the possibilities you need and you wonder if you can somehow solve this with Wix Code?
To reduce the problem to its core, you want to ADD some calculations/decisions to MercuryGate. If this is at all possible, depends solely on the fact if MercuryGate offers you possibilities to do so. These possibilities are usually referred to as an “API”, an interface between MercuryGate and the outside world.
If, for instance, MercuryGate would offer clients API-access to its shipping order table, one would be able to retrieve some order, do some custom calculations re shipping costs and means of transport and then WRITE the changed data back to MercuryGate.
So, in short, MercuryGate should offer an API that lets you retrieve and write shipping orders, at least.
Most interfaces (API´s) are either XML or JSON-based (those are standardized formats to exchange information between 2 systems, but there are others). Wix Code has implemented “fetch”, which allows you to perform HTTP PUT, GET, UPDATE and DELETE, a method that is simply URL-based. In what form the response then comes back (JSON, XML, CSV) is irrelevant, although Wix Code has no native support for XML, for that you have to jump thru hoops.
Thus: inquire with MercuryGate if they offer an API to their (well, your) data. If so, ask documentation. Then repost and we will see what we can do from that point.
I have tried to make this as non-technical as I possibly could. Does it make any sense at all?
Yes, this does help, thank you for explaining. I do have one question though, just to make sure I’m on the same page: if MercuryGate does have an API and everything works on their end (which I will confirm and get documentation if so), Wix Code would be able to fetch the custom calculated shipping price from MercuryGate, and add it to the order total shown in the normal Wix ecommerce check out?
I contacted MercuryGate and asked for API documentation and they sent me PDFs that may or may not be helpful. I don’t know that I can upload them to this form though, it is not letting me upload documents. Is there a way I can send this to you?
Hi, I too have similar use case, that I need to fetch shipping cost from external system and display in my wix store checkout page. Is this possible yet on wix ?
Please add a new post instead of bumping up an old thread from 2018.
Add a link in your new post to refer back to older posts if needed.
You can use Wix Fetch add Wix HTTP Functions to expose your site.
https://www.wix.com/corvid/reference/wix-fetch.html
https://www.wix.com/corvid/reference/wix-http-functions.html