Opencart API Acces to allow multi-channel selling
Posted: Tue Apr 20, 2021 6:51 pm
Hello.
We have an Opencart store connected to eBay and Amazon using Openbay Pro which for the most part is working extremely well. Orders from all three sources come through as Opencart orders and the stock management across all three systems is well synchronised.
Outside of this we have our own internal ERP system which is a MySQL database back-end with a Microsoft Access front-end as well as a PHP/MySQL web-based front-end.
Stock changes made on our internal system can be transmitted to the Opencart db using typical DB queries through our web-based front-end but the problem we are having is that these stock changes are not carried through to eBay/Amazon because they're done in the back-end database rather than through the Opencart Front-End.
Does anyone have any better solutions for how we can manage this?
Do I need to setup API access to Opencart rather than just updating the quantity fields in the oc_products table? Is there something else I can do that will trigger an Opencart front-end update rather than having my staff update the local system then have to manually login to Opencart to re-confirm the same changes?
We have an Opencart store connected to eBay and Amazon using Openbay Pro which for the most part is working extremely well. Orders from all three sources come through as Opencart orders and the stock management across all three systems is well synchronised.
Outside of this we have our own internal ERP system which is a MySQL database back-end with a Microsoft Access front-end as well as a PHP/MySQL web-based front-end.
Stock changes made on our internal system can be transmitted to the Opencart db using typical DB queries through our web-based front-end but the problem we are having is that these stock changes are not carried through to eBay/Amazon because they're done in the back-end database rather than through the Opencart Front-End.
Does anyone have any better solutions for how we can manage this?
Do I need to setup API access to Opencart rather than just updating the quantity fields in the oc_products table? Is there something else I can do that will trigger an Opencart front-end update rather than having my staff update the local system then have to manually login to Opencart to re-confirm the same changes?