Update WooCommerce website products and connect to eBay API Product Import
Budget: £250 – £750 GBP
I have a website which I have previously set up an api for to connect with my suppliers website for updating the stock levels of products. At some point my supplier updated their website and api which broke my custom coding and I have not updated it. The previous setup was via CRON job but it was a poor job and kept storing the retrieved zip file without deleting it once it had been updated causing storage issues.
Now I am looking to update the items on my website with the current inventory and then also connect my woocommerce store with my ebay account and put all of the products on there.
The supplier provides an excel spreadsheet which has approximately 93k rows.
As far as I can tell the best way is to import these products into woocommerce and then use my website to update the ebay stock levels. I have a server plan which hosts multiple websites.
I'm looking for a skilled developer to help me import products to my WooCommerce store and to eBay via API. The task includes real-time stock level checks and updates.
Key requirements and tasks include:
- Cleaning up the products on the current website. This includes deleting any discontinued products, updating current products, fixing any taxonomy issues with the product data etc
- Pulling product data from my WooCommerce store, which is backed by a MySQL database.
- Setting up the eBay API for product listing.
- Implementing real-time stock level checks and updates to ensure eBay listings are always up to date.
- Ensuring a smooth, efficient and error-free product import process.
Ideal skills for this project:
- Proficiency in WooCommerce and eBay API.
- Strong knowledge of MySQL.
- Experience with real-time data updates.
- Ability to troubleshoot and resolve issues promptly.
Please find attached a sample of the product spreadsheet.
My supplier provides the following instructions for api:
Live Stock API Call
The API Call to retrieve live stock is a GET request to https://www.pencarrie.com/api/public/v1/stock.csv with an Authorization header of Bearer $TOKEN, where $TOKEN is the access token created above.
The response is a CSV of free-to-sell stock levels for all SKUs, where values over 500 are replaced with “500+”.
The equivalent call using cURL is: curl -X GET https://www.pencarrie.com/api/public/v1/stock.csv -H "Authorization: Bearer $TOKEN"
Now I am looking to update the items on my website with the current inventory and then also connect my woocommerce store with my ebay account and put all of the products on there.
The supplier provides an excel spreadsheet which has approximately 93k rows.
As far as I can tell the best way is to import these products into woocommerce and then use my website to update the ebay stock levels. I have a server plan which hosts multiple websites.
I'm looking for a skilled developer to help me import products to my WooCommerce store and to eBay via API. The task includes real-time stock level checks and updates.
Key requirements and tasks include:
- Cleaning up the products on the current website. This includes deleting any discontinued products, updating current products, fixing any taxonomy issues with the product data etc
- Pulling product data from my WooCommerce store, which is backed by a MySQL database.
- Setting up the eBay API for product listing.
- Implementing real-time stock level checks and updates to ensure eBay listings are always up to date.
- Ensuring a smooth, efficient and error-free product import process.
Ideal skills for this project:
- Proficiency in WooCommerce and eBay API.
- Strong knowledge of MySQL.
- Experience with real-time data updates.
- Ability to troubleshoot and resolve issues promptly.
Please find attached a sample of the product spreadsheet.
My supplier provides the following instructions for api:
Live Stock API Call
The API Call to retrieve live stock is a GET request to https://www.pencarrie.com/api/public/v1/stock.csv with an Authorization header of Bearer $TOKEN, where $TOKEN is the access token created above.
The response is a CSV of free-to-sell stock levels for all SKUs, where values over 500 are replaced with “500+”.
The equivalent call using cURL is: curl -X GET https://www.pencarrie.com/api/public/v1/stock.csv -H "Authorization: Bearer $TOKEN"