We have customized AbleCommerce Gold to successfully query a 3rd party API for product base price, inventory, customer price level, item price code (which gives us the quantity discounts or markups for that customer price level to be applied to the base price of the product).
The system described above is working correctly, but we would like to cache the data into SQL to speed up the website and eliminate the possibility of failure should the 3rd party system go offline.
Since all the queries above are working, they can be used to build an import routine that iterates through Ablecommerce for every product/variant SKU, Customer ID (custom field in AC), and imports the applicable pricecodes, price levels and discounts. We would like to have this scheduled and also available to run on-demand from a web interface.
When complete, the existing calls to the 3rd party system's live data will need to be replaced with queries to the imported data for calculations and display on the website.
To summarize: products/variants are setup in AbleCommerce/SQL, but prices, discounts, and inventory are pulled from a 3rd party ERP. The reason we don't store everything inside A.C. is, AC doesn't allow for negative discounts (markups). If it did, we might pull everything into AC, and add a custom field for Product Price Code. We are already caching customer price live to SQL, as well as the customer's userID for the 3rd party system.
Contact me if you are interested, and I will provide more info about the 3rd party system, code samples, end-user views, and anything else required to estimate and deliver the project.