Payless Computer’s System Manual Entity Relationship Diagram
Environment: IE6.0, MS-Window XP Professional, PHP 4.5.5, AJAX ,MySQL 5.0.27, AppServ Open Project 2.4.8, and EBAY API (SOAP).
User Manual. Menu – Search Item – After entering the Keyword the program will direct you to the View&Edit Item page. If the item you are searching for is already in the database they will be shown up on the View&Edit page.
Add Item – It was designed to add a new item into the database. You can load the data from Ebay by entering the Item No. Then click on the “Load Data From Ebay” Button. The program will send a SOAP message to EBAY Web Service to fill out the necessary fields. After you click on the “Load Data From Ebay” Button, the program will check in the Database whether the Item you are trying to add is already in the database or not. Don’t violate the constraint by trying to add the same Item No into the database. If the all of the necessary fields are filled correctly, click on the “submit” button to insert the item into the database. After it „s done, you can go to the link provided below to create a new order including the item having been added to one of the item belong to the new Order.
Example: Item NO: 270102042066 then click "Load Data from Ebay" If the Item is not in the Database this is what you will see.
If the Item is in the Database this is what you will see.
If the Item is not in the Ebay database,
View&Edit Item – You can restrict the output from the keyword provided. You can also create a new order. (If the item you are trying to add is in the mySQL database. You can add a new item first)
Create Order – After filling form, the Order status will be “Waiting for payment” and then you can click on the Link shown to receive payment. The Item(s) adding to the Order must exist in the database, otherwise the application will not allow you to create the order. Be careful before adding any items!!. Be advised to use search Item page first then click on the link to create a new order from that page so that you will be sure to make no mistake due to typing error.
After submitting the order, click on the Make Payment to proceed the next step.
Receive Payment – After the new Order has been initiate, it will be place on the “”Waiting for Payment” status. You can see every orders being on the “Waiting for payment in this page”. Fill out all things required. For the Check payment, after submitting the form, the order will be place on the “Waiting for check to be cleared” status. Unlike the other payment type that the order will be placed on the “Waiting for shipping”, the order will appear on the “Item PAID on check” page.
Items Paid On Check cleared Once paypal approved the check payment, you can proceed the next step(Shipment) by click on the Clear Payment to move the order from “waiting for the check to be cleared” status to “Waiting for shipping” status. Ship Item(s) – All of the orders waiting to be shipped will appear on this page.
Then Click on the Order you „d like to ship.
View/Edit Order – This page will help you to find, view and edit the orders. Limit the results by using some searching criteria. All of the orders‟ parameters are editable in this page. Please be careful before making any changes. Enter the search criteria
Click On view
Click on Edit
Monthly Report – The report can be printed through this page, Also the excel report can be created.
Parameters that might be changed unexpectedly and cause the program to work improperly. - $APPS/GetItem/variables.php -- These will be used to connect to EBAY API. The keys below can be obtained from http://developer.ebay.com/common/api The keys might be valid until the middle of next year. o $devID = 'E7JQYNEL18NBFAW1ECEZX1KKP7Q8GG'; o $appID = 'PAYLESSC5IFECD9IA611S3K7ICMD53'; o $certID = 'D39SN28126R$9642N72G6-3DQ32474'; o $serverUrl = 'https://api.ebay.com/ws/api.dll'; o $userToken = 'AgAAAA**AQAAAA**aAAAAA**3poBRg**nY+sHZ2PrBmdj6wVn Y+sEZ2PrA2dj6wJnYOoCpmKowSdj6x9nY+seQ**eiwAAA**AAMAA A**152vQDCViwaDgz5HzSA5Ov5eerVBh24tHXHM0c7+jgB4fPMpVO igUJKsySDY2PWlkOruk789jrgiZ81zpihsUbnwm1+f7KZJyvIoF/8DcwH Vo+3SnXvuo9Tngl9CyGFXwuBfhQK7ybqE/iEBwdiCqu1DjDcccHAZi VoLPM8C+9k1tTot752Q1qaZPF6qe9vG77c59Pr7xJWpk0GsjbgRtmNFp 5a87lrg+5EjV9im7JOBn3IQ1c/ItuNX3exWWoauLO6P96r4II0qVeaN1zx oXxA8xpeMdAXcHd2y0bv3HNbacsbWK2bGQCKzwBZE+LW6+qioxh 28egq1c3SRIwkn2veoES3rg8FFXjTS9L1+ItQTHtqPtHi1JZxi7P/2stFxzO pPr3WaskklKmTEld4aJ9cjnwpEi7ZyR/L/d0AMXjDsOLQUNPFGw9Bib 7TrLmTZ1HTAt+qyggmwULOC1e10ZXrVFEwrCosiFmDB4hZbxbzlqc d+dh0AGEXZVro2r7OEHYMkTLchj/KKB65pEHd4iM15wY13tZfCz2jF TVJoMB82V7VqLJBoCTec7xd/vggDpaf52gxp+s0GPVudEJB40pA+1vS lOb1LQDNLGQTkR2+u6Spi9OQKqrqxBu8ZsdbYcTef591ugmb/dSmEU Z2Zltlz7zH8hIoxHA9nKZkMbpISc7czdcFbyjUho8E9PJXXZo7QCFS6J NvweTSyg44VYtR/ttNjugZYhFsSWD4JlLAHMkr43AsNdTj7RPyhBwO i'; - $APPS/GetItem/load_from_ebay.php o $titleNode is the parameter that use to show the Item name. If the name of the Item loaded through SOAP does not match the Item No on the Ebay website you might try to make change the number below. For example, from $titleNode[4] to $titleNode[5]. echo '
', $titleNode[4]->get_content(), " ($item_no)"; - To use the Web Service, The Application Server must support o extension=php_curl.dll o extension=php_domxml.dll You can enable these features through $OS_HOME/php.ini. After making any changes, restart the Apache Webserver always. MySQL admin o Go directly to http://localhost o phpMyAdmin Database Manager o Backup, Import, Insert, Delete, Update and Edit DB schema through the website Developed on PHP 4.5.5, MySQL 5.0.27 and AppServ Open Project 2.4.8. http://www.AppServNetwork.com
-
How to rename or add the EBAY seller’s name
Browse to the URL http://payless_srv/phpMyAdmin/ to manage the database. Username: root Password: root
Select the database “TEST”
Click on “Account“ table
Click on “Browse or Insert to manage the “Account”
Then you can insert, edit and delete the “Account” table.
Backup&Recovery Database Backup Application Backup
Database Backup Goto the server and open the URL http://localhost/phpMyAdmin/ to manage the database. Username: root Password: root
Click on “Export” to export the data to SQL statements.
Select the Database “TEST” to backup. Select the “SQL” Check on “SAVE AS FILE”. Then there will be a dialog popped up.
After click on “GO” Button, Save the files in the safe place.
Application Backup Copy all of the application files from the folder below in the Server to a safe place. C:\AppServ\www\payless
Recovery Install the AppServ Open Project 2.4.8 downloaded from http://www.AppServNetwork.com. o During installation the program will ask for the username and password. o Enter Username: root o Password: root Copy all application files to C:\AppServ\www. The Application Path may be C:\AppServ\www\payless If installation completely succeeded, you should be able to go to the first page of the Web Server like the picture below
Try to test MySQL Database by click on the phpMyAdmin Link. Enter the username: root, password: root Create the database named “test” by using the phpMyAdmin Run the SQL script backed up before. If there is no error, the database should have all of data like when you back up. Try to go to http://localhost/payless and see if the application is running fine.
Prepared by Nattakorn Wongsaichua Email: premw@hotmail.com Tel: 207-409-2481 Homepage: www.premw145.com