EasyPopulate 4.0 Support Thread

chadderuski:

Announcement: Easy Populate 4.0.20 Beta Posted to Github

This new version adds many features and enhancements:

-Attributes are now "round-robin". You can import-export-import your attributes to add/update as needed.
File naming requirements: The basic import must begin with "Attrib-Basic-EP" and the detail with "Attrib-Detailed-EP".
I am still awaiting feedback on what common columns would be useful in the Basic import file. I do not want to duplicate the Detailed, but
I'm sure there are a number of fields that users would like here. Attributes import is now multilingual.

-Added 'products_priced_by_attribute' to FULL file to support attributes.
-Added Featured Products support
-Added Support for products type 2. You can now import all relevant info for music products (artist, record label, genre).
-Expanded handling of "curly quotes" characters and character 0x92

BUG FIX: When import a mixed file of updated and new products with only a select number of columns, the data from an updated product was being inserted into a new product.

Download here: https://github.com/chaddro/EasyPopulate-4.0

Looking forward to your feedback,
-chadd

I haven't tried yet chad but just wanted to say thank you for your efforts. I'll have a go today at some point and let you know if I experience any issues.

Moe.

This is great chad, it seems to import and export attributes smoothly and without any issues. I love how it displays the products attributes vertical rather than horizontally. The other way created many issues when you had significant option names and values attached. Your method of pulling the information also displays the product name above the attribute prices which will save many hours of work matching product name to product model and attribute

So far all is working as it should. :thumbsup:

I can not get it to work. i have tried eevrything. I upload the fiels and all seems good but then I go into my admin it doesn't show up and it doesn't give me any warning. Any suggestions?

outeredge2:

I can not get it to work. i have tried eevrything. I upload the fiels and all seems good but then I go into my admin it doesn't show up and it doesn't give me any warning. Any suggestions?

Which version of zencart are you using? There are additional files that need to be uploaded for these to work and show up in your admin.

You should physically check to ensure you have the files in their proper location. So far, the only failures with installation have been user error.

-chadd

chadderuski:

Which version of zencart are you using? There are additional files that need to be uploaded for these to work and show up in your admin.

You should physically check to ensure you have the files in their proper location. So far, the only failures with installation have been user error.

-chadd

I'm loading it onto a brand new site with 1.5 on it.

I did load Ep 1.2.5.4 before this one. Can that be causing it error out? It's the only add-on I can't get working. I got all others (lightbox) sidebox, etc). not saying it's not user error, I just can't figur out why it's not working.

So I went through and check all of the files. They are all apreaing to be in the right locations.

I check the ensure that I had the 1.5 files included as well. Everything seems to be all located fine.

:blink:

EDIT:

So i got it working. I'n not sure what happend but I went through and removed all the old EP 4 things and then re-uploaded them and it works!!

P.s I have been reading more about this and the spread sheet style such as the drop down box options and everything.... WOW.... It rocks! Thanks for an amazing mod!!

outeredge2:

So i got it working. I'n not sure what happend but I went through and removed all the old EP 4 things and then re-uploaded them and it works!!

P.s I have been reading more about this and the spread sheet style such as the drop down box options and everything.... WOW.... It rocks! Thanks for an amazing mod!!

Glad you got it working! It was more than likely a corrupted file.

-chadd

No matter what I do, all of the products that I upload are given a product type of "2", which is apparently "music". How can I keep it from doing this? I need all oif my product types to be "product general".

hockey2112:

No matter what I do, all of the products that I upload are given a product type of "2", which is apparently "music". How can I keep it from doing this? I need all oif my product types to be "product general".

On your import file, add column v_products_type and set the value to 1.

I'll look into this. The default should be 1. Did you enable the music products under the configuration?

chadderuski:

On your import file, add column v_products_type and set the value to 1.

I'll look into this. The default should be 1. Did you enable the music products under the configuration?

I don't see any spot in EZPop config to enable/disable the music products.

Here are my columns:

v_products_model v_products_image v_products_name_1 v_products_type v_products_description_1 v_products_price v_products_weight v_products_quantity v_categories_name_1 v_tax_class_title v_status EOREOR

And I do have a "1" in the v_products_type fields for each product.

Thanks!

hockey2112:

I don't see any spot in EZPop config to enable/disable the music products.

Here are my columns:

v_products_model v_products_image v_products_name_1 v_products_type v_products_description_1 v_products_price v_products_weight v_products_quantity v_categories_name_1 v_tax_class_title v_status EOREOR

And I do have a "1" in the v_products_type fields for each product.

Thanks!

First off: EOREOR is NOT required for EasyPopulate 4.

Music products are disabled by default. From your Admin: Configuration > Easy Populate 4 > Enable Products Music Data

How do you change the database field lengths? I keep getting these errors
WARNING! - Model: SPST8116A - Products name: "17 GATOR ORANGE REAR TAILLIGHT SPST8116A " exceeds max. length: 21.333333333333
SKIPPED! - Model: SPST8116A - Category name: "Power Wheels and Ride on parts" exceeds max. length: 10.666666666667

this is what it says on my admin page
Database Field Lengths
categories_name:10.666666666667
manufacturers_name:10.666666666667
products_model:10.666666666667
products_name:21.333333333333
but on the database the char limits are much higher than that

chadderuski:

First off: EOREOR is NOT required for EasyPopulate 4.

Music products are disabled by default. From your Admin: Configuration > Easy Populate 4 > Enable Products Music Data

Ah, I see that config now. I must have overlooked it right under the Meta Data item. It is, and was before, disabled.

I removed EOREOR and uploaded a new copy of the CSV file with several new products included. The "update" products retained their product type, but the "new" products are still being added as "product type 2", even though they are marked as "1" in the spreadsheet...

I got it figured out. Its in the easypopulate2.php in the admin folder the values were divided by 3

rosrooster:

I got it figured out. Its in the easypopulate2.php in the admin folder the values were divided by 3

Did you install zencart 1.5 with iso-8859 or utf8?

UTF8 is multibyte... and you need to divide by 3 to get character count. However, if your store is set UTF8 and your databases are iso-8859 it may be confusing the script.

hockey2112:

Ah, I see that config now. I must have overlooked it right under the Meta Data item. It is, and was before, disabled.

I removed EOREOR and uploaded a new copy of the CSV file with several new products included. The "update" products retained their product type, but the "new" products are still being added as "product type 2", even though they are marked as "1" in the spreadsheet...

This is a prime example why I strongly recommend to always use Dr. Byte's MySQL Backup tool. You should run a backup before you import any files to ensure you understand them correctly.

If you have a problem, you can simply roll your store's data back by restoring your backup.

To fix the products_type error, you will need to delete these and re-import them.

hockey2112:

Ah, I see that config now. I must have overlooked it right under the Meta Data item. It is, and was before, disabled.

I removed EOREOR and uploaded a new copy of the CSV file with several new products included. The "update" products retained their product type, but the "new" products are still being added as "product type 2", even though they are marked as "1" in the spreadsheet...

Okay. Bug in code. You must have had music products enabled. Do this:

Open easypopulate_4_import.php with a plain text editor.
go to line 962

change:

if (isset($v_artists_name)) {
	$v_products_type = 2; // 1 is default, 2 = music
} else {
	$v_products_type = 2;
}

to:

if (isset($v_artists_name)) {
	$v_products_type = 2; // 1 is default, 2 = music
} else {
	$v_products_type = 1;
}

-chadd

chadderuski:

This is a prime example why I strongly recommend to always use Dr. Byte's MySQL Backup tool. You should run a backup before you import any files to ensure you understand them correctly.

If you have a problem, you can simply roll your store's data back by restoring your backup.

I strongly second that. I've long since learned to back-up before any EP upload (and I try to get my sister and her people to do the same on her sites.)

And Dr. Byte's back-up mod really simplifies that, no longer having to go in to cpanel and myphpadmin (or whatever its called) to manually download the DB. In fact, first mod I install now on my various demo sites is this DB back-up mod, as I'm always messing around on those sites. (Only thing: this DB backup mod doesn't seem to work well if your DB/UN password has strange characters other than numbers and letters.)

GITHUB UPDATED WITH PRODUCT TYPE FIX

Default product type has been fixed. If you enable music products in the config, and enter an artists_name, the product type will be set to 2,
otherwise it will be set to 1.

This is a quick fix. Will look into something more detailed later.

-chadd