I use Quickbooks Point of Sale with THUB order manager inventory sync ( a 3rd party program) THUB is actually what will post the prices, and you can use it with regular quickbooks too. It’s kind of a buggy program so can be super tedious sometimes in and of itself, but it does the trick. ECC is another program from Webgility that can achieve this kind of functionality, and I hear it’s more stable in some regards.
I was trying to the same thing with leaving the special price field blank and using the catalog price rules only initially, but after realizing my special prices weren’t feeding to my data feeds using this method, I broke down and started using the THUB functionality to update the prices.
I’ve contacted my hosting provider to see if the catalog price rules ‘special prices’ are stored somewhere usable, but they are still “investigating” it.
I’m using GoDataFeed and they can pull in any field from Magento provided I can supply it, so that is why I started this post to see if someone knew where catalog price rules stores those ‘special prices’ - since they don’t really store in the admin’s special price field.