I have an existing, live store using PS3. I have pretty much the same goal as above. I have been asked to add a comments field "somewhere" (clients words) such that these customer comments are part of the order details email they receive. I decided that the comments field should first appear on the product details page, and that the comments should appear (no field, just comments as entered prior) on the cart page.
Following the post that Jason left above, I:
1. Added the comments column to the cart object.
2. On the product details page, using the cart button wizard, I added an updatable comments column text field. Then using the properties panel in DW, I changed the field from single to multi-line. Returning to the cart buttom wizard, this gave me the default value:
<?php echo $_POST["WA_Store_Cart_1_Comments_Add"]; ?>
and I noticed that the updatable check box as text was no longer checked.
The code on the page shows:
<textarea name="WA_Store_Cart_1_Comments_Add" cols="36" rows="3"></textarea>
On the cart page, I was not sure what was meant when Jason wrote: "When creating the cart display page, on the second step, you can select columns to add to the display, click the plus button and add the comments column. When you run the checkout wizard, the cart added to the confirm page and the emails will be based on the cart display page you create."
I did not see any a way to add the comments column when clicking on the + button.
So, in code view I added the following line:
<?php echo $WA_Store_Cart->DisplayInfo("Comments"); ?></p>
thinking that the comments entered on the product detail page would flow through to the cart page along with the other detail associated with the product.
I have not tried this yet on the live store. Does what I have done so far look correct?
If so far so good, is there additional code to add such that the comments are passed with the other order detail information to the email my client will receive (and the email that the customer receives as well)?
Also, I have not added a comments column to the database. I presume that it is not necessary unless a record of the comments is required as part of the order history (which my client has not requested).