The last thing I want to try is installing this version 4 where everybody is talking about, but where can I find this version? And can I install this over the Easy populate CSV version?
Printable View
The last thing I want to try is installing this version 4 where everybody is talking about, but where can I find this version? And can I install this over the Easy populate CSV version?
I have found the one, but I do not have the courage to install this :( because it is a new install and I still have the CSV version that cannot being removed..
EP4 was written to have independent database and file information as compared to other versions so that they may be used independent of (or to not conflict with) each other.Quote:
Originally Posted by LadyoftheCave
It seems that you will likely still have the same issue that you have been reporting in each version unless you read the instructions...
While the Original Poster did not follow up on this issue, the problem with using this version of Easy Populate would appear to have been that the Comma Separated Value (csv) file was generated with semi-colons dividing field data. This would have been more noticeable of an issue in a comparison of the EP generated csv file with the csv file to be uploaded and then imported. I would expect that such a condition could be addressed with this plugin by either a change in one of the files or the use of an admin controller setting if there is one for the plugin. Also of course if the import csv file had been generated to use a comma as I suspect the instructions to indicate, then I would think that more successful use of the plugin would have been had.
hi I am using ZC 1.5.4 and easypopulate 1.2.5.4 i test with 1 products and it worked.
I have to upload about 1000 items.
I need also attribute function, but I try to download the demo csv attribute file with some demo items of my store in wich 1 has attributes, but I don't see any difference in these files between all demo items...
Is there a guide to manage attribute?
thanks to everyone
https://www.zen-cart.com/downloads.php?do=file&id=868
How to make it support version 1.56B?
When installing sql file get this error:
RROR 1136 (21S01) at line 14 in file: '/srv/html/zencart/install_sql': Column count doesn't match value count at row 1
While I believe this has been covered elsewhere in this thread, I know that there was a thread started by the last poster specifically on this issue. It is located at: https://www.zen-cart.com/showthread....59#post1358159Quote:
Originally Posted by tmccaff
What PHP Version you using? Most likely if you're using 7.1 or above the code needs to be changed. Try going back to an older version of php and see if it fixes that issue. If it does than code needs to be fixed.Quote:
Originally Posted by jiji2018
Most of these changes from database.. Example change is foreach that has been changed to while. I haven't looked at this plugin yet.
This plugin is no longer able to support the latest version of zencartQuote:
Originally Posted by tmccaff
Can you upgrade this plugin?
What php version you using? This mod was checked with php 5.6 and if your using 7 or above that is most likely the issue. Can you try another php version, so I can at least troubleshoot what is wrong? I will look into it when I get a chance.
In the mean time see if this one works for you..
https://www.zen-cart.com/downloads.php?do=file&id=2091
Is basically the same as easy populate but this is newer.
I have EP installed. All my products/decriptions/prices etc are loaded up ok.
All my product images images are located in the server/Images diretory. There are 2 images to each product:
eg FASHION/VOGUE/April_2000.jpg and FASHION/VOGUE/April_2000_spine.jpg
HOW do I use EP to associate all the images with the appropriate product?
When trying to install easy_populate_csv_v1.5.x_v1.2.6.4 into zen-cart-v1.5.6c I am getting this error
Code:[24-Mar-2020 14:29:44 Australia/Sydney] Request URI: /ADMIN/easypopulate.php?langer=installnew, IP address: 139.216.255.57#1 trigger_error() called at [/home/customdollhouse/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/customdollhouse/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/customdollhouse/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/customdollhouse/public_html/ADMIN/includes/functions/extra_functions/easypopulate_functions.php:250]
#5 install_easypopulate() called at [/home/customdollhouse/public_html/ADMIN/easypopulate.php:297]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column 'configuration_group_id' at row 1 :: INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1') ==> (as called by) /home/customdollhouse/public_html/ADMIN/includes/functions/extra_functions/easypopulate_functions.php on line 250 <== in /home/customdollhouse/public_html/includes/classes/db/mysql/query_factory.php on line 171.
This error was caused by server memory limit problem. there is nothing wrong with easy populate CSV and new version of zencart
Quote:
Originally Posted by vandiermen
In the CSV you need a column called v_products_imageQuote:
Originally Posted by gprit
Example value: J0844MH.jpg
Upload J0844MH.jpg in /images directory
Then J0844MH.jpg will be the main image for that item
when you want to add additional images to a product you use the origional main image name followed by "_2". THese should also go in the mystore.com/images directory
If you are using PHP 7.1 or higher, on line 879 in easypopulate.php you will find "ereg_replace" in that line. Function ereg_replace() is deprecated. The line should now be:
The original was:Code:$products_image_base = preg_replace($products_image_extension . '$', '', $products_image);
Hope this helps all who use and love easy populate.Code:$products_image_base = ereg_replace($products_image_extension . '$', '', $products_image);
Actually the line updated line should be:Quote:
Originally Posted by mstevens23
instead of:Code:$products_image_base = preg_replace('/'.$products_image_extension . '$/', '', $products_image);
Sorry bout the mis-typeCode:$products_image_base = ereg_replace($products_image_extension . '$', '', $products_image);
hi
i use the plugin on zencart 154
but i cant download and create the examples csv file
to click this the website go in blankpage
thanks
In any recent version of Zen Cart, a blank screen has an accompanying myDebug-xxxx log file in the logs directory. That said, more than likely the software of this version has not been updated to support newer PHP versions and requires some work/effort to bring it up-to-date. There are other options available if unable to address/fix the problems. Out of respect for this thread and software I don't wish to post those other options here as there may be those that will fix this when the issues are identified...Quote:
Originally Posted by salvo72
Quote:
Originally Posted by vandiermen
Be sure and change your admin directory to something other than "admin". I am sure those looking to hack our sites are checking out the information we post .... directory and such. Maybe you have coded over some words... but with the information in the other part.... it doesn't look like it....
It works fine for me on 157c with php 8.0.3.... maybe you need to post what issues you are having.Quote:
Originally Posted by jiji2018
If anyone is the caretaker of this wonderful tool.... I have an issue that just popped up for me. My item name in the file was larger than 64 chars.... It populated in the products table but not the products_description table. So the category showed 1 product but I could not see it. It would be great if you could add some checks to see if any of the data is too long for the database objects to accept and then not process them but put those records into a separate file so they can be worked with.
Thank you!
Quote:
Originally Posted by shrimp-gumbo-mmmhhh
Here is another issue that might want to be looked at: products_price is treated like a character field and cannot accept "$" before the amount. Still works but this gave me a problem at first... had to remove "$"
INSERT INTO products SET products_model = 'SKU501', products_type = 1, products_price = '$72.00 ',
Quote:
Originally Posted by shrimp-gumbo-mmmhhh
Okay, here are some other issues I believe I found with this module.... runs great but has some things you might need to clean up to get in:
1) I had measurements (26 13/16") in the metatags_description and the sql failed with error 1366: Incorrect String value
2) I had measurements in the products_description field and they failed if there was only one (") in the enclosed field..... if there were 2(") it seemed to load.
Maybe it needs code to clean up for quotes in strings?
3) I got a bunch of these "SKIPPED! - v_products_model: SHU018 Woodchuck | Woodchuck - specials price higher than normal price..." but the field value for both came from the same place so they were actually the same.... but this error showed up a lot.
Quote:
Originally Posted by shrimp-gumbo-mmmhhh
Quote:
Originally Posted by shrimp-gumbo-mmmhhh
Quote:
Originally Posted by shrimp-gumbo-mmmhhh
Having seen you post the list of plugins installed to your system, the one associated with mass product import is not the same plugin as discussed in this thread. The issues experienced are generally easy to correct when the csv file is properly created and/or escaped. For example, consider this situation:Quote:
Originally Posted by shrimp-gumbo-mmmhhh
The file processor (which is a php process) is looking for a double quote to indicate the start of a new field with a matching quote at the end of the field. But, somewhere between the two is a standard quote... without that inner quote identified as just text to be part of the grouping, then an error tends to be generated because after that "extra" quote, there isn't a field separator. This causes "confusion" to php basically and results in an error in that line. So the next line is then attempted... one fix is to escape that "inner" quote. This is done by using the backslash before a quote that is to be shown as text. That backslash looks like: \ so that an escaped quote would be \". Another way is to use the html equivalent of a quote: "e;. A third thought/consideration though I'm not at a computer to test is that when saving the csv file that text fields get an extra quote added to them. This is an option when saving the CSV file from within open Office if using that software.
The specials prices issue, well, a determination is made when importing prices associated with specials. The determination is to evaluate the price being imported against the resulting price of applying the special. The point of the special is generally to provide a price that is "better" than the product's price. If the special price is higher than the standard price, why would that be considered a "special" in a properly managed site? If the special and the product price were the same, why would *that* be considered a special? While the Zen Cart store allows these conditions, the version of bulk product software you have reported using prevents it. Considering that normally such a situation would exist/occur for a limited number of product, it should be something easily/quickly corrected through manual operation.
Now I say that, the comment was that they both came from the same place... that is not very descriptive which is why I provided the above general description of expectations. Might there be an issue in the code? Maybe, but I don't have enough information to say that there is/is not a problem with the code so would need more information and preferably at the thread associated with the plugin you are using. The thread path should be in the plugins documentation.
Quote:
Originally Posted by mc12345678
Thank you for looking into this MC! I apologize for not being clearer. When I said that the value came from the same place I was meaning that when I built the datafeed I used the product.price for the price and for the special price so that they were exactly the same.... so something got messed up somewhere for it to say that the specials price was more than the products price. Could the holding values or fields differ in some way so that one had higher precision? Not sure why it happened. I will try using null for the special price and see if that clears up this one error.
Still the wrong forum, but based on the report of what information was entered, I can confirm that the message received is specifically because the "specials" price entered was greater than or equal to the product price... Could the words be better or different? Perhaps. I almost question the existence of the "restriction". I mean, a store may want to operate where they mark a product as a "special" even if there is no change in price... why should the software offer that restriction at all times? At any rate, that's why there was a "note" about that portion of the import. If everything else was reported as ok, then that other data should have been fine with just this special affected. As I see it there are basically three possible solutions. 1) change the wording response so it says greater than or equal 2) Change the test to only be concerned with values grater than, not reporting an issue if the special price is the same as the products price, 3) remove the test/check as a part of the routine code.Quote:
Originally Posted by shrimp-gumbo-mmmhhh
Sorry, will find correct forum for future bugs of other version.Quote:
Originally Posted by mc12345678
Today I spent 6 hours trying to make easypopulate 4 working.....Fail
SO I found easypopulate csv......another fail....sql patch in admin fail, and importing .sql in myphpadmin file failed with "column count wrong" error.
I could have populated my site in less time that I wasted trying to debug these plugins.
I added a simple description field on the product detail page, how to add this field to the batch table function.
Which places need to be modified?
got this installed and downloaded my products, now im trying to make the data match whats expected by zen on the suppliers website and im not sure what "v_product_type" would be refering to so i can pick the corresponding data field to map with the "v_products_type" everything else seems obvious.
Not sure if the above post was made to the correct thread, but the products_type field is associated with things such as if this is a product - general, a product - music, document - general, document - product, product - free shipping, etc... The number that corresponds to the products_type can be found by accessing your store's admin, navigating to a category that has no sub-categories and also doesn't restrict the addition of product to a specific product type, then viewing the page source (F12 on your keyboard). You should be able to navigate/find the dropdown menu associated with new product. The value="" portion of the dropdown list item corresponds with the products_type. So, in a default store you should see that value="1" for product - general...Quote:
Originally Posted by flappingfish