Quote:
Originally Posted by prosam
Thanks for supplying the fix for this!
Printable View
Quote:
Originally Posted by prosam
Thanks for supplying the fix for this!
Hi folkz. I got this message in the top of my screen when i enter the EP admin screen. "Warning EASYPOPULATE_MSGSTACK_DROSS_DETECTED"
What does this mean, and am I doomed? ;):smile:
I'm having a heck of a time with Easy Populate today. I thought it might be my having over 2000 items in the csv... but read on here where people upload larger files without a problem.
I upload the file, doesn't work, page times out, no items imported.
Last week I created an import list, using the downloaded one as an example and it worked fine (still does). I can add and delete 200 items with no problem.
When I went in yesterday and again this morning to add a bunch more, using the same format and put these items into different categories, it doesn't do it.
Plus, it times out even when trying to download the main file (it does work when you have it create the file in the temp directory.
I was hoping Easy Populate would make changing 1000's of items an easy process. So far, that's not the case. Can anyone help make this thing work smoothly or is it always a rocky road to travel?
Thanks!
Jake
Hi Jake.Quote:
Originally Posted by jakedownhere
Seems strange. Personally I´ve imported almost 15.000 products at once, by uploading the file to the temp dir, and then imported it. By uploading and importing manually I get stuck on 3-4000 files. So if you have don that, please try to upload it to the temp dir first. If there is a problem with the file, you must upload it and include it here so that we can check it for errors.
Good luck :smile:
Okay, so how do you import a file in the temp dir? The page doesn't have a link there otherwise... or do you just type in the filename and click 'insert into db'?Quote:
Originally Posted by minshop.no
Okay, so I re-installed the easypopulate.php file and found the import from temp and split files options.Quote:
Originally Posted by jakedownhere
I'm still getting it timing out on a 10 item upload file.
It still isn't adding products. I'm going to try creating one product in each new category as a test, then uploading to that category and see if that works...
ANY help is greatly appreciated! I've been up all night trying to get this to work as an e-newsletter is going out in just over an hour and I want to make sure all my available products are up when people start browsing the site!
Thanks again!
mydanilo did you get this issue resolved? I have the exact same thing happening but I actually was able to import data with no problem at one point. I am now trying to add some more and update others and nothing. I deleted all the products checked the DB and still nothing. At this point I'm thinking of re-installing ZC and EP. Can someone help me out here?Quote:
Originally Posted by mydanilo
WELL!!! I figured it out! At least on my end.Quote:
Originally Posted by prosam
@woodymon and @mydanilo if you are still having this problem please make sure that your upload file's Quantity column at least has a number in the field for every product even if it's just 0. This store I'm working on does not require inventory checking so I had left that field blank. Yeah, I'm at fault. Oh well we live, we learn.
Scratch that. That did not work. I also had created some test products before importing again, that might be the answer. I have no idea. Back to the drawing board.Quote:
Originally Posted by prosam
That is correct Jake. the "insert into db" looks in your temp dir. So you just upload the txt file with ftp, and then enter the filename in that field, and push the button. Try with a few lines first. If it still does not work, please attach your file to your next post.Quote:
Originally Posted by jakedownhere
Well I believe I have figured it out, for me at least. A long with making sure that there's at least a Zero in the quantity column, I also had to make sure that in the v_tax_class_title column that Taxable Goods is capitalized. Those two things fixed allowed for the products to show after uploading. The weirdest thing, but it might just be case sensitive.Quote:
Originally Posted by prosam
Again, this worked for me not sure if it will for all. If you find that after successfully uploading your txt file and your products are not showing, while the Categories are; go back and make sure that the above 2 things are all set.
How can i remove this from the database. i installed it a moth ago and now have noticed my design center is not work. I was told i need to remove it but im not sure how to remove the sql i uploaded.
Anybody have the answer to this one?:dontgetitQuote:
Hi folkz. I got this message in the top of my screen when i enter the EP admin screen. "Warning EASYPOPULATE_MSGSTACK_DROSS_DETECTED"
Hi guys.
I have started using Easy Populate recently and it seems to be a great resource. However I am experiencing a couple of problems that I hope you can help me with:
1) I am uploading about 250 items from at Tab Delimited file, and they all upload apart from 3 of them. On these items it says "no category selected for this product," so they will not upload. I have double checked the categories for these items and they have definately been correctly selected. Why are they being skipped?
Hi guys.
I have started using Easy Populate recently and it seems to be a great resource. However I am experiencing a problem:
I am uploading about 250 items from at Tab Delimited file, and they all upload apart from 3 of them. On these items it says "no category selected for this product," so they will not upload. I have double checked the categories for these items and they have definately been correctly selected. Why are they being skipped?
Hate to cut in on all, and wish I could help some, but not that wise yet, sorry....
My question I have.... please look at my site
http://www.fragrancewholesales.net
If you go to the toolbar , and drop down the categories, it doesnt show everything, I have wayyy to many categories. I was wondering if i scroll down the categories that they could all be seen somehow..
Thanks a lot...
i have read, and read but dont understand where to put the ep files
in my download there ae two folders
admin
temp
and 4 txt files
and 1 sql file
where do these go?
your assistance is appreciated
ok - found the answer on page 43 of the orig thread
of course it is a duh once you know :P
jgg1974: You should post your question over in the Apple_Zen forum. Jade is quite helpful. There has been discussion on this topic, but it was well over a year ago. Really, you may need to think about how to organize you products in such a manner that works with the hover menu. There is no real good answer.Quote:
Originally Posted by jgg1974
If you use Quantity Price Discounts (or Price Breaks based on purchased Quantity) on your store, I have a working solution using EP to download, upload and update price breaks. Yes, this did require me to code it and create a new file type: Model/Price/Breaks "PriceBreaks-...".
Langer never got around to adding this, nor was it ever in EP-advanced last we spoke well over a year ago. It seems he's dropped off the map... I hope he's well.
I think a few people may have done their own coding to achieve this but to my knowledge no one has posted their work. I had intended to do this myself a long time ago, but you know how it is! The other issue is when you upload an update to something like EP you sort of take it on and that can be chore in itself!
It turns out this was not really that complicated, at least not for my needs. Took about two work days to figure out. I've tested this with data from our catalog: about 3500 product with a mix of no price breaks and items that break on up to three quantities. I have not tested the other breaking scheme (like percentage). These will have different quantity_price_discount codes.
A couple things to keep in mind: This is ALPHA code at best! The attached easypopulate.zip ONLY contains the easypopulate.php file. I have made numerous modifications (and deletions) to this file to suit my needs so please only use this for a reference on how to do your own quantity breaks. Some things are rather 'hard-coded' and not pretty.
SERIOUSLY! EP code is a mess :p to start with and a big bloated mess at that! No wonder no one has done a full rewrite!
To my knowledge the "froogle" stuff is dead. Also, the whole Attributes feature never worked properly either (please correct me if I'm wrong on that!).
Oh, I have not come up with a solution to remove unused breaks... meaning if you uploaded a product that had 4 price breaks, and then later change to 3 price breaks, you will have to set the 4th price break to 0 so it don't show (or go into the file via phpMyAdmin and delete it).
This is really for people with at least some coding experience, knowledge of MySQL and using phpMyAdmin. BACK UP YOUR STORE if you play with the code, USE AT YOUR OWN RISK yada yada yada not-so-legal disclaimer verbage. I will not be held responsible for you killing your store!
Hi Chadderruski,Quote:
Originally Posted by chadderuski
Is your update an update of the easypopulate.php file packaged in EP v. 1.2.5.5 (version available in ZC downloads area - "Admin Tools" category)?
http://www.zen-cart.com/index.php?ma...roducts_id=395
And does your update support ZC 1.38a?
Regarding creating a "new file type", what is meant by that?
Thanks,
Woody
Hi Woody,Quote:
Originally Posted by Woodymon
The above attached file is rather an example of how to do quantity discounts and not meant to be a full update to EP v1.2.5.5. That would require more time and testing in addition to making modifications to the admin selectable options.
I have added my own fields for download and also recently even added fields to my products database (products_price_UOM for example so I can list my prices as ea cs bx, etcetera). Extending this functionality to be broadly compatible for all users is again time consuming and would require further testing.
What I meant by "new file type" is that I made a new download type for products/price/and quantity breaks. Again, I've since changed this to include my own products_price_UOM but left that out of the above file since a user would need to modify their database and other core files...
I have also added fields for v_product_is_call v_products_sort_order v_products_quantity_order_min v_products_quantity_order_units because these are relevant to our business. All of these are rather easy to add since they are stored in the products database.
IF IF IF I can get the time AND figure out the attributes features I may do a full update to EP Free. The attributes look like a pain in the arse... more difficult than quantity breaks which turned out to be quite simple. At the same time I'd rather do a "configurable" download that would let you select the fields you need from the products database and download just those. This would be more useful in the long run and "hopefully" eliminate the need to modify the code manually.
So I posted this code for the more gear minded users to ponder and give feed back on, and for those that have been desperate for a quantity breaks update feature that has been sorely lacking to date.
I am using 1.38a but this should also work with 1.37 provided you check your database for added fields.
-cj
I would be extremely interested in this.
I'm leary to buy ep pro since the author doesn't seem to check his own forums and the non-profit would not want to waste it's money if it doesn't work. We'd be soley buying it so that we ep attributes as well as items categories etc.
Also incase people are interested, i have been able to add new fields to Easy Populate so that you can add new fields as well. The only file you need to edit is easypopulate.php and below is a link to the one that i made, it allows you to upload 5 new fields called; "Materials, Finish, Height, Width, Length".
You can use this a a guide and make it to however you want.
http://www.agelessartifacts.com/priv...sypopulate.rar
Would it be possible for you to package this up as a ZIP rather than RAR. Most novices can't unpack RAR as it requires a specific unpacker, but can unpack ZIP.Quote:
Originally Posted by Delights
Quote:
Originally Posted by schoolboy
http://www.agelessartifacts.com/priv...sypopulate.zip
:D
Thanks! :clap:
NP. it was really easy to do as well, the way that everyone was going on, i thought it would be alot harder.Quote:
Originally Posted by schoolboy
Hi,
Sorry for this so very basic post but I cant even get EP started.
I may have it in the wrong place and I may have done a few other things wrong.
There's a few things I don't understand.
I have no idea what I'm doin lol.
Anyway what I have done so far is.....
Downloaded EP, unzipped it (that I understand).
The install says rename the admin file to suit my zencart installation.
The version says it is "Zen Cart 1.3.7". So I have renamed the admin file "v1.3.7", not sure if this is right, but that's what I've done.
The install text says "The temp folder is configured to reside in your store directory".
The temp folder along with "v1.3.7" folder, the "easypopulate.php" file and the "install_sql" file are all here /public_html/.
This is also where all the folders start for zencart, so I'm assuming this is the root directory and where all the files for EP go.
In the admin area, Easy Populate appears at the bottom of the list and when clicked on opens the editing page which can be edited, e.g "Upload File Date Format" etc.
Easy Populate doesn't appear in the admin> tools dropdown list.
I also have the "temp" folder chmod to 700.
I have tried "/easypopulate.php?langer=install" after the website URL shopinoz.com.au/admin/ .
Only to get the message "Fatal error: Call to undefined function ep_chmod_check() in /home/xxxx/public_html/admin/easypopulate.php on line 217"
Can anybody steer me in the right direction of placement of the folders and files or what I need to rename the admin folder, or anything else I may be doing wrong.
I did search this thread but there's 200 pages and I couldn't find something as basic as the info I need.
Sorry to be so unknowing of the EP, it sounds so easy.
Thanks for any help,
Chris.
You put upload the admin fold to the store, for example mine is www.agelessartifacts.com/store, so in this case i would upload the folder to that.Quote:
Anyway what I have done so far is.....
Downloaded EP, unzipped it (that I understand).
The install says rename the admin file to suit my zencart installation.
The version says it is "Zen Cart 1.3.7". So I have renamed the admin file "v1.3.7", not sure if this is right, but that's what I've done.
The TEMP folder i always make it 777.Quote:
The install text says "The temp folder is configured to reside in your store directory".
The temp folder along with "v1.3.7" folder, the "easypopulate.php" file and the "install_sql" file are all here /public_html/.
This is also where all the folders start for zencart, so I'm assuming this is the root directory and where all the files for EP go
I made the temp folder 777 and the folders all seem to be where my store is.
I have to change the admin folder name as there is an admin folder already where I have uploaded EP.
Apart from what you have suggested nothing has changed, still no Easy Populate in the admin> tools> dropdown list.
So I still need a little help :smile:
Thanks for helping.
Chris.
I'm confused by all this discussion on EP.
All I want is a way to populate the store with products created in a database. Don't need options, specials, discounts, etc. What version do I need and where is the download? I really did try to follow the discourse, but over 200 pages is a bit overwhelming.
Tiz, Chris & Delights:Quote:
Originally Posted by tiz
You can download 1.2.5.4 from (IGNORE THE OTHER VERSION AS IT'S VERY BUGGY):
http://www.modhole.com/modhole/index..._Document_id=2
For Instructions on how to use EP Free (standard) I HIGHLY recommend SchoolBoy's wiki entry here:
http://www.zen-cart.com/wiki/index.php/Easy_Populate
If you were able to install your zencart store correctly, you should be able to understand the basic instructions in the zip file on how to proceed.
All the ep files go INTO the ADMIN folder following the file structure there. Example:
www.example.com ---> your domain name
www.example.com/store ----> this is where you installed your "store" but note that you may have also installed it in the root...
www.example.com/store/admin ----> this is where you go when you log in to your stores control panel
so, for easypopulate.php ... it goes here:
www.example.com/store/admin/easypopulate.php
Then all the includes folder files go here ...
www.example.com/store/admin/includes/ ... (to many to list, but you should get the idea)
A good ftp client will upload your "admin" directory off your local machine and update the remote site adding your new files and folders automatically.
After loading all your files, you would go to your store's admin page and under Tools > Install SQL Patches and PASTE the code from install_sql (just open it with notepad hi-light it all and copy it) don't upload the file as this doesn't always work correctly.
I hope this helps get you guys off on the right foot... 1.2.5.4 works fine for the basics, but I'm pretty sure ATTRIBUTES don't work...
Schoolboy, you still around? Can you verify this?
Good Luck!
I would suggest re-downloading and uploading the new files again, it must be a file upload error.Quote:
Originally Posted by chris21
Thanks for those links. I had downloaded the newest EP from the Add Ons section and worked through the old osc guides to add ep to my menu basically got everything right and was still having some screwed up issues I worked on it for probably 3 hours + :censored: not writing to the db. I downloaded the old file from your link and had it working in 5 minutes with new products. :clap:
Did anybody notice that Chris21 changed his admin folder name to his ZenCart Version Name.---Quote:
Originally Posted by Delights
Hiya Elkbow!Quote:
Originally Posted by elkbow
Yes, I did notice but I hoped my explanation would cover it!
Did you take a look at the quantity discounts (a page or two back) download/upload I figured out?
-cj
Need help,
Just installed, everything seemed fine then got this:
Upload Results
File uploaded.
Temporary filename: /tmp/phpFTGBrd
User filename: fulllist-07-11-08.XLS
Size: 4468736
Upload Complete
Seemed ok, but on the store i have no catergories, items....or anything just a plain install.
What did i o wrong? I installed everything correctly then uploaded my excel doc.
Thanks
Chris
Just to add, i see the file i uploaded in the temp folder
cj,Quote:
Originally Posted by chadderuski
I downloaded that Q discounts and looks pretty simple. And that post # 2035 above should give the EP users what they are looking for. I run about 5 stores and only use attributes on one since they do not work in EP, so I just list the 6000+ items by EP.
Chris21 should remove all EP he has and upload again - no changing of admin name.
Elkbow.
I am using Easy Populate 1.2.5.4. and imported all data successfully from EasyPopulate, but noticed that my categories had a few misspellings, so I went in and changed them in the local spreadsheet, saved as a tab-delimited .txt file and reuploaded. It said it was successful, but instead of overwriting the old categories with the new ones, it added them. When I look at the products_to_categories table, it has the products_id listed twice, once with the old categories_id and once with the new categories_id.
Is there a way for this to overwrite instead of just adding another category?
Thanks.
Jason
Hey Jason,
Yes, easy way, in my opinion anyway:
Take your spreadsheet and rename the categories to what you had before you changed them and change the second-to-last column to 9 instead of 1. Then upload. That will REMOVE all your items. While it's working, open the file again and change the 9's to 1's and fix the category names.
Once the products are removed, delete out the unwanted categories.
Then upload the new file. This should add your items back in and into the categories you wanted in the first place.
IF you put descriptions in the old category names, and want to keep that info, just rename them to exactly what EP has in the spreadsheet and it'll work fine as well.
That's what I'd do.. unless someone else has a better answer???
Remember to backup your database before you do anything I've mentioned, in case you delete all your products and can't get them back for some odd-duck sorta reason!
Jake
Have you seen my tutorial at:
http://www.zen-cart.com/wiki/index.php/Easy_Populate
Thanks delights, this is just what I was looking for a few pages back. you have come to the rescue! :smile::clap:Quote:
Originally Posted by Delights
Does anyone where to limit how many megabytes EP uses? Is this controlled within the script itself or is controlled by the php.ini file?
My host told me it's consuming a lot and need to decrease it.
Thanks for any info. :)
I have a client with 44,000 products. I uploaded them into the database with Easy Populate by breaking up the files into 4,000 product segments (yes, this took some time). Well, of course, now we need to do some mass changing and I can't download from Easy Pop as I have too many products.
Does anyone have a SQL query which I could run in my php MyAdmin that would give me the same type of output that Easy Populate would? I don't mind reuploading in smaller segments but my SQL is a bit rusty and it would be great if someone has already done this.
Thanks!
Janelle
Thought I might have it - nope.
Janelle,
Have you tried doing an EP export to your TEMP directory, then use FTP to get the file to your local machine?
I'm a newbie and got a few questions about EP. Can anyone help?
1. What's the smart tag feature for?
2. How to upload multiple image for a sinlge product. I've tried tag: v_products_image_1, v_products_image_2, but failed.
3. Any user guide about how to use the attribute tag? The user guide in zencart wiki doesn't mention this.
Tried to adapt this to my store.Quote:
Originally Posted by Delights
In your case you've added 5 new fields, in my case I only have 3 so I have made the correct changes in the file.
My Product table also have these 3 extra fields added.
Trouble is it doesn't seem to work and I can't see why.
based on your template, I simply did a search/replace for my fields.
I checked, double checked etc and I can;t seem to find what's wrong.
At the moment I have only 1 product in the store, so what I did is extract the data using EP admin via Download Complete tab-delimited .txt file to edit, then edited it in XL and added 1 product.
The loading of the file is working into temp, and when updating the database, it says it's working. when checking the store or the DB table, nothing is there...
Hope you can help..
Thx
Fixed my own problem by making sure each product has a model number (needed by easypopulate).
Thanks to a forum member for his help.
...just an update, my host told me this is not the limit set on the php.ini files, but it is invoking a process on the server which is using 80MB of memory once the easypopulate.php page is accessed.Quote:
Originally Posted by tj1
This was the result of uploading a file with a size of 6MB, is this normal? I didn't think easypopulate should used that much resources.
I use up to date version of Easy Populate & Zen Cart.
Manipulation with EP is OK till I delete column "v_products_description_2" - in this case import goes OK, BUT in ZC disappear everything in column "v_products_description_2", or (when admin/EP "Advanced Smart Tags" is set to True) there is just "<p></p>". What is wrong?
I thought that before import I can delete all columns I do not need except columns "v_products_model", "v_status" and "EOREOR".
I searched forums, wiki EP and sources, but no solution founded.
I am almost sure that month ago it was OK. So may be I changed something, but EP PHP files are same as those source files.Quote:
Originally Posted by imagino
1. Smart Tags: This appears to be used for doing string substitution at upload. You don't need this as you can use inline html in the descriptions and zencart will render them fine. I think this was meant provide smart substitution of text ->>> to ->>> <html>text</html> At least that is what is looks like.Quote:
Originally Posted by alimtlai
2. Multiple Images: you only need supply the base image for zencart. EP does not UPLOAD images, only set the image's name and path. I don't remember off the top of my head, but if your base images is "image.jpg" your added images are "image_01.jpg" "image_02.jpg" etc. Check the FAQ on this.
3. Attributed DO NOT work. Don't waste your time. That's why it's been left out of the wiki entry.
I added Easy Populate files and sql update and would like to back out changes. I backed up files so that part's easy. How do you undo sql update?
Cheers,
Gene Fourney
The Highlands Group
Sorry - been away for a bit. Yes, I did try to do this but I get a 505 error each time. I'm assuming it's just really too big. Any suggestions would be appreciated.Quote:
Originally Posted by fairestcape
Hi Guys
Hope you can help me with this one
Im pulling my hair OUT:frusty:
ive spent hours search the forums
I seem to have the same problems as others but ive tried everything wiht no joy
this is the message i get when i upload my txt file
SKIPPED! - Model: - No category provided for this product1 |
SKIPPED! - Model: - No category provided for this product2 | SKIPPED! - Model: - No category provided for this product3 |
SKIPPED! - Model: - No category provided for this product4
I have this error for every item i try & upload
PLEASE HELP:cry:
The message tells the problem. The file must have the category column and every product must have a category name.Quote:
Originally Posted by welshranger
Read my WIKI TUTORIAL on Easy Populate.
Thanks for all your replies:clap:
ill take a look schoolboy:D
I've got Easy Populate module configured with correct files uploaded. I've also configured upload tab delimited text file. 5 Test products upload correctly. Only is issue is Catgories. Items are to be added to subcategory under Retail and Commercial but categories are added at primary category level.
Example of store output is:
http://www.teamnhl.us/store
Upload file can be viewed at:
http://www.teamnhl.us/store/temp/nhl...pleupload4.txt
or
http://www.teamnhl.us/store/temp/nhl...pleupload4.xls
I've checked for characters in spreadsheet and that cateogories and subcategories match up. There are no backslashes or forward slashes or any other characters except in product description field. I've also checked to make sure there are no missing headers in spreadsheet.
Any ideas?
Cheers,
Gene Fourney
The Highlands Group
Quote:
Originally Posted by thehighlandsgroup
Not sure why you are getting that. I uploaded your file to my test site and it came out as expected, 2 top level with the correct sub-cats. My test site is 1.3.7 but I don't see why that would make a difference. I have another live site that I use EP on (it's 1.3.8a) without any problems.
I would suggest a manual addition of the cats/sub-cats and then upload it again (or just move the ones already there).
If that doesn't work, then I am just as puzzled as you!
Good luck!
I've got a problem with a site. I was working with instructions from a friend of mine who set the site up and is currently out of town. I really need to try to get the site back up.
I used Easy Populate to download the database (PriceQty-EP2008Dec02-2210.txt). I made the price changes, and then I saved the file as PriceQty.txt and I uploaded. It looked like everything went alright, one or two bad lines, but everything else was accepted. I checked a couple products under admin and the pricing had updated.
This was the middle of the day yesterday (Sunday). THis morning (monday) I came in, and tried to bring up the home page and got this message:
Sorry!
There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.
I tried to login to the admin and got this message:
0 DB_ERROR_NOT_CONNECTED
in:
[select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]
Any help is appreciated.
THanks,
chris
Your problem is unlikely to be EP.
Your site cannot connect to the database. (All files, not just product.)
Assuming nothing else was changed, you need to contact your hosting company or the person that maintains the server. Either your sql server is down (most likely)or your database is corrupted.
On the FTP site, I can see the file I uploaded via Easy Populate and it's 46457k. When I download the file, it's a zero k file. Might that mean the file is corrupted. Is it possible I named it incorrectly? Can I repost my backup via the ftp site or is this a lengthier process than just putting the file on the ftp site?
My backup is just PriceQty-EP2008Dec02-2210.txt. Is that all I need or is there a larger backup I should have pulled down before starting this?
Thanks,
Chris
Nothing to do with EasyPopulate or your file or FTP. The file you are refering to is only a temp work file and has nothing to do with the operation of your site.
All site data is stored in a SQL database. The error is a problem connecting to that.
Do you know where your site is hosted? Tell their tech support about the problem. They should be able to check the sql server.
There are a few different ways you can connect to sql, so there is not one simple answer.
If you look at includes/configure.php you will see the sql server name. That may help you to get to the right support people.
Hi , all my products and categories upload with the quantities 3 of category x , 34 of category y but when I click the category it says there are no products to display .I rechecked my data file and everything looks ok that products , image , url , categories are in the right place with the appropiate data. any ideas?
Quote:
Originally Posted by awhfy99
Thanks for the reply. I did manual addition of cats/sub-cats and then uploaded already. It looks as if I'll build out spreadsheet and then manually move categories after upload.
Cheers,
Gene Fourney
The Highlands Group
I just read through the wiki and I trying to come up with the best concept for uploading attributes. The wiki touches on using a sku for a product number such as
20105444
20 being shirt
10 long sleeve
5 being small
444 being product ID
What I am having a hard time with is the best way to populate my attributes. This sku theory leads me to believe I would have the same product added 4 times once per size as a new product. Currently I have a spreadsheet that has my colors and sizing but it isn't formated anywhere close to the by attribute that easypopulate accepts. Do anyhow have any advice here? Anything really? The only thing I can think of is figuring my own direct import into the db through php admin.. which wouldn't be easy for me but would be manually adding all of the products size and color variants.
The only advice I can offer is in the way of common sense; The easier it is for you to distinguish products by their SKU at a glance the better off you'll be.Quote:
Originally Posted by ahall13
If you do not rely on a distributor that uses standardized SKUs, you're free to make up your own, and you can use letters as well, so that Red doesn't have to be 444, it can be RD or whatever.
I also tried to make some kind of standardized system for myself across the field, but the model numbers don't have to be sequential (or make any kind of sense) and the biggest hurdle is being able to use them after not looking at them / thinking about them for a few weeks, after they'd cleared out of your short-term.
-Tim
For a quick tutorial on how to add fields to easy populate go to http://www.zen-cart.com/forum/showthread.php?t=116061
Have you downloaded a complete model/attributes(after manually adding a product or three with attributes in the admin panel)? You should be able to copy and paste from your spreadsheet into that file. I know it's awkward to use at first but once you are familiar with the fields it's easy. All of the spreadsheets from our vendors have to get copied and pasted, but it's not too hard once you've done it once or twice.Quote:
Originally Posted by ahall13
If you want to post a snippet of your spreadsheet we can see if we can offer any solutions.
Hello everyone, I'm not sure this is the right place to post this, but I downloaded the new Langer's EP [ Easy Populate Advance2.75a-Zen-Cart 1.2 - Default Language English(1) ] but the functions will not work. I've double then triple checked that I put the files into the right places, but I cannot either Download the tab-delim file nor is one created in the /temp folder. I've checked that temp is 0777.
Am I missing something?
I am running 1.2.5.4 on another Zen Cart install, and it works fine, but it is the older version.
-Tim
Nevermind, the only thing I was missing was some rather basic competence. :(
Works great now!
-Tim
I have to say Zen Cart is one of the best I have seen in testing EVERY cart I can get my hands on. The only issue I have is the LACK of a working easy populate. I have been messing with this thing on two different servers and urls and databases with no luck. I can get everything but a price???? I have changed files, saved with different formats, done everything i can think to do with NO LUCK. Has anyone got this thing to work. I have also used both ver of easy populate with the same results, no price. I am using the newest ZC,
Zen Cart 1.3.8aQuote:
Server Host: ( Database Host: mysq05..com (98..0.89)
Server OS: Linux 2.6.26.5-SMP2 Database: MySQL 5.0.41-community-log
Server Date: 01/03/2009 11:38:55 Database Date: 01/03/2009 11:38:55
Server Up Time: 11:38:55 up 44 days, 4:00, 1 user, load average: 7.80, 6.80, 6.43 HTTP Server: Apache/1.3.37 (Unix) mod_throttle/3.1.2 FrontPage/5.0.2.2635 mod_psoft_traffic/0.2 mod_ssl/2.8.28 OpenSSL/0.9.8b
PHP Version: 5.2.3 (Zend: 2.2.0) PHP Memory Limit: 24M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 189 kB Database Index Size: 322 kB
Database Patch Level: 1.3.8
v1.3.8 [2009-01-03 11:15:28] (Fresh Installation)
v1.3.8 [2009-01-03 11:15:28] (Fresh Installation)
PHP Version 5.2.3
Any help would be appreciated...Thank you and be safe
1.2.5.5 is the latest version right? Just asking cuz it says last updated Dec 01 2006.
Also, are questions/concerns regarding modhole's easy populate advanced handled here? Or are most people using 1.2.5.5 here?
Thanks!
Resolved - thanks
Ive been having an encoding file problem when i upload my file to easy populate...half of my characters show up as ?????? in my product descriptions on my website or just some random character...im using microsoft table wizard to combine tables as well and i save as a tab delimited text...i have my easy populate sheet and then i have a sheet with the quantities from my distributors and i just update the quantities in my easy populate sheet with microsoft table wizard and save it as a tab delimited text file.......well ever since i switched computers it has been doing this......
Please someone help me fix this...ive tried saving as UTF format, ASCII format, ISO...etc and all of them do it...
Im using microsoft excel 2007 and i tried open office as well and it still did it...never had this happen till recently when i got a new computer and i cannot figure out what is going on
Its not showing up on the website now like this because i used my old computer, but the old computer is about to die out so i need to figure this out soon...thanks in advance
EP does nothing with encoding of any sort.Quote:
ive tried saving as UTF format, ASCII format, ISO...etc
Did you look at the file using a simple editor such as notepad? A tab delimited file should look fine in Notepad except for column not lining up. You should be able to read everything.
You mention a new computer. Did your old PC use Office 2007? 07 uses totally new file formats vs. any prior version.
The "Latest" version is pretty old. The author no longer updates and seems to have abandoned the mod. It's a great mod and many people use it and try to help others.Quote:
Originally Posted by swamyg1
Advanced is not supported here. That appears to be a total re-write and is supported through the authors website. I hope its imporved, but last time I looked it was taking him weeks to respond there.
Quote:
Originally Posted by Jeff G
Yes i used 2007 on my old computer...that is what it doesn't make sense it is really weird..
New: CSV Easy Populate... heh.
OMG, I went through the code easypopulate.php and it's horrible. And judging from langers comments, he wasn't a very experienced programmer at the time. Although I've never seen the code for EPA3, so he could have got better.
Anyway, I haven't even used it yet really, I was just really bored tonight and couldn't sleep. :blink: So I rewrote a lot of the Download EP, Create EP, and Upload EP File code. Mainly in relation to file types. It now creates normal CSV files and accepts them. I was looking at the tab deliminated text files, and couldn't stand them.
Also, because of those text files, there is a TON of really convoluted code that is not necessary. I was able to replace some pages by just a couple lines of code.
So if you would prefer to use CSVs, then this is just what you need. There are options at the top of the file for how you want to deliminate and enclose the lines.
One thing I did not do was mess with (update) that split file feature, so it will NOT work. That code was much to sloppy to take the time to understand. Though I did add
to the top of the file so that should be good enough for larger files.PHP Code:set_time_limit(1200);
ini_set('max_input_time','1200');
One nice thing is that retarded EOREOR is completely gone and totally unnecessary. It would actually break it now.
If you just replace the easypopulate.php file in the admin folder with the attached csv one, it will be updated.
Note: your old product backups won't work, but you can export new ones with the csv easypopulate that should work just fine.
EDIT: Almost forgot, this will ONLY work with PHP > v5.1
How realistic is adding Meta tags support for the Free easy populate version. I know it's in advanced, but I am hearing about a lot of problems with that version.
If I could just add it to 1.2.5.5 I would be all set!
Phazei! I could not agree with you more. But if you think langer's free version is bad, go take a look at OSC's!Quote:
Originally Posted by phazei
I also did some editing of this mod (a few pages back) to add quantity discounts... something that's be sorely missing. And like you, I started hacking out whole sections of useless code. I know some people have successfully used the auto splitting feature, but personally I think this code can be removed in favor of better data management.
I'm looking forward to the 1.4 wrap up and also 2.0. The database changes will necessitate a rewrite of this mod.
One open question: Are there any drawback/advantages to CVS over Tab delimited? Thinking foreign character set support, punctuation, etc...
-cj
It does support all punctuation. You should be able to use any characters you want, including returns and tabs and quotes. Nothing is converted to <br> in the description. I did that because ZenCart has a textarea for the description field.Quote:
Originally Posted by chadderuski
A couple details on csv:
Usually everything is separated by a comma. Encapsulation (quotes) is usually only required when a special character is used, such as a separating or encapsulation character.
A line containing the following items:
entery one
second, item
"i am" quoted"
123.32
Would look like this:
entery one,"second, item",,"""i am"" quoted""",123.32
Quotes are doubled up if used and surrounded by quotes.
As long as the files are opened in a spreadsheet editor that will save as CSV, it should all be taken care of. That's just how it would look like if you opened it with notepad.
For the special case of froogle, I just have it check if it's froogle, if so, change delimination to "\t" (tab) and encapsulation to " " (space). The spaces won't interfere with anything, the php csv function just doesn't allow no character listed for encapsulation.
I was also thinking about the auto splitting feature and its purpose. Last night I had been up for a while so hadn't realized this. I was thinking the splitting feature was to prevent upload timeouts, but if that was the case, it would timeout before it even finished uploading the original file to split. That's why I added the max_input_time change at the beginning. But that wasn't the purpose at all. And ini_set might not work for everyone.
It was to prevent script timeouts, which is really simple to get around. It's really laughable that so much programing went into that when all the original programmer needed to go was add the set_time_limit. WOW.
So in this attached version, I removed everything that has to do with the splitting, which is like 4 pages of code.
Another note: if you see a tiny little box with a "?" in it in Excel next to your line feeds, it's ok. Linefeeds saved from the description field use \r\n, but excel only expects only \n. So it shows the \r as a square.
MetaTag support: products only.
For categories won't be coming.
I'm just really OCD and ADD, I need to get back to work...
I also rewrote lots of the sql statements and optimized them a bit.
Also noticed an issue where Excel changes the timestamp from a SQL to the native windows setting. I added some code so the timestamp can be in just about any format. Even "January 15th, last year" should work, heh.
Note: i deleted csv v1&v2
Fixed a line for the date function for the specials date items
WOWEEE! Meta tag support too! Phazei you totally rock. You are doing so many people a great services, hats off to you!!!
Actually, my .csv file is not uploading propertly. I get no error message, just no status of anything... and products don't upload.
Any ideas what could be causing this?
This is what I get:
Upload Results
File uploaded.
Temporary filename: /Applications/MAMP/tmp/php/phpjQuYHW
User filename: Full-EP2009Jan04-1806 copy.txt
Size: 22527
Upload Complete
Phazei,
Check this post for my version with quantity discount working:
http://www.zen-cart.com/forum/showpo...postcount=2022
From my own research, the Froogle code is defunct, and there are no longer any mods in the downloads area. Numinix's udated his feeder for Google Base, but there were many changes between the two that make all this froogle code outdated. So I killed it in my version.
I also think the "Advance Smart Tags" is unnecessary. It may be a "cool idea", but how many people have actually used it?
I also killed out the section on product attributes in favor of a future re-write.
Glad to see someone else interested in poking at this code!
-cj
Quote:
Originally Posted by swamyg1
Is that a file you exported with the version I made? I noticed it ended in .txt
My version creates .csv
There are lots of internal changes to the file. It won't work with files downloaded with other versions.
In particular, it needs to be a comma deliminated file and all that EOREOR stuff is gone.
Try doing a complete download, and then uploading that same one.
During my testing I found that if you upload any file that doesn't get parsed properly, it just says upload and puts it in your temp folder. Even zip and stuff.
Quote:
Originally Posted by chadderuski
While I removed the bad code I replaced, I didn't want to remove or break anything else. Like that Linda's Header Controler 2.0 thing, and lots of other hacks people added to it to work with lots of other peoples plugins. Chances are all that crap isn't needed, but it wasn't necessary to remove it now.
Also, I think googlebase has files similar to froogle, chances are the columns are just changed, it would be really simple to fix I believe if I knew what the new column headers were supposed to be.
There seems to be more functionality built into EP than is presented on the surface, there are lots of settings in there to do more stuff with a simple flip. It's written so it automatically adds new categories if you have a product in one that doesn't exist yet.
I noticed ZC won't allow products in a category that has a subcategory, not sure what would happen if you did that in a file. That 7 category depth limit is also simply controlled by a variable.
I did my best to not really bother looking how it worked, only what was needed and only making sure what I did didn't break the stuff written below.
Oh: and I remember seeing some code in EP that talked about quantity pricing already in it.
nm: maybe I was tired at the time and dreaming, can't find it now
Hmm very funny. I tried what you said with the same file but I'm getting the same thing. Nothing inserts into the DB and no report of anything that's happened. I downloaded the file, made a couple of price edits and reuploaded the same file. I've tried a dozen times and I haven't been able to get an upload.Quote:
Originally Posted by phazei
Upload Results
File uploaded.
Temporary filename: /Applications/MAMP/tmp/php/phpK9769Q
User filename: Full-EP2009Jan07-1806.csv
Size: 18473
Upload Complete
Just for testing purposes cut the csv down to like 10 products and see if it still does the same thing.
Then you could send me the csv and I'll see if I can figure out why.
Ok, I tried that but nothing happened. I've attached the zip here.Quote:
Originally Posted by phazei
I found the problem and was able to import it in just fine.
It's a CR/LF aka \r\n aka chr(13)chr(10) issue.
The function I use only uses LF as a end of line terminator.
That's fine for windows and linux users, since they use that (windows uses both). But I'm guessing you're using a mac, since all your lines were terminated by a CR only, which doesn't work, unless you're on a mac...
Chances are if you just exported and imported without editing, it would probably work, but that's useless.
You need to save it windows compatible.
And if you're not on a mac... I'm lost as to why you're lines end in CR instead of LF.
Quote:
Originally Posted by phazei
I am on a mac, and your solution totally fixed my problem!
Thanks for your help, and for busting out a much improved mod!!!
Fixed: when creating new manufacturers it didn't add to both mfg db's, so if you went to add a url later on, it wouldn't work, and it broke ZM.
After I hit add to DB, it acts like it is adding the products, but nothing is added. I've used EasyPopulate before with no problems, but it was a few months ago so I have no idea what I am doing wrong. Any help would be greatly appreciated as I have a new supplier and over 4,000 products to add.
Upload Results
File uploaded.
Temporary filename: /tmp/php9odnSs
User filename: amulets.csv
Size: 12131
Upload Complete