Product Extra Fields for text, pdfs and flash

[giuly]

Hello Thanks for work.
I use 1.5.1
I need this plugin only to add 3 fields of text, is it possible with this plugin?
I don't try to see video swf attached...
I try to read instructions but I didn't find any instructions, I upload all files and then run sql is true?
Last thing if I would to unistall can you say to me what sql command I have to run?
thanks in advance

[delia]

I need this plugin only to add 3 fields of text, is it possible with this plugin?
----Only one text field is provided specifically with this version.
I don't try to see video swf attached...
----Everything is provided that is necesary.
I try to read instructions but I didn't find any instructions, I upload all files and then run sql is true?
----Information in the readme.txt file
Last thing if I would to unistall can you say to me what sql command I have to run?
----Not provided but the install sql installs a new table so there's nothing to remove from the default zen cart tables.

[giuly]

thanks for fast reply ;-)

[Wayne Smith]

This contribution is a big help thanks!

Any way I can get the extra field to show as a column in the product list after clicking a category?

Cheers.

[colmhol]

Hey,

I am using the add-on and its working great, I altered some code to allow it show a size guide on some of our products - now if you click on it the size guide will display in a lightbox popup - check it out! http://www.rockfrocks.com/50s-style-...w-detail-black

However, I now find that when we go into the product details page in the admin, the values in each of the extra field get wiped and appear as blank. This means that each time we update a product description, we have to add the details for product extra fields again. Has anybody else experienced this and is there a solution?

[delia]

did you alter the admin code? I wouldn't think that you would have if you are just adding the lightbox feature. If you didn't then your edits are not at fault and something else is.

[colmhol]

Hey, no I didnt actually. I just edited the product info page. I might be able to restore just the admin page from a previous version. That seems like such an obvious solution now but it never even crossed my mind! Thanks for the pointer!

[athena]

Hi, Where is the install sql ? It does not appear to be in the zip file at the download here at the zen plugin section. I have uploaded all the files but now cannot access my product page in the admin.

[delia]

Well, that's bizarre. I can't believe no one has noticed this before! Here's the sql

DROP TABLE IF EXISTS `product_extra_fields`;
CREATE TABLE `product_extra_fields` (
  `products_id` int(11) NOT NULL default '0',
  `extra_field` text default '',
  `file_1` varchar(50) default NULL,
  `file_2` varchar(50) default NULL,
  `file_3` varchar(50) default NULL,
  `file_4` varchar(50) default NULL,
  `file_1_title` varchar(100) default NULL,
  `file_2_title` varchar(100) default NULL,
  `file_3_title` varchar(100) default NULL,
  `file_4_title` varchar(100) default NULL,
  `video` varchar(150) default NULL,
  `video_title` varchar(50) default NULL,
  `height` smallint(6) default NULL,
  `width` smallint(6) default NULL,
  PRIMARY KEY  (`products_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `product_extra_fields` (`products_id`)
SELECT `products_id` FROM `products` where `products_type` = 1;

Just copy and paste that into your admin > tools > Install SQL patches.

I'll put up the next version and be sure to include the sql. It will be different in the next version.

[athena]

Thank you so much. It seems to be working fine. appreciate your work on this. I wish there were a way to just add fields where you want them to show up on the Product page. The Numinix module for that I just can't get to work but your uploaded and so far no errors. Great contrib. Thank you again.