Easy Populate 1.2.5.4 support

ckosloff:

Hi,
My first post in this thread so please go easy.
ZC v. 1.3.8a, EP v.1.2.5.5, just installed on my test site.
Just imported the online site into my test site.
Tools -> EP says:
5 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here.
You are seeing this because there are references in tables to a product that no longer exists, which is usually caused by an incomplete product deletion. This can cause Zen Cart to misbehave in certain circumstances.

Upon clicking I get this:
Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

Then the log says this:
Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
110:6e5c303399d5f09249685463bae53bd4
114:5d9acb39caff4904d944963fc99a1e77
15:2a57da28bab4f4e8bd8023e3f1b2f7c3
13:e492a6585d4834baf3b27ebb49299df4
109:7f9a284d9ed0620f95c07b62b69a302d
It is recommended that you delete this corrupted data using phpMyAdmin.

The problem is: how do I delete corrupt data using phpMyAdmin?
Thanks.

1. Open up your cpanel in your host,
2. open up the phpmyadmin,
3. open up the zen database files,
4. scroll down to the products table, (click to open,
5. find those products, check the left box of those items,
6. towards the bottom, hit the delete link.

elkbow:

1. Open up your cpanel in your host
   Thanks for answer.
   None of these products show in the product table.
   So how delete debris?

ckosloff:

Thanks for answer.
None of these products show in the product table.
So how delete debris?

If a user had a pending cart with those products and if either the products or the user was deleted before the cart was emptied, then that can happen.

ckosloff:

Thanks for answer.
None of these products show in the product table.
So how delete debris?

Ok,
Next test:

Beyond the products table there are about 14 more tables refering to products.

Did you check each of them?

By the way, did youclick the Browse at the top of the structure to see the products??

1.3.8a
1.2.5.4
Dennis (awhfy99)

Have any idea how to add sort order for products to 1.2.5.4??

John

Hi

I am looking at the free easy populate v1.2.5.5

It says its for Zen cart version v1.3.6?? So it wont work with Zen cart Version 1.3.8a?

How does this compare with the Advanced easy populate someone is plugging on here.... zencartbuilder.com???

As an alternative I am looking at http://www.magneticone.com/ Store Manager.

What I want to do is to take a huge list of products from my supplier.. and import that into Zen cart, then I want to export it out of Zen cart back into spread sheet with all the direct links to the products in the (which zen cart should put in?)... I can then submit that list to google base (plus a few extra columns etc). Will it keep everything in order so the columns in my initial sheet (which are formatted for google base) will come back out in the same way.

Many Thanks!

elkbow:

Ok,
Next test:
Actually, clicking on the table in the left pane or clicking on the Browse button will yield same results.
I went through the tables, it's not that tough.
Select table, click Search and you get all the search parameters for that table.
Then, for example, products_id = 110.
But, no luck, found 0 for the products EP mentions.

elkbow:

1.3.8a
1.2.5.4
Dennis (awhfy99)

Have any idea how to add sort order for products to 1.2.5.4??

John

No, but the osCommerce version does have that option. It's not perfect but the ability to pick and choose which cats to download and whch headers to include makes it work for me. Try it on a test installation to see if it may be what you need.

ckosloff:

Actually, clicking on the table in the left pane or clicking on the Browse button will yield same results.
I went through the tables, it's not that tough.
Select table, click Search and you get all the search parameters for that table.
Then, for example, products_id = 110.
But, no luck, found 0 for the products EP mentions.

Try looking in the customers_basket for those products.

awhfy99:

Try looking in the customers_basket for those products.
Products were there all right.
Deleted all 5.
But...EP still throws the same error!

ckosloff:

Products were there all right.
Deleted all 5.
But...EP still throws the same error!
Ignore this post.
I got the procedure:
Select whole database
Click Search.
Select all tables.
Copy and paste the "debris" information.
Click go and delete all instances found.
EP is clean and happy now.

Next question:
Is there a tutorial where I can learn how to use EP?

ckosloff:

Next question:
Is there a tutorial where I can learn how to use EP?

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

There is also a thread on how to modify EP to add your own fields:

http://www.zen-cart.com/forum/showthread.php?t=116061

-cj

Thanks for a great module...

Can I add pics with Easy Populate?

SIMS-SA:

Thanks for a great module...

Can I add pics with Easy Populate?

The first one can be assigned with ep. All will need to be uploaded via a ftp program.

ie. if
Image 1= mypic.jpg
then
Image 2= mypic_2.jpg
Image 3= mypic_3.jpg

etc.

awhfy99:

The first one can be assigned with ep. All will need to be uploaded via a ftp program.
I have not started yet with EP, trying to understand it for the moment, so this post could be off-mark.
From what you describe I think Image Handler does all that for you and is less error-prone.
You navigate to the product and assign it a main image simply by browsing in your computer (or network) to the one you want.
Same procedure for additional images, IH uploads them to the images folder, renames them, etc. No need to FTP, just point and click.

ckosloff:

I have not started yet with EP, trying to understand it for the moment, so this post could be off-mark.
From what you describe I think Image Handler does all that for you and is less error-prone.
You navigate to the product and assign it a main image simply by browsing in your computer (or network) to the one you want.
Same procedure for additional images, IH uploads them to the images folder, renames them, etc. No need to FTP, just point and click.

That is true, the IH does do all of those things but if you are uploading en-mass, then why take the time to assign multiple images one at a time? Kind of defeats the purpose of EP, don't you think? The quickest way is to rename your images (ie. 1.gif, 1_1.gif, 1_2.gif, 1_3.gif, etc., and ftp them and let zencart handle the multiple image assignments for you.

The important thing to remember is that EP does NOT "upload" images...

The data you put into v_products_image column is simply a REFERENCE to the location and name of the primary image, and this data (reference) is stored in the database.

The actual image FILE (jpg, png, gif) is stored in the images folder (and/or a relevant sub-directory) and the best way to port the image files to your server is to use FTP.

ADDITIONAL images for any given product:-

(Main image = image.jpg)

• image_01.jpg
• image_02.jpg
• image_03.jpg

Are ALSO loaded via FTP, and their presence is then automatically recognised by ZC via ZC's "additional images" functionality.

I've used Easy Populate to update and to add products to my site. However, even though the upload and import to database were successful no products were added or updated.

I have over a thousand products to add and this would be a life saver. Here is what I have:

Zen Cart - 1.3.8a
Easy Populate 1.2.5.5 CSV
PHP - 5.2.9
MySQL - 5.1.30

I've attached a test file. Any help is appreciated.

samgdaniel: Did you have a product already in Zen Cart before you did a EP import?
As with EP 1.2.5.4 if you had no products in the DB and no category/ies and you imported with EP your products would not show, but if you have a one category and one product in ZC - EP would import and show!