AS400 Integration to E Commerce Website

AS400 Integration to E Commerce Website

Client Summary

  • Client is an American furniture, mattress, electronics and appliance store chain headquartered in The Woodlands, Texas, United States
  • Their annual turnover is US$ 1billion and employees over 5000 people

Executive Summary

  • A 125 years old company founded in Texas. One of the top consumer goods retailers with more than a Billion USD revenue. The client would like to achieve the seamless integration between AS400 servers and customer-facing E-commerce website to update the product data and maintain the information in a single repository.

Business Challenges

  • Adding stock from AS400
  • Adding new stock detail from AS400 server
  • Adding item images
  • Adding item quantity and price
  • Updating stock information from AS400
  • Updating stock information from AS400
  • Updating item price and quantity

Tool Used

  • PHP and OPENCART
  • MySQL

Solution

  • Stock details will be exported from AS400 files
  • Exported file contains item style, size, type, quantity, and price/li>
  • The exported file will be uploaded into an FTP server with a specific name along with each item's image
  • An automatic schedule job from the B2B site will read the uploaded file from FTP and parse the information to add item name, style, price, quantity to the B2B site database
  • Updated Stock details will be exported from AS400 files
  • Exported file contains an updated item style, size, type, quantity, and price
  • The exported file will be uploaded into an FTP server with a specific name along with each item's image
  • An automatic schedule job from the B2B site will read the uploaded file from FTP and parse the information
  • Parsed item details will be updated into the B2B site database if the stock style is already exist

Benefits

  • Open Source / Cost Effective
  • Flexible Framework
  • Reusable component
  • Reliable payment gateway /SSL certificate
  • Automated Job Schedule to run in a certain frequency
  • Automated process to add each information which is exported from AS400 to B2B site