EasyPopulate 4.0 Support Thread

[amirshawn80]

Hi,

I just installed the latest version of ep 4.0. I have a bunch of custom product fields, most are in the products table except for the second description which is in the description table. I had the old easy populate working for inputting the data and I'd like to get that working with the new EP, I saw the post on page 5, but I didn't really understand. I was wondering if you could explain in more detail how to add extra fields. Thank you for your help.

[igi2011]

Hi,

I just installed the latest version of ep 4.0. I have a bunch of custom product fields, most are in the products table except for the second description which is in the description table. I had the old easy populate working for inputting the data and I'd like to get that working with the new EP, I saw the post on page 5, but I didn't really understand. I was wondering if you could explain in more detail how to add extra fields. Thank you for your help.

OK here's how I did it - my example shows the field I wanted to add (products_family), obviously yours will be different :)

There are three files to edit:
YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php
YOUR-ADMIN-FOLDER/easypopulate_4.php
and YOUR-ADMIN-FOLDER/easypopulate_4_import.php

You're using the existing 'upc' field each time to create a new product field.

Firstly open YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php. Search for

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}

Now make a copy of this code directly underneath and change this to

if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}

so you now have

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}

Now find the following a few lines further down:

if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}

Copy this chunk of code and change as before, so you now have:

if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // Products Family mod
$filelayout_sql .= 'p.products_family as v_products_family,';
}

Now open YOUR-ADMIN-FOLDER/easypopulate_4.php and search for 'upc' again - around line 90

$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd

Make a copy so you now have

$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd
$ep_supported_mods['family'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_family'); // Products Family

Finally open YOUR-ADMIN-FOLDER/easypopulate_4_import.php and search for 'upc' again, there are four edits to make here, here's what mine looks like with the 'family' fields added (the line numbers may be slightly out)

Line 26:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_family';
}


Line 150:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod- chadd
$sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // products_family
$sql .= 'p.products_family as v_products_family,';
}

Line 594:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // products_family
$query .= "products_family = '".addslashes($v_products_family)."',";
}

Line 660:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // family
$query .= "products_family = '".addslashes($v_products_family)."',";
}


Hope this helps - this should work for the fields in the products table, but it might need a bit of tweaking for the field you have in the description table (not sure myself as I haven't tried it)

[awhfy99]

OK here's how I did it - my example shows the field I wanted to add (products_family), obviously yours will be different :)

There are three files to edit:
YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php
YOUR-ADMIN-FOLDER/easypopulate_4.php
and YOUR-ADMIN-FOLDER/easypopulate_4_import.php

You're using the existing 'upc' field each time to create a new product field.

Firstly open YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php. Search for

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}

Now make a copy of this code directly underneath and change this to

if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}

so you now have

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}

Now find the following a few lines further down:

if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}

Copy this chunk of code and change as before, so you now have:

if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // Products Family mod
$filelayout_sql .= 'p.products_family as v_products_family,';
}

Now open YOUR-ADMIN-FOLDER/easypopulate_4.php and search for 'upc' again - around line 90

$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd

Make a copy so you now have

$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd
$ep_supported_mods['family'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_family'); // Products Family

Finally open YOUR-ADMIN-FOLDER/easypopulate_4_import.php and search for 'upc' again, there are four edits to make here, here's what mine looks like with the 'family' fields added (the line numbers may be slightly out)

Line 26:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_family';
}


Line 150:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod- chadd
$sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // products_family
$sql .= 'p.products_family as v_products_family,';
}

Line 594:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // products_family
$query .= "products_family = '".addslashes($v_products_family)."',";
}

Line 660:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // family
$query .= "products_family = '".addslashes($v_products_family)."',";
}


Hope this helps - this should work for the fields in the products table, but it might need a bit of tweaking for the field you have in the description table (not sure myself as I haven't tried it)

Thanks,

this could make what I am trying to do a little easier. I have the same issue as several others and thought that ep4 could help fix them.

I have noticed that there are several posts on how to change the product type from 1 to 2 and I thought that by adding the fields

v_product_type
v_product_music_extras
v_record_artists
v_record_artists_info
v_record_company
v_record_company_info
v_music_genre


to ep4 would help in the creation of the new products before the old ones are deleted or just to add new products to Product - Music.

Don't know if I am on the right track or not, so I would appreciate your thoughts on this.

[chadderuski]

Thanks,

this could make what I am trying to do a little easier. I have the same issue as several others and thought that ep4 could help fix them.

I have noticed that there are several posts on how to change the product type from 1 to 2 and I thought that by adding the fields

v_product_type
v_product_music_extras
v_record_artists
v_record_artists_info
v_record_company
v_record_company_info
v_music_genre

to ep4 would help in the creation of the new products before the old ones are deleted or just to add new products to Product - Music.

Don't know if I am on the right track or not, so I would appreciate your thoughts on this.

If you hold off for just a little bit, I'll be posting soon with complete support for products type 2 for music (and also supporting the artists and record company info).

Initial testing looks good, but I need to comb through the code a bit more. Just give me to Sunday!

-chadd

[awhfy99]

If you hold off for just a little bit, I'll be posting soon with complete support for products type 2 for music (and also supporting the artists and record company info).

Initial testing looks good, but I need to comb through the code a bit more. Just give me to Sunday!

-chadd

I will do.

Looks like I posted the fields before I throughly checked the db structure, which I'm sure that you noticed!

Thanks for not exposing my oversight!

[songseng]

OK here's how I did it - my example shows the field I wanted to add (products_family), obviously yours will be different :)

There are three files to edit:
YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php
YOUR-ADMIN-FOLDER/easypopulate_4.php
and YOUR-ADMIN-FOLDER/easypopulate_4_import.php

You're using the existing 'upc' field each time to create a new product field.

Firstly open YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php. Search for

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}

Now make a copy of this code directly underneath and change this to

if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}

so you now have

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}

Now find the following a few lines further down:

if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}

Copy this chunk of code and change as before, so you now have:

if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // Products Family mod
$filelayout_sql .= 'p.products_family as v_products_family,';
}

Now open YOUR-ADMIN-FOLDER/easypopulate_4.php and search for 'upc' again - around line 90

$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd

Make a copy so you now have

$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd
$ep_supported_mods['family'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_family'); // Products Family

Finally open YOUR-ADMIN-FOLDER/easypopulate_4_import.php and search for 'upc' again, there are four edits to make here, here's what mine looks like with the 'family' fields added (the line numbers may be slightly out)

Line 26:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_family';
}


Line 150:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod- chadd
$sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // products_family
$sql .= 'p.products_family as v_products_family,';
}

Line 594:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // products_family
$query .= "products_family = '".addslashes($v_products_family)."',";
}

Line 660:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // family
$query .= "products_family = '".addslashes($v_products_family)."',";
}


Hope this helps - this should work for the fields in the products table, but it might need a bit of tweaking for the field you have in the description table (not sure myself as I haven't tried it)

THANKS chadd for this GREAT contribution!
Today I hv installed the latest version chaddro-EasyPopulate-4.0-f4314dc for my ZC1.50, and it works fine for my basic use.
However, there is another reason for me to arrived here, as I just installed the 'related product', and I really need EP4 for a quick update of the new product field (products_family).
As posted by igi2011, thanks for code, it works for at least the Export side. When I tried to Upload the CSV with changes on the products_family, it is Not updated. I wonder where is the mistake..
I've double confirmed the mod on the 3 suggested file.. Any idea, pls?

[chadderuski]

THANKS chadd for this GREAT contribution!
Today I hv installed the latest version chaddro-EasyPopulate-4.0-f4314dc for my ZC1.50, and it works fine for my basic use.
However, there is another reason for me to arrived here, as I just installed the 'related product', and I really need EP4 for a quick update of the new product field (products_family).
As posted by igi2011, thanks for code, it works for at least the Export side. When I tried to Upload the CSV with changes on the products_family, it is Not updated. I wonder where is the mistake..
I've double confirmed the mod on the 3 suggested file.. Any idea, pls?

Songseng,

You no longer have to make edits to the code if you want to add a custom field to your products table. The latest version of EP4 on github adds a new configuration variable for "User Defined Products Fields" ... just list your "products_family" here, and then add the column "v_products_family" to your spreadsheet.

When you return to the EP4 page, you will see an entry for your User Defined Fields and "True" if detected or "False" if not...

Hope this helps!

-chadd

ps: your EP4 version should be 4.0.22 (or later) for this feature

[songseng]

Songseng,

You no longer have to make edits to the code if you want to add a custom field to your products table. The latest version of EP4 on github adds a new configuration variable for "User Defined Products Fields" ... just list your "products_family" here, and then add the column "v_products_family" to your spreadsheet.

When you return to the EP4 page, you will see an entry for your User Defined Fields and "True" if detected or "False" if not...

Hope this helps!

-chadd

ps: your EP4 version should be 4.0.22 (or later) for this feature

Yes it's EP4 4.0.22 Beta.
Feel great with the "User Defined Products Fields", thats make job more easy and quick.

So I restored the 3 original files. Fill in "User Defined Products Fields" with 'products_family'. I was able to Export the v_products_family data without adding the column "v_products_family" manually to the spreadsheet. Meaning after the Export, I could see "v_products_family" in my CSV straight away.
BUT:
-I wasn't able to see User Defined Fields set to "True" if detected or "False" if not. I'm looking into Configuration > Easy Populate 4 > User Defined Products Fields. It's still showing the 'products_family' as I filled in before.
-After the Upload, the product family field is still Not updated.

I tried manually adding the "v_products_family" to the CSV and upload again, but it's still the same.
Chadd, correct me if I don't follow your steps, appreciate your hints again

[chadderuski]

Yes it's EP4 4.0.22 Beta.
BUT:
-I wasn't able to see User Defined Fields set to "True" if detected or "False" if not. I'm looking into Configuration > Easy Populate 4 > User Defined Products Fields. It's still showing the 'products_family' as I filled in before.
-After the Upload, the product family field is still Not updated.

Songseng:

In Tools -> Easy Populate 4 on the right-hand side where the info columns are will be an entry for user defined fields. This is
where you will see True/False next to your field name.

You are probably missing something simple. Send me a pm and I'll take a look at your CSV file off site.

-chadd

[Darkwander]

Greetings;

Just wondering if we have had a chances to look at the date issue, know why it happened and what we need to do to fix it...

Thanks