EasyPopulate 4.0 Support Thread

hzha:

Here is the previous discussion on my issue.
http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread/page159

You identified the issue is A URI rewriter incorrectly modified includes/classes/db/mysql/query_factory.php for ZC 1.5.3 in your post http://www.zen-cart.com/showthread.php?214190-Parts-Of-My-Store-Have-Stopped-Working

and stellarweb has a walk around in his post #1620.
http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread/page161

I am wondering what is the best way to resolve this issue. Thank you.

As I recall from the communication, a separate work-around was determined; however, in parallel I had worked on making the existing software "compatible" with 1.5.3. I did no testing for operations sake. I only had brought the code up-to-date to not to supposedly create the same errors. I will post the code in the Ultimate SEO URI thread. I believe it is not a complete set of software, but only the changes to the original software. As I stated in one of those post threads, a version of the URI rewriter is in a test status which I would fully consider the attached code as being. Truly the issue is with USU and should be addressed in that thread, it just happens to be observed when using this software.

See post 733 for the files that may resolve this issue when using Ultimate SEO URIs version 2.212.

Using Zencart 1.53.... And Easy Populate 4

The manufacturer of my products has expressly set up the data file for Easy Populate and suggests using the program. The columns are all set up like the columns in Easy Populate. Since there are like 2000 products, I have uploaded a test csv file of about 6-8 products. I browsed for the test file in easy populate on my hard drive, then clicked the upload buttom. Easy Populate says file was uploaded successfully at the top. The test csv file appears at the bottom of the page in Easy Populate. So my question is: how does the products populate the store. Do they come in automatically or am I supposed to click something that says - populate or something.

msbfrnj:

Using Zencart 1.53.... And Easy Populate 4

The manufacturer of my products has expressly set up the data file for Easy Populate and suggests using the program. The columns are all set up like the columns in Easy Populate. Since there are like 2000 products, I have uploaded a test csv file of about 6-8 products. I browsed for the test file in easy populate on my hard drive, then clicked the upload buttom. Easy Populate says file was uploaded successfully at the top. The test csv file appears at the bottom of the page in Easy Populate. So my question is: how does the products populate the store. Do they come in automatically or am I supposed to click something that says - populate or something.

Once the fileis identified as being in the file directory for EP4, adjacent to the filename is an option of import. EP4 will process the file as applicable for it's name/prefix. Essentially matching the file name for an uploaded file to the filenamme of a downloaded/exported file to include all of the letters up to the date will ensure that the file will be processed as "desired".

Ie: export file example Full-EP2013Jul09-073801.csv could be downloaded, modified then saved as Full-EP.csv and would still be functional/available for EP4 to process as a file for Full details to be modified.

All of what you said has happened. I have browsed for the correctly set up test csv file. Uploaded it with the upload button.
The browsed for file then appeared next to the browse button. Next to the browse button is the upload button. I then click that. Momentarily after that.... A message appears at the top of the page saying file uploaded successfully. THEN... I did see the import button at the bottom of the screen. I click that. A message immediately appears at the top of the page stating - file imported successfully. I then go to "online catalog" and nothing is there!

Are you saying that I should download one of the default data files that EP puts out....put my data in it and then re-up load it.... Then it will populate. I know..... you are allowed to scream at me if you want.... But I don't get it... :( Could someone just look at it for me please.....

Humbly submitted,
Brenda

msbfrnj:

All of what you said has happened. I have browsed for the correctly set up test csv file. Uploaded it with the upload button.
The browsed for file then appeared next to the browse button. Next to the browse button is the upload button. I then click that. Momentarily after that.... A message appears at the top of the page saying file uploaded successfully. THEN... I did see the import button at the bottom of the screen. I click that. A message immediately appears at the top of the page stating - file imported successfully. I then go to "online catalog" and nothing is there!

Are you saying that I should download one of the default data files that EP puts out....put my data in it and then re-up load it.... Then it will populate. I know..... you are allowed to scream at me if you want.... But I don't get it... :( Could someone just look at it for me please.....

Humbly submitted,
Brenda

No hootin' and hollarin' going on over here, except for the typical Saturday shenanigans. Your second paragraph sums it up exactly. You can add more to the filename if you wish to not replace the previous file and still have it available if a mistake is made.

Additionally, for the first one or two, recommend not adding fields to the file(s) until seems to work. (Ie. One step at a time. )

I've been using EP4 for a while now, great utility.

I've just uploaded a new line of products where the quantity is implied, and so I want to turn the off the Quantity box in the product listing. Is there a way to toggle the Products Quantity Box Shows option in the products listing using EP4?

Many thanks for any suggestions

John

jrobbo:

I've been using EP4 for a while now, great utility.

I've just uploaded a new line of products where the quantity is implied, and so I want to turn the off the Quantity box in the product listing. Is there a way to toggle the Products Quantity Box Shows option in the products listing using EP4?

Many thanks for any suggestions

John

Not by default, but it is easy to add...

In the admin->configuration->Easy Populate 4 there is a field (User defined products fields) to add additional fields for export/import. Fields associated with the products table can be added into this list. The fields should be identified as they appear in the products table separated by commas only (for more than one field). So for this case, if the products_qty_box_status field is listed then when it is set to zero (0) it appears that the option to choose a quantity for a product will be prevented.

One of those things that not everyone uses, so it seems that it was left off as a default like option, but is something still possible.

Well that turned out to be a whole lot easier than I thought it was going to be! Thanks very much @mc123456578 for the excellent reply, works like a charm.

Cheers

John

jrobbo:

Well that turned out to be a whole lot easier than I thought it was going to be! Thanks very much @mc123456578 for the excellent reply, works like a charm.

Cheers

John

Quite welcome, wouldn't have been possible without the rework done by chadderuski, all of the feedback of the users and the work of those leading up to this. :)

looking at installing this, hoping to bring 1.3.9 products into a 1.5.3 store. Is there a summary of the steps or do I need to read 169 pages ?

johnniejetski:

looking at installing this, hoping to bring 1.3.9 products into a 1.5.3 store. Is there a summary of the steps or do I need to read 169 pages ?

On a quick search, this is something I found, but if you still have the 1.3.9 database, then there is a zc process to import products other than using EP4 to import. It will work, but may not be the preferred method. http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1251347#post1251347

There's other occurrences of such a summary; however, I have not given the search time to find it...

mc12345678:

As I recall from the communication, a separate work-around was determined; however, in parallel I had worked on making the existing software "compatible" with 1.5.3. I did no testing for operations sake. I only had brought the code up-to-date to not to supposedly create the same errors. I will post the code in the Ultimate SEO URI thread. I believe it is not a complete set of software, but only the changes to the original software. As I stated in one of those post threads, a version of the URI rewriter is in a test status which I would fully consider the attached code as being. Truly the issue is with USU and should be addressed in that thread, it just happens to be observed when using this software.

See post 733 for the files that may resolve this issue when using Ultimate SEO URIs version 2.212.

Truly the issue is NOT with USU. I have been using USU (2.212) under Zen Cart 1.5.3 (by following the instructions in the manual and in the support forum) without issue.

The issue's I have seen reported in this thread (and on the USU thread) appears to be caused install errors.. Namely replacing Zen Cart 1.5.3 files with files from USUS which are modified versions of files for PREVIOUS versions of Zen Cart. The manual for USU like most well written modules says to use / merge the modified core files matching the installed version of Zen Cart. The issues reported seem to crop up when that advice isn't followed..

The current stable release of USU was released BEFORE the Zen Cart 1.5.2 release. As such it does not include core files from Zen Cart 1.5.2+ pre-modified and ready to go for end users. The support thread DOES include some examples of modified core Zen Cart files from Zen Cart 1.5.2 RC2. The support thread also includes some additional information relating to the use of USU in Zen Cart 1.5.2 and 1.5.3.

THE ANSWER for people having difficulties with USU is to head over to the USU support thread.. Suggest these folks checkout the relevant posts - in this case #555, #706, and #717. The author is talented and FULLY supports his module..

OR

Folks can wait for the next version of USU (which is in beta testing now) to be released in a few weeks.. It will have all of the FULLY MODIFIED files Zen Cart v1.5.3 files so people who don't bother to merge (as suggested in the readme) can simply just drag and drop to their hearts content..

FYI, uploaded a revision to EP4 that includes some compatibility with potteryhouse's version of Stock By Attributes (SBA) (in particular the customid). This is an expansion of capability that was previously included with an older version of SBA (compatibility with which still exists). A pull request has been made to incorporate the change into the version available from the first post of this thread.

In the mean time, if interested in testing this, please see:
https://github.com/mc12345678/EasyPopulate-4.0

Look for the "ZIP" button to download. To install, upload all files to your admin directory maintaining directory structure.
Also upload the additional files for your version of Zencart - be sure to put thes in their correct folder.

Or can download it directly from: https://github.com/mc12345678/EasyPopulate-4.0/archive/master.zip

Is it possible to assign the sort order of categories using EP4? I currently populate all of my categories using the CategoryMeta file, but I can't find a way of assigning the sort order

Thanks in advance for any suggestions

Kind Regards

John

jrobbo:

Is it possible to assign the sort order of categories using EP4? I currently populate all of my categories using the CategoryMeta file, but I can't find a way of assigning the sort order

Thanks in advance for any suggestions

Kind Regards

John

Category specific information should be available through the category export/import. I think that was also discussed within the last couple of pages or so as well.

mc12345678:

Category specific information should be available through the category export/import. I think that was also discussed within the last couple of pages or so as well.

I went back 15 pages but was not able to find any relevant info.

I am using the Full Category export and import features to update my category meta data, but there is no field in either of the category import/export files to specify the category sort-order. Is there any way to add that field please?

John

jrobbo:

I went back 15 pages but was not able to find any relevant info.

I am using the Full Category export and import features to update my category meta data, but there is no field in either of the category import/export files to specify the category sort-order. Is there any way to add that field please?

John

Will look into this later today.

mc12345678:

Will look into this later today.

Thanks very much MC, I apprectae your efforts

Cheers

John

jrobbo:

I went back 15 pages but was not able to find any relevant info.

I am using the Full Category export and import features to update my category meta data, but there is no field in either of the category import/export files to specify the category sort-order. Is there any way to add that field please?

John

Update 4.0.26 has been loaded to https://github.com/mc12345678/EasyPopulate-4.0 with a pull request to https://github.com/chaddro/EasyPopulate-4.0. Follow the same process as identified in post 1 of this thread; however, until merged use the first link above. Category sort_order information is loaded to and from the Categories Only (with Metatags) option.

Is the 4.0.26 compatible with ZC 1.5.1? or it is for 1.5.3 only?