I want to create a database using an inventory feed Import that will be refreshed daily by the inventory feed provider through an FTP.
I have looked in the database settings but was unable to find a place to give an FTP access. Does anyone know how that would work? I would hate to manually upload the database on an everyday basis.
there is no FTP access in Wix Code. But you may want to explore several other options:
In Wix Code you can access external services via HTTP. So, if you can access the feed as a resource on web, you can write some code that would do import for you.
We have exposing web services (compute functions) from Wix Code on our backlog, this would allow your provider to actively notify you about the new items.
If you have any further questions, I would be glad to help.
You could write some code using the wix fetch while waiting for compute function. Maybe in the hook before query you can import all data from csv and the reload the dataset and voila.