EasyPopulate 4.0 Support Thread

Quote:

---

Originally Posted by ma.r.a

Please help.

Easy Populate 4.0.39.ZC, Zen Cart v1.5.7d, PHP Version 7.4

I can't import products that are in a subcategory.

Import Results
"Error: Unbalanced Categories defined in:"

Thanks.
Attachment 20556

---

Unfortunate that this is occurring on your site. While a product being placed in a subcategory is a characteristic needed for it to occur, there is more information needed. Specifically, this is expected to be a possible condition for a store having or trying to have more than one language.

Next, the concern being addressed by the messaging is that the product is not being placed in the same tree position across languages. I suspect such a situation may be "normal" to try to do, but things I have seen about the configuration of categories within the store is that there is category that has multiple language assignments and then product at the last category of a branch and no category is to have a product and category within it. With that set of "requirements", even if a store owner wants to display categories in groups more appropriate to one language than another, there are limitations applied (it seems) to prevent such.

Anyways, could you please identify how many languages you have in your store, then perhaps give (example) data from the header and first row of your import file? Exact data can be changed, but at least show format, sequence, that sort of thing. Then when there are multiple database languages, the thought/concern is with the field data being imported.

Thank you for your advice.
I turned off the second language. The file is importing correctly now.

Thank you for your advice.
I turned off the second language. The file is importing correctly now.

Quote:

---

Originally Posted by ma.r.a

Thank you for your advice.
I turned off the second language. The file is importing correctly now.

---

Would you mind showing the first row of what the file looked like that was causing the issue? Generally speaking my intention was to allow Import to a multilingual database, though I wonder to what extent I limited such and furthermore to what extent that is expected or required. E.g., in language 1 a product is in cat1^cat1_1 in language 2 though in cat1^cat1_2 instead.

Reason I perceive the problem occurred is that in assignment or reassignment to another language is that if the category exists in both languages but is only referenced in the one then a search is not performed to push it to both languages. But, I await further information to try to resolve the issue identified.

dear mc12345678

,
i can not find it on the search, but when can we safely use easy pop on version 2?
many greetings

Quote:

---

Originally Posted by kernheimer

dear mc12345678

,
i can not find it on the search, but when can we safely use easy pop on version 2?
many greetings

---

If you're OK with the files being installed like they have been until recently, the github latest version is reported to work with version 2.0. If you're hard set on installation via the zc_plugins directory, I've been advised that the installation process on version 2.0 needs some minor massaging to accommodate changes made in the zc_plugins process.

Beyond that, I don't have a specific time especially if I find issues with the latest of the v2 code now that it has been released.

thank you so much ( again!)

Morning,

Zen Cart 1.5.8
PHP 7.4
MySQL 8.0.36

Code:

---

[29-Apr-2024 05:31:30 UTC] Request URI: /index.php?cPath=330_331_377&main_page=product_info&products_id=3772, IP address: 111.111.111.111
#1  trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2  queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3  queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4  queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5  zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6  zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7  zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8  require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9  require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
            SET products_price_sorter=''
            WHERE products_id=1530 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

---

Quote:

---

Originally Posted by mprough

Morning,

Zen Cart 1.5.8
PHP 7.4
MySQL 8.0.36

Code:

---

[29-Apr-2024 05:31:30 UTC] Request URI: /index.php?cPath=330_331_377&main_page=product_info&products_id=3772, IP address: 111.111.111.111
#1  trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2  queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3  queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4  queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5  zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6  zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7  zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8  require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9  require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
            SET products_price_sorter=''
            WHERE products_id=1530 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

---

---

Didn't realize I missed the text =O

This error is logging for all products... I suspect it might be an issue from EP or DBIO

Code:

---

[30-Apr-2024 05:38:21 UTC] Request URI: /index.php?cPath=77_128&main_page=product_info&products_id=3168, IP address: 11.11.11.11
#1  trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2  queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3  queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4  queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5  zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6  zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7  zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8  require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9  require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
            SET products_price_sorter=''
            WHERE products_id=4870 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

---

The decimal value stored in the DB is correct.

Easy Populate 4.0.39.ZC - 03-17-2023
Database I/O (DbIo) Manager v2.0.0-beta3 (2023-01-02)

~Melanie

Quote:

---

Originally Posted by mprough

Didn't realize I missed the text =O

This error is logging for all products... I suspect it might be an issue from EP or DBIO

Code:

---

[30-Apr-2024 05:38:21 UTC] Request URI: /index.php?cPath=77_128&main_page=product_info&products_id=3168, IP address: 11.11.11.11
#1  trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2  queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3  queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4  queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5  zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6  zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7  zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8  require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9  require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
            SET products_price_sorter=''
            WHERE products_id=4870 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.

---

The decimal value stored in the DB is correct.

Easy Populate 4.0.39.ZC - 03-17-2023
Database I/O (DbIo) Manager v2.0.0-beta3 (2023-01-02)

~Melanie

---

Might want to confirm the version of your includes/functions/functions_prices.php file against a new or original 1.5.8 version. Line numbers are not aligning at least with: https://github.com/zencart/zencart/b...ons_prices.php

Further I'm not yet seeing in that version of the file where an empty string would make its way back. I didn't do a comparison though between the v158 branch and the v1.5.8 breaks with also knowing that there was a sub version issued.

While I've found some other Zen Cart functions that don't handle a missing record sufficiently, this area may be one of them, but I don't really see how either tool could cause the described issue of the database field contains information on the correct format.

Quote:

---

Originally Posted by mc12345678

Might want to confirm the version of your includes/functions/functions_prices.php file against a new or original 1.5.8 version. Line numbers are not aligning at least with: https://github.com/zencart/zencart/b...ons_prices.php

Further I'm not yet seeing in that version of the file where an empty string would make its way back. I didn't do a comparison though between the v158 branch and the v1.5.8 breaks with also knowing that there was a sub version issued.

While I've found some other Zen Cart functions that don't handle a missing record sufficiently, this area may be one of them, but I don't really see how either tool could cause the described issue of the database field contains information on the correct format.

---

File version is * @version $Id: Scott C Wilson 2022 May 26 Modified in v1.5.8-alpha $ and it's the original installed file, untouched for over a year. File comparison with stock fresh file from 1.5.8 is identical. The one you posted that didn't line up is 1.5.8a.

The 1.5.8a file has a few code differences from 1.5.8.

Noting also that the what caught my attention originally is how slow the admin is. Front end is fast and fine.

I switched to the 1.5.8a file which seems to stop the logged error... However, the admin remains slow.

~Melanie

I am doing a clean install of 2.0.0 and my old 1.5.7c (thought it was d but that is wrong lol). I have the following KEYS listed in the database. Do I need to remove these before upgrading? I would rather get this all working right and just installing a new EP after.

Attachment 20601

ZC 2.0.0
Easy Populate 4.0.37.13 - 05-03-2021

Getting the following debug log file. Also, while the date on the code above says 5/3/2021, it was downloaded only 3 days ago.

Code:

---

[31-May-2024 10:44:32 UTC] Request URI: /fLash-SUC-snaCk/index.php?cmd=easypopulate_4, IP address: ::1, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\includes\header.php(71): trigger_error()
#2 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\easypopulate_4.php(646): require('C:\\wamp64\\www\\W...')
#3 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\index.php(11): require('C:\\wamp64\\www\\W...')
--> PHP Deprecated: This page requires updates for the next Zen Cart version. Please refer your site developer or plugin author to <a href="https://docs.zen-cart.com/dev/plugins/admin_head_content/" rel="noopener noreferrer" target="_blank">this</a> documentation. in C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\includes\header.php on line 71.

---

Quote:

---

Originally Posted by g2ktcf

ZC 2.0.0
Easy Populate 4.0.37.13 - 05-03-2021

Getting the following debug log file. Also, while the date on the code above says 5/3/2021, it was downloaded only 3 days ago.

Code:

---

[31-May-2024 10:44:32 UTC] Request URI: /fLash-SUC-snaCk/index.php?cmd=easypopulate_4, IP address: ::1, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\includes\header.php(71): trigger_error()
#2 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\easypopulate_4.php(646): require('C:\\wamp64\\www\\W...')
#3 C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\index.php(11): require('C:\\wamp64\\www\\W...')
--> PHP Deprecated: This page requires updates for the next Zen Cart version. Please refer your site developer or plugin author to <a href="https://docs.zen-cart.com/dev/plugins/admin_head_content/" rel="noopener noreferrer" target="_blank">this</a> documentation. in C:\wamp64\www\WLC_Artistry_158a\fLash-SUC-snaCk\includes\header.php on line 71.

---

---

Thanks for the report, will seek updating the page's header to incorporate that direction. Note that the log is expected to be generated once per session until resolved.

Quote:

---

Originally Posted by g2ktcf

I am doing a clean install of 2.0.0 and my old 1.5.7c (thought it was d but that is wrong lol). I have the following KEYS listed in the database. Do I need to remove these before upgrading? I would rather get this all working right and just installing a new EP after.

Attachment 20601

---

Thought I had responded to this, but it is obvious I did not. Not sure how just throw two keys remained in the database. I would have expected that an uninstall at the version that added them or beyond would have also removed them. Further without reviewing the installation steps, I'm not sure if or what issues might occur (e.g., other settings get loaded but to a different configuration menu, log generated because of attempted duplicate).

I do see though that you've reported performing a clean install, so this serves more of an acknowledgement to the question. I would have removed those two additional remnants before attempting a (re)install and investigated why they remained or were present.

Oh, and your database may have been 1.5.7d because issue of that version didn't actually update the version designation. File comparison would have been best to validate.

Quote:

---

Originally Posted by mc12345678

Thought I had responded to this, but it is obvious I did not. Not sure how just throw two keys remained in the database. I would have expected that an uninstall at the version that added them or beyond would have also removed them. Further without reviewing the installation steps, I'm not sure if or what issues might occur (e.g., other settings get loaded but to a different configuration menu, log generated because of attempted duplicate).

I do see though that you've reported performing a clean install, so this serves more of an acknowledgement to the question. I would have removed those two additional remnants before attempting a (re)install and investigated why they remained or were present.

Oh, and your database may have been 1.5.7d because issue of that version didn't actually update the version designation. File comparison would have been best to validate.

---

I did a database only upgrade on a test site at my host this morning. So, I have a native 2.0.1 install without all the old files. After installing Mod List I worked to find all the outdated configuration keys and pages. I found WAY more than those 2 for some odd reason this time. Mod List now shows only what is installed so I am making progress.

Thanks!

Zen Cart 1.5.6
Easy Populate 4.0.36.ZC
PHP versions tried 5.6, 7.1, 7.3
MySQL 8.0.37

Having a very strange problem, when I upload my products file, EP says it has been imported successfully, it spits out all the products in green in the list at the bottom and says they have all been created correctly, but in reality I only have one product visible on the website, it contains the Product Model, Image, Price & Min Order Quantity, from the product in the first row of the CSV, and the rest of the details (Name & Description) are populated from the product in the final row of the CSV file. The product has been added to every category that is listed in the Category column, so if I have 100 products across 20 categories, I am ending up with one product visible in 20 categories.

If I actually look in the MySQL database at the Products table, all the products are there. If I look at the Product Description table, the products are absent with the exception of the one product from the final row that it puilled the description from. The product ID is the product ID from the product that was in the first row of the CSV file.

Importantly, if I export the existing products on the site using EP, delete them all using EP, and then reupload the file I exported, it works properly and imports all the products correctly.

I have tried every version of UTF I can think of, using Notepad++ to convert to UTF8, nothing has worked so far. I have also tried uploading the file with double quotes around every value (matching how the EP export files look), but this does not work either.

I have not touched the site or EP version in a few years, this has started happening recently seemingly spontaneously. I know the host has upgraded the MySQL to version 8 recently. The PHP version changes sometimes, but I have tried reverting to multiple older versions with no luck. I have also tried uploading last year's data file, which worked last year, but this presents with the same problems.

So I started a new clean install of ZC 2.0.1

I have removed all the legacy configurations from the database and installed EP 4.0

I am getting the warning about opening the log file. However, the configuration EAYPOPULATE_4_CONFIG_TEMP_DIR does not exist. AND, there is no Easy Populate in the configuration menu. I have verified that all the files from Github did copy over.

If I try and load the Easy Populate Tools, I get a 500 error. Thoughts?

Quote:

---

Originally Posted by g2ktcf

So I started a new clean install of ZC 2.0.1

I have removed all the legacy configurations from the database and installed EP 4.0

I am getting the warning about opening the log file. However, the configuration EAYPOPULATE_4_CONFIG_TEMP_DIR does not exist. AND, there is no Easy Populate in the configuration menu. I have verified that all the files from Github did copy over.

If I try and load the Easy Populate Tools, I get a 500 error. Thoughts?

---

I have found zero logs for this. I have looked through ZC's logs and the only thing there is the debug log related to not finding the temp directory. The server error logs show ZERO errors.

ZC 2.0.1 Database only upgrade
Mod List
Image Handler
Bootstrap
Clone a Template
OPC

this is hosted on a sandbox server where the site address is site.host.com if that makes any difference. This is my last full test before going live.

Quote:

---

Originally Posted by Pingfah

Zen Cart 1.5.6
Easy Populate 4.0.36.ZC
PHP versions tried 5.6, 7.1, 7.3
MySQL 8.0.37

Having a very strange problem, when I upload my products file, EP says it has been imported successfully, it spits out all the products in green in the list at the bottom and says they have all been created correctly, but in reality I only have one product visible on the website, it contains the Product Model, Image, Price & Min Order Quantity, from the product in the first row of the CSV, and the rest of the details (Name & Description) are populated from the product in the final row of the CSV file. The product has been added to every category that is listed in the Category column, so if I have 100 products across 20 categories, I am ending up with one product visible in 20 categories.

If I actually look in the MySQL database at the Products table, all the products are there. If I look at the Product Description table, the products are absent with the exception of the one product from the final row that it puilled the description from. The product ID is the product ID from the product that was in the first row of the CSV file.

Importantly, if I export the existing products on the site using EP, delete them all using EP, and then reupload the file I exported, it works properly and imports all the products correctly.

I have tried every version of UTF I can think of, using Notepad++ to convert to UTF8, nothing has worked so far. I have also tried uploading the file with double quotes around every value (matching how the EP export files look), but this does not work either.

I have not touched the site or EP version in a few years, this has started happening recently seemingly spontaneously. I know the host has upgraded the MySQL to version 8 recently. The PHP version changes sometimes, but I have tried reverting to multiple older versions with no luck. I have also tried uploading last year's data file, which worked last year, but this presents with the same problems.

---

I am unable to edit the post now, but I should add that if I switch to Product ID as the primary key, all these problems go away.

All CSV files have been created in Open Office with recommended settings.

PHP 8.3.27 / ZC 2.0.1 / Easy Populate 4.0.39.ZC

After struggling through some errors and a lot of hunt and pecking while trying to patch those, I managed to get this mod to finally work with ZenCart 2.0.1.

Just a few questions:
1. is the EasyPopulate SBA modification supposed to create new combinations for inventorying? Is there a way to do so?
2. Is this the most recent version of Easy Populate to use? I couldn't keep track on the Git Hub repository.

Quote:

---

Originally Posted by retched

PHP 8.3.27 / ZC 2.0.1 / Easy Populate 4.0.39.ZC

After struggling through some errors and a lot of hunt and pecking while trying to patch those, I managed to get this mod to finally work with ZenCart 2.0.1.

Just a few questions:
1. is the EasyPopulate SBA modification supposed to create new combinations for inventorying? Is there a way to do so?
2. Is this the most recent version of Easy Populate to use? I couldn't keep track on the Git Hub repository.

---

Could really be helpful to identify what errored and/or needed patching in association with EP4. Forgive me, but the above makes it seem (right or wrong) that all of the issues experienced in association with ZC 2.0.1 were only issues with EP4 v4.0.39.ZC. Would like to address any that exist.

In answer to the questions:
1. Effort has not been put forth to address the necessary complication of generating new SBA combinations through file upload based on what would be needed to import a new combination containing characteristics that do not yet exist and how easy an existing combination could get destroyed/improperly updated with that same set of considerations/concerns. If this is in relation to the previous query created to "import"/generate combinations for newly added product each with an attribute that do not yet have a combination, mind you, whatever problem was experienced (which I didn't see a proper explanation of why the particular issues existed) the query was still sound and could be executed outside of each of these applications.

2. Yes, 4.0.39.ZC is the most recent version to push for all to use. There were a LOT of changes made and while I attempt to test series of combinations and possibilities, I do not believe I can test every possibility, which brings me back to the above, if the issue(s) are EP4 related, let's fix them. If they are/were from something else, then please clear the air.

Quote:

---

Originally Posted by Pingfah

I am unable to edit the post now, but I should add that if I switch to Product ID as the primary key, all these problems go away.

All CSV files have been created in Open Office with recommended settings.

---

Well, a couple of things.

First, apologies that 4.0.36 did not include some of the "error" checking that would likely have helped identify that using the products_id as a primary key may have been necessary (as compared to desired?).

There have been newer versions generated to address/correct the lack of the primary key value/data being present along with some other notifications so that do not have a false positive of success.

One thing that I didn't ask for was, what field headers were present in the file having an issue as compared to one that didn't. Then another was if the new file had unescaped special characters that possibly could have affected the import evaluation.

That it seems that no changes what-so-ever were made in the underlying code or the import file (meaning same ZC version, same EP4 version, same previous import file) seems to mean that either MySQL version and/or PHP version changed to a value affecting the code operation. Suggestion might be to compare two CSV files, the working and not working one(s) to see what other differences might exist causing the issue of basically the product table data getting imported to the correct area(s), but the products description table seems to only take the description (and therefore things like products_name) only were imported basically against the last product. To me, that aligns more with the issue of missing data associated with the chosen primary key or that all those affected have the same primary_key value.

Glad though that it seems a fix was found. As far as a log, generally, if EP4 logging is turned on, then a log that might get generated assuming a loggable event occurred would be in the debug log in the EP4 import/export file directory or added to it if it already existed.

Quote:

---

Originally Posted by mc12345678

Could really be helpful to identify what errored and/or needed patching in association with EP4. Forgive me, but the above makes it seem (right or wrong) that all of the issues experienced in association with ZC 2.0.1 were only issues with EP4 v4.0.39.ZC. Would like to address any that exist.

In answer to the questions:
1. Effort has not been put forth to address the necessary complication of generating new SBA combinations through file upload based on what would be needed to import a new combination containing characteristics that do not yet exist and how easy an existing combination could get destroyed/improperly updated with that same set of considerations/concerns. If this is in relation to the previous query created to "import"/generate combinations for newly added product each with an attribute that do not yet have a combination, mind you, whatever problem was experienced (which I didn't see a proper explanation of why the particular issues existed) the query was still sound and could be executed outside of each of these applications.

2. Yes, 4.0.39.ZC is the most recent version to push for all to use. There were a LOT of changes made and while I attempt to test series of combinations and possibilities, I do not believe I can test every possibility, which brings me back to the above, if the issue(s) are EP4 related, let's fix them. If they are/were from something else, then please clear the air.

---

With regards to the first, that is absolutely fine with regards to SBA. I thought I was doing something wrong and it wasn't generating the desired changes.

A lot of it was bandaid patching up (a big one was bad MYSQL code in easypopulate_4_filelayout.php and PHP 8's change to strformat (ie. if you provide arguments in the string, but only provide one, there is a fatal error thrown. One such error exists in the language file and it breaks from there.). I can certainly provide the changes I did, and will send a Git Fork/MR as soon as I can settle down on it. Most of the errors were caused by the export functions.

Quote:

---

Originally Posted by mc12345678

Could really be helpful to identify what errored and/or needed patching in association with EP4. Forgive me, but the above makes it seem (right or wrong) that all of the issues experienced in association with ZC 2.0.1 were only issues with EP4 v4.0.39.ZC. Would like to address any that exist.

In answer to the questions:
1. Effort has not been put forth to address the necessary complication of generating new SBA combinations through file upload based on what would be needed to import a new combination containing characteristics that do not yet exist and how easy an existing combination could get destroyed/improperly updated with that same set of considerations/concerns. If this is in relation to the previous query created to "import"/generate combinations for newly added product each with an attribute that do not yet have a combination, mind you, whatever problem was experienced (which I didn't see a proper explanation of why the particular issues existed) the query was still sound and could be executed outside of each of these applications.

2. Yes, 4.0.39.ZC is the most recent version to push for all to use. There were a LOT of changes made and while I attempt to test series of combinations and possibilities, I do not believe I can test every possibility, which brings me back to the above, if the issue(s) are EP4 related, let's fix them. If they are/were from something else, then please clear the air.

---

I noticed you mentioned 4.0.39 is available. I am using 2.0.1V of ZC. I checked GitHub and the latest I found is 4.037.13. Would you mind sharing where I can find the 4.039? Also, any idea if SBA import/export will be available in the future for the newer release particularly to work w/ v2.0.1 of ZC? Thanks.

Quote:

---

Originally Posted by chuckrey

I noticed you mentioned 4.0.39 is available. I am using 2.0.1V of ZC. I checked GitHub and the latest I found is 4.037.13. Would you mind sharing where I can find the 4.039? Also, any idea if SBA import/export will be available in the future for the newer release particularly to work w/ v2.0.1 of ZC? Thanks.

---

Link is provided in post 3564.

However, it is also provided here: https://github.com/mc12345678/EasyPo...ree/v4.0.39.ZC

As for SBA, the intention is for it to still work. It does appear some mistakes were made in changing query formatting and then at least one of my concerns in query formatting/sequencing came to a head at least in the export code. I've created a solution, but trying to figure out the best or right versioning to apply.

Thanks very much. Looking forward to its use.

Quote:

---

Originally Posted by chuckrey

Thanks very much. Looking forward to its use.

---

A few hours ago, uploaded modifications to address issues recently identified:
- SBA export of detailed and basic attributes caused SQL errors in the recent 4.0.39.ZC. One of them had a problem because in reformatting to ANSI style queries, an *AND* did not get moved correctly. In the other query, table relationships may have worked historically, but yes with updated server versions, needed to be reworked plus at least one table alias was incorrectly carried through.
- Also corrected the admin page headers so that if one of the menus from this plugin is the first to trigger the issue, well it won't anymore. BTW, what I'm saying is, understand the code that generates that log does so only once per session no matter how many different admin pages "deserve" the report. To me, it would seem better for the session variable to be unique for each such admin page. Maybe someone else agrees, if so, feel free to take it up with the code maintainers.
- Believe I've corrected/addressed the issues that prevented loading/executing the code to/from the zc_plugins folder, although still have a catalog type folder to load so that can use existing ajax calls rather than creating some new ajax tool.
- I haven't installed an alternate language to be able to maybe correct reported issues with categories not aligning or some similar messaging posted recently. The issue typically occurs or was expected to be reported if a single product in two different languages on a single record was pushed to two different category branch depths. In a way, this was done because it seems that ZC doesn't seem to openly support/encourage product/category trees being completely different in a multiple language store. I wanted to offer some amount of store protection in loading/working multiple languages; however, have only been working theoretically/logically.

All of my testing has been against PHP 8.3.2 and MySql 8.0.28-0ubunto0.20.04.3. to include ZC 2.0.whatever is out right now as none of that really has shown to have an impact on the code.

I would like to put it together for publication to the ZC site, but still seeking any additional feedback on issues so that can try to fix them before committing for the majorities.

I do have some changes in mind (for next sub-version):
I'm working on for import to force/ensure data type "conversion" and checks in association with default values. I haven't fully incorporated it because I'm still identifying some of the expected field default values/data types. I've also started considering how to implement default starting values across product types, though I presume "most" still use just the standard product type or if still in use the book type that was branched off of the code.

Another change to incorporate is the use of notifiers that begin with either NOTIFY_ or NOTIFIER_ so that auto loading could be used. My plan is to "duplicate" each notifier to include the additional NOTIFY_ prefix with each new one to follow the existing one. (E.g. where $zco_notifier->notify('EP4_START'); is used, it will be followed on the next line with $zco_notifier->notify('NOTIFY_EP4_START');)

Hi,

Does anyone know how to export attributes (e.g sizes) based on a category/brand rather than the entire site?

Thanks

Quote:

---

Originally Posted by waterbender

Hi,

Does anyone know how to export attributes (e.g sizes) based on a category/brand rather than the entire site?

Thanks

---

While there remain a couple updates to incorporate to the github.com version, the v4.0.39.ZC branch offers such filtering. One known issue to incorporate a fix for is import of a file not having the v_status field sets the status to off regardless the existing status. I have a fix for that, but need to incorporate into the fileset.

When I export my products, using admin -> tools -> easypopulate4, to a CSV file is there supposed to be a field for the URL for each product?

Please help.

Easy Populate 4.0.38.1, Zen Cart v1.5.7d

I can't import products that are in a subcategory.

Import Results
ADD NEW PRODUCT FAILED! - Model: PT05 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT06 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT07 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT08 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT09 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT10 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT11 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT12 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT13 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT14 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT15 - SQL error. Check Easy Populate error log in uploads directory


Thank you.

Quote:

---

Originally Posted by ma.r.a

Please help.

Easy Populate 4.0.38.1, Zen Cart v1.5.7d

I can't import products that are in a subcategory.

Import Results
ADD NEW PRODUCT FAILED! - Model: PT05 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT06 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT07 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT08 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT09 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT10 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT11 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT12 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT13 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT14 - SQL error. Check Easy Populate error log in uploads directory
ADD NEW PRODUCT FAILED! - Model: PT15 - SQL error. Check Easy Populate error log in uploads directory


Thank you.

---

Can you look to your logs folder and try to include the relevant parts of the ep_debug.log that would be generated with this?

Quote:

---

Originally Posted by kevinmc3

When I export my products, using admin -> tools -> easypopulate4, to a CSV file is there supposed to be a field for the URL for each product?

---

Unless you changed a setting, the URL should belong to "v_products_url" field. But do you mean for compatibility with a SEO rewrite engine, no there's no such field for that innately.

im using 4.0.39 in zen version 2.10 php 8.0 and am getting this error

Code:

---

[10-Dec-2024 07:19:10 America/New_York] PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_SPECIALS_HEADING" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:197
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 197

[10-Dec-2024 07:19:10 America/New_York] Request URI: /Jimmies_Admin/index.php?cmd=easypopulate_4, IP address: 192.168.1.33
--> PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_SPECIALS_HEADING" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:197
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 197.

[10-Dec-2024 07:19:10 America/New_York] Request URI: /Jimmies_Admin/index.php?cmd=easypopulate_4, IP address: 192.168.1.33
--> PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_SPECIALS_HEADING" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:197
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 197.

---

i installed through zc_plugins

changed line to this

Code:

---

$specials_print = defined('EASYPOPULATE_4_SPECIALS_HEADING') ? EASYPOPULATE_4_SPECIALS_HEADING : 'EASYPOPULATE_4_SPECIALS_HEADING';

---

and now getting this error

Code:

---

[10-Dec-2024 07:36:04 America/New_York] PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:331
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 331

[10-Dec-2024 07:36:04 America/New_York] Request URI: /Jimmies_Admin/index.php?cmd=easypopulate_4, IP address: 192.168.1.33
--> PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:331
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 331.

[10-Dec-2024 07:36:04 America/New_York] Request URI: /Jimmies_Admin/index.php?cmd=easypopulate_4, IP address: 192.168.1.33
--> PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:331
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 331.

---

Quote:

---

Originally Posted by jimmie

changed line to this

Code:

---

$specials_print = defined('EASYPOPULATE_4_SPECIALS_HEADING') ? EASYPOPULATE_4_SPECIALS_HEADING : 'EASYPOPULATE_4_SPECIALS_HEADING';

---

and now getting this error

Code:

---

[10-Dec-2024 07:36:04 America/New_York] PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:331
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 331

[10-Dec-2024 07:36:04 America/New_York] Request URI: /Jimmies_Admin/index.php?cmd=easypopulate_4, IP address: 192.168.1.33
--> PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:331
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 331.

[10-Dec-2024 07:36:04 America/New_York] Request URI: /Jimmies_Admin/index.php?cmd=easypopulate_4, IP address: 192.168.1.33
--> PHP Fatal error: Uncaught Error: Undefined constant "EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC" in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php:331
Stack trace:
#0 /Jimmies_Admin/index.php(28): require()
#1 {main}
thrown in /zc_plugins/EasyPopulateV4/v4.0.39.ZC/admin/easypopulate_4.php on line 331.

---

---

Check again to see if you copied over the right language files to the admin folder.

Should have a line like this in /admin/includes/languages/english/extra_definitions/lang.easypopulate_4.php:

PHP Code:

---

  'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC' => 'Product Short Descriptions: ', 


---

it doesnt seem to have installed anything in the admin side it all resides in zc_plugins, but no lang. file in there either
is there more to do than install from plugin manager

The version 4.0.39.ZC in GitHub at https://github.com/mc12345678/EasyPo...ree/v4.0.39.ZC and also linked in #3564 and #3626 is not ready for zc2.1.0

I have never used this plugin before.
I am only testing the plugins files. I had problems with the original language files not loading plus other issues like having to create the temp folder . The new format language files are not in there yet.

I am only part way through my testing. A lang.easypopulate_4.php file may be found in my GitHub at https://github.com/OldNGreyBMR/EasyP...guages/english
if this helps.
ONLY USE THESE FILES IN A TEST ENVIRONMENT

OldNGrey,

I too am having the same issue. This is a big problem for me because this is how i update my products. Does anyone have an alternative solution.

I did some more test to try and solve the issue with the import. Every time i do an import there seems to be missing information etc. Something is really wrong.
This is not a fun problem to have. If anyone has a solution or recommendation please let me know.

Quote:

---

Originally Posted by chadlly2003

I did some more test to try and solve the issue with the import. Every time i do an import there seems to be missing information etc. Something is really wrong.
This is not a fun problem to have. If anyone has a solution or recommendation please let me know.

---

Please provide some details about your system. What version of Zen Cart are you using?
What version of PHP and MySQL is your server using?
What is displayed in the error logs?
What other plugins do you have installed?

As for a solution, you will have to wait until someone updates the plugin.

Did you really put zc2.1.0 into a production environment without testing if all the plugins and options that you have are working correctly?

Zencart 2.1
EasyPopulate-4.0-4.0.39
php 8.2
webserver PHP version: 8.3.14

Not really getting any errors. Its just not importing correctly. And Yes i do have this on a live server. I thought I tested everything. Now I am looking for an alternative solution pulling my hair out of my head. not going to be a fun day

Did u try in your settings to put it on language id

When I go to backend i see Import Language Override. It was set to language_id_only i changed it to language_id and I still got the same results with it not importing correctly

Quote:

---

Does anyone have an alternative solution

---

Just use DBIO. EP has had too many cooks and should be laid to rest.

What is DBI is that a plugin

Come on, we are all DIY-ers here, "Zen Cart DBIO" should be the first reaction/search...

Quote:

---

Originally Posted by chadlly2003

Zencart 2.1
EasyPopulate-4.0-4.0.39
php 8.2
webserver PHP version: 8.3.14

Not really getting any errors. Its just not importing correctly. And Yes i do have this on a live server. I thought I tested everything. Now I am looking for an alternative solution pulling my hair out of my head. not going to be a fun day

---

EasyPopulate-4 is not ready for zc2.1.0 and I don't know if it OK for 2.0.x either.

I agree with Torvista and have installed DBio for my requirements.

zencart 2.1
php 8.2
easy populate 4.0.39

I am trying to unistall ep4. When i click uninstall it just refreshes the page. Anyone know how to remove ep4

Quote:

---

Originally Posted by chadlly2003

zencart 2.1
php 8.2
easy populate 4.0.39

I am trying to unistall ep4. When i click uninstall it just refreshes the page. Anyone know how to remove ep4

---

Have you tried adding ?langer=remove to the end of the URL?

that worked

actually it did not work.

this is what I tried


/index.php?cmd=easypopulate_4?langer=remove
/index.php?cmd=easypopulate_4.php?langer=remove

Just reporting back that EasyPopulate-4.0 from the GitHub works as expected when installed in admin. I used Zc2.1.0; PHP 8.3.4 Mariadb 11.6.2

It it just the /plugins version that still requires some work

Is there a way to have the file exports to sort by date, where the most recent is on top in the table at the bottom?

Quote:

---

Originally Posted by retched

Unless you changed a setting, the URL should belong to "v_products_url" field. But do you mean for compatibility with a SEO rewrite engine, no there's no such field for that innately.

---

There is a configurable option on easy populate to export the URL as would be seen using the Zen Cart function zen_href_link. The v_products_url field is a database field typically having a link to an off-site location to be displayed with the product or creatively used for other reasons such as to retrieve an image or something.

Quote:

---

Originally Posted by djdavedawson

Is there a way to have the file exports to sort by date, where the most recent is on top in the table at the bottom?

---

There is, though would require a little bit of SQL code to accomplish.

Are you wanting every export, certain or particular ones, something switchable like from the admin screen? When say by date or newest, can you be more specific? There typically are dates captured for every product; however, there are also means to bypass those dates or adjust them.

Trying to get an idea of the initial request which could then be modified to suit.

Sure, so im talking about the table on the ep4 page that shows a history of all the exports you do. so whichever file no mater the export type, the one with the most recent timestamp would be on top of the table. I could see where a sort option to change the sort preference in the admin would also be helpful, although IMO the most recent file on top of the list is very useful.

Hi, I am using ZC 2.1.0 w/ php 8.3. Template is Responsive Classic.

Let me preface by saying, I did not have a problem w/ 2.0.1, however I am having trouble with 2.1.0

I have been struggling w/ getting EP to work as the basic attributes is not allowing imports nor exports. After submitting an import I get a blank page. After exporting it returns exactly only 1 line of data instead of the many on the website. I initially tried installing EP4 located at https://github.com/mc12345678/EasyPopulate-4.0. I then attempted to use 4.0.39. I did have an error log, however I in error deleted it when restoring a backup.

Now that my steps are addressed. I removed Easy Populate altogether so I can have a fresh start. Can you please tell me which is the most "baked" Easy Populate version to use that others are using successfully for zc 2.1.0? I will install it and start over and if I run into issues will provide an update.

Thank you very much for your help

I needed to do a quick test to see how EP handled images. So I went to my new ZC2.0 site...and I get a 500 error. This sort of shocked me as I have never had any issues with EP.


Zen Cart 2.0.1
Database Patch Level: 2.0.0
v2.0.0 [2024-06-02 05:34:21] (Version Update 1.5.8->2.0.0)
v1.5.7a [2020-11-10 21:55:11] (New Installation-v157a)
v1.5.7a [2020-11-10 21:55:11] (New Installation-v157a)

A 500 error should create a log file. Post it in its entirety using the # above.

I needed something done that very minute. I did a bit of research on DBIO and realized it would do what I needed. It worked like a champ.

Quote:

---

Originally Posted by chuckrey

Hi, I am using ZC 2.1.0 w/ php 8.3. Template is Responsive Classic.

Let me preface by saying, I did not have a problem w/ 2.0.1, however I am having trouble with 2.1.0

I have been struggling w/ getting EP to work as the basic attributes is not allowing imports nor exports. After submitting an import I get a blank page. After exporting it returns exactly only 1 line of data instead of the many on the website. I initially tried installing EP4 located at https://github.com/mc12345678/EasyPopulate-4.0. I then attempted to use 4.0.39. I did have an error log, however I in error deleted it when restoring a backup.

Now that my steps are addressed. I removed Easy Populate altogether so I can have a fresh start. Can you please tell me which is the most "baked" Easy Populate version to use that others are using successfully for zc 2.1.0? I will install it and start over and if I run into issues will provide an update.

Thank you very much for your help

---

In my attempt to install Zen Cart version 2.1.0, apparently I installed the GitHub master version which is still reporting Zen Cart 2.1.0 but has been half way adapted to whatever is coming next. Doing so also caused loss of all simple trigger_error troubleshooting and resulted in countless hours troubleshooting server configuration settings, code modification, folder permission evaluation and related testing.

I need to attempt to relocate the files back to the zc_pligins directory to determine if you get a different result, but my last test of importing and exporting the basic attributes data is working.

One thing I unfortunately found was some of the advanced functionality was built while the unique id was set for the products_id instead of the products_model. I've made a change to account for either setting that needs to be uploaded.