EasyPopulate 4.0 Support Thread

Chadd,
Sorted. I redid the file and found an error in one of the headers and it all worked great.:clap:

OK, next question :dontgetit
Is it possible to add references/links to multiple images per product using EP4?
I'm specifically trying to add extra images showing colour options for each product.

vwaltz:

Hello,
I opened this file in notepad for copynpaste here.

"v_products_model" "v_categories_name_1"
"M4683G/A" "Toner-MONO^APPLE"
"M2473G/A" "Toner-MONO^APPLE"
"M2473G/A Extended" "Toner-MONO^APPLE"
"C3900A" "Toner-MONO^APPLE"
"DR400" "Toner-MONO^BROTHER"
"DR350" "Toner-MONO^BROTHER"

The above gave me the following when I imported the .csv file created with save as from open office:

Import Results

Filename: Category-EP2012Mar27-174859.csv

No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported

That's not a CSV file "Comma Separated Values". You probably selected TAB as the delimiter and is why it's failing.

-chadd

tedm:

OK, next question :dontgetit
Is it possible to add references/links to multiple images per product using EP4?
I'm specifically trying to add extra images showing colour options for each product.

You don't actually do THAT with EP4 (although there are attribute images, but not in EP4 yet).

You can specify your base image, and then just upload the others.

Base Image: HBB-250.jpg

Extra Images: HBB-250_01.jpg, HBB-250_02.jpg, HBB-250_03.jpg, etc.

Attribute Images are different (if you want them used in conjunction with a check or radio selection). You will have to do these manually.

-chadd

chadderuski:

That's not a CSV file "Comma Separated Values". You probably selected TAB as the delimiter and is why it's failing.

-chadd

Hello, when using the sample file below I get a 500 error. website cannot display the page after trying to import the csv file.

"v_products_model","v_products_name_1","v_products_price","v_manufacturers_name","v_categories_name_1"
"M4683G/A","M4683G/A",57.2,"Apple","Toner-MONO^APPLE"
"M2473G/A","M2473G/A",33.15,"Apple","Toner-MONO^APPLE"
"M2473G/A Extended","Extended",41.6,"Apple","Toner-MONO^APPLE"
"C3900A","C3900A",50.7,"Apple","Toner-MONO^APPLE"
"DR400","DR400",45.5,"Brother","Toner-MONO^BROTHER"

Hi,
I'm start using EP4 with zencart 1.3.9a. Is working perfect, the only problem i have is to update with the new csv. I'm using a csv file from my supplier but they do not have included the primary categories (only subcategories which are too many). I used to populate first time my zencart and then from administration i moved all the products in categories and subcategories. Now, the problem is, if i want to update the products and prices how i have to do that without changing the categories already created. Or is there any option to update automatically the csv file in excel from the master csv supplied? There are too many products to do it manually.
Thanks.

Please check:
https://www.itshoptrader.co.uk

vwaltz:

Hello, when using the sample file below I get a 500 error. website cannot display the page after trying to import the csv file.

"v_products_model","v_products_name_1","v_products_price","v_manufacturers_name","v_categories_name_1"
"M4683G/A","M4683G/A",57.2,"Apple","Toner-MONO^APPLE"
"M2473G/A","M2473G/A",33.15,"Apple","Toner-MONO^APPLE"
"M2473G/A Extended","Extended",41.6,"Apple","Toner-MONO^APPLE"
"C3900A","C3900A",50.7,"Apple","Toner-MONO^APPLE"
"DR400","DR400",45.5,"Brother","Toner-MONO^BROTHER"

Hi Waltz,

How large is your file? This is more about your server settings timing out when you upload the file with http. Are you on shared hosting? With who?

If you have a very large CSV file, you could first ftp it to your admin directory, then run the Split function should importing generate 500 errors. There are a number of settings you can change depending on your hosting, but that is beyond this thread.

itshoptrader:

Hi,
I'm start using EP4 with zencart 1.3.9a. Is working perfect, the only problem i have is to update with the new csv. I'm using a csv file from my supplier but they do not have included the primary categories (only subcategories which are too many). I used to populate first time my zencart and then from administration i moved all the products in categories and subcategories. Now, the problem is, if i want to update the products and prices how i have to do that without changing the categories already created. Or is there any option to update automatically the csv file in excel from the master csv supplied? There are too many products to do it manually.
Thanks.

Please check:
https://www.itshoptrader.co.uk

For existing products, you can use the Model/Price/Qty sheet format... you wont need categories since they are already defined.

For new products, you could create a non-active category and import to there first. This is hard to know for certain without seeing your sheet. If you want, you can PM me and I can take a look at it.

chadd

chadderuski:

Hi Waltz,

How large is your file? This is more about your server settings timing out when you upload the file with http. Are you on shared hosting? With who?

If you have a very large CSV file, you could first ftp it to your admin directory, then run the Split function should importing generate 500 errors. There are a number of settings you can change depending on your hosting, but that is beyond this thread.

Can't understand why this isn't working. Can you post a copy of what a line is supposed to look like? I tried to load the info below. as you can see it isn't very big. I got the web site can't display page error with it.

"v_products_model","v_products_name_1","v_products_price","v_manufacturers_name","v_categories_name_1"
"M4683G/A","M4683G/A",57.2,"Apple","Toner-MONO^APPLE"
"M2473G/A","M2473G/A",33.15,"Apple","Toner-MONO^APPLE"
"M2473G/A Extended","Extended",41.6,"Apple","Toner-MONO^APPLE"
"C3900A","C3900A",50.7,"Apple","Toner-MONO^APPLE"
"DR400","DR400",45.5,"Brother","Toner-MONO^BROTHER"
"DR350","DR350",55.9,"Brother","Toner-MONO^BROTHER"
"TN360","TN360",35.75,"Brother","Toner-MONO^BROTHER"
"TN330","TN330",31.2,"Brother","Toner-MONO^BROTHER"
"DR360","DR360",53.3,"Brother","Toner-MONO^BROTHER"

Hi Waltz,

What is your setting for "Script Execution Time" under Configuration -> Easy Populate 4

and

"Admin Set max_execution_time for processes" under Configuration -> My Store

and

"Maximum File Upload Size" under Configuration -> Max Values

Do you have access to your php.ini file in the root of our site? Or does your host prevent that?

Answer these and we'll see where that takes us.

-chadd

chadderuski:

Hi Waltz,

What is your setting for "Script Execution Time" under Configuration -> Easy Populate 4

and

"Admin Set max_execution_time for processes" under Configuration -> My Store

and

"Maximum File Upload Size" under Configuration -> Max Values

Do you have access to your php.ini file in the root of our site? Or does your host prevent that?

Answer these and we'll see where that takes us.

-chadd

Hello,
Configuration->Script Executation Time is 60
Admin Set max_execution is 60
Max File Upload Size is 2048000
I can access php.ini file

Thanks.

vwaltz:

Hello,
Configuration->Script Executation Time is 60
Admin Set max_execution is 60
Max File Upload Size is 2048000
I can access php.ini file

Thanks.

Your Zencart settings are fine.

Check your php.ini file. Look for these:

max_execution_time = 300
max_input_time = 300
memory_limit = 64M

Those numbers are from my VPS server. If you are in a shared hosting environment, start by increasing them moderately. Post your numbers.

What kind of hosting are you using? Which browser?

Oh, also make sure there aren't any extra "//" in your url except after http://www.....

-chadd

chadderuski:

For existing products, you can use the Model/Price/Qty sheet format... you wont need categories since they are already defined.

For new products, you could create a non-active category and import to there first. This is hard to know for certain without seeing your sheet. If you want, you can PM me and I can take a look at it.

chadd

Thanks.
I also want to know if is possible to do an automatic update with ftp. Do you want to see the original csv from my supplier?

chadderuski:

Your Zencart settings are fine.

Check your php.ini file. Look for these:

max_execution_time = 300
max_input_time = 300
memory_limit = 64M

Those numbers are from my VPS server. If you are in a shared hosting environment, start by increasing them moderately. Post your numbers.

What kind of hosting are you using? Which browser?

Oh, also make sure there aren't any extra "//" in your url except after http://www.....

-chadd

Hello,
I had a failure with the new settings also. I'm using IE browser. Hosting is linix.

Previous settings:
memory_limit - 48M
max_input_time - 60
max_execution_time - 30

New settings:
max_execution_time = 300
max_input_time = 300
memory_limit = 64M

I don't know if this means anything. If I export the Model/Category option from the Full Export Options, the import I do also fails.

Thanks.

itshoptrader:

Thanks.
I also want to know if is possible to do an automatic update with ftp. Do you want to see the original csv from my supplier?

This would be CRON support. I don't have direct CRON support added at this time.

Send me a PM and I'll look at your supplier file.

-chadd

vwaltz:

Hello,
I had a failure with the new settings also. I'm using IE browser. Hosting is linix.

Previous settings:
memory_limit - 48M
max_input_time - 60
max_execution_time - 30

New settings:
max_execution_time = 300
max_input_time = 300
memory_limit = 64M

I don't know if this means anything. If I export the Model/Category option from the Full Export Options, the import I do also fails.

Thanks.

I don't see anything wrong with your original settings for PHP.

If you do a full Export, then do a direct Import (not file upload), you are also getting a 500 Server Error? If so, then you need to contact your hosting as it must be a server related issue.

How many products in your store? A a decent server, 50,000 records can process in about 3 minutes. WHO IS YOUR WEB HOST?

From within your Admin, click the Version... scroll down to see if your php settings are accepted. Some hosting over ride this.

Developer's Note: I am still working on the "Basic Products Attributes (single-line)" download options.
This file is supposed to be in the same format as the current example files, but as yet I have
not worked out the sql/code to do so.

really need above feature, we really need this function,thanks

Hi, we just had an upgrade to 1.5.0 and a complete redecorate of our store and easy pop 4 was installed by the person we hired. I am trying to update the stock quantity and when I change the quantity and upload it, the stock doesn't change on our product pages. It is necessary for us to be able to do this because we have over 19000 products and to do it without ep would take a lifetime. Does anyone know what is causing this and how to fix it?
Thank you,
Cayla C
Everayla Outdoors

chadderuski:

I don't see anything wrong with your original settings for PHP.

If you do a full Export, then do a direct Import (not file upload), you are also getting a 500 Server Error? If so, then you need to contact your hosting as it must be a server related issue.

How many products in your store? A a decent server, 50,000 records can process in about 3 minutes. WHO IS YOUR WEB HOST?

From within your Admin, click the Version... scroll down to see if your php settings are accepted. Some hosting over ride this.

Hello,
Full Export when exported and imported fails (cannot display webpate). no download or editing involved.

Model/Price/Qty export but no error and no update
Model/Category export but no error and no udpate

PriceBreak and PriceQty export and import works fine and updates.

At this time i have 2 products in the store for testing.
This fails also (Model/Category from above):
v_products_model,v_categories_name_1"1001","Toner-MONO^APPLE""1000","Toner-MONO^APPLE"

PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 64M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 25M
Server provided through Liquid Web

everayla:

Hi, we just had an upgrade to 1.5.0 and a complete redecorate of our store and easy pop 4 was installed by the person we hired. I am trying to update the stock quantity and when I change the quantity and upload it, the stock doesn't change on our product pages. It is necessary for us to be able to do this because we have over 19000 products and to do it without ep would take a lifetime. Does anyone know what is causing this and how to fix it?
Thank you,
Cayla C
Everayla Outdoors

Hi Cayla,

Could you PM me with the CSV you are using? This make diagnosing importing issues MUCH easier. Most often cause of a failure to update is an error in headers.

Thanks,
Chadd