Page 1 of 6

[RELEASED] Custom Product Tab

Posted: Sun Mar 20, 2011 6:03 pm
by bull5-i
Have you ever needed an extra tab on the product page to store information that does not suite under product description? If yes, then this mod is just for you.

This mod adds a new tab to the product page where you can store additional information (custom text and/or images) about a product.

The mod can be found from http://www.opencart.com/index.php?route ... on_id=1536

The content of the custom tab can be edited from the administration panel under product edit page (see the attached images). The tab name (which defaults to "Specs") can be changed when applying the mod. The content of the custom tab is fully translatable. The custom product tab can be made to appear on the product page (in store front) only if it contains any information (see custom installation instructions included in the download)

Main features:
  • custom tab name
  • CKEditor support
  • configurable tab visibility (show when not empty/always show)
The mod is available for OpenCart versions 1.4.9.3 to 1.4.9.6
Version 1.1 of the mod is available for OpenCart 1.5.0-1.5.0.5, version is 1.1.1 and it's available for OpenCart 1.5.1.x.

The latest version 1.2.1 is available as a vQmod for OpenCart 1.5.1.x-1.5.3.x and 1.4.9.3-1.4.9.6.

Some screenshots:
ADMIN
Product edit page
admin_product_view.png

Admin product view - admin_product_view.png (62.19 KiB) Viewed 16729 times

STORE
Main product view with the custom product tab
store_front_product_view.png

Store front product view - store_front_product_view.png (72.61 KiB) Viewed 16729 times


- edit 22.04.2012 - released version 1.2.1 for OpenCart 1.5.1.x - 1.5.2.x and 1.4.9.3 - 1.4.9.6 (vQmod) - fixes database text field collation to utf8
- edit 15.03.2012 - released version 1.2.0 for OpenCart 1.5.1.x - 1.5.2.x and 1.4.9.3 - 1.4.9.6 (vQmod) - fixes default values when adding a new language and option to use admin language value for other languages
- edit 24.11.2011 - released version 1.1.2 for OpenCart 1.4.9.3-1.4.9.6 (vQmod)
- edit 17.11.2011 - released version 1.1.2 for OpenCart 1.5.1.x (vQmod) - fixes compatibility with Custom Product Image Titles (vQmod) mod
- edit 30.09.2011 - released version 1.1.1 and added support for OpenCart 1.5.1.3
- edit 16.09.2011 - vQmod released for OpenCart 1.5.1.x
- edit 24.07.2011 - added support for OpenCart versions 1.4.9.6 and 1.5.1.1
- edit 19.07.2011 - added support for OpenCart version 1.5.1
- edit 30.05.2011 - released version 1.1 for OpenCart 1.5.0
- edit 11.05.2011 - added support for OpenCart version 1.4.9.5

Re: [RELEASED] Custom Product Tab

Posted: Thu Mar 31, 2011 4:16 pm
by ptcole
are you able to set this tab to only show then customer is logged in?

I am looking for a module that allows me to hide pages like the specs tab until the customer is logged in. no need to purchase product.

can you help?

Re: [RELEASED] Custom Product Tab

Posted: Thu May 12, 2011 5:27 pm
by luukie33
Hello RMG,

I have a question, i have purchased your tab, but i dont know howto change ''Add a new column to table 'product_description' named 'spec' and type Text (see opencart.sql)'' Do i need to do this via php my admin? Could you explain how to do this?

tank you very much

Re: [RELEASED] Custom Product Tab

Posted: Tue May 31, 2011 3:57 am
by bull5-i
Released version 1.1 for OpenCart 1.5.0.

Version 1.1 adds configurability to the Module settings page. See screenshot below.
admin_module_settings.png

Admin panel, module settings page - admin_module_settings.png (9.59 KiB) Viewed 16444 times


Re: [RELEASED] Custom Product Tab

Posted: Mon Jul 25, 2011 7:02 am
by idealdream
Hi,

I have buy the module, but not function the filemanager image. When selecting an image from my archive nothing happens. I'm not loading anything. Suggestions? Thanks

Re: [RELEASED] Custom Product Tab

Posted: Sat Aug 27, 2011 8:06 pm
by nathalie
I have the same problem.
I cant insert images!

Re: [RELEASED] Custom Product Tab

Posted: Tue Aug 30, 2011 1:59 am
by Xciso
Does this work good or not?
I have 1.5.1.1 and i am very intressted in this extension..

Re: [RELEASED] Custom Product Tab

Posted: Fri Sep 16, 2011 9:10 pm
by bull5-i
I've tested with OC 1.5.1.1 and I did not see any problems with inserting images, so it's working well.

Released a vQmod version for OpenCart 1.5.1.x

Re: [RELEASED] Custom Product Tab

Posted: Sat Sep 17, 2011 10:11 pm
by markman-b
Thanx for making this extension. Just bought it.

I need 4 extra TABs. Can you give me brief explanation please how to do this?

Re: [RELEASED] Custom Product Tab

Posted: Mon Sep 19, 2011 11:46 pm
by markman-b
I'm still struggling with adding a second extra TAB, but came some steps closer.


- the second extra TAB (I named it specs), is visible now on the product page
- the second extra TAB is also visible on the admin product page, including the texteditor.

However as soon as I enter some text and try to save the productpage, SQL crashes.

I found this message in the errog logfile:
Undefined index: specs2 in admin/model/catalog/product.php on line 431

I editted this file from line 426 to 432 into this:

Code: Select all

$product_description_data[$result['language_id']] = array(
				'name'             => $result['name'],
				'description'      => $result['description'],
				'meta_keyword'     => $result['meta_keyword'],
				'meta_description' => $result['meta_description'],
				'specs'            => $result['specs'],
				'specs2'           => $result['specs2']
			);

And I changed line 13 and line 132 into this:

Code: Select all

$this->db->query("INSERT INTO " . DB_PREFIX . "product_description SET product_id = '" . (int)$product_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', meta_keyword = '" . $this->db->escape($value['meta_keyword']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', description = '" . $this->db->escape($value['description']) . "', specs = '" . $this->db->escape($value['specs']) . "', specs2 = '" . $this->db->escape($value['specs2']) . "'");
I can't see what I'm doing wrong. Please give some support, how to solve the error message.

Kind regards,
Markman-B

Re: [RELEASED] Custom Product Tab

Posted: Tue Sep 20, 2011 2:14 am
by bull5-i
You need to modify your sql table also, because you're missing the column specs2. Every tab needs a corresponding column in the sql table.

Re: [RELEASED] Custom Product Tab

Posted: Tue Sep 20, 2011 3:01 am
by markman-b
Okay thanx for the reply. I have not modified tables in sql before.

I suppose it concerns the table: product_descriptions ?

and than :
- add extra tabel/column
- after spec.

Am i right?


What is the missing line in the manual? Do i need it?

Thanx for helping!

EDIT: It is done!

Re: [RELEASED] Custom Product Tab

Posted: Tue Sep 20, 2011 11:43 pm
by markman-b
I've added 4 extra tabs. The last one is a spare TAB without info. I might use this spare TAB in near future. However, when I disable this setting:

Show always: The tab is visible even if does not contain any data.

Only the first standard TAB (description) is visible. Is it a bug, or did I missed something?

My compliments for this extension. I'm very satisfied with it and it was worth every eurocent 8)

Re: [RELEASED] Custom Product Tab

Posted: Fri Sep 30, 2011 10:24 pm
by bull5-i
It probably just checks the content of the first tab. I do not know exactly what changes you did to implement the 4 tabs.

Added support for OpenCart 1.5.1.3

Re: [RELEASED] Custom Product Tab

Posted: Fri Sep 30, 2011 10:59 pm
by markman-b
Thanx for the update!

I just repeated the steps needed for spec1 and added extra rows ins SQL.



Works fine. No errors, or whatsoever in the logfile

(still using OC 1.5.1.2)

Re: [RELEASED] Custom Product Tab

Posted: Fri Sep 30, 2011 11:09 pm
by bull5-i
In catalog/controller/product/product.php is the evaluation of
$this->data['cpt_show'] = ....
This is (probably for your case) the only variable that is checked to display or not to display the tabs. You would have to make a separate variable for each tab if you want individual control for the tabs.

Re: [RELEASED] Custom Product Tab

Posted: Fri Sep 30, 2011 11:28 pm
by markman-b
Thanx for the advice. I'll take a closer look at it, one of these days.

Error No: 1064

Posted: Fri Oct 07, 2011 1:53 am
by griffinrc
I followed the instructions for install, now I'm getting the following error

Notice: Undefined index: specs in /home/content/13/6473013/html/gemoc/catalog/model/catalog/product.php on line 21Notice: Error: 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 ')' at line 1
Error No: 1064
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM product_to_category p2c WHERE ) in /home/content/13/6473013/html/gemoc/system/database/mysql.php on line 49

I uninstalled the item but it didn't fix the mysql error. help please.

CustomProductTab_1.5.1.1_v1.1.1

http://griffinitsolutions.com/gemoc/

Re: [RELEASED] Custom Product Tab

Posted: Fri Oct 07, 2011 7:22 am
by bull5-i
No SQL sentences are modified in the front end, so you must have done something wrong.
If you did manual installation then check against the premodded files.

Re: [RELEASED] Custom Product Tab

Posted: Fri Oct 07, 2011 7:37 am
by griffinrc
I didn't do the manual install, and I didn't get an error until after I enabled it and added text and saved. Directly afterwards I received the error.