Easy Populate 1.2.5.4 support

how can i make updates to my product list with EP?

basicly, i want to add my products first and later their description.

first, i want to insert a product list with product_id/model, name, price and category. then i want to insert a new file with almost same product_id/model but only description and weight. when i say almost same, i mean that first file has 40 models and second only 30 of those 40.

when i do it like this for 4 products, my category sidebox says 8 and shows only 4 (from the first file). also, the descriptions (second file) are not shown anywhere. also, EP says NEW PRODUCT when i upload my update.

what am i doing wrong? how can i do this?

this is my first file (+ is for empty tab):
1100 + prod_1 + + + + + 100 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
2200 + prod_2 + + + + + 200 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
4400 + prod_4 + + + + + 400 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
5500 + prod_5 + + + + + 500 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR

this is my second file:
1100 + + desc_prod_1 + + + + 100 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
2200 + + desc_prod_2 + + + + 200 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
3300 + + desc_prod_3 + + + + 300 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR
5500 + + desc_prod_5 + + + + 500 + + + 50 manuf_1 cat_1 sub_1_1 sub_1_2 + + + + tax 1 EOREOR

prosam:

Ok I found the answer to my question and here it is if anybody else needs it. This worked in ZC 1.3.8 not sure about the older or newer versions coming out.

In includes/functions/html_output.php after

//auto replace with defined missing image
if ($src == DIR_WS_IMAGES and PRODUCTS_IMAGE_NO_IMAGE_STATUS == '1') {
$src = DIR_WS_IMAGES . PRODUCTS_IMAGE_NO_IMAGE;
}

> 
> Enter the following:
> ```
	if (!file_exists($src)) {
      $src = DIR_WS_IMAGES . PRODUCTS_IMAGE_NO_IMAGE;
	}

This will replace any broken product images with the no image file.

Thanks for supplying the fix for this!

Hi folkz. I got this message in the top of my screen when i enter the EP admin screen. "Warning EASYPOPULATE_MSGSTACK_DROSS_DETECTED"

What does this mean, and am I doomed? ;):smile:

I'm having a heck of a time with Easy Populate today. I thought it might be my having over 2000 items in the csv... but read on here where people upload larger files without a problem.

I upload the file, doesn't work, page times out, no items imported.

Last week I created an import list, using the downloaded one as an example and it worked fine (still does). I can add and delete 200 items with no problem.

When I went in yesterday and again this morning to add a bunch more, using the same format and put these items into different categories, it doesn't do it.

Plus, it times out even when trying to download the main file (it does work when you have it create the file in the temp directory.

I was hoping Easy Populate would make changing 1000's of items an easy process. So far, that's not the case. Can anyone help make this thing work smoothly or is it always a rocky road to travel?

Thanks!

Jake

jakedownhere:

I'm having a heck of a time with Easy Populate today. I thought it might be my having over 2000 items in the csv... but read on here where people upload larger files without a problem.

I upload the file, doesn't work, page times out, no items imported.

Last week I created an import list, using the downloaded one as an example and it worked fine (still does). I can add and delete 200 items with no problem.

When I went in yesterday and again this morning to add a bunch more, using the same format and put these items into different categories, it doesn't do it.

Plus, it times out even when trying to download the main file (it does work when you have it create the file in the temp directory.

I was hoping Easy Populate would make changing 1000's of items an easy process. So far, that's not the case. Can anyone help make this thing work smoothly or is it always a rocky road to travel?

Thanks!

Jake

Hi Jake.

Seems strange. Personally I´ve imported almost 15.000 products at once, by uploading the file to the temp dir, and then imported it. By uploading and importing manually I get stuck on 3-4000 files. So if you have don that, please try to upload it to the temp dir first. If there is a problem with the file, you must upload it and include it here so that we can check it for errors.

Good luck :smile:

minshop.no:

Hi Jake.

Seems strange. Personally I´ve imported almost 15.000 products at once, by uploading the file to the temp dir, and then imported it. By uploading and importing manually I get stuck on 3-4000 files. So if you have don that, please try to upload it to the temp dir first. If there is a problem with the file, you must upload it and include it here so that we can check it for errors.

Good luck :smile:

Okay, so how do you import a file in the temp dir? The page doesn't have a link there otherwise... or do you just type in the filename and click 'insert into db'?

jakedownhere:

Okay, so how do you import a file in the temp dir? The page doesn't have a link there otherwise... or do you just type in the filename and click 'insert into db'?

Okay, so I re-installed the easypopulate.php file and found the import from temp and split files options.

I'm still getting it timing out on a 10 item upload file.

It still isn't adding products. I'm going to try creating one product in each new category as a test, then uploading to that category and see if that works...

ANY help is greatly appreciated! I've been up all night trying to get this to work as an e-newsletter is going out in just over an hour and I want to make sure all my available products are up when people start browsing the site!

Thanks again!

mydanilo:

I am working on a test site and I can't upload my products right.

I exported from another shop then uploaded in my test shop. Categories get created, both levels.

Easy Populate 1.2.5.4 page at the bottom shows all products that have been uploaded, no errors but if I check in my store, only the categories are there but no products.

Now I go in admin- catalog- categories/products

I look at the new created category and see 17 of 17 active on the right, I click to go into the category and there is nothing there ether.

fix_cache_key and reset master id, cleared imagehandler cache.... what else?

I uploaded the same file one more time and Easy Populate shows:
Upload Results

File uploaded.
Temporary filename: /tmp/phpYI6geD
User filename: Full-EP2008May08-1111.txt
Size: 33656

UPDATED! - Model: WXPT0055 | FIGS-AND-M | Figs and M | This Figs | | | | | 19 | 2 | | 03/11/08 1 | 1 | | Wax Potter | Wax Potter | | | | | | Taxable Go | 1 |

and so on for all products. It shows UPDATED, meaning there were products to be updated? Where are they? Any idea?

mydanilo did you get this issue resolved? I have the exact same thing happening but I actually was able to import data with no problem at one point. I am now trying to add some more and update others and nothing. I deleted all the products checked the DB and still nothing. At this point I'm thinking of re-installing ZC and EP. Can someone help me out here?

prosam:

mydanilo did you get this issue resolved? I have the exact same thing happening but I actually was able to import data with no problem at one point. I am now trying to add some more and update others and nothing. I deleted all the products checked the DB and still nothing. At this point I'm thinking of re-installing ZC and EP. Can someone help me out here?

WELL!!! I figured it out! At least on my end.

@woodymon and @mydanilo if you are still having this problem please make sure that your upload file's Quantity column at least has a number in the field for every product even if it's just 0. This store I'm working on does not require inventory checking so I had left that field blank. Yeah, I'm at fault. Oh well we live, we learn.

prosam:

WELL!!! I figured it out! At least on my end.

@woodymon and @mydanilo if you are still having this problem please make sure that your upload file's Quantity column at least has a number in the field for every product even if it's just 0. This store I'm working on does not require inventory checking so I had left that field blank. Yeah, I'm at fault. Oh well we live, we learn.

Scratch that. That did not work. I also had created some test products before importing again, that might be the answer. I have no idea. Back to the drawing board.

jakedownhere:

Okay, so how do you import a file in the temp dir? The page doesn't have a link there otherwise... or do you just type in the filename and click 'insert into db'?

That is correct Jake. the "insert into db" looks in your temp dir. So you just upload the txt file with ftp, and then enter the filename in that field, and push the button. Try with a few lines first. If it still does not work, please attach your file to your next post.

prosam:

Scratch that. That did not work. I also had created some test products before importing again, that might be the answer. I have no idea. Back to the drawing board.
Well I believe I have figured it out, for me at least. A long with making sure that there's at least a Zero in the quantity column, I also had to make sure that in the v_tax_class_title column that Taxable Goods is capitalized. Those two things fixed allowed for the products to show after uploading. The weirdest thing, but it might just be case sensitive.

Again, this worked for me not sure if it will for all. If you find that after successfully uploading your txt file and your products are not showing, while the Categories are; go back and make sure that the above 2 things are all set.

How can i remove this from the database. i installed it a moth ago and now have noticed my design center is not work. I was told i need to remove it but im not sure how to remove the sql i uploaded.

Hi folkz. I got this message in the top of my screen when i enter the EP admin screen. "Warning EASYPOPULATE_MSGSTACK_DROSS_DETECTED"

Anybody have the answer to this one?:dontgetit

Hi guys.

I have started using Easy Populate recently and it seems to be a great resource. However I am experiencing a couple of problems that I hope you can help me with:

1. I am uploading about 250 items from at Tab Delimited file, and they all upload apart from 3 of them. On these items it says "no category selected for this product," so they will not upload. I have double checked the categories for these items and they have definately been correctly selected. Why are they being skipped?

Hi guys.

I have started using Easy Populate recently and it seems to be a great resource. However I am experiencing a problem:

I am uploading about 250 items from at Tab Delimited file, and they all upload apart from 3 of them. On these items it says "no category selected for this product," so they will not upload. I have double checked the categories for these items and they have definately been correctly selected. Why are they being skipped?

Hate to cut in on all, and wish I could help some, but not that wise yet, sorry....

My question I have.... please look at my site

http://www.fragrancewholesales.net

If you go to the toolbar , and drop down the categories, it doesnt show everything, I have wayyy to many categories. I was wondering if i scroll down the categories that they could all be seen somehow..

Thanks a lot...

i have read, and read but dont understand where to put the ep files

in my download there ae two folders
admin
temp
and 4 txt files
and 1 sql file

where do these go?

your assistance is appreciated

ok - found the answer on page 43 of the orig thread
of course it is a duh once you know :P

jgg1974:

Hate to cut in on all, and wish I could help some, but not that wise yet, sorry....

My question I have.... please look at my site

http://www.fragrancewholesales.net

If you go to the toolbar , and drop down the categories, it doesnt show everything, I have wayyy to many categories. I was wondering if i scroll down the categories that they could all be seen somehow..

Thanks a lot...

jgg1974: You should post your question over in the Apple_Zen forum. Jade is quite helpful. There has been discussion on this topic, but it was well over a year ago. Really, you may need to think about how to organize you products in such a manner that works with the hover menu. There is no real good answer.