Reading an order feed

[PartyMania]

I need to be able to read either an XML or text delimited file and input that information into the OSCommerce orders. Anyone know how to do this?

[Rob123]

The answer is simple... Yes.

The concept of entering orders through a file is easier said than done, however it is possible.

 

If you are in control of the information that will be provided your life would be easier. Remember that you need to consider new orders as well as new customers. You need to consider shipping rates, out of stock items, error handling and of course charging customer credit cards.

 

The above is a good start for a high level analysis, once you make your decisions

 

Step one is reading the data. Some people like CSV others prefer XML.

Step two is transforming the data such as product ID's and address formats

Step three is determining if you need to insert or update customer data.

Step four is inserting the new order information and reducing inventory.

Step five is sending out confirmation emails.

Step six is any other steps required that I may have forgotten :blush:

 

Let me know if you have any questions.

Robert

[PartyMania]

Thanks for the response Robert. I have the format of the XML file, and currently the only thing that is important to me is inputting the order from the XML feed into the database.

 

Do you know of any contributions that would help with this?

 

Feed format:

http://ccimg.catalogcity.com/Images/corpor...leOrder_XML.xml

 

Thanks.

[Rob123]

Hey... I recognize that feed from shop.com!

There is currently no contribution that will satisfy your needs.

 

I worked on a project for a client that integrated the order process from shop.com (he won't let me release it).

 

However once you start, feel free to ask me any questions and I'll help you on your way.

 

HTH,

Robert