Hi expediteship,

First, you need to add 2 or 4 customfields to the product object.  ProductWeight and ProductDimension (or possibly ProductHeight and ProductWidth and ProductDepth).  You can then enter the appropriate values for each product.

If an opportunity and it's line items (products) represent an order, then to get the requisite data you would issue a query using a soql statement similar to this.

Select Id, TotalPrice, UnitPrice, ListPrice, Quantity, PricebookEntryId From OpportunityLineItems Where OpportunityId = '00630000000h8dQAAQ'

This will give you the detail of the order.  The next thing to do is to get the product details which is why I included the PricebookEntryId.  Using this we can obtain the specific product details of each line item.  Loop through the previous results and collect up the PricebookEntryId's into a string array. 

QueryResult qr = binding.query("<soql from above>");

ArrayList pricebookentryIds = new ArrayList();

for (int i=0;i<qr.records.Length;i++) {

     pricebookentryIds.Add(qr.records[i].id);

}

string[] ids = (string)pricebookentryIds.ToArray(typeof(string));

You can then pass this array of ids using the retrieve call to fetch the PricebookEntrys for the opportunity.

SObject[] pricebookentries = binding.retrieve("Id, Product2Id", "PricebookEntry", pricebookentryIds);

Place all the Product2Ids into a string array also.

string[] product2Ids = new string[pricebookentries.Length];

for (int i=0;i<pricebookentries.Length;i++)

    product2Ids[i] = ((PricebookEntry)pricebookentries[i]).Product2Id;

No you can retrieve the products.

SObject[] products = binding.retrieve("Id, ProductDimension, ProductWeight, ProductCode", "Product2", product2Ids);

To distinguish closed orders (as indicated by opportunity stage) you would select using Where not Stage Like 'Closed%' in your query of the opportunity.

To get the rest of the information, you will need to grab the account id from the opporunity and then retrieve or query the account object using the id as a criteria.

Bottom line, there is no single query to do what you want.  You will have to do this "step-wise".