EasyPopulate 4.0 Support Thread

Quote:

---

Originally Posted by Jenovee

Hello. Thanks for the reply, mc. I changed the code as you stated (just the number "2") and tried it again. No, it's still doing the exact same thing. It imports everything fine, but still deletes the product name.

I logged out and back in also, just in case it needed to "refresh" in some way. But same thing over and over. :(

---

So, what was the filename of your modified file with just quantity modified? What version is being used currently? What fields are in the file? What if any custom fields are used?

I took a "risk" and after downloading the file that was created from the section that says import/export for model/price/qty. I modified the file to change just the number of quantity for a product. I intended to delete all but the one row, but I uploaded all of the rows and had no loss of the product name. I did see the change of quantity that I uploaded, but didn't experience the issue described by following the above process...

For this, I'm following the same method as when I export the complete products and add new products. I export the file, edit, then upload the same exact file. The filename never gets changed. The latest filename is -- "PriceQty-EP2015Mar30-043833.csv". I've exported it multiple times during this problem, and the filename is always named the same way.

The version of EP is 4.0.28 - Beta 01-03-2015. The ZC version is v1.5.4.

No custom fields on this. Just the standard -- v_products_model v_status v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_quantity

I'm wondering if something is wrong with my installation then. I'll keep testing different ways to see if I can figure this out.

Quote:

---

Originally Posted by mc12345678

So, what was the filename of your modified file with just quantity modified? What version is being used currently? What fields are in the file? What if any custom fields are used?

I took a "risk" and after downloading the file that was created from the section that says import/export for model/price/qty. I modified the file to change just the number of quantity for a product. I intended to delete all but the one row, but I uploaded all of the rows and had no loss of the product name. I did see the change of quantity that I uploaded, but didn't experience the issue described by following the above process...

---

Also, just so we are clear on how I am doing this. I am doing my edits the same way someone would add new products. At the bottom (end) of the spreadsheet, I add the product information as if it were a new product. From my understanding, it should just overwrite whatever information has been changed. It seems to work fine, since it edits the quantity and doesn't create a doubled product. BUT it deletes the product name.

Now .... when I specifically go to a current item .... if I merely change the qty and import, everything is fine. Qty gets updated and everything is in tact. The filename only gets wiped when the method is like I'm adding a new product.

Does this plugin allow exporting products images as well?

Quote:

---

Originally Posted by Thannaree

Does this plugin allow exporting products images as well?

---

This plugin is a database related plugin and will export the path to the base image (please read the applicable FAQ for additional images). It does not export the actual image itself. It is generally considered that ftp be used to export the file that is the image (or "right" clicking the image and saving it when it is displayed onscreen).

Quote:

---

Originally Posted by Jenovee

Also, just so we are clear on how I am doing this. I am doing my edits the same way someone would add new products. At the bottom (end) of the spreadsheet, I add the product information as if it were a new product. From my understanding, it should just overwrite whatever information has been changed. It seems to work fine, since it edits the quantity and doesn't create a doubled product. BUT it deletes the product name.

Now .... when I specifically go to a current item .... if I merely change the qty and import, everything is fine. Qty gets updated and everything is in tact. The filename only gets wiped when the method is like I'm adding a new product.

---

This is a process different than tested... Seems that if the model# is known, it could be just as easily searched for as compared to retyped, unless I am missing something... Will still look at the process to see why "adding" the product anew in the list has a different affect than modifying the item in the list. Would almost suggest in this scenario that all other line records be removed from the list other than the one instance of the model#(s) being revised.

For further clarification when stating:

Quote:

---

Originally Posted by Jenovee

The filename only gets wiped when the method is like I'm adding a new product.

---

the term filename refers to the product name correct? And that is the only data that the code removes or unexpectedly modifies in this scenario?

Quote:

---

Originally Posted by mc12345678

This is a process different than tested... Seems that if the model# is known, it could be just as easily searched for as compared to retyped, unless I am missing something... Will still look at the process to see why "adding" the product anew in the list has a different affect than modifying the item in the list. Would almost suggest in this scenario that all other line records be removed from the list other than the one instance of the model#(s) being revised.

---

Yes, it would be error-free doing it by search and edit method. The reason I am doing it this way is because I am trying to sync my quantities with those of a dropshipper. I would have to manually search for every product to edit, which would take hours. But this way, I can simply import all the data within a few minutes. Even products I don't carry can be imported without sorting, since EP will simply ignore it with: "SKIPPED! - Model: CGG3333333333 - No category provided for this new product"

Since there is no dropshipper module that I can find, this is the easiest and fastest method I currently see.

Quote:

---

Originally Posted by mc12345678

For further clarification when stating:


the term filename refers to the product name correct? And that is the only data that the code removes or unexpectedly modifies in this scenario?

---

Yes, I'm sorry. I was typing faster than I was thinking. I meant to say the product name; and only the product name.

Quote:

---

Originally Posted by Jenovee

Yes, it would be error-free doing it by search and edit method. The reason I am doing it this way is because I am trying to sync my quantities with those of a dropshipper. I would have to manually search for every product to edit, which would take hours. But this way, I can simply import all the data within a few minutes. Even products I don't carry can be imported without sorting, since EP will simply ignore it with: "SKIPPED! - Model: CGG3333333333 - No category provided for this new product"

Since there is no dropshipper module that I can find, this is the easiest and fastest method I currently see.



Yes, I'm sorry. I was typing faster than I was thinking. I meant to say the product name; and only the product name.

---

No problem, just double checking...

So back to my earlier suggestion, how do things work if the file is "blank" of products listed and just the dropshipper's data populates it? (Headings still in place and assuming that the dropshipper's data has the model listed once only. If listed more than once, could setup a quick calc column to show a duplicate and then delete the desired duplicate before saving for uploading.)

Quote:

---

Originally Posted by mc12345678

No problem, just double checking...

So back to my earlier suggestion, how do things work if the file is "blank" of products listed and just the dropshipper's data populates it? (Headings still in place and assuming that the dropshipper's data has the model listed once only. If listed more than once, could setup a quick calc column to show a duplicate and then delete the desired duplicate before saving for uploading.)

---

Ahhhhhh, I was able to try it just now. I did everything exactly the same, but then I deleted ALL my products. I imported just 1 line of data. Everything seems good! The item name is fine, and all other data seems intact.

I will keep testing it, but this method seems to work. Thank you MC. :smile:

Quote:

---

Originally Posted by mc12345678

This plugin is a database related plugin and will export the path to the base image (please read the applicable FAQ for additional images). It does not export the actual image itself. It is generally considered that ftp be used to export the file that is the image (or "right" clicking the image and saving it when it is displayed onscreen).

---

Thank you

Hi mc12345678

so will the code you posted fix the v_options_values_price_w issue? or is that an added feature of an update in the works?

$row2 = ($ep_uses_mysqli ? mysqli_fetch_array($result2) : mysql_fetch_array($result2));

Quote:

---

Originally Posted by HugoStiglitz

Hi mc12345678

so will the code you posted fix the v_options_values_price_w issue? or is that an added feature of an update in the works?

$row2 = ($ep_uses_mysqli ? mysqli_fetch_array($result2) : mysql_fetch_array($result2));

---

No, unfortunately the posted fix does not address the field that is in question.

Perhaps I could get a little help based on the following:
To ensure that the new field is incorporated only for those that have the applicable plugin installed, what "flag" on the right side of the screen indicates "on" or "yes" when only the applicable plugin is installed?
If the answer is none, then I have a clear path forward.
If something specific, then need to account for that "other" plugin and this one.
Verification on my side to identify requires me to install the. Plugin upfront to correct (a bit of a time issue involved and I'd like to provide a resolution rapidly)

Jeking, able to identify this?

unfortunately I'm not sure what you mean.
however I can provide access to the admin & ftp of an installation that has the plugins installed.

Quote:

---

Originally Posted by HugoStiglitz

unfortunately I'm not sure what you mean.
however I can provide access to the admin & ftp of an installation that has the plugins installed.

---

I would think that simply having access to the EP4 application under tools would be sufficient for what I need, or a screen shot of the same without divulging your admin directory.

is this what you are after?

Attachment 15117

Yup. Thanks.

It'll be a new section to add for support. Clear path as identified above. :)

I just tried the attribute pricing for the first time. My results are different than Hugo's. I had existing product with attribute prices that I just created. I exported the file to see how it all looked. I also entered attribute pricing for another new product I had just created. The new prices updated into catalog.

But, the prices are all prefixed with a "0". In my drop-down list, instead of "$2.50", it's "[email protected]". And this is not just for the new prices I entered. The existing prices on the product that already had prices before the export are also changed to "0$x.xx" now.

Since this is different than Hugo's issue, I'm just mentioning it in case the fix is different.

Okay, I just went back to figure out what happened. Since this is my first time with attribute pricing, I now see what happened. Importing the file has somehow changed the prefix from "+" to "0". Now that I can explain it better, it should be easier to understand. :)

Quote:

---

Originally Posted by Jenovee

Okay, I just went back to figure out what happened. Since this is my first time with attribute pricing, I now see what happened. Importing the file has somehow changed the prefix from "+" to "0". Now that I can explain it better, it should be easier to understand. :)

---

To try to help as quickly as possible before identifying a more global fix, does your export file have a zero in the field of the prefix (original file) or is it blank?

Quote:

---

Originally Posted by mc12345678

To try to help as quickly as possible before identifying a more global fix, does your export file have a zero in the field of the prefix (original file) or is it blank?

---

Yes, it seems to be converting the prefix to "0" on export. Some items are blank, while others have zeros. I can't tell why though.

Quote:

---

Originally Posted by Jenovee

Yes, it seems to be converting the prefix to "0" on export. Some items are blank, while others have zeros. I can't tell why though.

---

If the zero is appearing on export (to the csv file from ZC) then the zero was already in the database. Overall, Zc is basically supposed to ignore any different character if it is not a minus basically. Anything other than a minus in a default install I thought it was supposed to display as a +. Maybe it is process as a plus but display whatever is entered. Anyways, to fix, from within your editor (ideally Open Office) simply change and save that column with either blank if nothing is to prefix the display or the appropriate symbol to display (+, -, etc...)


Should fix your issue, then could export again to see if it remains as input.

Quote:

---

Originally Posted by mc12345678

If the zero is appearing on export (to the csv file from ZC) then the zero was already in the database. Overall, Zc is basically supposed to ignore any different character if it is not a minus basically. Anything other than a minus in a default install I thought it was supposed to display as a +. Maybe it is process as a plus but display whatever is entered. Anyways, to fix, from within your editor (ideally Open Office) simply change and save that column with either blank if nothing is to prefix the display or the appropriate symbol to display (+, -, etc...)


Should fix your issue, then could export again to see if it remains as input.

---

Well, I just restored my database to how it was before I decided to mess with attribute pricing. Comparing the exported file to what was in my catalog, I can see that it's changing values. I have products with size/color attributes, but no prices attached to them. I can see a blank field for attrib price when in admin panel, and it has the "+" prefix. On export, that plus gets changed to zero. I manually changed one of the changed zeros back to "+" and exported again. It changed back to zero on export. It's changing values rather than ignoring.

Quote:

---

Originally Posted by Jenovee

Well, I just restored my database to how it was before I decided to mess with attribute pricing. Comparing the exported file to what was in my catalog, I can see that it's changing values. I have products with size/color attributes, but no prices attached to them. I can see a blank field for attrib price when in admin panel, and it has the "+" prefix. On export, that plus gets changed to zero. I manually changed one of the changed zeros back to "+" and exported again. It changed back to zero on export. It's changing values rather than ignoring.

---

Are you using the detailed products attributes to export your data? I get plusses exported from a ZC 1.5.3 site. Or a blank entry (if no symbol is entered). And then where I have a sample product that uses multiplication I have my x there. If not using the detailed attributes, please clarify which method so that one can be fixed...

Quote:

---

Originally Posted by mc12345678

Are you using the detailed products attributes to export your data? I get plusses exported from a ZC 1.5.3 site. Or a blank entry (if no symbol is entered). And then where I have a sample product that uses multiplication I have my x there. If not using the detailed attributes, please clarify which method so that one can be fixed...

---

Yes, I am using the detailed products attributes to export.

I am comparing more in depth now. This may sound strange, but this is what is happening on one specific item in the catalog:

From attributes controller, I can see all the attributes. I have eight total attributes on this one product. Four have no prefix. Four have "+" prefix. The four with no prefix show as blank on export. The four with "+" prefix all get converted to zero on export.

I don't have a single "+" prefix on my exported file at all.

Quote:

---

Originally Posted by Jenovee

Yes, I am using the detailed products attributes to export.

I am comparing more in depth now. This may sound strange, but this is what is happening on one specific item in the catalog:

From attributes controller, I can see all the attributes. I have eight total attributes on this one product. Four have no prefix. Four have "+" prefix. The four with no prefix show as blank on export. The four with "+" prefix all get converted to zero on export.

I don't have a single "+" prefix on my exported file at all.

---

Yeah does sound strange seeing as not able to reproduce the issue.
What is being used to view the result? Does a zero show up when looking at the csv file with a plain text editor?

Quote:

---

Originally Posted by mc12345678

Yeah does sound strange seeing as not able to reproduce the issue.
What is being used to view the result? Does a zero show up when looking at the csv file with a plain text editor?

---

Everything is being done with Open Office. I no longer use Excel since coming to this forum. :laugh:

I opened it in Note Pad ++. What a mess to look at. But it shows the same basic result. The blanks are "" and the zeros are "0".

Quote:

---

Originally Posted by mc12345678

Anyways, to fix, from within your editor (ideally Open Office) simply change and save that column with either blank if nothing is to prefix the display or the appropriate symbol to display (+, -, etc...)


Should fix your issue, then could export again to see if it remains as input.

---

Sorry it took a while. I just tried your suggestion. Changing the values back to "+" can't be done. Are you able to edit that field with whatever you like and save???

I entered "+" into one field. I am now stuck in that field. I cannot get out! When I click on another box, the original box that I am stuck inside will change to "+xx", with the "xx being the new cell/box I am in.

So with this new info, could my issue be with Open Office, rather than EP? Then again, my NotePad++ view shows it seperate from Open Office. ..........

Try pressing the enter key after changing the "value" to a plus. By clicking outside of the cell after entering a plus, OO is trying to add the cell that is next clicked. :)

As for the output, EP4 is pulling the information from the database and storing it.. There are no inline conversions performed (ie, no assignment to a string or an integer.). The only other things I wonder about is 1) what's stored in the database when a plus is used within ZC (for your site), what data type it is, and what charset is involved...

As for putting "anything" in the cell, default ZC behavior at least for adding and subtracting of attribute prices is: if a negative, subtract the price, anything else add it...

The product thing I was talking about above is some extra code that I have written where - subtracts; x, X, or * multiplies; and everything else adds... But yes can put "whatever" desired.

Oh brother. LOL! You can tell I don't use the "+" key much in spreadsheets. :laugh:

Anyways, I looked at the actual database. The prefix value is stored properly with the "+" before export. The type is "char(1)".

I didn't pay attention before this because I had no need. But the products_attributes_weight_prefix is also changing to zero along with the price prefix. It may not be connected at all, but these are the only two things using the "char(1)" type in the database.

Okay, I'm brand new to Zen Cart, and wanted to post a thank you to everyone that has contributed to this plugin because it worked perfectly for me!!

I installed Zen Cart(1.5.1) on Host Gator shared hosting using the script that they provided, so it's the only site on my server at this point.

I had tried a different version of EP that claimed to offer csv support, as well as another one that claimed to work with native Excel files. Neither worked out for me.

I found that with this plugin, I did end up using Open Office (and was surprised to find it's not Apache Open Office) to edit the files as suggested.

Again, thank you, and good luck to anyone else struggling with this plugin - it's worth it!

Quote:

---

Originally Posted by Clayo84

Okay, I'm brand new to Zen Cart, and wanted to post a thank you to everyone that has contributed to this plugin because it worked perfectly for me!!

I installed Zen Cart(1.5.1) on Host Gator shared hosting using the script that they provided, so it's the only site on my server at this point.

I had tried a different version of EP that claimed to offer csv support, as well as another one that claimed to work with native Excel files. Neither worked out for me.

I found that with this plugin, I did end up using Open Office (and was surprised to find it's not Apache Open Office) to edit the files as suggested.

Again, thank you, and good luck to anyone else struggling with this plugin - it's worth it!

---

Welcome to ZC, glad to hear that you've gotten this far, though using the install script, you've missed out on a lot of the learning opportunities of managing ZC. Hopefully, you'll take the time in the near future to manually upgrade to the latest ZC version, which can be done while your current store remains functional/operational. But I digress.

For some reason, cause yet to be determined the export of a char(1) value of a plus, is being translated to a 0 on export. We haven't discussed versions of software yet, the identification of the various charsets (includes/configure.php, admin/includes/configure.php, database tables and one other place I can't remember), nor the status of internal character encoding (top right in the Easy Populate 4 screen).

Anyways, the majority of the issues are in the usage of the plugin, not the plugin itself, although this current issue appears to be a bit of an anamoly to the local setup, not so much the program itself.

Thinking of beginning a new thread with the details of the code compressed down to the applicable actions, when I create it, I'll post the link here. Jenovee, if you wouldn't mind following and subscribing to it, maybe this can be resolved.

Hi, I have installed Ep4 v4.0.28 on a local machine test site with zc1.5.4 and SBA 1.5.4. Everything seems to be working so far. I have a couple of problems/questions though. Do I need to add the custom id field in the EP4 configuration options? If I upload the file with this field empty I get an error (check for tabs in fields) and if there is data in this field it all works fine. It is showing in the downloaded files without being added in the configuration. Secondly my product display is now showing the custom id in the quantity box. Any ideas as to how to stop this from showing.

Quote:

---

Originally Posted by propster

Hi, I have installed Ep4 v4.0.28 on a local machine test site with zc1.5.4 and SBA 1.5.4. Everything seems to be working so far. I have a couple of problems/questions though. Do I need to add the custom id field in the EP4 configuration options? If I upload the file with this field empty I get an error (check for tabs in fields) and if there is data in this field it all works fine. It is showing in the downloaded files without being added in the configuration. Secondly my product display is now showing the custom id in the quantity box. Any ideas as to how to stop this from showing.

---

Still a few "variables" in the mix... Although the few branches that are off of the potteryhouse revised version of SBA would not impact the functionality/interaction of EP4 with SBA, the version does modify how the information is displayed.

To bring things home a little, the customid that is a part of the potteryhouse version of SBA should not need to be added to the configuration->EP4->custom fields menu option and in fact would not provide anything of benefit because custom fields area is a products table field not associated with other tables. SBA creates a products_with_attributes_stock table. In that table is customid. When using the detailed SBA export/import (sba-detailed-ep is the filename prefix), effectively this additional feature expects that the SBA variants (row of data) already exist and that only the products_id, stock_attributes, quantity, sort, and in this case the customid (as customid is included with SBA 1.5.4) fields are updated... This additional feature remains limited and follows the development of SBA, meaning that some of the additionally desired actions must wait a little to ensure that the feature in SBA is to remain and/or how it is to be used moving forwards.

Then there is the sba-stock-ep prefix named file, which is only for stock tracking purposes. So, the current detailed SBA attributes (described in the README.txt of the download) is basically a stock tracking tool at this time, with the expectation that the SBA product variants would be setup through the database. (Of course EP4 could be used to create many of the aspects of the products, with going into the admin control panel to generate the variants, and then EP4 could be used to manage the quantities of the existing variants.)

I'm not sure about the issue of the customid showing in the quantities box, again there are a few variables at play. What does your actual import file look like? (A few lines of it anyways) What did the same line(s) (of model number data) look like before modification? What is the file name(s) involved? (at least the prefix, as these files are processed based on the beginning of the filename... There's only so much that can be done to help based on the information provided above in the original post, so please help identify all the details associated. The version numbers were a good start, but there is far more involved than versions.

Quote:

---

Originally Posted by mc12345678

Thinking of beginning a new thread with the details of the code compressed down to the applicable actions, when I create it, I'll post the link here. Jenovee, if you wouldn't mind following and subscribing to it, maybe this can be resolved.

---

Yes, I'll help in any way I can. I'm really curious as to what's causing this. Especially since, so far, it seems like I'm the only one with this issue. And also the only one with the item name being deleted.

Quote:

---

Originally Posted by Jenovee

Yes, I'll help in any way I can. I'm really curious as to what's causing this. Especially since, so far, it seems like I'm the only one with this issue. And also the only one with the item name being deleted.

---

Well there was one other that was experiencing a loss of names issue when the names column was removed from the import. So that aspect was similar but different.

Ok Thanks for the quick reply. I am downloading SBA-Detailed-EP2015xxx. I try to re-import the file without opening it and get the following message. An SQL error has occurred. Please check input data for tabs within fields and delete these. If this error continues please forwrd your error log to the Easy Populate maintainer. I have attached the error log and a screen shot of my admin area.
I have solved the problem of the quantities box. It was a configuration option which needed to be edited.

Issue is that the code is/was written thinking that the customid was going to be a unique number... However, it is a string, so working on a change to accommodate in addition to a few other minor changes...

Quote:

---

Originally Posted by mc12345678

Issue is that the code is/was written thinking that the customid was going to be a unique number... However, it is a string, so working on a change to accommodate in addition to a few other minor changes...

---

Doesn't fix Jenovee's issue(s), but 4.0.29 has been pushed to: https://github.com/mc12345678/EasyPopulate-4.0

If I get a few to validate the new operation, then perhaps it can be merged into the main version.

Changes:
-Added support for products_map modification (Manufacturer's Advertised Price)
-Added MSRP export to areas where previously begun but not fully incorporated.
-Modified import of customid for SBA-detailed-attributes to treat as a string.
-Began incorporating language overrides, specifically with German as the first alternate language.
-Added support for the plugin dual pricing.

No changes were made to the configuration menu in this version. Upgrade from 4.0.28 should be by replacement of the files only.

Quote:

---

Originally Posted by mc12345678

Doesn't fix Jenovee's issue(s), but 4.0.29 has been pushed to: https://github.com/mc12345678/EasyPopulate-4.0

If I get a few to validate the new operation, then perhaps it can be merged into the main version.

Changes:
-Added support for products_map modification (Manufacturer's Advertised Price)
-Added MSRP export to areas where previously begun but not fully incorporated.
-Modified import of customid for SBA-detailed-attributes to treat as a string.
-Began incorporating language overrides, specifically with German as the first alternate language.
-Added support for the plugin dual pricing.

No changes were made to the configuration menu in this version. Upgrade from 4.0.28 should be by replacement of the files only.

---

Thanks again for a very quick response. This is now working how I want. I have managed to download the SBA-Detailed file and re-import without errors. I have also changed quantities and re-imported without any problem. Thanks again for all your work.

Quote:

---

Originally Posted by propster

Thanks again for a very quick response. This is now working how I want. I have managed to download the SBA-Detailed file and re-import without errors. I have also changed quantities and re-imported without any problem. Thanks again for all your work.

---

Glad to know that fix was successful, the stock tracking/updating aspect already properly treated the model# as a string. Next validation? :P

Hi all,

We have just had our site upgraded to version 1.5.4 and have Easy Populate 4.0.28 - Beta 01-03-2015 which are testing at present before we go live. Here is some server info:
PHP Version: 5.3.28 (Zend: 2.3.0) PHP Memory Limit: 128M
Server OS: Linux 3.18.5-x86_64-linode52

The EP4 version seems to work ok apart from one thing when I add a new product in csv file it loads it to the site but does not load into the fields. Below is information regarding the upload.
UPDATED! - Model: A16783 | 1 | Product im | Genuine Ro | | | | | | 22.55 | A16783 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-16 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: 732-04839 | 1 | Product im | Genuine Ro | | | | | | 2.68 | A16800, 73 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-16 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: 787-01951 | 1 | Product im | Genuine Ro | | | | | | 2.5 | A16801, 78 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-16 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: A318228 | 1 | Product im | Genuine Ro | | | | | | 0.91 | A318228 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
No model field in record. This line was not imported1 | Product im | Genuine Ro | | | | | | 0 | | 0 | | | | 0 | 0 | | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | 0001-01-01 | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: A123456 | 1 | Product im | Genuine Ro | | | | | | 1 | A123456 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | | 0 | | | 0.5 | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | 0001-01-01 | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |

Once done I go to the product A123456 that has not added the information to the required fields within it (not that this is only with new product). If I change information on product that are already on the site they are changed using the EP4 module correctly.

Am I doing something wrong when I add new product in the csv file. I have tried copying a line of information already in the file and changed part number and price but still fields are left blank.

Any help would be appreciated as I really like the module and want to sort out if it is the person (ME) on the keyboard not doing correctly.

Sorry to see that you are having difficulty. From the above data though, the item with model# A123456 is not a new item but an update of an existing item indicating that there already exists an item with that model#.

If that is so, then when going back to look at the "desired" new item, what is happening is that another has been updated.

To confirm this situation, if you export the complete product list, you can then sort on model # and look for duplicates. Starting specifically with that model#.

Otherwise it may help to identify the process of which report method is chosen to export the file, then what filename the changes are saved as for upload. More questions may follow, but that is a start.

mc12345678,

The original file did add as a new product and because the fields were not filled out I then attempted to add more information to see if the fields would then update, which did not happen. I have tried to update several times and still nothing happens.

I have checked for duplicates and do not have any using the search option in the admin/categories.



I deleted the product and installed again and this is the message that I received after re-installing:

UPDATED! - Model: 787-01951 | 1 | Product im | Genuine Ro | | | | | | 2.5 | A16801, 78 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-16 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: A318228 | 1 | Product im | Genuine Ro | | | | | | 0.91 | A318228 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
No model field in record. This line was not imported1 | Product im | Genuine Ro | | | | | | 0 | | 0 | | | | 0 | 0 | | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | 0001-01-01 | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
NEW PRODUCT! - Model: A123456 | 1 | Product im | Genuine Ro | | | | | | 1 | A123456 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0.5 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |

Updated records: 156
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 15648440
Memory Peak: 16318192
Execution Time: 2.96993088722 seconds.

I have also noted that it is not loading user defined product fields which are: products_sku,products_price_carrot,products_length,products_height,products_widt h,products_carrot,threshold_set,products_condition,products_EHF,additional_skus, additional_skus_only,discontinue,products_pdf_attachment,products_vendor_code,pr oducts_vendor_price,availability_id

I am assuming that It has to do with the user defined product fields.

Quote:

---

Originally Posted by Bruce1952

mc12345678,

The original file did add as a new product and because the fields were not filled out I then attempted to add more information to see if the fields would then update, which did not happen. I have tried to update several times and still nothing happens.

I have checked for duplicates and do not have any using the search option in the admin/categories.



I deleted the product and installed again and this is the message that I received after re-installing:

UPDATED! - Model: 787-01951 | 1 | Product im | Genuine Ro | | | | | | 2.5 | A16801, 78 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-16 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
UPDATED! - Model: A318228 | 1 | Product im | Genuine Ro | | | | | | 0.91 | A318228 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
No model field in record. This line was not imported1 | Product im | Genuine Ro | | | | | | 0 | | 0 | | | | 0 | 0 | | none | | | 0 | | | | | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | 0001-01-01 | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |
NEW PRODUCT! - Model: A123456 | 1 | Product im | Genuine Ro | | | | | | 1 | A123456 | 0 | 0 | 0 | 0 | 0 | 0 | New | none | | 0 | 0 | | | 0.5 | 0 | 0.2 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-02-17 | 0 | Rover | Lawn Mower | Taxable Go | 0 | 0 | 0 | 0 | 0 | 0 | | | |

Updated records: 156
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 15648440
Memory Peak: 16318192
Execution Time: 2.96993088722 seconds.

I have also noted that it is not loading user defined product fields which are: products_sku,products_price_carrot,products_length,products_height,products_widt h,products_carrot,threshold_set,products_condition,products_EHF,additional_skus, additional_skus_only,discontinue,products_pdf_attachment,products_vendor_code,pr oducts_vendor_price,availability_id

I am assuming that It has to do with the user defined product fields.

---

Quote:

---

Originally Posted by mc12345678

Sorry to see that you are having difficulty. From the above data though, the item with model# A123456 is not a new item but an update of an existing item indicating that there already exists an item with that model#.

If that is so, then when going back to look at the "desired" new item, what is happening is that another has been updated.

To confirm this situation, if you export the complete product list, you can then sort on model # and look for duplicates. Starting specifically with that model#.

Otherwise it may help to identify the process of which report method is chosen to export the file, then what filename the changes are saved as for upload. More questions may follow, but that is a start.

---

Still need this and more information... Not in front of your computer, so can not make random guesses at what is going on. Now there are new things not previously identified with which to contend. In what table(s) are all of those extra fields? Are they all listed in the configuration->Easy Populate 4->custom fields entry? What data type is each one? Are they all listed in the example provided above? If your datafile only had one record in it, do you get a different result? What EP4 file modifications are there? What happens if you omit the custom fields from the import? What program is used to modify the files?

I just installed this or tried to and am getting an error that I cannot seem to find the cause.
ZC154 apache Mysql
the plugin is from the download link (purchased) and then again from github.
The error is when I click on the tools tab for EP4
EP4 FATAL ERROR: No default language set.
The site is using en (it's the only language installed)
From Apache error log:
[Fri Apr 10 21:22:39 2015] [warn] [client 107.77.76.52] mod_fcgid: stderr: PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/**/public_html/myadminfolder/easypopulate_4.php on line 184, referer: http://www.**.com/myadminfolder/stat...cts_viewed.php
[Fri Apr 10 21:22:39 2015] [warn] [client 107.77.76.52] mod_fcgid: stderr: PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/**/public_html/myadminfolder/includes/functions/extra_functions/easypopulate_4_functions.php on line 1143, referer: http://www.**.com/myadminfolder/stat...cts_viewed.php
[Fri Apr 10 21:22:39 2015] [warn] [client 107.77.76.52] mod_fcgid: stderr: PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/mysite/public_html/myadminfolder/includes/functions/extra_functions/easypopulate_4_functions.php on line 1142, referer: http://www.**.com/myadminfolder/stat...cts_viewed.php
[Fri Apr 10 21:22:39 2015] [warn] [client 107.77.76.52] mod_fcgid: stderr: PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/mysite/public_html/myadminfolder/easypopulate_4.php on line 180, referer: http://www.**.com/myadminfolder/stat...cts_viewed.php

I saw some discussion about this back on 1.53
Any advice would be appreciated.

What PHP version is reported when clicking on version from the admin panel in the upper right hand corner. While there please identify the reported database information in the lower portion of the upper window.

This was first seen in ZC 1.5.3 because of the way ZC 1.5.3 transitioned to mysqli_ type database calls. EP4 uses some of these direct database calls to provide a slightly more continuous operation. When an error occurs, instead of halting all code, an error log is generated specifically for EP4.

There are also a few files that if not closely related to the original files will cause trouble. Ie if they are from older versions of the same file. That had been seen by a few trying to install the other supported URI rewriter where the 1.5.4 version of the file wasn't used with the 1.5.4 version of ZC.

PHP Version: 5.3.29 (Zend: 2.3.0) PHP Memory Limit: 128M
Database: MySQL 5.5.40-36.1
I just recently upgraded from ZC153 to 154
If I recall there was a difference in a db file as I ran winmerge on all the files before upgrading. But I don't recall which one it was, it wasn't under any of the admin folders.

Thanks for that little pointer- I went back and checked the files.
Sure enough it was a old file I didn't replace with the upgrade, it came from ultimate seo and was the /includes/classes/db/mysql (I replaced both the define and query) so not sure which one but whatever it works now.

There are a few on the store side that are loaded by the admin side that could be involved. If able to do a comparison, may I suggest doing so across the install. Also could look for mysql_ related functions identifying operation is used in some EP4 files to provide backwards compatibility and may be so in other software.

Quote:

---

Originally Posted by SStreich

Thanks for that little pointer- I went back and checked the files.
Sure enough it was a old file I didn't replace with the upgrade, it came from ultimate seo and was the /includes/classes/db/mysql (I replaced both the define and query) so not sure which one but whatever it works now.

---

Glad it was resolved. :) hope all goes well with the software. :)

After further comparison it was definitely the query_factory file.

Quote:

---

Originally Posted by mc12345678

Still need this and more information... Not in front of your computer, so can not make random guesses at what is going on. Now there are new things not previously identified with which to contend. In what table(s) are all of those extra fields? Are they all listed in the configuration->Easy Populate 4->custom fields entry? What data type is each one? Are they all listed in the example provided above? If your datafile only had one record in it, do you get a different result? What EP4 file modifications are there? What happens if you omit the custom fields from the import? What program is used to modify the files?

---

Here is the information that you have requested:

CREATE TABLE IF NOT EXISTS `products` (
`products_id` int(11) NOT NULL AUTO_INCREMENT,
`products_type` int(11) NOT NULL DEFAULT '1',
`products_quantity` float NOT NULL DEFAULT '0',
`products_model` varchar(32) DEFAULT NULL,
`products_sku` varchar(32) DEFAULT NULL,
`products_image` varchar(64) DEFAULT NULL,
`products_price` decimal(15,4) NOT NULL DEFAULT '0.0000',
`products_price_w` varchar(150) DEFAULT '0',
`products_price_carrot` decimal(15,4) DEFAULT '0.0000',
`products_virtual` tinyint(1) NOT NULL DEFAULT '0',
`products_date_added` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`products_last_modified` datetime DEFAULT NULL,
`products_date_available` datetime DEFAULT NULL,
`products_weight` float NOT NULL DEFAULT '0',
`products_length` float(6,2) DEFAULT NULL,
`products_height` float(6,2) DEFAULT NULL,
`products_width` float(6,2) DEFAULT NULL,
`dangerous_goods` int(1) DEFAULT '0',
`products_status` tinyint(1) NOT NULL DEFAULT '0',
`products_carrot` tinyint(1) DEFAULT '0',
`threshold_set` tinyint(1) DEFAULT '0',
`products_tax_class_id` int(11) NOT NULL DEFAULT '0',
`manufacturers_id` int(11) DEFAULT NULL,
`products_ordered` float NOT NULL DEFAULT '0',
`products_quantity_order_min` float NOT NULL DEFAULT '1',
`products_quantity_order_units` float NOT NULL DEFAULT '1',
`products_priced_by_attribute` tinyint(1) NOT NULL DEFAULT '0',
`product_is_free` tinyint(1) NOT NULL DEFAULT '0',
`product_is_call` tinyint(1) NOT NULL DEFAULT '0',
`products_quantity_mixed` tinyint(1) NOT NULL DEFAULT '0',
`product_is_always_free_shipping` tinyint(1) NOT NULL DEFAULT '0',
`products_qty_box_status` tinyint(1) NOT NULL DEFAULT '1',
`products_quantity_order_max` float NOT NULL DEFAULT '0',
`products_sort_order` int(11) NOT NULL DEFAULT '0',
`products_discount_type` tinyint(1) NOT NULL DEFAULT '0',
`products_discount_type_from` tinyint(1) NOT NULL DEFAULT '0',
`products_price_sorter` decimal(15,4) NOT NULL DEFAULT '0.0000',
`master_categories_id` int(11) NOT NULL DEFAULT '0',
`products_mixed_discount_quantity` tinyint(1) NOT NULL DEFAULT '1',
`metatags_title_status` tinyint(1) NOT NULL DEFAULT '0',
`metatags_products_name_status` tinyint(1) NOT NULL DEFAULT '0',
`metatags_model_status` tinyint(1) NOT NULL DEFAULT '0',
`metatags_price_status` tinyint(1) NOT NULL DEFAULT '0',
`metatags_title_tagline_status` tinyint(1) NOT NULL DEFAULT '0',
`products_condition` varchar(32) DEFAULT NULL,
`products_EHF` varchar(100) NOT NULL DEFAULT 'none',
`additional_skus` varchar(250) DEFAULT NULL,
`additional_skus_only` int(1) DEFAULT NULL,
`discontinue` int(1) DEFAULT '0',
`products_pdf_attachment` varchar(300) NOT NULL,
`products_vendor_code` varchar(32) DEFAULT NULL,
`products_vendor_price` decimal(15,4) DEFAULT NULL,
`availability_id` int(11) DEFAULT NULL,
PRIMARY KEY (`products_id`),
KEY `idx_products_date_added_zen` (`products_date_added`),
KEY `idx_products_status_zen` (`products_status`),
KEY `idx_products_date_available_zen` (`products_date_available`),
KEY `idx_products_ordered_zen` (`products_ordered`),
KEY `idx_products_model_zen` (`products_model`),
KEY `idx_products_price_sorter_zen` (`products_price_sorter`),
KEY `idx_master_categories_id_zen` (`master_categories_id`),
KEY `idx_products_sort_order_zen` (`products_sort_order`),
KEY `idx_manufacturers_id_zen` (`manufacturers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20689 ;

I have attached images as well.

Using Open office to edit the files.

Removed the addition fields and still had the same issues as shown in images fields not loaded.

This is what is shown when the file has been uploaded:

Filename: Full-EP2015Apr11-205047.csv

NEW PRODUCT! - Model: EP4test | 1 | Product im | Rover | ep4test | | | | | 2 | 0 | | | | | | | | | 1 | Rover | EP4 Test F | | | | | | | | | | |
Finished Processing Import File

Updated records: 0
New Imported records: 1
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 11443144
Memory Peak: 11916512
Execution Time: 0.0130989551544 seconds.

After the upload, have you gone to phpmyadmin to review the data in the products table for that model#? I.e., is it that the data has arrived in the table but is not appearing through the admin? (Thought being/having to do with cacheing of data...) None of this is expected nor previously identified, so am trying to find where the disconnect is occurring. Especially since Image 1 shows information that is not appearing in the following images... (Ie. model # is shown on the admin screen, $2/$0 is showing, etc... But upon entry into the product information, the data is not showing..

In the original post of this issue, it was identified that the site had been recently updated by someone else, and that the current site in use is a "demo" site... Seems that there could be issues with the ZC files between these two locations as compared to a standard/clean installation of ZC...

Are you able to add a new product from the admin without issue?

FWIW, Numinix plugins should not in any way interfere with EP4 or other properly written plugins.

Not described, but when attempting to add a new product to the database without the additional fields in the CSV that were identified on the previous page, was the custom_fields entry blank as well?

If there is still difficulty with importing with just the ZC standard products datatable information and the custom_fields in the Easy Populate V4 configuration menu is blank, then it would appear as there is something else that is awry about how the data is retrieved within the admin panel for the current site. It may also help to have/see the csv file as viewed in a plain text editor pasted between CODE tags [CODE] generated by selecting the # symbol above the reply entry area.

Quote:

---

Originally Posted by mc12345678

After the upload, have you gone to phpmyadmin to review the data in the products table for that model#? I.e., is it that the data has arrived in the table but is not appearing through the admin? (Thought being/having to do with cacheing of data...) None of this is expected nor previously identified, so am trying to find where the disconnect is occurring. Especially since Image 1 shows information that is not appearing in the following images... (Ie. model # is shown on the admin screen, $2/$0 is showing, etc... But upon entry into the product information, the data is not showing..

In the original post of this issue, it was identified that the site had been recently updated by someone else, and that the current site in use is a "demo" site... Seems that there could be issues with the ZC files between these two locations as compared to a standard/clean installation of ZC...

Are you able to add a new product from the admin without issue?

FWIW, Numinix plugins should not in any way interfere with EP4 or other properly written plugins.

Not described, but when attempting to add a new product to the database without the additional fields in the CSV that were identified on the previous page, was the custom_fields entry blank as well?

If there is still difficulty with importing with just the ZC standard products datatable information and the custom_fields in the Easy Populate V4 configuration menu is blank, then it would appear as there is something else that is awry about how the data is retrieved within the admin panel for the current site. It may also help to have/see the csv file as viewed in a plain text editor pasted between CODE tags [CODE] generated by selecting the # symbol above the reply entry area.

---

Ok I am able to load a new product but the same issue with fields are not loading. It is the same as if I am using EP4 to upload.

I will advise the installer of the issue and get him to check the database etc.

Quote:

---

Originally Posted by Bruce1952

Ok I am able to load a new product but the same issue with fields are not loading. It is the same as if I am using EP4 to upload.

I will advise the installer of the issue and get him to check the database etc.

---

Noticed something else looking over some history, are you sure also that the issues with previous files randomly disappearing has been fully addressed?

Glad though to see that the issue is comparable to "normal" operation. If the issue arises that there is a problem with EP4, please get back to the forum and provide information... I expect that once the product info issue is corrected that you should be able to use all of your additional products fields as originally setup.

I've tried to search for information on the issue i'm having, if you know where it is please direct me or if you can answer this that would be great too..

Zencart version - 1.5.1
Easy Populate version - 4.0.28

I created a few items using the Zencart admin then exported a .csv file containing those items. I opened the file using the recommended OpenOffice and made sure to have the options (Separated by Tab - Comma - Text Delimiter ") I added some items to the csv file and saved it as test.csv. When I use EP to import the new items I get an error:

No model field in record. This line was not imported Limited E |

Also, a few times (not every time) some of the imported items will not be in the proper sub category even know I had copied the category from other items already uploaded via Admin. Also, some items will randomly disappear entirely.

Any help is appreciated, thanks!

Might be able to help, but first need help to give help... It is highly unlikely that anyone else is in front of your computer screen besides yourself to provide indication of what is being performed. Ie, which of the several EP4 file types are being exported. Then which field(s) are being included/modified/deleted from the file. The filename provided will result in processing the file as if it is a full export related file...

As to the error about not importing,that is related (or expected to be related) to the entry not having a model number, letter, or other unique designation for the product.

Filterable Exports:
Complete Products

Categories:
Alpha, Limited Edition

Manufacturers:
Wizard of the Coast

Status:
All

I am not modifying any of the first row at all, no editing no deleting.

Generally I often end up with several items all with the same v_products_model - do I need to have unique v_products_model?

Quote:

---

Originally Posted by ExtensiveEnterprises

Filterable Exports:
Complete Products

Categories:
Alpha, Limited Edition

Manufacturers:
Wizard of the Coast

Status:
All

I am not modifying any of the first row at all, no editing no deleting.

Generally I often end up with several items all with the same v_products_model - do I need to have unique v_products_model?

---

Regarding unique model #s, yes, unique model #s are required for each product that is to be uploaded otherwise the data in (or omitted from) a later entry will populate the earlier entry...

There are a number of ways to rectify duplicate model#s, including using the data exported by eP4, or as necessary additional data added to the export file.

Doesn't the system automatically create Product ID's?

I suppose what it comes down to is, what is this warning:

No model field in record. This line was not imported Limited E |

and what do I need to do to make my stuff actually import?

Quote:

---

Originally Posted by ExtensiveEnterprises

Doesn't the system automatically create Product ID's?

---

Yes, ZC provides a unique product_id for each product in the database, though that product_id is likely to be different than the product_id of another store and is not referenced by mass data available from a vendor that provides a product with it's own model#. Also certainly two different vendors marketing two different types of product could have the same model #, but things can be done with that data to make them unique in a store.

So to address the second question (not quoted here) about what it takes to populate the store using EP4. Please do not take any comments/suggestions as anything "personal" or attacking, there is no intention of anything other than providing assistance or indicating information that is perceived to be needed to resolve the issue(s).

1. Please read the instructions that are provided to understand the overall functionality and that a. Model # is required.
2. Populate a product in ZC with information that you would like to see/try to change. (Existing data is fine, but important to understand the data in the database.) This is part of the instructions as well.
3. Download the data to a file. From the above it appears that the data is being prefiltered. There is also an option to download the full product data. This latter option is probably useful for a store that is just starting to use EP4 to ensure that the data is sound for future updates.
4. Maintain the first part of the filename depending on how the data is to be used/manipulated. The specific filename prefixes needed are identified in the instructions. An attributes basic file won't necessarily provide the information needed to populate Stock-By-Attributes, if that plugin is installed.
5. Ensure (like eluded) that the csv file for upload is properly quoted (and escaped). And that the field separator is appropriately identified for the export from the spreadsheet program (expected to be the same separator as in the downloaded csv file.)
6. Attempt an upload of a file with a single product. Even if it is a disabled product. Product should remain in the database unless the status of the product is set to 9 in the upload file. Data related to a product will be "deleted" if the row contains no data in the applicable column. Inthe case of two product having the same model # the data of the last row with that model# will replace any data before that row's entry.

Ought to provide a good starting point.

I got it to upload stuff but it will not upload the entire list. It seemingly chooses random items to upload and then doesn't upload the rest.

Is EasyPopulate 4.0 compatible with Zen v1.5.4?

What is the difference between EasyPopulate 4.0 and Easy Populate 1.2.5.4?

Quote:

---

Originally Posted by Kevin205

Is EasyPopulate 4.0 compatible with Zen v1.5.4?

What is the difference between EasyPopulate 4.0 and Easy Populate 1.2.5.4?

---

1) Yes, as documented in this thread over the last several pages and in the applicable documentation of the plugin's download. If following ZC recommended process of store operation/modification, this would be identified when installed on a development environment.

2) From a few perspecitves, a lot... Though, unfortunately am unable to answer the specific differences between the two programs as I have not used the other. They both use a csv file, they both allow some form of management of product data.

Where can I download the latest version of EP4? I could not find it in the plugin sections.

Quote:

---

Originally Posted by Kevin205

Where can I download the latest version of EP4? I could not find it in the plugin sections.

---

Not submitted as a plugin yet because of 1) insufficient documentation and 2) not multi-language (yet).

Two places, the most up-to-date awaiting feedback to be incorporated into the standard location is: https://www.zen-cart.com/showthread....22#post1278422
Otherwise see the first post of this thread for a slightly older version that doesn't yet contain the changes made above.

Quote:

---

Originally Posted by mc12345678

Not submitted as a plugin yet because of 1) insufficient documentation and 2) not multi-language (yet).

Two places, the most up-to-date awaiting feedback to be incorporated into the standard location is: https://www.zen-cart.com/showthread....22#post1278422
Otherwise see the first post of this thread for a slightly older version that doesn't yet contain the changes made above.

---

Thanks.

I used easy populate to add new products and received error,
1st can I use this to add new products?
2cnd this is the errors I received:
[Import Results


Filename: Full-EP2015Apr29-115223.csv

UPDATED! - Model: E139 | 1 | earrings/E | Fashion de | Cheap whol | | Fashion Ea | Fashion Ea | | | | | | | | 1 | 0.851 | 0 | 0 | 1 | 1 | 0 | 0 | | 2015-04-29 | 1 | | Jewelry an | Joyas y Ac | ?^^Earring | --none-- | 1 | 1 | 1 | 1 | 1 | 0 | Cheap whol | Cheap earr | Cheap whol | | | | | | | http://www |
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
Error: Unbalanced Categories defined in:
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 0 | Cheap whol | | | | | | | | | |

Finished Processing Import File ]
Can you explain what I am doing wrong?
Thanks
RonGin

Looks like the category "escape" code is used without having some sort of parent category...

To have present a pair of shoes that are of a particular style and for a specific gender for example, a category structure such as

shoes -> men -> sneakers could be a category structure. In the default version of EP4, this is represented as: shoes^men^sneakers

Above, I see an example of ^^Earring which could potentially indicate that he category Earring is underneath two blank categories.. That seems like it could present an error. Would almost need to see the raw data (CSV file) to provide a clearer explanation.

As for adding product, most certainly, every product must have a unique model #, and that model # must be included in the file being uploaded.

Easy Populate 4

Back to having issues, this program has yet to work correctly. Any help on what I am doing wrong would be greatly appreciated!! I keep getting this error:

No model field in record. This line was not imported

What am I doing wrong to get this error?

I have uploaded the csv with nothing in the v_products_model column, then again with the same thing for every product, then with different things for each product but i'm getting this message every time.

Is there any export/import type that includes both v_customid and v_options_values_price? Attrib-Detailed and SBA-Detailed both fall short. Mass updates of price by customid, like stock by customid, would be a killer feature.

Quote:

---

Originally Posted by ExtensiveEnterprises

Easy Populate 4

Back to having issues, this program has yet to work correctly. Any help on what I am doing wrong would be greatly appreciated!! I keep getting this error:

No model field in record. This line was not imported

What am I doing wrong to get this error?

I have uploaded the csv with nothing in the v_products_model column, then again with the same thing for every product, then with different things for each product but i'm getting this message every time.

---

So the easiest way to identify the issue is to provide an example csv data row (including header) for a row of data not importing. (Please place contents between CODE tags generated by clicking # in the toolbar.)

Every item being added/modified must have a model # in the file. Product in the database with the matching model# will be updated. Now that said, there are some languages that have proven to be problematic with the process. What language(s) are being used? Also the charset of the database canbe an issue as EP4 is designed to work UTF8 throughout just like later versions of ZC are.

Quote:

---

Originally Posted by SHK

Is there any export/import type that includes both v_customid and v_options_values_price? Attrib-Detailed and SBA-Detailed both fall short. Mass updates of price by customid, like stock by customid, would be a killer feature.

---

V_customid was only offered under the SBA import/export file. That file was originally generated for a very specific reason (stock quantities basically) that said, it seems that the v_options_values_price might be able to be combined in a sense, though it seems as if it would only apply for product that have a single attribute, or if not just single that multiple attributes will become a bit more complex/error prone.

One could argue that the SBA listing falls short in that it doesn't allow editing of the order history or more directly the product description. The database is a relational database, there are things that relate to one another throughout the database, but the relationship may not be the best suited for the majority. And yes some ofthat determination is made by those that support the software. Custom mods are likely to occur that might combine certain aspects, but with the minimal documentation currently available it seems like it would be unwise to offer that particular feature at this time. Besides, what factors are involved to need to update those values so frequently? Is there not some other relationship used that would facilitate the price update of attributes?

Actually I might be able to give you some insight on this "no model field in record". I fought with it on all of the EPs over the years. After fighting again I looked, and sure enough. The delimiters were not right when I saved.

Using Openoffice,

Save As> under the options check "Edit Filter Settings", and then when the box comes up, even if it set right (comma delimiter, and "" for text), be sure to check "quote all text cells". Then save.

This has been my exact problem every single time I have fought with this issue, and I kept forgetting about it the next time I worked with files. It has always worked like a charm once I figured out my delimiters were screwy for each one I was working with.

Hope it helps.

Hi
Question error for upload.



Using Open office


Server Upload Failure could not be uploaded due to a server issue. Check that the file size being uploaded does not exceed the maximum for your PHP server configuration in php.ini, and file uploads are permitted. Contact your web host if you cannot resolve this issue.

Easy populate 3.0.3

http://www.filedropper.com/csvzencart0515prova
<a href=http://www.filedropper.com/csvzencart0515prova><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >upload files free</a></div>

Regard

Hi
Question error for upload.



Using Open office


Server Upload Failure could not be uploaded due to a server issue. Check that the file size being uploaded does not exceed the maximum for your PHP server configuration in php.ini, and file uploads are permitted. Contact your web host if you cannot resolve this issue.

Easy populate 3.0.3

http://www.filedropper.com/csvzencart0515prova


Regard

Besides the fact that the link is broken, this thread is for EasyPopulate v4 not version 3.0.3. An upload issue such as described is likely to be resolved by splitting your file so that it is smller or as suggested by the error message increasing the maximum upload file size.

Otherwise don't know what thread to access for EasyPopulate v 3.0.3, but if you go to the first post of this thread you can download EasyPopulate v 4.

Hi, new to EP4 and Zen Cart in general. I'm exporting ~1500 records from my old storefront into Zen Cart. I loaded EP4 with little hassle, formatted my data in OO to fit your example, uploaded it to the temp/ folder on my site, chose the import option from the admin->tools->EP4 page, got a green bar at the top saying it was imported successfully, yet I see no items added to my catalog nor do they display in my shopping cart. Any ideas on what I may have messed up on? Or will it take a bit to populate? I appreciate the help in advance!

It has been a few years since I used ezpopulate but I remember it showing the records as they came in, or the products I should say. You can also use phpmyadmin from you cpanel to see if anything was entered but it prob wasn't if you don't see anything.

Did you try adding one or two items into zencart directly and then using ezpopulate to export the data? You can then use this as a master file to compare w the file u are using.

Quote:

---

Originally Posted by lruskauff

It has been a few years since I used ezpopulate but I remember it showing the records as they came in, or the products I should say. You can also use phpmyadmin from you cpanel to see if anything was entered but it prob wasn't if you don't see anything.

Did you try adding one or two items into zencart directly and then using ezpopulate to export the data? You can then use this as a master file to compare w the file u are using.

---

Quote:

---

Originally Posted by tk42one

Hi, new to EP4 and Zen Cart in general. I'm exporting ~1500 records from my old storefront into Zen Cart. I loaded EP4 with little hassle, formatted my data in OO to fit your example, uploaded it to the temp/ folder on my site, chose the import option from the admin->tools->EP4 page, got a green bar at the top saying it was imported successfully, yet I see no items added to my catalog nor do they display in my shopping cart. Any ideas on what I may have messed up on? Or will it take a bit to populate? I appreciate the help in advance!

---

Pretty much a step out of the instructions that are provided. As to trouble shooting, there remains a lot of unknowns for this particular issue. To obtain the best help, need to know the details from start to finish related to the issue also any detail specifically requested/covered by the posting tips. Posting tips can be momentarily viewed by clicking reply/reply with quoted to any message and then scrolling up above it.

Yes, more details are needed. But I was just directing them to something they could try themselves. Not sure why you quoted me?

Quote:

---

Originally Posted by lruskauff

It has been a few years since I used ezpopulate but I remember it showing the records as they came in, or the products I should say. You can also use phpmyadmin from you cpanel to see if anything was entered but it prob wasn't if you don't see anything.

Did you try adding one or two items into zencart directly and then using ezpopulate to export the data? You can then use this as a master file to compare w the file u are using.

---

I actually did exactly this to start it out. This is why I'm pretty surprised that nothing happened. I added a few items to my catalog, defined the categories I would be using, then exported a csv with EP4. I then appended the rest of my catalog to that csv following the format that was already there. That was what I uploaded with EP4 into my catalog.

I'm actually going to install it tomorrow because I once again need it so I will let you know if I run into the same thing. Maybe someone can help before then. You might want to add some more into too. Hope you solve it soon.

Linda

I got it to work! Stupid mistake on my part, I had messed up the csv formatting somewhere along the way. Not sure when or how, but it's probably what I get for trying to do the export past 2am.

Glad to hear that. If it was anything specific, please share. I may run into the same problem tomorrow.

Quote:

---

Originally Posted by lruskauff

Yes, more details are needed. But I was just directing them to something they could try themselves. Not sure why you quoted me?

---

There was no reason for two people to say the same thing two different ways when the one was fine as it was and appeared to be more than likely the cause.

But see now that something else came into play as well, but yes the suggestion was to start from the beginning and be descriptive as possible to support quick and straightforward resolution.

Glad all is working so far for all. :)

MS12345678: I'm sorry, I didn't see any other response. I must not have gone back thru the thread enough. I just finally figured out ( or thought I did ) how things are layed out in the forum. Maybe I'll try another view. Thank you for the help.

Quote:

---

Originally Posted by lruskauff

Glad to hear that. If it was anything specific, please share. I may run into the same problem tomorrow.

---

Nothing specific. The instructions are clear enough and if followed it should turn out fine. Like I said earlier, I was just working super late and probably saved it wrong or something.

Quote:

---

Originally Posted by lruskauff

MS12345678: I'm sorry, I didn't see any other response. I must not have gone back thru the thread enough. I just finally figured out ( or thought I did ) how things are layed out in the forum. Maybe I'll try another view. Thank you for the help.

---

No apologies necessary for offering assistance to another. Not sure what other "view" you are considering.

In regards to the issue that was supported, the description of reproducing the problem was not really there, indicating the need to "start from scratch", which ws suggested. After that the and had further input not been provided, the list of possibilities of the problem's cause expand significantly and one reason why I posted the way I did. :)

Round thing about it is that based on other posts, I recognize the concerns about posting etiquette, none of which appears to be an issue here.

Just checking in to see if there is any movement on the v_options_values_price_w issue?

Thanks,

Quote:

---

Originally Posted by HugoStiglitz

Just checking in to see if there is any movement on the v_options_values_price_w issue?

Thanks,

---

Did you try the latest version identified in this post? https://www.zen-cart.com/showthread....22#post1278422

Quote:

---

Originally Posted by mc12345678

Did you try the latest version identified in this post? https://www.zen-cart.com/showthread....22#post1278422

---

FWIW, I just confirmed that the field is addressed in the above version. What I request is confirmation that it works as expected/desired.

Spent a day bashing my head on importing price breaks and finally conceded defeat :-)

I started using the lastest EP from github on ZenCart 1.54 - I have been using variations for a long time. I also tried the 4.0.29 update without any success either.

I have a script that parses my data and exports to the appropriate format - spent a long doing that when I first started and have had it down to a fine art until now.

I can easily bulk import the basic records but when it comes to the price breaks it appears to import correctly, but when you look at a product there is no additional pricing. I have tried making sure the file is identical to the original - even making sure that it renders numerals to 3 decimal places.

If I manually add a few prices to a product and then EXPORT from ZenCart, or just import without, I can manually adjust the prices in a plain text editor and it imports the changes back. But despite appearing to completely replicate the file, if I try with my own clean file, it fails (with no apparent errors)

I have posted a couple of demo files here :

http://www.reetspetit.com/Other

The first 3 starting 2015_ are the 3 generated from my code.

2015_Full-EP_Products15_06_17-184924.csv - this will import OK
2015_Remove_file_Products15_06_17-184924.csv - this works OK
2015_PriceBreaks-EP_Products15_06_17-184924.csv - this will not modify the prices or add quantity discounts


PriceBreaks-EP2015Jun17-192419.csv - export from the above imports
PriceBreaks-EP-edited.csv - manually edited. This WILL add/change prices


If you diff 2015_PriceBreaks-EP_Products15_06_17-184924.csv and PriceBreaks-EP-edited.csv the only difference are the prices, and the 'Edited' file was done manually using mcedit.

There is no obvious difference that I can see.....

Any help gratefully appreciated !

B. Rgds
John

Code "response" for some opertions are filename dependent.

This is described in the instructions.

Quote:

---

Originally Posted by mc12345678

Code "response" for some opertions are filename dependent.

This is described in the instructions.

---

From README.txt:

Quote:

---

5) File names act as a switch inside the script for Importing. Namely: PriceBreaks-EP, CategoryMeta-EP, Featured-EP, SBA-Stock-EP, and Attrib-Basic-EP/Attrib-Detailed-EP ... these import files must have names that start with this string.

---

Oh FFS ^&((*"$&()£&%*(^&"$*(^""$( swear bang crash.

Sorry - I have been using the same format for some time - probably 4 years - and just had not realised that it had changed. Thank you pointing it out.

I had read the 'README.txt' but must have glazed over the filename - when you look at it on github, the end of the line is missed off so I only saw :

"5) File names act as a switch inside the script for Importing. Namely: PriceBreaks-EP, CategoryMeta-EP, Featured-EP, SBA-S"

So I wrongly assumed that it was the same rule as before and that so long as the file name CONTAINED this it would be OK.

I even started debugging and saw that it picked up the file as an import file and didn't see any other errors whilst it was processing.

Can I make a suggestion that there should be some form of sanity checking on the filename ? As far as I could see it all went through OK and reported that it had succeeded in the import, which obviously is a complete lie.

If I can figure where to do it I'll try and do a patch myself.

Thanks for the rapid response.

B. Rgds
John

Yosameti Sam at his worst. :)

I pulled that from the bottom of the github screen.

What I see can be done, though the code structure doesn't necessarily support such a clear separation of function is to provide notification on import of which "filetype" is being processed.

Alternatively and probably more user friendly/understandable is to have in the admin panel different "windows" ssociated with each filetype by name... An example of the expected filenme prefix shown.

That I think would take things the step further that would help those that have not read the instructions.

Btw, if 5 waas the last one to see/read, then there is a lot to go. The file is included in the download so should be able to read it from desktop.

LOL :-)

I think I start to understand.

It all starts to go wrong at this point in the import file :

1407 if ( strtolower(substr($file['name'],0,14)) == "pricebreaks-ep") {

First, that is probably a change from the version I was using and does indeed only check the START of the filename string whereas before it parsed the whole string probably something like this :

$filename = "test-file-pricebreaks-EP-myname.csv";

if (stristr($filename,"pricebreaks-ep")) {
echo "We found it";
}

That is case insensitive and find the filename anywhere in the string.

Second is that that if it FAILS that test, it jumps through to 1459 and carries on regardless... arrrrggghhhh !!!!!!!! That means it misses some vital bits, but still appears to work.

That is really bad..... it ought to gracefully die and notify the user that 'Filename is incorrect" when it fails the file check (and that occurs in several places). I'm no php coder, but it ain't rocket science....

Not sure how you want to fix it, but it is badly broken :-)

Happy to test anything if you want to try and resolve it.

B. Rgds
John

So, in a way I beg to differ that it is broken... That is akin to renaming a zip file of a text document to have an extension of .txt, then trying to open the document in a standard text editor expecting to be able to read the text as originally written.

File opens fine, there is some content provided, but it all did not work as "expected"...

EP4 was written to offer some greater flexibility, assuming that the operator(s) followed the instructions...

Sure, the filenaming could check for presence of words, but then it will be that the chosen text is "wrong", then ever more users will have to change their filename convention after that change.

Okay, all that aside, with the current filenme convention, when a directory is sorted by filename, each file "type" remains together and actully is sorted by date, so "restoration" of a state is easily identifiable. Then there is the saving of a modified file, go to the end of the filename, and do what is desired with it. If the files are sorted by modified date, the the result similar to prefixing the file with a date is obtained, identifying what file was changed and when. Presumably shortly after the change, the file is uploaded to effect the change. An added benefit of the "loose" action within the code is that fields that are not routinely a part of one of the special cases can also be included and will be processed. There are though some things that are relatively specific to the special name mostly requiring different queries compared to the product/product description.

Lastly, the code is modifiable to suit unique desires/needs. The code suggested could be individually incorporated, but in the grand ease of use and instruction, to me I struggle to see how that would provide an overall improvement.