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