Easy Populate 1.2.5.4 support

warefare:

Hi

well I have a problem OO Calc won't let me import the file I have completely, it will cut off some columns. Even tried uniCSVed and CSVed, no luck either.

I got to add 100 products but all have different attributes, e.g. a bra that has different sizes.

My client does not want to go through editing tons of lines over and over again. What would be the fastest way to add attributes to a product relatively quickly?

Does EP advanced have a GUI? That would be a feature.. you just select the attributes that are already stored into zencart and you can mass-add it to any product. That system would be fool-proof ;)

Thanks for your help and suggestions :)

Hmm I just realized that I can copy attributes via zencart :oops:

But if I just want to add 3 attributes and the others should be "default" attributes what would I have to do ?

Anyone got an example file how I would add three simply attributes to a product?

I know that I can just export the EP attributes file but there are way too many attributes in there and I just want to add three.

Maybe I am wrong but if I want to add three attributes shouldn't that just be 6 columns ? The ID and the name ..

once everything is in there where do I go from there? everything is uploaded , imported and all and that's it - there's no interface to connect anything.

where do I go from there
If the upload shows no errors, your should see all your products in admin and the live site.

Hello all, quick question, can anyone tell me where when I Split EP Files, where does that save to ??? I thought it would save to my Temp file , but its not there?? :blink:

Thanks 4 any help...

I also had a few EP questions. I have it installed and working and was wondering if there was a way that anyone new that would allow me to upload the UPC. I already downloaded the module that allows me to add UPC/ISBN individually. This would be a great help to me in listing DVD's.

Would adding in v_products_UPC in my upload work? Or is this something that I would need to pay for teh advanced version to make work?

Thanks in advance!

jgg1974:

Hello all, quick question, can anyone tell me where when I Split EP Files, where does that save to ??? I thought it would save to my Temp file , but its not there?? :blink:

Thanks 4 any help...

Guess SUndays are kinda qiet in here.. :lamo:

jgg1974:

Hello all, quick question, can anyone tell me where when I Split EP Files, where does that save to ??? I thought it would save to my Temp file , but its not there?? :blink:

Thanks 4 any help...

I have not used the split feature much, but if you have not changed the code, the files should be in your temp folder. I believe it might change the file name.

Make sure you are looking at the right temp folder. It should be at the same top level as admin & includes.

jlosee:

I also had a few EP questions. I have it installed and working and was wondering if there was a way that anyone new that would allow me to upload the UPC. I already downloaded the module that allows me to add UPC/ISBN individually. This would be a great help to me in listing DVD's.

Would adding in v_products_UPC in my upload work? Or is this something that I would need to pay for teh advanced version to make work?

Thanks in advance!
From what I've read, the advanced version does not have extra fields (but I could easily be wrong here).

You started right with adding the column (probably best to use all lower case though). You need to find the INSERT and UPDATE sections starting around line 1650 and add the new field definitions.

Jeff G:

I have not used the split feature much, but if you have not changed the code, the files should be in your temp folder. I believe it might change the file name.

Make sure you are looking at the right temp folder. It should be at the same top level as admin & includes.

Jeff is correct-- Image of Temp Directory in the root folder of your store.

I uploaded by txt file. It shows it as it went thru fine - it does show up in my temp file. However, it does not show up in the catalog. What step am i missing?

ella33:

I uploaded by txt file. It shows it as it went thru fine - it does show up in my temp file. However, it does not show up in the catalog. What step am i missing?
Uploads to Easy Populate should not be in txt format..
need to be converted first to tab delimited .csv by i.e
Open Office program.

heavenlynights:

Product shows up in admin however, if I try to edit it by clicking on admin>categories> product edit symbol or clicking on the product name, it takes me to google.com.au (very weird) same thing applies, if I click on all other symbols except for attribute and image handler symbols.

In regard to the actual store front, I can see the product in the product listing http://www.heavenlynightslingerie.com.au/index.php?main_page=advanced_search_result&search_in_description=1&keyword=7786 but when you click on the product it takes you to the page not found where the sitemap is showing.

So! not sure what to make of all of this, especially the google thing :wacko:

Any help would be much appreciated

TIA

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

heavenlynights:

One other thing, in the admin >tools>easy populate page there appears to be indicate that there are 5 partially deleted products somewhere in the database.. i click on the link to delete them, but it fails every single time.

TIA

Hi again. ok I am just trying to work out how to fix above quoted problem.

I have looked at the ep_debug_log to establish what went wrong and below are the 5 files/products that i cannot delete.

Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
326:f4f3fa30b5e879c74e5fd6ae0609f81e
612:5ef342d2d56e0dbf6183a95d959ee3d4
353:745fb41191f898509f15959a3df40815
611:fd62356a05335753c6aa2951e4351e86
640:3ea24ff30ee1b11931289aa335e2ff83
It is recommended that you delete this corrupted data using phpMyAdmin.

I have looked in the phpmyadmin and cannot find any reference to these products within the products table. Where else in phpmyadmin, should I look?

TIA for any help on this

heavenlynights:

Hi again. ok I am just trying to work out how to fix above quoted problem.

I have looked at the ep_debug_log to establish what went wrong and below are the 5 files/products that i cannot delete.

I have looked in the phpmyadmin and cannot find any reference to these products within the products table. Where else in phpmyadmin, should I look?

TIA for any help on this

I had the same quirk and had to access the db to remove the snips of data. My incident was due to deleting my test user without emptying his cart beforehand. It might also happen if a product is deleted in admin after being selected by a user, so I would check anything and everything that has to do with a users shopping cart. Good luck!

I am uploading my inventory right now to Easy Populate, but it does not show the attributes at all. Do I have to upload those in a different text file? Is there anyone to upload everything at once? Also, with images what do you use to upload all of your inventory images at once?

I installed Easy Populate and can't get it to work.

It installed perfectly. I went to Tools-->Easy Populate and chose 'Create complete Tab-Delimited text file in temp dir'

I opened the file in Open Office and only Two Categories and Sub Categories show up out of 5 categories/sub-categories I manually put in in Zencart.

I also tested trying to add a new category/sub-category/product...but NOTHING shows up in my Zencart site.

awhfy99:

I had the same quirk and had to access the db to remove the snips of data. My incident was due to deleting my test user without emptying his cart beforehand. It might also happen if a product is deleted in admin after being selected by a user, so I would check anything and everything that has to do with a users shopping cart. Good luck!

Thanks for that. Done a quick search in database and found all problem files. deleted them. problem solved :clap:

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

Are you uploading the file to import to the temp directory and importing from there? If so I'd think you'd be OK.