Zen Cart Logo
Forums / Addon Admin Tools / EasyPopulate 4.0 Support Thread

EasyPopulate 4.0 Support Thread

Sticky

Views: 733,344

Results 3,081 to 3,100 of 3,671
22 Oct 2019, 4:05 AM
#3081
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

EasyPopulate 4.0 Support Thread

jimmie:

i open it with microsoft excel
Definitely Excel is taking that long set of numbers and changing the display of them scientific. That column though should be treated as text on import.

I did an Internet search for: excel import csv column as text

And came up with a lot of good results.

26 Oct 2019, 8:52 PM
#3082
chibipaw avatar

chibipaw

Zen Follower

Join Date:
Jul 2011
Posts:
163
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Im trying to set up a simple cron job to import a CSV.
However, upon trying to run the command php ep4_cron.php import=myproducts.csv, the system throws a bunch of these types of errors.
Notice: Undefined index: securityToken in [myadmin]/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_TITLE - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_TITLE' in easypopulate_4_import.php on line 2493

Any thoughts on how to properly get this to work? There doesnt not seem to be much of any documentations at all.

26 Oct 2019, 10:59 PM
#3083
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

chibipaw:

Im trying to set up a simple cron job to import a CSV.
However, upon trying to run the command php ep4_cron.php import=myproducts.csv, the system throws a bunch of these types of errors.
Notice: Undefined index: securityToken in [myadmin]/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_TITLE - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_TITLE' in easypopulate_4_import.php on line 2493

Any thoughts on how to properly get this to work? There doesnt not seem to be much of any documentations at all.
It's relatively new and incorporated to help someone that had asked for the possibility and didn't know how to put together the bits that would be necessary for its execution, so yes, little to no documentation other than what is in the file itself.

As for the warnings received, that's because the language file is not pulled into the cron and not into the import portion. Furthermore it's because the import file does more than just import, it also prepares text to be exported, but does not actually export text.

So, to get those messages to go away, I am thinking the following would work.

In line 332 of admin/ep4_cron.php add the following:

if (isset($_SESSION['language']) && file_exists(DIR_FS_ADMIN . DIR_WS_LANGUAGES . $_SESSION['language'] . '/easypopulate_4.php')) {
    require DIR_FS_ADMIN . DIR_WS_LANGUAGES . $_SESSION['language'] . '/easypopulate_4.php';
} else {
 require DIR_FS_ADMIN . DIR_WS_LANGUAGES . 'english'. '/easypopulate_4.php';
}

With the require for the import file being at line 339 as it may seem.

My ISP is having some serious issues so I am limited on what I can test, confirm, and manipulate basically by what my cell phone can do or what can be done with limited cell phone data tethering.

27 Oct 2019, 12:09 AM
#3084
chibipaw avatar

chibipaw

Zen Follower

Join Date:
Jul 2011
Posts:
163
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Looks likes that bit of code actually worked.
Still spews a lot of similar errors, but the csvs were processed. I'll just redirect the garbage into /dev/null and hope it will get clean up at some point.
The good thing is, it's working.
Now that we're on the topic of automation. Any thoughts about crontabbing status of categories ?

I'm thinking of doing something like this right after the cron ep4_cron job to toggle the status of the category.
mysql --user=[username] --password=[password] < [script pathway]

—————SCRIPT——————
update products set catagories_status=1 where catagories_id = [product to be toggled];

mc12345678:

It's relatively new and incorporated to help someone that had asked for the possibility and didn't know how to put together the bits that would be necessary for its execution, so yes, little to no documentation other than what is in the file itself.

As for the warnings received, that's because the language file is not pulled into the cron and not into the import portion. Furthermore it's because the import file does more than just import, it also prepares text to be exported, but does not actually export text.

So, to get those messages to go away, I am thinking the following would work.

In line 332 of admin/ep4_cron.php add the following:

if (isset($_SESSION['language']) && file_exists(DIR_FS_ADMIN . DIR_WS_LANGUAGES . $_SESSION['language'] . '/easypopulate_4.php')) {
require DIR_FS_ADMIN . DIR_WS_LANGUAGES . $_SESSION['language'] . '/easypopulate_4.php';
} else {
require DIR_FS_ADMIN . DIR_WS_LANGUAGES . 'english'. '/easypopulate_4.php';
}

> 
> With the require for the import file being at line 339 as it may seem.  
> 
> My ISP is having some serious issues so I am limited on what I can test, confirm, and manipulate basically by what my cell phone can do or what can be done with limited cell phone data tethering.
27 Oct 2019, 10:20 AM
#3085
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

chibipaw:

Looks likes that bit of code actually worked.
Still spews a lot of similar errors, but the csvs were processed. I'll just redirect the garbage into /dev/null and hope it will get clean up at some point.
The good thing is, it's working.
Now that we're on the topic of automation. Any thoughts about crontabbing status of categories ?

I'm thinking of doing something like this right after the cron ep4_cron job to toggle the status of the category.
mysql --user=[username] --password=[password] < [script pathway]

—————SCRIPT——————
update products set catagories_status=1 where catagories_id = [product to be toggled];

Don't know why, but I kind of get the feeling that the concept of open source community is not fully understood...

The error messages/problems won't fix themselves and probably will go undiscussed/undiscovered for quite a while if 1) everyone follows suit with dumping the "garbage" and 2) not providing the log files to potentially allow correction of the issue(s). Sure the issue could still be on either side (the code or the server), but one will never know if the information is not shared. I had thought that my previous description of the origin of this code section would encourage discussion rather than just ignoring what is going on.

All that aside, the query suggested won't do what is desired or thought unless that "simple" line is to get intrepretted correctly based on what is provided.

The status of a category is in the categories table. The status of a product is in the products table. A category's status condition is or can be independent of the product. Adjusting the product's condition based on the category being modified potentially has some nuances as a product can have a category as its master category or it can be linked to the category with some other category being the master. In either case, changing the status of the product changes it in all locations. If the desire is to "hide" a product from a specific category but not everywhere, then the products_to_categories table may need adjustment to remove the link from the product to that category or to change the master category as part of that.

Just understand that the overall desire is always to resolve issues and not ignore them. The easiest thing to do on your side is to provide back logs (with the admin directory obscured) so that at least if there is something amiss with the code it can be corrected whether you adopt the changes or not.

27 Oct 2019, 8:46 PM
#3086
chibipaw avatar

chibipaw

Zen Follower

Join Date:
Jul 2011
Posts:
163
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

Don't know why, but I kind of get the feeling that the concept of open source community is not fully understood...

The error messages/problems won't fix themselves and probably will go undiscussed/undiscovered for quite a while if 1) everyone follows suit with dumping the "garbage" and 2) not providing the log files to potentially allow correction of the issue(s). Sure the issue could still be on either side (the code or the server), but one will never know if the information is not shared. I had thought that my previous description of the origin of this code section would encourage discussion rather than just ignoring what is going on.

All that aside, the query suggested won't do what is desired or thought unless that "simple" line is to get intrepretted correctly based on what is provided.

The status of a category is in the categories table. The status of a product is in the products table. A category's status condition is or can be independent of the product. Adjusting the product's condition based on the category being modified potentially has some nuances as a product can have a category as its master category or it can be linked to the category with some other category being the master. In either case, changing the status of the product changes it in all locations. If the desire is to "hide" a product from a specific category but not everywhere, then the products_to_categories table may need adjustment to remove the link from the product to that category or to change the master category as part of that.

Just understand that the overall desire is always to resolve issues and not ignore them. The easiest thing to do on your side is to provide back logs (with the admin directory obscured) so that at least if there is something amiss with the code it can be corrected whether you adopt the changes or not.

Trust me I know the nature of open source projects But I dont think lecturing people will improve upon it the nature of it.
At least I posted a excerpt of the logs, could have been simply nothing like most people.
But Ooof, lets move on.

Anyways, I've gotten the category toggling working with the bit of mysql script listed earlier. Lets consider that incident closed.
Focusing back to ep4_cron.php. Since Im not a coder, I'll leave this for those who are more capable than I am.

ZC: 1.5.5f
AWS Linux 4.14.146-93.123.amzn1.x86_64 #1 SMP
DB: MariaDB 10.3.8
Php 7.1.32

[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Constant BOX_CONFIGURATION_REWARD_POINTS already defined in /home/shopping/fakeadmin/includes/languages/english/extra_definitions/reward_points_definitions.php on line 5
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Constant TEXT_PREVIOUS_EXPORTS already defined in /home/shopping/fakeadmin/includes/languages/english/extra_definitions/shipping_export.php on line 33
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Constant EP4_ADMIN_TEMP_DIRECTORY already defined in /home/shopping/fakeadmin/ep4_cron.php on line 84
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_SPECIALS_HEADING - assumed 'EASYPOPULATE_4_SPECIALS_HEADING' in /home/shopping/fakeadmin/ep4_cron.php on line 124
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC - assumed
'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SHORT_DESC' in /home/shopping/fakeadmin/ep4_cron.php on line 175
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_UNIT_MEAS - assumed
'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_UNIT_MEAS' in /home/shopping/fakeadmin/ep4_cron.php on line 179
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_UPC - assumed 'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_UPC' in /home/shopping/fakeadmin/ep4_cron.php on line 183
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_GOOGLE_CAT - assumed
'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_GOOGLE_CAT' in /home/shopping/fakeadmin/ep4_cron.php on line 187
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_MSRP - assumed 'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_MSRP' in /home/shopping/fakeadmin/ep4_cron.php on line 191
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_MAP - assumed 'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_MAP' in /home/shopping/fakeadmin/ep4_cron.php on line 195
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_GP - assumed 'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_GP' in /home/shopping/fakeadmin/ep4_cron.php on line 199
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_EXCLUSIVE - assumed
'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_EXCLUSIVE' in /home/shopping/fakeadmin/ep4_cron.php on line 203
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_DPM - assumed 'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_DPM' in /home/shopping/fakeadmin/ep4_cron.php on line 207
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SBA - assumed 'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_SBA' in /home/shopping/fakeadmin/ep4_cron.php on line 211
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_CEON - assumed 'EASYPOPULATE_4_DISPLAY_STATUS_PRODUCT_CEON' in /home/shopping/fakeadmin/ep4_cron.php on line 215
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_HEADING - assumed 'EASYPOPULATE_4_DISPLAY_HEADING' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 23
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_LOCAL_FILE_SPEC - assumed 'EASYPOPULATE_4_DISPLAY_LOCAL_FILE_SPEC' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 26
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined index: v_status in /home/shopping/fakeadmin/easypopulate_4_import.php on line 301
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined index: in /home/shopping/fakeadmin/easypopulate_4_import.php on line 301
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined index: v_status in /home/shopping/fakeadmin/easypopulate_4_import.php on line 414
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined index: in /home/shopping/fakeadmin/easypopulate_4_import.php on line 414
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined variable: v_status in /home/shopping/fakeadmin/easypopulate_4_import.php on line 686
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined variable: v_status in /home/shopping/fakeadmin/easypopulate_4_import.php on line 689
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:07 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_RESULT_UPDATE_PRODUCT - assumed 'EASYPOPULATE_4_DISPLAY_RESULT_UPDATE_PRODUCT' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 1752
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: v_status in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2281
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2281
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Undefined index: securityToken in /home/shopping/fakeadmin/includes/classes/class.admin.zcObserverLogEventListener.php on line 158
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_TITLE - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_TITLE' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2493
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_NUM_RECORDS_UPDATE - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_NUM_RECORDS_UPDATE' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2520
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_NUM_RECORDS_IMPORT - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_NUM_RECORDS_IMPORT' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2522
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_NUM_ERRORS - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_NUM_ERRORS' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2524
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_NUM_WARNINGS - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_NUM_WARNINGS' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2526
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_MEM_USE - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_MEM_USE' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2529
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_MEM_PEAK - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_MEM_PEAK' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2531
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Notice: Use of undefined constant EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_EXEC_TIME - assumed 'EASYPOPULATE_4_DISPLAY_IMPORT_RESULTS_EXEC_TIME' in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2537
[26-Oct-2019 23:37:08 America/Los_Angeles] PHP Fatal error: Uncaught Error: Call to a member function add() on null in /home/shopping/fakeadmin/easypopulate_4_import.php:2547
Stack trace:
#0 /home/shopping/fakeadmin/ep4_cron.php(332): require()
#1 {main}
thrown in /home/shopping/fakeadmin/easypopulate_4_import.php on line 2547

2 Nov 2019, 7:39 PM
#3087
jiji2018 avatar

jiji2018

Zen Follower

Join Date:
Apr 2018
Posts:
121
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Is the 1.56c version now supported?

15 Nov 2019, 2:08 PM
#3088
jodean avatar

jodean

Totally Zenned

Join Date:
May 2011
Location:
Tennessee
Posts:
511
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Is the 1.56c version now supported?

16 Nov 2019, 4:33 PM
#3089
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

jodean:

Is the 1.56c version now supported?

Not 100% sure how to answer this question. As written (which may be related to a language issue) the answer is yes because issues that are identified are corrected. As perhaps understood to be meant, I have been able to successfully use EP4 as provided from GitHub on ZC 1.5.6c. Currently, one of the added features is not 100% complete.

The new feature of using the extension of _en or similar to denote a specific language works for the full import; however, does not for one or two of the other imports.

Note, that this new feature has been incorporated to allow continued use of the import file(s) as they were (a language dependent field ending with the language_id associated with how that database is setup) but it also offers some override type features where if both the language_code (e.g. en, de) and language_id were used then one overrides the other.

Further note, that although I chose to be somewhat forceful in discussion with a recent user at the cost of being seen as a jerk, the information obtained led to a solution that resolved the issues that otherwise were going to be ignored.

As far as the software with Zen Cart 1.5.6c there is nothing done to that version of software affecting this, the issues if any are or expected to be related to php versions.

4 Dec 2019, 8:38 PM
#3090
linuxguy2 avatar

linuxguy2

Zen Follower

Join Date:
Sep 2013
Location:
Texas
Posts:
315
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

ZC 1.5.6a Classic Clone.
CheckBoxTextBoxIconV1.0.3
EasyPopulate-4.master-ZC
one_page_checkout-2.0.5
ColumnGridLayout_for_155f

Using two "Product Types"
(Type 1) Product General and (Type 4) Document Product.
When I export with ep4 the v_products_type column is correct.
( I get 1 & 4 )
When I import all type 4 get changed to type 1.
Searched all morning but could not find a solution.
Is there a setting that over rides product types when importing with EP4?

In Admin "editing " category mode (Type) doesn't have any effect on the Product Type setting of products already entered.
When entering new products in Admin the Type setting works correctly

Thank You in Advance for your time.

4 Dec 2019, 8:48 PM
#3091
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

linuxguy2:

ZC 1.5.6a Classic Clone.
CheckBoxTextBoxIconV1.0.3
EasyPopulate-4.master-ZC
one_page_checkout-2.0.5
ColumnGridLayout_for_155f

Using two "Product Types"
(Type 1) Product General and (Type 4) Document Product.
When I export with ep4 the v_products_type column is correct.
( I get 1 & 4 )
When I import all type 4 get changed to type 1.
Searched all morning but could not find a solution.
Is there a setting that over rides product types when importing with EP4?

In Admin "editing " category mode (Type) doesn't have any effect on the Product Type setting of products already entered.
When entering new products in Admin the Type setting works correctly

Thank You in Advance for your time.
While there are few "restrictions" really placed on the software, one that is present is by default allowing the product type to be changed on update. That said, because it is a product field, there is the ability to incorporate it as a user defined field in the configuration area. In this way, updates will attempt to modify the products_type field so long as products_type is identified there.

4 Dec 2019, 9:23 PM
#3092
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

linuxguy2:

ZC 1.5.6a Classic Clone.
CheckBoxTextBoxIconV1.0.3
EasyPopulate-4.master-ZC
one_page_checkout-2.0.5
ColumnGridLayout_for_155f

Using two "Product Types"
(Type 1) Product General and (Type 4) Document Product.
When I export with ep4 the v_products_type column is correct.
( I get 1 & 4 )
When I import all type 4 get changed to type 1.
Searched all morning but could not find a solution.
Is there a setting that over rides product types when importing with EP4?

In Admin "editing " category mode (Type) doesn't have any effect on the Product Type setting of products already entered.
When entering new products in Admin the Type setting works correctly

Thank You in Advance for your time.

mc12345678:

While there are few "restrictions" really placed on the software, one that is present is by default allowing the product type to be changed on update. That said, because it is a product field, there is the ability to incorporate it as a user defined field in the configuration area. In this way, updates will attempt to modify the products_type field so long as products_type is identified there.

I've tried to look further into what might cause a change in the status and see that it seems if the v_products_type field is not present in the import file, then the value might be changed. Could you please identify the presence of that field in an import file where this type conversion has occurred? Have a few ideas about how to address what appears to be a todo item, though I thought it had been otherwise addressed.

5 Dec 2019, 9:29 PM
#3093
linuxguy2 avatar

linuxguy2

Zen Follower

Join Date:
Sep 2013
Location:
Texas
Posts:
315
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

I've tried to look further into what might cause a change in the status and see that it seems if the v_products_type field is not present in the import file, then the value might be changed. Could you please identify the presence of that field in an import file where this type conversion has occurred? Have a few ideas about how to address what appears to be a todo item, though I thought it had been otherwise addressed.

The v_products_type field is in the import file and contains the desired values ( 1 & 4)
As I indicated the export file contains the correct value 1&4 in the v_products_type field which was entered/selected via the Admin interface.
Uploading the same file flips all v_products_type back to 1.

Thanks,

5 Dec 2019, 9:32 PM
#3094
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

linuxguy2:

The v_products_type field is in the import file and contains the desired values ( 1 & 4)
As I indicated the export file contains the correct value 1&4 in the v_products_type field which was entered/selected via the Admin interface.
Uploading the same file flips all v_products_type back to 1.

Thanks,
And the settings for the User defined fields in configuration->Easy Populate V4?

6 Dec 2019, 4:35 AM
#3095
linuxguy2 avatar

linuxguy2

Zen Follower

Join Date:
Sep 2013
Location:
Texas
Posts:
315
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

And the settings for the User defined fields in configuration->Easy Populate V4?

I believe I just use the default settings.
Please see attached images
Attachment 18747Attachment 18748

7 Dec 2019, 8:50 AM
#3096
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

linuxguy2:

I believe I just use the default settings.
Please see attached images
Attachment 18747Attachment 18748
Ahh yes, that version 4.0.36.ZC did have a little issue with products_type on import which at least is partially addressed in the current master branch. I thought that change had been incorporated sooner, but see that is not the case.

Anyways, I wanted to acknowledge the issue and am trying to put together even just some code here to address it, but at the moment I'm a little short on resources.

I do "think" that if the field were added as a user identified field that the file's value would override the code's attempt to set/maintain a value.

7 Dec 2019, 4:18 PM
#3097
linuxguy2 avatar

linuxguy2

Zen Follower

Join Date:
Sep 2013
Location:
Texas
Posts:
315
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

Ahh yes, that version 4.0.36.ZC did have a little issue with products_type on import which at least is partially addressed in the current master branch. I thought that change had been incorporated sooner, but see that is not the case.

Anyways, I wanted to acknowledge the issue and am trying to put together even just some code here to address it, but at the moment I'm a little short on resources.

I do "think" that if the field were added as a user identified field that the file's value would override the code's attempt to set/maintain a value.

Cool! No rush. Just wanted to be sure I wasn't overlooking some setting.
I'll see if I can find the fix in the code, a work around or upgrade to the newest version.
Haven't used this feature before and because I'd like to display "Quantities on Hand" on specific items it will come in handy.

This Plugin has been such a time saver I can't imagine using ZC without it.

Thanks, For Your time!!!!

10 Dec 2019, 9:45 PM
#3098
msrwebmaster avatar

msrwebmaster

New Zenner

Join Date:
Sep 2008
Location:
Calgary, AB
Posts:
33
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Hi all. Upgrading from Easy Populate 1.2.5.4
Please confirm that I'm understanding this correctly:
Old version: v_categories_name_1, v_categories_name_2, v_categories_name_3 (etc.) was Category, Sub-Category, Sub-sub-Category (etc.) (ie. Vegetable, Tomato, Roma, for example)
New version: v_categories_name_1, v_categories_name_2, v_categories_name_3 (etc.) are now languages (ie. English, French, German, etc. would be Vegetable, Légume, Gemüse, etc.)
To get sub-categories, I need to put all words in the v_categories_name_1 (for English) separated by carats Vegetable^Tomato^Roma
Correct?
Thanks.

10 Dec 2019, 11:05 PM
#3099
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

MSRWebMaster:

Hi all. Upgrading from Easy Populate 1.2.5.4
Please confirm that I'm understanding this correctly:
Old version: v_categories_name_1, v_categories_name_2, v_categories_name_3 (etc.) was Category, Sub-Category, Sub-sub-Category (etc.) (ie. Vegetable, Tomato, Roma, for example)
New version: v_categories_name_1, v_categories_name_2, v_categories_name_3 (etc.) are now languages (ie. English, French, German, etc. would be Vegetable, Légume, Gemüse, etc.)
To get sub-categories, I need to put all words in the v_categories_name_1 (for English) separated by carats Vegetable^Tomato^Roma
Correct?
Thanks.

Yes, the "new" way is how EP4 operates. If the "carat" is not desired, there are ways to change it, but the carat (^) is the default character.

13 Dec 2019, 8:26 PM
#3100
msrwebmaster avatar

msrwebmaster

New Zenner

Join Date:
Sep 2008
Location:
Calgary, AB
Posts:
33
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Thanks mc1234678! Much appreciated.