Easy Populate 1.2.5.4 support

maxim:

Greetings all,

Has anyone with a large store (e.g., 20,000 products) had success with Easy Populate? If so, would you mind posting or PMing me your host. My host upgraded MySQL, and I am being told that I have to use SSH (instead of Easy Populate) to update the database. I have been trying to get it figured out for months...to no avail:shocking:. So, I am hoping to find advice on an alternative host which can handle Easy Populate for large stores.

Thanks in advance...and don't forget to vote!

Maxim

I have nearly 50,000 stamps on mine and have little to no problems except that the confirmations do not show. I use a US firm of TCH (Total Choice Hosting), if I am allowed to say that here.

We have a couple of large stores (10,000 + products) and I generally run Easypopulate updates in "tranches" - by manually splitting the tab-delimited files to more manageable numbers.

In our big store (15,650 products) I generally split the main spreadsheet into three section (roughly 5,000 products each), then run each of these through EP.

It takes a bit longer - but it generally avoids errors.

... and I ALWAYS do the EP from the temp folder in the site itself - never via a remote upload.

elkbow:

The first thing I see is the Unique Model Number is the same for all of the items shown above. try changing the 3364290 to
3364290A, 3364290B, 3364290C. Since you have different named sub categories and the same model number is the linked problem.

ok, I have adjusted our spreadsheet now and added A, B, C to products with the same model number...

so now, can I upload the spreadsheet? what will happen? will it make this spreadsheet our new DB? what I don't want to happen is it leaves the old ones and adds these on top...

ebaobao:

Hello,
So I just got done importing my file. I went to tools->ezpop, then browse my file and click on import. There was about 14000 records. The import seems to be complete because it had the waiting message at the status bar below my browser while it seemed to be importing or doing something. About 10-15min later the waiting messge disappear..I got no error. But I never got a success message either so I'm not sure. Anyways, I went to browse my products and I don't see any. I went to view my tables via phpMyAdmin and nothing has changed either. So what could be wrong?

Me too! Did you ever find a way to make easy populate create the categories or sort products to the appropriate category without specifying "v_master_categories_id" I've labeled the appropriate category names in "ptc_categories_index_path".

Hi All,
Langer said to make specials_price "0" to delete the special from the product. I have done just that and it says 15 products successfully updated but the prices remain the same. The products still have specials on them. Where am I going wrong here?

Thanks,
John

Hello. I apologize if this has been covered already, but I have been scouring the forums for two days and couldn't find it. I am setting up a clothing retail store on Zen 1.3.8a. I have quite a few products from different companies. Each company names their colors differently, so I have ended up with 169 colors to add into my attributes. I added them into the option value controller, but when I try to download the file from EP (v. 1.2.5.4), the file is too long (too many columns) to open with Open Office or Excel. Is there a way of splitting the file so I don't have to enter these colors into each product individually? Any help is GREATLY appreciated!

awhfy99:

I have nearly 50,000 stamps on mine and have little to no problems except that the confirmations do not show. I use a US firm of TCH (Total Choice Hosting), if I am allowed to say that here.

I just want to say a big "THANKS" to all who responded to my issue. I will try out the various suggestions.

Much love, maxim

heavenlynights:

OK, after much frustration and very close examination of the products table in phpMyadmin, I found where my problem was and that was that the EP complete download was missing a field "v_products_ type" and was therefore defaulting to 0, where type should have been 1. As soon as I edited the table by replacing the 0 to 1 in the products_type within phpMyadmin, I was able to access product page on my storefront and I was also able to access all product features ie: edit, copy, move etc within the store admin without being re-directed to google.com

My questions are now.

has anyone else had this problem, or is it just an isolated incidence with my downloaded file and if so what would have caused the omission.

and

if the "v_products_type" field is not meant to be included as part of the downloaded file, where would be the best place to add this field in the csv file for uploading so that I don't have this problem again.

Thanks

Ok after waiting so long for an answer re: adding field to csv and not getting one LOL, i decided to try it anyway and I can confirm that adding the "v_products_type" field to the file and setting it to 1 does NOT work.

Anyone got any suggestions, because if I can't figure this out it would be pointless using EP if i have to physically go into phpmyadmin to change the settings of each new product that i upload via EP to product type "1"

TIA

and was therefore defaulting to 0, where type should have been 1
It looks like you somehow modified the structure of the products table. The default setup is for products_type to have a default value of 1.

As it appears that EP only supports standard products (type 1), it does not need products_type column and the update just uses the default ("1").

Jeff

Jeff G:

It looks like you somehow modified the structure of the products table. The default setup is for products_type to have a default value of 1.

As it appears that EP only supports standard products (type 1), it does not need products_type column and the update just uses the default ("1").

Jeff

thanks Jeff but Gee how would I have done that without knowing and where would i have done that, store admin or through phpmyadmin? (although i don't normally fiddle with the database in phpmyadmin only now because I have had to, with EP.

Any idea on how to set the default back to 1?

Thanks

ok here is a snippet from phpmyadmin for product types

Edit   	Delete   	1  	Product - General  	product  	1  	Y  	   	2006-01-30 22:01:54  	2006-01-30 22:01:54
Edit 	Delete 	2 	Product - Music 	product_music 	1 	N 	  	2006-01-30 22:01:54 	2006-01-31 19:32:34
Edit 	Delete 	3 	Document - General 	document_general 	3 	N 	  	2006-01-30 22:01:54 	2006-02-27 12:14:34
Edit 	Delete 	4 	Document - Product 	document_product 	3 	N 	  	2006-01-30 22:01:54 	2006-01-31 19:34:12
Edit 	Delete 	5 	Product - Free Shipping 	product_free_shipping 	1 	Y 	  	2006-01-30 22:01:54 	2006-01-30 22:01:54

does everything look ok or not?

In phpMyadmin,

1. find table products
2. click box next to products_type
3. click pencil (edit)
4. "default" should be "1", if not, change it and "save"

I just saw the second part of your post. It has nothing to do with that table. It's only the "products" table.

I'll be around for another hour or so. Let me know how you make out.

Thanks Jeff. Turned out default was set to 0. have now edited this bit to default to 1. Hopefully this will make a differnce.

Thanks so much for your help :thumbsup: :cheers:

Always glad to help when I can.

I'm trying to use the EP to adjust stock by attribute. I did a test on a few products and I screwed up something. Now all of my variants display this symble " : " instead of the name (i.e. instead of showing small, medium, large - each one showed : . The quantity was correct though)

Is there a quick and dirty guide to the stock by attribute template for EP? I did a thorough search of not only this forum, but google as well.

Hi again

Need a little more help. I have 3 new columns in the products table that I need extracted into the Full EP file when I run EP.

These are:

products_height
products_length
products_width

Can anyone tell me what code I would need to add and to what file I would need to add it too. My guess I would need to add it to file easypopulate.php?

TIA

i've configured my zencart site to use iso-8859-2 encoding. my database zc1 is set to collate to utf-8.

when i add products via Admin -> Catalog -> ... new product, i use my language characters (čćžšđ) and they display ok on site.

i downloaded EasyPopulate's complete tab-delimited .txt file, edited it in notepad++ and saved using utf-8 encoding. then i go to EP, Upload EP File, select the file and hit insert into db. Everything ends ok, but when go to se the products on my site, the text is this "mi� cc��d" instead of this "miš čćžšđ".

What am I doing wrong?

When i click on:
Download Complete tab-delimited .txt file the file does not show v_categories_name_1 etc.. can someone help please

loti29:

When i click on:
Download Complete tab-delimited .txt file the file does not show v_categories_name_1 etc.. can someone help please

If its a new install, try adding a category and a product before downloading that file.

If your store has products and they are priced by attributes, then good luck getting the download to look right. One I tried that way was really unusable.

If its a new install and it still looks funky after adding that catagory and product, I would reread the install instructions and try again.

Thank you.. i reinstalled and followed all the instructions and it worked great.