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
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?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.
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.
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. 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.
Bookmarks