Tabbed Products Pro (TPP) Contrib - Official Thread

Hi i am working on add ing this contrib (0.5 beta)

to a zencart 1.3.7 site and i receive this error on product_info

[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 'MAX_DISPLAY_XSELL' at line 8
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '3782' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit MAX_DISPLAY_XSELL]

i allready had cross sell running before i added the

tpl_product_info_display.php file but it seems to be erroring out

Quote:

---

Originally Posted by sgflowers

Hi i am working on add ing this contrib (0.5 beta)

to a zencart 1.3.7 site and i receive this error on product_info

[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 'MAX_DISPLAY_XSELL' at line 8
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '3782' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit MAX_DISPLAY_XSELL]

i allready had cross sell running before i added the

tpl_product_info_display.php file but it seems to be erroring out

---

looks like the advanced cross sell addon removed some of the cross sell configuration that this looks at - all is good as far as this now

2 issue configuring the layout i want

on zen 1.3.7 & TPP 0.5 beta

1) i want the attributes right below the product description above the tabs
but i can't seem to get it to display in the right place - it either goes below the tabs or above the description > i attached my tpl_product_info_display.php

2) i cannot get the model # (details) to appear on my custom tab it only seems to appear below

in my product html code i have

<!--%Product Details%-->
<p><strong>Features:</strong></p>
<ul>
<li>dog&nbsp;accent</li>
<li>large strap</li>
<li>available in aqua, black,&nbsp;or red</li>
</ul>
<p><strong>Material:</strong></p>
<ul>
<li>durable synthetic leather</li>
</ul>
<p><strong>Size: (w x h x d)</strong></p>
<ul>
<li>17 x&nbsp;11 x 4 inches (43 x&nbsp;28 x 10 cm)</li>
</ul>
<!--*sub_DetailsOnTabs(1)*-->

i think i attached the wrong tpl_product_info_display

here is the one i am currently using

you can also see it here

http://www.secretgardenflowers.com/i...oducts_id=3782

I still have both issues

1) i want the attributes right below the product description above the tabs
but i can't seem to get it to display in the right place - it either goes below the tabs or above the description > i attached my tpl_product_info_display.php

2) i cannot get the model # (details) to appear on my custom tab it only seems to appear below

Quote:

---

Originally Posted by sgflowers

i think i attached the wrong tpl_product_info_display

here is the one i am currently using

you can also see it here

http://www.secretgardenflowers.com/i...oducts_id=3782

I still have both issues

1) i want the attributes right below the product description above the tabs
but i can't seem to get it to display in the right place - it either goes below the tabs or above the description > i attached my tpl_product_info_display.php

2) i cannot get the model # (details) to appear on my custom tab it only seems to appear below

---

ok maybe i can work off of this

I attached the current tpl_product_info that i have modified from clyde's layout

http://mysticmountainnaturals.com/te...products_id=21

but what i am trying to change:

- add to cart & attributes just below description on right column
- custom "product details tab" and include details such as model# in this tab
- additional images and cross sell and review in tabs

can anyone suggest how to modify clyde's page to accommodate the above?

I will take a look at it and see what I can do. The sub_details on tab thing might be a bug.

I came across this site and like its tabbed setup. ( Description Features Specifications Warranty Downloads)

a) It looks like TPP will allow something similar, is this correct?

b) Will a store search still yield results based on the tabbed product descriptions?

Quote:

---

Originally Posted by kai920

I came across this site and like its tabbed setup. ( Description Features Specifications Warranty Downloads)

a) It looks like TPP will allow something similar, is this correct?

b) Will a store search still yield results based on the tabbed product descriptions?

---

A) Sure.. you can disable the images and use dotted borders

B) There is no code on the server to change search results. It is completely javascript based on the client so there is absolutely nothing to affect results

Thanks for your reply.

Quote:

---

Originally Posted by qhome

B) There is no code on the server to change search results. It is completely javascript based on the client so there is absolutely nothing to affect results

---

Going back to the previous link, I see that they have detailed specifications listed in a table. So this is just done via simple HTML inside each product's description field, and not in a database?

Off-topic: Is there a mod that will add extra fields such as detailed specs via additional tables in the DB?

Quote:

---

Originally Posted by kai920

Thanks for your reply.



Going back to the previous link, I see that they have detailed specifications listed in a table. So this is just done via simple HTML inside each product's description field, and not in a database?

Off-topic: Is there a mod that will add extra fields such as detailed specs via additional tables in the DB?

---

The Table is likely just html in the product description area, or their cart's detailed specs could be a separate tabular entity. Either way, it can work with TPP (the second option would require a few code modifications but its rather simple)

Zen-Cart refrained from using tables to keep things more div based.. but sometimes a table is a safe option.

There are mods that can be made for ZC to add additional modules for that.. just need someone to make the one you want.