My company uses an internal management software for storing
products. They want to transpose all the
products in a MySql database so they can do available their
products on the company website.
Notice: they will continue to use their own internal software. This software can exports all the
products in various file format (including XML).
The syncronization not have to be in real time, they are satisfied to syncronize the MySql database once a day (late night).
Also, each product in their software has one or more images, then I have to do available also the images on the website.
Here is an example of an XML export:
<?xml version="1.0" encoding="UTF-8"?>
<export_management userid="78643">
<product id="1234">
<version>100</version>
<insert_date>2013-12-12 00:00:00</insert_date>
<warrenty>true</warrenty>
<price>139,00</price>
<model>
<code>324234345</code>
<model>Notredame</model>
<color>red</color>
<size>XL</size>
</model>
<internal>
<color>green</color>
<size>S</size>
</internal>
<options>
<s_option>some option</standard_option>
<s_option>some option</standard_option>
<extra_option>some option</extra>
<extra_option>some option</extra>
</options>
<images>
<image>
<small>1234_0.jpg</small>
</image>
<image>
<small>1234_1.jpg</small>
</image>
</images>
</product>
</export_management>
Some ideas for how can I do it? Or if you have better ideas to do that.
