Vianna1111

With this contribution, I use "text area" attributes with some of my products and was having the issue with text over extending the table in the following files. catolog/includes/modules/email_invoice/templates/invoice.php (if you use the email invoice contribution) catalog/account_history_info.php catalog/checkout_confirmation.php admin/invoice.php admin/packslip.php I believe those are all the files which need to be changed. Find the following code: echo '<br><nobr><small>?<i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>'; and change to: echo '<br><nl2br><small>?<i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nl2br>'; I hope this helps someone... Note: The above code might be slightly different in some files, but what needs to be changed is in bold.

Good deal :thumbsup:.

*Note*I had to "Alter table order by" before I made the updates, I'm assuming I had to do this because these products already had attributes. Additional steps if product already has attributes: 1. Delete the respective attributes in your catalog/product attributes. 2. In ?phpMyAdmin?, optimize the table (the optimize table option is also located near the bottom of the "Operations" page). 3. "Alter table order by :? (select the appropriate attribute you would like to sort by). 4. Insert the new attributes in your catalog/product attributes in the order you want them to appear.

Hi there, I'm assuming the above "Product Options" your are referring to is in your SQL table also? If so, my "type" is set to varchar, length(32) I'm really still learning myself but you might try this: Product Options ID: 14 Personalized Engraving Line 1 Option Type: varchar Lenght: 32

Ok, I think I finally figured out how I sorted my product attributes. 1. Log into ?phpMyAdmin?. 2. Select appropriate database (database name) from the pull-menu located in top left. 3. Click on the ?products_attributes? table link (located in left panel). 4. Select the ?Operations? tab located near the top of the main window. 5. Where is says ?Alter table order by :? Select the appropriate attribute you would like to sort by. (I wanted my attributes to sort by price, so I selected ?options_values_price?. 6. Click ?Go?. It?s working for me so far today...I had to change the attributes of some of my products today and I noticed it wasn't sorting like before, but it could have something to do with me inserting these products before I stumbled across how I sorted them initially. Anyway I hope this helps and I?d back up the database first (I believe you back up the database in your control panel. :D

Sorry to just get back with you...I really just stumbled across fixing this. It's going to take me a minute to remember what I did :(, I should have wrote it down then...I'll update as soon as I figure out how I did it.

No Problem...I was wondering this very thing a couple of weeks ago! LOL Not sure who your hosting with, but my SQL table is located in my control panel. I have "My PHP Admin" installed on my server and this is where I sorted the table. Let me know if need more info.

For anyone else who had this issue...the solution is in SQL table, sorted by option_value.

Hello All, I just installed the above contribution (Product Attributes - Option Type Feature) and I am having a problem with the option values changing for each product I insert, I really need for the options to stay in the same format that I've created, and remain consistent thereafter. I've been working on this a lot so maybe I'm missing something obvious :blush:. EXAMPLE Available Options Business Card *Attributes* Select Box (pulldown) -Blank (so customer is not automatically charged an option they didn't want) -Textured (+ .50) -Glossy ( + 1.00) 1. Business Name (text box) - Customer enter's Business Name 2. Business Address (text box) - Customer enter's Business Name 3. Business Website Address (text box) - Customer enter's website address. (these appear in aphabetical order, would like to change this if possible) ectera...but the main problem I'm having seems to be the "select" pull down menu. No matter what order I insert the attributes the select box doesn't stay the same. When I try to add the same or similiar attributes to another products, the "Glossy" options is on top, or the "Textured" is on top....this changes everytime I insert or apply attributes to a product using the select feature....and, the select box doesn't always stay on top of the other optional information. There seems to be no sort order with the select attribute... I hope i am explaining this correctly....please help anybody! :D

Found the contribution I was looking for here... http://www.oscommerce.com/community/contributions,160 Much thanks to all who contributed to the above contribution...works great!

LOL...hey, my brain was half functioning after working on this most of the day...lol. AND, come to find out I misunderstood what the contributions does :blush:... What I need is a "Form" with text boxes in the product_info.php file, where customers can manually add certain information about each respective item and this information carry's over into the checkout and order emails. I've look all over contributions, but haven't found anything. Idea's anyone?? Thanks!

I checked a recent backup, but it only contained the first few tables in my sql database...am I missing something? Thanks! Duh, nevermind, found it. :D

Hey Thanks! Uh Backup???!?! Please don't say that word! :blink: , it took me half a day to figure out the "product extra fields" contribution. I sure hope I don't have to do that again...I don't think I had any attributes yet.

Hello Everyone... Just getting my feet wet with OSCommerce...and while I'm quite proud of myself for adding the "Product Extra Fields" contribution....I had no idea what I was doing messin' around in my SQL database. Needless to say I accidently deleted (or dropped) the "products_options_values_to_products_options" table! :blush: Can someone please copy the SQL from this table? Much appreciated!