Easy Populate 1.2.5.4 support

Hello all,

I'm trying to upload my HTML product descriptions using EP.
I have 900 products, some of the descriptions upload fine and others not all the text uploads or the formatting is inconsistent with missing line breaks etc.
**
Here's a correct page** - http://www.kcbgraphics.com/index.php?main_page=product_info&cPath=17_63_64&products_id=170

Here's an incorrect page - http://www.kcbgraphics.com/index.php?main_page=product_info&cPath=17_63_64&products_id=171

Has anyone bumped into this issue and resolved it?

Any help would be appreciated.
Thank you.
ZC1.3.8
PHP5.2.9
Mysql5.0.81

Thanks, that's the ticket

LOL, it's the same as the old format, just saved as a CSV. Who knew?

I am officially the sharpest knife in the drawer today! :smartalec:

Hello all,

I'm trying to upload revised product descriptions. In Admin - Tools - Easy Populate it shows the upload completing without any errors but when I go to my product descriptions none of my changes are showing.

Has anyone seen this issue before?? If so... how did you resolve it?

Any help would be appreciated.

ZC 1.3.8
PHP 5.2
MySQL 5.0.81

The previous discussions where people had upload issues using an Apple computer that I could find all say you cannot use a MAC to create the file. The truth is: you cannot use Excel on a MAC but you do have options. I use "Numbers" to output the csv file - worked fine for EP 1.2.5.6!!

I try not to give up until I have spent at least 2 days at something. :)

Hi,

Trying to install Easy Populate v1.2.5.6 on Zc v1.3.8 and I get these error msgs when I type in ?langer=install in my browser:

EASYPOPULATE_MSGSTACK_INSTALL_KEYS_FAIL
Warning EASYPOPULATE_MSGSTACK_TEMP_FOLDER_MISSING
Warning EASYPOPULATE_MSGSTACK_INSTALL_CHMOD_FAIL

I have tempEP CHMOD setting at 777, in my root directory (same as my store)

Do I need to install the MySql patch or do I have something else wrong?

thanks in advance.

autoace:

Hi,

Trying to install Easy Populate v1.2.5.6 on Zc v1.3.8 and I get these error msgs when I type in ?langer=install in my browser:

EASYPOPULATE_MSGSTACK_INSTALL_KEYS_FAIL
Warning EASYPOPULATE_MSGSTACK_TEMP_FOLDER_MISSING
Warning EASYPOPULATE_MSGSTACK_INSTALL_CHMOD_FAIL

I have tempEP CHMOD setting at 777, in my root directory (same as my store)

Do I need to install the MySql patch or do I have something else wrong?

thanks in advance.

EZ Pop can run with teh temp folder at 755 instead of 777: many hosts won't allow code to run if folders are set at 777.

Copy the files up again, I think you're missing some.

Make sure the tempEP folder is there. Check that the temp folder is set in configuration/ easy pop. You might have a "tempEP" folder and it's set for "tmp" or something.

Tapper:

Thanks for the quick reply, I changed my tempEP folder to 755 and re-uploaded all the files.

My temp folder's name is 'tempEP', do I rename that to temp and it is is my root directory same as my store.

Same error message.

Do I need to install the 'install_sql' file? Upload or via phpMyAdmin?

How do I know which file is the configure file to check what the name of temp folder should be?

Thanks for your help.

autoace:

Tapper:

Thanks for the quick reply, I changed my tempEP folder to 755 and re-uploaded all the files.

My temp folder's name is 'tempEP', do I rename that to temp and it is is my root directory same as my store.

Same error message.

Do I need to install the 'install_sql' file? Upload or via phpMyAdmin?

How do I know which file is the configure file to check what the name of temp folder should be?

Thanks for your help.

Remove the EP from the end of your temp folder. It is /temp and it cannot be anything else.

Im using EP to upload automotive products and have come across an issue...
there are instances where a part# can belong to different car models for ex:

Part#21-496 - for Audi A3
also
Part#21-496 - for VW GTI

in Easy populate i file these under 2 seperate categories, Audi and VW.
The part# (model#) stays same, but i change the description of the product to read 1. for audi a3 2. for vw GTI
but EZ populate just overwrites this and makes both products "for VW GTI.

basically,

1. How to make EZ populate NOT to overwrite the descriptions?
2. How to make EZ populate create DUPLICATE (not linked) products instead?

Your assistance is greatly appreciated.
Thanks!

Any idea bout this error

MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
UPDATE zen_products SET
products_price = '50' ,
products_image = 'peces/koicarp02.jpg' ,
products_weight = '5' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2009-08-09 01:19:12' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '1' ,
master_categories_id = '69' ,
manufacturers_id = '2',
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 = '129' )

if is possible any friend here post a example of csv.file for import
Thanks in advance

credenscel:

Im using EP to upload automotive products and have come across an issue...
there are instances where a part# can belong to different car models for ex:

Part#21-496 - for Audi A3
also
Part#21-496 - for VW GTI

in Easy populate i file these under 2 seperate categories, Audi and VW.
The part# (model#) stays same, but i change the description of the product to read 1. for audi a3 2. for vw GTI
but EZ populate just overwrites this and makes both products "for VW GTI.

basically,

1. How to make EZ populate NOT to overwrite the descriptions?
2. How to make EZ populate create DUPLICATE (not linked) products instead?

Your assistance is greatly appreciated.
Thanks!
credenscel
Since EP uses the "part number" as the key you cannot have two items with the same part number in the database and it appears you are not trying to violate that you just want it to be assigned in two categories. What I did was to make a second upload table with the second category tree. This added and did not overwrite the original. There may be an easier way but it worked for me so I am sticking to it.

Good luck.

My friend your store for car parts I think is like my store with many items

I become boring of easy populate
I use now Storemanager from the company Magneticone and the true is very easy upgrade products and also import 1000 of products with also images.
is not a free product but also is not really expensive.
For me solve many days of update products Now I make in few clicks

Try I using now Free for 30 days but I really I go to buy . Zen cart become really porwerfull

credenscel:

Im using EP to upload automotive products and have come across an issue...
there are instances where a part# can belong to different car models for ex:

Part#21-496 - for Audi A3
also
Part#21-496 - for VW GTI

in Easy populate i file these under 2 seperate categories, Audi and VW.
The part# (model#) stays same, but i change the description of the product to read 1. for audi a3 2. for vw GTI
but EZ populate just overwrites this and makes both products "for VW GTI.

basically,

1. How to make EZ populate NOT to overwrite the descriptions?
2. How to make EZ populate create DUPLICATE (not linked) products instead?

Your assistance is greatly appreciated.
Thanks!

A few things come to mind for me.

1. The simplist is to add an prefix (or suffix) to your part numbers (Audi, VW, GM, etc) so that each would then have a unique number. Very simple to do, just use the concatenate feature of your spreadsheet (at least excel has that option).

2. It is also possible create a PN field, so that it will allow duplication of your PN's (use with the 1st idea?). You could substitute the PN field for the model # on the shipping invoices and search features, etc.

3. Another idea (which has not been researched by me) is that there might be a way to change the indexing key in EP from the model number to another field (such as the image path, since that is unique by definition). This assumes that the PN's all have a unique image.

Myself, I would stay with the VW-0123456 idea.

I have just started using EP 1.2.5.6.
I hope you guys will help me get started with this add-on that I really need to use.
I didn't need to run any SQL, just uploaded the files and it was there.
Just in case I ran ?langer=install in the address bar after easypopulate.php and got warnings, but the files finally downloaded to tempEP.
When I attempted to download attributes I got the following:
"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."
But in the end I did get the file, I have literally hundreds of attributes and was seeing all of them for all models, even those that don't belong.
Any input on this error, please?

Hey guys,

I'm relatively new to ZenCart and just starting to use it on a website for the company i work for.

I have the latest version of ZenCart, running a few add-ons, all to no luck as of right now. That is why I got on the forums.

I installed Easy Populate (latest version) and noticed it was giving me the array_flip error... Fixed that pretty easily, and noticed that my company didn't spring for PHP5 so running PHP4.

lame, i know

anyway, so now I am siting here and and everything seems to be working OK, no errors.. BUT, as soon as I upload to teh temp, then upload up, or do any type of "insert into db" .. I get nothing. it says its all okay, but nothign is actually pushing up.

I am goinng to do some more searching, just confused as to where the issue is... php4 issue? (i went back a few versions to see if this was the case... and still didn't work) install issue? (tried reinstalling a few times with a few different versions). array_flip fix issue? (maybe this does not actually fix it?)

any help appreciated.

royboy789:

as soon as I upload to teh temp, then upload up, or do any type of "insert into db" .. I get nothing. it says its all okay, but nothign is actually pushing up.
If you download the .csv template and then re-upload it, nothing will happen, and that is OK.

ckosloff:

If you download the .csv template and then re-upload it, nothing will happen, and that is OK.

wait, that makes no sense... it says everything goes through ok, when i hit "insert into db" or watever... no errors

but the products i put into the CSV (new ones) don't get put into my store... very weird.

I changed this from 0 to 1000 but someone mentioend maybe i should have made the string larger, so I put in a few zeros.... still not working.

array_flip(fgetcsv($handle, 1000000, $csv_deliminator, $csv_enclosure))) {

royboy789:

wait, that makes no sense... it says everything goes through ok, when i hit "insert into db" or watever... no errors

but the products i put into the CSV (new ones) don't get put into my store... very weird.

I changed this from 0 to 1000 but someone mentioend maybe i should have made the string larger, so I put in a few zeros.... still not working.

array_flip(fgetcsv($handle, 1000000, $csv_deliminator, $csv_enclosure))) {

I don't know if the problem I had and the way I solved it will help you or not...but here goes.

I had downloaded my entire ez-populate list of products...a total of about 2500 because I had to make some changes....Once I made the changes i used the tool to split the files which were uploaded to my temp file. Then I started to upload each file...but although I got the message that everything was okay...actually nothing was being uploaded.

So I downloaded all 8 of the temp files to my computer and took a look at them. One thing I noticed was that there were several columns that I really did not use that appeared blank...but I decided to delete them anyway...they were the specials_price...specials_date_avail and specials_expires_date. Once I deleted those columns and had ezpopulate upload each of the files everything worked fine.

Wish I had great insight as to why it worked...but you might try and look for some columns that should be blank and eliminate them and see if that helps.

Good luck.

I have searched through this thread and have not found any mentioning of this issue, and I apologize if this subject has already been covered.

I have a large inventory of items (48000+). When trying to download a Froogle (Google Base) feed, and when, in fact, trying to download any of these .csv/.txt files, my Admin area times out.

When I uploaded the inventory, I used a simple CSV splitter program to break up the upload file into 1000 item chunks...and I'm sure that if I were more PHP savvy I'd be able to code something to do the same thing but...I ain't. Any suggestions?

:frusty:

Thanks in advance,

Dale

We have just install Easy Populate

Version: 1.2.5.6.csv.2
**Last Updated: **Jun 18 2009

Into Zen Cart™ Version: v1.3.7

It works great except for one bug. When you give the item a price ie $1.00 and you set sales tax in my case to IN @ 7%, it writes the $1.00 into the gross field and writes the net field as $0.93... basically lowering my net price.

We tried it without setting sales tax and it write $1.00 in both net and gross.

My solution until this is fixed is to load all items with no Sale Tax and then use SQL to change the flag

Anyone else experiencing this?
Mike