Easy Populate 1.2.5.4 support

schoolboy:

I uninstall 1.2.5.4 before I upgrade to ZC.1.5 - then I do a full install of EP4 after the upgrade is complete.

Microsoft was never designed for "developer" purposes. It was designed for "simpletons" who need the software to do a lot of things automatically. Unfortunately, when you use MS stuff for developer or code purposes, it still behaves as if you want it to do a lot of auto-formatting - and there's no way of switching these auto-functions off.

MSOffice is similar, but a lot more respectful of an individual's desire to format stuff manually - so I like to use it as I have a lot more control over how things get formatted.

And there's no "conversion" to worry about. OO will read an XLS file.

Thank you and chadderuski for your replies. I have an update:

1. Easy Populate CSV V1.2.5.7c (the latest version) does not work with older ZC versions, at least when I installed into my 1.3.9h site. So there are 2 versions that you can use if you've upgraded to zc1.5 (EP-CSV1.2.5.7c and EP4.0)

2. Easy Populate 4.0 has options for both older zc1.3.x and the new zc1.5.x and is a fantastic upgrade. After using EP1.2.5.4 for a year it's like trading in your '95 Corolla for a new Lexus!

3. EP4.0 installs separate from any other versions of EP so you can maintain existing functionality while upgrading. This is good since EP is "mission-critical".

4. I updated/enabled metatags for over 12,000 products with EP4.0 using Excel 2007 without a hitch. (Yes, I tested with just a couple products first... I ain't crazy!) So far no need to use Open Office.

THANKS AGAIN!
Scott

USing ZenCart 1.3.9h and ezpop 1.2.5.4 after upload categories are showing the wrong product counts. 1 category has 1 product but shows 4 as a count. Others show double the amounts actually in the store.

hi all

im using zen 1.5.0 and ep 1257c , it all work fine on upload etc but the download is struggling on a full download either to pc or temp folder. if i do a model/price/quantity dload it is all ok, a complete csv dload and my screen starts ok but about 20-30 secs in my browser screen just goes white and nothing else happens. i have about 22000 items in my store, it all worked fine initially when i had a few items but now get the error, it will upload ok just not download. ive changed my timout in admin and php.ini but no joy.

any help appreciated

thanks

dessy

I am runing Zen 1.5.1 and easy populate csv for zencart 1.5.x

I am getting following error message:

MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
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.products_last_modified as v_last_modified,
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,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id

MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
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.products_last_modified as v_last_modified,
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,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id

MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
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.products_last_modified as v_last_modified,
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,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id

MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
UPDATE products SET
products_price = '0.0000' ,
products_image = '02.jpg' ,
products_weight = '23' ,
products_tax_class_id = '1' ,
products_date_available = '' ,
products_date_added = '2003-11-03 12:32:17' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '0' ,
master_categories_id = '4' ,
manufacturers_id = 'NULL',
products_status = '1',
metatags_title_status = '',
metatags_products_name_status = '',
metatags_model_status = '',
metatags_price_status = '',
metatags_title_tagline_status = '', EASYPOPULATE_CONFIG_CUSTOM_FIELDS='' WHERE ( products_id = '1' )
MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
UPDATE products SET
products_price = '0.0000' ,
products_image = 'matrox/DSC_0514.JPG' ,
products_weight = '0' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2003-11-03 12:32:17' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '31' ,
master_categories_id = '4' ,
manufacturers_id = 'NULL',
products_status = '1',
metatags_title_status = '',
metatags_products_name_status = '',
metatags_model_status = '',
metatags_price_status = '',
metatags_title_tagline_status = '', EASYPOPULATE_CONFIG_CUSTOM_FIELDS='' WHERE ( products_id = '2' )
MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
UPDATE products SET

** and it continues in the same way

I hope somebody is able to help me fix this issue.

Can anyone help with this please?

My install of Easy Populate is working fine, but is missing from the 'configuration' menu.

I downloaded what looks to be the latest version from http://www.zen-cart.com/downloads.php?do=file&id=868

I've tried to upload the SQL patch to no avail.

MySQL v5.0.9
Zen Cart v1.5.1
EP v1.2.5.7c

i am not able to do anything. when i try to upload my file i get a message that says...

an sql error has occured. PLease check your input data for tabs within the fields and delete these...

Not sure what is going wrong... Please help

I've just installed this mod,and so far I think things are looking good,but I notice a few threads here that are not replied to, and perhaps I can help out:

Hardy159 => Are you certain you clicked on the install link at the top of the page after visiting the Admin>Tools>EasyPopulate page?

double-happiness => Do you mean to say the Admin>Tools>EasyPopulate menu? It may have been in configuration in the past, but it is not there now.

drago => This sounds like a problem with the data you are trying to move, in one of your products, you use a TAB instead of spaces, which may cause problems with some data downloads/uploads. Change the product to use spaces and you should be ok. Yes, I know it may be difficult to find which product this is. :(

Ray

RayDube:

I've just installed this mod,and so far I think things are looking good,but I notice a few threads here that are not replied to, and perhaps I can help out:

Hardy159 => Are you certain you clicked on the install link at the top of the page after visiting the Admin>Tools>EasyPopulate page?

double-happiness => Do you mean to say the Admin>Tools>EasyPopulate menu? It may have been in configuration in the past, but it is not there now.

drago => This sounds like a problem with the data you are trying to move, in one of your products, you use a TAB instead of spaces, which may cause problems with some data downloads/uploads. Change the product to use spaces and you should be ok. Yes, I know it may be difficult to find which product this is. :(

Ray

Upon Further review, double-happiness, you may be looking for the EASY POPULATE 4.0 SUPPORT THREAD, found here:
http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&highlight=Easy+Populate+V4

Ray

Yes... You should use EP 4 if your site is based on ZC 1.5.x

This is a much-improved and advanced version, and has a number of valuable new features and functions. There is a support thread with a link to GITHUB where the latest "edition" of chad's module will be available.

hello all i need some help please

when i try and import my products via this add-on i get an error come up saying

ADD NEW PRODUCT FAILED! - Model: 633043 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: 633044 - SQL error. Check Easy Populate error log in uploads directory

when i look in the error file it says this????

MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
INSERT INTO products SET

can anyone please tell me what im doing wrong?

at top of admin page it says

Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

I have upgraded from 1.38 tot 1.51. the module is working, but I have no menu options anymore for configuring easy populate. (only in tools --> easy populate)

How can I make the menu visible again to configure the module, without re-installing or upgrading to other (newer) versions of easy populate?
Remark: The newer versions do not seem to work when I open the exported file to excel (products get mixed up)

I had some long time consuming delays with easy populate and wasn't able to find a solution online. I wanted to share my problem and solution. I figure if I had the problem others must too. I have a client who's supplier sends him an xlsx file with most data needed for the easy populate csv file, however it doesn't easily covert because of commas, quotes - apostrophes (used for measurement description), bullet points and more. Hours of frustrations.
First if your using Open Office calc open your downloaded easy populate cvs file and convert it (save as) to a .ods spreadsheet for a friendly work area. DO-NOT convert it to an xl file. I found the hard way that open office will limit the number of characters in a table cell cutting my descriptions length in half. - I was scratch my head for hours.
Second because the upload file needs to be a .csv you can't have commas quotes or apostrophes. What do I do when my product description needs em'? I searched and searched online and I read a lot about what options to select when I save as csv. Nothing worked. Somehow I remembered my old school basic html special characters. After I had place in all the descriptions I did a find and replace
Comma - , replace with ,
quotes - " replace with "
Apostrophe - ' replace with '
Bullet Points - • replace with •
Then save as .csv leave the field delimiter as a comma and delete the quote from text delimiter so it's blank.
Now your csv file is ready to be imported. I hope this helps and save you from frustration and time.

Hi, have just installed this onto a fresh install of 1.5.1 on local server, only other addon is Quick Updates (latest version)

Upon clicking 'install configuration' at top, the bottom half of the easy populate page looks like this

[Attachment no longer available]

if I run the uninstall script the text at the bottom vanishes

have no idea what I am doing wrong

any help greatly appreciated

pete

Guys,

I am trying to use easy_populate_csv_for_zencart_v1.5.x_v1.2.5.7c... but no matter what I do, the SQL files bombs and there is no entry in the Configuration menu. This is a clean install.

Thought? Help?

David

I am getting this error when trying to upload a file? I have tried to manually upload and that works but then I get the same error

Upload Results
File uploaded.
Temporary filename:
User filename: data live sheet.csv
Size: 0
ERROR: file doesn't exist

check in your tools section that is where mine was installed however it will not import a file...

Hello everyone,

I am sorry if this question has already been asked but I searched the forum and could not find an answer. :(

My problem is that I have almost 23000 products in my store and when I try to download a complete .CSV file, create a complete .cs or froogle file in temp directory through easy populate my screen just goes white after about a minute and the link of the white/blank page is this:

http://www.domain/admin/easypopulate...am&dltype=full

Is it safe to assume that there is a time restraint somewhere? Or, do I have too many products? When I uploaded my products originally using easy populate I did it by product type so it wasn't one large upload. But since I have uploaded everything, I have moved categories around and I need to export everything the way it stands now so I can't do it by product type anymore.

I am using zen cart 1.5.1 and I just downloaded the latest version of Easy populate about 3 weeks ago. Not sure the version.:blush:

Please someone tell me this is an easy fix for a novice/beginner (fingers crossed).

Thank you.

My Easy populate tab under configuration opens my Super Orders config. I can't access the Easy populate Config. Can anyone tell me how to fix this?

Thanks,
Tom

So frustrated. I need to know how to first

1. download the existing products and categories (which I need first!)
2. add more or update the excel file
3. Upload the new CVS file

Is there some documentation please?

easy populate does not show up in zen cart tool bar

please help

i installed easy populate admin folder in my admin directory.
the easy populate admin folder has the same name as my admin directory.
the files are all visible, within my ftp directory.

easypopulate_4_export.php (permissions 644)

i also installed the zen cart 1.3 extra files. (permissions 755)
in my stores admin directory

what am i doing wrong?

thanks

art

art