Easy Populate 1.2.5.4 support

Does anyone know how I can add the size to a product (clothing business) and then add it to the export file of Easy Populate ?

My distributors will give me periodic .csv files to upload for stock updating and I need to give them in the exported file the : model or product name, size (s,m,l,xl), price and quantity. When they give me back the .csv, products that are 0 qty should be made inactive.

I'd really appreciate the help.

Thanks in advance.

ejunk:

Does anyone know how I can add the size to a product (clothing business) and then add it to the export file of Easy Populate ?

My distributors will give me periodic .csv files to upload for stock updating and I need to give them in the exported file the : model or product name, size (s,m,l,xl), price and quantity. When they give me back the .csv, products that are 0 qty should be made inactive.

I'd really appreciate the help.

Thanks in advance.

you need to first create the attribute ("Size") in (Tools->Option Name Manager), then create the values under Option Values Manager (ie., a field for S, another filed for M, another for L, another for XL, etc)...

Then you can export the template from easy pop (export the model/attributes template), then fill it.

For pricing and visibility, you have to have a number to have it view...(eg,. S & M are the same price, but L is +$5, and XL is +$7) then you put 0's in the S & M fields, and "5" and "7" in the respective fields..

I use this a bit, with somewhat mixed results...

My experience:

1. you can't change the Attribute NAME or the Value Name from record to record....

• • (the "Size" Attribute can NEVER be used as say "style" on another record, and you can't name "XL" as "really big" on a differnt record) -- - -there is something in te way the database pulls it, that titles in attribute names and value names will 'burp" if changed much.....

If there is a work-around on this, i'd love to know it.. my sites have hourly uploads, and with the qty of attribs i run, it takes quite a while....

2. I think there might be a problem with Easy Pop in terms of max # of attributes... I don't know this, and would love to know the answer myself..(see my post above as explanation). I'm running 12 attribute Names, with anywhere from 5 - 36 attribute values for each attribute name... and it seems to be causing some sort of issue.....

Anybody else still viewing this thread? Looking for answers on the Attrib issue...

Also, is there a good way to dual-post the same model product into multiple categories (simultaneously) with either version of EP?

If i've got say a widget that can sell in both "Red Widgets"and in "Round Widgets", how can I put it in the file so it'll automatically populate to both categories?

When using ez pop you can add in multiple identical lines by taking the original and duplicating then altering the category columns accordingly. Then upload.

For example if product 1722 needs to be in cat a & b you will have two line items with the only thing altered being the category and likely your metas if you use them.

JimmyV:

When using ez pop you can add in multiple identical lines by taking the original and duplicating then altering the category columns accordingly. Then upload.

For example if product 1722 needs to be in cat a & b you will have two line items with the only thing altered being the category and likely your metas if you use them.

thx..

I'm familiar with this.. was hoping there is a way to encapsulate that info in a single record entry, as it makes communication with a database significantly less complex.

Anybody have experience in dealing with the Attributes issues I laid out above?

HI,
who can I help me ?
when I import easy populate of install_sql.txt ,the sql prompt:

SQL check:

INSERT INTO configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'tempEP/', 'Name of directory for your uploads (default: tempEP/).', '31', '0', NULL, now(), NULL, NULL), ('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', '31', '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'), ('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', '31', '2', NULL, now(), NULL, NULL), ('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large up[...]

MySQL reruren:
#1062 - Duplicate entry '0' for key 1

what can I do?

Does the mod actually removes the product attributes if I remove a size value from the CSV file ?

I watched some video tutorials on how to install easy populate and how it works. It seems to me that the CSV creates its own categories within your shopping cart. Is there a way to prevent that? Or would I have to, after uploading the CSV file containing hundreds of items, individually move those items to the category I want. Because I have my own category structure and I am afraid that uploading the CSV files and it making its own categories will mess things up.

alucard13mm:

I watched some video tutorials on how to install easy populate and how it works. It seems to me that the CSV creates its own categories within your shopping cart. Is there a way to prevent that? Or would I have to, after uploading the CSV file containing hundreds of items, individually move those items to the category I want. Because I have my own category structure and I am afraid that uploading the CSV files and it making its own categories will mess things up.

EP will not create new categories UNLESS the new products in the CSV also describe a NEW category.

If (in the CATEGORIES column) you insert the name of EXISTING categories, then EP will just write the new products' data, and the new products will appear in EXISTING categories.

Try an EP upload with just ONE NEW PRODUCT. Make sure you show an EXISTING category name. Then take a look at the result.

Remember... The category name must EXACTLY match the category name in the database. There is a difference between Mens Shoes and Men's Shoes and mens shoes and men's shoes. Letter case MUST be the same - spelling must be the same.

ALSO... you have posted your question in the EP 1.2.5.4 thread. This version does NOT use CSV but TAB DELIMITED....

Zen Version: 1.5.1 / Easy Populate For ZenCart v1.5.x

I hate to bring this up again, as others have done so previously, but I just can't resolve this issue; Whenever I attempt to insert the file into the database via my Zen admin, I receive the following error:

No model field in record. This line was not imported

However, I DO have the model field in place (v_products_model) as well as EOREOR to close the record. The temp folder is also set to 777.

I have downloaded the record from another Zen Cart, version 1.3.8a, in an attempt to transfer the data to my updated zen cart. Can anyone give me a clue as to why I am unable to successfully make this transfer?

Thanks!

Do you have Chad's version of EP on your 1.5 site? EP1.2.5.4 does not work on ZC 1.5

Hmmm... OK, it looks like I have the wrong version installed (easy_populate_csv_for_zencart_v1.5.x_v1.2.5.7c). However, I'm not seeing an uninstall SQL. Any thoughts on how to best uninstall this version?

And is Chad's "EasyPopulate-4.0-master" the version to install?

Thanks

In configuration/Easypopulate...

I have no settings to change, just the column header of Title/Value/Action.

ZC1.5.1
The VERY latest EZP version for 1.5.1

Server OS: Linux 2.6.32-279.14.1.el6.x86_64 Database: MySQL 5.0.96-log
Server Date: 01/04/2013 03:11:26 Database Date: 01/04/2013 03:11:26
Server Up Time: 03:11:26 up 8 days, 3:31, 0 users, load average: 3.10, 2.60, 2.51 HTTP Server: Apache
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 64M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 32M POST Max Size: 33M
Database Data Size: 2,413 kB Database Index Size: 2,273 kB

Ok, I have spent several days trying to figure this out and and am at loss

I had easy populate working perfectly for my zc 1.3.8, never a problem. I now have zc 1.5.0 and uploaded easy populate v. 1.2.5.7b and having nothing but problems:

My 3 issues:

When uploading my open office .csv file I am getting "**No model field in record. This line was not imported"**even though I do indeed have data in the model field

The second problem is I do not have anything in the admin > configuration tab for Easy Populate.

Also getting this: **40 partially deleted product(s) found! Delete this dross to prevent unwanted zencart behaviour by clicking here. ** When I try it does not work, the error log says I need to go into phpmyadmin and manually remove data but I can not figure out how.

I’m at a loss, this worked perfectly for me when I had 1.3.8. Please advise, I have a ton of webwork to do and can't get started.

Only EP 4 will work with ZC 1.5.x

Good news is that the new EP will not "interfere" with the old EP version. (Which you should just remove from ZC 1.5 - follow the uninstall procedure).

As far as removing the "dross" is concerned, this will need to be done in phpMyAdmin - BUT... you should not go tinkering around in the database unless you know what's going on there. If you do not know how to access phpMyAdmin, it follows that you do not know what it is or how to work with it.

As I said, it IS possible to get rid of this "dross" via phpMyAdmin (I do it occasionally) but it is not doing any real harm, and as there is a risk that your tinkering may actually do some real harm, I recommend you leave it alone for now.

OK, I've successfully removed the incorrect version of EP and installed EP 4. All looks to be in order but I am still receiving a "No model field in record. This line was not imported" even though they are in place (v_products_model).

I'm downloading a database, using EP, from a Zen Cart version 1.3.8a so that I may then upload this information to my new Zen Cart. Could that be creating the issue?

there is a difference in how the csv files are built, by the different EP versions. Best thing to do is to make a download using the different versions and compare them
you can then edit the csv file downloaded from ZC 1.38 to comply with the EP4 column headings

MeltDown:

OK, I've successfully removed the incorrect version of EP and installed EP 4. All looks to be in order but I am still receiving a "No model field in record. This line was not imported" even though they are in place (v_products_model).

I'm downloading a database, using EP, from a Zen Cart version 1.3.8a so that I may then upload this information to my new Zen Cart. Could that be creating the issue?

Notice that EP 4 has several differences from EP 1.2.5.4

Firstly, it is CSV (not TAB DELIMITED) so you must follow CSV protocols (comma separated, text enclosed in double quotes... this endures that if you have commas in product description text, for example, these commas will not be seen as field delimiters.)

Secondly, it no longer uses EOFEOF as a line ender.

Thirdly, it uses a CARET SYMBOL to separate CATEGORIES and SUB-CATEGORIES. EG: Main Category^Sub Category^Sub-Sub Category ... whereas EP 1.3.5.4 used separate COLUMNS for each cat and sub-cat.

Load up a product in the conventional way, then do a DUMP of your database using EP. Then look at the resultant spreadsheet...

PS... EP4 has its own support thread so please go there for advice... This thread should be exclusively for 1.2.5.4 and as we have dealt with your issue, no point in talking more about EP4 on this thread.

Just installed Easypopulate V1.5x with zencart V1.51. Just try to add few new items for testing.
My step is 1. download the updated data FullEP2012xxxx.txt and open it with excel. 2. Download complete .csv and add new item following the FullEP2012xxx.txt format. 3. Upload the new items via ftp. 4. Insert the new item .csv to db. I got the following error:
"ADD NEW PRODUCT FAILED! - Model: #MM2013-01 - SQL error. Check Easy Populate error log in uploads directory"

Can anyone help me here? I appreciated for your help.

I installed the latest version of E P, the link is in the drop down in tools, but not under the drop down list under configuration. I have reinstalled it a couple of times, but still the same. I can't find a thread on this. Ant help would be appreciated.