PRETTY PLEASE!! Adding to Products Description???

[ashinco]

I have a site I am working on that has jewelry items. I need to be able to do something like the following using a spreadsheet: (simple example)

 

Product name: Beautiful Ring

 

Product description: This is a beautiful ring with several stones of various types.

 

Metal Type: Yellow Gold

Metal karat: 18

Gem1 Type: Diamond

Gem1 Clarity: VI

Gem1 Color: G

Gem1 Cut: Princess

Gem1 Carat: 1.5

Gem2 Type: Ruby

Gem2 Color: Red

Gem2 Carat: 2.5

 

You see the pattern? Each field would be a column in my spreadsheet, but I don't want them as little dropdown boxes (options). When I upload the spreadsheet to my database, I want these fields firmly planted together so when someone clicks on an item, you can immediately see all of the pertinant information about the item. I can work on the actual page layout later. I just need to know exactly how to creat the spreadsheet, what fields OSC uses, etc., and most importantly, HOW to upload it. There isn't a way to do this directly from the admin (only options, which have those annlying little dropdown boxes). Or at least, I haven't figured it out yet. Hee hee.

 

Any suggestions? Thanks, and Happy Holidays!!! :D :D :D

[moonstone]

Well, I suggest using tables in your product description. For example:

 

This is a beautiful ring with several stones of various types.

<table>

<tr>

<td>Metal Type:</td>

<td>Yellow Gold</td>

</tr>

<tr>

<td>Metal karat:<td>

<td>18</td>

</tr>

<tr>

<td>Gem1 Type:</td>

<td>Diamond</td>

</tr>

:

:

:

:

:

</table>

[Guest]

Or you could install this HTML editor

 

The_Bear

[ashinco]

Well, I suggest using tables in your product description. For example:

 

This is a beautiful ring with several stones of various types.

<table>

<tr>

<td>Metal Type:</td>

<td>Yellow Gold</td>

</tr>

<tr>

<td>Metal karat:<td>

<td>18</td>

</tr>

<tr>

<td>Gem1 Type:</td>

<td>Diamond</td>

</tr>

:

:

:

:

:

</table>

Hik I'm not sure what you are telling me. Is this a suggestion for the web page layout? If it is, that is something I already understand. What I need is help in getting all of my data into my database. What fields should I use, etc. HTML is something I understand. Databases are what I have so much trouble with. I've tried looking at EasyPopulate, but even that is too complicated for me (at least the instructions are).

 

What I'm looking for is a very uncomplicated way of getting my data into my database, in the correct fields so that when I finish my web design with OSC, everything will be where it's suuposed to be.

 

Thanks.

 

Tom

[Guest]

you can edit the product_info.php the section:

 

<tr>
<td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>
<td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
</tr>

 

and make this as repeating region rather than menu list. I couldn't do that hand coding but wit some app like dreamweaver perhaps.

 

tom