Easy Populate 1.2.5.4 support

[macnerd]

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

[macnerd]

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?

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

[macnerd]

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?

[coln2016]

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?

[ejunk]

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

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

[schoolboy]

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

[MeltDown]

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!

[schoolboy]

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