X-Cart forums

[sofiane]

Bringing this back to life.

Okay so we have the extra field linked to the database and displaying the value for the new column, in this case "artist".

Now, how do we allow our vendors to modify those values? How do we modify those values when adding a new product? When I go inot the admin area and I want to add a new product I can't modify the value for "artist" because its not included in the form. How do we include it?

Thanks.

[elmirage001]

Originally Posted by PhilJ

OK, here's how it's done in v4.1.x ...
1) Add a new product text field called 'artist'...
Patch the database...

ALTER TABLE `xcart_products` ADD `artist` TEXT NOT NULL ;

2) include/product_modify.php
Look for...

# Update product data

Within...

$query_data = array( ... );

Along similar lines add...

"artist" => $artist,

3) skin1/main/product_details.tpl
Add this code in a suitable place...

<tr>
 {if $geid ne ''}<td width="15" class="TableSubHead"><input type="checkbox" value="Y" name="fields[artist]" /></td>{/if}
 <td class="FormButton" nowrap="nowrap">Artist</td>
 <td class="ProductDetails"><input type="text" name="artist" size="18" value="{if $product.productid eq ""}{else}{$product.artist}{/if}" /></td>
</tr>

Or for predefined options...

<tr>
 {if $geid ne ''}<td width="15" class="TableSubHead"><input type="checkbox" value="Y" name="fields[artist]" /></td>{/if}
 <td class="FormButton" nowrap="nowrap">Artist</td>
 <td class="ProductDetails">
 <select name="artist">
 <option value=""{if $product.artist eq ""} selected{/if}>None</option>
 <option value="Van Gogh"{if $product.artist eq "Van Gogh"} selected{/if}>Van Gogh</option>
 <option value="Picasso"{if $product.artist eq "Picasso"} selected{/if}>Picasso</option>
 </select>
</td>
</tr>

That's it!
To use the field on your product page, (skin1/customer/main/product.tpl), use this code...

{$product.artist}

To use the field on your products page, (skin1/customer/main/products.tpl or products_t.tpl), use this code...

{$products[product].artist}

v4.4.x use this code

{$product.artist}

I used this to create a custom Image Alt Tag for product images instead of it defaulting to the product name.

Thank you Phil! This may be an old post but it's a GREAT one!!

Paul