My problem has to do with the way in which Shopsite is exporting product information into an XML file, specifically the product information field.
After I have successfully exported an XML file, which simply contains the unique product SKU and the product description field, I notice some text gets misplaced.
As an example, here is a non-escaped product description, as it appears before export:
8"<br>
plush fur with poly stuffing<br>
Round and round and round we go! This soft sculpted plush piece is constructed with internal wires preserving the heart warming poses. Packaged in an open sided box for easy on-shelf merchandising while providing full view and "touch-ability" for your customers!
And here is the same product description once it is exported as XML (and HTML characters are escaped)
<Product>
<SKU>94004</SKU>
<ProductDescription>"<br>
plush fur with poly stuffing<br>
Round and round and round we go! This soft sculpted plush piece is constructed with internal wires preserving the heart warming poses. Packaged in an open sided box for easy on-shelf merchandising while providing full view and "touch-ability" for your customers!8</ProductDescription>
</Product>
If you look very carefully, you will see that Shopsite has placed the numeral 8 at the end of the product description, just before the closing </ProductDescription>, rather than after <ProductDescription>, where it should be.
One more example:
Non-escaped, non-XML version:
8"<br>
plush fur with poly stuffing<br>
Creative fun to go! Crayola® Crayon color-inspired Boyds Bear comes complete with its own backpack for traveling along with a four-pack of Crayola® Crayons and a Boyds paw print-shaped doodlepad to give the kids hours of fun!
Exported XML version:
<Product>
<SKU>919120</SKU>
<ProductDescription>"<br>
plush fur with poly stuffing<br>
Creative fun to go! Crayola8® Crayon color-inspired Boyds Bear comes complete with its own backpack for traveling along with a four-pack of Crayola® Crayons and a Boyds paw print-shaped doodlepad to give the kids hours of fun!</ProductDescription>
</Product>
This latest example takes the numeral 8, which belongs at the beginning of the product-description, and places it between Crayola and ®.
Does anyone have any thoughts why the XML parser is getting confused here?
Thank you.