Tabbed Products ''LITE'' version - Delimiter based

i'm useing the non admin version, i'll give that a try after i upgrade the system

This may be a silly question but I have installed the admin version and run the sql file to update my database. I can see the configuration group settings and the configuration settings in phpmyadmin but I do not get the options in my configuration menu in zen cart.

Any ideas?

Thanks

Rick

disciple:

This may be a silly question but I have installed the admin version and run the sql file to update my database. I can see the configuration group settings and the configuration settings in phpmyadmin but I do not get the options in my configuration menu in zen cart.

Any ideas?

Thanks

Rick

In the Configuration settings, do they all have the same Configuration Group ID number that matches the configuration group that is linked to "tabbed products config" ?

Hi,

I just doubled checked each one and they all match.

Rick

Hi ... can you please help me out.

I've installed the contrib as per your instructions on v.1.3.6 and can see the options in Admin --> Config which is all fine.

When I go to the main product description screen and add my tabs - they just don't show up. The tab identifiers are just ignored and the text for each tab is displayed in the product description area. :cry:

I am using trublu as my template and have copied the files across. Can you just also confirm that there isn't a catalog folder for this template please?

Thanks in advance

TeddyGirl:

Hi ... can you please help me out.

I've installed the contrib as per your instructions on v.1.3.6 and can see the options in Admin --> Config which is all fine.

When I go to the main product description screen and add my tabs - they just don't show up. The tab identifiers are just ignored and the text for each tab is displayed in the product description area. :cry:

I am using trublu as my template and have copied the files across. Can you just also confirm that there isn't a catalog folder for this template please?

Thanks in advance

Do you have a link I can see? PM me if u don't want it public.

I have figured out the issue I was having which makes me feel a bit more than silly maybe on the edge of stupid.

I also have the admin profiles installed and I had not given myself permission to use the tabbed products.

Thanks for a great contribution and help.

Rick

disciple:

I have figured out the issue I was having which makes me feel a bit more than silly maybe on the edge of stupid.

I also have the admin profiles installed and I had not given myself permission to use the tabbed products.

Thanks for a great contribution and help.

Rick

Heh.. never tried that one but good to see it works after u got permission :)

i really think this is cool and i was just curious how you go about making customizing the tab lite to look like this

http://www.winfieldwoodworks.com/catalog/Cutting_Board_12.html

MB1:

i really think this is cool and i was just curious how you go about making customizing the tab lite to look like this

http://www.winfieldwoodworks.com/catalog/Cutting_Board_12.html

Just use colors in the style sheets and remove the background images. Then in the tpl_tabbed_products_lite.php file, you could probably change all "onclick" to "onmouseover"

thank you it's working great

is there a dowloadable version which has the tabs on the side of the like the demo shows or is that still unavailable?

vsymons:

is there a dowloadable version which has the tabs on the side of the like the demo shows or is that still unavailable?

I'm pretty certain qhome reported in this thread (more than once) that he would post here when such update is ready ;-)

If you are happy with what you see on qhomes tabbed products demo page maybe just copy his CSS?

Woody

Woodymon:

I'm pretty certain qhome reported in this thread (more than once) that he would post here when such update is ready ;-)

If you are happy with what you see on qhomes tabbed products demo page maybe just copy his CSS?

Woody

Well I do appologize that it has taken so long. The thing is that I recently have been enlightened to the world of "properly CSS'd Div tags". The current demo was something I was trying with many nested tables, the problem was that I had to change the code to do that.

So lately as I had been thinking of a better layout design, I had realized that the table method was a bad idea.

Then i started planning new layouts and finding the best way to design product info pages.

Then I started thinking about better ways to implement the tabs. Even tho they are already div tag based (no tables). So then as I was thinking about that, I started working on a new fully div based template. Which I do wonder why Zen team decided to use a Table for the main 3 column layout structure of zencart.. it is very limiting.

Anyway.. since I started like 5 things all at once (which is often a bad habit of mine) I haven't put the full effort into the new side view tabs.

But now that I seem to have learned quite a bit, I think it may be time to take another fresh look at the tabs and get the div stuff sorted out so that I can put the tabs on the side simply via use of CSS.

So stay tuned.. i know i said I'd get it done a while ago.. but its better that i do it right :)

qhome:

Are you using a database prefix? To fix your problem, you need to add your database prefix to the sql file.

so globally replace:

FROM configuration_group --> FROM prefix_configuration_group
FROM configuration --> FROM prefix_configuration
INTO configuration_group --> INTO prefix_configuration_group
INTO configuration --> INTO prefix_configuration
UPDATE configuration_group --> UPDATE prefix_configuration_group

Be sure to use the your actual prefix, not just the word "prefix"

Does that help?

If you still can't get it working. There is a NonAdminEdition folder in your /includes/modules/ folder. Copy the version of tabbed_products_lite.php up one level to the includes/modules folder, replacing the existing Admin version. All changes will now have to be made inside the header of that file instead of via the admin panel, but at least it will get you up and running.

I was having the same problem, but the solution quoted didn't work. :(

Instead I ran this modified SQL (note my database prefix of 'zen_')...

DELETE FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Tabbed Products Config' LIMIT 1;
DELETE FROM `configuration` WHERE `configuration_description` LIKE 'Set this to 1%' LIMIT 11;
INSERT INTO configuration_group VALUES ('', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');
SELECT @gid := configuration_group_id FROM `zen_configuration_group` where `configuration_group_title` LIKE 'Tabbed Products Config';
UPDATE configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
INSERT INTO configuration VALUES ('', 'Global Product Description Tab', 'GLOBAL_PROD_DESC_ON_TAB', '1', 'Set this to 1 if you want all products to have the Main Product Description on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Main Image On Tab', 'GLOBAL_MAIN_IMAGE_ON_TAB', '0', 'Set this to 1 if you want the product main image on the first tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Add To Cart Tab', 'GLOBAL_ADD_TO_CART_ON_TAB', '0', 'Set this to 1 if you want the add to cart button on a tab. Note this includes Add To Cart, Qty Discounts, and Option Attributes. The add to cart option will add itself to the first tab if using any custom tabs, otherwise it will make its own tab, which will be the first tab. This keeps the Add to cart button in view at all times no matter the configuration', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Additional Images Tab', 'GLOBAL_ADDL_IMAGES_ON_TAB', '1', 'Set this to 1 if you want the additional images for a product on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Customers Also Purchased Tab', 'GLOBAL_CUST_ALSO_PURCH_ON_TAB', '1', 'Set this to 1 if you want the Customers Also Purchased module on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Media Collection Tab', 'GLOBAL_MEDIA_COLLECTION_ON_TAB', '0', 'Set this to 1 if you want the Media Collection module on its own tab. (MUSIC PRODUCT TYPE ONLY)', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Cross Sell Is Installed', 'CROSS_SELL_IS_INSTALLED', '0', 'Set this to 1 ONLY if you have the Cross Sell contrib installed as per the Cross Sell contribs instructions. This will give an error if you enable this to true without already having it installed', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Cross Sell Tab', 'GLOBAL_CROSS_SELL_ON_TAB', '0', 'Set this to 1 if you want the Cross Sell module on its own tab. This will only work if the setting \"Cross Sell Is Installed\" above is set to 1', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Show Tab Headers', 'SHOW_TAB_HEADERS', '1', 'Set this to 1 if you want a header bar to appear under the tabs, above the tab content', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Show Tab Headers when Javascript is Off', 'SHOW_TAB_HEADERS_NO_JSCRIPT', '1', 'Set this to 1 if you want the header to appear under the tabs when javascript is off. This makes it look nicer and more organized if the customer has javascript off and separates each section with a header bar. Can be used even if the normal Show Tab Header is set to false.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Reviews Tab', 'GLOBAL_REVIEWS_ON_TAB', '1', 'Set this to 1 if you want the Product Reviews to show up on its own tab.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Use Sub Tags', 'GLOBAL_USE_SUB_TAGS', '1', 'Set this to 1 to allow the use of sub tags to allow more than one core module to appear on the same tab.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");

Hope this helps others.

Alex Clarke:

I was having the same problem, but the solution quoted didn't work. :(

Instead I ran this modified SQL (note my database prefix of 'zen_')...

DELETE FROM configuration_group WHERE configuration_group_title LIKE 'Tabbed Products Config' LIMIT 1;
DELETE FROM configuration WHERE configuration_description LIKE 'Set this to 1%' LIMIT 11;
INSERT INTO configuration_group VALUES ('', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');
SELECT @gid := configuration_group_id FROM zen_configuration_group where configuration_group_title LIKE 'Tabbed Products Config';
UPDATE configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
INSERT INTO configuration VALUES ('', 'Global Product Description Tab', 'GLOBAL_PROD_DESC_ON_TAB', '1', 'Set this to 1 if you want all products to have the Main Product Description on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Main Image On Tab', 'GLOBAL_MAIN_IMAGE_ON_TAB', '0', 'Set this to 1 if you want the product main image on the first tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Add To Cart Tab', 'GLOBAL_ADD_TO_CART_ON_TAB', '0', 'Set this to 1 if you want the add to cart button on a tab. Note this includes Add To Cart, Qty Discounts, and Option Attributes. The add to cart option will add itself to the first tab if using any custom tabs, otherwise it will make its own tab, which will be the first tab. This keeps the Add to cart button in view at all times no matter the configuration', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Additional Images Tab', 'GLOBAL_ADDL_IMAGES_ON_TAB', '1', 'Set this to 1 if you want the additional images for a product on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Customers Also Purchased Tab', 'GLOBAL_CUST_ALSO_PURCH_ON_TAB', '1', 'Set this to 1 if you want the Customers Also Purchased module on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Media Collection Tab', 'GLOBAL_MEDIA_COLLECTION_ON_TAB', '0', 'Set this to 1 if you want the Media Collection module on its own tab. (MUSIC PRODUCT TYPE ONLY)', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Cross Sell Is Installed', 'CROSS_SELL_IS_INSTALLED', '0', 'Set this to 1 ONLY if you have the Cross Sell contrib installed as per the Cross Sell contribs instructions. This will give an error if you enable this to true without already having it installed', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Cross Sell Tab', 'GLOBAL_CROSS_SELL_ON_TAB', '0', 'Set this to 1 if you want the Cross Sell module on its own tab. This will only work if the setting "Cross Sell Is Installed" above is set to 1', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Show Tab Headers', 'SHOW_TAB_HEADERS', '1', 'Set this to 1 if you want a header bar to appear under the tabs, above the tab content', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Show Tab Headers when Javascript is Off', 'SHOW_TAB_HEADERS_NO_JSCRIPT', '1', 'Set this to 1 if you want the header to appear under the tabs when javascript is off. This makes it look nicer and more organized if the customer has javascript off and separates each section with a header bar. Can be used even if the normal Show Tab Header is set to false.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Reviews Tab', 'GLOBAL_REVIEWS_ON_TAB', '1', 'Set this to 1 if you want the Product Reviews to show up on its own tab.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Global Use Sub Tags', 'GLOBAL_USE_SUB_TAGS', '1', 'Set this to 1 to allow the use of sub tags to allow more than one core module to appear on the same tab.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");

> 
> Hope this helps others.

Hmm its odd that you would have a prefix zen_configuration_group, but not a prefix of zen_configuration

That's what I was thinking! :|

However, all my tables have a 'zen_' prefix, but when adding this prefix to the SQL above I got errors. :(

Anyway... it all appears to be working now.

Great contribution btw! :)

Alex Clarke:

That's what I was thinking! :|

However, all my tables have a 'zen_' prefix, but when adding this prefix to the SQL above I got errors. :(

Anyway... it all appears to be working now.

Great contribution btw! :)

Well glad its working for you! Thanks for posting it, maybe its some funky nuance of mysql... Technically I never tested this myself as I dont use a prefix so I could only assume.

Glad you like it! :)

One after thorght... could the Install SQL feature add the prefix automatically?

I noticed that some table names were enclosed in '`'. Maybe these will automatically have the prefix added?

Alex Clarke:

One after thorght... could the Install SQL feature add the prefix automatically?

I noticed that some table names were enclosed in '`'. Maybe these will automatically have the prefix added?

Ya could be good. But that would likely need to be added to the zen-cart function code for installing SQL patches. Perhaps a toggle checkbox to prepend the prefix. Maybe ZC 1.3.8 can have it :)