ok.
everything seems to work perfectly..
:clap:
apart from :lamo:
under tools i have
BOX_TOOLS_POPULATE
instead of the easy populate link.. and when i click it, it links me too:
admin/FILENAME_POPULATE.php
Printable View
ok.
everything seems to work perfectly..
:clap:
apart from :lamo:
under tools i have
BOX_TOOLS_POPULATE
instead of the easy populate link.. and when i click it, it links me too:
admin/FILENAME_POPULATE.php
right im sorry to add another reply..
I believe the above error is there because I'd already installed easy populate, and still have the old link there, which links to it fine. so i'll just have to edit the other one out on the menu, whats the file to do this?
i have just done the exact same thing with my other shop and its gone crazy :huh:
i get all this code in the admin section, at the top.. and cant stop it.
[quote=gerhard59;585680]Just started a webshop and added some items manually, exported the list to get the right EP format.
I added the rest of the products and try to import this file.
Record format is correct but I get message "No products_id field in record. This line was not imported" and no products are imported.
record format starts with
"19-10pdu samples/19-8pdu.jpg 19-10pdu powerstrip....etc"
In this case 19-10pdu is a unique identifier connected with v_products_model
The manually added products do get updated whenever I import the file but no new items are added. Images are already downloaded to server.
I use Zencart version 1.3.8 and latest version of easypopulate.
quote]
I have the exact same problem and I have EPA. I entered products without the description manually into zen cart, saved the file, added the description into the file and imported it back into zencart. All I get is the following error message:
Product Import Results
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
SKIPPED! - Product Index: - no such current category path for this existing product.
Invalid index (products_model) in upload file - This line was not imported - Product - | catalog/2_ | Ergo Diape | | | | | | 60 | 0 | | 18/07/2008 | 0 | Ergo Baby | Sales & Cl | | | Taxable Go | 1 |
I really really want to be able to use EP but so far it hasn't been very successful.
Please help
Erin
www.momandbabyboutique.ca/servlet
Thnx, I have downloaded the right version now and decided to start from scratch. My store was still in the making and not yet open to the public.
I will keep you posted about my progress with ZC 1.3.8 and EP1.2.5.4
Sc0rian : Firstly, its not my mod to place in the downloads area, that would be up to Langer as it is his port from OSC. If you think its misleading then contact a Moderator re the uploads section, I have contacted them to rename this thread so it is for Version 1.2.5.4 to avoid confusion regarding versions to try to help people, as I feel the download section is there for people to post fix's if a mod improvement does not work, as this is a community add-on not a ZC feature.
Secondly to me it looks as you have conflict with your first EP install and your second install of version 1.2.5.4, so you must still have some files installed ?
erinl : Contact Langer as EPA is a commercial product and he does support his product on his website via his forum (and email I think).
Scrat: I'll post my question to Langer - thanks for responding!
Erin
thanks for your reply scrat.
I deleted my whole admin folder and tried uploading a fresh one and tried uploading the workin one out of my other shop. both didnt work..
Progress on installation and Easy Populate.:smartalec:
I reinstalled zen cart and easy populate this morning and started testing with my product files. One thing I noticed was EP under Tools was different then before, which was good in my opinion.
Importing still did not work properly. Although all neccesary folders had write access according to dreamweaver (I use DW for other websites and uploading) it turned out this was not true.:frusty:
After applying the proper rights on the neccesary folders the import is working perfectly.:clap:
According to screen it looks like EP is using a different folder for temp.
Whole thing is working like a charm now.:bigups:
Now it's time to start sales.
I need Easy Populate 1.2.5.4 to modify the maximum quantity field. I can’t afford the $65 version and I don’t need the other features – I just need maximum quanties. I have tried all I can to get it to work, but it doesn’t. If there is a PHP expert than can give me a tip to get it to work then I would be grateful.
Below I describe what I have tried.
I tried to follow the instructions posted by awev in post #950, but I think his instructions only work for variables stored in TABLE_PRODUCTS_DESCRIPTION.
I believe that max quantity is in the TABLE_PRODUCTS and named products_quantity_order_max.
I tried to modify his method by searching for every instance of “quantity” When I found anything referring to products_quantity I added a line below it and replaced products_quantity with products_quantity_order_max. While I think that is straight forward, it doesn’t work. I get an SQL error. In Admin the message “An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer” is displayed.
Below is what is in the ep_dubug_log
MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13651")' at line 3
When executing:
UPDATE products
SET
products_price="0.50" ,products_image="Eventid_Batwing_Brume.jpg", products_weight="0.004", products_tax_class_id="1", products_date_available= NULL, products_date_added= "2008-07-25 10:35", products_last_modified=CURRENT_TIMESTAMP, products_quantity="560, products_quantity_order_max="" ,manufacturers_id=7 , products_status=1
WHERE
(products_id = "13651")
The exact steps I took are below: The bold lines are what I added.
Line 392
'v_date_added' => $iii++,
'v_products_quantity' => $iii++,
'v_products_quantity_order_max' => $iii++,
line 460
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.products_quantity_order_max as v_products_quantity_order_max,
line 485
'v_products_price' => $iii++,
'v_products_quantity' => $iii++,
'v_products_quantity_order_max' => $iii++,
line 500
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity
p.products_quantity_order_max as v_products_quantity_order_max
line 607
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.products_quantity_order_max as v_products_quantity_order_max,
line 1290
'v_products_price',
'v_products_quantity',
'v_products_quantity_order_max',
line 1444
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.products_quantity_order_max as v_products_quantity_order_max,
line 1919
products_weight,
products_quantity,
products_quantity_order_max,
line 1933
'".zen_db_input($v_products_weight)."',
'".zen_db_input($v_products_quantity)."',
'".zen_db_input($v_products_quantity_order_max)."',
line 1970
', products_last_modified=CURRENT_TIMESTAMP' .
', products_quantity="' . zen_db_input($v_products_quantity) .
', products_quantity_order_max="' . $v_products_quantity_order_max .
Any ideas what is wrong?
[QUOTE=erinl;586336]If you have categories set up already, you MUST allocate a category (and relative sub-category in your EP file.Quote:
Originally Posted by gerhard59
See the WIKI for an EP tutorial - search WIKI for Easy Populate.
can EP be also used for things like zones, co0untries, users database?
Sadly not...Quote:
Originally Posted by francesca_ph
read install text file again and again spending over 24 hours, still cannot complete the install########. need someone to help.
my easy populate version is: (1).2.5.4
1. i think i install the install_sql sucessfully. configuate / easy poplate , i saw this tab . i can have 10 option to config , like uploads directory.
2. but i think installation is not completed. tool/ there is nothing for easy populate.
- the admin folder - i renamed to "easy" and put it to zencart/admin/easy,
i don't set any chmod for this easy folder
- the temp folder - i located either on zencart/temp or zencart/admin/temp,
i also set this temp and all subdirectory to 700.
- there are 4 text file, (history, read me, licence , install) , i think it is not necessary for installation.
on brower, when i typed
http: //www.my.com/zencart/admin/easypopulate.php?langer=install
got 404
please help to direct me where is the problem.
thank you.
???
- the admin folder - i renamed to "easy" and put it to zencart/admin/easy,
Why did you do this?
All you need to do is FTP two folders to the root install of your ZC.
admin
and
temp
this is because:Quote:
Originally Posted by fairestcape
there was already a admin folder existed . zencart/admin is the folder comes from zencart.
easy poplute comes with admin and temp folder.
if i ftp ep admin to zencart directory, it will overwrite the zencart/admin . so this is the reason why i rename ep admin to ep easy.
then ep admin, where should i ftp?
if to zencart/ - i will overwrite everything for zencart orignal admin folder .
please help
thank you.
Quote:
Originally Posted by colour97
hi finally , i got it work. now i understand i have wrong concept of same admin folder. and details of admin is totally different from zencart admin folder.
thank again for your help
Folders do not overwrite folders. All you need do is this
In your FTP program you will have two panes:
1. is for your local machine
2. is for your remote machine (server)
In your local machine pane you will see:-
admin
temp
(and some txt files that DO NOT get ftp'd)
Highlight both folders and click the arrow (or drag and drop) to send them to your remote machine (server)
The server will see the folders and say:
"Ah... here comes some files and they must go in the ADMIN FOLDER... I already have a admin folder, so I'll just bring in the files..."
(and they get put in the admin folder)
Then, your server says:
"Ah... here comes a folder called temp, and as I don't have a folder called temp yet, I will create one and put all the files from temp on the local drive, into the temp folder I just created."
--------------------------------------
Naturally, if there are ADDITIONAL folders in the admin and temp on your LOCAL machine, the server will simply create them if they don't already exist, or if they DO exist, will take the contents only.
Quote:
Originally Posted by fairestcape
thank you very much, now fully understand. this is the 1st time i have shopping cart experience, so far so good. thank again for your help.
Ok so im having problem with easy populate 1.2.5.4 i upload all my products and everything works perfect except for my categories...it only uploads my products into my last subdirectory it makes no sense
i uploaded an example of my .txt (tab delimited file)
everything is correct in it...i recently had the advanced version of easy populate installed but i unistalled it because the free version actually works better....
But what it is doing is if u look at my example....it will look at v_categories_name_3
and when its uploaded it will put all my products under my 3rd category....
v_categories_name_1 & 2 it just ignores those two categories like it doesnt exist
Like if u look at my file it will put the information under
Scanners/Readers and skip Computer Hardware the main category, and also skip the first subcategory and put all the information under the sub-sub-category
this makes no sense can someone please help me thanks
You can't use BACKSLASHES... Your category descriptions contain backslashes. These have a specific meaning in EP - namely, they indicate a DIRECTORY PATH.
You will have to re-name your categories to PLAIN ALPHA NUMERIC - don't use special characters or backslashes.
(See v_products_url for an example of when backslashes ARE used)
This restricted use of special characters is discussed here:-
http://www.zen-cart.com/wiki/index.php/Easy_Populate
Quote:
Originally Posted by rickiesdiscount
ADDITIONALLY, in v_status you have the word "Active"
The correct term to insert here is a DIGIT...
v_status
0
1
9
Where:-
0 = PRODUCT IS INACTIVE
1 = PRODUCT IS ACTIVE
9 = DELETE THIS PRODUCT FROM THE DATABASE
(All this and more is at:-
http://www.zen-cart.com/wiki/index.php/Easy_Populate )
Whilst it did run for something like 12 hours, it ran flawlessly through and created 310,000 items for me. Yah!! :bigups:
Now I've just got to figure how to get the product search down from 26 seconds for one item. :(
Oo err...
Quote:
Originally Posted by fairestcape
Quote:
Originally Posted by fairestcape
Yeah, but ive uploaded this exact file before i used the advanced version, but then i was having image problems...but that is fixed now and switched back and i had no problem at all the way the document is...i wonder if its because i had the advanced version installed and i did not delete everything...Anyway im not using backslashes under the category discription if u look its a foward slash...
As for the backslashes not sure what ur talking about ive had no problem with this before and that is the way the distributor gives me the information it cannot be changed i have 22,000 products from them it would take to long.
I really appreciate the help and advice though but im almost positive this isnt whats causing it.
Forward Slash, Back Slash... term is irrelevant. These are restricted characters and are the cause of your categories problem.Quote:
Originally Posted by rickiesdiscount
I get a similar list from my drop-shipper who ALSO describes the categories using slashes.Quote:
Originally Posted by rickiesdiscount
This is what I do:-
1. Open the list in excel.
2. Highlight the CATEGORIES COLUMN (where the backslashes/forwardslashes appear).
3. COPY to clipboard
4. Open MS Word
5. PASTE
6. (Now I have that column in a table in MS Word).
7. HIGHLIGHT THE WHOLE TABLE, then under MS Word menu "Table", select "Convert Table to Text.
8. Now I have the table as a list of "sentences" delimited by Paragraphs.
9. Use EDIT REPLACE - (tell MS Word to find / and relpace with ^t)
10. This replaces all slashes with a TAB.
11. Highlight all text, and go back to "Table" menu at the top, and now "Convert Text to table, using TABS to delimit columns.
12. I now have all my categories and sub-categories in their required columns
13. CTRL+A (select all) , the COPY
14. Go back to Excel and PASTE
15. Adjust excel columns and headers to suit EAsyPopulate...
For 22,000 products this will take about 20 minutes.
My list is routinely about 12,500 to 13,000 products and it takes me this amount of time to "repair" the layout.
I'm sure it is what's causing it... sorry to disagree!Quote:
Originally Posted by rickiesdiscount
Good Luck.
there is bugs to change or add subcategory? when i add a subcategory to existed products, these products be duplicated and move to new subcategory, but there is still products exist at parent category.
...and you will find that these are now LINKED products. This is a standard EP feature and Langer TELLS YOU THAT IT WILL HAPPEN !Quote:
Originally Posted by alvalong
Before you re-assign a product to a category, you must DELETE it from its old category (v_status for that product = 9), then run EP again to upload that product data to NEW category (v_status is then = 1).
You will have to re-upload the product image to its relevant images folder. This is the downside of v_status = 9 .
New questions...
I want to install the latest EP, but see reference to various versions and dates - some references to v1.2.5.4 look like they were in 2006. And a link to the "latest and greatest" would be very helpful.
Also, I see reference to EP Advanced Version 3.0.3 for $65. What if anything is different than the basic version? I don't mind paying for something that is markedly improved, though I am familiar with Excel, CSV and SQL so I am not scared of something basic so long as it works.
Thanks!
(New to EP)
Is there a way to include "dual pricing/wholesale" fields in this mod?
Tx
Veronika
Hi, I tried to find an answer to this but havent had any luck. What I'm wondering is if its possible to add a column to Easy Populate that will automatically bullet a list of "product specs" when entered.
The problem im having is that when I go to add products from manufacturers' web sites, the formatting varies so much that its a huge pain to enter into Easy Populate...plus Easy Populate adds a bunch of code that screws up the formatting anyway.
I just want to be able to insert a plain list and have the output in the Zen Cart description be this same list but bulletted.
Can anyone tell me if this exists or an easy way to accomplish this? I would be so grateful!!
Thanks,
Dave
can i use EP to add attributes to multiple items?
I used zen cart admin to add option name/value and add attributes to 1 product. I then download the attribute file through EP. Add attributes to other items by entering "0" in corresponding columns. I then upload the attribute file through EP.
It does not work. Am I missing something?
My EP just quit. Can you over load this software. I have around 12,000 products on my store using EP and now I can't even download one of the basic start up files to use. Every time I do anything in EP, I get a "500 Internal Server Error". I know my server isn't full and my bandwidth is hardly being touched. Everything else in the ZC Admin works fine. Its just the Easy Populate has crashed. Is there a way to uninstall it or reinstall it.
Like I said, it was working fine before. It had the occasional time out here and there. But it seems to be toast right now.
Here is the error I get:
The server encountered an unexpected condition which prevented it from fulfilling the request.
The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log.
Where can I find this error log. Maybe that will shed a bit of light. There isn't anything in my temp folder.
Please help
Matt
Sounds more like a problem with the Hosting account than the script. You should contact your Hoster for more information as they may have a Server protocol that kicked in and stopped the script. Could be the script took the Server load too high but only your Hoster knows for sure. :wink:
How can I uninstall EP and reinstall it? Or would it be the same as replacing all the .php files?
I think I found my error log. What does this mean?
PHP Warning: explode() [<a href='function.explode'>function.explode</a>]: Empty delimiter. in /hermes/bosweb/web055/b556/**************/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241
MattS - Firstly are you using langer's version 1.2.5.4 if not you should be !
I was using 1.2.5.4 until about 5 minutes ago when I switched to the osc version.
MattS - Basically if you read this thread it seems there are several versions floating around but the two to use are Langers Free Version (From Modhole) or EPA.
I would say your issues are to do with bugs in versions you are using, I have installed EP 1.2.5.4 several times not without issue, if it was me remove all EP and OSC-EP files and start again.
I originally had 1.2.5.5 installed. Then I went to the ocs version. Now with some digging I have 1.2.5.4 rolling. Still having the same issues.
I talked to my web host and they are looking into some things. Hopefully they can tell me something.
is this a free module? .... please let it be free :)
MattS : Then check your upload file, as always do a test, download a 'Complete' file and change some detail and upload that file. Usual problems are because your file format is incorrect :yes:
accurax : Yes this version is 'FREE' downloaded from Modhole see first reply in this thread... or EPA which is a commercial version (£$'s) also available from the same reply.
Scrat, It won't even let me download a generic file to modify. I used EP for a week with out any problems before it all of the sudden quit.
MattS:Sorry I hadn't read your original post properly, had you changed any files before it would not work( I am sure you didn't but lets rule out the obvious ) if you hadn't changed any server side files than as you said it will be a server issue with your host, 12,000 products may eat alot of php's memory and your host may be stopping this thus you get a '500 Internal Server Error', what has your host said ?Quote:
I have around 12,000 products
Have you tried to download it to your temp folder on the server and ftp from the server ?
Had you increased your product count when this happened say 10,000 products to 12,000 products, if so again this would show a memory issue ?
The only thing that was going on that was in conjunction with this problem was uploading all the pictures. When I uploaded the list, I didn't have very many pictures uploaded yet. then I spent the next week uploading all the pictures for the 12,000 products. I did notice that the more pics I uploaded the slower they got. But it wasn't making a dent in my available web space so I didn't think much of it.
I am still learning as I go here. Does the amount of space I have on the server have anything to do with the performance. I am also only using a spec of my bandwidth as well. What ever that means.
Thanks
MattS
MattS : Web space and bandwidth are two different things, bandwidth is all about what information is pulled via a browser from your server, so if no one visits your web site no band width is use if a million customers visit and buy (that would be nice :yes:) then a million x ?kb are used !
Web space is the amount of hard drive space you have on the server.
What does your host say ?
As I understand PHP (and I am not an expert) PHP has a very small memory compared to your server, so with EP the more products you upload the more memory it uses within PHP(not server memory), this is why you split the file into files with approx. 300 products in to upload. If you read in this thread EP does start to struggle with thousands and thousands of products, like not showing what products have been added or updated after an import in the browser screen, this is not a problem as EP still works in the back ground doing what you ask, just not confirming as it would.
Have you tried my test ?
Also try uploading just one product and see what you get with that ?
What else had you been doing ? You had not been editing any other files had you?Quote:
The only thing that was going on that was in conjunction with this problem
hi
i have ep 1.2.5.4, i have been uploading files fine i have uploaded around 3000 products altogether but for some reason i now get error 500 internal error.
I am hosting with 1and1.co.uk and they said that there is nothing wrong, but i still cant upload an products, ive tried to upload just one line and i still get the error. Also i can download fine, which doesnt make sense to me. :(
Many thanks
peter.smith11
Check you temp folder for permission 755 and not 777.
Finally got a response from my host. Here is what they said. Can someone explain this to me.
"I am contacting you about your ticket, ####, regarding your error. If you are receiving a max size limit, that is due to your script is querying too much in one session. If its realated to MySQL, you can set such limits in your php.ini through your control panel. "
I am using StartLogic as my provider.
Hi elkbow
Thanks for your help it works now :D
Matts,Quote:
Originally Posted by MattS
Here's a php.ini file::
register_globals = off
allow_url_fopen = on
expose_php = Off
max_input_time = 120
variables_order = "EGPCS"
extension_dir = ./
upload_tmp_dir = /tmp
precision = 12
SMTP = relay-hosting.secureserver.net
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="
[Zend]
zend_extension=/usr/local/zo/ZendExtensionManager.so
zend_extension=/usr/local/zo/4_3/ZendOptimizer.so
Note line 4- yours may say max_input time = 30 or 60
Find that file on your server, download, change that line to 120 and upload. See if that works.
Thanks for the help so far. I think we are getting somewhere. Except for one thing, I can't find a php.ini file anywhere. Is this something I need to create and how. Can I take someone elses and put it in my folder?
Does anything like this exist for version 1.38a?
Quote:
Originally Posted by elkbow
MattS,Quote:
Originally Posted by MattS
I think your earlier post mentioned by the host was that your php.ini can be modified in your control panel. Mine just happens to reside in the root directory.
Alright, I think I found it. At least this is where my host told me to get it. This file can't be edited through a normal explorer, it has to be done with in my host control panel. They mentioned maximum_limit and I can't find it anywhere. I copied it all into a txt file so hopefully someone can look at it and let me know what needs changed. Sorry for the zip, the txt file was too big to attach.
Thanks for your help.
Matt
MattS :In your favourite Text Editor search or Find and you will find it, its really there :yes: set as aboveQuote:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 12M ; Maximum amount of memory a script may consume (8MB)
Alright, this is starting to get under my skin a bit. I increased the limit and still failing. I am starting to think that I want to just delete everything including zen cart and start all over. But man, I don't want have to go through all that template stuff again.
MattS : Did you try saving to the Temp folder on your server ? and or ftp your file to the Temp folder and importing from there ?
Hello Friend,
I woluld like to import Catalogue in multiple languages (French and spanish).
How can i do with Easy populate?
I
We have been using easypopulate a lot. We have been adding more and more items to the site.
It appears that when we do export, everything is exported into 1 big file, be it store file, extStore file, or attribute file. As our database size increases (now the store file is over 70 mb), it gets more and more difficult to have everything in one file. Is there any way that we can break the files up into several smaller files?
Please help.
w2e,Quote:
Originally Posted by w2e
I just ran a test on my server and downloaed the Full EP. I then took the top line V_products_etc all across to the EOREOR and copied that line.
I broke the Full EP in half and inserted that line I just coppied. Then deleted all item above that insertion, giving me only one half of my products. Changed a few items then up loaded thru EP. Worked just fine..
Therefore I believe the answer is YES you can break your file into as many subfiles as you want.
Backup - Backup - Backup...
actually, upload is not the problem. As a matter of fact, you can import/upload just a few columns. The problem is on export.
How do you, for example, export just some selected categories?
Hello All,
All product information and category information is in the same tab delimated text file.
Can anyone tell me how to import Product Categories in multiple languages (french , spanish) ?
Hello,
I have a site in 3 languages, Easy populate is working great, except that it only makes new catagories in the default language, and in the other languages it moves the category box or coolmenu box. The default language is english, when you look in french the category box has moved, and that not all the categories are there.
So what i think there has to be done is to add a few lines for the categories from other languages in Easy populate.
But i realy don't know how to do that :(
Can somebody please help me
Regards,
Pankaj
Quote:
Originally Posted by Scrat
I can't import from anywhere, I can't export anything, but I can split some files. But the splitting eventually crashes.
I changed limits on php files. Does anyone else use Startlogic as a host?
This is taring me up.
Matt
Could someone please tell me if easy populate automatically adds the neccesary index and pages in the catagory box of your site as long as everything is configured correctly in the files.
IE, we have all files correctly named with the correct headings., then all we need to do is import the files for the pages to be created.
I was going to import manually but it would probably take me 2 weeks 10 hours a day and figured it would be quicker and easier to take a few days learning easy populate, I am reading the Wiki also.
Thanks, Spot.
Hi, i have downloaded easy populate, but i dont have a clue how to use it, i got told that i could upload bulk excel files into zencart using easy populate, could someone explain how this is done please. Thanks
Its pretty easy, Once you are in the EP area under tools, click on the download links. This will download a txt file into your temp folder. Get that file and open it in Excel and fill in the blanks. Then upload. You will have to upload the pictures manually, EP doesn't mess with picture files, it will just point them out. If your excel file gets pretty big then use the split function. It will take your large file and split it to a bunch of smaller files (default 300 items) that will be put in your temp folder. You will still need to insert these files one by one.Quote:
Originally Posted by ben harry
Clear as mud, right.
Matt
For you folks that are using EP with a ton of items (30,000 plus). What service provider are you using for your store. I am narrowing my problems with my EP and slow store to my host. I may be looking to move my store and starting from scratch.
Thanks for a fast reply. This might sound stupid but how do I open the file in excel, as when i download a file it goes striaght to the temp folder within zencart on my server. Thanks
Move the file on to your computer. To open the txt file in excel, right click on it and select "open with", then select excel.
Thanks Matt for your help so far, I have managed to upload files to excel now. How can I upload a manufacturers file from excel into zencart. Do I have to create a new category name, and sub category names. and also what about product descriptions, does this have to be done manually one by one. Thanks
Once the file has been edited in excel, how do i upload it back onto zencart, i assume it doesnt simply doesnt go back to the temp file. Thanks
The layout of the spreadsheet you get from out of EP has to stay the same. All the column heading and order has to stay the same. If you get a list from your supplier in spreadsheet form, you can copy/paste the information into your EP spreadsheet.
All the information that is in your EP spreadsheet will be entered into ZC. So if you have all the manufactureres, categories, sub categories, descriptions, and so on filled out in the EP spreadsheet in the correct column, it will add it all to ZC.
I think thats what the question was?
Matt
Quote:
Originally Posted by ben harry
In your EP area under tools in your ZC admin area, you can browse for your file and insert it into the database. Make sure that the file is a .txt and not a excel file.
Thanks Hopefully I can figure this out.
good luck, I wish my EP would work.
Fingers crossed, im now uploading my first attempt at a bulk price change. Just waiting for the install to complete
The upload is complete and I got the following error messages and the prices didnt get updated, it must be something simple i didnt do. If you could help me Id be appreciative.
No model field in record. This line was not imported | | Pipercross | | | | | 0 | 0 | | 07/08/2008 | 0 | | Fast Road | Airfilter | | | | | | --none-- | 0 |
No model field in record. This line was not importedinduction | Audi 80 1. | Pipercross | | | | | 92.99 | 15 | | 07/08/2008 | 0 | | Fast Road | Induction | Audi | 80 | | | | --none-- | 1 |
No model field in record. This line was not importedinduction | Audi 80 2. | Pipercross | | | | | 92.99 | 15 | | 07/08/2008 | 0 | | Fast Road | Induction | Audi | 80 | | | | --none-- | 1 |
No model field in record. This line was not importedinduction | Audi 80 2. | Pipercross | | | | | 92.99 | 15 | | 07/08/2008 | 0 | | Fast Road | Induction | Audi | 80 | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |
Thanks
The problem seems to be that you didn't give those items a unique model name. EasyPopulate uses the items models as handle instead of the ID used in the rest of the store or database, so it's really needed that you give them all a unique model and none miss it. Hope that helps.
I was hoping that you werent going to say that, I kind of figured that out as I put a model number in as zero and instead of updating the products I got a new insert. Is there a way of inserting new products and deleting the old ones without a model number, or any other quick way around this problem. Thanks
Not really. EP requires unique model names.
If you want to change the model name of an item, or change its category, you need to remove the existing one with a 9 in the status column and then create it again with the new model name or category.
Is there any other downloads I could use to add product model numbers as I have thousands of products all without a model number. Ive just spent the last 30mins changing 6 products in admin to have a products number and did a test upload with EP and it worked fine, but its going to take weeks to add the model numbers in one by one. Thanks
Well, if you have a code number or unique image filenames for every product, then you could copy any of those columns and paste it in the models one. Just make sure you don't change the column headers.
MattS: Have you got a test site? not on your host.
Try using your test site,set up a store and load your EP file and see if it works on this(as it would be independant to your live site) if so you would know if it is a hosting issue or not, or whether it is a setup issue.
The thing that seems strange is that you are unable to upload just one product, which to me seem to be a hosting issue as the mysql query is very small, and makes no difference if you have one product or 30,000 products in the database.
One question you don't answer is what is the reaction of your host to your problem ?
Scrat,
I have everything installed on the web. I am not sure what you are talking about on a test site.
The response I get from the host is that they don't see a problem. I worked with them on the phone and gave them access to my ZC admin so they could recreate the failure. Well, just like any problem I have ever had, it always works fine on their computers. I have tried it on several computers and it always fails. BUT, even though they didn't get a failure, I don't think there was anything exported to my temp folder.
MattS You should always have a test site as a working model just in case you need to alter anything or have it as a back up.
Test Site on your Localhost :
Bascially you set up your PC as a host/web server, very simple to do using apache and php, if you do not understand that use an old version of XAMPP version 1.4.16 which installs what you need. Then you can setup a ZC store on your PC and access it via your browser using an address like http://localhost.
Then you can see if you can upload the data using EP. From this if this works it would be a hosting issue.
I am not an expert in hosting but it seems to look as if it is a hosting issue if it works for the host but not for you,as it should either work or not whether a remote user or a server side user. Possible look at another hosting company, Look at the certified hosts on this site I use one and they are excellent without any issues. Ask them if they have any issues with large stores like yourself before you commit, if they specialize in ZC they should beable to answer your question.
So can I move everything from the web over to my computer, or do I need to start over. I am getting a bit lost.
MattS : Start with a fresh install and just add the EP module to that install so you know everything is new and then add one product manually and then import your EP complete file from your present web based site.(you don't have to customize this, we are only testing the setup)
This would then show if you have any problems with the basic ZC setup.
Once you are happy with that then (as long as your live site is the same version as your localhost ) just copy your ZC web based files over to your PC and see if that works, if not than you have a setup issue in your ZC files, if it does work then it must be a hosting issue.
If you are stuggling with this I would buy the e-start book it will help you tons.
For all the people have used EZ populate advance, the latest version. Do you guys think I should buy it? I'm running v.1.3.8a and I need to import quite a few products, each item going into a lot of subcategories. Do you guys think it will help and is it easy to use?
I just made a purchase at zencartbuilder.com, but I don't have a file or anything to show me where to get my software?
forget, I got the file now. thanks.
Hello,
I just got the latest version of ez populate advance. I was wondering if ez populate would be able to populate custom product fields that I have created for my products. I have 2 custom fields that I created for my products. If it can, how do I find what is the column label for those fields?
Hello,
So I'm creating my excel file right now and I'm at the column v_master_categories_id.
Can I leave the cells below blank? Will EP generate that id for me after I specify which parent directory and link directory for that product on the next columns?
Hello,
So I just got done importing my file. I went to tools->ezpop, then browse my file and click on import. There was about 14000 records. The import seems to be complete because it had the waiting message at the status bar below my browser while it seemed to be importing or doing something. About 10-15min later the waiting messge disappear..I got no error. But I never got a success message either so I'm not sure. Anyways, I went to browse my products and I don't see any. I went to view my tables via phpMyAdmin and nothing has changed either. So what could be wrong?
Where did you come up with that v_master_catagories_id?Quote:
Originally Posted by ebaobao
The catagory column name is v_catagories_name_1
Also the advanced EP version help is located where you bought the product. This is the Free version - 1.2.5.4
What I did was from the admin -> tools -> EP, they have the option to download datafile, so what I did was download the extStore file, I opened it and it has all the columns. So what I did was just put my info under the appropriate column with the correct data. That file has a column with the master category id. After editing the file, I went ahead and did a import with the file. Is that the correct way?
Hello Everyone
Need some advice. Have EP 1.2.5.4 ZC 1.3.8a Linux server. Have used EP for some time now with a few Excel problems but have worked most of those out. Uploading new inventory this week, new categories too, and worked fairly well. A few line 241 errors that seemed to relate to Product Names too long or code in descriptions. Then my admin slowed down, EP slowed to a crawl....now I can't upload. Keep getting webpage cannot be displayed and items are not updated or added. Same response to download except with Quantity file, but trying to upload file back with only top two items results in page cannot display. Same results with upload from /temp.
Any ideas? Is there a way EP gets overloaded with temp files or something? Should I delete some from /temp?
Apologize for the length. Any ideas appreciated. Thanks
Also, is there a way to access an EP log in my site directory?
Dear Friends
I was checking all Forum and FAQ to solve my problem but, nothing was there.
I installed EP and it seemed to work fine, I download text files to make my database firm, but when uploading txt file for 40K size following errors occur:
Warning: file(/home/public_html/temp/Full-EP2008Aug29-2245.txt) [function.file]: failed to open stream: No such file or directory in /home/public_html/admin/easypopulate.php on line 1201
Warning: Invalid argument supplied for foreach() in /home/public_html/admin/easypopulate.php on line 1301
I am trying my level best to solve without posting.
Pls help. :oops:
ebaobao: EPA is commercial product really you should ask your question on the authors forum as EPA will be written differently to EP 1.2.5.4. As I understand that it is not a open source module.
overmyhead: How many products have you ? The thing with hosting if you buy a shared hosting package there may be 2000 other sites on that server, and you will only be allowed x amount of memory/ram if other sites are v busy they will take the power at the expence of yours.
ORIKO : This may be a permission error, is your temp folder permission set currently ?
Reading your error you are receiving it is not seeing this file ? Also check your files, have you been altering any files ?
PHP Code:No such file or directory