The only effective way to sync stock with Sage 50 correctly is to use their SDK or use a piece of middleware that a Sage50 developer has built using the Sage50 SDK.
The problem you have with trying to bypass the SDK is how Sage50 stores data which is in it's own database'y structure.
If you can get access to the SDK the documentation isn't bad but Sage 50 isn't the most "performent" system and realistically you aren't going to get a nice "real time" system with it as you are going to constantly be connecting and disconnecting to Sage to retrieve and update data.
Alot of online systems that integrate with it take the approach of sending "order acknowledgements" and later send an "order confirmation" once they've been able to confirm stock. They also have a "buffer" of stock that is ear marked for when stock levels are low as a precaution.
(fyi, this is general Sage50 knowledge as I used to create add-ons for Sage 50 and Sage 200, but not Tea Commerce knowledge as I'm yet to use that).
Yeh, spoken to Sage and the SDK is £333 + vat per month, paid annually.
A bit of a no go really for just updating stock levels.
Our other option would be like you say use some 3rd party middleware to do the syncing. But again I don't know how robust that is going to be and the level for error may be high.
The option we may go with is having no stock update on the website. The customer runs off an export daily and imports into Sage which updates their stock levels that way. I suppose stock levels aren't that important for the website as the product should still be able to be bought, it just means communication to the customer has to be paramount to inform them of a longer lead time for delivery due to ordering stock in? Not ideal but a much easier and cost-effective way to do it.
Are there any 3rd party software/middlewares you have used before that you'd recommend?
I used to right my own to be fair so can't really recommend any specific middle ware sorry, I've written a few different ones tailored specifically to their required use case including generating order entries, creating customer accounts invoices etc etc.
I believe what you are actually paying for is joining the "Developer Programme" which is annoying as you only really need the SDK but it would give you access to their development support team (which used to be much better than it is now as you can't speak to them on the phone any more, only e-mail!).
Also, something to be aware of, each time your client upgrades their Sage the middleware software will need to be updated (I never managed to get my custom ones to work in a generic fashion with their SDKs).
Presumably you want the Stock items themselves to be managed in Sage?
What would you be looking to import into Sage? Customer Accounts / Orders / Invoices?
Tea Commerce + Sage 50 syncing stock iventory
Has anyone ever integrated Tea Commerce with Sage 50 for stock inventory management?
I have a client that would like the stock levels of products to be synced with their Sage 50 2014 software which is sat on a server.
I've found a few things online to add the data to an MS SQL DB but it's read-only and non-bi directional to sync stock levels back and forth.
Sage seems to push you down the route of using their SDK which is expensive and seems overkill really to just want to sync stock inventory only.
Would be interested to hear if anyone else has come across this? Or have you used a 3rd party system similar to something like Tradebox?
The only effective way to sync stock with Sage 50 correctly is to use their SDK or use a piece of middleware that a Sage50 developer has built using the Sage50 SDK.
The problem you have with trying to bypass the SDK is how Sage50 stores data which is in it's own database'y structure.
If you can get access to the SDK the documentation isn't bad but Sage 50 isn't the most "performent" system and realistically you aren't going to get a nice "real time" system with it as you are going to constantly be connecting and disconnecting to Sage to retrieve and update data.
Alot of online systems that integrate with it take the approach of sending "order acknowledgements" and later send an "order confirmation" once they've been able to confirm stock. They also have a "buffer" of stock that is ear marked for when stock levels are low as a precaution.
(fyi, this is general Sage50 knowledge as I used to create add-ons for Sage 50 and Sage 200, but not Tea Commerce knowledge as I'm yet to use that).
Hi Nik
Yeh, spoken to Sage and the SDK is £333 + vat per month, paid annually. A bit of a no go really for just updating stock levels.
Our other option would be like you say use some 3rd party middleware to do the syncing. But again I don't know how robust that is going to be and the level for error may be high.
The option we may go with is having no stock update on the website. The customer runs off an export daily and imports into Sage which updates their stock levels that way. I suppose stock levels aren't that important for the website as the product should still be able to be bought, it just means communication to the customer has to be paramount to inform them of a longer lead time for delivery due to ordering stock in? Not ideal but a much easier and cost-effective way to do it.
Are there any 3rd party software/middlewares you have used before that you'd recommend?
I used to right my own to be fair so can't really recommend any specific middle ware sorry, I've written a few different ones tailored specifically to their required use case including generating order entries, creating customer accounts invoices etc etc.
I believe what you are actually paying for is joining the "Developer Programme" which is annoying as you only really need the SDK but it would give you access to their development support team (which used to be much better than it is now as you can't speak to them on the phone any more, only e-mail!).
Also, something to be aware of, each time your client upgrades their Sage the middleware software will need to be updated (I never managed to get my custom ones to work in a generic fashion with their SDKs).
Presumably you want the Stock items themselves to be managed in Sage? What would you be looking to import into Sage? Customer Accounts / Orders / Invoices?
If you want, DM me on twitter and we can discuss things further :-)
Cool, I'll drop you a DM now :)
is working on a reply...