Easy Populate 1.2.5.4 support

I'm writing in hopes that someone may be able to quickly resolve the issue I am having. I have been working with developers to upload a suppliers catalog (in the form of excel spreadsheet) of 65,000 products into our database using EP.

Initially they uploaded all the products to MasterCategory=0. I then created a Misc. Category (ID#730) and a subcategory (#838) in which I want this particular catalog to go to. I then had them re-upload the products into the database with a MasterCategory ID#838 which is the subcategory I would like all the products to appear under.

The store shows that there are 65,000 products but on the site it only shows a short list of newly added products. In the admin side of ZenCart when clicking the miscellaneous category, the subcategory then disappeared. I tried adding a new subcategory and going into the database to change that category ID back to 838 so the products would appear but alas, no luck. Anytime I change the category ID to 838 the category then disappears although the products and the product_to_category ID relationship is established in the database...... Any suggestions??

Hey Boaters Planet - I'll take a stab at this if you haven't figured it out yet.

I do know that if you upload a product with a Model# that already exists, but the category is different, that new category will only be linked product and not a NEW master category. So what you do to change an entire category of link products to a master category is navigate in your ADMIN/Catalog to your list of products. Then on any of the products click the C for copy at left. Once the next page at the bottom left you'll see a button called "Multiple Category Links Manager". After clicking that you see a list of ALL the categories you have created. if the product you are looking at is in more than one category then more than one category will be checked. the one that is yellow is the master category. So if you see that you want to change that product;s master category AND all the products in that category along with it, look at the very bottom of the page where you'll see "Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ..." enter the number of the category you want to be the new Master category and viola! It changes.

I hope this helps! I'm sure why the category you created disappeared. Hopefully there's a logic explanation for that.

And now here's my Easy Populate problem!

I just finished add A LOT of attributes - 187 to be exact - and now I'm getting an error when I try to download (or create for the temp folder) a Model/Attributes.txt file. Other files are created fine, its just the Attributes one that isn't getting created. It might be a Timing Out error because the file is so large. The error I'm getting after about 90 seconds is:

500 Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache mod_fcgid/2.3.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at focalpointhardware.net Port 80

I'm using Hostgator as my hosting service. I look in my cpanel at my "error log" it reads:

[Mon Apr 11 14:18:56 2011] [error] [client 7#.##.##.253] File does not exist: /home/focalpt/public_html/500.shtml, referer: http://focalpointhardware.net/zc_admin/easypopulate.php

Could the attributes file just be too large to create and thus the server is timing out? Or could there be some error how I entered my attributes? Here's an example of an attribute entry:

[DMY-LR EP 03] Dmy Left-Right EP Polish Brass

I just can't seem to figure this out. :frusty:

Hi,

I am using Easy Populate 1.2.5.4 and its working perfectly but i am having a slight issue when it comes to images. I am using excel to add my items to the website but you see i have an excel sheet with all the product details and everything about the products except the image path. Then i have a second excel sheet with about have those products on it with all the same details only i have the image path on this one.

Is there any way of putting the image paths into the correct products using excel or easy populate?

Something like this:
insert "v_products_image" from "database1" to "database2" where "database1" "v_products_model" = "database2" "v_products_model"

Thanks

BrooklynArtist:

And now here's my Easy Populate problem!
[Mon Apr 11 14:18:56 2011] [error] [client 7#.##.##.253] File does not exist: /home/focalpt/public_html/500.shtml, referer: http://focalpointhardware.net/zc_admin/easypopulate.php

FIRST! NEVER NEVER NEVER post this kind of server path details in an open forum. You're looking for all sorts of trouble form the hackers.

EP 1.2.5.4 Attributes DO NOT WORK! Period. You will need EP Advanced 3.03 from Langer. Unfortunately, he hasn't been around for years and there is no guarantee you'll get what you pay for if his site is actually still up. And his solution is clunky at best.

Optionally, you can try my BETA version off github. I have BASIC attribute imports working. PM me for any help as I don't want to hijack this thread:

https://github.com/chaddro/EasyPopulate-4.0

It installs independent of EP 1.2.5.4. Remember, BETA! Back up your data! Hoping to post it for public thrashing one of these days soon.

-cj

HI!
I've just installed Easy Populate and can not see it in my ZC admin page. please advise. thank you

QueenKat:

HI!
I've just installed Easy Populate and can not see it in my ZC admin page. please advise. thank you

Hiya QueenKat,

You are most likely missing one or more files if you are not seeing the Tools > Easy Populate or Config > Easy Populate options. Verify that each file did correctly upload to your server.

Also, please give Schoolboy's great Wiki entry on Easy Populate:

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

That should get you on the right road.

I am an EP noob so please excuse my basic questions, I have searched around and am a little confused.

I have an existing download store and now have a load of physical (shippable) products to add in their own seperate category.

I installed EP, looks fine, the spreadsheet for my existing stuff was created ok. Have attached a few lines, take a look if required.

I have 2 questions:

1. I would like each product to have 2 images, one small 'title' image which would be the product thumbnail and a second 'main' image which would be seen in the product. Can I do this with EP or do I need something else?

2. Shipping, all of the existing products on the spreadsheet are downloads. The new products would all have the same shipping details. Is there a way to specify this in EP?

I've added my products using EP just fine, but even though they are visible on the store side using search, when I search on the admin side, they are never found. Any way that I can fix this? Thanks!

Cheepnis

Do you have breadcrumbs visible on your store? If so, after you do a search on a product, click it to view it's "Product Page", then look at the breadcrumb to see the path. It should show you the category or subcategory that it is in then follow that in your Admin/Categories.

If you do all that and still can't see then I'm stumped.

BrooklynArtist:

Cheepnis

Do you have breadcrumbs visible on your store? If so, after you do a search on a product, click it to view it's "Product Page", then look at the breadcrumb to see the path. It should show you the category or subcategory that it is in then follow that in your Admin/Categories.

If you do all that and still can't see then I'm stumped.

Well, yes, that would allow me to find the product within admin, but I SHOULD be able to just do a simple search within admin and have it show up there right away. The search function is what seems to be broken.

got a problem with EP

download full EP from my site and change information and upload... all spot on and working :-D

download price and qty from my site, change a feu prices and upload, chnages all the prices correctly but then also deletes all my product descriptions!!

whats the deal there??

kitcorsa:

got a problem with EP
download full EP from my site and change information and upload... all spot on and working :-D
download price and qty from my site, change a few prices and upload, changes all the prices correctly but then also deletes all my product descriptions!!
whats the deal there??

Are you sure you are using 1.2.5.4? Some of the other version have "issues" ...

whoops sorry Easy Populate 1.2.5.5.csv

ebay turbo lister with easy populate

a dream but I think you can do this? I think many would be very glad to see this in action.

is it possible or it is already being done?

searching but cannot get answer.

Can we export our product from zencart to excel file then import it with TL?

Thank you

I'm getting this error when trying to use the Easy Populate add on

Warning: explode() [function.explode]: Empty delimiter

includes/functions/extra_functions/easypopulate_functions.php on line 241

what does that mean and how do I fix it?

I re-uploaded that file to the server and that didn't help..

How to include weight field in Easypopulate Froogle downloaded textfile?

Where do I locate the file to alter??

We are using Easy Populate 1.2.5.4 and Zencart v1.3.9e

Appreciate all help.

Thanks,
Per

Hi all,

Forgive me for asking a question which has no doubt been asked before but I couldn't find it when searching the thread.

What happens when a store already has products that never used model numbers ?

Well actually I know the answer to this :oops:

When downloading the product file for the first time non of the products had model numbers. After I assigned model numbers to these products and uploaded the file easy populate created new products for each model number. However the old products were still there so basically I was left with each product on the system twice - the original unmodeled one and the created by easy populate modeled sku.

No major issue caused as I had a backup to restore but what's the best way around this (other than assigning model numbers first before running easy populate - we have 5,000+ products in the database)

pixbo:

How to include weight field in Easypopulate Froogle downloaded textfile?

Where do I locate the file to alter??

We are using Easy Populate 1.2.5.4 and Zencart v1.3.9e

Appreciate all help.

Thanks,
Per

Rather use NUMINIX's excellent GoogleBase generator and feeder. EasyPop's Froogle feeder is many years out of date and probably does not conform to Google's requirements.

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=473

QueenKat:

I'm getting this error when trying to use the Easy Populate add on

Warning: explode() [function.explode]: Empty delimiter

includes/functions/extra_functions/easypopulate_functions.php on line 241

what does that mean and how do I fix it?

I re-uploaded that file to the server and that didn't help..

This is just a rather obscure error message and it is telling you that there is something amiss with the TXT upload file that you are trying to load in the database.

In many cases, it relates to DATE fields (such as "date added", "specials date" ...).

You MUST make sure that:-

1. Your EasyPop CONFIGURATIONS are correct (admin >>> configuration >>> Easy Populate) - particularly regarding the DATE formatting.

2. When you open your TXT file in a spreadsheet, it is very likely that it will automatically see the date values, and then REFORMAT them. This is a pain in the b u t t and you will have to make sure you REFORMAT the dates to that which EP uses. View a RAW text file of your data to see how EP is formatting your dates:times .

3. Generally, you can safely REMOVE EP columns (from the spreadsheet) that refer to DATES (unless of course you want date DATA in your upload.

The key to successful EP uploads is making sure that the TXT file is 100% accurate (in terms of complying with EP formatting).

SEE MY WIKI on Easy Populate:
http://www.zen-cart.com/wiki/index.php/Easy_Populate