We are porting an online store to a new shopping cart system and now have an XML export of the current store system.
And that needs to be imported into the new shopping cart.
Therefore we need an ASP script (NOT ASP.NET) that takes about 10 elements of the XML per product and inserts them into the respective database fields of the products table. Product options like colors and/or sizes need to be specially formatted, i.e.:
<OptionLists>
<OptionList name="Color">
<OptionValue>Chestnut Stain (Dark Brown)</OptionValue>
<OptionValue>Pine Stain (Medium Amber)</OptionValue>
<OptionValue>Aged Ebony Paint</OptionValue>
</OptionList>
becomes:
Color "Chestnut Stain (Dark Brown)" "Pine Stain (Medium Amber)" "Aged Ebony Paint"
and that string imported into one field of the product table.
Then there need to be a lookup for the category by category name and then inserted the newly added product id and the found category id into the category-product relation table.
This task is URGENT, so please bid only if you can complete it by Monday morning US EST.
Thanks