Adding/Modifying Fields in the Main Product Table
Does anybody know where to find info about modifying or adding fields in the main products table (as opposed to adding an extra field)?
How complicated is this? Which files (sql/php/tpl ??) are associated this type of mod? Example: - What are the implications of adding a new field "Artist" and displaying it on the main category or products listing page? Why not use extra fields? - The exported table is seperate to the main products table and makes editing in a spreadsheet cumbersome. As I am a newcomer forgive me if I have misunderstood anything basic and I look forward to your replies. |
Re: Adding/Modifying Fields in the Main Product Table
If you take a look at some of my freebie mods, you'll pick up a few tips on how to add custom fields to the products table and manage them in admin. It's not too hard, failing that I'll post a quick tutorial.
Cheers, Phil |
Re: Adding/Modifying Fields in the Main Product Table
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 ; Look for... Code:
# Update product data Code:
$query_data = array( ... ); Code:
"artist" => $artist, Add this code in a suitable place... Code:
<tr> Code:
<tr> To use the field on your product page, (skin1/customer/main/product.tpl), use this code... Code:
{$product.artist} Code:
{$products[product].artist} Code:
{$product.artist} |
Re: Adding/Modifying Fields in the Main Product Table
Excellent, that looks straightforward - appreciate your help.
|
Re: Adding/Modifying Fields in the Main Product Table
Just tried the above code - worked first time, suddenly everything seems so much easier - cheers Phil
|
Re: Adding/Modifying Fields in the Main Product Table
What I don't understand is why I would have to add the extra field to the database even AFTER I've added it to the product through the Admin area. Where is this data stored in the first place? I have v4.0.19, will this still work?
|
Re: Adding/Modifying Fields in the Main Product Table
Is it possible to use this new fiels in the Product Varients table?
Thanks. |
Re: Adding/Modifying Fields in the Main Product Table
Be warned while this works trying to "modify products" after this is frustrating becasue there are some steps missing you will get sql errors
|
Re: Adding/Modifying Fields in the Main Product Table
It's meant for v4.1.x stores, not v4.0.x
|
Re: Adding/Modifying Fields in the Main Product Table
how can I use it in the simple search?
Thank you Gitty |
Re: Adding/Modifying Fields in the Main Product Table
how can I add my new field to the simple and advanced searches?
does anyone have any ideas? |
Re: Adding/Modifying Fields in the Main Product Table
Quote:
Hi Phil, I can add a custom field successfully. When i try to import cvs database... I got error messages: Quote:
if that's not supposed to be in the section 'PRODUCTS', which section should I use? THANKS |
Re: Adding/Modifying Fields in the Main Product Table
I want to add some more fields like Pack Size & Attribute in a small text field and also the content type=Liquid,Solid etc.... in a select box in the product item card.Also I want to import that field values via 3x-4x import. How can I able to do that?Kindly help me to do this.
Thanks to all again. |
Re: Adding/Modifying Fields in the Main Product Table
Quote:
Thanks PhilJ for such effort.But can you help me where to add {$product.artist} in (skin1/customer/main/product.tpl) file? |
Re: Adding/Modifying Fields in the Main Product Table
Quote:
Thanks PhilJ for those fine codes.But I can not know where to add {$products[product].artist} in (skin1/customer/main/product.tpl) file?Can you guide me? Also is it possible to import from 3x-4x import? Thanks to all. |
Re: Adding/Modifying Fields in the Main Product Table
Hi,
May I request some help from the Forum please? I am here --- > ](*,) Thanks in advance... |
Re: Adding/Modifying Fields in the Main Product Table
Any response from forum please!!! I really need some help.
Thanks to all. |
Re: Adding/Modifying Fields in the Main Product Table
Thank you PhilJ. People are affraid X-Cart because there are no information how to change the code. If QT will take in consideration to write a developer manual, it will be much easier for everyone to go on their own.
|
Re: Adding/Modifying Fields in the Main Product Table
Hi am2003,
Can you help me a little bit !!! Thanks to all. |
Re: Adding/Modifying Fields in the Main Product Table
Hello!
I'm new with x-cart. I have try to add one field fallowing the steps you've writen. The data is displayed well but no modification to the data is reported to DataBase. What's wrong ? To DataBase: ALTER TABLE `xcart_products` ADD `descrauteurs` TEXT DEFAULT NULL; in product_modify.php, i added: "descrauteurs" => $descrauteurs at the wright place and in product_details.tpl, i added: <tr> {if $geid ne ''}<td width="15" class="TableSubHead"><input type="checkbox" value="Y" name="fields[descrauteurs]" /></td>{/if} <td class="FormButton" nowrap="nowrap">{$lng.lbl_descrauteurs}* :</td> <td class="ProductDetails"> {include file="main/textarea.tpl" name="descrauteurs" cols=45 rows=12 class="InputWidth" data=$product.descrauteurs width="80%" btn_rows=4} </td> </tr> What's the problem ???? Tanks for your help. |
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. |
Re: Adding/Modifying Fields in the Main Product Table
Quote:
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 07:07 PM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.