Printable View
Version 1.2.5.4 shows compatibility with ZC 1.36 Tearing down my whole store with mods and all isn't much of an option. I don't want to take the chance of messing other mods or store functionality up by such a downgrade. Since there is no official 1.2.5.6 thread I assumed this is the best place to come since all the EZ Pop wizards are here.Quote:
Originally Posted by misty
So does anyone mind taking a crack at my Duplicated Manufacturer issue?
Yes, and also works with ZenCart 1.3.8.a, which is whyQuote:
Version 1.2.5.4 shows compatibility with ZC 1.36
suggested it, because version you have installed is not
as stable.
You most certainly have something different in the manufacture's name ... even an added space at the end will cause a duplicate, ie:Quote:
Originally Posted by gecko77799
"Libbey" vs "Libbey "
Manufacturer's are also case sensitive:
"Libbey" vs "libbey"
This issues is also evident in Category names.
What EP version are you using? The 1.2.5.6 CSV version?Quote:
Originally Posted by NickPCs
(I personally don't use these newer "csv" versions as they appear to be a bit buggy).
Your v_products_price...
$35.61
$341.76
$341.80
$335.07
$341.80
$341.80
$30.65
$169.33
$299.06
$347.04
You are including a $ symbol before the price. This column should just be the numeric value - NO currency symbol.
Well to me I thought the froogle code would be a happy bonus, as I don't have anything like it in my cart yet. But it appears to be severely outdated as froogle is now the Google merchant center or something like that. Looking through the docs there it would appear that the feed this produces isn't exactly compatible.Quote:
Originally Posted by chadderuski
So as it stands now it seems broken. If it were to be fixed to work with what Google now offers I would definitely use it.
Anthony Taylor
Webmaster
http://buydentalequipment.com
Alright.. I had a peek inside and did what I can to bring EP into shape with regards to Google.Quote:
Originally Posted by llynix
This is untested and may contain bugs!! However the old version was broken so maybe this is better.
Here is the diff:
There are a few spots where it could be cleaner. And right now it just defaults to 'new' for the condition which seems to be required.Code:557c557
< 'v_froogle_ shipping' => $iii++,
---
> // 'v_froogle_ shipping' => $iii++,
559c559
< 'v_froogle_ upc' => $iii++,
---
> // 'v_froogle_ upc' => $iii++,
564c564
< 'v_froogle_manufacturer_id' => $iii++,
---
> // 'v_froogle_manufacturer_id' => $iii++,
566c566
< 'v_froogle_product_type' => $iii++,
---
> // 'v_froogle_product_type' => $iii++,
568c568
< 'v_froogle_currency' => $iii++,
---
> // 'v_froogle_currency' => $iii++,
572,573c572,573
< 'product_url' => $iii++,
< 'name' => $iii++,
---
> 'link' => $iii++,
> 'title' => $iii++,
576,580c576,580
< 'image_url' => $iii++,
< 'category' => $iii++,
< 'offer_id' => $iii++,
< 'instock' => $iii++,
< 'shipping' => $iii++,
---
> 'image_link' => $iii++,
> 'product_type' => $iii++,
> 'id' => $iii++,
> 'condition' => $iii++,
> // 'shipping' => $iii++,
582c582
< 'upc' => $iii++,
---
> // 'upc' => $iii++,
587c587
< 'manufacturer_id' => $iii++,
---
> // 'manufacturer_id' => $iii++,
589c589
< 'product_type' => $iii++,
---
> // 'product_old' => $iii++,
591c591
< 'currency' => $iii++,
---
> // 'currency' => $iii++,
754,756c754,756
< $row['v_froogle_instock'] = 'Y';
< $row['v_froogle_shipping'] = '';
< $row['v_froogle_upc'] = '';
---
> $row['v_froogle_instock'] = 'new';
> // $row['v_froogle_shipping'] = '';
> // $row['v_froogle_upc'] = '';
760c760
< $row['v_froogle_manufacturer_id'] = '';
---
> // $row['v_froogle_manufacturer_id'] = '';
762c762
< $row['v_froogle_product_type'] = 'OTHER';
---
> // $row['v_froogle_product_type'] = 'OTHER';
764c764
< $row['v_froogle_currency'] = 'usd';
---
> // $row['v_froogle_currency'] = 'usd';
798a799
> // Google merchants doesn't seem to require the quotes anymore A.T.
800,801c801,802
< $row['v_froogle_products_name_' . $lid] = '"' . html_entity_decode(strip_tags(str_replace('"','""',$row2['products_name']))) . '"';
< $row['v_froogle_products_description_' . $lid] = '"' . html_entity_decode(strip_tags(str_replace('"','""',$row2['products_description']))) . '"';
---
> $row['v_froogle_products_name_' . $lid] = html_entity_decode(strip_tags(str_replace('"','""',$row2['products_name'])));
> $row['v_froogle_products_description_' . $lid] = html_entity_decode(strip_tags(str_replace('"','""',$row2['products_description'])));
I went off the directions located here: http://www.google.com/support/mercha...&answer=160083
I've yet to test this, because I'm running it on a beta site which has a few mangled product prices that I don't want released in the wild. I'll get back with you guys when I've tested.
Anthony Taylor
Webmaster
http://buydentalequipment.com
llynix My advice would just use 'Google Base Feeder' as in the add-ons. This is a much better mod now than EP for google feeds as you can automate via con jobs. As everthing in software, this mod has not been develop lately and things have moved on...
Except the Google base feeder hardcodes the condition field. My Zen Cart installation has been hacked to add an additional condition field. So no matter what I would have to hack something. Since we'll be using Easy Populate in other projects it seemed the lesser of two evils. It wasn't too hard to hack into shape. Things haven't changed that much.Quote:
Originally Posted by Scrat
Anthony Taylor
Webmaster
http://buydentalequipment.com
Well - this week I took delivery of my shiny new HP Pavillion, loaded up with all the latest MS horror stories (vista64, MS Office 2007...)
... and I set about working with some clients' sites using EasyPop to manage some price changes.
Export TXT file to Temp Folder (All OK)
Open MS Excel 2007 (All OK)
Import TXT file into Excel (sort of OK, but apply all the format stripping procedures and it should be fine)
Do edits to data. (OK)
SAVE AS tab-delimited file (OK)
Open file in notepad++ to see if I can spot obvious MS junk (OK)
FTP to temp folder (OK)
Use EP to import into database...
... BANG! CRASH! SPLINTER... :shocking::shocking::shocking:
All product data disappears!
Major panic. Swallow heart pills. Take 2 cups of espresso.
-------------------------------------------
Go onto old computer.
Use similar process as above... THIS TIME use OPEN-OFFICE CALC instead of MS...
Runs as smooth as a Cheetah... :smile:
Data back in dbase - all is OK
What's the moral of the story? (You tell me...)
Hiya Schoolboy!
So... You DID make a backup before using EP??? LOL!
What you describe sure sounds like some funky end-of-line issues. Did they change something in excell 2007?
If you track it down, please post your discovery. I have had similar problems via excell on the MAC that necessitated using OO to export my tab or CSV files.
-cj
Oh yes... ALL my hosting accounts (for clients) INCLUDE DAILY BACKUP service with the hosting co, and I ALSO employ a fantastic chap in Mumbai (India) who does manual backups a little later than the host's backup system. In that way, I have backups happening every 12 hours... Been doing it this way for years and years... (Only ever had to restore a full backup once though... Host is great!)Quote:
Originally Posted by chadderuski
I tried a few things on a test install of ZC - using the EP file that seemed to be causing problems.Quote:
Originally Posted by chadderuski
After running EP on one attempt, it seemed to go just fine. EP reported UPDATED PRODUCTS, but they did not appear in the store.
Looking at the DB in phpMyAdmin showed that the PRODUCTS table got populated OK, but the PRODUCTS_DESCRIPTION table was empty...
I figured that something (like line breaks) may be the culprit at v_products_description... but couldn't find anything. Also, looked for " " marks ... nothing.
I'll abandon MS now... Do everything in OpenOffice....
background:
was using php v4, installed ep v 1.2.5.6 and had probs. so I upgraded to php v5.
I used a freshly downloaded sample file but whoops all the catagorie columns are missing. however, I didn't notice this until I uploaded. It did something but didn't add product.
now I have something really weird - this is the only one I have found like this but I have a product number #310 that is showing two times on the screen, but only one time in the admin section.
I have seen the opposite prob talked about here but not this.
here is the link to the product, if you click it then use the next prev buttons you will see it is only displayed one time. ???
I have looked in DB and see nothing odd. Please help as it also does not update quantities in cart correctly either.
http://crafterscafe.com/index.php?ma...ex&cPath=53_54
it is the polished chrome product 1 x 1"
Is anyone able to use EP to populate new products and QBI for getting info to quickbooks?? are there conflicts with these two programs that I can not find in documention???
I am thinking my problems have something to do with this.
crafterscafe Use version 1.2.5.4 from Modhole and you want have any major issues as it just works(One or two bugs) but it will not make your head hurt :no:
Also check your product number for any extra characters, also check in your database to see if you have two records the same.
As for QBI I don't use it so I would need to know the format of the import required, if is a case of re-arranging the format that should be pretty straight forward in OO/excel
I have EP working great on Zen 1.3.8a. I have my complete .csv file with all my products, and I need to compare it to a different excel file that has just model #'s and qty.'s. Is there a way to do this automatically or with a macro?
File 1 is a complete .csv file exported from EP.
File 2 is an excel file from my supplier that has roughly 3000 rows and 3 columns. Column A is model #, B is Qty., C is price.
I have excel and open office and I want the Qty. of each model from File 2 to be inserted in the correct Qty. cell for that model in File 1. I want the same thing to happen with the price. Then any model #'s that are in File 2 but not in File 1 should be added to file one.:huh:
Can somebody help with this or is there another site that my be able to help?
I'm running zen-cart 1.3.8a.
I've installed easy populate 1.2.5.7
I'm using a downloaded file as a template but cannot get the file uploaded again.
The error message I'm getting is: "No model field in record. This line was not imported" and no lines are getting imported.
What am I doing wrong???
I'm so :frusty:
Are you using MS or Openoffice?
jmebright What you are really asking for is a custom app. to search one file and populate another, Yes anything is possible, and this is quiet simple to do with very little knowledge of script writing, I would suggest you have a look at 'Python' its a great OO programming language and very easy to learn(pickup) with lots of free on-line tutorials (both text and video's to help)
Kristina Use version 1.2.5.4 from Modhole !!! (it just works with out any major issues) - other than that if you really want to use your version check your file format against the original download.
Always a good test, download a complete file and edit the file leading the header and just one product and try uploading again and see what happens. If you search this thread you will see that these .csv version of this module have many bugs, some people seem to have good results but if you just want a tried and tested version use version 1.2.5.4.
Thanks for the input. I'll try it again with version 1.2.5.4.
BTW, I'm using microsoft excel to modify the file. But I've also tried it with Notepad and it didn't work there either. So I'll try 1.2.5.4.
Thanks again.
Thanks - switching to version 1.2.5.4 worked like a charm. :clap:
...now I just have to get all my data in the right form, yikes!
:no:Quote:
I'm using microsoft excel to modify the file. But I've also tried it with Notepad and it didn't work there either
USE OPEN OFFICE..FREE from
http://www.openoffice.org/
Thank you! This was exactly my problem. I just truncated each of those tables and viola! no more annoying errors!Quote:
Originally Posted by awhfy99
I just installed 1.2.5.4 and it seems like a really good program. I can downloads data fine, but I can only upload if I place file in temp folder manually and in the zen cart admin menu EP is calling itself "BOX_TOOLS_EASYPOPULATE". Have I mis-installed something, or is this normal. Thanks in advance!
I have install the Easy Populate adn I am getting this error:
Warning: array_flip(): The argument should be an array in /home/content/m/o/r/morristech/html/giftshop/admin/easypopulate.php on line 1328
Can someone help me on this?
right now I have 1.2.5.4 installed but I just bought 3.0.3 advanced can I just upload and install the files over the 1.2.5.4
Quote:
Originally Posted by dp-web
I am having this exact same problem and really need help sorting it out. I've contacted my host and they are just telling me that they are uncertain as to why this is happening. They aren't offering me a solution...yet.
Can somebody out there tell me what they think I should do to fix this?
Thanks (o:
~Cdnbride~
tom50 Re-check your install, I think you have missed a .php file from the FTP.
bkeaton What version are you using ? (Money on, that you are not using v1.2.5.4)
touchclothing Read the Readme.txt file and run the uninstall http(this will remove the database configs for EP) and then remove all the EP 1.2.5.4 .php files as the install.
cdnbride What version are you using ? (Money on, that you are not using v1.2.5.4)
Scrat
I'm using 1.3.8a
My cart says that I'm using the current version, should I be using something different?
I have just less than 5000 products, my hosting service has told me that they think this is happening because
"The max_execution_time we have set globally on our servers is 30 seconds."
"since there is so much data involved, it is taking the MySQL server longer to retrieve it all than is allowed by our timeout values. Since this is a shared server, there isn't any way to increase that value. The only way to increase that value would be for you to upgrade your account to a VPS or a dedicated server. Since you would be (from our point of view) the only customer on the server, we'd set it up however you wish."
~Cdnbride~
Quote:
Originally Posted by cdnbride
Sorry I'm using Easy Populate 1.2.5.4 with Zencart 1.3.8a (that makes more sense)
cdnbride Not your ZC version - the version of EP you are using (eg 1.2.5.4, 1.2.5.5, 1.2.5.6, 1.2.5.7, 3.03(com.))
Scrat
I'm using Easy Populate 1.2.5.4
~Cdnbride~
cdnbride Have you checked your folder permissions of your /temp folder, as usually ever with a large database EP should download to the /temp folder.
If this is a server issue than maybe it is a good idea to have a look for another host,
Also where did you download your version from ?Quote:
HTTP Error 500 Internal server error
is a 'catch-all' error generated by the Web server. Basically something has gone wrong, but the server can not be more specific about the error condition in its response to the client. In addition to the 500 error notified back to the client, the Web server should generate some kind of internal error log which gives more details of what went wrong. It is up to the operators of the Web server site to locate and analyse these logs.
I had a successful installation of my easy populate 1.2.5.4.
I uploaded my products via txt file and everything was successful.
All information appears in the product set-up page except there is no product image.
Product images appear for those products uploaded prior to installing easy populate. Despite having all correct product links and my images in the correct folders, the only way images appear is after uploading through the set-up page.
Is there some setting adjustment that needs to be made for images to appear without having to upload in set-up page?
Hi Scrat
Okay, first of all I am really really new to all of this so please bear with me. I looked in the /temp folder and there is no easy populate there. I have gone into my public_html/admin and found my easypopulate.php, which the permissions seem to be set at 644 and the attributes controller is set at 755. Would one of these files be what you are referring to? I am only having problems trying to "Download Model/Attributes tab-delimited .txt file", everything else seems to download. One thing I have noticed is that if I click on the "Create Model/Attributes tab-delimited .txt file in temp dir" and then I download the file to my computer is that when I try to open it in Excel (as that is what I've used for all of my .txt file creating) I get an error that says "File not loaded properly"
I also don't think that it is a server thing because the Full File from "Download Complete tab-delimited .txt file to edit" downloads without a problem every time. I would think that the Model/Attributes file would be smaller and less complex than the full data file, therefore the statement that my host support team made about the file possibly being a lot of data doesn't seem right, kwim?
I installed EP through the Fantastico on my Cpanel.
~Cdnbride~
808helmets Easiest way to check your products is download a 'complete' file and check the image details and compare working ones to non working ones... also make sure that the folder names are the same as in the image details (E.g images/folder1 against images/Folder1 ) as ZC we see this as two different folders not the same best way use just lower case or upper case but not both.
cdnbride Its not a problem, we all started one day with very little knowledge but all becomes clearer with time :clap:.
Firstly I have no knowledge of what version 'Fantastico' uses and where that originates from.
As for permissions, you need to check that your temp FOLDER permissions are set right (I have mine set to 0755) because if this is not set correctly it would mean that any files sent to this folder may not be allowed to save into this folder because the permissions disallow it.(also there is no EP .php files in this folder as it is a temp folder for temp files)
Generally version 1.2.5.4 works pretty well (some know bugs) and usually errors of this nature are due to server issues. Most cheap hosting really set levels low as they can have say 2000 sites on one server so imagine if every site tried to up load 5000 products at once this would kill the server so they set levels for each user to stop this happening, another example is that they limit the users of the mysql database so only 12 people can connect to the database at once (12 customers - the 13th gets a server busy error page) so again it does not kill the server.
I would have a look at the easypopulate.php file and see if it is this version by comparing the one you can download from modhole.
Quote:
Originally Posted by Scrat
Hi Scrat
I have checked the temp folder permissions and it is set at 0755 so tonight I will compare the .php files to see if they are the same. I thought that I picked a good hosting company but again this is pretty new to me so maybe I haven't. I would say who it is if I knew that I was permitted to here. Not sure what the rules are with forums like this so that is why I hadn't said in the first place.
I will be back once I look at those .php files.
Thanks again
~Cdnbride~
Firstly:Quote:
Originally Posted by cdnbride
EP 1.2.5.4 was never known for its reliability regarding the upload of attribute data - and remember, it claimed to upload only option names and values - not how they may have been assigned to products. For this feature, only the Commercial Version (3) of EP has the capacity to do full attribute uploads. (And even then, its reliability is questionable.)
Secondly:
There is NO NEED to change FILE PERMISSIONS. They should be the default of 644. Permissions of the TEMP folder could be 755, and if this causes issues, then 777 is probably required. What I do is change the temp folder to 777 ONLY WHILE I do EP uploads/downloads. Then I take it back to 755.
Thirdly:
To establish if it is EP that is causing the problem, do a TEST upload with a few test products. (It should not have a problem writing a complete DB download to the temp folder - I do this routinely on stores with upwards of 8000 - 9000 products.)
Fourthly:
Never use "fantastico" to install anything - particularly not a module. EP has SEVERAL files to upload. ALL go into admin. There is nothing on the catalog side of the store:
Here is the directory/file TREE for the EP 1.2.5.4 module:
admin (folder)
|_includes (folder)
|......|_boxes (folder)
|...........|_extra_boxes (folder)
|...............|_easypopulate_tools_dhtml.php (file)
|
|......|_extra_datafiles (folder)
|...........|_easypopulate_filenames.php (file)
|
|......|_functions (folder)
|...........|_extra_functions (folder)
|...............|_easypopulate_functions.php (file)
|
|......|_languages (folder)
|...........|_english (folder)
|.............|_easypopulate.php (file)
|.............|_extra_definitions (folder)
|................|_easypopulate.php (file)
|
|_easypopulate.php (file)
|
temp (folder)
NOTE: I trust you realise that while some files have the same NAMES, their purpose and function is determined by where they are LOADED in the folder tree. Files of similar names are NOT interchangeable!
Easy Populate 1.2.5.4 download can still be found in this list:
http://www.zen-cart.com/archived_con...s/admin-tools/
(After 5 years, I still find it to be the most reliable of all the EP offerings - and it works on all my installs of ZC 1.3.8a)
Thanks for the reply. All my image details are correct and still no image. However, when I add photo through set-up page, the image appears even though the both addresses before and after are the same.Quote:
Originally Posted by Scrat
For some reason, my ZC is not reading the photo unless I go through the set-up page. I even looked at the addresses in my database and all are correct.
Any suggestions?
What method are you using to UPLOAD the image files, to the images folder, on the server?Quote:
Originally Posted by 808helmets
I am using fireftp through my firefox browser.
You should be using a dedicated (and comprehensive) FTP program, such as Ipswitch WS-FTP Pro - or if you want a free (less reliable) program, try Filezilla.
Browser-based FTP is unreliable, and you may find that you have been sending your images to the server in ASCII mode - rendering them unreadable.
I am using Zen 1.3.8a.
I have the mod 'Dual Pricing' installed.
I have the mod 'Image Handler' installed.
Instead of using Excel 2007 I opted to use OpenOffice for my spreadsheet app.
I created a small test list of products, about 10. I deleted the columns I don't use as recommended in the EP docs (specials, etc.). I copied and pasted the list, including the headers, into a new file and saved it as a .csv file. Also all cells were formatted as plain text.
Here's what's happening:
When I upload the list only the first item in the product list shows in my products. The rest do not show. At the bottom, after the upload, where it gives a listing of the products uploaded in EZ admin it shows the first product in the list in bright green with the rest in the list standard black text (which tells me that only the first product 'went through'.)
Also, the image (which was entered in the image spreadsheet cell for each item) does not show, as well. I have placed all my images in the default Zen location of the 'images' directory in the store root.
I find EZ a great app and will stick with it until I get it to work right but as of now I'm having these two issues. I have checked the ADMIN/CONFIG/EZ setups and they are all set properly. I can successfiully download the list using EZ but it apparently is the uploading that's giving me problems.
Do the EZ headers (i.e v_product_price, etc.) need to be uploaded along with the listing (I AM currently including the headers in my testing)?
Any ideas on why this might be happening? (Have searched this thread and found no post dealing with this particular problem).
Thanks in advance!
Rod
Thanks for the reply.
I tried using filezilla and I am getting the same results.
When I go to categories and edit of one my products, the image name appears since it was uploaded through easy populate. After clicking preview, the product image does not appear.
However, when I go back to the product set-up page, click browse and add product image manually, and then go to preview page, the image finally appears.
I am not getting the image to appear unless I add through the product set-up page, regardless if the product links and file names are correct.
I uploaded through easy populate successfully, and all links and image folders are aligned. But, I am still not having success with images appearing.
Any suggestions?
How would I go about globally renaming my product image names (in column B of the EZ spreadsheet aka v_Products_Image) Example. I have the following product model numbers in column A:
34225
45667
34556
In EZ Populate it asks for the image name and location (which in my case the image name is the same as the model number) in column B. So I copied and pasted the model numbers to column B. While I have used a spreadsheet what is the command to do a global renaming of all my model numbers with the .jpg extension (in leiu of doing each one manually) at one shot? I know there's a way but just can't find it.
I'd like all my product image names to look like the following:
34225.jpg
45667.jpg
34556.jpg
Thanks for any help. I imagine it's fairly simple.
Rod
I've just been assisting someone with a similar sort of issue, and when we went into it, we found that the core code of ZC was so heavily customized (a lightbox zoom feature had been embedded into a huge number of core files) that it was no wonder certain functions were not performing.Quote:
Originally Posted by 808helmets
All that easy populate does is write the NAME of the file to the database. It just provides the PATH and image NAME. In a standard install of zencart, the php code references this line of text (because that's all it is really) from the database, and uses it to process the <img src> link to the relevant image.
If you are putting in the correct LOCATION in EP for your image files, AND you are sending the actual images up to the server via BINARY ftp, then the images should display.
I have a feeling you have some intricate customization (such as a lightbox feature), that seriously interferes with this standard behaviour. When you add an image via the product add/edit screen, there is probably some code sitting there that re-writes not only the images (some perhaps as thumbnails with a _th1 addition before the extension?), but their relative paths as well.
What image enhancing mods do you have installed - and how long have they been there? (Who put them there?)
Hello,
I'm sure this has probably been covered in previous posts but I can't route it out. Is there a page somewhere telling you ste-by-step how to use easy populate.
I have it installed, then I download the file that already has a few files on it - "Download Complete tab-delimited .txt file to edit" . From there I'm a bit lost..... I can see the items and can add on items in Excel, tried open office. But nothing I do seems to work so I'm probably missing something obvious as usual!! I just would really appreciate someone pointing me to a page that holds my hand and tells me what to do.
I really appeciate any help.
When I have time, I add stuff to my WIKI on easy populate:-
http://www.zen-cart.com/wiki/index.php/Easy_Populate
I am using this version "Zen Cart 1.3.8a"Quote:
Originally Posted by Scrat
What version of Easy Populate? There are several... Quite a few are recent attempts at making EP 1.2.5.4 more "friendly", but these newer versions are a bit buggy right now.Quote:
Originally Posted by bkeaton
Langer's last "stable" version was 1.2.5.4 , which I use on nearly 100 1.3.8a zencart sites.
Occasionally, I have a "blip" with EP 1.2.5.4 , but that is often related to suspicious characters in the TXT file.
I routinely go through my clients' spreadsheets and substitute literal characters for their HTML character code:
EG: instead of ' I use & # 3 9 ; (so isn't becomes isn& # 3 9 ;t) - Spaces added intentionally because this post will display the result, not the code.
The version of Easy Populate is 1.2.5.7.csv
That's one of the later versions which many people are reporting as a bit unstable right now.Quote:
Originally Posted by bkeaton
What version of PHP is on your server? (to find this out, click VERSION in the header menu - right hand side - in your admin console.)
Version PHP4
You need PHP 5.2... for 1.2.5.7Quote:
Originally Posted by bkeaton
So, uninstall EP 1.2.5.7
And install 1.2.5.4
Then read my WIKI
http://www.zen-cart.com/wiki/index.php/Easy_Populate
1.2.5.4 is available HERE
What is the fastest way to uninstall the EP 1.2.5.7?Quote:
Originally Posted by schoolboy
I have downloaded the other version and I don't like it. You have to type everything in that is what I don't want. Typing it in is wastes my time. Is there another way to do this?
Here is an image of what I am talking about:
http://www.morrisgiftshop.biz/images/screenshot.gif
Type into what?Quote:
Originally Posted by bkeaton
At some point, someone is going to have to CREATE the data relating to a product (unless you are a magician and can get the computer to do this by itself).
So even if the data is originally captured on paper, carved in stone, scrawled on payrus, written with a stick on beach sand... the fact is that the data is created by a person.
So, by getting the data into a spreadsheet all you do is save a lot of time. Once you have this in spreadsheet format, saving it to Easy Populate formats is quick and straightforward.
The image you provide is OsCommerce... what relevance does it have to zencart?
hello I did a wrong thing with EP, I insert wrong prices for 200 products.
Now when I change and reupload the file with right prices, I see always old files, why?
Please :frusty:
sorry solved I had saved wrong the file to upload :P
I know its from OsCommerce is there a way we can make an add-on like this for Zen-Cart?Quote:
Originally Posted by schoolboy
Why this version is using text file instead of excel. To me you have to through to look what you are looking for it wastes time. I just don't like it at all.Quote:
Originally Posted by schoolboy
Ah, Text file known as .txt is a Excel file. Open the file in Excel.Quote:
Originally Posted by bkeaton
It will not open up as an excel file.
Yes... of course you can. Zencart is opensource so you can do whatever you like when creating modules. When you've finished it, maybe you'd like to put it in the Free Add-ons. I have a couple of modules I built in the free add-ons, so there's no reason why you can't have some there too...Quote:
Originally Posted by bkeaton
Not really correct...Quote:
Originally Posted by elkbow
A TXT file is a TXT file - not an Excel File.
TXT files can be IMPORTED into Excel, as long as you tell Excel what the delimiter is. (the FIELD delimiter).
The delimiter can actually be ANY CHARACTER - a space, a comma, a tab, a percentage sign, a semi colon...
Usually, the field delimiter in a TXT file is a TAB or a COMMA. (Though when it's a COMMA, it is usually saved as a CSV file (Comma-Separated-Values).
Unfortunately, we cannot give you lesson on how to use spreadhseets. Find a tutorial on the web.
I'm using EP to set up my shop-
I set it up working, with various attributes, with set prices, NOT '+' prices.
Then I downloaded the EP file, so I could see the way it laid out the attributes etc, and copied them for all the products I needed.
When I uploaded it all again, although all the attributes are now present on all the items, they are all '+' Prices.
Is there a way of changing this in EP instead of editing each product?
It would be nice if someone can make a module for the Multiple Products. I am not very good in PHP but I am trying.Quote:
Originally Posted by schoolboy
Ah, sorry about that. Meant to say a .txt will open in Excel. I wonder when they will seperate in this forum, the fact that there are multiple EP versions since this is 1.2.5.4 which I have never had a problem within 9 stores and questions still come up for 1.2.5.6 and 1.2.5.7 ???Quote:
Originally Posted by schoolboy
I am experimenting the mod. When I download it then import to excel and do a few changes. When I move one item to another category and delete from the old category and up load it to the database it still show in the old category. what is that?
I hate this mod. it is causing more problems. What it is doing is. When move a product to another category (Not Copy) it is copying the category as a new category. And its link a product to another category. I just hate this mod.
I need the csv/txt files that are saved in the tmp dir to be saved with UTF8 encoding. How do I do that?
Thanks!
Y.
It can be frustrating, but you have to "think like a computer" when you work with easy populate.Quote:
Originally Posted by bkeaton
Computers are incredibly stupid, but absolutely obedient. They will do EXACTLY what you tell them to do!
In your case, if you do not REMOVE the product from the ORIGINAL category before changing it to the NEW category, both easy populate and zencart will assume that you want to LINK the products.
So, after you get your first easy populate file dump you must work out what the V_STATUS needs to be... If you want to MOVE products, you will first have to DELETE them.
So your first RUN of easy populate back into the store will be a v_status = 9 for all products you want to move.
I usually create a seaprate spreadsheet for these products, because once I have done the v_status = 9 upload, I then take the SAME spreadsheet, change the categories, then make v_status = 1.
Then I run that file through EP again.
The second time, (As there are NO products of that model number in the database) easy populate adds them as NEW products into the different categories.
PS... when using v_status=9, be sure to BACKUP all data... AND backup your images folder... v_status=9 will delete the product and its image...
I was using this version Easy Populate is 1.2.5.7.csv and I had to uninstall it then install the Version 1.2.5.4 I am getting errors like these:
Admin on the top page in pink color:
EasyPopulate uploads folder not found!
NIX SERVERS: Your uploads folder is either missing, or you have altered the name and/or directory of your uploads folder without configuring this in EasyPopulate.
WINDOWS SERVERS: Please request your web host to assign write permissions to the uploads folder. This is usually granted through Windows server user account IUSR_COMPUTERNAME.
Your configuration indicates that your uploads folder is named tempEP/, and is located in /home/content/m/o/r/morristech/html/, however this cannot be found.
EasyPopulate cannot upload files until you have provided an uploads folder with read/write/execute permissions for the site owner (chmod 700)
and this when I try install the MySQL file:
1062 Duplicate entry 'EASYPOPULATE_CONFIG_TEMP_DIR' for key 2
in:
[INSERT INTO configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL), ('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'), ('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Usefull for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL), ('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', last_insert_id(), '3', NULL, now(), NULL, NULL), ('', 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', last_insert_id(), '4', NULL, now(), NULL, NULL), ('', 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', last_insert_id(), '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', last_insert_id(), '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', last_insert_id(), '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', last_insert_id(), '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Can someone help me fix this?
I have fixed my problem
What was the solution that you discovered worked for you? :smile:
I have an issue.
When I do a change to experiment with.
I have an item is "#13129"
It was on lets say Category 1 and I move it Category 2.
its shows this:
#13129 Category 1 so I deleted Category 1 to Category 2
Then when I upload it to the db I get duplicates (Links) Catorgies so Its not moving that product to another categories. What am I doing wrong?
Sorry I still don't like this mod. its wastes my time typing everything in and will take forever.Quote:
Originally Posted by schoolboy
All I want is where you can select pruducts from one category to another. Like for an example.
lets say Category 1 has 20 items.
I want to move about 8 items from Category 1 to Category 2 at the same time. Then move 5 products from Category 1 to Category 3 at the same time and so forth.
I am starting to get the hang of this, but I have a problem. When I download the full EP to edit after I did some few changes. Then why my Products prices are different then orignally. Like for an example:
I have a candle that I am selling for $7.95 and it changes to $28.90 it change all my products prices how can fix this so I won't to go through indvidually?
I need this solve ASAP
I hate this mod. it is screwing everything up.
Is there someone standing behind you with a gun saying "Use Easy Populate or I will shoot you." ?Quote:
Originally Posted by bkeaton
You don't have to use Easy Populate if you don't want to. I have been using it for 5 years (across various versions) and have successfully populated over 100 webshops - many of them several times over.
If I were to add up the number of products uploaded and downloaded over the years, it would probably be close to half a million data items...
I have never had a problem with EP, and as I say in my WIKI tutorial, problems can usually be traced back to the operator, rather than the software! :D
Well when I do a full download and change my prices like it should be then when I upload the full it chages the prices on me. Why?
Is there a way to change the Always Free Shipping option?
I don't see that item in any of the EP downloaded files unless the column titled "shipping" in the Froogle download is it. ( I didn't think it was since it was blank for all of my products and I have them set both ways.)
Can a column for that option be added to any of the EP CSV downloads? If so what would be the name for that column?
(I searched the forum and found this question ASKED many times but never could find an answer.)
You're in luck...
The following field:
product_is_always_free_shipping
is part of the PRODUCTS table, so you can add this field to Easy Populate.
I have done this with other fields in the products table, by following this thread:
http://www.zen-cart.com/forum/showthread.php?t=116061
bkeaton,Quote:
Originally Posted by bkeaton
very sorry to hear you are having so many problems with EP. However, it is very hard for us to help you unless we know just what you are doing, meaning:
1. exactly which version you are using -> use 1.2.5.4 for the fewest problems! (but not issue free!)
2. what program you are editing your spread sheet in
3. if you've modified the data type in the cost field -> specifically, if you make it "currency" so it displays a $ dollar sign, on export this will not import correctly. Leave it as type 'general'
4. what operating system you are on: mac or pc
5. post some of your sample data for us to check -> yes, a portion of your excel spreadsheet!
Also note that this is a free mod with free support. And those of us that do try to help do so on our own time and dime without any compensation and as time permits.
That worked. :clap:Thanks!Quote:
Originally Posted by schoolboy
After I added it that way I saw an option in the admin section for EasyPopulate that is called "Custom Products Fields" --- the description from that menu reads:Quote:
Originally Posted by LRS
Custom Products Fields
Enter a comma seperated list of fields to be automatically added to import/export file(ie: products_length, products_width). Please make sure field exists in PRODUCTS table.
Would that menu do the same thing?
Apologies if this has already been asked, but it's late and the thread is 270 pages long!
Is there someway of automating the import? I have scripted the update of products etc on my machine on a daily basis, this then uploads the csv to the server, i then want to kick of an EP import script or webpage - without having to manually visit the admin section and click on import.
Thanks
Greg
1. You cannot ADD data to a dbase table unless there is a field available to STORE that data. That is why the above comment says: "Please make sure field exists in PRODUCTS table."Quote:
Originally Posted by LRS
2. You can add whatever FIELDS you like to the products table, and then put data into those fields - but the data that sits in these new fields is of no use to you, unless and until you incorporate it into your webshop. In other words, you will use php commands and scripts to bring that data into some useful function or operation within your store.
This will involve either editing existing PHP files so that the data can be made "useful" (perform some function), or writing new php files to do the same.
Personally I think EZ is a great mod. Once you have your basic product tab delimited file created you can add, delete, etc. just by editing that one file and saving it under a different file name. Yes, it DOES take a lot of work to get the first file created (it won't do it by itself...) but once that's done you're really on easy street.
I am having a minor problem I can't figure out. When I UL my entire product listing to Zen it's cutting off part of the product name and the descriptions as well. It doesn't do it with every product, just at random. Example: if I have a candle called "Spice Candle" I may get just "Spice Can" as the product name. In the product description it will cut off part of a word mid-sentence in the descript and the remainder of the descript isn't there at all.
Prices, quantities, model number and everything else comes through fine and nothing is changed during the upload (i.e., prices?) in those areas. I DO save all cells/columns in my spreadsheet as 'general', nothing else, regardless of what they contain.
Any idea(s) what might be causing this? I've checked my titles and descripts in my tab delimited file and everything is there and complete. I've even widened the column holding the descriptions then saved the file (thinking that may help) but it still doesn't give all descripts in my store.
Thanks!
Rod
Schoolboy...
Any advice on how to have EZ port my product names and descriptions properly (completely)? I have done it several times and many names and/or descriptions are partial or don't exist at all. Of course I can manually edit each of over 2000 products but that kind of defeats the purpose of EZ.
When I'm editing my products in my spreadsheet is there any special cell formatting for the text in those cells? Length of product name and/or descripitions? Font type? Characters I should avoid using, etc? Also when I do edit names/descriptions in my sheet should I port again using all existing fields and not just those fields that are missing data to do an update?
I usually select the entire spreadsheet and format the cells as 'general' (in Excel 2007). If I use OpenOffice I format the cells as text. Is there a preference as to which spreadsheet does the better job (Excel or Openoffice) in your opinion?
Thank you. I have all my products in place. It's just the names and descripts that are giving me fits now. Prices, quantities, etc., port fine and are correct.
BTW, I am using EZ 1.2.5.4.
Rod
Easy Populate like things kept SIMPLE... as does php and MySQL. The minute you start using "special characters" in the content (data), you risk corrupting it, because some characters are used in the programming for various purposes.
Back and forward slashes, single quotes (even as apostrophes), % signs, @ signs, and many others, can wreak havoc in the data.
I have seen many people give their images very elaborate names - some using square brackets, periods, slashes, aplostrophes, etc - or a convoluted combination of all of these. And the result is usually a confused mess in Easy Populate.
Even in the product description text, some characters give real problems - such as single quote marks and apostrophes. I try to use HTML character codes for these, so instead of saying "it's the best product on earth", I would use the HTML character code for the apostrophe (it& # 3 9 ;s) - no spaces of course... I put spaces here to prevent your browser rendering it as an apostrophe!
I deal with a lot of this in my WIKI
http://www.zen-cart.com/wiki/index.php/Easy_Populate
Additionally, if your product descriptions are long - or contain formatted line breaks - a program like Excel can TRUNCATE the text. Many people write up their product data in programs like MSWord and then use COPY and PASTE to get the text into the spreadhseet. This will copy MS formatting too - which is an absolute NO-NO.
So when I populate the v_products_description datasets I MAKE SURE not to have formatted line breaks and replace all these with <br /> tags. I remove ALL other formatting - or at least replace it with good, clean html tags.
Read my WIKI for additional advice.
Thanks, Schoolboy. I now have a direct link to your wiki and will be scouring it.
My product supplier supplies the images and they correspond to the model number (i.e., 12000 is the model number and the image is 12000.jpg). So that makes it simple for me. Nothing fancy with image names and I won't be reinventing the wheel there.
I'll check those descriptions that have ported correctly to see what they contain (or don't) then compare them against those that didn't and see what those that are partial contain that is messing up. Understanding how EZ looks at and ports text/characters will help me a lot.
Sounds like editing my products in Word first may be a better approach or maybe better yet, Notepad, where there is no formatting at all. I know when I receive my product descriptions and sizes are described my supplier many times uses, for example, 3/4 as all one character (as would be see in a MS Word document) and not three independent characters, 3 then / then 4. This may also be an issue in the porting.
Thanks again!
Earnest,
Give OpenOffice a try! OO will properly encapsulate exported fields in "" (quotes) where excel will often not. OO will also allow you to have more than 256 characters in a field.
-cj
Oh, and OO is free!
I don't know if this helps, but I went into the phpadmin and changed the varchar up to around 125 and it allowed my entire product name to appear. Seemed that the description length was too short.
There are other tables (orders, for example) where Product Name is stored. If you have 125 in one table and 64 in another, you are on a disaster heading...Quote:
Originally Posted by elkbow
All field lengths for common data MUST be the same...
I searched them all out and changed them. Every one worked fine. Some were around 105 in length with no problems.Quote:
Originally Posted by schoolboy