Would appreciate some advice on using external data with SQL Server 2005
You can import your data into a staging table then update the product reference data from that.  The product table can hold your 'available' flag.  Unfortunately you will have to import the XML data into SQL Server to load it, but SSIS has an XML reader, so you can use that to do the imports.