Display stock levels from Sage Accounts onto Website

[ChrisLambert]

I've been asked by a client if there is any software that would allow their customers to view current stock levels with the information taken from Sage 50 Accounts.

Sage is stored on an onsite server, not the cloud version.

I thought i'd put the question to the hive mind to see if there was anything anyone can recommend and reduce the amount of time I need to spend going through various websites to find the software doesn't do what we want and I'm getting sales call/email.

 

[fisicx]

If you can access the DB you can run an sql query. More difficult if it’s on a local server as this needs to connect to the internet.

What sort of website do they have?

What sort of budget do they have?

 

[johndon68]

Sage 50 has an ODBC driver that can be used to extract the relevant data.

Sage have an 'Additions' service that lists known add ons from Sage Developers although the ODBC driver can be used by anyone, you don't have to be a member of Developers Programme.

SAGE UK Marketplace | Sage UK

Sage UK Marketplace is a web-based application listing both Resale and Referral ISV Partner applications that integrate with Sage cloud products. It allows you to discover, use and manage business applications in one simple and secure site, from anywhere

my.sage.co.uk

John

 

[JEREMY HAWKE]

If your planning to use Sage it would be a benefit if all concerned migrated onto cloud storage.

 

[ChrisLambert]

If your planning to use Sage it would be a benefit if all concerned migrated onto cloud storage.

They're already using Sage Accounts, but the director doesn't trust the cloud. I've shown him the benefits of cloud and how secure it is when done correctly, but he's been burned in the past and now doesn't want to go cloud.

It took years to get them to trust Microsoft 365 for emails.

 

[ChrisLambert]

Sage 50 has an ODBC driver that can be used to extract the relevant data.

Sage have an 'Additions' service that lists known add ons from Sage Developers although the ODBC driver can be used by anyone, you don't have to be a member of Developers Programme.

SAGE UK Marketplace | Sage UK

Sage UK Marketplace is a web-based application listing both Resale and Referral ISV Partner applications that integrate with Sage cloud products. It allows you to discover, use and manage business applications in one simple and secure site, from anywhere

my.sage.co.uk

John

Thanks, I'll have a look through and see if anything fits the bill.

 

[johndon68]

They're already using Sage Accounts, but the director doesn't trust the cloud. I've shown him the benefits of cloud and how secure it is when done correctly, but he's been burned in the past and now doesn't want to go cloud.

It took years to get them to trust Microsoft 365 for emails.

Even with Sage 50cloud, although a copy of the data is held in the cloud that is solely for the purpose of syncing across multiple sites, the extraction of any data would still have to done locally, the data in the cloud cannot be accessed via the ODBC driver.

John

 

[JEREMY HAWKE]

They're already using Sage Accounts, but the director doesn't trust the cloud. I've shown him the benefits of cloud and how secure it is when done correctly, but he's been burned in the past and now doesn't want to go cloud.

It took years to get them to trust Microsoft 365 for emails.

You have the same problem as me
Despite being the most experienced No fecker wants to take your advice

 

[Total Barcodes]

I've been asked by a client if there is any software that would allow their customers to view current stock levels with the information taken from Sage 50 Accounts.

Sage is stored on an onsite server, not the cloud version.

I thought i'd put the question to the hive mind to see if there was anything anyone can recommend and reduce the amount of time I need to spend going through various websites to find the software doesn't do what we want and I'm getting sales call/email.

Hi Chris

This is something we have done a few times for clients. If you want to get in touch to discuss, please DM me

Regards