We have customized the latest version of AbleCommerce to successfully query a 3rd party API for product and customer info.
... Existing queries can be used to build an import routine that loops through Ablecommerce for every SKU and customer, and imports the needed info to SQL. ... I have attached the code that does the real-time queries, and below you will find more information on the fields/tables:
In Sage (MAS90):
From CUSTOMER query, we use the AbleCommerce UserSageKey to lookup
-CustomerPriceLevel (I believe it's A,B, or NULL)
From ITEM query, we use the AbleCommerce.ProductVariants.SKU to lookup:
-StandardUnitPrice (base price, from which customer-specific volume discount levels are calculated)
-PriceCode (this, along with the CustomerPriceLevel, allows us to lookup the volume discount quantites & rates)
From ITEMWAREHOUSE query, we again use the SKU to lookup:
From ITEMPRICECODE query, we use the previously queried CustomerPriceLevel and ItemPriceCode to lookup
-Quantity/discount breaks for calculating the price.