I have been asked to add a shopping cart to an existing website and the company uses Sage Line 50 to hold details of their stock, etc.
I have experience with MySQL and I've been told that sage uses odbc. Can anyone recommend the best way to do this?
Thanks in advance
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Using Sage Line 50 with a Website
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: Using Sage Line 50 with a Website
There is no BEST way, there are lots of ways.
We do integration an service so we can get data in and out of Sage via files on your web server.
Depending on the application and the amount of data this can be done lots of different ways, we have one that uses a csv files that is read by a perl script to make web pages. It would be awful if you had a lot of data.
There are some people doing .net stuff to integrate real time with sage.
Our approach is simple, we take data out of sage eg stock records/details/description and upload them toy your webserver via ftp. Perhaps hit a url to kick a process to update an sql database.
In reverse the site could make emails, or csv files for each order which we would load into sage.
We do integration an service so we can get data in and out of Sage via files on your web server.
Depending on the application and the amount of data this can be done lots of different ways, we have one that uses a csv files that is read by a perl script to make web pages. It would be awful if you had a lot of data.
There are some people doing .net stuff to integrate real time with sage.
Our approach is simple, we take data out of sage eg stock records/details/description and upload them toy your webserver via ftp. Perhaps hit a url to kick a process to update an sql database.
In reverse the site could make emails, or csv files for each order which we would load into sage.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Amazon [Bot] and 17 guests