Our firm just recently began using the trial version of Shipstation and we love it. SS offers much more than we expected and saves considerable time. We highly recommend it, though we hate adding additional cost to our operation.

A few minor criticisms about the Shipstation:

1. It uses the product_id field as "Name" in the software and "Description" in the emails. The product_id field really isn't either.
2 It imports the products_model field as "SKU" in the software and calls it "Item #" in the emails. Our firm uses the product_id field as a SKU (since it is the unique, keyed field) and wanted to have the product description somewhere.

Shipstation was very friendly about the suggestions and may offer some changes. In the meantime, we changed/ added the following code to the /catalog/shipstation_zc.php file:

1. To address issue #1 above, we changed the mapping at (around) for the SKU field as follows:
Code:
	//AddFieldToXML("SKU", '<![CDATA['.$orderitems_result->fields['products_model']. ']]>');
	  AddFieldToXML("SKU", '<![CDATA['.$orderitems_result->fields['products_id']. ']]>');
2. To address issue #2 above, we added a new query, then changed the mapping. Around line 250, after the $image_query statements, add this new query:

Code:
//NEW: Get ZC Product Description; Apollo Caster, Inc. 10/8/12
$desc_query = "SELECT products_description FROM ". TABLE_PRODUCTS_DESCRIPTION ." WHERE products_id = '". $orderitems_result->fields['products_id'] ."'";
$desc_result = $db->Execute($desc_query);
// END NEW
Then, a few lines down, modify the mapping field "name" to use the above queried product_description:

Code:
	//AddFieldToXML("Name", '<![CDATA['. $orderitems_result->fields['products_name']. ']]>');
	  AddFieldToXML("Name", $desc_result->fields['products_description']);
Save the file, upload to your site, then in ShipStation hit the "Update" button. If you don't get an error (coding typo), run a test order and see how the data comes in on the new order.