priyeshrawal Posted January 31, 2009 Share Posted January 31, 2009 Hi guys, I just need a hint or tip, I can add more boxes on checkout like comment box which are used to ask product specific questions, I can even set an checkbox assigned to a product in admin on whether or not to ask a customer questions during checkout, the only thing I can't figure out is: Each product on checkout will have a question box added to it (similar to comment box) how do I dynamically add this into database as sometimes there may be one item, and sometimes ten items. Each item should have a unique box ID so that all information is stored otherwise it will keep overighting it. I do not want to use product attributes as this requires selection in product_info page, I need these options or questions answered during checkout. Unless I can do this with attributes? Some one please spare me a few minutes of thought and help? Thanks Link to comment Share on other sites More sharing options...
Guest Posted February 1, 2009 Share Posted February 1, 2009 Hello, Easiest way I can think of is to implement an add-on. Use the product ID as the key (which is unique) in an external set of tables Checkout_Questions Checkout_Answers Give each question a unique Question_ID and an Order_ID That way you can ask an arbitrary number of questions (in order) and receive an arbitrary number of answers per question. Customer can be presented questions during checkout until they finish with the question set or Quit. You would need a question editor screen, a question answer review screen and modification (or insertion) of an interstitial in the checkout process. Best Regards, Graham Leach Co-Proprietor, Authentic Closet ---- Link to comment Share on other sites More sharing options...
priyeshrawal Posted February 1, 2009 Author Share Posted February 1, 2009 Hi thanks for the reply, that makes sense, Now to figure out how to do that!!! I was thinking of making question boxes named dynamically using ID like question1+productID, then ask limitless questions and finally combine these answers to one and post it into database as one field. with separators to help me know. However your method which would enable more robust data collection is im afraid beyond by beginner skills in PHP. maybe if you could give me an example of codes that i could use? I appreciate that you may not have the time to help me, if you did reply more details, I would be extremely grateful. otherwise will have to find a coder, however i am on a budget. Thanks Link to comment Share on other sites More sharing options...
satish Posted February 1, 2009 Share Posted February 1, 2009 Use text based attributes. Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
priyeshrawal Posted February 2, 2009 Author Share Posted February 2, 2009 Ok I could use product text based attributes... however, rather than entering attributes during product_info page, is there any way I can ask customers to enter all attributes during checkout? Thanks guys for helping me along Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.