Post by bull5-i » Sun Mar 20, 2011 6:03 pm

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 19938 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 19938 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
Last edited by bull5-i on Fri May 25, 2012 2:02 pm, edited 18 times in total.

|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]

Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus

All mods & extensions by me


Active Member

Posts

Joined
Tue Jan 11, 2011 8:49 pm

Post by ptcole » Thu Mar 31, 2011 4:16 pm

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?

Newbie

Posts

Joined
Mon Oct 25, 2010 8:00 am

Post by luukie33 » Thu May 12, 2011 5:27 pm

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

Newbie

Posts

Joined
Mon May 02, 2011 12:37 am

Post by bull5-i » Tue May 31, 2011 3:57 am

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 19653 times


|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]

Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus

All mods & extensions by me


Active Member

Posts

Joined
Tue Jan 11, 2011 8:49 pm

Post by idealdream » Mon Jul 25, 2011 7:02 am

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

Newbie

Posts

Joined
Thu Dec 03, 2009 5:58 pm

Post by nathalie » Sat Aug 27, 2011 8:06 pm

I have the same problem.
I cant insert images!

New member

Posts

Joined
Tue Feb 23, 2010 12:19 am

Post by Xciso » Tue Aug 30, 2011 1:59 am

Does this work good or not?
I have 1.5.1.1 and i am very intressted in this extension..

Active Member

Posts

Joined
Fri Jul 15, 2011 5:20 am

Post by bull5-i » Fri Sep 16, 2011 9:10 pm

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

|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]

Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus

All mods & extensions by me


Active Member

Posts

Joined
Tue Jan 11, 2011 8:49 pm

Post by markman-b » Sat Sep 17, 2011 10:11 pm

Thanx for making this extension. Just bought it.

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

OC version 1.5.4.1


Active Member

Posts

Joined
Wed Aug 24, 2011 7:13 pm

Post by markman-b » Mon Sep 19, 2011 11:46 pm

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

OC version 1.5.4.1


Active Member

Posts

Joined
Wed Aug 24, 2011 7:13 pm

Post by bull5-i » Tue Sep 20, 2011 2:14 am

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.

|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]

Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus

All mods & extensions by me


Active Member

Posts

Joined
Tue Jan 11, 2011 8:49 pm

Post by markman-b » Tue Sep 20, 2011 3:01 am

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!

OC version 1.5.4.1


Active Member

Posts

Joined
Wed Aug 24, 2011 7:13 pm

Post by markman-b » Tue Sep 20, 2011 11:43 pm

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)

OC version 1.5.4.1


Active Member

Posts

Joined
Wed Aug 24, 2011 7:13 pm

Post by bull5-i » Fri Sep 30, 2011 10:24 pm

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

|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]

Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus

All mods & extensions by me


Active Member

Posts

Joined
Tue Jan 11, 2011 8:49 pm

Post by markman-b » Fri Sep 30, 2011 10:59 pm

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)
Last edited by markman-b on Thu Apr 26, 2012 4:02 pm, edited 1 time in total.

OC version 1.5.4.1


Active Member

Posts

Joined
Wed Aug 24, 2011 7:13 pm

Post by bull5-i » Fri Sep 30, 2011 11:09 pm

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.

|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]

Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus

All mods & extensions by me


Active Member

Posts

Joined
Tue Jan 11, 2011 8:49 pm

Post by markman-b » Fri Sep 30, 2011 11:28 pm

Thanx for the advice. I'll take a closer look at it, one of these days.

OC version 1.5.4.1


Active Member

Posts

Joined
Wed Aug 24, 2011 7:13 pm

Post by griffinrc » Fri Oct 07, 2011 1:53 am

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/

Newbie

Posts

Joined
Fri Oct 07, 2011 1:49 am

Post by bull5-i » Fri Oct 07, 2011 7:22 am

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.

|V|355 \/\/17|-| 7}{3 |3357, ... [you know the rest]

Commercial mods: New! Questions & Answers PRO - Admin Quick Edit PRO - Product Downloads PRO - Custom Product Tab PRO - New! Product Quick Edit Plus

All mods & extensions by me


Active Member

Posts

Joined
Tue Jan 11, 2011 8:49 pm

Post by griffinrc » Fri Oct 07, 2011 7:37 am

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.

Newbie

Posts

Joined
Fri Oct 07, 2011 1:49 am
Who is online

Users browsing this forum: No registered users and 298 guests