Add a DropDown “How did you hear about us” to Checkout

[jis]

Need to Add a DropDown list for example: “How did you hear about us” to checkout (which would include the following options: search engine, friend, store, email blast, and possibly a few more at some point). How can we achieve this?
And also I need to get this information on the Admin site for each User. Please help.

[jmestep]

I have done this on the one page checkout. I added the dropdown,then stored the selection in a UserSetting field. The client wanted to have it for the order, not the user, so on the receipt page I transferred it from a UserSetting to an order customfield. I didn't put it into an order custom field on the checkout page because of all the other actions going on with that page and the dropdown list was getting reset at times.

[jis]

Thanks for your reply. I am sorry to say, I am totally new to Ablecommerce. Could you please explain the work around for this? Do you need to use the UserSetting field and order customfield in DB for this? And how can we show it on the Admin site with the receipt?

[jmestep]

I'm sorry, but it's too involved for me to post any more here. I was just trying to point you in direction you go to solve it.

[s_ismail]

You need to pick selected option from where you saved during checkout.e-g customer select an option 'Friend' and this value is saved db table 'ac_UserSettings' then on admin site load this selected value from db table 'ac_UserSettings' and display it.