Easy Populate 1.2.5.4 support

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

Quote:

---

Originally Posted by 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/priv...sypopulate.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.

Quote:

---

Originally Posted by 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/priv...sypopulate.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