How can I display this information on my product pages from customer side?
[quote name='brandonvd' timestamp='1315810410' post='121482']
Not that I don't like making a few extra bucks, but this is something that you could do yourself.
Here is what to do:
1.) In you phpMyadmin run this SQL:
ALTER TABLE `cscart_products` ADD `brand` VARCHAR(100) AFTER `product_code` ;
2.) In skins/basic/admin/views/products/update.tpl
After:
{hook name="companies:product_details_fields"}
{include file="views/companies/components/company_field.tpl" title=$lang.vendor name="product_data[company_id]" id="product_data_company_id" selected=$product_data.company_id}
{/hook}
Add:
```php
Brand:
3.) In schemas/exim/products.php
After:
```php 'Price' => array (
'table' => 'product_prices',
'db_field' => 'price',
'convert_put' => array ('fn_exim_import_price', '@price_dec_sign_delimiter'),
'process_get' => array ('fn_exim_export_price', '#this', '@price_dec_sign_delimiter'),
), ```
Add:
```php 'Brand' => array (
'db_field' => 'brand',
), ```
4.) In schemas/exim/google.php
After:
```php 'upc' => array (
'db_field' => 'product_code'
), ```
Add:
```php 'brand' => array (
'db_field' => 'brand',
), ```
This could be cleaned up and put into an addon, but this will do the job.
Hope it helps,
Brandon
[/quote]