View Single Post
  #12  
Old 10-01-2008, 09:21 AM
 
carpart4u carpart4u is offline
 

Newbie
  
Join Date: Jun 2008
Posts: 6
 

Default 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}

Hi Phil,

I can add a custom field successfully.
When i try to import cvs database...
I got error messages:
Quote:
An error occurred during the verification of the CSV file. Please check your CSV file and fix the problem, then try again.

Date: 01-Oct-2008 10:19:14
Launched by: master

Error on line 2: Column 'BIN_LOCATION' is not supposed to be in the section 'PRODUCTS' (PRODUCTS):
!PRODUCTID;!PRODUCTCODE;!BIN_LOCATION

if that's not supposed to be in the section 'PRODUCTS', which section should I use? THANKS
__________________
Version 4.1.10
Reply With Quote