EasyPopulate 4.0 Support Thread

I have been with ZC since 2002 and appreciate the efforts of those that diligently support the community. I spent 2 hours reading the entire support thread yesterday before I even asked my question to find a solution. For those that have an established store with products that have been indexed by search engines and have back links, it would be devastating to simply replace the existing products. In my case it is imperative that the product id number stay the same to support backlinks.

Thank you for the great support and taking time from paid projects to bring a valuable service.

I realized you asked about how the file was opening.... here is the text version of the file with the first product
v_products_model,v_products_type,v_products_image,v_products_name_1,v_products_d escription_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_ expires_date,v_products_price,v_products_id,v_products_weight,v_product_is_call, v_products_sort_order,v_products_quantity_order_min,v_products_quantity_order_un its,v_products_priced_by_attribute,v_product_is_always_free_shipping,v_date_avai l,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_ta x_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v _metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v _metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
MG SIGNS,1,buttons/magneticvehiclesigns.jpg,Magnetic Signs,"<table width=""600"" bgcolor=""#e1f0ff"" align=""center""> <tbody><tr> <td valign=""top"" bordercolor=""#333333""><div> <div> <div align=""center""><strong>Magnetic Vehicle Signs</strong><br /> Printed FULL COLOR &amp; full bleed directly on a 30mil low shine magnetic material.</div> </div> </div></td> </tr> </tbody></table>",,,,,0,12,0,0,0,1,1,1,0,,5/2/04 3:30,0,,Magnetics^Magnetic Signs,Taxable Goods,0,0,0,0,0,0,,,

The date looks a little odd, but it may work/go through. I try to make sure it is in the format of YYYY-MM-DD (using all numbers).

Quote:

---

Originally Posted by mc12345678

Found and fixed the issue(s) with updating while not using products_model as the primary key. Haven't uploaded the fix quite yet, but will be up soon. Want to also check some of the changes made to the featured products area to address some previously pointed out issues.

Not yet sure about the 0 products updated issue... please check for any log errors in the logs directory...

---

Uploaded the change(s) for this as well as a few of the other 4.0.35 items to github: https://github.com/mc12345678/EasyPopulate-4.0 in the master thread... Still working on the featured import changes.

FANTASTIC! It's working. Very thankful for the timely and efficient work on this mod. Thank you mc12345678

Quite welcome.

For everyone, submitted version 4.0.35.ZC for review and eventual posting to the ZC plugins available from here.

The use of the added ZC to the version was because on github the version had been updated to 4.0.35 and wanted to be sure that those that had installed it would be notified of the available version on ZC.

Significant changes made are that the featured import now assigns a value that ZC recognizes as a blank field if the in import of the file the available and/or expiry fields are blank, 0 or 0000-00-00.
Somehow in recent updates the ability to import by products_id was disabled by lack of code to support it. All my doing, but that functionality is restored as expected and desired above.
The code has been updated to operate without further modification if a site does not have the applicable mb_ (multibyte) functions activated.
There are other changes which are documented in the changelog of the download and can be pre-reviewed on github or upon posting of the plugin to the ZC site.

In other "news" (although this message may not be seen by all because of the time since my last post), I wanted to let others know about some upcoming planned changes/expansion to EP4.

Currently the operations of EP4 are centrally controlled by the admin file easypopulate_4.php and as applicable other actions are taken during execution of that file (import, export, etc.). Those other actions are addressed in additional external files. (ie. Import is admin/easypopulate_4_import.php). As a result of these external operations but the "central processor" being an admin file, I'd like to make the operations of EP4 available to other outside code while maintaining appropriate security to prevent non-ZC code from activating the operations. This does afterall manipulate the content of the store's database.

So, the first step in this will be to pull out code that directly supports the internal operations into sensible files that could be referenced by some other non-EP4 program in such a way that it would be poised to continue operation through reference of one or more of the other external files.

The next thing, which I'm contemplating both the operation of and potential impact on the store is taking that EP4 data and/or operation structure to a class such that a variable such as $ep4 could be used/referenced from within the admin and the applicable action could take place. So something like $ep4->import($filename) would activate the import of the file. This particular modification, the extent of which remains to be determined may affect others that piggy-back on EP4 and require some code changes to work with the data structure of that new class. Don't worry, this won't be overnight (for those with concerns) and sorry this won't be overnight (for those really wanting that functionality. :) ) There are also some things to consider like in the above example of using the import function to pull in a file, what's to say that the code couldn't be adapted to pull in a variable or some other source? Sure EP4 has been successful at working with and manipulating csv files, but what's to say it couldn't be expanded to work with more in the same controlled method to minimize bloat, processing time, and memory usage.

Anyways, just some thoughts for EP4 in addition to some of the other minification that is planned say for the import operation to pull the contents of specific file processing into its own file thus easing modifications and specialization as well as program readability.

Thoughts/discussion welcome. I'll be opening an issue for each of these on github.

Quote:

---

Originally Posted by mc12345678

Quite welcome.

For everyone, submitted version 4.0.35.ZC for review and eventual posting to the ZC plugins available from here.

The use of the added ZC to the version was because on github the version had been updated to 4.0.35 and wanted to be sure that those that had installed it would be notified of the available version on ZC.

Significant changes made are that the featured import now assigns a value that ZC recognizes as a blank field if the in import of the file the available and/or expiry fields are blank, 0 or 0000-00-00.
Somehow in recent updates the ability to import by products_id was disabled by lack of code to support it. All my doing, but that functionality is restored as expected and desired above.
The code has been updated to operate without further modification if a site does not have the applicable mb_ (multibyte) functions activated.
There are other changes which are documented in the changelog of the download and can be pre-reviewed on github or upon posting of the plugin to the ZC site.

---

Version 4.0.35.ZC is available for download. Notification should be available for those that have previously upgraded to 4.0.34 or newer.

Additional "correction" included sanitization of attribute data that is imported through easypopulate_4_attrib.php.

I updated to the version in the link, and still get the update notification:
Easy Populate 4.0.35.ZC - 04-29-2016 - NOTE: A NEW VERSION OF THIS PLUGIN IS AVAILABLE. [Details]

Quote:

---

Originally Posted by henry3

I updated to the version in the link, and still get the update notification:
Easy Populate 4.0.35.ZC - 04-29-2016 - NOTE: A NEW VERSION OF THIS PLUGIN IS AVAILABLE. [Details]

---

Yes it would because on my latest upload I identified it as v4.0.35.ZC on the ZC website but instead in the file as 4.0.35.ZC. I have submitted a request to the ZC team to modify the version response information to report back the coded 4.0.35.ZC. When that has been performed the notification of a newer version should cease to occur until a newer version is again posted.

Thank you for pointing that out.

Quote:

---

Originally Posted by henry3

I updated to the version in the link, and still get the update notification:
Easy Populate 4.0.35.ZC - 04-29-2016 - NOTE: A NEW VERSION OF THIS PLUGIN IS AVAILABLE. [Details]

---

Quote:

---

Originally Posted by mc12345678

Yes it would because on my latest upload I identified it as v4.0.35.ZC on the ZC website but instead in the file as 4.0.35.ZC. I have submitted a request to the ZC team to modify the version response information to report back the coded 4.0.35.ZC. When that has been performed the notification of a newer version should cease to occur until a newer version is again posted.

Thank you for pointing that out.

---

Fixed .

Quote:

---

Originally Posted by DrByte

Fixed .

---

Thank you!!!!

Now for anyone wondering how that happened? Moments before submitting the version to ZC I had created a version tag in github. In github they recommend the use of the v as a prefix... so, that was fresh in my mind and "seemed" correct when entering the version info to submit for ZC. The impact was not fully recognized. Immediate problem solved though.

I have a little problem. I have updated my plugin but the problem is still there. Products are disappearing.

I have a clean v155 installed. I did a backup of my shop, then imported that file in to the clean install and the products that are 'off' in my shop do not appear in the clean install. I have had a look at CSV and the product that is off is not in the database. So I think it is not being downloaded.

Quote:

---

Originally Posted by adb34

I have a little problem. I have updated my plugin but the problem is still there. Products are disappearing.

I have a clean v155 installed. I did a backup of my shop, then imported that file in to the clean install and the products that are 'off' in my shop do not appear in the clean install. I have had a look at CSV and the product that is off is not in the database. So I think it is not being downloaded.

---

And of course I'm a little confused, but sure we can figure it out.

Clean ZC 1.5.5 installed, check.
Backup of a previous shop made... Is this an export using EP4 or one of the approved/recommended processes for backing up a database in support of say an upgrade?
The export or at least an export using EP4 of the "previous shop" (filename up to and including ep?) does appear to include the "disabled", out-of-stock, red-buttoned product, but the status is shown as 0 or disabled, correct?
Upload and then import of the EP4 file (filename at least up to and including ep?) is only populating product with status of 1 or on.
Part that also is confusing is the last statement, that think it is not being downloaded... Download is the direction of the information coming from the website to your "personal" computer. If the information is in the CSV file then it has been downloaded. If after upload and import the information in that CSV is not making it to the website, then that "could" be an issue with the upload (doubt it) but more than likely something with the import of deactivated product. Not necessarily a terrible thing because import of enabled product works, but certainly not as intended, expected, or desired. Regardless a little confused about which site shows what and what is in what file with any/all not clearly identified as what is missing where.

So, help me with the above and clarify/explain what you can and we'll get through it. :)

Quote:

---

Originally Posted by mc12345678

And of course I'm a little confused, but sure we can figure it out.

Clean ZC 1.5.5 installed, check......

---

I think this is what you are after:

• Using the current shop;
• Using Easy Populate 4.0.35.zc -04-29-2016 for export of the file.
• Filterable Exports; download type selected ‘Complete Products’ (I have also done an export without changing any of the preferences) clicked Export.
• From the table and under title ‘This contains any other file. They will be processed like the upload of a full data file’ download the file using the ‘Download’ button.
• File name exported/Imported: Full-EP2016May05-160538.csv
• Clean install;
• Used EP4’s (same version as above) ‘upload EP File’ to upload and then imported.

Yup, certainly helps.

Now though. Does Full-EP2016May05-160538.csv contain the disabled product of the current store?

Quote:

---

Originally Posted by mc12345678

Yup, certainly helps.

Now though. Does Full-EP2016May05-160538.csv contain the disabled product of the current store?

---

No disabled products can be found in Full-EP2016May05-160538.csv

Quote:

---

Originally Posted by adb34

No disabled products can be found in Full-EP2016May05-160538.csv

---

Okay. I'm taking a look now through the code to see why export using the dropdowns when not selecting a specific option under the status column only provides active product. In the mean time, can envision either of two options working. Change the status dropdown to all and/or use the clickable link that is down below that row of dropdowns.

Okay, looks like the "default" setting (making no changes to the status of product to export) is to export only active product. This can be seen at:
https://github.com/mc12345678/EasyPo...ate_4.php#L480 and related code starting at: https://github.com/mc12345678/EasyPo...export.php#L78

Fyi, next version will include an additional link in the upper right near the remove EP4 statement, this will be an update sql related link so that when changes are made to the install script, the process will be improved to insert ignore all of the settings and therefore the new items will be added while the existing will remain the same. As part of that script change the sort order will be addressed separately so sequencing may change slightly/new items inserted where seen "reasonable". This option will be provided based on some evaluated factors so as to only be shown "when necessary". This will of course depend on updates properly including a "flag" that will need to be changed by the submitter of the code to ZC.

OK, so here I go for another lambasting for being the thickest user.

I've uploaded EP4 and renamed the admin to match store name but not sure I have put it in the right place, when it says upload to admin I presumed that meant the zenadmin | all uploaded in its own directory EasyPopulate-4.0-master

is this the right path to use

Quote:

---

Originally Posted by Haggis

OK, so here I go for another lambasting for being the thickest user.

I've uploaded EP4 and renamed the admin to match store name but not sure I have put it in the right place, when it says upload to admin I presumed that meant the zenadmin | all uploaded in its own directory EasyPopulate-4.0-master

is this the right path to use

---

No.

Almost all plugins (actually "all" as long as they're written consistently) have a set of directories that correspond to the existing directories in your Zen Cart site.

So the easy-populate40-master/admin folder contains the files that you would add to your /admin (or renamed admin) directory.
And likewise most of the easypopulate40-master/whatever files and folders would go in your / (main, no subdirectory) directory.

Quote:

---

Originally Posted by Haggis

OK, so here I go for another lambasting for being the thickest user.

I've uploaded EP4 and renamed the admin to match store name but not sure I have put it in the right place, when it says upload to admin I presumed that meant the zenadmin | all uploaded in its own directory EasyPopulate-4.0-master

is this the right path to use

---

Two other ways to look at it is:
1) the files easypopulate_4.php, easypopulate_4_import.php, easypopulate_4_export.php etc. Are in the same admin directory as files like orders.php, option_names.php, attributes_controller.php, etc.... from that location, the other folders should already exist.

The second way to view it is that the files to operate EP4 are placed in the folder that is used to access your admin from the Web. So if you had to type in https: // yourdomain. com / directory1/directory2/mysecretadmin to get to your admin, then the files in the admin directory of the download would go into that directory without modification of the file/folder structure of the remaining downloaded items.

Quote:

---

Originally Posted by DrByte

No.

Almost all plugins (actually "all" as long as they're written consistently) have a set of directories that correspond to the existing directories in your Zen Cart site.

So the easy-populate40-master/admin folder contains the files that you would add to your /admin (or renamed admin) directory.
And likewise most of the easypopulate40-master/whatever files and folders would go in your / (main, no subdirectory) directory.

---

I think I'm more confused by your answer than I was before.

Do the EP4 files all go into their own directory within the path named zenadmin/whatever-your-plugin-is-called/your-store-name-here

or something different to that

Quote:

---

Originally Posted by Haggis

I think I'm more confused by your answer than I was before.

Do the EP4 files all go into their own directory within the path named zenadmin/whatever-your-plugin-is-called/your-store-name-here

or something different to that

---

public_html/STORENAMEHERE/zenadmin/EasyPopulate-4.0-master

Attachment 16290 Attachment 16289

To use your example, the files from EasyPopulate-4.0-master/ go into public_html/STORENAMEHERE/
And, since you must account for whatever you've renamed your admin to (you used zenadmin here), the EasyPopulate-4.0-master/admin files go into public_html/STORENAMEHERE/zenadmin/

I think that's where I have them, if you look at the images I have attached above, then I renamed the directory called admin contained within EP4 to match the store name.

Is that where I have gone wrong because nothing shows up in zen CP under tools

Quote:

---

Originally Posted by Haggis

I think that's where I have them, if you look at the images I have attached above, then I renamed the directory called admin contained within EP4 to match the store name.

---

I can't understand your images.

Is easypopulate_4.php at STORENAMEHERE/zenadmin/easypopulate_4.php ?
If not, then you're putting things in the wrong place.

Quote:

---

Originally Posted by Haggis

Is that where I have gone wrong because nothing shows up in zen CP under tools

---

If the files are copied into the correct places, then the menu option will be automatically installed.


The EP plugin is no different than the majority of other plugins: its directory structure mimics your own Zen Cart structure, with its files already placed in the directories where you're supposed to copy them to inside your own store.

The steps I have taken

downloaded zip file, unpacked, then uploaded into the zencart directory which is called zenadmin. I have checked 3x and all files in the zip file are matched exactly on cpanel.

So now the question becomes what have I done wrong. I have tried four option, none of which have woked so far.

1. uploading the unpacked files into their own subdirectory called EasyPopulate-4.0-master within zenadmin, and then renamed the file from EP4 which was called admin to match store name

2. as 1. above except left the same admin file without renaming.

3. uploaded the unpacked files directly into zenadmin without creating a subdirectory EasyPopulate-4.0-master and then renamed the file from EP4 which was called admin to match store name.

4. as 3. above except left the same admin file without renaming.

so since nothing shows in zenadmin cp under tools, I have done something wrong but cannot workout what it is.

this is the file structure when unpacked from the zip file and uploaded to zenadmin directory in exactly the same way as it came

\zenadmin\EasyPopulate-4.0-master\admin
\zenadmin\EasyPopulate-4.0-master\examples
\zenadmin\EasyPopulate-4.0-master\htaccess4AdminTempFolder

the easypopulate_4.php file is within the admin directory listed above

Quote:

---

Originally Posted by Haggis

this is the file structure when unpacked from the zip file and uploaded to zenadmin directory in exactly the same way as it came

\zenadmin\EasyPopulate-4.0-master\admin
\zenadmin\EasyPopulate-4.0-master\examples
\zenadmin\EasyPopulate-4.0-master\htaccess4AdminTempFolder

the easypopulate_4.php file is within the admin directory listed above

---

None of those are correct.
If zenadmin represents your admin directory, then everything that you see when viewing this directory: \zenadmin\EasyPopulate-4.0-master\admin

Should be in:
\zenadmin

Quote:

---

Originally Posted by mc12345678

None of those are correct.
If zenadmin represents your admin directory, then everything that you see when viewing this directory: \zenadmin\EasyPopulate-4.0-master\admin

Should be in:
\zenadmin

---

ok, so as I understand that instruction, all I have to do is ignore the file tree EP4 came with and bundle everything into the zenadmin directory

After thinking about it, there is something I am just not getting, so I have deleted EP4. I'll survive without it.

thanks to those that tried to help

Quote:

---

Originally Posted by Haggis

After thinking about it, there is something I am just not getting, so I have deleted EP4. I'll survive without it.

thanks to those that tried to help

---

How do you install any other plugin? That is truly what you are not getting. Also, I don't know how to answer your last question because of the likelihood that you understand file tree differently than intended...

There should be/should have been 5 files and one directory in the folder referenced above (zenadmin/EP4/admin). All six items should be in your zenadmin directory. There is no "ignoring" the folder structure.

As DrByte said, the layout of the files is relatively the same as installing any other ZC downloaded program. it's a shame for you to give up just when things are about to go right...

Ok, I feel like a complete **** now, but I HAVE TO ask for help. Took me 2 days to install the plugin - no idea what was wrong everytime, it was just NOT WORKING (no EP links in admin...ect), but finally I installed it and I can see it in my administration.
HOWEVER ! Im struggling for about a day with imports. Everytime it shows : "No model field in record. This line was not imported" - which of course is BS, because I DO HAVE it in the file.
I have found a few other people who have the same issues, I tried all the recommended steps I found on forums, but with no luck.
Therefor I would like to ask any of you guys to help me figure out WTH am I doing wrong.


Here is a CSV file with one product :
v_products_model;v_products_image;v_products_name_1;v_products_description_1;v_p roducts_url_1;v_products_price;v_products_weight;v_date_avail;v_date_added;v_pro ducts_quantity;v_manufacturers_name;v_categories_name_1;v_tax_class_title;v_stat us
4CARS ROHOZ GUMOVA UNI 1;fa2b713ae48fb054def15b88ae77876e;4CARS ROHOZ GUMOVA UNI 1;AUTOROHOŽE gumové, UNI I, 4-dielne, k ochrane kobercov v aute, jednoduchá údržba, vhodné pre všetky modely osobných áut.;;13,7;;;;432;;Auto^Autodoplnky^Interiér^Gumové rohože;;1

ALSO, in Easy Populate, I found it created a csv file of all my products - but even this file (created by EP) is showing the same error when trying to import the products from it!

Thank you for any help. :(

What language is that? There have been problems seen regarding some specific languages for example Russian. If not mistaken the issue is not central to only EP4 in those cases.

That aside, it appears that the file provided above is semi-colon based rather than comma based, also don't see quotes applied between applicable fields. Further to be sure are you using EP4 as available from: https://www.zen-cart.com/downloads.php?do=file&id=2069 or from the first post of this thread?

Quote:

---

Originally Posted by kabko

Ok, I feel like a complete **** now, but I HAVE TO ask for help. Took me 2 days to install the plugin - no idea what was wrong everytime, it was just NOT WORKING (no EP links in admin...ect), but finally I installed it and I can see it in my administration.
HOWEVER ! Im struggling for about a day with imports. Everytime it shows : "No model field in record. This line was not imported" - which of course is BS, because I DO HAVE it in the file.
I have found a few other people who have the same issues, I tried all the recommended steps I found on forums, but with no luck.
Therefor I would like to ask any of you guys to help me figure out WTH am I doing wrong.


Here is a CSV file with one product :
v_products_model;v_products_image;v_products_name_1;v_products_description_1;v_p roducts_url_1;v_products_price;v_products_weight;v_date_avail;v_date_added;v_pro ducts_quantity;v_manufacturers_name;v_categories_name_1;v_tax_class_title;v_stat us
4CARS ROHOZ GUMOVA UNI 1;fa2b713ae48fb054def15b88ae77876e;4CARS ROHOZ GUMOVA UNI 1;AUTOROHOŽE gumové, UNI I, 4-dielne, k ochrane kobercov v aute, jednoduchá údržba, vhodné pre všetky modely osobných áut.;;13,7;;;;432;;Auto^Autodoplnky^Interiér^Gumové rohože;;1

ALSO, in Easy Populate, I found it created a csv file of all my products - but even this file (created by EP) is showing the same error when trying to import the products from it!

Thank you for any help. :(

---

Have you following the proper file naming convention for your csv file? (spoken from experience)

Quote:

---

Originally Posted by jeking

Have you following the proper file naming convention for your csv file? (spoken from experience)

---

I was just about to add something to my last post related to that. But stated that exported and then imported the resulting file (I assume with no changes, edits or without accessing the file) and it provided "the same error".

Sorry mc12345678: I have found something else that is not backed-up. Empty directories. I know that this has been happening for the last couple of versions of this plugin. Again sorry :blush:

Quote:

---

Originally Posted by adb34

Sorry mc12345678: I have found something else that is not backed-up. Empty directories. I know that this has been happening for the last couple of versions of this plugin. Again sorry :blush:

---

Please explain. Empty directories? And are you still using the dropdowns at the top where the last one indicates status, but have not changed it to all?

Quote:

---

Originally Posted by mc12345678

What language is that? There have been problems seen regarding some specific languages for example Russian. If not mistaken the issue is not central to only EP4 in those cases.

That aside, it appears that the file provided above is semi-colon based rather than comma based, also don't see quotes applied between applicable fields. Further to be sure are you using EP4 as available from: https://www.zen-cart.com/downloads.php?do=file&id=2069 or from the first post of this thread?

---

The language is SLOVAK.
The file I provided - I just copied and pasted the file opened in text editor. Pls see attached file in zip.
I have downloaded the latest version from github.

Quote:

---

Originally Posted by mc12345678

I was just about to add something to my last post related to that. But stated that exported and then imported the resulting file (I assume with no changes, edits or without accessing the file) and it provided "the same error".

---

Exactly. The file that is in EP from the beginning (I assume EP created it itself) - when I tried to IMPORT it, the same error was showing up.

Quote:

---

Originally Posted by jeking

Have you following the proper file naming convention for your csv file? (spoken from experience)

---

Not sure what you mean Jeking. Please explain.
But as I mentioned, even the EP´s self-created file is giving me the same eror when I try to IMPORT it. :(

The file provided above, which does reflect what you described, was not generated by this version of EP4 as provided. At a minimum a modification has been made to use a $csv_delimiter of ";"...

If you want to continue to use this delimiter instead of the programmed comma (,) then you will need to make a change to your files downloaded now and in the future until such "delimiters" can be chosen in the admin.

Open admin/easypopulate_4.php in a plain text editor, preferably one that shows line numbers.
search for:
$csv_delimiter and should find at or around line 6 the following:

Code:

---

$csv_delimiter = ","; // "\t" = tab AND "," = COMMA

---

If you wanted to have everything semi-colon separated, then would change this to:

Code:

---

$csv_delimiter = ";"; // "\t" = tab AND "," = COMMA

---

I do somewhat discourage this change though because there is other code that for example upon export will save the file with the extension .txt instead of .csv because it is not "comma separated"...

That said, I suggest actually clicking one of the links in the program to generate a new csv file of your product, then view the file/import it... Remember to backup before making changes and routinely.

Quote:

---

Originally Posted by mc12345678

Please explain. Empty directories? And are you still using the dropdowns at the top where the last one indicates status, but have not changed it to all?

---

Short answer – Yes
Long answer – I did three back-ups in three different ways;
1 Filterable Exports: only changed ‘status’ equals all.
2 & 3 - Category Export/Import Options: did both.

The ‘Categories Only (with Metatags)’ is the only CSV file that displays the categories that has no products in that category.

I cannot work out how ‘Categories Only’ works. If you are to import that CSV file, how does it know which category is a sub-category and under which category to put the sub-category?

Quote:

---

Originally Posted by kabko

Exactly. The file that is in EP from the beginning (I assume EP created it itself) - when I tried to IMPORT it, the same error was showing up.

---

This file just happened to exist in the directory that is/was referenced. EP4 does not create a file until the admin chooses either a clickable export link or uses the dropdowns at the top of the screen.

Also, part of what jeking was referencing was that the filename of an import file plays a part in how the program operates. Please see the instructions addressing filenames. The filename provided in the zip was newimport2.csv. On import this file would be treated as if it contained information to fully describe a product accessing it's products table, the categories table(s), and metatag information. There are a few files that must begin with a particular series of characters in order to process them for their intended function. For example, the full import/export doesn't address attributes of a product, and the attributes file(s) don't necessarily have useful information for the full products part so they don't usually get processed as part of the full product information. The only "special" part of the filename is whatever exists(ed) when an export was performed to include the characters from the first letter up to and including ep...

Quote:

---

Originally Posted by mc12345678

The file provided above, which does reflect what you described, was not generated by this version of EP4 as provided. At a minimum a modification has been made to use a $csv_delimiter of ";"...

If you want to continue to use this delimiter instead of the programmed comma (,) then you will need to make a change to your files downloaded now and in the future until such "delimiters" can be chosen in the admin.

Open admin/easypopulate_4.php in a plain text editor, preferably one that shows line numbers.
search for:
$csv_delimiter and should find at or around line 6 the following:

Code:

---

$csv_delimiter = ","; // "\t" = tab AND "," = COMMA

---

If you wanted to have everything semi-colon separated, then would change this to:

Code:

---

$csv_delimiter = ";"; // "\t" = tab AND "," = COMMA

---

I do somewhat discourage this change though because there is other code that for example upon export will save the file with the extension .txt instead of .csv because it is not "comma separated"...

That said, I suggest actually clicking one of the links in the program to generate a new csv file of your product, then view the file/import it... Remember to backup before making changes and routinely.

---

The provided file was not the file generated by EP, its the file I tried to IMPORT. The generated file is too long, I did not attached it here.

Ok, I have attached the file generated by EP4 (Export).
When I try to import it - I only see the errors (see screenshot attached).

Quote:

---

Originally Posted by adb34

Short answer – Yes
Long answer – I did three back-ups in three different ways;
1 Filterable Exports: only changed ‘status’ equals all.
2 & 3 - Category Export/Import Options: did both.

The ‘Categories Only (with Metatags)’ is the only CSV file that displays the categories that has no products in that category.

I cannot work out how ‘Categories Only’ works. If you are to import that CSV file, how does it know which category is a sub-category and under which category to put the sub-category?

---

The filtered dropdowns relate to product... No product, no information... Therefore an empty category would not appear on the export of a list of products.

As to the two other selections. The 'Categories Only' list each product (by model #) and the category(ies) to which it is referenced. This helps to identify linked product, to see to what categories a product is placed, and in actuality offers a way to further link a product to other categories.

The category with metadata option is the detailed category information much like if you were editing the category in ZC admin. It does not display the relationship of one category to another. That "relationship" is done when assigning a product to a category.

Quote:

---

Originally Posted by mc12345678

The category with metadata option is the detailed category information much like if you were editing the category in ZC admin. It does not display the relationship of one category to another. That "relationship" is done when assigning a product to a category.

---

I have quite a lot of categories to add and using the admin/catalog/Categories / Products is taking a lot of time. So I was hoping to use category with metadata to speed up the process. So with what you have said this is not possible?

Quote:

---

Originally Posted by mc12345678

This file just happened to exist in the directory that is/was referenced. EP4 does not create a file until the admin chooses either a clickable export link or uses the dropdowns at the top of the screen.

Also, part of what jeking was referencing was that the filename of an import file plays a part in how the program operates. Please see the instructions addressing filenames. The filename provided in the zip was newimport2.csv. On import this file would be treated as if it contained information to fully describe a product accessing it's products table, the categories table(s), and metatag information. There are a few files that must begin with a particular series of characters in order to process them for their intended function. For example, the full import/export doesn't address attributes of a product, and the attributes file(s) don't necessarily have useful information for the full products part so they don't usually get processed as part of the full product information. The only "special" part of the filename is whatever exists(ed) when an export was performed to include the characters from the first letter up to and including ep...

---

May I ask you : Could you please upload a sample csv file, so I can see what am I doing wrong? Just a file with 1-2 products, please.
Thank you very much.

Quote:

---

Originally Posted by adb34

I have quite a lot of categories to add and using the admin/catalog/Categories / Products is taking a lot of time. So I was hoping to use category with metadata to speed up the process. So with what you have said this is not possible?

---

So couple of things here... Remember, this tool allows you to add things in bulk.. So... There are a lot of ways to use it to your advantage even if there are some "features" not directly implemented. Categories get generated when a product is associated with a category, the product doesn't need to be an active product, it could be a "dummy" product that is used to generate all new categories will be linked to all categories (initially) and perhaps periodically you delete the main product from the store once in a while to be reuploaded the next time you need to just generate a category...

The next thing is that if you already know what category name you are going to create you can make a "line" to represent that category's data, and then once your dummy product is uploaded to create the category you can also download your list of categories and copy/paste that category's information to the correct category_id. But as written, the code does not (yet?) support just creating a category and all of it's data from an upload. Doesn't seem like it would be too much of a stretch to implement on ones own from the existing code, it just doesn't have that at the moment. Further while this tool was primarily developed to support upload of multiple product to existing areas in support of mass "mailers", it could be further used/developed to do more.

EVEN if you think you are doing this, I have had the "no model field" issue for no apparent reason.

So: bookmarked this message:
https://www.zen-cart.com/showthread....ield-in-record

solves the problem every time - I have learned to use Save As and follow these instructions

Hope this helps you

Wheat

Quote:

---

Originally Posted by wheat

EVEN if you think you are doing this, I have had the "no model field" issue for no apparent reason.

So: bookmarked this message:
https://www.zen-cart.com/showthread....ield-in-record

solves the problem every time - I have learned to use Save As and follow these instructions

Hope this helps you

Wheat

---

Good information to address such usage. If I understand correctly about the recent situation, when product has been exported, and the file then immediately imported, the no model_id response is still received at that store.

I visually reviewed the file and didn't see any issues with the formatting but also didn't have a chance yet to try importing it to a test store to see the result.

Because of the lack of detail from the code to identify what the primary key is (issue to be addressed), would want to know the settings in the configuration panel for EP4. Although there are several settings, if products_id or blank_new was selected with the current/recent file then the error seen would be consistent.

Alternatively I am wondering if the various language/encoding settings of the site/database could be the issue.

Quote:

---

Originally Posted by mc12345678

Good information to address such usage. If I understand correctly about the recent situation, when product has been exported, and the file then immediately imported, the no model_id response is still received at that store.

I visually reviewed the file and didn't see any issues with the formatting but also didn't have a chance yet to try importing it to a test store to see the result.

Because of the lack of detail from the code to identify what the primary key is (issue to be addressed), would want to know the settings in the configuration panel for EP4. Although there are several settings, if products_id or blank_new was selected with the current/recent file then the error seen would be consistent.

Alternatively I am wondering if the various language/encoding settings of the site/database could be the issue.

---

Hi.

Well, don´t ask me how or why I have done that change (somehow, dont know how), but yes, the problem was in configuration of EP4. It was changed to product_id, and when I changed it to products_model everything is working OK :)
Thank you all for your help, much appreciated. :)

Quote:

---

Originally Posted by kabko

Hi.

Well, don´t ask me how or why I have done that change (somehow, dont know how), but yes, the problem was in configuration of EP4. It was changed to product_id, and when I changed it to products_model everything is working OK :)
Thank you all for your help, much appreciated. :)

---

Whew. Thank you for that update. Default install should have had it as products_model. That said and as I pointed out, the error message should show the correct primary key and not default to products_model. Further in retrospect I thought I remember at one point at least heavily considering adding the products_id field in the export in such a setup, though can't recall a good reason to not automatically include it in such a download.

I know I was concerned about the possibility of it being the primary key *and* as a user defined field (already addressed I thought) and that by it being a user defined field it would place it at the far right instead of adjacent to the products_model. But regardless I see that it can be included to make life "easier". :) one more thing to add to the next update. :) (actually two more things.)

Some poor devil was having the same problem I encountered with Easy Populate on their updated ZenCart 1.5.x. I tried to follow the thread from where the problem started but ran out of time, etc. So, in case someone wanted a new perspective on this, here it is:

Easy Populate was installed from the download on this site. I tried to test it out and could not get EP to download the complete products. It kept on telling me there was an error and to try again. I went to someone who is more experienced in the ways of ZenCart than I am and this is what they came up with and it worked. I hope it works for you. It seems pretty simple:

Quote:

---

I found that even though I installed the latest version, it did not remove old stuff from the database. So, I manually deleted all references to EP in the database, then ran their SQL for the new version. There are now settings in the Configuration menu as well. I was able to download a complete CSV and the data looks good. Upon further investigation, I found the plugin I downloaded (latest on the Zen site) was not a good one. They have another on GitHub. So, I removed the other one and installed the new one. This one looks to be working properly. And, it runs a little differently. For example, it does not allow you to stream a download. You need to right click and download after you click on of the links. Here's what I did: Step 1: Backed up database (manually just to be sure). Step 2: Backed up database using Zen admin tool. Step 3: Clicked Complete Products (with Metatags). Step 4: Right clicked on the Download link (bottom of page) and downloaded file. Step 5: Modified a product description and saved CSV file as a new file. Step 6: Clicked Browse button and Upload File. Step 7: Scroll to bottom of page and click Import next to new file. Step 8: Checked product and update was there.

---

Hope that helps someone. I really can't answer a lot of questions about the above, it was done by someone else but I am posting it here and hope it might help someone who has the same problem.

Quote:

---

Originally Posted by fabienne

Some poor devil was having the same problem I encountered with Easy Populate on their updated ZenCart 1.5.x. I tried to follow the thread from where the problem started but ran out of time, etc. So, in case someone wanted a new perspective on this, here it is:

Easy Populate was installed from the download on this site. I tried to test it out and could not get EP to download the complete products. It kept on telling me there was an error and to try again. I went to someone who is more experienced in the ways of ZenCart than I am and this is what they came up with and it worked. I hope it works for you. It seems pretty simple:



Hope that helps someone. I really can't answer a lot of questions about the above, it was done by someone else but I am posting it here and hope it might help someone who has the same problem.

---

Not entirely sure of the timeline regarding the ZC version to github version issue, but what I see about the above is how/why one transitioned from one of the other Easypopulate versions to this one. No, this one doesn't "clear" settings from other versions and in fact should be using settings different from the others just to be sure that there is no conflict. The github version is expected to always be at or ahead of the version on the ZC site as that is where it is further developed and shared.

Fabienne thank you for sharing your experience. Hopefully the other issues experienced over the last year or so are no more. :)

Quote:

---

Originally Posted by mc12345678

Not entirely sure of the timeline regarding the ZC version to github version issue, but what I see about the above is how/why one transitioned from one of the other Easypopulate versions to this one. No, this one doesn't "clear" settings from other versions and in fact should be using settings different from the others just to be sure that there is no conflict. The github version is expected to always be at or ahead of the version on the ZC site as that is where it is further developed and shared.

Fabienne thank you for sharing your experience. Hopefully the other issues experienced over the last year or so are no more. :)

---

Thanks Mac12345678. Like I said, I wasn't the guy who did this, but it worked and was pretty pain free, simple, straight forward. It's just meant to be another option to try if you are having problems. The other issues....they were just old abandoned shopping instances which were imported with the other data onto a new website. When the same customer tried to check out, the old cart would register a $0 charge for the product because on my old cart there were no pricing attributes--I put them all in by hand so there was no price. We weeded out all the old abandoned shopping and never had the problem again. *

"Old Abandoned Shopping Instance"=when you put something in your cart, then you don't check out. You go away for a long time (like a year) and then return, shop more, check out with the very first item from a year ago, in your cart which never had attributes associated with it then or when you try checking out. You will get the first item costing $0 and the rest costing as they should.

Quote:

---

Originally Posted by fabienne

Thanks Mac12345678. Like I said, I wasn't the guy who did this, but it worked and was pretty pain free, simple, straight forward. It's just meant to be another option to try if you are having problems. The other issues....they were just old abandoned shopping instances which were imported with the other data onto a new website. When the same customer tried to check out, the old cart would register a $0 charge for the product because on my old cart there were no pricing attributes--I put them all in by hand so there was no price. We weeded out all the old abandoned shopping and never had the problem again. *

"Old Abandoned Shopping Instance"=when you put something in your cart, then you don't check out. You go away for a long time (like a year) and then return, shop more, check out with the very first item from a year ago, in your cart which never had attributes associated with it then or when you try checking out. You will get the first item costing $0 and the rest costing as they should.

---

That's right, now I remember why I made some changes to another plugin on which I've been working to I thought it was process all product through in particular those having attributes. Goal was to be sure that product having attributes when in the cart have attributes supported by the store and that store product that have attributes are applied against product in the cart. It already has some checks in place, but there are others that can be applied. Problem is/becomes as other option name types are created, shopping cart addition/update may need modification as well. :/

Anyways, it would seem that the support of this plugin in the form of an announcement of its "success" would help others when posted where they are expressing having difficulty. :)

A error occur when import the Attrib-Basic-EP.csv
log:

Code:

---

MySQLi error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':) LIMIT 1' at line 1
When executing:
SELECT * FROM products WHERE (products_model = xxx':) LIMIT 1

---

Zencart: v1.5.4
PHP: 7.0.6
MySQL: 5.0.12
EP: Easy Populate 4.0.35.ZC - 04-29-2016

There is no problem when use the old EP version Easy Populate 4.0.28 - Beta 01-03-2015

Quote:

---

Originally Posted by su35

A error occur when import the Attrib-Basic-EP.csv
log:

Code:

---

MySQLi error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':) LIMIT 1' at line 1
When executing:
SELECT * FROM products WHERE (products_model = xxx':) LIMIT 1

---

Zencart: v1.5.4
PHP: 7.0.6
MySQL: 5.0.12
EP: Easy Populate 4.0.35.ZC - 04-29-2016

There is no problem when use the old EP version Easy Populate 4.0.28 - Beta 01-03-2015

---

Line 25 of admin/easypopulate_4_attrib.php change from:

Code:

---

$query = $db->bindVars($query, ':v_products_model', $v_products_model, 'string');

---

To:

Code:

---

$query = $db->bindVars($query, ':v_products_model:', $v_products_model, 'string');

---

Adding a colon (:) after :v_products_model.

Quote:

---

Originally Posted by mc12345678

Line 25 of admin/easypopulate_4_attrib.php change from:

Code:

---

$query = $db->bindVars($query, ':v_products_model', $v_products_model, 'string');

---

To:

Code:

---

$query = $db->bindVars($query, ':v_products_model:', $v_products_model, 'string');

---

Adding a colon (:) after :v_products_model.

---

Ugh, apparently same issue on lines 97 and 98:

Code:

---

                                        $sql = $db->bindVars($sql, ':v_products_options_name:', $v_products_options_name[$l_id], 'string');
                                        $sql = $db->bindVars($sql, ':v_products_options_type:', $v_products_options_type, 'integer');

---

Change(s) shown: https://github.com/mc12345678/EasyPo...99d7d0671fc80b

Quote:

---

Originally Posted by mc12345678

Ugh, apparently same issue on lines 97 and 98:

Code:

---

                                        $sql = $db->bindVars($sql, ':v_products_options_name:', $v_products_options_name[$l_id], 'string');
                                        $sql = $db->bindVars($sql, ':v_products_options_type:', $v_products_options_type, 'integer');

---

Change(s) shown: https://github.com/mc12345678/EasyPo...99d7d0671fc80b

---

After modified, when importing the data I got a blank page.
log:

Code:

---

MySQLi error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': AND
                                                a.products_options_values_id = b.products_options_values_id AND
                                ' at line 8
When executing:
SELECT
                                                a.products_options_id,
                                                a.products_options_values_id,
                                                b.products_options_values_id,
                                                b.products_options_values_name
                                                FROM products_options_values_to_products_options as a, products_options_values as b
                                                WHERE
                                                a.products_options_id = 1: AND
                                                a.products_options_values_id = b.products_options_values_id AND
                                                b.products_options_values_name = 'xxx'

---

Quote:

---

Originally Posted by su35

After modified, when importing the data I got a blank page.
log:

Code:

---

MySQLi error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': AND
                                                a.products_options_values_id = b.products_options_values_id AND
                                ' at line 8
When executing:
SELECT
                                                a.products_options_id,
                                                a.products_options_values_id,
                                                b.products_options_values_id,
                                                b.products_options_values_name
                                                FROM products_options_values_to_products_options as a, products_options_values as b
                                                WHERE
                                                a.products_options_id = 1: AND
                                                a.products_options_values_id = b.products_options_values_id AND
                                                b.products_options_values_name = 'xxx'

---

---

More of the same issue. For some reason when I was searching the file yesterday only 6 occurrences of substitution were identified (included those correctly coded and the ones that were fixed as identified incorrect), when I returned to the same thing later, the total was more than the original 6. Will correct soon and repost the associated link(s).

As relates to EP4.0.35.ZC, this "patch" is provided for those that use the basic attribute import. This is/will be incorporated in 4.0.36. At this time, no interim version is being provided.

Hi guys, I am having problems with EP also....
I am running "Zen-Cart 1.5.5" and have "Easy Populate For ZenCart v1.5.x". I have followed all instructions but am getting stuck. I load all the files to my server and Easy Populate appears in my "TOOLS" dropdown. When I click it, I get the Easy Populate page with the error at the top of the page that reads "Easy Populate Configuration Missing. Please install your configuration by clicking here."
Clicking there gives me this error ""WARNING: An Error occurred, please refresh the page and try again."
Refreshing does nothing...

Also, on the Easy Populate page I see this note.."Import from Temp Dir (EASYPOPULATE_CONFIG_TEMP_DIR/)" and I do not see that Dir anywhere on my server? I have removed and re-installed EP 3 times with the same exact issues, I know I must be missing something?
Any help would be very much appreciated...

P.S. Easy Populate DOES NOT appear in my Configuration dropdown menu.

Don't necessarily expect this to be directly related, but what version of EP4 is being attempted to install?

Second, what is the error message seen by review of the latest logs directory entry (obscure your admin directory path when posting.) When posting please first press the # button in the message box toolbar and then paste the complete message with admin directory obscured.

Quote:

---

Originally Posted by mc12345678

As relates to EP4.0.35.ZC, this "patch" is provided for those that use the basic attribute import. This is/will be incorporated in 4.0.36. At this time, no interim version is being provided.

---

Thanks. It works!:smile:

I have downloaded this: easy_populate_csv_for_zencart_v1.5.x_v1.2.6.1

Quote:

---

Originally Posted by ntsllc

I have downloaded this: easy_populate_csv_for_zencart_v1.5.x_v1.2.6.1

---

Similar program, different thread... think that the same issue has been "described" there for some time.

But, while you're here, maybe you'd like to try this version. Download is here.

Sorry, but if you use attributes in your import there's a minor patch a couple of posts back.

OK< I answered my own question!!! When I posted the version I used, I realized it wasn't EP4!!! What a moron!!! Removed th eold one, downloaded the REAL EP4 and all is working now!!! Sorry for wasting anyone's time today!!
Thank You!

Quote:

---

Originally Posted by ntsllc

OK< I answered my own question!!! When I posted the version I used, I realized it wasn't EP4!!! What a moron!!! Removed th eold one, downloaded the REAL EP4 and all is working now!!! Sorry for wasting anyone's time today!!
Thank You!

---

No problem. Certainly threw me for a loop, but either without asking (or initially posting) might have gone chasing the wrong thing. :)

I know I've been meaning to make the plugin description more informative, but haven't submitted the requested text yet. The plugin finally reached a state of being submitted for approval and well... the plugin description didn't include more pertinent detail unlike the expectation for a store product description.

Anyways, glad you got through that hurdle.

Thank you!!! I probably would have kept beating my head against the wall!! Works great now!

Hi mc12345678
"Activate Blank Featured" miss the setting field at right.

Quote:

---

Originally Posted by su35

Hi mc12345678
"Activate Blank Featured" miss the setting field at right.

---

Please explain. Right side of screen when looking at the configuration menu, right side of the a function that uses the constant? Is it enabled but not capturing one of the conditions? Etc.

I'm stumped. I uploaded the files but Easy Populate does not show up under Admin>Tools.

Here's what I've done.
I uploaded all the files in the admin directory to my site maintaining directory structure within admin from EasyPopulate-4.0-4.0.35.
I then logged in to my store's admin and looked under Tools. There is nothing there for Easy Populate.
I made note of the below comment from install.txt . . .

Code:

---

4. Login to your store's admin. Under Tools you will see a new entry "Easy Populate 4".
  (If you do not see this entry, you did not upload your files correctly.)

---

I then checked and confirmed that each and every file was uploaded to the correct directory with the exception of the following that were not uploaded . . .

\admin\includes\languages\deutsche\ -- since I only need English
\examples\ -- since it was not in the admin directory and the instructions said to upload the files in the admin directory maintaining directory structure
\htaccess4AdminTempFolder\ -- since it was not in the admin directory
\examples\ -- since it was not in the admin directory
\zencart 1.3 extra files\ -- since I'm using Zen Cart 1.5.5a

Any ideas?

My vitals
1. Zen Cart v1.5.5a fresh clean install including demo data; files uploaded via FTP then run zc_install
2. Linux Apache
3. PHP Version: 5.6.17 (Zend: 2.6.0)
4. Database: MySQL 5.5.42-37.1-log
5. Database Backup MySQL Addon

More than likely the admin directory within the EP4 package has been copied to YOUR_SECRET_ADMIN folder rather than the contents of the admin directory within the EP4 package being copied there.

If you locate the file easypopulate_4.php on your server, what other file(s) are in the directory with it? If they are only other EP4 files, then loaded to the wrong location.

Installation of EP4 with regards to loading the contents of the admin directory to your server's admin directory is very similar to the installation of any other ZC plugin. It is an admin side application with no catalog side facing software (no basic includes folder).

Quote:

---

Originally Posted by mc12345678

If you locate the file easypopulate_4.php on your server, what other file(s) are in the directory with it? If they are only other EP4 files, then loaded to the wrong location.

---

Good thought. However, there are many other files in my secret admin directory /zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/
Alphabetically the 1st file is admin_account.php and the last is zones.php
easypopulate_4.php and the four other easypopulate php files are also in there.

Also, as recommended in install.txt I successfully installed Back MYSQL Plugin. So backup_mysql.php is also in there indicating that I understood, at least in one case, how to upload files to MY_SECRET_ADMIN

What should I check out next?

Thanks so much for your assistance!

When you access your admin, does the path to your admin include zen-cart-v1.5.5a-05052016 when looking at the uri of your browser?

Does backup_mysql.php exist elsewhere in your file structure off of the catalog front end?

Quote:

---

Originally Posted by mc12345678

When you access your admin, does the path to your admin include zen-cart-v1.5.5a-05052016 when looking at the uri of your browser?

---

Yes, when looking at the uri of my browser the path to my admin does include zen-cart-v1.5.5a-05052016. This is as expected since zen-cart-v1.5.5a-05052016 is the catalog front end of the Zen Cart.

Quote:

---

Originally Posted by mc12345678

Does backup_mysql.php exist elsewhere in your file structure off of the catalog front end?

---

I don't know how to check for that short of manually looking into each of the hundreds of sub directories contained therein. However, just to confirm the admin tool console was in fact looking at that file, I deleted it and then tried accessing Tools> Database Backup - MySQL and, as expected, got a 404 Error File Not Found. I then restored /zen-cart-v1.5.5a-05052016/My_Secret_Admin/backup_mysql.php and then again accessed it via Tools> Database Backup - MySQL without error.

Additionally, I used the admin Console>Tools>Developers Tool Kit to Look up in all files and search the phrase easypopulate in All Files Catalog/Admin for every file type. Here are the files that were found.


/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_attrib.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_export.php
zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_import.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_split.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/functions/extra_functions/easypopulate_4_functions.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/functions/extra_functions/reg_easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/easypopulate_4_menus.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/extra_definitions/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/modules/easypopulate_4_filelayout.php

How does that look? What should I do next? Thanks!!

Quote:

---

Originally Posted by Zean

Additionally, I used the admin Console>Tools>Developers Tool Kit to Look up in all files and search the phrase easypopulate in All Files Catalog/Admin for every file type. Here are the files that were found.


/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_attrib.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_export.php
zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_import.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/easypopulate_4_split.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/functions/extra_functions/easypopulate_4_functions.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/functions/extra_functions/reg_easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/easypopulate_4_menus.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/languages/english/extra_definitions/easypopulate_4.php
/zen-cart-v1.5.5a-05052016/MY_SECRET_ADMIN/includes/modules/easypopulate_4_filelayout.php

How does that look? What should I do next? Thanks!!

---

I see you are missing admin/includes/extra_datafiles/easypopulate_4_filenames.php
Try to upload that file and let us know... :)

The above "easypopulate" search should have identified the file kabko stated. The contents of that file are:

Code:

---

<?php
// $Id: easypopulate_filenames.php, v4.0.21 06-01-2012 chadderuski $
define('FILENAME_EASYPOPULATE_4', 'easypopulate_4');
?>

---

The absence of that file will prevent loading the admin menu option to operate EP4. Thanks for that additional file comparison. I was going to suggest attempting to reupload all of the files as a group (not one at a time) and have them replace the files previously attempted to be uploaded.

Quote:

---

Originally Posted by kabko

I see you are missing admin/includes/extra_datafiles/easypopulate_4_filenames.php
Try to upload that file and let us know... :)

---

Wow! You hit it exactly! I uploaded that file and all seems to work.
I misunderstood the instructions in INSTALL.txt item 2 b) . . .

Code:

---

2. Upload all files in the "admin" directory to your site maintaining directory structure.
  No core files are changed.

        a) If you are using zencart 1.3.8/1.3.9, you need to also upload the additional
        files in the "zencart 1.3 extra files" folder.

        b)  If you are using zencart 1.5.x, no additional files need to be uploaded as the file necessary
        to support ZenCart 1.5.x has been placed within the above "admin" directory.

---

So, I mistakenly did not upload admin\includes\extra_datafiles\easypopulate_4_filenames.php
It seems I erroneously conflated "no additional" with "extra_datafiles"

Now that I seem to have it properly installed, I'm looking forward to figuring out how to use it.
I thought as a first step I would export the demo data products to see how the csv's of new products should be coded for input.

Thanks so much kabko! And Thank you mc12345678

Quote:

---

Originally Posted by Zean

Thanks so much kabko! And Thank you mc12345678

---

No problem... Even though Im "beginner" in ZENCART, I do know a little bit about coding, so everytime I see someone has a problem, I try to find a solution, and if I cant, I look into forum if anyone else replied with a solution - and this is the best way to learn. (at least for me...lol)

Quote:

---

Originally Posted by Zean

Wow! You hit it exactly! I uploaded that file and all seems to work.
I misunderstood the instructions in INSTALL.txt item 2 b) . . .

Code:

---

2. Upload all files in the "admin" directory to your site maintaining directory structure.
  No core files are changed.

        a) If you are using zencart 1.3.8/1.3.9, you need to also upload the additional
        files in the "zencart 1.3 extra files" folder.

        b)  If you are using zencart 1.5.x, no additional files need to be uploaded as the file necessary
        to support ZenCart 1.5.x has been placed within the above "admin" directory.

---

So, I mistakenly did not upload admin\includes\extra_datafiles\easypopulate_4_filenames.php
It seems I erroneously conflated "no additional" with "extra_datafiles"

Now that I seem to have it properly installed, I'm looking forward to figuring out how to use it.
I thought as a first step I would export the demo data products to see how the csv's of new products should be coded for input.

Thanks so much kabko! And Thank you mc12345678

---

I am making some modifications to the instructions for the next version. This will be an area touched to try to reduce such confusion.

A little background, at some point in the code's history, chadderuski had made the final "step" of installation a process requiring upload of the applicable file for the version of ZC. Not too long ago I decided to simplify the process by a step to include the file automatically in the fileset. In changing the instructions to "match" I minimized the change instead of rewriting that section. Time to rewrite. :) thanks for identifying where the confusion came from.

On a side note and as pointed out by DrByte in the last couple of pages, generally speaking plugins are provided with the complete file structure and "at worst" may require renaming of override folders to match the applicable template. This plugin doesn't have such overrides (except for languages not yet translated), but the point being that once such changes have been made "locally" and possibly merge of overwritten files performed, the entire fileset is uploaded as a unit rather than file by file. Such a "missed" file would not occur. Again there, thank you for identifying why the file was omitted. That type of discussion helps upfront to identify why something isn't working the way it is expected and helps to expedite solving the issue.

As to your next step of exporting a sample file. Spot on. Please keep in mind usage as described in the instructions for uploading and also note that there is a patch on the previous page if you are uploading attributes using EP4 version 4.0.35.ZC as downloaded from the ZC site.

I have a need to provide a product export from a zen cart store which will be incorporated into a Amazon store. Amazon is asking for the following product information:

SKU/Model#
Product Name
Brand/Manufacturer
Price
Quantity
Description
Image URL
additional images
attributes

I installed Easy Populate 4.0.35.ZC and downloaded "Complete Products (with Metatags)" and "Basic Products Attributes (basic single-line)"

Questions:

1. Is there a way to perform an export that contains both the complete product info and attributes in one file?
2. Is there a way to get the "Image URL"
3. Is there a way to export additional images?

Always a way. :) may not really like the results in total, but it is always possible to add more data to the export.
2. The image path is pretty much already provided.
3. Additional images is something not directly handled by EP4 but by invoking some of the other ZC code, such image paths can be obtained. Do run into some of the issues otherwise addressed like, how will each of the additional images be presented? One image per row of data such that if there were 5 additional images then each row of product data would be displayed 5 times over? Or columns? How does one maximize the use of the appropriate column?

Look back several pages I explain how the exported tables will grow by combining ever more data into a single spreadsheet, but doable.

@Crunch,

What are the separators for attributes and additional images?
With regards to attributes, how is a grouping of option names expected to be considered/separated?
Ie. If a product has an option name of size and an option name of color, are they looking for all potential sizes and all potential colors or only the combinations that are expected to exist, both, etc...

Quote:

---

Originally Posted by mc12345678

@Crunch,

What are the separators for attributes and additional images?
With regards to attributes, how is a grouping of option names expected to be considered/separated?
Ie. If a product has an option name of size and an option name of color, are they looking for all potential sizes and all potential colors or only the combinations that are expected to exist, both, etc...

---

Unfortunately I was provided no specifics. I was cold added into an email thread between the store owner and an Amazon rep discussing migration to a Amazon store.

This is all they asked for:

"Send me a data file or spreadsheet (as a product export from your eCommerce platform) containing the following product information for the initial items you’d like to list:

• Product Name
• Brand/Manufacturer
• UPC Code
• Price
• Quantity
• Description
• Image URL

There are many other optional fields that can be included, such as your own SKU#, search keywords, additional images, size or color variations available, weight if you want to charge weight-based shipping rates, etc. But those are optional—the fields above are the basic ones needed."

They refer to attributes as variations.

I think at this point I will send them two data files - the "Complete Products (with Metatags)" and "Basic Products Attributes (basic single-line)" and see if that works for their integration team. If I receive any other info, I will let you know.

FYI: I discovered that a Froogle export in Easy Populate v1.2.5.4 contains the image URL's (and Product URL's) in the data file.

Quote:

---

Originally Posted by Crunch

Unfortunately I was provided no specifics. I was cold added into an email thread between the store owner and an Amazon rep discussing migration to a Amazon store.

This is all they asked for:

"Send me a data file or spreadsheet (as a product export from your eCommerce platform) containing the following product information for the initial items you’d like to list:

• Product Name
• Brand/Manufacturer
• UPC Code
• Price
• Quantity
• Description
• Image URL

There are many other optional fields that can be included, such as your own SKU#, search keywords, additional images, size or color variations available, weight if you want to charge weight-based shipping rates, etc. But those are optional—the fields above are the basic ones needed."

They refer to attributes as variations.

I think at this point I will send them two data files - the "Complete Products (with Metatags)" and "Basic Products Attributes (basic single-line)" and see if that works for their integration team. If I receive any other info, I will let you know.

---

Well, I began creating a sort of EP4 plugin to try to accomodate. Figured why not. :P Seeing that the "combined" list of attributes is expected to fill in a single block I thought I would try to find out. :)

Didn't see anything about language though, like identifying the content to a language (as you may have come to know, EP4 does support populating multiple languages) so was going to try to adapt to that as well... perhaps though in the conversations you can find out some more information.

Quote:

---

Originally Posted by Crunch

FYI: I discovered that a Froogle export in Easy Populate v1.2.5.4 contains the image URL's (and Product URL's) in the data file.

---

Yeah, not a big deal to create. There's already the ability to export various aspects of a product, for example there already is an export of the products_uri as say a customer would enter. There's also already the image location as it relates to DIR_WS_IMAGES. All that needs to happen is say to export the uri generated when using the zen_image (or sorry if at the moment I forgot the function name) function appended to the base uri... I realize that you may be new to EP4, but I said it maybe 2 or more years ago, everything that is needed is here in the code, someone just has to identify what they need/want and even better if someone adds to it (one has taken EP4 and added the export of a product type that in itself is complicated and done so without affecting the base EP4 code). At the moment I'm working on the additional capability of Stock-by-attributes to handle the upload of files otherwise I might be adding to EP4. I have to balance my time to suit "particular" needs and requests.

When I get a chance in the next day or so I'll upload what I have for the amazon "addition" to github. Probavly as a separate repo as it will be an add-on to EP4 rather than some sort of modification to it. Pretty sure after that others will begin splitting off. Considering that the information is to be one way (outward) would be good to know what headings each column should have so that the necessary format can be applied.

I get this error whenever I try to import a feed into the website. The vps I got is this:

Server Host: centos (91.92.109.48)

Server OS: Linux 2.6.32-042stab108.2

Server Date: 06/01/2016 09:45:58

Server Up Time: Unsupported

HTTP Server: Apache/2.2.31 (Unix)

PHP Version: 5.6.20 (Zend: 2.6.0)

PHP File Uploads: On

Upload Max Size: 128M

PHP Memory Limit: 1024M

POST Max Size: 128M

Database: MySQL 5.5.49

Database Host: 127.0.0.1 (127.0.0.1)

Database Date: 06/01/2016 09:45:58

Database Data Size: 457 kB

Database Index Size: 464 kB

MySQL Slow Query Log Status: On

MySQL Slow Query Log File: /var/lib/mysql/centos-slow.log

MySQL Mode: (None set)

and zen cart 1.5.5

[31-May-2016 17:22:11 UTC] Request URI: /zcadmin/configuration.php?gID=31&cID=547&action=edit, IP address: 172.93.102.178
#1 call_user_func() called at [/home/soft/public_html/XXXXXXXXXXX.com/zcadmin/includes/functions/general.php:1800]
#2 zen_call_function() called at [/home/soft/public_html/XXXXXXXXXXX.com/zcadmin/configuration.php:129]

[31-May-2016 17:22:11 UTC] PHP Warning: call_user_func() expects parameter 1 to be a valid callback, function 'zen_cfg_select_option(array('true', 'false'),' not found or invalid function name in /home/soft/public_html/XXXXXXXXXXX.com/zcadmin/includes/functions/general.php on line 1800
[31-May-2016 17:22:11 UTC] Request URI: /zcadmin/configuration.php?gID=31&cID=547&action=edit, IP address: 172.93.102.178
#1 call_user_func() called at [/home/soft/public_html/XXXXXXXXXXX.com/zcadmin/includes/functions/general.php:1800]
#2 zen_call_function() called at [/home/soft/public_html/XXXXXXXXXXX.com/zcadmin/configuration.php:129]

[31-May-2016 17:22:11 UTC] PHP Warning: call_user_func() expects parameter 1 to be a valid callback, function 'zen_cfg_select_option(array('true', 'false'),' not found or invalid function name in /home/soft/public_html/XXXXXXXXXXX.com/zcadmin/includes/functions/general.php on line 1800

Quote:

---

Originally Posted by RonaldNavarro689

I get this error whenever I try to import a feed into the website. The vps I got is this:

Server Host: centos (91.92.109.48)

Server OS: Linux 2.6.32-042stab108.2

Server Date: 06/01/2016 09:45:58

Server Up Time: Unsupported

HTTP Server: Apache/2.2.31 (Unix)

PHP Version: 5.6.20 (Zend: 2.6.0)

PHP File Uploads: On

Upload Max Size: 128M

PHP Memory Limit: 1024M

POST Max Size: 128M

Database: MySQL 5.5.49

Database Host: 127.0.0.1 (127.0.0.1)

Database Date: 06/01/2016 09:45:58

Database Data Size: 457 kB

Database Index Size: 464 kB

MySQL Slow Query Log Status: On

MySQL Slow Query Log File: /var/lib/mysql/centos-slow.log

MySQL Mode: (None set)

and zen cart 1.5.5

[31-May-2016 17:22:11 UTC] Request URI: /zcadmin/configuration.php?gID=31&cID=547&action=edit, IP address: 172.93.102.178
#1 call_user_func() called at [/home/soft/public_html/XXXXXXXXXXX.com/zcadmin/includes/functions/general.php:1800]
#2 zen_call_function() called at [/home/soft/public_html/XXXXXXXXXXX.com/zcadmin/configuration.php:129]

[31-May-2016 17:22:11 UTC] PHP Warning: call_user_func() expects parameter 1 to be a valid callback, function 'zen_cfg_select_option(array('true', 'false'),' not found or invalid function name in /home/soft/public_html/XXXXXXXXXXX.com/zcadmin/includes/functions/general.php on line 1800
[31-May-2016 17:22:11 UTC] Request URI: /zcadmin/configuration.php?gID=31&cID=547&action=edit, IP address: 172.93.102.178
#1 call_user_func() called at [/home/soft/public_html/XXXXXXXXXXX.com/zcadmin/includes/functions/general.php:1800]
#2 zen_call_function() called at [/home/soft/public_html/XXXXXXXXXXX.com/zcadmin/configuration.php:129]

[31-May-2016 17:22:11 UTC] PHP Warning: call_user_func() expects parameter 1 to be a valid callback, function 'zen_cfg_select_option(array('true', 'false'),' not found or invalid function name in /home/soft/public_html/XXXXXXXXXXX.com/zcadmin/includes/functions/general.php on line 1800

---

Assuming that zcadmin is not your actual admin directory (if it is, suggest changing it), if you goto your configuration for EP4, what are your current settings for uploads Directory and Uploads Directory Admin/catalog? With regards to the first, does the path include the name of your admin directory (that's the real question.)?

Also does your admin/includes/functions/extra_functions/easypopulate_4_functions.php include both:
function ep4_directory_check and
function ep4_directory_choice_check?

And what version of EP4 do you have installed as obtained from?

Quote:

---

Originally Posted by mc12345678

Assuming that zcadmin is not your actual admin directory (if it is, suggest changing it), if you goto your configuration for EP4, what are your current settings for uploads Directory and Uploads Directory Admin/catalog? With regards to the first, does the path include the name of your admin directory (that's the real question.)?

Also does your admin/includes/functions/extra_functions/easypopulate_4_functions.php include both:
function ep4_directory_check and
function ep4_directory_choice_check?

And what version of EP4 do you have installed as obtained from?

---

thank you for your fast reply. it seems it has solved itself after reuploading the easypopulate? I looked again in the logs errors and saw that easypopulate_4_import.php was ending abruptly.

If anyone is faced with this issue, maybe it finds useful the reupload solution and looking again in the logs to see if there will be any more errors.

Quote:

---

Originally Posted by RonaldNavarro689

thank you for your fast reply. it seems it has solved itself after reuploading the easypopulate? I looked again in the logs errors and saw that easypopulate_4_import.php was ending abruptly.

If anyone is faced with this issue, maybe it finds useful the reupload solution and looking again in the logs to see if there will be any more errors.

---

Yes that can often be an issue if errors begin after first uploading the files. Glad that you were able to resolve it.

thanks again for assistance.

Quote:

---

Originally Posted by mc12345678

As to your next step of exporting a sample file. Spot on. Please keep in mind usage as described in the instructions for uploading and also note that there is a patch on the previous page if you are uploading attributes using EP4 version 4.0.35.ZC as downloaded from the ZC site.

---

I can not successfully import detailed attributes.
I applied the patch on the previous page since I'm working with attributes using EP4 version 4.0.35.ZC as downloaded from the ZC site, by adding the 4 instances of the colon to easypopulate_4_attrib.php.

Background
I thought I would use EP4 to export products from an existing Zen Cart store v1.54 and try importing them into a freshly installed empty ZC v.1.55a store.

I exported 3 files.

File 1. I exported using Filterable Exports: Download Type = Complete Products and left the other parameters (i.e, Categories, Manufactures, Status) at their default (I assume that's the way to get everything).
Full-EP2016May31-220237.csv

File 2. I exported using Attribute Export/Import Options
Basic Products Attributes (basic single-line)
Attrib-Basic-EP2016May31-221112.csv

File 3. I exported using Attribute Export/Import Options
Detailed Products Attributes (detailed multi-line)
Attrib-Detailed-EP2016May31-221156.csv


I uploaded the 3 files into the new empty ZC v1.55a store using "Upload EP File", Browse, Upload. The files then automagically appeared under the apparently appropriate EP4 admin File Name sections . . .

File 1. This contains any other file. They will be processed like the upload of a full data file.
Full-EP2016May31-220237.csv

File 2. Prefix: attrib-basic-ep. It will be processed through the Basic Attribute filters.
Attrib-Basic-EP2016May31-221112.csv

File 3. Prefix: attrib-detailed-ep. It will be processed through the Detailed Attributes filters.
Attrib-Detailed-EP2016May31-221156.csv

I then attempted to Import the 3 files by clicking on their associated Import buttons.

File 1 seems to have worked fine . . .
Updated records: 171
New Imported records: 148
Errors Detected: 0
Warnings Detected: 0

File 2 seems to have worked reasonably well . . .
Updated records: 28
New Imported records: 839
Errors Detected: 161
Warnings Detected: 0

File 3 will not import nor update anything into the store . . . What am I doing wrong?
Filename: Attrib-Detailed-EP2016May31-221156.csv

SKIPPED! - Attribute Entry on : - Not Found!
.
.
SKIPPED! - Attribute Entry on : - Not Found!
Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 5156
Warnings Detected: 0
Memory Usage: 1267824
Memory Peak: 2011576
Execution Time: 4 seconds.


What am I doing wrong? I only get errors and zero Imported and zero Updated records for the Attrib-Detailed-EP file.

So, besides that the error notification needs a touch up, the issue comes down to this. It would appear that the transfer of detailed attributes from one store to another is not as robust as the remaining aspects. But one can with some manual data management make the transition.

See, the data used by EP4 on import of the detailed attribute file is directly related to the database assigned designations. This is likely to be different in one store when compared to another.

So in one store where the products_id is 10, in the other it may be 15. Then the attributes parts may also each have their own unique/different designation.

Thus when uploading the detailed attributes file, if the four pieces of information used to identify the specific attribute, then the attribute is considered not found and no update is performed. This is an update evolution not an insert (other than it will insert download file information if otherwise not pre-existing).

So, in order to do such a database to database transfer (which really it is still suggested to use the standard upgrade/store transfer process instead), the previous two files need to be used in addition to a current export of the detailed file of the current store in order to modify all of the identifying characteristics of the original detailed file in order for all of the key aspects to line up with the desired change(s). Some of this could have been made "easier" if the products_id was used as the primary key (making a "mirror" of the existing site) but still would have required modification of a few of the other attribute portions.

Doable, but currently a pain...