You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
In V9 Where do you go to update an order sent to T-Hub (True/False)
Had a problem with T-Hub and I need to pull some resent orders
Offline
(1) Access Store / Component / Settings / Extension Module: T-Hub Connector and note the 'Accounting System Data Storage Slot' for THUB.
(2) Access System / Database / Raw Database Admin then the Submit Raw SQL Statement function. If the data slot being used above was the Primary slot, use this SQL to reset the order so it can be exported again. The order number in this example is 'XXX':
UPDATE ecom_orders SET acctsyspri='' WHERE id='XXX'
If the data slot being used above was the Alternate slot, use this SQL to reset the order so it can be exported again. The order number in this example is 'XXX':
UPDATE ecom_orders SET acctsysalt='' WHERE id='XXX'
Offline
Thanks Nick
Can you include an exported to T-Hub Flag (True/False) in orders in next maintenance release like in V8?
Would make things a lot easier
Randy
Offline
Thank you for the request, but that's not going to happen. K9 supports integrations with two accounting systems simultaneously. Those primary and alternate connection details are embedded throughout the software for all different types of data. The K9 core itself is not going to contain any module-specific flags for accounting system integrations. The intention is to use one or the other of the data slots based on settings.
This type of setup makes it easy to migrate to different accounting systems or use different connection types. When you get tired of THUB bastardizing your data on the way into QuickBooks, and are ready for a heavier/better integration, you'll likely want to use the QuickBooks Web Connector extension module, which plugs into K9 the same way the THUB module does.
We could make a THUB helper that does this for you in an easier fashion, but a client would have to sponsor that.
Offline