| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | Mark Forums Read | User manuals | Login |
Adding/Modifying Fields in the Main Product Table | ||||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
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.
__________________
X-cart 4.1.3 pro Linux 2.6.17 Music Website Selling Digital Downloads |
|||||||
#2
|
|||||||
|
|||||||
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
__________________
xcartmods.co.uk |
|||||||
#3
|
|||||||
|
|||||||
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:
Look for... Code:
Code:
Code:
Add this code in a suitable place... Code:
Code:
To use the field on your product page, (skin1/customer/main/product.tpl), use this code... Code:
Code:
Code:
__________________
xcartmods.co.uk |
|||||||
|
#4
|
|||||||
|
|||||||
Re: Adding/Modifying Fields in the Main Product Table
Excellent, that looks straightforward - appreciate your help.
__________________
X-cart 4.1.3 pro Linux 2.6.17 Music Website Selling Digital Downloads |
|||||||
#5
|
|||||||
|
|||||||
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
__________________
X-cart 4.1.3 pro Linux 2.6.17 Music Website Selling Digital Downloads |
|||||||
#6
|
|||||||
|
|||||||
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?
|
|||||||
#7
|
|||||||
|
|||||||
Re: Adding/Modifying Fields in the Main Product Table
Is it possible to use this new fiels in the Product Varients table?
Thanks.
__________________
JP UNIX v4.1.11 v4.2 v4.3 v4.4 |
|||||||
#8
|
|||||||
|
|||||||
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
__________________
Version 4.0.14 |
|||||||
#9
|
|||||||
|
|||||||
Re: Adding/Modifying Fields in the Main Product Table
It's meant for v4.1.x stores, not v4.0.x
__________________
xcartmods.co.uk |
|||||||
#10
|
|||||||
|
|||||||
Re: Adding/Modifying Fields in the Main Product Table
how can I use it in the simple search?
Thank you Gitty
__________________
X-Cart version 4.1.10 upgraded from 4.0.13 myself slowly and with help from xcart forums. Thanks all! http://www.discountseforim.com Hebrew Seforim and Jewish Books |
|||||||
|
Thread Tools | Search this Thread |
|
|
|
|||
X-Cart forums © 2001-2020
|