Shopify API
Budget: $250 – $750 USD
I have a client with a very old order-system. The old order-system is HTML-based (created 20-years ago) and use an MS SQL-server. In addition they have an MS Access-system which is connected to the SQL-server through ODBC. They have clients who can register orders. When they work with the orders they use MS Access. (you do not need to know MS Access for this project!)
My clients job is then to organize the distribution of the order. They use a special made logistic system for this which creates labels they can put on the packages and which sends the shipping-order to the transport-companies. Back from the transport-companies comes a "transport-id". Today we have a system (part of MS Access) to import those IDs so they will end up in the SQL-server.
The challenge is that they have a request from a company who use shopify.com as their order-system. They are asking if my client can distribute the products.
For that to work my client will need to log in to the customers shopify-account and download the orders. Then those transport-IDs needs to be updated in shopify. The customer with the shopify-order-system also needs to be able to track the orders they get in and they do not have access to my clients systems...they must find all relevant info in their shopify-account.
So - basically - we need 1 program to download orders from shopify to an SQL-server and 1 program to upload transport-IDs. from the SQL-server to the shopify-account. I imagine programs windows-scheduled on their MS SQL-server which will run regularly and download and upload.
My clients job is then to organize the distribution of the order. They use a special made logistic system for this which creates labels they can put on the packages and which sends the shipping-order to the transport-companies. Back from the transport-companies comes a "transport-id". Today we have a system (part of MS Access) to import those IDs so they will end up in the SQL-server.
The challenge is that they have a request from a company who use shopify.com as their order-system. They are asking if my client can distribute the products.
For that to work my client will need to log in to the customers shopify-account and download the orders. Then those transport-IDs needs to be updated in shopify. The customer with the shopify-order-system also needs to be able to track the orders they get in and they do not have access to my clients systems...they must find all relevant info in their shopify-account.
So - basically - we need 1 program to download orders from shopify to an SQL-server and 1 program to upload transport-IDs. from the SQL-server to the shopify-account. I imagine programs windows-scheduled on their MS SQL-server which will run regularly and download and upload.