EasyPopulate 4.0 Support Thread

Thanks, mc12345678, for the pointers. I'll give the updated version a go and post back here if I notice anything amiss.

Hello,
I have redone a new sheet and this did upload and show these readings at bottom: but no products in the category
Filename: Full-EP2015Sep27-212544.csv

UPDATED! - Model: SSP-100 | 1 | silver/SSP | 5 carat ge | ★Cente | | | | | | | | | | | 60 | | 360 | 0.33 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-07-24 | 1 | Stuffwhole | Handcrafte | ^Libra est | ^英镑的 | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | 5 cart 7 x | genuine to | 5 cart 7 x | | | | | | | http://www |
UPDATED! - Model: TNE-1000 | 1 | silver/tur | Double str | Double str | | | | | | | | | | | 45 | | 99 | 0.4 | 0 | 1 | 1 | 1 | 0 | 0 | | 2015-07-24 | 10 | Stuffwhole | Handcrafte | ^Libra est | ^英镑的 | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | Double str | Genuine st | Double str | | | | | | | http://www |
UPDATED! - Model: PSC4 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 2 | 1 | 1 | 0 | 0 | | 09/27/15 | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC9 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 3 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC6 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 4 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC7 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 5 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC8 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 6 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC10 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 7 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC11 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 8 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC12 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 9 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC13 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 10 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC14 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 11 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC15 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 12 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC16 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 13 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC17 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 14 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC18 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 15 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |

Finished Processing Import File

Updated records: 3
New Imported records: 13
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 7396432
Memory Peak: 7676528
Execution Time: 0.28616714477539 seconds.

lat9:

Thanks, mc12345678, for the pointers. I'll give the updated version a go and post back here if I notice anything amiss.

Thanks. I also periodically check other forks off of either version/location to see if there are reported issues/solutions and then try to incorporate. Further I try to venture out to other ZC international sites, most recently trying to check in with the italian website but for whatever reason they refuse to offer me the ability to try to post to help others having difficulty with EP4. It's been 2 months since their last post, maybe/hopefully they have gotten their questions answered some other way.

I'm almost done incorporating the German language found at a german ZC site and of course thus almost done with the language overrides for the english part as well. :)

stuffwo:

Hello,
I have redone a new sheet and this did upload and show these readings at bottom: but no products in the category
Filename: Full-EP2015Sep27-212544.csv

UPDATED! - Model: SSP-100 | 1 | silver/SSP | 5 carat ge | ★Cente | | | | | | | | | | | 60 | | 360 | 0.33 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-07-24 | 1 | Stuffwhole | Handcrafte | ^Libra est | ^英镑的 | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | 5 cart 7 x | genuine to | 5 cart 7 x | | | | | | | http://www |
UPDATED! - Model: TNE-1000 | 1 | silver/tur | Double str | Double str | | | | | | | | | | | 45 | | 99 | 0.4 | 0 | 1 | 1 | 1 | 0 | 0 | | 2015-07-24 | 10 | Stuffwhole | Handcrafte | ^Libra est | ^英镑的 | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | Double str | Genuine st | Double str | | | | | | | http://www |
UPDATED! - Model: PSC4 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 2 | 1 | 1 | 0 | 0 | | 09/27/15 | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC9 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 3 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC6 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 4 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC7 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 5 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC8 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 6 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC10 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 7 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC11 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 8 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC12 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 9 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC13 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 10 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC14 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 11 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC15 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 12 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC16 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 13 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC17 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 14 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |
NEW PRODUCT! - Model: PSC18 | 1 | silver/PSC | 24kt. Gold | Boxed 24kt | | | | | | | | | | | 9.99 | | 30 | 0.025 | 0 | 15 | 1 | 1 | 0 | 0 | | | 1 | Macy's | Handcrafte | ^Libra est | ^英镑的 | | | | | | | | | | | | | | | | | |

Finished Processing Import File

Updated records: 3
New Imported records: 13
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 7396432
Memory Peak: 7676528
Execution Time: 0.28616714477539 seconds.

So I haven't uploaded it here, but I had taken one of the previous files and modified it to the format I would have expected to find it, I then uploaded and imported it to a test site, and all product appeared including the generation of category that didn't previously exist... The site only had two languages and therefore had errors reported for trying to import the third language version.

I didn't check the second language version mostly because I don't expect that it necessarily worked properly because the category name began with a carat divider (^) which is the character to be used to indicate a sub-category from the previous category/sub-category. It may result in category population in the sub-category with no problem, but that's a different issue.

Now as for the above product not appearing in the category(ies), where was looked to see if/if not present? Admin? Store-front? Do they differ? Does this category exist already and have other sub-categories in it? From the detail at the bottom, it does appear that something was done where there were product updated and product added...

Hi,
thanks for your help with your suggestion and clicking the show product to 1 I have the products showing. I will try and remember this and do another later this week.:)
Ron

stuffwo:

Hi,
thanks for your help with your suggestion and clicking the show product to 1 I have the products showing. I will try and remember this and do another later this week.:)
Ron

If you inlcide the field status (header should be v_status) with the value set to 1, it will actvate the product on the site. All depends on how you want to manage the process.

Hi, I am having problems with easypopulate 4 importing. It says successfull yet no stock imported, can anyone help me. please.

widget50:

Hi, I am having problems with easypopulate 4 importing. It says successfull yet no stock imported, can anyone help me. please.

Version of EP4 installed?

Easypopulate 4.0 Master lastest version with zencart 1.5.4

So I added to the store some items categories etc. then i exported the file. add more items to the csv, go to upload and upload the file in easypopulate and it says successfull.

However, when i go to the store none of my stock items are in the store or new categories.

My uploads file is in my admin (as suggested to move) and has a 755 on the directory.

widget50:

Easypopulate 4.0 Master lastest version with zencart 1.5.4

So I added to the store some items categories etc. then i exported the file. add more items to the csv, go to upload and upload the file in easypopulate and it says successfull.

However, when i go to the store none of my stock items are in the store or new categories.

My uploads file is in my admin (as suggested to move) and has a 755 on the directory.

1. "lastest version" is non-specific... There are two versions currently posted and discussed in this thread... The version available from the first post of this thread is version 4.0.30. A soon to be adopted version (assuming some independent feedback) is version 4.0.31 discussed at the top of the previous page.

2. If you've only selected to upload the file, then the file is sitting on your server awaiting to be imported... Until imported, no data is attempted to be modified in the database...

Need to locate the file in the list in the table in the middle of the screen and then select to import the file. BTW, in version 4.0.32, these links will be changed to buttons to support the module submission process which expects database modifications to be made by post parameters rather than get parameters... Currently the database modification occurs based on the data/file provided, but the information in the get parameter does not specifically modify the database, somewhat a fine line (in my opinion), but close enough that it's worth making the change to ensure acceptance as a fully accepted ZC plugin and to provide the applicable/desired security of data transfer and database modification.

OMG thanks :smile: I have been looking at this for days. So i went to the file at the bottom and pressed import. LOL and viola all my stock is there. Thanks you saved my week.

widget50:

OMG thanks :smile: I have been looking at this for days. So i went to the file at the bottom and pressed import. LOL and viola all my stock is there. Thanks you saved my week.

Glad to help. Be sure to review the instructions provided in the download about how to build up the product and use the remaining features of EP4. :)

I am working with Attributes, and trying to update "v_options_values_price" and "v_products_options_sort_order" using Detailed Products Attributes (detailed multi-line)
but I get this error for ever single line:

SKIPPED! - Attribute Entry on Model: - Not Found!

I exported from EP, update the info and reloaded... didn't even change the file name...

any thoughts?

HarryJL:

I am working with Attributes, and trying to update "v_options_values_price" and "v_products_options_sort_order" using Detailed Products Attributes (detailed multi-line)
but I get this error for ever single line:

SKIPPED! - Attribute Entry on Model: - Not Found!

I exported from EP, update the info and reloaded... didn't even change the file name...

any thoughts?

Also getting this on top the page:

Warning File Import Completed with issues.
Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

HarryJL:

I am working with Attributes, and trying to update "v_options_values_price" and "v_products_options_sort_order" using Detailed Products Attributes (detailed multi-line)
but I get this error for ever single line:

SKIPPED! - Attribute Entry on Model: - Not Found!

I exported from EP, update the info and reloaded... didn't even change the file name...

any thoughts?

First, please identify version of EP4.
Second, do you use model#s in your store and does each and every product have a unique model#?
Third, when you say you exported with EP, was that wth this version of EP4? Or some other EP program?
Fourth, could you either paste the first few lines of your csv file as copied from a plain text editor and paste between ```
[code] and [/code]

Background info:
ZC151
EP4.0.31 - Beta 08-01-2015
++++

Hi All!

I'm stumped by something that seems simple. (What else is new, right? lol)

I can't seem to remove the data contained in the v_products_url_1 for about 50 products. I did a full product export for the category with the dead links, deleted the deleted the bad, and uploaded/imported... hoping to overwrite the bad links with nothing.

No dice!

Is there a trick to this? I can probably edit the table directly via phpMyAdmin or do it manually in my carts catalog but I'd rather figure out the correct EP4 method in case something like this happens again.

Any help would be appreciated!

Thanks!

++++
Btw, in the event there is no method available, I'd like to make the following suggestion:
What if you allowed a magic word (say, "Remove_Data") to trigger a DELETE sql response during import routine?

As long as the magic word was unique enough, nobody would accidentally use it.

Feznizzle:

Background info:
ZC151
EP4.0.31 - Beta 08-01-2015
++++

Hi All!

I'm stumped by something that seems simple. (What else is new, right? lol)

I can't seem to remove the data contained in the v_products_url_1 for about 50 products. I did a full product export for the category with the dead links, deleted the deleted the bad, and uploaded/imported... hoping to overwrite the bad links with nothing.

No dice!

Is there a trick to this? I can probably edit the table directly via phpMyAdmin or do it manually in my carts catalog but I'd rather figure out the correct EP4 method in case something like this happens again.

Any help would be appreciated!

Thanks!

++++
Btw, in the event there is no method available, I'd like to make the following suggestion:
What if you allowed a magic word (say, "Remove_Data") to trigger a DELETE sql response during import routine?

As long as the magic word was unique enough, nobody would accidentally use it.

To confirm the condition in which this is occurring:

1. Datafile name does not begin with the text of one of the specific filename prefixes (capitalization is not important): categorymeta-ep, attrib-, or if installed sba-
2. The field v_products_url_1 is in the datafile.
3. The row of data with the product's unique key (products_model typically) is listed one time or if listed more than once, then the last occurrence has the data for the v_products_url_1 field that is desired.
4. That the about 50 products to be modified are in the import file.
5. That the v_products_name field is included in the datafile.

Regarding the separate "trigger", the expectation is that if the row data below the column header is exported and modified that import will reverse the process with the data that has been modified. The results in a final state of the data to be what was provided in the rows below the column headers. There are two "magic words" that have been incorporated, one is a product status (v_status) of 9 which will delete the entire product from the database following the process that is invoked by ZC. The second is a status of 7 which moves the master_categories_id to the category identified in the row that has status of 7 (creating the category as necessary) and if previously assigned to a master_categories_id removes the product from the category that was the previous master_categories_id. In all other cases, the expectation is that the data presented to EP4 is what will be entered into the database, so a lack of data (blank) in a field will import a blank to the database.

That is the "standard" operation for most of the tables in ZC as the row of data tends to exist for the product whether the data is "blank" or not. An exception to this can be seen in the attributes area when addressing downloads or music. Downloads have an additional table that when that table has data in it for that product indicates that the attribute is download related, no entry in that table and the attributes are "not download related". SBA (Stock by Attributes) operates similarily, a product can have attributes, but not be tracked by SBA. Those products that have attributes and are tracked by SBA appear in the products_with_attributes_stock table. If they are removed from that table, then they are no longer tracked by SBA... Because of the uniqueness of both of these aspects (SBA and ie. downloads), they are each handled separately.

Sorry went off a little in a tangent, but basically, data of import file in the applicable column (field) ought to replace the existing data of the database. If it is not to be modified, either remove the product, remove the field, or don't change the field from export to import... This is also why it is suggested to backup the database before an import in the event that incorrect data is entered that it can be restored...

mc12345678:

5. That the v_products_name field is included in the datafile.

Huh? That must have been the problem!

mc12345678:

... basically, data of import file in the applicable column (field) ought to replace the existing data of the database. If it is not to be modified, either remove the product, remove the field, or don't change the field from export to import...

Because of what you just said, I typically remove any column I do not want modified, leaving only what I am changing, plus the control (model# being EP4 default). Since I wasn't changing product_name, I removed it.

But I just uploaded with product_name included (all fields, really) and it went in exactly as expected, removing the foul links.

Thanks, MC! You da man!

Feznizzle:

Huh? That must have been the problem!

Because of what you just said, I typically remove any column I do not want modified, leaving only what I am changing, plus the control (model# being EP4 default). Since I wasn't changing product_name, I removed it.

But I just uploaded with product_name included (all fields, really) and it went in exactly as expected, removing the foul links.

Thanks, MC! You da man!

I'll take another look at that section of code. I think in the addition of languages/an extended field if found present in the database that the test for that sql to be run or not didn't get updated... It looks like originally that code section was intended only to address the products_name field and to be run only if a name was to be inserted or updated... Then along came some other fields... I expect to revise it to still do a test, but 1) only call the code section if something within is to be acted on and 2) only to include the field(s) with data to optimize the query as able.

mc12345678:

1. only call the code section if something within is to be acted on and 2) only to include the field(s) with data to optimize the query as able.

That seems so much more logical to me! First hit the index (model# being default), then check field. If the index supplies point of reference, no need to act on anything other than supplied fields.

Wait, maybe that's backwards? First check fields to find out what needs action (code needs calling), then apply only to indexed entry.

Having to supply the product name when all I wanted to do is alter product_url seemed illogical.

Anyway, glad your on it! Thanks again!