ODBC to Woocommerce connection for automatic inventory control
Budget: £250 – £750 GBP
I have a CRM/stock management software (Ibcos.com) that contains all my products and their current stock quantity.
I have an OBDC connection to the software's database that I can use to view and filter my live inventory in excel outside of the softwares UI. Please see this video of how I connect to the CRM database via ODBC to view the database within Excel (https://youtu.be/vb5cZUSlMP0). This is just for reference, the project can work by any means.
I wish to be able to update my WooCommerce website's stock with the stock levels from my CRM software on an automated schedule. I can/will set my SKU's on the WooCommerce to match the CRM software but need help with the link between two systems.
I have an OBDC connection to the software's database that I can use to view and filter my live inventory in excel outside of the softwares UI. Please see this video of how I connect to the CRM database via ODBC to view the database within Excel (https://youtu.be/vb5cZUSlMP0). This is just for reference, the project can work by any means.
I wish to be able to update my WooCommerce website's stock with the stock levels from my CRM software on an automated schedule. I can/will set my SKU's on the WooCommerce to match the CRM software but need help with the link between two systems.