Forums / All Other Contributions/Addons / How to Add Custom Fields for Materials & Dimensions when adding products?

How to Add Custom Fields for Materials & Dimensions when adding products?

Views: 6,754

Results 61 to 80 of 96
29 Apr 2016, 3:32 AM
#61
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

How to Add Custom Fields for Materials & Dimensions when adding products?

Oops Enter it this way:

SELECT configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';


INSERT INTO configuration
( configuration_id,
  configuration_title,
  configuration_key,
  configuration_value,
  configuration_description,
  configuration_group_id,
  sort_order,
  last_modified,
  date_added,
  use_function,
  set_function)
VALUES (
NULL ,  'TPP ñ Extra Product Fields Tab',  ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ',  '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL ,  'zen_cfg_select_option(array(''0'', ''1''),'
)

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

29 Apr 2016, 3:36 AM
#62
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

Nope!

SQL query: Documentation


INSERT INTO configuration
( configuration_id,
  configuration_title,
  configuration_key,
  configuration_value,
  configuration_description,
  configuration_group_id,
  sort_order,
  last_modified,
  date_added,
  use_function,
  set_function)
VALUES (
NULL ,  'TPP ñ Extra Product Fields Tab',  ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ',  '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL ,  'zen_cfg_select_option(array(''0'', ''1''),'
)ELECT configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';
MySQL said: Documentation

#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 'ELECT configuration_group_id 
FROM configuration_group
WHERE configuration_gro' at line 15 
29 Apr 2016, 3:41 AM
#63
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

That one is not my fault. You have mispelt select.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

29 Apr 2016, 3:44 AM
#64
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

mc12345678:

That one is not my fault. You have mispelt select.

Ok, now I got this:

INSERT INTO configuration
( configuration_id,
  configuration_title,
  configuration_key,
  configuration_value,
  configuration_description,
  configuration_group_id,
  sort_order,
  last_modified,
  date_added,
  use_function,
  set_function)
VALUES (
NULL ,  'TPP ñ Extra Product Fields Tab',  ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ',  '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL ,  'zen_cfg_select_option(array(''0'', ''1''),'
)
MySQL said: Documentation

#1048 - Column 'configuration_group_id' cannot be null 
29 Apr 2016, 3:47 AM
#65
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

Figured that would be an issue, but kind of wanted you to see the "process"... Enter it this way:

SELECT configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';


INSERT INTO configuration
(configuration_title,
  configuration_key,
  configuration_value,
  configuration_description,
  configuration_group_id,
  sort_order,
  last_modified,
  date_added,
  use_function,
  set_function)
VALUES (
'TPP ñ Extra Product Fields Tab',  ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ',  '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL ,  'zen_cfg_select_option(array(''0'', ''1''),'
)

There, removed reference to the configuration_id so it should auto increment.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

29 Apr 2016, 3:50 AM
#66
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

mc12345678:

Figured that would be an issue, but kind of wanted you to see the "process"... Enter it this way:

SELECT configuration_group_id
FROM configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';

INSERT INTO configuration
(configuration_title,
configuration_key,
configuration_value,
configuration_description,
configuration_group_id,
sort_order,
last_modified,
date_added,
use_function,
set_function)
VALUES (
'TPP ñ Extra Product Fields Tab', ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ', '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL , 'zen_cfg_select_option(array(''0'', ''1''),'
)

> 
> There, removed reference to the configuration_id so it should auto increment.

Same Error.
29 Apr 2016, 3:56 AM
#67
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

Oh yeah, forgot that what I had been wanting (and the reason the first query was rewritten this way) was to know what the configuration_group_id was going to be.... by adding the second query, it is trying to insert the result(s) which could still end up going to the wrong place... (because the info requested by running the first query all by itself in phpmyadmin isn't known.). So, if you want to try to install this one key, then use both sql queries below and it should add it to the place described in the long text of the first query, otherwise it will be added to the "empty" storage location... if you'd like to know where it's going to store the resulting switch, then run the first query only.Enter it this way:

SELECT @gid:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';


INSERT INTO configuration
(configuration_title,
  configuration_key,
  configuration_value,
  configuration_description,
  configuration_group_id,
  sort_order,
  last_modified,
  date_added,
  use_function,
  set_function)
VALUES (
'TPP ñ Extra Product Fields Tab',  ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ',  '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL ,  'zen_cfg_select_option(array(''0'', ''1''),'
)

There, removed reference to the configuration_id so it should auto increment.[/QUOTE]

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

29 Apr 2016, 3:59 AM
#68
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

mc12345678:

Oh yeah, forgot that what I had been wanting (and the reason the first query was rewritten this way) was to know what the configuration_group_id was going to be.... by adding the second query, it is trying to insert the result(s) which could still end up going to the wrong place... (because the info requested by running the first query all by itself in phpmyadmin isn't known.). So, if you want to try to install this one key, then use both sql queries below and it should add it to the place described in the long text of the first query, otherwise it will be added to the "empty" storage location... if you'd like to know where it's going to store the resulting switch, then run the first query only.Enter it this way:

SELECT @gid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= ' Tabbed Products Pro - Config ';

INSERT INTO configuration
(configuration_title,
configuration_key,
configuration_value,
configuration_description,
configuration_group_id,
sort_order,
last_modified,
date_added,
use_function,
set_function)
VALUES (
'TPP ñ Extra Product Fields Tab', ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ', '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL , 'zen_cfg_select_option(array(''0'', ''1''),'
)

> 
> There, removed reference to the configuration_id so it should auto increment.\[/QUOTE]

Tried that still the same error.
29 Apr 2016, 4:04 AM
#69
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

What that seems to tell me is that this:
configuration_group_title= ' Tabbed Products Pro - Config ' doesn't exist in your database as provided...

So the question becomes, in what configuration menu would you like this option to be applied?

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

29 Apr 2016, 4:06 AM
#70
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

mc12345678:

What that seems to tell me is that this:
configuration_group_title= ' Tabbed Products Pro - Config ' doesn't exist in your database as provided...

So the question becomes, in what configuration menu would you like this option to be applied?

What do you suggest?

29 Apr 2016, 4:21 AM
#71
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

Well the main reason for this mod is to make extra fields for Materials & Dimensions of the items.

30 Apr 2016, 12:02 AM
#72
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

wmorris:

What do you suggest?
I would think the product info configuration menu might make sense... I can't recall the gID for it, but if you select the menu, and look at the uri, you will see the gID that needs to replace with the selection you wish.

That gID would then replace the @gid portion of the second sql statement and the first sql statement would not be needed.

Now I identified the above, but also today there is/was someone that posted one of their preferences is that ZC base menus/configurations not be modified by an outside plugin and that a separate "misc" group be generated to support such additional options. Me personally I'm not hard one way or the other. I think that the overall productivity of using the store should come first such that like the above, something that affects the product info page be relatively applied in that direction. But, at the same time if there was a sort of "sub-group" within it that showed that options were added by a plugin, that would be a plus as well (yet another layer of information/maintenance for the core code). The target of the suggestion by the other zenner was to support and make it easier to upgrade and or take over an existing site from someone else... I get that too. :) Anyways, sorry it took so long to get back to you. Not sure how/if this topic relates to some of the other suggested changes to your site regarding facebook, but if still headed down this direction, maybe it will help. :)

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

30 Apr 2016, 1:14 AM
#73
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

mc12345678:

I would think the product info configuration menu might make sense... I can't recall the gID for it, but if you select the menu, and look at the uri, you will see the gID that needs to replace with the selection you wish.

That gID would then replace the @gid portion of the second sql statement and the first sql statement would not be needed.

Now I identified the above, but also today there is/was someone that posted one of their preferences is that ZC base menus/configurations not be modified by an outside plugin and that a separate "misc" group be generated to support such additional options. Me personally I'm not hard one way or the other. I think that the overall productivity of using the store should come first such that like the above, something that affects the product info page be relatively applied in that direction. But, at the same time if there was a sort of "sub-group" within it that showed that options were added by a plugin, that would be a plus as well (yet another layer of information/maintenance for the core code). The target of the suggestion by the other zenner was to support and make it easier to upgrade and or take over an existing site from someone else... I get that too. :) Anyways, sorry it took so long to get back to you. Not sure how/if this topic relates to some of the other suggested changes to your site regarding facebook, but if still headed down this direction, maybe it will help. :)

There is already a Product Info Configuration Menu.

30 Apr 2016, 1:20 AM
#74
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

wmorris:

There is already a Product Info Configuration Menu.
Yes, of course. That is why I provided direction to identify the criteria needed to obtain the data to modify the above sql and then to run the sql so that this one switch could be added to it...

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

30 Apr 2016, 1:21 AM
#75
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

wmorris:

There is already a Product Info Configuration Menu.
Since you've not got the Tabbed Products Pro plugin installed, you can't insert the configuration option onto the TPP menu.
So, put it on something else. The Product Info menu was suggested. Its ID is usually 18, but if you want to look it up by its name, you'd modify the SQL from earlier to be something like: ```
DELETE from configuration where configuration_key = 'TPP_GLOBAL_EXTRA_FIELDS_ON_TAB';

SELECT @gid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Product Info';

INSERT INTO configuration
(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES ('TPP Extra Product Fields Tab', ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ', '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL , 'zen_cfg_select_option(array(''0'', ''1''),')

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

30 Apr 2016, 1:27 AM
#76
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

DrByte:

Since you've not got the Tabbed Products Pro plugin installed, you can't insert the configuration option onto the TPP menu.
So, put it on something else. The Product Info menu was suggested. Its ID is usually 18, but if you want to look it up by its name, you'd modify the SQL from earlier to be something like: ```
DELETE from configuration where configuration_key = 'TPP_GLOBAL_EXTRA_FIELDS_ON_TAB';

SELECT @gid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Product Info';

INSERT INTO configuration
(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES ('TPP Extra Product Fields Tab', ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ', '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL , 'zen_cfg_select_option(array(''0'', ''1''),')


Yes! Just like the good Dr. said. :) Exactly in fact. Though the DELETE may not properly resolve, because so far/recently the sql has not fully/properly executed because of the lack of a proper group_id...

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

30 Apr 2016, 1:29 AM
#77
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

DrByte:

Since you've not got the Tabbed Products Pro plugin installed, you can't insert the configuration option onto the TPP menu.
So, put it on something else. The Product Info menu was suggested. Its ID is usually 18, but if you want to look it up by its name, you'd modify the SQL from earlier to be something like: ```
DELETE from configuration where configuration_key = 'TPP_GLOBAL_EXTRA_FIELDS_ON_TAB';

SELECT @gid:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Product Info';

INSERT INTO configuration
(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES ('TPP Extra Product Fields Tab', ' TPP_GLOBAL_EXTRA_FIELDS_ON_TAB ', '1', 'Set this to 1 if you want to enable the extra fields on your products', @gid, 1, NOW( ) , NOW( ) , NULL , 'zen_cfg_select_option(array(''0'', ''1''),')


Ok, it did install through the SQL 1 to enable but still doesn't show the extra fields.
30 Apr 2016, 1:38 AM
#78
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

Ok, here is my includes/templates/responsive_sheffield_blue/templates/tpl_product_info_display.php

<?php
/**
 * Page Template
 *
 * Loaded automatically by index.php?main_page=product_info.<br />
 * Displays details of a typical product
 *
 * @package templateSystem
 * @copyright Copyright 2003-2014 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id:  $
 */
 //require(DIR_WS_MODULES . '/debug_blocks/product_info_prices.php');
?>
<div class="centerColumn" id="productGeneral">

<!--bof Form start-->
<?php echo zen_draw_form('cart_quantity', zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params(array('action')) . 'action=add_product', $request_type), 'post', 'enctype="multipart/form-data"') . "\n"; ?>
<!--eof Form start-->

<?php if ($messageStack->size('product_info') > 0) echo $messageStack->output('product_info'); ?>

<!--bof Category Icon -->
<?php if ($module_show_categories != 0) {?>
<?php
/**
 * display the category icons
 */
require($template->get_template_dir('/tpl_modules_category_icon_display.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_category_icon_display.php'); ?>
<?php } ?>
<!--eof Category Icon -->

<!--bof Prev/Next top position -->
<?php if (PRODUCT_INFO_PREVIOUS_NEXT == 1 or PRODUCT_INFO_PREVIOUS_NEXT == 3) { ?>
<?php
/**
 * display the product previous/next helper
 */
require($template->get_template_dir('/tpl_products_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_next_previous.php'); ?>
<?php } ?>
<!--eof Prev/Next top position-->

<!--bof Main Product Image -->
<?php
  if (zen_not_null($products_image)) {
  ?>
<?php
/**
 * display the main product image
 */
   require($template->get_template_dir('/tpl_modules_main_product_image.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_main_product_image.php'); ?>
<?php
  }
?>
<!--eof Main Product Image-->

<!--bof Product Name-->
<h1 id="productName" class="productGeneral"><?php echo $products_name; ?></h1>
<!--eof Product Name-->

<!--bof Product Price block -->
<h2 id="productPrices" class="productGeneral">
<?php
// base price
  if ($show_onetime_charges_description == 'true') {
    $one_time = '<span >' . TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION . '</span><br />';
  } else {
    $one_time = '';
  }
  echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);
?></h2>
<!--eof Product Price block -->

<!--bof free ship icon  -->
<?php if(zen_get_product_is_always_free_shipping($products_id_current) && $flag_show_product_info_free_shipping) { ?>
<div id="freeShippingIcon"><?php echo TEXT_PRODUCT_FREE_SHIPPING_ICON; ?></div>
<?php } ?>
<!--eof free ship icon  -->

 <!--bof Product description -->
<?php if ($products_description != '') { ?>
<div id="productDescription" class="productGeneral biggerText"><?php echo stripslashes($products_description); ?></div>
<?php } ?>

<?php 
if (!TPP_GLOBAL_EXTRA_FIELDS_ON_TAB) {
	
	?>

<?php if (isset($products_file_1_link) || isset($products_file_2_link) || isset($products_file_3_link) || isset($products_file_4_link) || isset($video_file_link) || isset($extra_field) || isset($text_1) ||isset($text_2) || isset($text_3) || isset($text_4)) {
        echo  '<div class="files"><div class="filesHead">'.TEXT_PRODUCT_MORE_INFO.'</div><ul>';
		  }?>
<?php if($extra_field!='') { 
    echo '<li>'.$extra_field . '</li>';
} ?>
<?php if($text_1!='') { 
    echo '<li>'. PRODUCT_TEXT_1 .' '.$text_1 . '</li>';
} ?>
<?php if($text_2!='') { 
    echo '<li>'. PRODUCT_TEXT_2 .' '.$text_2 . '</li>';
} ?>
<?php if($text_3!='') { 
    echo '<li>'. PRODUCT_TEXT_3 .' '.$text_3 . '</li>';
} ?>
<?php if($text_4!='') { 
    echo '<li>'. PRODUCT_TEXT_4 .' '.$text_4 . '</li>';
} ?>
 
<?php if(isset($products_video_link)) { 
    echo '<li>'.$products_video_link . '</li>';
} ?> 
<?php if(isset($products_file_1_link)) { 
    echo '<li>'.$products_file_1_link . '</li>';
} ?>    
<?php if(isset($products_file_2_link)) {
    echo '<li>'.$products_file_2_link . '</li>';
} ?>    
<?php if(isset($products_file_3_link)) {
    echo '<li>'.$products_file_3_link. '</li>';
}  ?>
<?php if(isset($products_file_4_link)) {
    echo '<li>'.$products_file_4_link;
} 
if(isset($products_file_1_link) || isset($products_file_2_link) || isset($products_file_3_link) || isset($products_file_4_link) || isset($video_file_link) || isset($extra_field)) {
echo '</ul></div>';
}
?>

 <?php 
}
 ?>
<!--eof Product description -->
<br class="clearBoth" />

<!--bof Add to Cart Box -->
<?php
if (CUSTOMERS_APPROVAL == 3 and TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE_SHOWROOM == '') {
  // do nothing
} else {
?>
            <?php
    $display_qty = (($flag_show_product_info_in_cart_qty == 1 and $_SESSION['cart']->in_cart($_GET['products_id'])) ? '<p>' . PRODUCTS_ORDER_QTY_TEXT_IN_CART . $_SESSION['cart']->get_quantity($_GET['products_id']) . '</p>' : '');
            if ($products_qty_box_status == 0 or $products_quantity_order_max== 1) {
              // hide the quantity box and default to 1
              $the_button = '<input type="hidden" name="cart_quantity" value="1" />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            } else {
              // show the quantity box
    $the_button = PRODUCTS_ORDER_QTY_TEXT . '<input type="text" name="cart_quantity" value="' . (zen_get_buy_now_qty($_GET['products_id'])) . '" maxlength="6" size="4" /><br />' . zen_get_products_quantity_min_units_display((int)$_GET['products_id']) . '<br />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            }
    $display_button = zen_get_buy_now_button($_GET['products_id'], $the_button);
  ?>
  <?php if ($display_qty != '' or $display_button != '') { ?>
    <div id="cartAdd">
    <?php
      echo $display_qty;
      echo $display_button;
            ?>
          </div>
  <?php } // display qty and button ?>
<?php } // CUSTOMERS_APPROVAL == 3 ?>
<!--eof Add to Cart Box-->

<!--bof Product details list  -->
<?php if ( (($flag_show_product_info_model == 1 and $products_model != '') or ($flag_show_product_info_weight == 1 and $products_weight !=0) or ($flag_show_product_info_quantity == 1) or ($flag_show_product_info_manufacturer == 1 and !empty($manufacturers_name))) ) { ?>
<ul id="productDetailsList" class="floatingBox back">
  <?php echo (($flag_show_product_info_model == 1 and $products_model !='') ? '<li>' . TEXT_PRODUCT_MODEL . $products_model . '</li>' : '') . "\n"; ?>
  <?php echo (($flag_show_product_info_weight == 1 and $products_weight !=0) ? '<li>' . TEXT_PRODUCT_WEIGHT .  $products_weight . TEXT_PRODUCT_WEIGHT_UNIT . '</li>'  : '') . "\n"; ?>
  <?php echo (($flag_show_product_info_quantity == 1) ? '<li>' . $products_quantity . TEXT_PRODUCT_QUANTITY . '</li>'  : '') . "\n"; ?>
  <?php echo (($flag_show_product_info_manufacturer == 1 and !empty($manufacturers_name)) ? '<li>' . TEXT_PRODUCT_MANUFACTURER . $manufacturers_name . '</li>' : '') . "\n"; ?>
</ul>
<br class="clearBoth" />
<?php
  }
?>
<!--eof Product details list -->

<!--bof Attributes Module -->
<?php
  if ($pr_attr->fields['total'] > 0) {
?>
<?php
/**
 * display the product atributes
 */
  require($template->get_template_dir('/tpl_modules_attributes.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_attributes.php'); ?>
<?php
  }
?>
<!--eof Attributes Module -->

<!--bof Quantity Discounts table -->
<?php
  if ($products_discount_type != 0) { ?>
<?php
/**
 * display the products quantity discount
 */
 require($template->get_template_dir('/tpl_modules_products_quantity_discounts.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_products_quantity_discounts.php'); ?>
<?php
  }
?>
<!--eof Quantity Discounts table -->

<!--bof Additional Product Images -->
<?php
/**
 * display the products additional images
 */
  require($template->get_template_dir('/tpl_modules_additional_images.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_additional_images.php'); ?>
<!--eof Additional Product Images -->

<!--bof Prev/Next bottom position -->
<?php if (PRODUCT_INFO_PREVIOUS_NEXT == 2 or PRODUCT_INFO_PREVIOUS_NEXT == 3) { ?>
<?php
/**
 * display the product previous/next helper
 */
 require($template->get_template_dir('/tpl_products_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_next_previous.php'); ?>
<?php } ?>
<!--eof Prev/Next bottom position -->

<!--bof Reviews button and count-->
<?php
  if ($flag_show_product_info_reviews == 1) {
    // if more than 0 reviews, then show reviews button; otherwise, show the "write review" button
    if ($reviews->fields['count'] > 0 ) { ?>
<div id="productReviewLink" class="buttonRow back"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params()) . '">' . zen_image_button(BUTTON_IMAGE_REVIEWS, BUTTON_REVIEWS_ALT) . '</a>'; ?></div>
<br class="clearBoth" />
<p class="reviewCount"><?php echo ($flag_show_product_info_reviews_count == 1 ? TEXT_CURRENT_REVIEWS . ' ' . $reviews->fields['count'] : ''); ?></p>
<?php } else { ?>
<div id="productReviewLink" class="buttonRow back"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, zen_get_all_get_params(array())) . '">' . zen_image_button(BUTTON_IMAGE_WRITE_REVIEW, BUTTON_WRITE_REVIEW_ALT) . '</a>'; ?></div>
<br class="clearBoth" />
<?php
  }
}
?>
<!--eof Reviews button and count -->


<!--bof Product date added/available-->
<?php
  if ($products_date_available > date('Y-m-d H:i:s')) {
    if ($flag_show_product_info_date_available == 1) {
?>
  <p id="productDateAvailable" class="productGeneral centeredContent"><?php echo sprintf(TEXT_DATE_AVAILABLE, zen_date_long($products_date_available)); ?></p>
<?php
    }
  } else {
    if ($flag_show_product_info_date_added == 1) {
?>
      <p id="productDateAdded" class="productGeneral centeredContent"><?php echo sprintf(TEXT_DATE_ADDED, zen_date_long($products_date_added)); ?></p>
<?php
    } // $flag_show_product_info_date_added
  }
?>
<!--eof Product date added/available -->

<!--bof Product URL -->
<?php
  if (zen_not_null($products_url)) {
    if ($flag_show_product_info_url == 1) {
?>
    <p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=product&products_id=' . zen_output_string_protected($_GET['products_id']), 'NONSSL', true, false)); ?></p>
<?php
    } // $flag_show_product_info_url
  }
?>
<!--eof Product URL -->

<!--bof also purchased products module-->
<?php require($template->get_template_dir('tpl_modules_also_purchased_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_also_purchased_products.php');?>
<!--eof also purchased products module-->

<!--bof Form close-->
</form>
<!--bof Form close-->
</div>
30 Apr 2016, 1:40 AM
#79
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

To rule out the TPP thing, find this line:if (!TPP_GLOBAL_EXTRA_FIELDS_ON_TAB) {and replace with:```
if(true) {

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

30 Apr 2016, 1:51 AM
#80
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,683
Plugin Contributions:
0

Re: How to Add Custom Fields for Materials & Dimensions when adding products?

DrByte:

To rule out the TPP thing, find this line:if (!TPP_GLOBAL_EXTRA_FIELDS_ON_TAB) {and replace with:```
if(true) {


Ok, it worked but with another issue.

When enter this in the text 1 its suppose to be this: 5.5" x 2.5" x 8.5" and came out this: 5.5" x 2.5" x 8.5"