I currently have Sage MAS200 SQL (with eBusiness and full support) and looking to launch a consumer ecommerce site. I also have an old website (we took it offline to focus on distribution) written in ASP. The site is from 1998. We now want to launch a new site. I was thinking of running the whole consumer site on PHP/MySQL, but willing to consider ASP.NET. I have the following questions:
1) What is the best way to integrate the MAS200 SQL database with PHP?
I want to be able to update the online database with current inventory and to be able to transfer order information from the online database to MAS200. Basically, I want to use SAGE as our backend. Currently, we use Starship for shipping. Sage really only needs the basic info (like the item, how many of the item and where the item is going) with the rest of the info (like customer tracking and item information) will stay on the the MySQL.
2) Is it worth using the old ASP site or should I just look to reprogram the whole thing?
Thanks,
Casey
You can look at our wholesale site at www.prolificart.com. It is run using Sage's eBusiness.
------------------------
General MAS200 info http://www.sagesoftware.com/mas90/
ProvideX ODBC http://www.pvx.com/
eBusiness http://www.sagesoftware.com/products...null/product/2 8  13038 
I don't know much about Sage. Could you help me understand it by answering the questions below?
Sage isn't a database in itself is it? Is it just an application platform based on SQL Server right?
Sage is an ERP. We have it set up on a SQL server locally. I do NOT want to host the commerce site locally (we get knocked offline a lot.) In fact, I want the ecommerce site to have as little to do with Sage as possible.
I don't know much about Sage. Could you help me understand it by answering the questions below?
Sage isn't a database in itself is it? Is it just an application platform based on SQL Server right?
Alright I get what you are trying to do:
Basically you want MySQL/PHP to run your ecommerce site, and then have the basic info (like the item, how many of the item and where the item is going) sent to SAGE via PHP. Right?
It can be done.
The solution i would use is setup a secure server (https) with certificate. Everytime a transaction is completed on the ecommerce site, have it create an xml file with the item ordered, quantity, and delivery address and store it on that secure encrypted ( https://www.yourstore.com/orders/recentorders.xml). From your local server ping that xml file every 1-2 hrs(time really depends on your needs) grab the latest info and submit into the SQL SQL server database running your ERP.
Does this answer your question? It's a simple solution using XML instead of direct interfacing.
Alright I get what you are trying to do:
Basically you want MySQL/PHP to run your ecommerce site, and then have the basic info (like the item, how many of the item and where the item is going) sent to SAGE via PHP. Right?
Exactly, I want to figure out a way to NOT use SAGE for ecommerce programming. It's good at accounting, but....
It can be done.
The solution i would use is setup a secure server (https) with certificate. Everytime a transaction is completed on the ecommerce site, have it create an xml file with the item ordered, quantity, and delivery address and store it on that secure encrypted (https://www.yourstore.com/orders/recentorders.xml). From your local server ping that xml file every 1-2 hrs(time really depends on your needs) grab the latest info and submit into the SQL SQL server database running your ERP.
Does this answer your question? It's a simple solution using XML instead of direct interfacing.
Thank you! That sounds perfect. Almost too easy. I sent my proposal to a couple of development firms and they were terrified of the MAS200 interfacing. Maybe I just wasn't all that clear.
Two more questions. Could I do the opposite (say I wanted to update the qty on the site)? And could I get the info as a batch (say all orders on Sat)?
I don't see why you couldn't get the orders as a batch.
On the other question regarding updating quantity. There are one of two ways of doing it. - Manually
- Create an interface in the ecommerce software (it should already have this) that allows you to update quantity.
- Automatically
- If you have a dedicated ip/domain on the net that resolves to your ERP solution server. You could setup a webserver on it and do the same thing in reverse with the xml files and php code(ecommerce site requests ERP server for quantity information).
- Otherwise with some simple php code on your local host you can create an xml file with updated quantity information and upload it via php's ftp functions to your ecommerce server/site. Very doable, and easy.
Make sure your connections are secure and encrypted.
I wanted to get everyone's feedback on whether this made sense.
(See attached database.pdf)
Thanks,
Casey
You did an excellent job with the diagram. I am Impressed.
You did an excellent job with the diagram. I am Impressed.
hi, you can buy a couple of sage ready ecommerce carts with product csv upload and xml download. you can upload your stock data and download SOP's based on website orders.
see:
this is a developer using oscommerce to link to sage:
www.ibexinternet.co.uk/sage-integration.html
this is a sage enabled shopping cart:
www.actinic.co.uk/products/link.htm
Sign in to post your reply or Sign up for a free account.
Similar topics
by: eSc |
last post by:
I am trying to connect to Sage Line 50 data files through odbc
driver (SageLine50v8) from php5 (running on windows xp pro) by
odbc_connect().
Unfortunately I can not find right connection string...
|
by: Sai Hertz And Control Systems |
last post by:
Dear all,
Their was a huge rore about MySQL recently for something in java functions
now theirs one more
http://www.mysql.com/doc/en/News-5.0.x.html
Does this concern anyone.
What I...
|
by: Phil |
last post by:
My mission is to get some data out of a sage application, via a very
complicated query, into a csv file.
My approach, so far, has been
1) link access tables to the sage application
2) build...
|
by: cheungs7 |
last post by:
Hi all,
Wondering whether you can anyone help me. We have Sage Payroll (and
accounting/payroll software), which has a MS Access database where the data
is stored.
Now I want to access the...
|
by: kj |
last post by:
Hi people,
newcommer here, i know a little ms programming but am new to sage,
Is it possible to connect to sage line 50 with ms access?
TIA
Keith
|
by: Duncan |
last post by:
Dear friends,
I have a client which would like us to post data into SAGE Line 50. Are
there any API or Controls or methods out there that you know off which would
help us achieving the task
...
|
by: el chupacabra |
last post by:
Everytime I want to enter to a textbox area "it's fun" (no quotes) I get an error.
"Problems with Query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL...
|
by: marc.holt |
last post by:
Please help!
I am attempting to extract data from a Sage Line 50 database ( .dta
extention) via an ODBC connection. Included in the application
install of Sage Line 50, is an ODBC driver.
I...
|
by: jadamwilson2 |
last post by:
Hello,
I have recently become interested in using python for scientific
computing, and came across both sage and enthought. I am curious if
anyone can tell me what the differences are between the...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
