X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)
-   -   Adding/Modifying Fields in the Main Product Table (https://forum.x-cart.com/showthread.php?t=26844)

sofiane 05-31-2012 01:48 AM

Re: Adding/Modifying Fields in the Main Product Table
 
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 04-16-2019 02:34 PM

Re: Adding/Modifying Fields in the Main Product Table
 
Quote:

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...
Code:

ALTER TABLE `xcart_products` ADD `artist` TEXT NOT NULL ;
2) include/product_modify.php
Look for...
Code:

# Update product data
Within...
Code:

$query_data = array( ... );
Along similar lines add...
Code:

"artist" => $artist,
3) skin1/main/product_details.tpl
Add this code in a suitable place...
Code:

<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...
Code:

<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...
Code:

{$product.artist}
To use the field on your products page, (skin1/customer/main/products.tpl or products_t.tpl), use this code...
Code:

{$products[product].artist}
v4.4.x use this code
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


All times are GMT -8. The time now is 08:23 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.