EasyPopulate 4.0 Support Thread

Speak394:

v1.5.8
PHP Version: 7.4.33

I am getting this error:

SQLi error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
categories_id = 3,
language_id = 1' at line 1

Have latest version from github.

Please help.

What is the filename of the file being imported?

Filename is Full-EP2023Apr25-201651.csv.

I am trying to download my products from a previous version of zencart 1.5.4 using Easy Populate 4.0.30 - Beta 06-27-2015, into my new zencart using Easy Populate 4.0.37.13 - 05-03-2021.

Speak394:

Filename is Full-EP2023Apr25-201651.csv.

I am trying to download my products from a previous version of zencart 1.5.4 using Easy Populate 4.0.30 - Beta 06-27-2015, into my new zencart using Easy Populate 4.0.37.13 - 05-03-2021.

OK, here's my thought, though haven't been able to test all this out.

First, I suspect that the table definition for products_description has been altered from the Zen Cart default. It is possible that it has not been altered.
Identifying the table's definition would likely help resolving this issue.

My guess is that there is a field included that doesn't have a default value and because the query described below doesn't also provide a value for that field, the query fails. As such, if a field does exist without a default value, the below suggestion won't resolve the issue either.

Second is that for whatever reason the query syntax used to insert some data, appears to not be acceptable in this instance. So, I would suggest in admin/easypopulate_4.php modifying lines 1141-1145 from:

                $sql = "INSERT INTO " . TABLE_CATEGORIES_DESCRIPTION . " SET
                    categories_id   = :categories_id:,
                    language_id     = :language_id:,
                    categories_name = :categories_name:,
                    categories_description = :categories_description:";

To:

                $sql = "INSERT INTO " . TABLE_CATEGORIES_DESCRIPTION . " (categories_id, language_id, categories_name, categories_description) VALUES (
                    :categories_id:,
                    :language_id:,
                    :categories_name:,
                    :categories_description:)";

Really, some more data should be collected about what issue really is experienced in the query.

Hello, Can EP4 create linked products? What is the best method?

Thanks

djdavedawson:

Hello, Can EP4 create linked products? What is the best method?

Thanks

Yes.

In part from the instructions:

Also note that if you enter the same products_model twice, the latest (last) record
entry will over-write any previous entry. The exception here is if you enter a different category; this will result in a linked
product. This means that if two rows of data have the same v_products_model data with only a difference of the category name,
then the product will appear in both categories and a change to the data in one entry will appear in the other category. See the
previous sentence about effect of two products having the same products_model identifier.

Basically, whatever is used to "uniquely" identify the product has a category different than the original or an existing category will cause a linked version to be created. Further because rows are processed sequentially, the last row of data for that "unique" product will become the primary data for the entire product wherever it is shown/stored.

How to import or add new products via easy populate , without matching product_models? I mean I want to make the csv and it will add new products to

my store which does not have any product model

diptimoy:

How to import or add new products via easy populate , without matching product_models? I mean I want to make the csv and it will add new products to

my store which does not have any product model

You have options. The old school way would be to run a sql query that would generate a unique model for each product, then export that file, edit it and upload any changes. Hmm, though you asked about just adding product.

Well, generally speaking the software currently expects to have something in the field associated with the unique identifier. So if you started using a model designation with your product to be added, then if it isn't in the database it will become a new product.

A more advanced method would be to use the products_id as the unique identifier with black to allow adding product. (blank_new setting). I warn you though that incorrect use of this option could destroy your database. Test with either of these methods on a backup of your database or a store not intended to make sales.

Please also read over the last page or so of posts. There are two issues still with the default install of the software, one is only present in zencart 1.5.8 and above. I'm close to issuing an update, though still worried that I haven't tested every possible issue sufficiently. Options and capability has been expanded so much, I inky expect a problem. Anyways, there is installation assistance over the last many pages, but it just basically repeats every few.

mc12345678:

You have options. The old school way would be to run a sql query that would generate a unique model for each product, then export that file, edit it and upload any changes. Hmm, though you asked about just adding product.

Well, generally speaking the software currently expects to have something in the field associated with the unique identifier. So if you started using a model designation with your product to be added, then if it isn't in the database it will become a new product.

A more advanced method would be to use the products_id as the unique identifier with black to allow adding product. (blank_new setting). I warn you though that incorrect use of this option could destroy your database. Test with either of these methods on a backup of your database or a store not intended to make sales.

Please also read over the last page or so of posts. There are two issues still with the default install of the software, one is only present in zencart 1.5.8 and above. I'm close to issuing an update, though still worried that I haven't tested every possible issue sufficiently. Options and capability has been expanded so much, I inky expect a problem. Anyways, there is installation assistance over the last many pages, but it just basically repeats every few.

You mean if the CSV has a product_model column and that product_model data if not present in the database , it will add as a new product ?

diptimoy:

You mean if the CSV has a product_model column and that product_model data if not present in the database , it will add as a new product ?

In a default install yes. Again please test on a site not making you money. Also make a database backup before first trying. It's both easy and complicated, highly rule based.

diptimoy:

You mean if the CSV has a product_model column and that product_model data if not present in the database , it will add as a new product ?

mc12345678:

In a default install yes. Again please test on a site not making you money. Also make a database backup before first trying. It's both easy and complicated, highly rule based.

To be clear though, the field name is: products_model. Thus the field column header in the csv file should be: v_products_model.

Such information becomes more obvious when reviewing the downloaded version of the exported file.

Again, it's those little things where it's both easy and complicated.

" To be clear though, the field name is: products_model. Thus the field column header in the csv file should be: v_products_model. "

I know this but for soem reason its not happening , product is skipped and warning says file is imported with issues .

Thanks for quick reply

diptimoy:

" To be clear though, the field name is: products_model. Thus the field column header in the csv file should be: v_products_model. "

I know this but for soem reason its not happening , product is skipped and warning says file is imported with issues .

Thanks for quick reply

Again, please see the issues with default install over the last several pages. The product must also have a category assigned to it.

Feel free to post the settings of the configuration for the plug in, there may be something obvious there.

I didn't learn English and code well like myself, so I upgraded PHP and Zencard versions (php7.8 Zencard 1.5.7 to php8.1 Zencard 1.5.8), which directly caused the plugin to be unusable. This is a very frustrating thing .

Who can provide the latest plugin package for PHP 8.1 ZENCART 1.5.8a?

Just like the previously developed plugins, simply change the name of the management folder and upload it.

targetmarts:

I didn't learn English and code well like myself, so I upgraded PHP and Zencard versions (php7.8 Zencard 1.5.7 to php8.1 Zencard 1.5.8), which directly caused the plugin to be unusable. This is a very frustrating thing .

Who can provide the latest plugin package for PHP 8.1 ZENCART 1.5.8a?

Just like the previously developed plugins, simply change the name of the management folder and upload it.

Apply the change described here: https://github.com/zencart/zencart/blob/v158/admin/includes/functions/admin_access.php

Depending on other factors there may be one other post that contains a correction needed.

targetmarts:

I didn't learn English and code well like myself, so I upgraded PHP and Zencard versions (php7.8 Zencard 1.5.7 to php8.1 Zencard 1.5.8), which directly caused the plugin to be unusable. This is a very frustrating thing .

Who can provide the latest plugin package for PHP 8.1 ZENCART 1.5.8a?

Just like the previously developed plugins, simply change the name of the management folder and upload it.

mc12345678:

Apply the change described here: https://github.com/zencart/zencart/blob/v158/admin/includes/functions/admin_access.php

Depending on other factors there may be one other post that contains a correction needed.

Correction. Please identify what happens when and what version of this plugin is being used.

mc12345678:

Correction. Please identify what happens when and what version of this plugin is being used.

we used the latest version from 2023.5 with zen cart 1.5.7b php 7.8 work fine,but it don't work and many other problem with zen cart after to zen cart 1.5.8a and php 8,1,and we install zen cart 1.5.8a in php 8.1 now,but it don't work when upload the easypopulate.
heelsbags.com

targetmarts:

we used the latest version from 2023.5 with zen cart 1.5.7b php 7.8 work fine,but it don't work and many other problem with zen cart after to zen cart 1.5.8a and php 8,1,and we install zen cart 1.5.8a in php 8.1 now,but it don't work when upload the easypopulate.
heelsbags.com

1. Login to admin. OK. Yes/ no?
2. Tools->Easy Populate 4. OK. Yes/ no?
3. Export all product. Ok. Yes/No?
4. Upload file.ok. Yes/ no?
5. Import file. OK. Yes/ no?

If no, explain what you see.

mc12345678:

1. Login to admin. OK. Yes/ no?
2. Tools->Easy Populate 4. OK. Yes/ no?
3. Export all product. Ok. Yes/No?
4. Upload file.ok. Yes/ no?
5. Import file. OK. Yes/ no?

If no, explain what you see.

1. Login to admin. OK.
2. Tools->Easy Populate 4. no,blank
   ........

mc12345678:

1. Login to admin. OK. Yes/ no?
2. Tools->Easy Populate 4. OK. Yes/ no?
3. Export all product. Ok. Yes/No?
4. Upload file.ok. Yes/ no?
5. Import file. OK. Yes/ no?

If no, explain what you see.
And the bugs in log as here:

[17-Jul-2023 10:21:19 UTC] PHP Fatal error: Uncaught Error: Undefined constant "EP4_DB_FILTER_KEY" in /....../public_html/heelsbags/admin/easypopulate_4.php:23
Stack trace:
#0 /....../public_html/heelsbags/admin/index.php(11): require()
#1 {main}
thrown in /....../public_html/heelsbags/admin/easypopulate_4.php on line 23

[17-Jul-2023 10:21:19 UTC] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 240e:381:2763:9f00:ac1a:80d:306b:e5e8
--> PHP Fatal error: Uncaught Error: Undefined constant "EP4_DB_FILTER_KEY" in /....../public_html/heelsbags/admin/easypopulate_4.php:23
Stack trace:
#0 /....../public_html/heelsbags/admin/index.php(11): require()
#1 {main}
thrown in /....../public_html/heelsbags/admin/easypopulate_4.php on line 23.

targetmarts:

And the bugs in log as here:

---

[17-Jul-2023 10:21:19 UTC] PHP Fatal error: Uncaught Error: Undefined constant "EP4_DB_FILTER_KEY" in /....../public_html/heelsbags/admin/easypopulate_4.php:23
Stack trace:
#0 /....../public_html/heelsbags/admin/index.php(11): require()
#1 {main}
thrown in /....../public_html/heelsbags/admin/easypopulate_4.php on line 23

[17-Jul-2023 10:21:19 UTC] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 240e:381:2763:9f00:ac1a:80d:306b:e5e8
--> PHP Fatal error: Uncaught Error: Undefined constant "EP4_DB_FILTER_KEY" in /....../public_html/heelsbags/admin/easypopulate_4.php:23
Stack trace:
#0 /....../public_html/heelsbags/admin/index.php(11): require()
#1 {main}
thrown in /....../public_html/heelsbags/admin/easypopulate_4.php on line 23.
Sorry for the significant delay.

Obtain latest copy from: GitHub - mc12345678/EasyPopulate-4.0 at CSV-delimiter-catalog-message-correct

The direct zip file download link is: https://github.com/mc12345678/EasyPopulate-4.0/archive/refs/heads/CSV-delimiter-catalog-message-correct.zip

Then load files, Access menu and perform install.
Then, go to configuration->EasyPopulate 4
Change setting for "Import Language Override" - language_code_only

to any other value.