Views: 1,301,117
Zen Follower
SaMortensen
Two Very Import Fields : -
v_status EOREOR
You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.
Zen Follower
I tried to upload files today using easy populate v1.2.5.4 .....i was trying to update my first half of my files with the produtcts url's and then I upload some new files...well...i kept getting this error
and the only thing i added was the manufacturers url to my product information that shouldnt have messed it up should it?
This is the error i kept on getting:
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>500 Internal Server Error</title> </head><body> <h1>Internal Server Error</h1> <p>The server encountered an internal error or misconfiguration and was unable to complete your request.</p> <p>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.</p> <p>More information about this error may be available in the server error log.</p> </body></html>Then after i tried to upload my files so many times i got this error:
1226 User 'u70568462' has exceeded the 'max_questions' resource (current value: 50000)
in:
[select value from sessions where sesskey = 'ba0414ffc29cc39d6fa5871e0407183b' and expiry > '1216072998']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I know what the second error is....its because i had to many products/attributes uploaded at one time and the server cannot handle it....
But the first error (internal server error) i have no idea whats going on that has never happened before.
I know i have it set up right to because the other day i uploaded 1299 items with no problem.....
Could this be a problem with my hosting?
I have netfirms right now
Zen Follower
rickiesdiscount:
I tried to upload files today using easy populate v1.2.5.4 .....i was trying to update my first half of my files with the produtcts url's and then I upload some new files...well...i kept getting this error
and the only thing i added was the manufacturers url to my product information that shouldnt have messed it up should it?
This is the error i kept on getting:
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>500 Internal Server Error</title> </head><body> <h1>Internal Server Error</h1> <p>The server encountered an internal error or misconfiguration and was unable to complete your request.</p> <p>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.</p> <p>More information about this error may be available in the server error log.</p> </body></html>Then after i tried to upload my files so many times i got this error:
1226 User 'u70568462' has exceeded the 'max_questions' resource (current value: 50000)
in:
[select value from sessions where sesskey = 'ba0414ffc29cc39d6fa5871e0407183b' and expiry > '1216072998']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.I know what the second error is....its because i had to many products/attributes uploaded at one time and the server cannot handle it....
But the first error (internal server error) i have no idea whats going on that has never happened before.
I know i have it set up right to because the other day i uploaded 1299 items with no problem.....
Could this be a problem with my hosting?
I have netfirms right now
I forgot to mention Also my files are split in to 200 products per file.....
the first time i uploaded them they worked fine...now after i uploaded them with the manufacturers url...it has an internal server error
New Zenner
Scrat:
SaMortensen
Two Very Import Fields : -You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.
Scrat,
Thank you so very much. I have finally achieved success! Now all I need to do is get those pictures uploaded!
Thanks a MILLION for your help! :clap:
New Zenner
Scrat:
SaMortensen
Two Very Import Fields : -You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.
Scrat,
it worked!!!!
only.. 1. it created catogories of the same name for some. 2. I have e.g. 'treats'
for cat. 1 for some items and cat 2 for others. when i go back to zc, it says invalid master id, and created 2 ids of 'treats' for me
Zen Follower
Hi, I was wondering if there is a way to make all my products "product is virtual" with easy populate. At the moment all my products are prompting the customer for a shipping address which I dont want.
Zen Follower
lizar5- : Sorry in short the answer is no :no:
If all your products are virtual then the easiest way would be to use a sql script.
Zen Follower
Scrat:
SaMortensen
Two Very Import Fields : -You need in v_status either : 1 = new import or 9 = Delete this product and every line/row must have " EOREOR " at the end.
Just telling if somebody finds this useful:
And 0 is a hidden product. I use for example when not wanting to delete but the product is longer time out of stock or I need to change the info but has no time exactly on that moment.
New Zenner
I have read through the thread and am unable to find my answer.
everytime i try and add a product, i get this problem:
| T696969 | T4444I.jpg | This is a | Test | | 69 | 0 | 0 | 0 | | 0000-00-00 | 69 | | Hex Keys | Hex Sets | | | --none-- | 1 !New Product!
| | | | | | | | | | | | | | | | | | |
No products_id field in record. This line was not imported
products_id???
every line does end with EOREOR
Zen Follower
Sc0rian : EP has to have a product_id/model, other wise EP just does not work.
By the looks of it your file format is incorrect, you look to have a empty TAB to start with> *****| T696969 | T4444I.jpg |
As always if you have problems with EP start with a downloaded Complete File and work from there.:yes:
New Zenner
Hi
I'm very new to all this so please bear with me.
I installed Zencart and easypopulate yesterday and managed to get it to add a product or two okay.
I don't seem to be able to see the images though, is it supposed to upload the images at the same time?
If it is, what path name am I supposed to use and if not is there an addon within Zencart someone can recommend for me to do this.
Cheers
Jayne (the dizzy blonde):bigups:
New Zenner
bluedogatdingdong:
Hi
I'm very new to all this so please bear with me.
I installed Zencart and easypopulate yesterday and managed to get it to add a product or two okay.
I don't seem to be able to see the images though, is it supposed to upload the images at the same time?
If it is, what path name am I supposed to use and if not is there an addon within Zencart someone can recommend for me to do this.
Cheers
Jayne (the dizzy blonde):bigups:
you put the image name in the excel file, and upload the image into the /images DIR using FTP.
Scrat:
Sc0rian : EP has to have a product_id/model, other wise EP just does not work.
By the looks of it your file format is incorrect, you look to have a empty TAB to start withAs always if you have problems with EP start with a downloaded Complete File and work from there.:yes:
Hey,
thanks for the reply
I downloaded the complete excel document, it downloads as a .txt file.
v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_priced_by_attribute v_products_weight v_products_sort_order v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_tax_class_title v_status EOREOR
those are the list of items i get. i'm missing product_id?
i tried adding in v_products_id as my very first list, still doesnt work.
| 496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated!
| 497 | T69696 | T4444I.jpg | T69666666 | a test | | 1212 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !New Product!
New Zenner
Thanks - I really wanted my customer to be able to do it all through the control panel on Zencart. I take it that this is not an option.
Zen Follower
Sc0rian : Your product_id column is 'v_products_model' column one in your file.
Post your Complete file as an example and we can have a look. ( To me it looks as I said previously you have a leading TAB
| 496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated!
Where as it should be
496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated!
bluedogatdingdong : No, other than coding it yourself in PHP for server side or coding it on our customers PC.
Totally Zenned
bluedogatdingdong:
Hi
I'm very new to all this so please bear with me.
I installed Zencart and easypopulate yesterday and managed to get it to add a product or two okay.
I don't seem to be able to see the images though, is it supposed to upload the images at the same time?
If it is, what path name am I supposed to use and if not is there an addon within Zencart someone can recommend for me to do this.
Cheers
Jayne (the dizzy blonde):bigups:
Read this: http://www.zen-cart.com/wiki/index.php/Easy_Populate
New Zenner
Scrat:
Sc0rian : Your product_id column is 'v_products_model' column one in your file.
Post your Complete file as an example and we can have a look. ( To me it looks as I said previously you have a leading TAB
| 496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated!
> Where as it should be
> ```php
496 | T4444I | T4444I.jpg | T4444I Imp | High-quali | | 9.59 | 0 | 0 | 0 | | 0000-00-00 | 17 | | Hex Keys | Hex Sets | | | --none-- | 1 !Updated!
bluedogatdingdong : No, other than coding it yourself in PHP for server side or coding it on our customers PC.
ok, i've uploaded my example.
New Zenner
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.
Tried to import files with less columns but no success.
All help is welcome.
New Zenner
i got the exact same problem gerhard59
Zen Follower
Sc0rian & gerhard59 : What version of EP are you using, please note this is the thread is for Version 1.2.5.4 and that is the version to use any other seems to be buggy (Excluding EPA of course which is a commercial version)
New Zenner
Hi Scrat,
I am using version 1.2.5.4 that is what the zipfile is named.
Although readme talks about another version, not shure now if I use correct version.
Where can I re-download 1.2.5.4 and compare with my version?
Fields marked required must be completed.
Tell staff why this post should be reviewed.