Easy Populate 1.2.5.4 support

chadderuski:

Hiya Elkbow!

Yes, I did notice but I hoped my explanation would cover it!

Did you take a look at the quantity discounts (a page or two back) download/upload I figured out?

-cj

cj,
I downloaded that Q discounts and looks pretty simple. And that post # 2035 above should give the EP users what they are looking for. I run about 5 stores and only use attributes on one since they do not work in EP, so I just list the 6000+ items by EP.

Chris21 should remove all EP he has and upload again - no changing of admin name.

Elkbow.

I am using Easy Populate 1.2.5.4. and imported all data successfully from EasyPopulate, but noticed that my categories had a few misspellings, so I went in and changed them in the local spreadsheet, saved as a tab-delimited .txt file and reuploaded. It said it was successful, but instead of overwriting the old categories with the new ones, it added them. When I look at the products_to_categories table, it has the products_id listed twice, once with the old categories_id and once with the new categories_id.

Is there a way for this to overwrite instead of just adding another category?

Thanks.

Jason

Hey Jason,

Yes, easy way, in my opinion anyway:

Take your spreadsheet and rename the categories to what you had before you changed them and change the second-to-last column to 9 instead of 1. Then upload. That will REMOVE all your items. While it's working, open the file again and change the 9's to 1's and fix the category names.

Once the products are removed, delete out the unwanted categories.

Then upload the new file. This should add your items back in and into the categories you wanted in the first place.

IF you put descriptions in the old category names, and want to keep that info, just rename them to exactly what EP has in the spreadsheet and it'll work fine as well.

That's what I'd do.. unless someone else has a better answer???

Remember to backup your database before you do anything I've mentioned, in case you delete all your products and can't get them back for some odd-duck sorta reason!

Jake

Have you seen my tutorial at:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

Delights:

Also incase people are interested, i have been able to add new fields to Easy Populate so that you can add new fields as well. The only file you need to edit is easypopulate.php and below is a link to the one that i made, it allows you to upload 5 new fields called; "Materials, Finish, Height, Width, Length".

You can use this a a guide and make it to however you want.

http://www.agelessartifacts.com/private/easypopulate.rar

Thanks delights, this is just what I was looking for a few pages back. you have come to the rescue! :smile::clap:

Does anyone where to limit how many megabytes EP uses? Is this controlled within the script itself or is controlled by the php.ini file?

My host told me it's consuming a lot and need to decrease it.

Thanks for any info. :)

I have a client with 44,000 products. I uploaded them into the database with Easy Populate by breaking up the files into 4,000 product segments (yes, this took some time). Well, of course, now we need to do some mass changing and I can't download from Easy Pop as I have too many products.

Does anyone have a SQL query which I could run in my php MyAdmin that would give me the same type of output that Easy Populate would? I don't mind reuploading in smaller segments but my SQL is a bit rusty and it would be great if someone has already done this.

Thanks!

Janelle

Thought I might have it - nope.

Janelle,

Have you tried doing an EP export to your TEMP directory, then use FTP to get the file to your local machine?

I'm a newbie and got a few questions about EP. Can anyone help?

1. What's the smart tag feature for?
2. How to upload multiple image for a sinlge product. I've tried tag: v_products_image_1, v_products_image_2, but failed.
3. Any user guide about how to use the attribute tag? The user guide in zencart wiki doesn't mention this.

Delights:

Also incase people are interested, i have been able to add new fields to Easy Populate so that you can add new fields as well. The only file you need to edit is easypopulate.php and below is a link to the one that i made, it allows you to upload 5 new fields called; "Materials, Finish, Height, Width, Length".

You can use this a a guide and make it to however you want.

http://www.agelessartifacts.com/private/easypopulate.rar

Tried to adapt this to my store.
In your case you've added 5 new fields, in my case I only have 3 so I have made the correct changes in the file.
My Product table also have these 3 extra fields added.

Trouble is it doesn't seem to work and I can't see why.

based on your template, I simply did a search/replace for my fields.

I checked, double checked etc and I can;t seem to find what's wrong.

At the moment I have only 1 product in the store, so what I did is extract the data using EP admin via Download Complete tab-delimited .txt file to edit, then edited it in XL and added 1 product.
The loading of the file is working into temp, and when updating the database, it says it's working. when checking the store or the DB table, nothing is there...

Hope you can help..

Thx

Fixed my own problem by making sure each product has a model number (needed by easypopulate).
Thanks to a forum member for his help.

tj1:

Does anyone where to limit how many megabytes EP uses? Is this controlled within the script itself or is controlled by the php.ini file?

My host told me it's consuming a lot and need to decrease it.

Thanks for any info. :)

...just an update, my host told me this is not the limit set on the php.ini files, but it is invoking a process on the server which is using 80MB of memory once the easypopulate.php page is accessed.

This was the result of uploading a file with a size of 6MB, is this normal? I didn't think easypopulate should used that much resources.

I use up to date version of Easy Populate & Zen Cart.
Manipulation with EP is OK till I delete column "v_products_description_2" - in this case import goes OK, BUT in ZC disappear everything in column "v_products_description_2", or (when admin/EP "Advanced Smart Tags" is set to True) there is just "<p></p>". What is wrong?

I thought that before import I can delete all columns I do not need except columns "v_products_model", "v_status" and "EOREOR".

I searched forums, wiki EP and sources, but no solution founded.

imagino:

I thought that before import I can delete all columns I do not need except columns "v_products_model", "v_status" and "EOREOR".

I am almost sure that month ago it was OK. So may be I changed something, but EP PHP files are same as those source files.

alimtlai:

I'm a newbie and got a few questions about EP. Can anyone help?

1. What's the smart tag feature for?
2. How to upload multiple image for a sinlge product. I've tried tag: v_products_image_1, v_products_image_2, but failed.
3. Any user guide about how to use the attribute tag? The user guide in zencart wiki doesn't mention this.

1. Smart Tags: This appears to be used for doing string substitution at upload. You don't need this as you can use inline html in the descriptions and zencart will render them fine. I think this was meant provide smart substitution of text ->>> to ->>> <html>text</html> At least that is what is looks like.

2. Multiple Images: you only need supply the base image for zencart. EP does not UPLOAD images, only set the image's name and path. I don't remember off the top of my head, but if your base images is "image.jpg" your added images are "image_01.jpg" "image_02.jpg" etc. Check the FAQ on this.

3. Attributed DO NOT work. Don't waste your time. That's why it's been left out of the wiki entry.

I added Easy Populate files and sql update and would like to back out changes. I backed up files so that part's easy. How do you undo sql update?

Cheers,

Gene Fourney
The Highlands Group

fairestcape:

Janelle,

Have you tried doing an EP export to your TEMP directory, then use FTP to get the file to your local machine?

Sorry - been away for a bit. Yes, I did try to do this but I get a 505 error each time. I'm assuming it's just really too big. Any suggestions would be appreciated.

Hi Guys

Hope you can help me with this one
Im pulling my hair OUT:frusty:
ive spent hours search the forums
I seem to have the same problems as others but ive tried everything wiht no joy
this is the message i get when i upload my txt file
SKIPPED! - Model: - No category provided for this product1 |
SKIPPED! - Model: - No category provided for this product2 | SKIPPED! - Model: - No category provided for this product3 |
SKIPPED! - Model: - No category provided for this product4

I have this error for every item i try & upload

PLEASE HELP:cry:

welshranger:

Hi Guys
this is the message i get when i upload my txt file
SKIPPED! - Model: - No category provided for this product1 |
SKIPPED! - Model: - No category provided for this product2 | SKIPPED! - Model: - No category provided for this product3 |
SKIPPED! - Model: - No category provided for this product4
The message tells the problem. The file must have the category column and every product must have a category name.