EasyPopulate 4.0 Support Thread

**chadderuski** · 3 Mar 2013, 04:47 PM

Originally Posted by jodean

I am using Zen 1.5.1 and installed Easy Populate 4.0 v1.2.5.7. When I click on the Easy Populate under the tools menu I get the following error.

1 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.

When i click on clicking here i get the error below

Deleting of product data debris failed! Please see the debug log in your uploads directory for further information.

I get the error regardless of using empty files or after i add a product.

Does anyone have any idea for fixing the error?

You have the wrong version (it's not EP 4.0) ... this thread is for my version currently only on github:

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

-chadd

**CCMall** · 4 Mar 2013, 07:43 AM

This is an awesome contribution bro. Awesome work. Question though....

First I am creating a site and my suppliers are all drop shippers. All the cvs/xls files I'm getting are different, ie names, descriptions, ext ext. I am an amature coder, I created a PHP (page really) that takes the file and edits the fields to create the columns I want. For example the one suppliers cvs file had 4 columns that I needed into 1. Only one column had <HTML> tags so I had to move the data where I wanted it with in the Description and add the <HTML> tags I wanted, lastly save the file as a CVS.

I downloaded the complete products list from my site using Easy Populate. Deleted all the data. Then C&P'ed all the data into the respective fields. Uplaoded it. (after a little messing around) it worked great.

My question for you is: My next step will be to have my custom PHP page create the appropriate cvs file that will upload into Easy Populate in order to update or add new products. What are the fileds I need for sure? Ones I leave out will they get the default value in the database??

Thanks

**Kevin205** · 4 Mar 2013, 11:40 PM

Trying to import Attributes via the Basic Products Attributes (basic single-line).
Started with:

Click image for larger version.

Name: Started.jpg
Views: 72
Size: 21.1 KB
ID: 12053

Revised and added the following record to the excel sheet
v_products_model
50165
v_products_options_type
5
v_products_options_name_1
Color
v_products_options_values_name_1 Pink

Click image for larger version.

Name: Revised.jpg
Views: 90
Size: 20.9 KB
ID: 12054

When I imported the csv file, not only Color Pink was not attached to Product Model 50165, color Pink was not added as an "Option Values".

What did I do wrong? How else would you add the attributes via EP4?

**Kevin205** · 4 Mar 2013, 11:52 PM

And also following is the result from the upload.

Import Results
.
.
.
UPDATED! - Model: 50165 | 5 | Color | Pink |
.
.
.
Finished processing the the import file
Updated records: 13
New Imported records: 0
Errors Detected: 0
Warnings Detected:0
.
.
.

**Kevin205** · 5 Mar 2013, 12:31 AM

I think I found out where the problem started from.

After reading the "attribute_types.txt" in the mod, I realized I had changed the name of the csv file to "test.csv".
In the read me, it is stated that Basic Attribute Import file name must begin with "Attrib-Basic-EP" plus any other text you want

As soon as I changed the file name it updated the attribute.
NEW ATTRIBUTE! - Model: 50165, Option: Color, Values: Pink

Questions:

Was this the only thing I did wrong?

Does this rule apply to all other imports for EP4?

**chadderuski** · 5 Mar 2013, 05:59 PM

Kevin: You should be on the right track now. Some imports have file naming conventions because they act as switches to what the import script does.

This applies to category, attribute and pricing sheets. I have not yet put a restriction on the full sheet, but that may come...

**Kevin205** · 6 Mar 2013, 03:13 PM

Thank you for all you are doing.

How hard is it to add yet another field such as UPC/ISBN, to the scheme of import and export of products in EP4?

A lot companies are using UPC along with their model number.

**Kevin205** · 6 Mar 2013, 03:15 PM

Thank you for all you are doing.

How hard is it to add yet another field such as UPC/ISBN Product Fields to the scheme of import and export of products in EP4?

A lot of companies are using UPC along with their model number.

Thread: EasyPopulate 4.0 Support Thread

Thread Tools

Search Thread

Display

Hybrid View

Re: EasyPopulate 4.0 Support Thread

Re: EasyPopulate 4.0 Support Thread

Re: EasyPopulate 4.0 Support Thread

Re: EasyPopulate 4.0 Support Thread

Re: EasyPopulate 4.0 Support Thread

Re: EasyPopulate 4.0 Support Thread

Re: EasyPopulate 4.0 Support Thread

Re: EasyPopulate 4.0 Support Thread

Similar Threads

Hebrew Support - latest release [Support Thread]

BackUp ZC [Support Thread]

Wordpress On ZC [Support Thread]

ZJ Black 2 support thread

Posting Permissions