Trying to Accomplish:
I would like my WIX store to communicate with a Microsoft SQL application (slightly different than mySQL) in order to read inventory levels from our existing database.
If that is impossible at this time, at the very base level, I need my WIX store to read a continuously auto updated CSV file.
What I understand:
Very little about direct coding.
There needs to be a translator between the WIX API and Microsoft SQL, as well as coded information on both ends.
The basic use of a CSV file for inventory purposes in the WIX store editor – I do not wish to update an Excel spreadsheet daily when there is already an inventory system in place.
This is a larger business with four physical locations.
Our system integrates with Microsoft Office, not Google.
What I need:
Resources from people who have achieved WIX store integration with an inventory application based in Microsoft SQL.
Perhaps some sort of guide on this subject matter.
Something more direct than the Corvid by Wix, Corvid: Working with External Database Collections, and API resources I have already found and been directed to. – Wix Support has also been fruitless.
A couple of questions:
Are there example codes for the differing APIs and the translator floating around the internet?
Is this a common practice with WIX stores? - integrating with third party inventory software