add 2 field to for products detail page.

phuchha · July 25, 2009, 12:00am

I’m willing to pay for this add on, can someone help me how to add 2 field from my Products (Back-end).

Item Condition:
Mfg Part#:

I would like to import & export these 2 fields also.

(Please see image for more detail).

Thanks
sample_2_admin_page.jpg

sample_1_show_up_in_products_detail.jpg

snorocket · July 25, 2009, 12:00am

[quote name=‘phuchha’]I’m willing to pay for this add on, can someone help me how to add 2 field from my Products (Back-end).[/QUOTE]

Donations can be sent to paypal@snorocket.com

=======================================================

OPEN phpmyadmin and PASTE below CODE into “Run SQL query/queries on database” text field.

ALTER TABLE `cscart_products` ADD `item_condition` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `product_code` , ADD `mfg_partno` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `item_condition` ;

OPEN …/admin/views/products/update.tpl

FIND:

```php

{$lang.product_code}:

```
[b]PASTE AFTER ABOVE CODE:[/b]
```php

{$lang.item_condition}:

{$lang.mfg_partno}:

```
[b]OPEN .../customer/views/products/components/buy_now.tpl[/b]

[b]FIND:[/b]
```php
{if $show_sku}

{$lang.sku}: {$product.product_code}

{/if}
```
[b]PASTE AFTER ABOVE CODE:[/b]
```php

{$lang.item_condition}: {$product.item_condition}

{$lang.mfg_partno}: {$product.mfg_partno}

```

[b]ADD NEW LANGUAGES:[/b]
```php {$lang.item_condition}
{$lang.mfg_partno} ```

[b]CLEAR CACHE. DONE.[/b]

miracles · July 25, 2009, 12:00am

Thanks sno it is good to see this feature, but i want to know how should i hide them without written anything on there because i seen i have not written anything and it is still displaying “Item Conditions”, is there anyway to hide them ?

Also want to remove on feature products, only shows this on product description

joe · July 25, 2009, 12:00am

[quote name=‘miracles’]Thanks sno it is good to see this feature, but i want to know how should i hide them without written anything on there because i seen i have not written anything and it is still displaying “Item Conditions”, is there anyway to hide them ?[/quote]

In …/customer/views/products/components/buy_now.tpl

[COLOR=Red]{if $product.item_condition}[/COLOR]{$lang.item_condition}: {$product.item_condition}
[COLOR=Red]{/if}[/COLOR]

miracles · July 25, 2009, 12:00am

[quote name=‘joe’][COLOR=Red]{if $product.item_condition}[/COLOR]

{$lang.item_condition}: {$product.item_condition}

[COLOR=Red]{/if}[/COLOR][/QUOTE]

Nope not working it is showing on backend only and the row of Item conditions was also not adjust. Any help :mad:

row.JPG

joe · July 25, 2009, 12:00am

[quote name=‘miracles’]Nope not working it is showing on backend only and the row of Item conditions was also not adjust. Any help :mad:[/quote]

In …/customer/views/products/components/buy_now.tpl

snorocket · July 25, 2009, 12:00am

[quote name=‘miracles’]Nope not working it is showing on backend only and the row of Item conditions was also not adjust. Any help :mad:[/QUOTE]

your image is showing you have not added the languages:

{$lang.item_condition} {$lang.mfg_partno}

phuchha · July 25, 2009, 12:00am

Thanks snorocket, this add on work very good. Donations will sent to paypal@snorocket.com.

Thanks a lot.

phuchha · July 29, 2009, 12:00am

Does anyone know how to add these 2 fields into Import & Export Manger?

{$lang.item_condition}

{$lang.mfg_partno}

Thanks,

Phuc Ha

timst · September 22, 2009, 12:00am

Bump

This would be very usefull… all our manufactures have UPC or MPN and google also prefers this info when uploading so that they can index it better.

snorocket · September 26, 2009, 12:00am

Hey Triplex, below is the code but attached is also an updated update.tpl (change from update.txt to update.tpl after downloading) with your modification, just upload this file and over-right the existing one (after you back it up first)

You need to add 3 new DE languages:

{$lang.lieferant} {$lang.lieferer_art_nr} {$lang.lieferer_ek}

Database queries:

ALTER TABLE `cscart_products` ADD `lieferant` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `product_code` , ADD `lieferer_art_nr` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `lieferant` ADD `lieferer_ek` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `lieferer_art_nr` ;

```php

{$lang.lieferant}:

{$lang.lieferer_art_nr}:

{$lang.lieferer_ek}:

```
Let me know if this works, Thanks - Sno

update.txt

triplex · September 26, 2009, 12:00am

Hi Sno, thanks very much!

If i add the mysql Code in phpmyadmin i get this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD `lieferer_ek` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT ' at line 2

WhatÂ´s wrong?

Thanks for fast help!

snorocket · September 27, 2009, 12:00am

Hi Triplex, do you know how to manually add the 2 new fields with phpmyadmin? adding the 2 new fields with phpmyadmin would be the easiest way…

Thanks - Sno

triplex · September 27, 2009, 12:00am

No sorry Sno, i dont know

triplex · September 27, 2009, 12:00am

O.K. now itÂ´s work. Thanks very much. You know donation i have done.

Please can you explain me, how i can show this new fields in the

skins\basic\admin\views\orders\details.tpl???

Thanks very much!

best regards

Triplex

indymart · September 29, 2009, 12:00am

Sno, is it possible add URL html extra field?

[quote name=‘snorocket’]Donations can be sent to paypal@snorocket.com

=======================================================

OPEN phpmyadmin and PASTE below CODE into “Run SQL query/queries on database” text field.

ALTER TABLE `cscart_products` ADD `item_condition` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `product_code` , ADD `mfg_partno` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `item_condition` ;

OPEN …/admin/views/products/update.tpl

FIND:

```php

{$lang.product_code}:

```
[b]PASTE AFTER ABOVE CODE:[/b]
```php

{$lang.item_condition}:

{$lang.mfg_partno}:

```
[b]OPEN .../customer/views/products/components/buy_now.tpl[/b]

[b]FIND:[/b]
```php
{if $show_sku}

{$lang.sku}: {$product.product_code}

{/if}
```
[b]PASTE AFTER ABOVE CODE:[/b]
```php

{$lang.item_condition}: {$product.item_condition}

{$lang.mfg_partno}: {$product.mfg_partno}

```

[b]ADD NEW LANGUAGES:[/b]
```php {$lang.item_condition}
{$lang.mfg_partno} ```

[b]CLEAR CACHE. DONE.[/b][/QUOTE]

triplex · September 30, 2009, 12:00am

You mean a clickable url? or only text?

text isnt a problem!

and i think clickable must coded extra.

indymart · October 1, 2009, 12:00am

Clickable URL

[quote name=‘Triplex’]You mean a clickable url? or only text?

text isnt a problem!

and i think clickable must coded extra.[/QUOTE]

snorocket · October 1, 2009, 12:00am

[quote name=‘Triplex’]Please can you explain me, how i can show this new fields in the

skins\basic\admin\views\orders\details.tpl???[/QUOTE]

I think you can just paste:

{$product.lieferant} {$product.lieferer_art_nr} {$product.lieferer_ek}

where you want them to show up in details.tpl

mattmoore0 · July 30, 2010, 12:00am

Hi

I cant find buy_now.tpl file to modify. Can somebody help