EasyPopulate 4.0 Support Thread

jsimoes1997:

Good

I appended all categories and would like to add categories to csv, but when I added the file and do import, give me the error described below:

SKIPPED! - Category ID: 1,"","Adapter","","Adaptadores","","","","","","","","0" - Not Found!

And the csv file contains what is described below:

v_categories_id,v_categories_image,v_categories_name_1,v_categories_description_1,v_categories_name_3,v_categories_description_3,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1,v_metatags_title_3,v_metatags_keywords_3,v_metatags_description_3,v_sort_order
1,"","Adapter","","Adaptadores","","","","","","","","0"

I would like a help, thanks.
Categories are added by processing a product file that is identified as a full product type file.
Details about a category are updated using the categorymeta-epxxxxx type file.

Another way to think about it is that categories exist to support a product. The details of a category are independent of the product.

Ok, I noticed but now I did what I said and added a new product with all the fields and since to create the category has to be with the product I did it but when I mattered it says that it is wrong with the part of not knowing the category.

the error code is described below

SKIPPED! - Model: 270-4373,"1","","SUN PCI GIGABIT FC NETWORK ADAPTER","SUN PCI GIGABIT FC NETWORK ADAPTER","","SUN PCI GIGABIT FC NETWORK ADAPTER","SUN PCI GIGABIT FC NETWORK ADAPTER","","","","","0","0","0","1","1","1","0","0","2019-03-01 00:00:00","2019-02-28 00:00:00","6","SUN","Adapter","Adaptadores","--none--","1" - No category provided for this new product

I would like to know how to do it, Thanks.

jsimoes1997:

Ok, I noticed but now I did what I said and added a new product with all the fields and since to create the category has to be with the product I did it but when I mattered it says that it is wrong with the part of not knowing the category.

the error code is described below

SKIPPED! - Model: 270-4373,"1","","SUN PCI GIGABIT FC NETWORK ADAPTER","SUN PCI GIGABIT FC NETWORK ADAPTER","","SUN PCI GIGABIT FC NETWORK ADAPTER","SUN PCI GIGABIT FC NETWORK ADAPTER","","","","","0","0","0","1","1","1","0","0","2019-03-01 00:00:00","2019-02-28 00:00:00","6","SUN","Adapter","Adaptadores","--none--","1" - No category provided for this new product

I would like to know how to do it, Thanks.

The error message seems to indicate that the categories field heading is not provided (v_categories_name_1 or whatever number represents your current language_id).

Best suggestion to offer if it hasn't been done, is to export one or more product (can select a category to export), then modify the data in the row for your your product to make it unique and reference what you want to import and then import that. From there can trim down fields not needed to get to your preferred process.

Hi All, I am having a slight problem with the price breaks export. I am running version 4.0.36.ZC, on Zen Cart 1.5.5f.

The problem is thus, I have 4 price breaks set up, as well as the base price, for each product. But when I export the price breaks using the Model/Price/Breaks export function, it only exports the first 3, and ignores the 4th price break. There is no column for it in the exported csv file.

I can add products with the 4th price break by manually adding it to the csv file and uploading, it adds all the price breaks exactly as it should, but when exporting the products again, you only get the first 3 price breaks.

Has anybody else encountered this?

Pingfah:

Hi All, I am having a slight problem with the price breaks export. I am running version 4.0.36.ZC, on Zen Cart 1.5.5f.

The problem is thus, I have 4 price breaks set up, as well as the base price, for each product. But when I export the price breaks using the Model/Price/Breaks export function, it only exports the first 3, and ignores the 4th price break. There is no column for it in the exported csv file.

I can add products with the 4th price break by manually adding it to the csv file and uploading, it adds all the price breaks exactly as it should, but when exporting the products again, you only get the first 3 price breaks.

Has anybody else encountered this?
There's a configuration setting in configuration->Easy Populate 4 titled Maximum Quantity Discounts that identifies the number of discount columns to be downloaded. The default is 3 which is what you are/were seeing. You can change that to a value of 4 or whatever number is desired.

mc12345678:

There's a configuration setting in configuration->Easy Populate 4 titled Maximum Quantity Discounts that identifies the number of discount columns to be downloaded. The default is 3 which is what you are/were seeing. You can change that to a value of 4 or whatever number is desired.

Super, thank you very much indeed!

Hi, when I did the import of a file successfully but it says that it has a sql error what I'm doing is with a product of a category then I created a product with another category already created,
I am putting the product id as the primary key and when I enter the new product and the category name even with it already created it gives error.

The data in the file I'm importing is this:

v_products_model;v_products_id;v_products_type;v_products_image;v_products_name_1;v_products_description_1;v_products_url_1;v_products_name_3;v_products_description_3;v_products_url_3;v_specials_price;v_specials_date_avail;v_specials_expires_date;v_products_price;v_products_weight;v_product_is_call;v_products_sort_order;v_products_quantity_order_min;v_products_quantity_order_units;v_products_priced_by_attribute;v_product_is_always_free_shipping;v_date_avail;v_date_added;v_products_quantity;v_manufacturers_name;v_categories_name_1;v_categories_name_3;v_tax_class_title;v_status
swTTT;184;1;;SWITCH;TEST 1 FOR PRODUCT;;SWITCH;TESTE 1 DE PRODUTO;;;;;5;5;0;1;1;1;0;0;;2019-03-04 14:28:22;2;CISCO;Test;Teste;--none--;1
swswq;;1;;SWITCH 1;TEST 1 FOR PRODUCT 1;;SWITCH 1;TESTE 1 DE PRODUTO 1;;;;;6;6;0;1;1;1;0;0;;2019-03-04 14:28:23;3;CISCO;Test1;Teste1;--none--;2

The sql error that you are giving me is this:

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 ')
WHERE
products.products_id=188' at line 8
When executing:
SELECT
products_to_categories.products_id,
products_to_categories.categories_id,
products.master_categories_id
FROM
products
LEFT JOIN
products_to_categories ON (products.products_id = products_to_categories.products_id AND products_to_categories.categories_id=)
WHERE
products.products_id=188
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 ')' at line 2
When executing:
INSERT INTO products_to_categories (products_id, categories_id)
VALUES (188, )
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 ')
WHERE
products.products_id=188' at line 8
When executing:
SELECT
products_to_categories.products_id,
products_to_categories.categories_id,
products.master_categories_id
FROM
products
LEFT JOIN
products_to_categories ON (products.products_id = products_to_categories.products_id AND products_to_categories.categories_id=)
WHERE
products.products_id=188
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 ')' at line 2
When executing:
INSERT INTO products_to_categories (products_id, categories_id)
VALUES (188, )

I need help!! Its urgent.
Thanks for the time.

jsimoes1997:

Hi, when I did the import of a file successfully but it says that it has a sql error what I'm doing is with a product of a category then I created a product with another category already created,
I am putting the product id as the primary key and when I enter the new product and the category name even with it already created it gives error.

The data in the file I'm importing is this:

v_products_model;v_products_id;v_products_type;v_products_image;v_products_name_1;v_products_description_1;v_products_url_1;v_products_name_3;v_products_description_3;v_products_url_3;v_specials_price;v_specials_date_avail;v_specials_expires_date;v_products_price;v_products_weight;v_product_is_call;v_products_sort_order;v_products_quantity_order_min;v_products_quantity_order_units;v_products_priced_by_attribute;v_product_is_always_free_shipping;v_date_avail;v_date_added;v_products_quantity;v_manufacturers_name;v_categories_name_1;v_categories_name_3;v_tax_class_title;v_status
swTTT;184;1;;SWITCH;TEST 1 FOR PRODUCT;;SWITCH;TESTE 1 DE PRODUTO;;;;;5;5;0;1;1;1;0;0;;2019-03-04 14:28:22;2;CISCO;Test;Teste;--none--;1
swswq;;1;;SWITCH 1;TEST 1 FOR PRODUCT 1;;SWITCH 1;TESTE 1 DE PRODUTO 1;;;;;6;6;0;1;1;1;0;0;;2019-03-04 14:28:23;3;CISCO;Test1;Teste1;--none--;2

> 
> 
> The sql error that you are giving me is this:
> 
> ```
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 ')
          WHERE
          products.products_id=188' at line 8
When executing:
SELECT 
          products_to_categories.products_id,
          products_to_categories.categories_id,
          products.master_categories_id
          FROM
          products
          LEFT JOIN
          products_to_categories ON (products.products_id = products_to_categories.products_id AND products_to_categories.categories_id=)
          WHERE
          products.products_id=188
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 ')' at line 2
When executing:
INSERT INTO products_to_categories (products_id, categories_id)
            VALUES (188, )
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 ')
          WHERE
          products.products_id=188' at line 8
When executing:
SELECT 
          products_to_categories.products_id,
          products_to_categories.categories_id,
          products.master_categories_id
          FROM
          products
          LEFT JOIN
          products_to_categories ON (products.products_id = products_to_categories.products_id AND products_to_categories.categories_id=)
          WHERE
          products.products_id=188
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 ')' at line 2
When executing:
INSERT INTO products_to_categories (products_id, categories_id)
            VALUES (188, )

I need help!! Its urgent.
Thanks for the time.
If I understand correctly besides that the error message provided does not appear to directly relate to the product being imported, it looks like the particular issue would be addressed by modifying line 1501 from:

          '.TABLE_PRODUCTS_TO_CATEGORIES.' ON ('.TABLE_PRODUCTS.'.products_id = '.TABLE_PRODUCTS_TO_CATEGORIES.'.products_id AND '.TABLE_PRODUCTS_TO_CATEGORIES.'.categories_id='.$v_categories_id.')

to:

          '.TABLE_PRODUCTS_TO_CATEGORIES.' ON ('.TABLE_PRODUCTS.'.products_id = '.TABLE_PRODUCTS_TO_CATEGORIES.'.products_id AND '.TABLE_PRODUCTS_TO_CATEGORIES.'.categories_id='.(int)$v_categories_id.')

This area of code has been redone in the next revision.

Also, what this seems to imply overall is that it sounds like you have product in the main category of the store (not in a sub-category) and have a sub-category in which a product is located). This configuration in a default store can cause display issues.

I say this because without the change provided above, if $v_categories_id is equal to 0, then the issue identified would occur. A $v_categories_id of 0 indicates that the product is assigned to the root of the store. Further have said that in part are dealing with an existing product that is in an existing category; however, an existing category doesn't have a categories_id = 0 because only the root has that. Then there is the issue of the products_id = 188 when the file indicates 184... Perhaps a typo, but important information. The other possible issue seems that the setting to select the primary id may be set to products_model even though the file contains a products_id and the products_model is assigned to more than one product.

Ok, I have exported the cvs file and when I click "Download" I got an "403: Forbidden". It never done this I didn't change anything.

wmorris:

Ok, I have exported the cvs file and when I click "Download" I got an "403: Forbidden". It never done this I didn't change anything.

Download of csv files from the stored directory depends on the permissions of that folder and those above it. There is an .htaccess file in the distribution that is configured to support download of csv files. It can be found in the folder that starts with htaccess4... as stated in the instructions that file should be placed in your export/downloads fiolder.

The cause could be that something above the current folder was changed that prevented download of the files.

mc12345678:

Well, that method doesn't exactly help things other than allowing those in the forum to possibly discover more quickly the errors with their installation package. One thing of note, whenever a screen goes blank there is likely an error message related to it in the logs folder. While total time to move an existing installation out of the way to discovery of a missing parentheses by execution of the code (would have likely been faster just to look at the patch itself) was about 20 minutes, I have pushed the revised patch to: https://github.com/mc12345678/EasyPopulate-4.0/compare/mc12345678:v4.0.36.ZC...v4.0.36-categories_description_import_patch

The issue is definitely a missing sql assignment when adding a new category. Again it was something that has existed in this software since before I started helping with it, but systems had generally been flexible enough to understand what to do and not cause a problem, but now are becoming stricter (which is good overall). Unfortunately users had not been making the issue known so changes could not be made for a problem not described... It has been addressed in an upcoming release and the above patch has been verified to work. Of course there are a number of things to be done with that code to tighten it up, but that's addressed in the next release.

I am having this issue with ZenCart 1.56a and EasyPopulate 4. If it matters, my PHP is version 7.1 and MySQL is 5.6.

In trying to address the issue, I came across this thread and have installed the v4.0.36.ZC Patch 1 12-29-2018 mc12345678. I didn't know exactly how to use the diff but I found the raw file on github and copy/pasted the entire thing so I think that would be OK?

However I still get an error when attempting an import. From ep_debug_log.txt:

MySQLi error 1366: Incorrect integer value: '' for column 'products_sort_order' at row 1
When executing:
INSERT INTO products SET
                                                        products_model                                  = 'BLUFFF_BLKDOV',
                                                        products_type                           = 1,
                                                        products_price                                  = '39.95', 
                                                        products_image                       = '62802-full.png',
                                                        products_weight                                 = 0.085,
                                                        products_discount_type          = 0,
                                                        products_discount_type_from     = 0,
                                                        product_is_call                 = 0,
                                                        products_sort_order             = '',
                                                        products_quantity_order_min     = 0,
                                                        products_quantity_order_units   = 0,
                                                        products_priced_by_attribute    = 0,
                                                        product_is_always_free_shipping = 0,
                                                        products_tax_class_id                   = 0,
                                                        products_date_available                 = NULL, 
                                                        products_date_added                             = '2018-08-09 11:10:00',
                                                        products_last_modified                  = CURRENT_TIMESTAMP,
                                                        products_quantity                               = 15,
                                                        master_categories_id                    = 139146,
                                                        manufacturers_id                                = 0,
                                                        products_status                                 = 1,
                                                        metatags_title_status                   = 0,
                                                        metatags_products_name_status   = 0,
                                                        metatags_model_status                   = 0,
                                                        metatags_price_status                   = 0,
                                                        metatags_title_tagline_status   = 0

Here are the columns in my CSV:

v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_products_price,v_products_weight,v_products_quantity,v_date_added,v_categories_name_1,v_categories_name_2,v_status

Any ideas on how I can fix this?

Thanks for your time,

Drew

imacamper:

I am having this issue with ZenCart 1.56a and EasyPopulate 4. If it matters, my PHP is version 7.1 and MySQL is 5.6.

In trying to address the issue, I came across this thread and have installed the v4.0.36.ZC Patch 1 12-29-2018 mc12345678. I didn't know exactly how to use the diff but I found the raw file on github and copy/pasted the entire thing so I think that would be OK?

However I still get an error when attempting an import. From ep_debug_log.txt:

MySQLi error 1366: Incorrect integer value: '' for column 'products_sort_order' at row 1
When executing:
INSERT INTO products SET
products_model = 'BLUFFF_BLKDOV',
products_type = 1,
products_price = '39.95',
products_image = '62802-full.png',
products_weight = 0.085,
products_discount_type = 0,
products_discount_type_from = 0,
product_is_call = 0,
products_sort_order = '',
products_quantity_order_min = 0,
products_quantity_order_units = 0,
products_priced_by_attribute = 0,
product_is_always_free_shipping = 0,
products_tax_class_id = 0,
products_date_available = NULL,
products_date_added = '2018-08-09 11:10:00',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = 15,
master_categories_id = 139146,
manufacturers_id = 0,
products_status = 1,
metatags_title_status = 0,
metatags_products_name_status = 0,
metatags_model_status = 0,
metatags_price_status = 0,
metatags_title_tagline_status = 0

> 
> Here are the columns in my CSV:
> 
> ```
v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_products_price,v_products_weight,v_products_quantity,v_date_added,v_categories_name_1,v_categories_name_2,v_status

Any ideas on how I can fix this?

Thanks for your time,

Drew
This issue was fixed in a later push of code when more was done to ensure there was a "sanitizer" for every field being populated.

I'm nearly inclined to suggest installing the latest version on GitHub. I'm looking at a couple of additional tests to verify that it will be possible to import language related information using the two character language code. The existing method uses the numeric language id.

Change lines 1039 and 1190 of admin/easypopulate_4_import.php from:

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

to:

            $query = $db->bindVars($query, ':products_sort_order:', $v_products_sort_order, 'integer');

mc12345678:

This issue was fixed in a later push of code when more was done to ensure there was a "sanitizer" for every field being populated.

I'm nearly inclined to suggest installing the latest version on GitHub. I'm looking at a couple of additional tests to verify that it will be possible to import language related information using the two character language code. The existing method uses the numeric language id.

Change lines 1039 and 1190 of admin/easypopulate_4_import.php from:

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

> to:
> ```
            $query = $db->bindVars($query, ':products_sort_order:', $v_products_sort_order, 'integer');

Thank you very much. That has solved my issue.

Cheers,

Drew

Hi everyone. I'm a happy user with EP4 and am curious if this can be done: convert inventory items that were originally general over to music. So I've updated the "show music" genre in the admin. I've updated my inventory by: changing type from 1 (general) to 2 (music) , added the music fields to my database, and then uploaded the database with no errors. But when I go into the inventory, the music fields are not showing. It's weird: if I create a new music inventory item, all of the music fields are on my screen to enter. My thinking is that once you have created a product under "general" it cannot be converted to "music" If that's wrong, any suggestions would be really appreciated.

mrmcastle:

Hi everyone. I'm a happy user with EP4 and am curious if this can be done: convert inventory items that were originally general over to music. So I've updated the "show music" genre in the admin. I've updated my inventory by: changing type from 1 (general) to 2 (music) , added the music fields to my database, and then uploaded the database with no errors. But when I go into the inventory, the music fields are not showing. It's weird: if I create a new music inventory item, all of the music fields are on my screen to enter. My thinking is that once you have created a product under "general" it cannot be converted to "music" If that's wrong, any suggestions would be really appreciated.

Some more information is needed to help through this situation.
ZC version?
EP4 version?
When saying that have changed the products_type from 1 to 2, please explain how/where.
Does the export of a manually entered music product look the same as an export of one entered using EP4? Is this what you are talking about when looking at "inventory"?
What custom field import filter(s) are applied as found in the configuration screen for EP4?

As to product types, well, the general thought is that product product types should not be changed at least after the product has been created and is part of the store. It doesn't mean that they can not be changed. The issue centers around some of what you are seeing. How to populate the other data related to the product if the product type is now x and what to do with the old/unrelated data when the product type has changed? For example if a music product is converted to a product general product, won't there now be fields associated with the music product type that are populated but not used?

Sorry, that's a lot of info I forgot to mention. I'm using ZC 1.51 and EP 4.0.24 I know these are older versions but the site is working fine and you know what they say... if it ain't broke don't fix it. I don't take credit cards... send my buyers to Paypal which is very secure so I'm not really too worried about all the security issues mentioned in the forum. (Please let me know if I my thinking is wrong on that).

When I enter a new item manually using the Product-Music category, the screen looks like the attached picture A. So after modifying my inventory (using a spreadsheet and then filling in those music fields) I assumed they would show up like that picture, with those fields now displaying the info. Instead, the music data from EP4 goes nowhere. If I go into category and look at the items I've updated using EP4, those 3 fields are not there. I am assuming that after I change product type from 1 to 2 and then fill in all of the music fields (artist, recording company, genre) they should show up, but nothing. I just did an export from EP4 and those fields I updated with the music infor are not there. It's weird because after I import them in, it shows those fields as having been added on the confirmation screen.. but I guess they are not.

Let's take a step back to see where the issue really is.

First consider a product that was manually entered in the admin as a music product.

If you export that record, is all of the desired music related information in the export?
If you modify some music related aspect of that one product and upload a file that has just the headers and that one product, then import the file back into the database, does it get updated with the new information?

Yes to all. I exported the file, made a couple of modifications to the music fields in my spreadsheet and then uploaded thru EP4. The file uploaded successfully and the changes I made were updated.

mc12345678:

Let's take a step back to see where the issue really is.

First consider a product that was manually entered in the admin as a music product.

If you export that record, is all of the desired music related information in the export?
If you modify some music related aspect of that one product and upload a file that has just the headers and that one product, then import the file back into the database, does it get updated with the new information?

mrmcastle:

Yes to all. I exported the file, made a couple of modifications to the music fields in my spreadsheet and then uploaded thru EP4. The file uploaded successfully and the changes I made were updated.
When you populated your new record for your new "music" product, did you have an artist entered in the v_artists_name field?

Following your logic, I decided to try changing the v_products type to 1 on that item (the music product item you had me create) and then uploaded it back up via EP4. I thought for sure the item would no longer show the recording artist, record company and genre but those fields are still there. It seems like it's one of two things.... either the version ZC I have doesn't want to work with the EP4 version I have or there is no switching over once you've created an item as a general or music product. EP4 is pretty good but it has its quirks... I installed the Ceon URI mapping program and it would not switch my existing inventory over until I went in to each product and saved it. Yeah, I know there was a fix out there but I didn't want to shell out the $60 for it....

Oh sorry just saw your recent post will check it and get back to you