Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

VJ

Easy Populate & Products Attributes

Recommended Posts

Guest

froogle does not accept this info anymore, so comment out in your files:

 

/*
if ( $dltype=='froogle' ){
 // set the things froogle wants at the top of the file
 $filestring .= "# html_escaped=YES\n";
 $filestring .= "# updates_only=NO\n";
 $filestring .= "# product_type=OTHER\n";
 $filestring .= "# quoted=YES\n";
}
*/

 

change a few lines further down:

  // if the filelayout says we need a products_name, get it
 // build the long full froogle image path
 $row['v_products_fullpath_image'] = $froogle_image_path . $row['v_products_image'];
 // Other froogle defaults go here for now
 $row['v_froogle_instock']    = 'Y';
 $row['v_froogle_shipping'] 	 = '';
 $row['v_froogle_brand'] 	 = $row['v_products_name'];
 $row['v_froogle_upc']    = '';
 $row['v_froogle_manufacturer_id']	= $row['v_products_model'];
//  $row['v_froogle_quantitylevel']  = '';
//  $row['v_froogle_exp_date']  = '';
 $row['v_froogle_product_type']  = 'OTHER';
//  $row['v_froogle_delete']  = ''; not used/needed
 $row['v_froogle_currency'] 	 = 'USD';
 $row['v_froogle_offer_id'] 	 = $row['v_products_model'];
 $row['v_froogle_product_id']  = $row['v_products_model'];

Share this post


Link to post
Share on other sites
Guest

quite a ways further down is the sql select, where you need to add your fields. i found the easiest way to add whatever field you want to add is search for products_model and duplicate the same format:

  $filelayout_sql = "SELECT
	 p.products_id as v_products_id,
	 p.products_model as v_products_model,
	 p.products_image as v_products_image,
	 p.products_price as v_products_price,
	 p.products_weight as v_products_weight,
	 p.dvd_star as v_dvd_star,
	 p.dvd_director as v_dvd_director,
	 p.dvd_release_date as v_dvd_release_date,
	 p.dvd_type as v_dvd_type,
	 p.dvd_features as v_dvd_features,
	 p.dvd_studio as v_dvd_studio,
	 p.dvd_categories as v_dvd_categories,
	 p.dvd_movie_length as v_dvd_movie_length,
	 p.dvd_also_available as v_dvd_also_available,
	 p.products_bimage as v_products_bimage,
	 p.products_subimage1 as v_products_subimage1,
	 p.products_bsubimage1 as v_products_bsubimage1,
	 p.products_date_available as v_date_avail,
	 p.products_date_added as v_date_added,
	 p.products_tax_class_id as v_tax_class_id,
	 p.products_quantity as v_products_quantity,
	 p.manufacturers_id as v_manufacturers_id,
	 subc.categories_id as v_categories_id,
	 p.products_status as v_status
	 FROM
	 ".TABLE_PRODUCTS." as p,
	 ".TABLE_CATEGORIES." as subc,
	 ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc
	 WHERE
	 p.products_id = ptoc.products_id AND
	 ptoc.categories_id = subc.categories_id
	 ";

Share this post


Link to post
Share on other sites
Guest

search for and modify per your site here:

  $filelayout = array(
	 'v_froogle_products_url_1' 	 => $iii++,
	 );
 //
 // here we need to get the default language and put
 $l_id = 1; // dummy it in for now.
//  foreach ($langcode as $key => $lang){
// 	 $l_id = $lang['id'];
	 $filelayout  = array_merge($filelayout , array(
  	 'v_froogle_products_name_' . $l_id  => $iii++,
  	 'v_froogle_products_description_' . $l_id	=> $iii++,
  	 ));
//  }
 $filelayout  = array_merge($filelayout , array(
	 'v_products_price'  => $iii++,
	 'v_products_fullpath_image'	=> $iii++,
	 'v_category_fullpath'  => $iii++,
	 'v_froogle_offer_id'  => $iii++,
	 'v_froogle_instock'  => $iii++,
	 'v_froogle_ shipping'  => $iii++,
	 'v_manufacturers_name'  => $iii++,
	 'v_froogle_ upc'  => $iii++,
// 	 'v_froogle_color'  => $iii++,
// 	 'v_froogle_size'  => $iii++,
// 	 'v_froogle_quantitylevel'	=> $iii++,
	 'v_froogle_product_id'  => $iii++,
	 'v_froogle_manufacturer_id'	=> $iii++,
// 	 'v_froogle_exp_date'  => $iii++,
	 'v_froogle_product_type'	=> $iii++,
// 	 'v_froogle_delete'  => $iii++,
	 'v_froogle_currency'  => $iii++,
   ));
 $iii=0;
 $fileheaders = array(
	 'product_url'	=> $iii++,
	 'name' 	 => $iii++,
	 'description'	=> $iii++,
	 'price' 	 => $iii++,
	 'image_url'  => $iii++,
	 'category'  => $iii++,
	 'offer_id'  => $iii++,
	 'instock'  => $iii++,
	 'shipping'  => $iii++,
	 'brand' 	 => $iii++,
	 'upc' 	 => $iii++,
// 	 'color' 	 => $iii++, //not used/needed
// 	 'size' 	 => $iii++, //not used/needed
// 	 'quantity'  => $iii++, //not used/needed
	 'product_id'  => $iii++, //not used/needed
	 'manufacturer_id'	=> $iii++, //manufacturer part#
// 	 'exp_date'  => $iii++, //not used/needed
	 'product_type'  => $iii++, //not needed
// 	 'delete'  => $iii++, //not needed
	 'currency'  => $iii++, //if blank, usd
	 );
 $filelayout_sql = "SELECT
	 p.products_id as v_products_id,
	 p.products_model as v_products_model,
	 p.products_image as v_products_image,
	 p.products_price as v_products_price,
	 p.products_weight as v_products_weight,
	 p.dvd_star as v_dvd_star,
	 p.dvd_director as v_dvd_director,
	 p.dvd_release_date as v_dvd_release_date,
	 p.dvd_type as v_dvd_type,
	 p.dvd_features as v_dvd_features,
	 p.dvd_studio as v_dvd_studio,
	 p.dvd_categories as v_dvd_categories,
	 p.dvd_movie_length as v_dvd_movie_length,
	 p.dvd_also_available as v_dvd_also_available,
	 p.products_bimage as v_products_bimage,
	 p.products_subimage1 as v_products_subimage1,
	 p.products_bsubimage1 as v_products_bsubimage1,
	 p.products_date_added as v_date_avail,
	 p.products_tax_class_id as v_tax_class_id,
	 p.products_quantity as v_products_quantity,
	 p.manufacturers_id as v_manufacturers_id,
	 subc.categories_id as v_categories_id
	 FROM
	 ".TABLE_PRODUCTS." as p,
	 ".TABLE_CATEGORIES." as subc,
	 ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc
	 WHERE
	 p.products_id = ptoc.products_id AND
	 ptoc.categories_id = subc.categories_id
	 ";
 break;

Share this post


Link to post
Share on other sites
Guest

and here:

 	 $sql = "SHOW TABLE STATUS LIKE '".TABLE_PRODUCTS."'";
	 $result = tep_db_query($sql);
	 $row =  tep_db_fetch_array($result);
	 $max_product_id = $row['Auto_increment'];
	 if (!is_numeric($max_product_id) ){
   $max_product_id=1;
	 }
	 $v_products_id = $max_product_id;
	 echo "<font color='green'> !New Product!</font><br>";

	 $query = "INSERT INTO ".TABLE_PRODUCTS." (
  	 products_image,
  	 products_model,
  	 products_price,
  	 products_status,
  	 products_last_modified,
  	 products_date_added,
  	 products_date_available,
  	 products_tax_class_id,
  	 products_weight,
  	 dvd_star,
  	 dvd_director,
  	 dvd_release_date,
  	 dvd_type,
  	 dvd_features,
  	 dvd_studio,
  	 dvd_categories,
  	 dvd_movie_length,
  	 dvd_also_available,
  	 products_bimage,
  	 products_subimage1,
  	 products_bsubimage1,
  	 products_quantity,
  	 manufacturers_id)
     VALUES (
    	 '$v_products_image',";

	 // unmcomment these lines if you are running the image mods
	 /*
   $query .=	. $v_products_mimage . '", "'
    	 . $v_products_bimage . '", "'
    	 . $v_products_subimage1 . '", "'
    	 . $v_products_bsubimage1 . '", "'
    	 . $v_products_subimage2 . '", "'
    	 . $v_products_bsubimage2 . '", "'
    	 . $v_products_subimage3 . '", "'
    	 . $v_products_bsubimage3 . '", "'
	 */

	 $query .="  '$v_products_model',
    	 '$v_products_price',
    	 '$v_db_status',
    	 CURRENT_TIMESTAMP,
    	 $v_date_added,
    	 $v_date_avail,
    	 '$v_tax_class_id',
    	 '$v_products_weight',
    	 '$v_dvd_star',
    	 '$v_dvd_director',
    	 '$v_dvd_release_date',
    	 '$v_dvd_type',
    	 '$v_dvd_features',
    	 '$v_dvd_studio',
    	 '$v_dvd_categories',
    	 '$v_dvd_movie_length',
    	 '$v_dvd_also_available',
    	 '$v_products_bimage',
    	 '$v_products_subimage1',
    	 '$v_products_bsubimage1',
    	 '$v_products_quantity',
    	 '$v_manufacturer_id')
    	 ";
   $result = tep_db_query($query);
 } else {
	 // existing product, get the id from the query
	 // and update the product data
	 $row =  tep_db_fetch_array($result);
	 $v_products_id = $row['products_id'];
	 echo "<font color='black'> Updated</font><br>";
	 $row =  tep_db_fetch_array($result);
	 $query = 'UPDATE '.TABLE_PRODUCTS.'
  	 SET
  	 products_price="'.$v_products_price.
  	 '" ,products_image="'.$v_products_image;

	 // uncomment these lines if you are running the image mods 
/*
   $query .= '" ,products_mimage="'.$v_products_mimage.
  	 '" ,products_bimage="'.$v_products_bimage.
  	 '" ,products_subimage1="'.$v_products_subimage1.
  	 '" ,products_bsubimage1="'.$v_products_bsubimage1.
  	 '" ,products_subimage2="'.$v_products_subimage2.
  	 '" ,products_bsubimage2="'.$v_products_bsubimage2.
  	 '" ,products_subimage3="'.$v_products_subimage3.
  	 '" ,products_bsubimage3="'.$v_products_bsubimage3;
*/

	 $query .= '", products_weight="'.$v_products_weight .
  	 '", dvd_star="'.$v_dvd_star .
  	 '", dvd_director="'.$v_dvd_director .
  	 '", dvd_release_date="'.$v_dvd_release_date .
  	 '", dvd_type="'.$v_dvd_type .
  	 '", dvd_features="'.$v_dvd_features .
  	 '", dvd_studio="'.$v_dvd_studio .
  	 '", dvd_categories="'.$v_dvd_categories .
  	 '", dvd_movie_length="'.$v_dvd_movie_length .
  	 '", dvd_also_available="'.$v_dvd_also_available .
  	 '", products_bimage="'.$v_products_bimage .
  	 '", products_subimage1="'.$v_products_subimage1 .
  	 '", products_bsubimage1="'.$v_products_bsubimage1 .
  	 '", products_tax_class_id="'.$v_tax_class_id . 
  	 '", products_date_available= ' . $v_date_avail .
  	 ', products_date_added= ' . $v_date_added .
  	 ', products_last_modified=CURRENT_TIMESTAMP
  	 , products_quantity="' . $v_products_quantity .  
  	 '" ,manufacturers_id=' . $v_manufacturer_id . 
  	 ' , products_status=' . $v_db_status . '
  	 WHERE
     (products_id = "'. $v_products_id . '")';

	 $result = tep_db_query($query);
 }

 

basically the whole thing in a nutshell

Share this post


Link to post
Share on other sites

Mibble - post #927 shows a easypopulate file with the lines commented out for the image mods contribs. I am posting the same section of code (approx. lines 1690 to 1740) uncommented. I believe I have followed the instructions given in post #86 (and a few others) in order to get the big_image mod to work. I still get the dreaded parse error as I open the page. I replace the comments and the page parses correctly. DB is updated correctly. osC 2.2 MS2. Any thoughts?

 

 	 // unmcomment these lines if you are running the image mods
	 
         $query =	. $v_products_mimage . '", "'
    	 . $v_products_bimage . '", "'
    	 . $v_products_subimage1 . '", "'
    	 . $v_products_bsubimage1 . '", "'
    	 . $v_products_subimage2 . '", "'
    	 . $v_products_bsubimage2 . '", "'
    	 . $v_products_subimage3 . '", "'
    	 . $v_products_bsubimage3 . '", "'
     

	 $query .="    '$v_products_model',
       '$v_products_price',
       '$v_db_status',
       CURRENT_TIMESTAMP,
       $v_date_added,
       $v_date_avail,
       '$v_tax_class_id',
       '$v_products_weight',
       '$v_products_quantity',
       '$v_manufacturer_id')
    	 ";
   $result = tep_db_query($query);
 } else {
	 // existing product, get the id from the query
	 // and update the product data
	 $row =  tep_db_fetch_array($result);
	 $v_products_id = $row['products_id'];
	 echo "<font color='black'> Updated</font><br>";
	 $row =  tep_db_fetch_array($result);
	 $query = 'UPDATE '.TABLE_PRODUCTS.'
  	 SET
  	 products_price="'.$v_products_price.
  	 '" ,products_image="'.$v_products_image;

	 // uncomment these lines if you are running the image mods

   $query =
  	 '" ,products_mimage="'.$v_products_mimage.
  	 '" ,products_bimage="'.$v_products_bimage.
  	 '" ,products_subimage1="'.$v_products_subimage1.
  	 '" ,products_bsubimage1="'.$v_products_bsubimage1.
  	 '" ,products_subimage2="'.$v_products_subimage2.
  	 '" ,products_bsubimage2="'.$v_products_bsubimage2.
  	 '" ,products_subimage3="'.$v_products_subimage3.
  	 '" ,products_bsubimage3="'.$v_products_bsubimage3;

 

Thanks for sharing your time.

Stewart

Share this post


Link to post
Share on other sites
Guest

what is the parse error you are getting? (this helps me narrow down where your error is)

 

by the way, for some reason i dont get any emails from the forum anymore when someone makes a post, even tho i am subscribed

Edited by Mibble

Share this post


Link to post
Share on other sites

Here are the first couple of mines from my error where the EP does not recognize the model no. This is what EP shows when I try to import...

 

File uploaded.

Termporary filename: /tmp/php95UvIK

User filename: EP_Split1.txt

Size: 86839

| m26090 | 26090.jpg | Creative L | Creative L | | 44.38 | | 10/28/2004 | 10/28/2004 | 99 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Creative L | Accessorie | | | GST/HST/PS | Active

 

No products_model field in record. This line was not imported

 

| 18461 | 18461.jpg | SOUND BLAS | SOUND BLAS | | 19.38 | | 10/28/2004 | 10/28/2004 | 99 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Creative L | Accessorie | | | GST/HST/PS | Active

 

 

Here is the notepad version...

Model Image Product Name Description URL Retail Price Weight Date Avail. Date Added Quantity Option No. Value Option No. Value Option No. Value Option No. Value Value 2 Option No. Value Value Option No. v_attribute_values_price_3_3 v_attribute_values_name_3_3_1 v_attribute_values_id_3_4 v_attribute_values_price_3_4 v_attribute_values_name_3_4_1 v_attribute_values_id_3_5 v_attribute_values_price_3_5 v_attribute_values_name_3_5_1 v_attribute_options_id_4 v_attribute_options_name_4_1 v_attribute_values_id_4_1 v_attribute_values_price_4_1 v_attribute_values_name_4_1_1 v_attribute_values_id_4_2 v_attribute_values_price_4_2 v_attribute_values_name_4_2_1 v_attribute_values_id_4_3 v_attribute_values_price_4_3 v_attribute_values_name_4_3_1 v_attribute_values_id_4_4 v_attribute_values_price_4_4 v_attribute_values_name_4_4_1 v_attribute_options_id_5 v_attribute_options_name_5_1 v_attribute_values_id_5_1 v_attribute_values_price_5_1 v_attribute_values_name_5_1_1 v_attribute_values_id_5_2 v_attribute_values_price_5_2 v_attribute_values_name_5_2_1 v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_tax_class_title v_status EOREOR

m26090 26090.jpg Creative Lab Headphone HN-505 Black Creative Lab Headphone HN-505 Black 44.38 10/28/2004 8:00 10/28/2004 8:00 99 Creative Labs Accessories GST/HST/PST Active EOREOR

18461 18461.jpg SOUND BLASTER AUDIGY 2 BLACK DRIVE FACEPLATE KIT SOUND BLASTER AUDIGY 2 BLACK DRIVE FACEPLATE KIT 19.38 10/28/2004 8:00 10/28/2004 8:00 99 Creative Labs Accessories GST/HST/PST Active EOREOR

 

Thanks for taking the time, much appreciated.

Share this post


Link to post
Share on other sites
Guest

needs to be:

v_products_model v_products_image v_products_name v_products_description

 

there are more, but that is how the header needs to be,

Edited by Mibble

Share this post


Link to post
Share on other sites
what is the parse error you are getting? (this helps me narrow down where your error is)

 

by the way, for some reason i dont get any emails from the forum anymore when someone makes a post, even tho i am subscribed

 

 

"Parse error: parse error, unexpected '.' in XXX\admin\easypopulate.php on line 1692"

 

I get this parse error when uncommenting the lines that support big_images contribution. See post #928

 

Thanks, Stewart

Edited by stewart

Share this post


Link to post
Share on other sites
"Parse error: parse error, unexpected '.' in XXX\admin\easypopulate.php on line 1692"

 

I get this parse error when uncommenting the lines that support big_images contribution. See post #928

 

Thanks, Stewart

 

 

Forgot to mention that I am using EP 2.74 for MS2

 

Thanks,

Stewart

Share this post


Link to post
Share on other sites
Guest

try it this way then: you will have to make adjustments to your code, this one has additional fields

 

	$query .="  '$v_products_model',
    	 '$v_products_price',
    	 '$v_db_status',
    	 CURRENT_TIMESTAMP,
    	 $v_date_added,
    	 $v_date_avail,
    	 '$v_tax_class_id',
    	 '$v_products_weight',
    	 '$v_dvd_star',
    	 '$v_dvd_director',
    	 '$v_dvd_release_date',
    	 '$v_dvd_type',
    	 '$v_dvd_features',
    	 '$v_dvd_studio',
    	 '$v_dvd_categories',
    	 '$v_dvd_movie_length',
     '$v_dvd_also_available',
     
$v_products_mimage . '", "'
    	 . $v_products_bimage . '", "'
    	 . $v_products_subimage1 . '", "'
    	 . $v_products_bsubimage1 . '", "'
    	 . $v_products_subimage2 . '", "'
    	 . $v_products_bsubimage2 . '", "'
    	 . $v_products_subimage3 . '", "'
    	 . $v_products_bsubimage3 . '", "'
    	 '$v_products_quantity',
    	 '$v_manufacturer_id')
    	 ";

Share this post


Link to post
Share on other sites
try it this way then:  you will have to make adjustments to your code, this one has additional fields

 

	$query .=" ?'$v_products_model',
? ? ?	'$v_products_price',
? ? ?	'$v_db_status',
? ? ?	CURRENT_TIMESTAMP,
? ? ?	$v_date_added,
? ? ?	$v_date_avail,
? ? ?	'$v_tax_class_id',
? ? ?	'$v_products_weight',
? ? ?	'$v_dvd_star',
? ? ?	'$v_dvd_director',
? ? ?	'$v_dvd_release_date',
? ? ?	'$v_dvd_type',
? ? ?	'$v_dvd_features',
? ? ?	'$v_dvd_studio',
? ? ?	'$v_dvd_categories',
? ? ?	'$v_dvd_movie_length',
? ? ?'$v_dvd_also_available',
? ? ?
$v_products_mimage . '", "'
? ? ?	. $v_products_bimage . '", "'
? ? ?	. $v_products_subimage1 . '", "'
? ? ?	. $v_products_bsubimage1 . '", "'
? ? ?	. $v_products_subimage2 . '", "'
? ? ?	. $v_products_bsubimage2 . '", "'
? ? ?	. $v_products_subimage3 . '", "'
? ? ?	. $v_products_bsubimage3 . '", "'
? ? ?	'$v_products_quantity',
? ? ?	'$v_manufacturer_id')
? ? ?	";

 

Mibble - the only change that I can that you made was to remove the query statement and the subsequent dot on the same line. I have tried it anyway, and the error has changed to "Unexpected T_Variable on line 1702"

 

Did I miss something? Stewart

Share this post


Link to post
Share on other sites
Guest

it has to be dealing with something else in your code, as i took that from a different working ep file . . .

Share this post


Link to post
Share on other sites

Mibble - I have also installed Linda's "Header Tag Controller", and Steve's "Wolfen_Featured_Sets", both prior to installing EP 2.74.

 

I will start to look how these interplay, but they are working.

 

Any other thoughts/suggestions?

 

I appreciate the help already afforded me, and hope that it will continue for myself and everyone else here. Great job.

 

Thanks,

Stewart

Share this post


Link to post
Share on other sites
Mibble - I have also installed Linda's "Header Tag Controller", and Steve's "Wolfen_Featured_Sets", both prior to installing EP 2.74.

 

I will start to look how these interplay, but they are working.

 

Any other thoughts/suggestions?

 

I appreciate the help already afforded me, and hope that it will continue for myself and everyone else here. Great job.

 

Thanks,

Stewart

 

 

Back to getting the "Parse error: parse error, unexpected '.' in . . . /admin/easypopulate.php on line 1692"

 

Stewart

Share this post


Link to post
Share on other sites
Guest

Stumped on this one ..

 

I'm using EP 2.74 and when I create Model/price, Model/category & froogle downloads, they all import into Excel fine.

 

When I use the "full" export download, Excel reads it into one column(A) and then breaks it into multiple rows

 

Same data in all downloads - 3 work, the full one doesn't

 

Any suggestions/help would be greatly appreciated.

 

(PS - I also downloaded a clean version of EP and same issue)

 

Note: When I copied the froogle striptags prod_description code to the full download, the file imported correctly into Excel but naturally I lost all the HTML tags (I'm using the HTML editor for prod descriptions)

 

Thanks !

Share this post


Link to post
Share on other sites
Guest

send me your easypopulate.php and your data file, i will look sometime this weekend

Share this post


Link to post
Share on other sites

Hi,

I need help with Easypopulate work along side with Product Extra Fields

 

I have downloaded and install "Product Extra Fields" Contribution, Everythings worked beautifully.

 

I have added these fields with the "Product Extra Fields" feature:

 

 

Media Format

Audio/Language

Subtitles

Number of Discs

Regions Coding

Episodes

Running Time

Release By

Genre

Release Date

 

However when I download the "Download Complete tab-delimited .txt file to edit" in Easy PopulateThe delimited file does not have those fields define to be downloadable.

 

Can any help me with this. How do I add them to in so I can have it defined to be download. I have 3000 items to add, this will have help me out a lot if I can just have it definded in excel and upload it all at one instead of having to individually input each items for them.

 

This is what it look like on the PHPadmin side on the assigned fields for the table created by Product Extra Field feature.

products_extra_fields_id

products_extra_fields_name

products_extra_fields_order

products_extra_fields_status

 

Where ...

products_extra_fields_id is (auto set number defined fields, 1, 2, 3, 4 etc)

products_extra_fields_name is ( the field I have inputted above)

products_extra_fields_order is (the sort order how it appear on site)

products_extra_fields_status is (the on/off of the field -)

 

 

any help is greally appreciated. I am totally new to php, I just don't know where to begin with the fix or how to have it fix so I can just the easypopulate to upload my list with those newly added fields.

 

thanks

Kel

Edited by Kelina

Share this post


Link to post
Share on other sites
Guest

there are many discussions in this support thread which show how to add fields.

Share this post


Link to post
Share on other sites
there are many discussions in this support thread which show how to add fields.

 

Mibble,

 

Thanks, I just don't know where to start, I look over so many pages of code in this thead, Not sure where or which part I need to do this task.

 

guidence would be appricated.

 

 

-Kel

Share this post


Link to post
Share on other sites
Guest

there is also a contribution to add fields search for easy populate and read thru the different ones you find.

Share this post


Link to post
Share on other sites
there is also a contribution to add fields search for easy populate and read thru the different ones you find.

 

Mibble,

Will you be so kind to direct me to the section I need. I am totally new to PHP, I don't know how to do it. Do you have an section somewhere with step by step instruction mapped out for newie like me.

 

thanks

Kel~

Share this post


Link to post
Share on other sites

*Warning* -- No PHP or SQL coding experience

 

I'm having the same issue implimenting the <Product Extra Fields> mod. This mod produces it's own table. EP seems to only look into the [Products] and [Products_Description] tables.

 

I'm not certain if it's possible to create fields in one table that are simply pointers to another table. If it were I could create field pointers to the fields in [Products_Extra_Fields].

 

Otherwise, I'm looking to see how to get {easypopulate.php} to look for fields in the entire database instead of just 2 tables. If I could figure out how to have it pull another table ([Products_Extra_Fields]), it'd be set.

 

If I figure something out I will certainly post here.

Share this post


Link to post
Share on other sites

Actually...

 

<Product Extra Fields> mod adds another table [products_to_products_extra_fields] which holds the actual information. This is linked by product_id.

 

Looking through {easypopulate.php} I found 58 instances of TABLE_PRODUCTS. If I knew how, would these 58 instances be where I would add TABLE_PRODUCTS_EXTRA_FIELDS? If so, this isn't looking too good.

 

<Product Extra Fields (PEF)> allows new fields to be created in the admin page. And it adds the fields to the product description in the catalog. It integrates with the product add page in admin the same way <Header Tags Controller> does.

 

I still don't yet see a way to merge <EP> and <PEF>. The easiest way, if possible, would be to create a field (in products_description) that links to fields from the <PEF> contribution.

 

Anyone have any ideas beyond this?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×