XML Order Entry

Integrate the ability to send orders received on my website to my supplier using XML. Include in the admin portion of the website a report recording my sales order number and either my supplier’s Order ID or the error code and message.

Web Site Information:

My web site can be found at http://www.bigkahunacomputers.com.

I am using CRE Loaded osCommerce version 6.15 with a custom template.

Server info is included as an attachment to the project.

Project Requirements:

1. Must not break any other functionality of the web site.

2. Orders must be sent according to the XML specification of my supplier. The XML specification is included in the project as an attachment.

3. Orders need to be sent after payment confirmation is received for the order. The payment modules I am using are PayPal IPN and Authiorize.net.

4. A table in the database needs to be created to store the following info at a minimum (more columns may be added as required by the project):

•orderNumber (my order number)

•ASI_orderID (suppliers order ID)

•errorCode (supplier’s error code if there is one)

•errorMessage (text of supplier’s error message if there is one)

•time (time stamp for when ASIOrderReply is received)

5. A table needs to be created to contain the ASI sku and my cost for that sku to be able to complete the required information for the XML specification. This will also make this information easily updateable for me thru phpMyAdmin.

6. A page (ASI Orders) needs to be added under the Customers/Orders heading in the admin portion of the store to contain the report ASI Orders.

7. ASI Orders report should contain the following information:

•orderNumber (my order number)

•ASI orderID (suppliers order ID)

•Time (time stamp for when ASIOrderReply is received)

•errorCode (supplier’s error code if there is one)

•errorMessage (text of supplier’s error message if there is one)

8. If an order is not successfully sent to my supplier an email needs to be generated containing the information that would be found on the ASI Orders report and emailed the e-mail address of the store owner.

9. The project will be complete once my supplier has process 3 successful XML test orders from my website, and all the above requirements are also met.

Additional Information:

1. I use the ASI sku number as my products ‘product_id’ from the ‘products’ table in the database.

2. A CSV file containing my price from the distributor for every sku will be made available to the winning bidder. This file will be needed to meet requirement #5 above.

3. Modifications to any existing files and installation of any new files will be done by the winning bidder.

4. Any login information will be provided to winning bidder as required to complete the project.