I've tried about dozen or so time sto get this to work and I'm not having any luck at all. I've loaded other new items before but can't for the life of me figure this out.Quote:
Originally Posted by Serious
Anyone able to take a look?
Printable View
I've tried about dozen or so time sto get this to work and I'm not having any luck at all. I've loaded other new items before but can't for the life of me figure this out.Quote:
Originally Posted by Serious
Anyone able to take a look?
The products that won't load start ar in lines 9995 - 10633.
Zip file attached.
EDIT
The file is too big to add as a attachment.
Anyone care to PM me an email address I can sent it too?
No help = Sad Panda...:cry:
Weird.
The 638 products I'm trying to add are visible under the manufactures heading (Eaton) in the Mfg. Sidebox but not in the categoties/products.
There are a few products listed under "Axle & Drivetrain/Lockers & Carriers/Eaton", but they were loaded prior to the problem i'm having today.
http:// www .seriousoffroadproducts .com/
They aren't in the admin/catalog/categories/products either!!
How is that possible?
Recently I and getting a "Cannot Display Page...server dropped connection....can happen when server is busy....please try later" return from my browser (Safari) when I do an upload with Easy populate 1.2.5.4. I'm running 1.39h of Zencart. The upload seems to be working. Here is what I'm doing. I download the Price/Qnty xls file via EP and update the qty values through a formula, save as a tab delimited txt file. I try to split it, I get only one resulting split file even though the file contains 3600+ records and the split value is still at the default of 300. I've set the permissions to the temp dir at 777. When I upload the single split file, I get the browser error. I'll download the Price/Qty file via EP and check it, sure enough the new qualities are there. This is just a pain to check all the time that the upload took. Any ideas? I am running on a Godaddy hosting account. EP was working great a couple of weeks ago.
Thanks for any help! :frusty:
Trying to remove all products by changing product staus to 9 (per the Wiki) and the porducts are staying put.
debugg log says:
Quote:
[26-Mar-2011 07:31:20] PHP Warning: file(/home/seriouso/public_html/temp/../easypopulate2.txt) [<a href='function.file'>function.file</a>]: failed to open stream: No such file or directory in /home/seriouso/public_html/SeriousAdmin/easypopulate.php on line 1226
[26-Mar-2011 07:31:20] PHP Warning: Invalid argument supplied for foreach() in /home/seriouso/public_html/SeriousAdmin/easypopulate.php on line 1305
.php file line 1225 thru 1227:
line 1303 thru 1307:Quote:
// get the entire file into an array
$readed = file(DIR_FS_CATALOG . $tempdir . $file['name']);
}
Anyone got a hint for me?Quote:
// now we string the entire thing together in case there were carriage returns in the data
$newreaded = "";
foreach ($readed as $read){
$newreaded .= $read;
}
Serious
1. What version are you using ?
2. EP works the best if you upload max 300 products at once,split your file.
3. Did you enter any products into ZC before you used EP
4. Have you done a 'complete' download and edited your file so there is only 3-4 products in it, edit some changes and then upload via EP and see if that changes the products.
5. If you are uploading hundreds of products EP will not do a report at the end of the upload the screen will be just blank. If you do get a report, what are the results. Like I suggest reduce your file in size and then you would see results of the upload and it may give you some idea of whats going on
EP 1.2.5.4 works :clap:
Yesterday, I used EP1.2.5.4 to load 6500 products into an install at http://www.thepartymonster.co.uk .
I created my EP tab-delimited TXT file, then sent it via FTP to the temp folder.
I then used the "load from temp folder" feature in EP admin.
It loaded all 6500 products in about 90 seconds - no problem.
jvalich I have never used the split function via EP myself, I would suggest you split the file manually to say 10-20 products and see if that works. It may be php is timing out on the request to the server, and the connection is dropping. With this smaller file is would prove that it is a timing issue.
In MOST cases where data is not loading (or is producing errors) the fault is with the TAB DELIMITED TEXT file.Quote:
Originally Posted by Scrat
If your tab-delimited text file is clean, it will load... I do it many times a day on the sites we manage and I don't (generally) have any problems).
Schoolboy Hi (how's the rewrite of EP going ?, I've gone down the remote access route), matter of interest by ftp'ing the file did you get a report of product status' 'updated' etc in EP's screen.
jvalich says that the split file does update the database, if it was a format fault it wouldn't update the new data ?
...slowly...Quote:
Originally Posted by Scrat
Oh yes... all 6500 products showed up as "new product added". Took a while to load the page, but EP behaved as it should.Quote:
Originally Posted by Scrat
Without seeing the actual TXT file, I can't comment. All I can say is that if EP works loading 1 product (as a test), then it will load MANY products. My WIKI tutorial goes through some of the key processes, as well as common pit-falls.Quote:
Originally Posted by Scrat
EP1.2.5.4Quote:
Originally Posted by Scrat
I finally got everything deleted by a combination of things.
Broke down the product txt file into 11 seperate files of just under 1k each.
FTP'd to the TEMP folder
Ran each file through the EP upload process and was able to delete al but 750 products that way. I have no idea why these wouuld not delete.
I even created a Complete Tab Delimiyed txt file via Admin>Tools>EP and went through it line by line to see why these productswould not delete. Changed the Status from1 to 9 and tried to delete the remaining files 1 last time.....no luv.
Went into the Category/product page and deleted all Categories.
FTP'd my new product list and attempted to load it from the TEMP directory....Internal Server error message.......[sigh]
Tried loading via Browse>upload to DB from my local drive....work just fine.
Just need to add Categoriy and Sub-Cat images and I'll be okay.
Serious,
See this post on how to clear out your databases. Use with caution!
Also, you can use your zen_install to do this if you haven't removed it.
http://www.zen-cart.com/forum/showthread.php?p=1006332
Concerning your data:
1st SERIOUS error (no pun intendd ;P) you have a gap in your categories path, namely: you are skipping over category_name_3 (blank!) and putting a value in category_name_4.
I can only guess how much this will mess up your category tree.
You do this around records: 6353 - 6844, again 6845 - 6891, again 6892 - ... you get the idea. YOU MUST FIX THIS BEFORE ANYTHING ELSE!
2nd SERIOUS error: you have many duplicated v_products_model. Indeed, some of these look like dates "01/01/01" .... EP MUST ( I repeat MUST! ) use unique non-duplicate v_products_model identifers to populate your store, else you will have "duplicated" linked products that in no way have you intended to link (from their names/descriptions).
3rd SERIOUS error: BLANK v_products_name_1 .... this won't break your upload, but it will make for many headaches. I would not leave any products_name blank, ever. You are asking for trouble.
4th: products_name ... set to "0" ... set to all "EATON" "Detriot Locker" ... etc. Like you inadvertently put the manufacture there. At a minimum I'd pull this from your descriptions.
5th: To compound the 4th issue, you have the Manufacturer in the products_name, and then "........................." in the products description. You'll never know what is what!
6th: minor issue: many missing images
If I were in your position, I would first reset my databases using either of the above suggestions. Then install Dr. Bytes mysql backup tool. I consider this MANDATORY!
http://www.zen-cart.com/index.php?ma...products_id=81
Break your 10,000 products up into some logical/manageable order. Either master category, manufacturer or what makes sense to you. Carefully verify your data for completeness.
MANUALLY enter a few products from your spread sheet, do an export and compare your sheets to ensure you are doing things correctly.
Remember, you cannot mix products and categories! Your store will not work correctly. See some recent post where a new user was doing just that much to their grief.
Hope this helps get you on the right track.
Is there a way to attribute multiple styles in ep? In other words is I had an item that comes in three colors and wanted to provide a color select box on the product page, how would I do this with ep?
Also how would I make an item from one subcategory be a linked item in another subcategory via the upload?
Thanks in advance.
hi
i wonder if somebody would be kind enough to help me. I have installed easy populate 1.2.5.7.csv i am using zen v1.3.9f (i know i should upgrade) php5.3
i can manage to upload the csv file and all the categories list correctly, however, none of the categories have products in them???
All i get is this message:
There are no products to list in this category. :( please help me i am pulling my hair out; any help would be so appreciated.
Thank you kindly in advance
regards
USE Easy Populate Version 1.2.5.4..otherwise try another similar module i.e. ApsonaQuote:
I have installed easy populate 1.2.5.7.csv
i found a lot of that after I sent you the copy.Quote:
Originally Posted by chadderuski
Spent a looooooooooooooooong time going trough the orginal spread sheet from my vendor cleaning up mis-named products, image files, blank fields...
I'm still ninding crap that needs to be fixed...it's a slow process.
I had made a lot of progress and opted to start removing products by changing the Status field from 1 to 9. I broke down the .txt file to multiple smaller files and deleted small groups of products that no one looked at.
Thought I had a handle on it till around midnight (last night) when I attemptd to add 10 part to one category. Upload went smoothly but now, none of the product images in that entire category are visible.....argh..NOt AGAIN!?!?!:censored::censored::censored:
All the image files are still in their original locations.
None of the image file names were changed on my EP txt file.
In my experience, doing a STATUS = 9 on an EP upload will ALSO delete the products' images.Quote:
Originally Posted by Serious
When I do a STATUS = 9, I backup the images folder (usually by just renaming it to images-bak, and then create a new empty images folder with nothing in it (all this done via FTP client).
Then, after I have used EP to do the mass-delete, I remove the empty images folder and re-name the images-bak to its original name (ie: images).
I'm writing in hopes that someone may be able to quickly resolve the issue I am having. I have been working with developers to upload a suppliers catalog (in the form of excel spreadsheet) of 65,000 products into our database using EP.
Initially they uploaded all the products to MasterCategory=0. I then created a Misc. Category (ID#730) and a subcategory (#838) in which I want this particular catalog to go to. I then had them re-upload the products into the database with a MasterCategory ID#838 which is the subcategory I would like all the products to appear under.
The store shows that there are 65,000 products but on the site it only shows a short list of newly added products. In the admin side of ZenCart when clicking the miscellaneous category, the subcategory then disappeared. I tried adding a new subcategory and going into the database to change that category ID back to 838 so the products would appear but alas, no luck. Anytime I change the category ID to 838 the category then disappears although the products and the product_to_category ID relationship is established in the database...... Any suggestions??
Hey Boaters Planet - I'll take a stab at this if you haven't figured it out yet.
I do know that if you upload a product with a Model# that already exists, but the category is different, that new category will only be linked product and not a NEW master category. So what you do to change an entire category of link products to a master category is navigate in your ADMIN/Catalog to your list of products. Then on any of the products click the C for copy at left. Once the next page at the bottom left you'll see a button called "Multiple Category Links Manager". After clicking that you see a list of ALL the categories you have created. if the product you are looking at is in more than one category then more than one category will be checked. the one that is yellow is the master category. So if you see that you want to change that product;s master category AND all the products in that category along with it, look at the very bottom of the page where you'll see "Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ..." enter the number of the category you want to be the new Master category and viola! It changes.
I hope this helps! I'm sure why the category you created disappeared. Hopefully there's a logic explanation for that.
And now here's my Easy Populate problem!
I just finished add A LOT of attributes - 187 to be exact - and now I'm getting an error when I try to download (or create for the temp folder) a Model/Attributes.txt file. Other files are created fine, its just the Attributes one that isn't getting created. It might be a Timing Out error because the file is so large. The error I'm getting after about 90 seconds is:
500 Internal Server Error
---------------------------
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache mod_fcgid/2.3.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at focalpointhardware.net Port 80
---------------------------------------
I'm using Hostgator as my hosting service. I look in my cpanel at my "error log" it reads:
[Mon Apr 11 14:18:56 2011] [error] [client 7#.##.##.253] File does not exist: /home/focalpt/public_html/500.shtml, referer: http://focalpointhardware.net/zc_admin/easypopulate.php
Could the attributes file just be too large to create and thus the server is timing out? Or could there be some error how I entered my attributes? Here's an example of an attribute entry:
[DMY-LR EP 03] Dmy Left-Right EP Polish Brass
I just can't seem to figure this out. :frusty:
Hi,
I am using Easy Populate 1.2.5.4 and its working perfectly but i am having a slight issue when it comes to images. I am using excel to add my items to the website but you see i have an excel sheet with all the product details and everything about the products except the image path. Then i have a second excel sheet with about have those products on it with all the same details only i have the image path on this one.
Is there any way of putting the image paths into the correct products using excel or easy populate?
Something like this:
insert "v_products_image" from "database1" to "database2" where "database1" "v_products_model" = "database2" "v_products_model"
Thanks
FIRST! NEVER NEVER NEVER post this kind of server path details in an open forum. You're looking for all sorts of trouble form the hackers.Quote:
Originally Posted by BrooklynArtist
EP 1.2.5.4 Attributes DO NOT WORK! Period. You will need EP Advanced 3.03 from Langer. Unfortunately, he hasn't been around for years and there is no guarantee you'll get what you pay for if his site is actually still up. And his solution is clunky at best.
Optionally, you can try my BETA version off github. I have BASIC attribute imports working. PM me for any help as I don't want to hijack this thread:
https://github.com/chaddro/EasyPopulate-4.0
It installs independent of EP 1.2.5.4. Remember, BETA! Back up your data! Hoping to post it for public thrashing one of these days soon.
-cj
HI!
I've just installed Easy Populate and can not see it in my ZC admin page. please advise. thank you
Hiya QueenKat,Quote:
Originally Posted by QueenKat
You are most likely missing one or more files if you are not seeing the Tools > Easy Populate or Config > Easy Populate options. Verify that each file did correctly upload to your server.
Also, please give Schoolboy's great Wiki entry on Easy Populate:
http://www.zen-cart.com/wiki/index.php/Easy_Populate
That should get you on the right road.
I am an EP noob so please excuse my basic questions, I have searched around and am a little confused.
I have an existing download store and now have a load of physical (shippable) products to add in their own seperate category.
I installed EP, looks fine, the spreadsheet for my existing stuff was created ok. Have attached a few lines, take a look if required.
I have 2 questions:
1. I would like each product to have 2 images, one small 'title' image which would be the product thumbnail and a second 'main' image which would be seen in the product. Can I do this with EP or do I need something else?
2. Shipping, all of the existing products on the spreadsheet are downloads. The new products would all have the same shipping details. Is there a way to specify this in EP?
I've added my products using EP just fine, but even though they are visible on the store side using search, when I search on the admin side, they are never found. Any way that I can fix this? Thanks!
Cheepnis
Do you have breadcrumbs visible on your store? If so, after you do a search on a product, click it to view it's "Product Page", then look at the breadcrumb to see the path. It should show you the category or subcategory that it is in then follow that in your Admin/Categories.
If you do all that and still can't see then I'm stumped.
Well, yes, that would allow me to find the product within admin, but I SHOULD be able to just do a simple search within admin and have it show up there right away. The search function is what seems to be broken.Quote:
Originally Posted by BrooklynArtist
got a problem with EP
download full EP from my site and change information and upload... all spot on and working :-D
download price and qty from my site, change a feu prices and upload, chnages all the prices correctly but then also deletes all my product descriptions!!
whats the deal there??
Are you sure you are using 1.2.5.4? Some of the other version have "issues" ...Quote:
Originally Posted by kitcorsa
whoops sorry Easy Populate 1.2.5.5.csv
ebay turbo lister with easy populate
a dream but I think you can do this? I think many would be very glad to see this in action.
is it possible or it is already being done?
searching but cannot get answer.
Can we export our product from zencart to excel file then import it with TL?
Thank you
I'm getting this error when trying to use the Easy Populate add on
Warning: explode() [function.explode]: Empty delimiter
includes/functions/extra_functions/easypopulate_functions.php on line 241
what does that mean and how do I fix it?
I re-uploaded that file to the server and that didn't help..
How to include weight field in Easypopulate Froogle downloaded textfile?
Where do I locate the file to alter??
We are using Easy Populate 1.2.5.4 and Zencart v1.3.9e
Appreciate all help.
Thanks,
Per
Hi all,
Forgive me for asking a question which has no doubt been asked before but I couldn't find it when searching the thread.
What happens when a store already has products that never used model numbers ?
Well actually I know the answer to this :oops:
When downloading the product file for the first time non of the products had model numbers. After I assigned model numbers to these products and uploaded the file easy populate created new products for each model number. However the old products were still there so basically I was left with each product on the system twice - the original unmodeled one and the created by easy populate modeled sku.
No major issue caused as I had a backup to restore but what's the best way around this (other than assigning model numbers first before running easy populate - we have 5,000+ products in the database)
Rather use NUMINIX's excellent GoogleBase generator and feeder. EasyPop's Froogle feeder is many years out of date and probably does not conform to Google's requirements.Quote:
Originally Posted by pixbo
http://www.zen-cart.com/index.php?ma...roducts_id=473
This is just a rather obscure error message and it is telling you that there is something amiss with the TXT upload file that you are trying to load in the database.Quote:
Originally Posted by QueenKat
In many cases, it relates to DATE fields (such as "date added", "specials date" ...).
You MUST make sure that:-
1. Your EasyPop CONFIGURATIONS are correct (admin >>> configuration >>> Easy Populate) - particularly regarding the DATE formatting.
2. When you open your TXT file in a spreadsheet, it is very likely that it will automatically see the date values, and then REFORMAT them. This is a pain in the b u t t and you will have to make sure you REFORMAT the dates to that which EP uses. View a RAW text file of your data to see how EP is formatting your dates:times .
3. Generally, you can safely REMOVE EP columns (from the spreadsheet) that refer to DATES (unless of course you want date DATA in your upload.
The key to successful EP uploads is making sure that the TXT file is 100% accurate (in terms of complying with EP formatting).
SEE MY WIKI on Easy Populate:
http://www.zen-cart.com/wiki/index.php/Easy_Populate
Assigning MODEL NUMBERS (in your case) cannot be done with Easy Populate, as EP uses the Model Number field as a PRIMARY reference. This makes sense, as SKU protocol is almost always a case of a SKU number living and dying with an individual, single product. All formal retailers work on this basis. Go into any supermarket and look at the UPN/EAN/SKU/BARCODE . It is UNIQUE on every product. If a product goes off the market, the SKU number goes with it. It is NEVER used again, for any product.Quote:
Originally Posted by PatF
Your solution is to use SQL to update your product list. Even with 5000 products, this is not too difficult a task - but can be a bit time-consuming.
You will only be able to use EP after you have done these updates via SQL first.
Certain fields MUST be included when doing an EP upload. even if you are just changing prices. I know that you HAVE to include:Quote:
Originally Posted by kitcorsa
Model Number
Product Name
Product Description
Product Status
EOREOR
( I usually include most of the columns - even for minor changes, such as price).
1. Use the zencart ADDITIONAL IMAGES feature. https://www.zen-cart.com/tutorials/index.php?article=58Quote:
Originally Posted by weisdaclick
2. Easy Populate deals only with PRODUCT data. Shipping data cannot be managed using EP.
zc ver : 1.3.9h
php version : 5.2.10
ez pop ver : 1.2.5.4
fresh ZC install everything is up payment module and shipping i can communicate with the bank all of that i got my old products back but then i got to update some descriptions but nothing happens so i checked cache folder and i get this :
[29-Apr-2011 03:41:51] PHP Warning: file(/home/mywebsite/mystore/temp/test.csv) [<a href='function.file'>function.file</a>]: failed to open stream: No such file or directory in /home/mywebsite/mystore/temp/test.csv/admin/easypopulate.php on line 1179
[29-Apr-2011 03:41:51] PHP Warning: Invalid argument supplied for foreach() in /home/mywebsite/mystore/temp/test.csv/easypopulate.php on line 1279
anyway to rectify this at all?
test.csvQuote:
Originally Posted by christ89
Easy Pop 1.2.5.4 does not use CSV formatting.
The file MUST BE a TAB-DELIMITED TXT file.
http://www.zen-cart.com/wiki/index.php/Easy_Populate
How do I add a sku field to the downloaded file? I need am using the Numinux Products Fields mod for the sku field in the admin side.
Where can I find the debug file?? I have looked everywhere and my eyes are bugging:wacko:
Hello all!
I recently installed this add on and when I visited my
admin > Tools > Easy populate...
I see this:
http://img543.imageshack.us/img543/8...opluate.th.jpg
Is this how it should look like If not, how can I fix this?
Im using the latest Zencart
Thanks
Does anybody have a solution for this? When I manually add a product, it shows up on the admin search, but my EP-added products never show up. This is making it impossible to actually USE ZenCart. :no:Quote:
Originally Posted by Cheepnis
Not sure if this will work but it has for me.Quote:
Originally Posted by Cheepnis
Try Tools > Store manager >Reset ALL Products Master Categories ID and press RESET.
Please don't quote me on this, this is what I have tried and has worked for me but may not work for you. Back up if anything.
PERFECT!!!Quote:
Originally Posted by dimsumgurl
THANK YOU SO MUCH!!!
:clap:
Hi, I have just used excel populate to import into a fresh install. All went fine until I went in to amend the quantity. When I opened the product no details were in there apart from the price, product code and image location. Therefore I had to retype the description, title etc just to amned the stock quantity. What have I done wrong?
I have 7 products that are throwing an error, but I can't find the debug log. Where is it????
I think I can answer that - look in catalog/cacheQuote:
Originally Posted by helpme
In Zen Cart v1.3.9h / EP 1.2.5.4
Does anyone know why pretty much all my products have come up linked to 2 categories? They are only supposed to be linked to one, I'm having to manually remove 3700 x invalid category links.
iv downloaded an EP file of all my products from EP
removed all special characters from the feed file and tried to upload it, but it wont upload the file, i click upload and then it "pretends" to proccess the file but then nothing happens..
Hi
I have a couple of questions regarding EP. Sorry if they have been covered in this thread, but 336 pages is difficult to consume.
Firstly when I try to edit a product that I previously entered via the full EP spread sheet, it adds another product instead of edit the one already in the catalogue. For example I changed one digit in the model number.
Also, I have added extra fields into the products of my catalogue. Is there a way to populate these via EP? I can't seem to find the definitive answer when searching.
The simplest way:
Go into your admin area and delete the product then load your Tab Delimited .TXT file that contains the revised product.
To add fields:
http://www.zen-cart.com/forum/showthread.php?t=116061
Thanks I'll look at that thread.
So I can't edit with EP? If I want to edit 10,000 lines I have to do it manually through admin?
Yes you can edit, but EP see's your revised model number as a new product and add's it to your catalog as such. You could add the new model number as a new line on your .TXT file and then change the product status on the old product from 1 to 9. This will remove the old product from your catalog. IIRC, it will also remove the associated image file too.
It took me a long time to grasp the concept. EP doesn't know that your intent is, so to speak. All it can do is make changes based on very specific inctructions.
Lets say you have a product model number of 1234 and you want to change it to 123Z. Simply changing the number on the .TXT file won't work. EP see's this as a new item to be added. It has no way of knowing what you want to do.
It must be told that you want to delete a product model number and simply changing it on your .TXT doesn't do that.
So you must ;
A.) Tell it to Delete a Product Model Number
B.) Tell it to Insert a new Product Model Number.
This doesn't apply to changes you make in any of the remaining fields for a specific product. EP will make those changes since they will be associated with a known model number based on what is in the V_Products_Model field.
Make sense?
Anytime I try to download any tab-delimited files or save them to the temp dir, I'm always sent back to the login screen. This was brought up several times before, but it was never answered. Any help?
FYI, I'm using EP Version 1.2.5.4 on Zencart 1.3.9hQuote:
But when I click Download Complete tab-delimited .txt file to edit link, it ask for admin login, I login, click the link, but it still ask for admin login, then when I click the link or other link it always ask for admin login
Thanks!
Figured it out. It turns out that this (like several other contributions :censored:) won't work if I'm using full-time SSL in the admin. Not sure if it's because I use a shared certificate or not, but the only way this is fixed is if the admin/configure.php file is set to NOT have all four URLs as SSL. *sigh*Quote:
Originally Posted by Cheepnis
Sorry for the delay in replying. Many thanks for taking the time to reply. Makes perfect sense. Cheers.
Hi!
I can't seem to easily find a definitive answer. I am helping someone with their Zen Cart setup and we found Easy Populate as a good option for uploading the multiple products she has. However, she has already input about 50-60 products manually.
If I use Easy Populate and upload a list of additional products, will it leave the manually input products where they are or do I need to import them into the txt file to turn around and upload the entire inventory using EP?
Thanks!
Vanessa
As long as all the products have a unique model number it will leave the ones already entered alone. To be safe even the ones already entered should have a unique number. But back up beforehand just to be safe!Quote:
Originally Posted by vanessac
Dennis
using zen cart v1.3.9b
using easy populate 1.2.5.4
when i download froogle file, it is saying all items are instock, flag is equal to Y even when they are not. this downloaded file is very useful for me to create my googlebase file which i do as another step in excel. I have all the programming done, and have been using for awhile. only now i realize why the numbers of items keep getting larger, as out of stock items are in inventory. my datafeed at google is now not being uploaded as too many items are not appearing...
does someone know a mod to the code or can make one that corrects this problem so instock varible is either Y or N, according to actual setting? with over 10,000 items in this file, there is no practical way i can find the out of stock items manually.
thanks in advance for your help
Betsy
change line 2351 in easypopulate.php in folder adminQuote:
Originally Posted by jonprecise
Code:if ($col == $filelayout['v_products_model'])
to
if ($col == $filelayout['v_products_image'])
change line 1875 in easypopulate.php in folder admin
changer line 1879 in easypopulate.php in folder adminCode:if ($v_products_model != "")
to
if ($v_products_image != "")
Code:$result = ep_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_model = '" . zen_db_input($v_products_model) . "')");
to
$result = ep_query("SELECT products_id FROM ".TABLE_PRODUCTS." WHERE (products_image = '" . zen_db_input($v_products_image) . "')");
hope can help you :smile:
HI
Could someone point me to a starting point for Easy populate i have a csv from a supplier i want to import , in the past i have given up due to partial / incomplete uploads
I may be a computer engineer but databases make me feel very sick
Thanks in anticipation :D
TryQuote:
Originally Posted by CastleComputers
http://www.zen-cart.com/wiki/index.php/Easy_Populate
Of course lol ty
still feel sick mind :lookaroun
In the EP TEMP folder is a "sample" file...
Be VERY CAREFUL to open it in a plain text editor, and then look at the date formatting.
The trouble with spreadsheets (eg; excel) is that they automatically parse a date (or anything that looks like a date) into a date format (usually a default).
So when you come to do your data load, your date formatting may be different from that needed by EP.
Remember also, that EP (under the CONFIGURATION area of your admin) requires that you set the desired date format.
What I have done in the past is load up a dummy product using the standard add-product screen, giving it a date added as well.
Then, do an EP export from the store, and see how it's formatted the date for my test product.
That's how it must be formatted when you do your EP upload...
Thanks
Ill look at that t`moro i am all based out lol i am getting a few things uploaded troble is as i see it the data supplied by my supplier ie the catergories are all in one so to speak i am havin to separate them out and they are alphabetical i am doing this on a sub domain at mo
cheers :blink:
hi for all,
I have installed Easy Populate and work correctly expect UTF-8 char.
My language is arabic, but when I use Easy Populate all arabic word appeared as unknown char
but in english work very nice.
how can I use Easy Populate in arabic language?
I try to save my file as utf-8 encoding but when importing it the system show this message ( there is no model column
thanks for all
I am using this mod, I am familiar with Easy populate CSV, but on this one I can’t figure out how to add stock by attributes. Is there a column I need to add to make all the sizes I have appear as having “1” in stock? Do I have to add a column in the main CSV file or in the attributes file?
Thanks for any help
Bahaa87,Quote:
Originally Posted by bahaa87
You have to first check to see if you installed Zencart as UTF. In most cases this is not the default. You can check this through phpMyAdmin. Also look for Dr. Byte's tool for converting to UTF-8.
http://www.zen-cart.com/index.php?ma...oducts_id=1937
Be sure to properly backup your files before doing any conversion if necessary.
You will next have to use OpenOffice to export your data. OpenOffice will let you export in various encoding where excell seems to do what ever it wants. When using OO be sure to select "edit filter settings" when doing your export (or save as) and ensure you have the encoding you want.
-cj
I have found a nifty "bypass" that seems to work well.Quote:
Originally Posted by chadderuski
Instead of SAVING the spreadsheet as a TXT file (with appropriate character set), I use "copy and paste"...
I create the spreadsheet, making sure that the data is "clean for easy populate", and then I highlight the full range of cells and <CTRL+C>.
Then I <CTRL+V> into Emerald Editor (or equivalent text editor - use a good one) and I save THAT file as a TXT file with appropriate charecter set choice.
Hi,
I installed easy populate 1.2.5.4 , everything works correctly but one thing , my site encoded to utf-8 with hebrew.
export is working great i see everything in he but when i try to import the ep returns this failure :
anyway to fix this problem?Quote:
No model field in record. This line was not imported10113134CF | פרו פ� | | | פרו פ� | חתולי | | | | | 0 | 3.2 | | 2011-07-08 | 50 | פרופל | הכל ל� | אוכל � | יבש | | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | | | |
Thanks!!
Hi Zenners,
I have two languages on my website - Hebrew and English...
I am able to upload the products - EP uploads a category name in Hebrew - that is fine - however, Zen Cart does not allow me to add the category name in English... I edit the category and press update, however, the category name in English does not appear...
Any possible suggestions?
Eran
Hi Eran,
How do you upload in Hebrew , the script returns me problems with categories , any idea why ?
my site encoded to UTF8
Thanks
Shay
never mind it works!!
Quote:
Originally Posted by sitges65
i've the same issue, i can't find the aswer in this thread...could any one help me plzz....:frusty:Quote:
Originally Posted by sitges65
could any one can help me plz...:cry::cry:
Looks like I've found a Guinea pig for my modded version of EP. I rewrote the categories code to support multiple languages, but haven't found anyone to put it through the paces.Quote:
Originally Posted by eranariel
You can download from here:
https://github.com/chaddro/EasyPopulate-4.0
Be sure to test on a backup of your store! I'm not positive how the script will behave when english isn't the default (i.e. the "_1", and "_2" would be next languages.
Also, my code uses CSV not TXT, so use OO when editing, and you can install it along side your current version of EP without affecting it.
PM me if you have any questions so as to not hijack this thread :p
-cj
Hi Chad
I grabbed the EP 4 off github a few days ago, and I will hopefully have some time in Aug to put it through the mill.
AWESOME! Could really use your input! Basic attribute importing is working, but really needs testing.Quote:
Originally Posted by schoolboy
So far I've had pretty good feedback (or a lack of complaints!). Check the "Issues" tab for one thing that will need to be fixed, though most people haven't run into that.
Haven't had much time this year to work on it much... real work getting in the way. jrobeson's version on github is VERY different (though he is using
some of my code). He has some good ideas and more features but he's taken a real tangent away from zencart and I've had problems getting his
version to work now. He's gone the Zenmagik route.
If you think it passes muster as a replacement for 1.2.5.4, I'll post a support thread for it. I just haven't had time to daily support questions on it, and just
offer it to those people looking for a specific solution so I've been reluctant to really push it as a replacement.
Thanks again,
-cj
Is it multi-lingual? By this I mean can you upload the products in the csv in multiple languagesQuote:
Originally Posted by schoolboy
Chad's been devoting huge energy to the multi-language aspect, and he's close...Quote:
Originally Posted by Design75
Hopefully it will have reliable language support... but we're still testing. It's a big project and all I've managed to do so far is stand on the sidelines and :clap:
This is chad's work thru and thru - all I'm doing (when I have time) is testing.
Thx, that great to read. I know it's a lot of work and I appreciate your efforts. So here is a big :thumbsup: for all of you, and a nice cold refreshing drink :cheers:
EP has always been "sort of" multi-lingual. This is what the "_1" is used for each language. In the past, EP has had problems when English wasn't the default language. It's been someQuote:
Originally Posted by Design75
time, but I believe I did cover that in my work. When I redid the categories (I really didn't like have 7+ columns for them) I also added language support. Only made sense. So now you
have v_categories_name_1, and the full path is specified in a single cell where each level is separate by a unique delimiter.
For example: "Kitchen Utensils^Kitchen Knives^Clam & Oyster Knives"
My work on importing attributes correctly does not yet support multi-languages. Attribute importing isn't really even at what I'd call beta, more still in development. There is a flaw (or feature depending on your point of view) in zencart's attributes core design that makes importing and building attributes at run time very difficult. I have an idea on how to solve this, but it would require some heavy core modifications, and that is not my goal for EP4. So to use my mode, I have imposed a restrictions that the products_options_name be unique (much like products_model must be unique).
Ack! If I keep this up, I'll really have to make a new thread for it. Don't want to pull focus from 1.2.5.4!
hello,
I started my own thread regarding a problem I have with Easy Populate before finding this thread. Rather than double posting, If I could just direct those with expertise here;
http://www.zen-cart.com/forum/showthread.php?t=183398
The problem is that I have multiple links to 'Easy Populate' from the 'configuration' drop down.
I have been using easy populate for some time with no problem but for some reason when I upload a new ep file i get and internal error 500. Not sure why. Any suggestions.
Thanks
Lexxie
thanks for the reply to my query... my apologies for not replying sooner!
I'll test and get back to you...
Best,
Eran
Hi biggDQuote:
Originally Posted by biggD
Did you get this sorted out? I have exactly the same symptoms, same EP version, but Zencart 1.3.9.h.
heatherm and biggD:
Do you have your admins set to SSL? I saw an earlier post of someone having this problem, and it was "fixed" by taking the admin off SSL.
Let us know if that is also your issue.
Unable to search products in Admin if they were added with Easy Populate.
If I ad new product with or without a new category by hand, then I can search in the Admin Categories/Products area and in the store.
If the new product is added with Easy Populate then a search in the Admin Categories/Products menu doesn't show anything for that item, but if you search in the store it does.
This has been an ongoing problem for about 7 months now. I totally deleted the entire category and sub categories that was giving me problems before and started adding it back in one category at a time. The very first addition via Easy Populate would not allow searching in the Admin area.
HELP! I absolutely MUST be able to search for products in the Admin area. Why is this happening?
Running ZenCart 1.39h
items added using a text file comma delimited
Only added about a dozen items.
NOTHING I add with Easy Populate will allow me to search ANY of the items in the Admin.................
Well.... I found the fix.
In Admin / Tools / Store Manager
Reset ALL Products Master Categories ID
Hello Zenners,
I can't get EP to install. When I go to my admin page I can see Easy Populate under tools, when I click on it nothing happens, blank page only, no install. Please help met out!
Zencart version 1.39, dutch & english language,I tried to install under both languages, same result nothing happens/installs. I can see all the files in the correct directories (myadmin) Any Ideas??
I have used EP 1.2.5.4 for years and it works great . But today when I clicked Create Complete tab-delimited .txt file in temp dir (Attributes Not Included) The page just went blank. There was no file in temp dir to download. But then I clicked Create Model/Price/Qty tab-delimited .txt file in temp dir . And it worked. I guess my file was too big. It is about 10 MB. I am wondering if there is any way to solve the problem. Any suggestions will be welcome.
Sunrise,Quote:
Originally Posted by sunriseimports
That is a pretty big file! The script is probably timing out without any warning and just being killed by the server.
If so, you can try to increase your execution time in your php.ini file (if you have access):
Look for:
max_execution_time = 30 ; Maximum execution time of each script, in seconds
and increase that and see if that helps.
I managed to upload a bunch of prices in the v_specials_price field that I didn't actually want to keep there. I've successfully altered that column to a zero value and re-uploaded the file, but there does not appear to be a way for EasyPopulate to upload a null field and erase a value already in the database to be replaced with no entry. I don't want ANY values in this field. What do I enter into this field to overwrite what is in the database with a blank entry?
Help please. My cart has all these red lines through it, and it's a hassle. I have 2,000 products so removing the "specials" price manually from each one isn't happening.
Thanks!