X-Cart forums

[djdoubleh]

I need help! I am a newbie to x-cart and i am using x-cart pro 4.0.12. I need to add permanent fields to the product page without using the extra field or make the "extra fields" appear in separate columns on csv.

The reason why I prefer to add permanent fields is that I have a lot of products to import through my csv file and would love to have few more fields added to my csv import file and the "Extra Fields" in csv are muddled up into one column.

It is awkward for me to fill in the muddled "Extra fields" especially when I have up to 10 extra fields. If I can have the extra fields in separate columns and can be uploaded that way via csv, it will be nice but if that is not possible, I will rather prefer to have a few more product fields which can appear in my csv whenever I import or export my csv file.

Thanks for your anticipated help.

Henry

[balinor]

Post moved. Please read the forum descriptions and stickies carefully before posting, the Custom Mods forum is for COMPLETED MODS only. Thanks!

[shan]

you can add extra rows to the products table and then update these files

PRODUCT_DETAILS.TPL
PRODUCT_MODIFY.PHP

The import / export stuff will pick up the extra fields by itself

[djdoubleh]

Originally Posted by shan

you can add extra rows to the products table and then update these files

PRODUCT_DETAILS.TPL
PRODUCT_MODIFY.PHP

The import / export stuff will pick up the extra fields by itself

Hello Shan,

Can you kindly give me a detailed description of how to go about this. I am not so good in PHP and templates.

Your help will be highly appreciated. Thanks.

Henry

[shan]

dont have a lot of time at the mo but you basically add extra rows to the database then add code to input the new values in the tpl file and then update the update portion of the php file to match

[djdoubleh]

I am getting errors, can someone help me out please. I added this to my xcart_products table in mysql : album_title varchar(255) NOT NULL ,

I added this to "Update Product data" in "include/product_modify.php" : album_title='$album_title', immediately after: db_query("UPDATE $sql_tbl[products] SET product='$product',

Then I added this: <TR>
{if $productids ne ''}<TD width="15" class="TableSubHead"><INPUT type="checkbox" value="Y" name="fields[album_title]"></TD>{/if}
<TD class="FormButton" nowrap>{$lng.lbl_album_title}:</TD>
<TD class="ProductDetails">
<INPUT type="text" name="album_title" size="45" class="InputWidth" value="{$product.album_title}">
</TD>
</TR>
to the "main/product_details.tpl".

Finally I went to the language section in admin and added "lbl_album_title" to the "labels".

Now each time i click on "Modify Product" or "Add Product" from admin or from the Provider end, I get errors.

Please remember that I am using X-Cart PRO.

Can anyone help me out. I need to know what else i need to do or what I must have done wrong. Thanks in anticipation.

Henry (djdoubleh)

[shan]

with pro it may be slightly different. im not sure

[Lucent88]

I did the some modification in simliar steps.

I created extra fiels/row in xcart_products.

Edit product_detail.tpl to add the text fields.

edit product_modify.php to update informaton.

My question is, on product_modify.php ... is the

# update product data the only part I have to modify? It look fairly simple enough to do it.. but when I tried to update product detail from admin, it doesn't save/update. Am I missing some steps here?