Xml Data

[serv_co_za]

Hello guys,

 

I am trying to input a xml data sheet into oscommerce database, would this be possible and could u please help me out so far i am building a example xml with the database tables needed to add the data.

 

<xml>

<products>

<products_id>1</products_id>

<products_quantity>32</products_quantity>

<products_model>MG200MMS</products_model>

<products_image>matrox/mg200mms.gif</products_image>

<products_price>299.9900</products_price>

<products_date_added>2005-09-27 11:20:55</products_date_added>

<products_last_modified>NULL</products_last_modified>

<products_date_available>0000-00-00 00:00:00</products_date_available>

<products_weight>23.00</products_weight>

<products_status>1</products_status>

<products_tax_class_id>1</products_tax_class_id>

<manufacturers_id>1</manufacturers_id>

<products_ordered>0</products_ordered>

</products>

 

That i anderstand.

 

but what is this table for products_attributes

 

<products_attributes>

<products_attributes_id></products_attributes_id>

<products_id></products_id>

<options_id></options_id>

<options_values_id></options_values_id>

<options_values_price></options_values_price>

<price_prefix></price_prefix>

</products_attributes>

 

 

Please help out.

 

Thanks

[serv_co_za]

ok never mind that last post,

 

Now what i would want to find out, if i have more than one color and size of a product and i have lets say 2 blue in stock and 1 small and one meduim how can i enter these values as well so that if 1 meduim is bought it doesn`t show any more or it shows out of stock.

 

Please Help

[serv_co_za]

Hi.

 

Does this xml look right.

 

<xml>

<products>

<products_id>1</products_id>

<products_quantity>32</products_quantity>

<products_model>MG200MMS</products_model>

<products_image>matrox/mg200mms.gif</products_image>

<products_price>299.9900</products_price>

<products_date_added>2005-09-27 11:20:55</products_date_added>

<products_last_modified>NULL</products_last_modified>

<products_date_available>0000-00-00 00:00:00</products_date_available>

<products_weight>23.00</products_weight>

<products_status>1</products_status>

<products_tax_class_id>1</products_tax_class_id>

<manufacturers_id>1</manufacturers_id>

<products_ordered>0</products_ordered>

</products>

 

<products_description>

<products_id>1</products_id>

<language_id>1</language_id>

<products_name>Matrox G200 MMS</products_name>

<products_description>Reinforcing its position</products_description>

<products_url>www.matrox.com/mga/products/mill_g400/home.htm</products_url>

<products_viewed>0</products_viewed>

</products_description>

 

<products_options>

<products_options_id>1</products_options_id>

<language_id>1</language_id>

<products_options_name>Color</products_options_name>

</products_options>

 

<products_options>

<products_options_id>2</products_options_id>

<language_id>1</language_id>

<products_options_name>Size</products_options_name>

</products_options>

 

<products_options_values>

<products_options_values_id>1</products_options_values_id>

<language_id>1</language_id>

<products_options_values_name>Blue</products_options_values_name>

</products_options_values>

 

<products_options_values>

<products_options_values_id>2</products_options_values_id>

<language_id>2</language_id>

<products_options_values_name>small</products_options_values_name>

</products_options_values>

 

<products_options_values>

<products_options_values_id>3</products_options_values_id>

<language_id>2</language_id>

<products_options_values_name>large</products_options_values_name>

</products_options_values>

 

<products_options_values_to_products_options>

<products_options_values_to_products_options_id>1</products_options_values_to_products_options_id>

<products_options_id>1</products_options_id>

<products_options_values_id>1</products_options_values_id>

</products_options_values_to_products_options>

 

<products_options_values_to_products_options>

<products_options_values_to_products_options_id>2</products_options_values_to_products_options_id>

<products_options_id>2</products_options_id>

<products_options_values_id>1</products_options_values_id>

</products_options_values_to_products_options>

 

<products_options_values_to_products_options>

<products_options_values_to_products_options_id>3</products_options_values_to_products_options_id>

<products_options_id>2</products_options_id>

<products_options_values_id>2</products_options_values_id>

</products_options_values_to_products_options>

 

<products_to_categories>

<products_id>1</products_id>

<categories_id>1</categories_id>

</products_to_categories>

</xml>

[serv_co_za]

I did this so far

 

But i don`t really anderstand the option values, could someone please explain to me how they work.

 

<categories>

<categories_id>1</categories_id>

<categories_image>none.gif</categories_image>

<parent_id>0</parent_id>

<sort_order>1</sort_order>

<date_added>2005-09-27 11:20:55</date_added>

<last_modified>NULL</last_modified>

</categories>

 

<categories_description>

<categories_id>1</categories_id>

<language_id>1</language_id>

<categories_name>test</categories_name>

</categories_description>

 

<manufacturers>

<manufacturers_id>1</manufacturers_id>

<manufacturers_name>test</manufacturers_name>

<manufacturers_image>none.gif</manufacturers_image>

<date_added>2005-09-27 11:20:55</date_added>

<last_modified>NULL</last_modified>

</manufacturers>

 

<manufacturers_info>

<manufacturers_id></manufacturers_id>

<languages_id></languages_id>

<manufacturers_url></manufacturers_url>

<url_clicked></url_clicked>

<date_last_click></date_last_click>

</manufacturers_info>

 

<products>

<products_id>1</products_id>

<products_quantity>32</products_quantity>

<products_model>MG200MMS</products_model>

<products_image>matrox/mg200mms.gif</products_image>

<products_price>299.9900</products_price>

<products_date_added>2005-09-27 11:20:55</products_date_added>

<products_last_modified>NULL</products_last_modified>

<products_date_available>0000-00-00 00:00:00</products_date_available>

<products_weight>23.00</products_weight>

<products_status>1</products_status>

<products_tax_class_id>1</products_tax_class_id>

<manufacturers_id>1</manufacturers_id>

<products_ordered>0</products_ordered>

</products>

 

<products_description>

<products_id>1</products_id>

<language_id>1</language_id>

<products_name>Matrox G200 MMS</products_name>

<products_description>Reinforcing its position</products_description>

<products_url>www.matrox.com/mga/products/mill_g400/home.htm</products_url>

<products_viewed>0</products_viewed>

</products_description>

 

<products_options>

<products_options_id>1</products_options_id>

<language_id>1</language_id>

<products_options_name>Color</products_options_name>

</products_options>

 

<products_options>

<products_options_id>2</products_options_id>

<language_id>1</language_id>

<products_options_name>Size</products_options_name>

</products_options>

 

<products_options_values>

<products_options_values_id>1</products_options_values_id>

<language_id>1</language_id>

<products_options_values_name>Blue</products_options_values_name>

</products_options_values>

 

<products_options_values>

<products_options_values_id>2</products_options_values_id>

<language_id>2</language_id>

<products_options_values_name>small</products_options_values_name>

</products_options_values>

 

<products_options_values>

<products_options_values_id>3</products_options_values_id>

<language_id>2</language_id>

<products_options_values_name>large</products_options_values_name>

</products_options_values>

 

<products_options_values_to_products_options>

<products_options_values_to_products_options_id>1</products_options_values_to_products_options_id>

<products_options_id>1</products_options_id>

<products_options_values_id>1</products_options_values_id>

</products_options_values_to_products_options>

 

<products_options_values_to_products_options>

<products_options_values_to_products_options_id>2</products_options_values_to_products_options_id>

<products_options_id>2</products_options_id>

<products_options_values_id>1</products_options_values_id>

</products_options_values_to_products_options>

 

<products_options_values_to_products_options>

<products_options_values_to_products_options_id>3</products_options_values_to_products_options_id>

<products_options_id>2</products_options_id>

<products_options_values_id>2</products_options_values_id>

</products_options_values_to_products_options>

 

<products_to_categories>

<products_id>1</products_id>

<categories_id>1</categories_id>

</products_to_categories>