EasyPopulate 4.0 Support Thread

[chadderuski]

it says it was imported fine (green highlight on top of admin)
but when i look in phpMyAdmin or the zen cart store, its not updated :/

any reasons for this?

Please either attach or PM me your data file, or a portion there of.
You are clicking on Import after Uploading the file?

-chadd

[larryweiss]

Width
24
24
25...
Length
30
31
32.......

It would help to see an example on your site. But if you can create the Options Name/Options Values in Zencart, you can also with EP4.

Sure. A relevant page is:

http://www.sofabed-mattress dot com/sleeper-sofa-bed-mattresses/premium-sofabedmattress.htm

[chadderuski]

Announcment: New version 4.0.21 posted to github

https://github.com/chaddro/EasyPopulate-4.0

Fixes in this version:
- products_type on import bug
- admin security error when using admin profiles in v1.5
- new way of checking database collation... to fix mult-byte issues when UTF8 is not used.

Getting close to submitting to zencart team! Thanks again to everyone for testing and your feedback!

-chadd

[su35]

Hi Chadderuski

Thanks for the great work. I installed the version 4.0.21 and compared with the Easy Populate CSV 1.2.5.7 that I am using. The "custom field", a function in the Easy Populate CSV 1.2.5.7, are very useful. If possible, hope you can add this function to the EP4.

SU35

[shopsfm]

Hi Chadderuski

Thanks for the great work. I installed the version 4.0.21 and compared with the Easy Populate CSV 1.2.5.7 that I am using. The "custom field", a function in the Easy Populate CSV 1.2.5.7, are very useful. If possible, hope you can add this function to the EP4.

SU35

I agree I need to add "custom fields" , "Cost" (my cost) and "Warehouse" (where I get the item from) to my spreadsheets in a hidden field but not sure how to do it.

sorry again for so many questions and THANK YOU for the quick responses.

[chadderuski]

Hi Shopsfm and su35,

I will look into it. However, my version makes adding your own custom fields rather easy. A good "how-to" was posted earlier in this thread. You can add your own fields for the products database in something like 15 minutes work.

I'll see where I am at in my list of to-do's. If 4.0.21 goes well, I'll want to submit to the zencart team and exit beta.
That takes priority. I also need to flesh out the docs... something along the lines of what Schoolboy did for 1.2.5.4.

I appreciate the feed back. Keep it coming!

-chadd

[shopsfm]

I think I found how to add database custom fields
http://www.zen-cart.com/showthread.p...t-Thread/page5
http://www.zen-cart.com/showthread.p...-Thread/page21
hopefully this works.

[chadderuski]

I think I found how to add database custom fields
http://www.zen-cart.com/showthread.p...t-Thread/page5
http://www.zen-cart.com/showthread.p...-Thread/page21
hopefully this works.

Yep, Igi2011 did a great job laying it all out in post 205. Just note that the line numbers have changed.
Also, if you follow the formula and add your fields as a "mod", you will be able to easily patch them into newer releases.

I will look into the custom fields of Easy Populate CSV 1.2.5.7 when time permits. A lot of the current work I've done may actually make that easy to do... we'll see.

-chadd

[shopsfm]

did not work
followed post 205
Here is what I did.. Trying to impout a hidded field "Cost"

easypopulate_4.php

line 102
$ep_supported_mods['Cost'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_Cost');

*********************

easypopulate_4_import.php

line 30
if ($ep_supported_mods['Cost'] == true) { // Cost - chadd
$default_these[] = 'v_products_Cost';
line 322
if ($ep_supported_mods['Cost'] == true) { // Cost- chadd
$sql .= 'p.products_cost as v_products_Cost,';
line 936
if ($ep_supported_mods['Cost'] == true) { // Cost
$query .= "products_Cost = '".addslashes($v_products_Cost)."',";

line 1025
if ($ep_supported_mods['Cost'] == true) { // Cost
$query .= "products_Cost = '".addslashes($v_products_Cost)."',";
*************************

easypopulate_4_functions.php


line 79
if ($ep_supported_mods['Cost'] == true) { // Cost
$filelayout[] = 'v_products_Cost';

line 160
if ($ep_supported_mods['Cost'] == true) { // Cost
$filelayout_sql .= 'p.products_Cost as v_products_Cost,';

any help or link to a tutorial would be greatly appriciated.

[SPH]

One this that is important to remember!

The BASIC import can be used to CREATE and MODIFY the options names and options values names attached to a specific product.

But the DETAILED is ONLY used to UPDATE a specific products model, option name, options values name combo. This is why those first columns must remain untouched. The _id's are used to find and update that specific combo. Although not very flexible, this works well and is quick.

I am waiting for feedback on what COMMON additional columns would be useful for the BASIC import, but have not received any feedback on that yet.

I hope this clears things up.

Chadd,

ZC 1.5, this product:
http://www.webdivision.prommart.com/...roducts_id=191

We think we know how your Basic Attributes work.

But we probably really need the Detailed Attributes sheet to do our V-Lookup thing off of the column headings I mentioned some months ago.

I guess my question is: Can I use the Detailed Attributes sheet to ADD another color to this product? If so, how.

I tried and think that I am stuck on column A...v_products_attributes_id

I tried adding what should be the next number in order, but didn't work.

Thanks.

Steve