-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Okay, so another confusing statement, but no matter... :)
So, each field that has an underscore followed by a number (ie. _1) is a field that can be found in the (prefix)products_description table. And again, the number corresponds to an installed language. No two stores are guaranteed to have the same sequence of languages. (Meaning a random selection of websites that have multiple languages may put Spanish 2nd, 1st, 6th, etc... Assuming that another language was applied/installed at some point before...
So, regarding the field length... That is controlled within your mySQLadmin editor...
If you open the mySQLAdmin editor (most likely through your cPanel), then open your store's database, then open the table (prefix)products_description, then while on the Structure tab, select the products_name field and edit it.
The next window should show the various information related to the field. For example the Length/Values... Update though for this type of data to have the maximum that you want to be able to enter.
Hope that helps.
I'm so sorry I made my statement confusing. Thank you for the instructions. I followed them exactly, and unfortunately, this is the exact same thing I did previously which did not work.
Went to database>table: products_description>products_name and changed VARCHAR to 165 under Length/Values.
Went to database>table: orders_products>products_name and changed VARCHAR to 165 under Length/Values.
The Database Field Lengths are still listed as follows on the "Easy Populate 4.0.22 - Beta 6-10-2012" page from where I again imported the file to my test site:
Database Field Lengths
categories_name:255
manufacturers_name:32
products_model:32
products_name:128
After I re-imported the file, I got the same results on some of the products: "Warning! ...(product Model and info are listed)... exceeds max. length: 128"
Any more ideas? Is there a modification which has to be made to the EP4 code which is downloaded on my site? If so, where and how or is this not applicable?
Thank you for your help.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
pdevo
I'm so sorry I made my statement confusing. Thank you for the instructions. I followed them exactly, and unfortunately, this is the exact same thing I did previously which did not work.
Went to database>table: products_description>products_name and changed VARCHAR to 165 under Length/Values.
Went to database>table: orders_products>products_name and changed VARCHAR to 165 under Length/Values.
The Database Field Lengths are still listed as follows on the "Easy Populate 4.0.22 - Beta 6-10-2012" page from where I again imported the file to my test site:
Database Field Lengths
categories_name:255
manufacturers_name:32
products_model:32
products_name:128
After I re-imported the file, I got the same results on some of the products: "Warning! ...(product Model and info are listed)... exceeds max. length: 128"
Any more ideas? Is there a modification which has to be made to the EP4 code which is downloaded on my site? If so, where and how or is this not applicable?
Thank you for your help.
If you haven't modified the EP4 code, then there is nothing about EP4 that is hindering using more space in the field. I say this because EP4 reads the size of the field from the database and then reports (and uses) that size to display what you are seeing. It could be that the value was cached somewhere in the process. Suggest clearingcache/cookies and trying again, or trying to access from a different browser or machine (sort of like clearing those two without actually doing so for the first two tries or so.) Anyways, EP4 just didntsee the change at the tme of testing, perhaps when you read this next (if the change stays the way it is/was) EP4 will report a. Different result.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
If you haven't modified the EP4 code, then there is nothing about EP4 that is hindering using more space in the field. I say this because EP4 reads the size of the field from the database and then reports (and uses) that size to display what you are seeing. It could be that the value was cached somewhere in the process. Suggest clearingcache/cookies and trying again, or trying to access from a different browser or machine (sort of like clearing those two without actually doing so for the first two tries or so.) Anyways, EP4 just didntsee the change at the tme of testing, perhaps when you read this next (if the change stays the way it is/was) EP4 will report a. Different result.
Thank you so much for the follow up. Although I tried clearing the cache yesterday and didn't see a change, this morning when I booted up fresh for the day, the change showed up. It is not showing on my test site but I am taking steps to clear that up. Thank you so much for your help. I am without a developer right now (and desperately need one) and truly appreciate your assistance and that of the forum.
I see we can "buy you a cup of coffee" for your help. I would be happy to do that. Can you please direct me on how to get that done?
Thank you.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
pdevo
Thank you so much for the follow up. Although I tried clearing the cache yesterday and didn't see a change, this morning when I booted up fresh for the day, the change showed up. It is not showing on my test site but I am taking steps to clear that up. Thank you so much for your help. I am without a developer right now (and desperately need one) and truly appreciate your assistance and that of the forum.
I see we can "buy you a cup of coffee" for your help. I would be happy to do that. Can you please direct me on how to get that done?
Thank you.
You are quite welcome. It's good to know that EP4 was not the cause of the problem.
I'm not sure how close to the line of allowance I am on stating this. Some of those that offer assistance have a website in their signature section of their post(s). This is often a good way to find out more about what they do, or offer. Perhaps for some it is clearer than for others.
Coffee though, sure helps encourage productivity (or just make one jittery. :) )
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
pdevo
Thank you so much for the follow up. Although I tried clearing the cache yesterday and didn't see a change, this morning when I booted up fresh for the day, the change showed up. It is not showing on my test site but I am taking steps to clear that up. Thank you so much for your help. I am without a developer right now (and desperately need one) and truly appreciate your assistance and that of the forum.
I see we can "buy you a cup of coffee" for your help. I would be happy to do that. Can you please direct me on how to get that done?
Thank you.
Someone is always willing to help:yes:
-
Re: EasyPopulate 4.0 Support Thread
I apologize if this question has come up already, I have searched through over 50 pages of the thread before I decided to just send this question: I am currently using a temporary url (ip address/~sitename) and I cannot get ep 4.0 to upload my full complete file. I get directed strait to the admin login screen. I use ep 4.0 for every site and do not typically use a temp url, but I need to in this instance. I did find one post regarding this and it turned into a pm but a solution to the problem was not offered. I have updated my config file (both) to reflect the temporary url, but it's still not working. I also double checked for "//" and it is not there either. I am fairly confident there is something else I am missing in the config file or uploads directory but can't figure it out. Again, my apologies if I missed this somewhere else in this thread. Looking forward to assistance. Thanks.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
creyesx6
I apologize if this question has come up already, I have searched through over 50 pages of the thread before I decided to just send this question: I am currently using a temporary url (ip address/~sitename) and I cannot get ep 4.0 to upload my full complete file. I get directed strait to the admin login screen. I use ep 4.0 for every site and do not typically use a temp url, but I need to in this instance. I did find one post regarding this and it turned into a pm but a solution to the problem was not offered. I have updated my config file (both) to reflect the temporary url, but it's still not working. I also double checked for "//" and it is not there either. I am fairly confident there is something else I am missing in the config file or uploads directory but can't figure it out. Again, my apologies if I missed this somewhere else in this thread. Looking forward to assistance. Thanks.
When you say upload, do you mean import? Or do you mean that you are having problems getting the file to exist on the server to be processed via import?
How many items are you trying to process? Have you tried splitting the file? Have you tried using a single line item in a file and trying to import it? Does it work, or cause the same result? If there is a configure.php problem I would suggest addressing that through a different thread. Ideally you would use the install utility of ZC to create the configure.php file for your version. There are FAQs about that in the forum.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
When you say upload, do you mean import? Or do you mean that you are having problems getting the file to exist on the server to be processed via import?
How many items are you trying to process? Have you tried splitting the file? Have you tried using a single line item in a file and trying to import it? Does it work, or cause the same result? If there is a configure.php problem I would suggest addressing that through a different thread. Ideally you would use the install utility of ZC to create the configure.php file for your version. There are FAQs about that in the forum.
How many items are you trying to process? Have you tried splitting the file? Have you tried using a single line item in a file and trying to import it? Does it work, or cause the same result? If there is a configure.php problem I would suggest addressing that through a different thread. Ideally you would use the install utility of ZC to create the configure.php file for your version. There are FAQs about that in the forum.[/QUOTE]
Yes, I meant upload. I am unable to get the file to exist on the server. It just takes me to the admin login screen. I have tried to upload the Full/Complete file several times (more than 5) with making adjustments to the uploads directory. I can't get past the upload so am unable to import a single line item in a file (I tried to upload with a single line item though) nor am able to split the file since it doesn't upload. The export function is not working for me either. To double check my suspicion of thinking it had to do with using the ip address (using temporary url until domain name servers are changed), I tried to duplicate my efforts with another site that is using a temporary url and had the same result. The config files were created by zc via cpanel, but I am not certain if that is one in the same as the utility since this is the only way I have installed ZC with other sites. Thank you very much for responding, I typically don't post unless I am completely stuck.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
creyesx6
How many items are you trying to process? Have you tried splitting the file? Have you tried using a single line item in a file and trying to import it? Does it work, or cause the same result? If there is a configure.php problem I would suggest addressing that through a different thread. Ideally you would use the install utility of ZC to create the configure.php file for your version. There are FAQs about that in the forum.
Yes, I meant upload. I am unable to get the file to exist on the server. It just takes me to the admin login screen. I have tried to upload the Full/Complete file several times (more than 5) with making adjustments to the uploads directory. I can't get past the upload so am unable to import a single line item in a file (I tried to upload with a single line item though) nor am able to split the file since it doesn't upload. The export function is not working for me either. To double check my suspicion of thinking it had to do with using the ip address (using temporary url until domain name servers are changed), I tried to duplicate my efforts with another site that is using a temporary url and had the same result. The config files were created by zc via cpanel, but I am not certain if that is one in the same as the utility since this is the only way I have installed ZC with other sites. Thank you very much for responding, I typically don't post unless I am completely stuck.[/QUOTE]
Hmm, interesting indeed. You should be able to ftp the file and put it in the directory used by/for EP4. Then perhaps the import will take. I would say though, that it is not an EP4 issue. Perhaps folder permissions maybe don't allow the transfer or still could be a configure.php issue. Typcially it is not suggested to install cia the cPanle, but instead. By ftp and then go to the webpage address to install, rename the admin folder and basically remove the install folder. This is not to say that install won't work that way, but there have been known to be problems.
There may be something else going on also related to the store's setup as to why you are taken back to the admin login while under this temporary setup. But as said, if. Able to ftp the file to the right place, try to import. (And yes since can't upload, all the rest about importing doesn't help from my previous message.)
What is the configuration otherwise? ZC version, php, etc.?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Yes, I meant upload. I am unable to get the file to exist on the server. It just takes me to the admin login screen. I have tried to upload the Full/Complete file several times (more than 5) with making adjustments to the uploads directory. I can't get past the upload so am unable to import a single line item in a file (I tried to upload with a single line item though) nor am able to split the file since it doesn't upload. The export function is not working for me either. To double check my suspicion of thinking it had to do with using the ip address (using temporary url until domain name servers are changed), I tried to duplicate my efforts with another site that is using a temporary url and had the same result. The config files were created by zc via cpanel, but I am not certain if that is one in the same as the utility since this is the only way I have installed ZC with other sites. Thank you very much for responding, I typically don't post unless I am completely stuck.
Hmm, interesting indeed. You should be able to ftp the file and put it in the directory used by/for EP4. Then perhaps the import will take. I would say though, that it is not an EP4 issue. Perhaps folder permissions maybe don't allow the transfer or still could be a configure.php issue. Typcially it is not suggested to install cia the cPanle, but instead. By ftp and then go to the webpage address to install, rename the admin folder and basically remove the install folder. This is not to say that install won't work that way, but there have been known to be problems.
There may be something else going on also related to the store's setup as to why you are taken back to the admin login while under this temporary setup. But as said, if. Able to ftp the file to the right place, try to import. (And yes since can't upload, all the rest about importing doesn't help from my previous message.)
What is the configuration otherwise? ZC version, php, etc.?[/QUOTE]
The ftp to the temp folder works! It still takes me to the login screen after importing but at least it imports. Since it's a temporary url, I can work with that to at least get the products on the site and then I will update the dns servers and the temporary url issue will be gone. Thanks for the suggestion!
-
Re: EasyPopulate 4.0 Support Thread
creyesx6:
do you have a static ip for the site? if so, you can use the IP for the site rather than the http://server.domain.com/~cpanelusername/
shortcut. I HAVE seen issues with this before but don't remember how we fixed it. Using the IP has always worked for me though.
http://server.domain.com/~cpanelusername/ <<< there is a name for this, but I can't find it. It's like using a semaphore, but that's not right either. Anyone know??
-chadd
Quote:
Originally Posted by
creyesx6
Hmm, interesting indeed. You should be able to ftp the file and put it in the directory used by/for EP4. Then perhaps the import will take. I would say though, that it is not an EP4 issue. Perhaps folder permissions maybe don't allow the transfer or still could be a configure.php issue. Typcially it is not suggested to install cia the cPanle, but instead. By ftp and then go to the webpage address to install, rename the admin folder and basically remove the install folder. This is not to say that install won't work that way, but there have been known to be problems.
There may be something else going on also related to the store's setup as to why you are taken back to the admin login while under this temporary setup. But as said, if. Able to ftp the file to the right place, try to import. (And yes since can't upload, all the rest about importing doesn't help from my previous message.)
What is the configuration otherwise? ZC version, php, etc.?
The ftp to the temp folder works! It still takes me to the login screen after importing but at least it imports. Since it's a temporary url, I can work with that to at least get the products on the site and then I will update the dns servers and the temporary url issue will be gone. Thanks for the suggestion![/QUOTE]
-
Re: EasyPopulate 4.0 Support Thread
I am using Zen Cart v1.5.1 (The latest one) and Easy Populate for v1.5.1.
I Downloaded Zen Cart today after finally losing patience with OpenCart, and have ran into trouble using easy populate. I would really appreciate some help from the community.
When I go to add my CSV File to the database, this error comes up
PHP Code:
Upload Results
File uploaded.
Temporary filename: /customers/1/9/0/cheaponline############s.com/tmp/phpacB0j8
User filename: condoms.csv
Size: 24433
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported for all r | they come | moisten t | seal | and let y | the bette | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported tapered a | silky smo | special r | made from | individua |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported specially |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported Made from | teated en | Each cond |
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported the World | has put t | sensitive | and simpl |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported teat ende | made from | Ribbed | Warming;T |
No model field in record. This line was not imported warming a | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Durex Per | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported our studd | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported for extra | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported 40percent |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
Upload Complete
You can view the CSV File here, please just check this to see if I'm making any glaring errors - http://tinyurl.com/q5x58lr
(Please note, the CSV File contains adult goods, I Run an adult store so just be aware)
I am using windows 7 and Open Office Calc for the editing.
Any advice would be appreciated.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
ChrisUren
I am using Zen Cart v1.5.1 (The latest one) and Easy Populate for v1.5.1.
I Downloaded Zen Cart today after finally losing patience with OpenCart, and have ran into trouble using easy populate. I would really appreciate some help from the community.
When I go to add my CSV File to the database, this error comes up
PHP Code:
Upload Results
File uploaded.
Temporary filename: /customers/1/9/0/cheaponline############s.com/tmp/phpacB0j8
User filename: condoms.csv
Size: 24433
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported for all r | they come | moisten t | seal | and let y | the bette | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported tapered a | silky smo | special r | made from | individua |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported specially |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported Made from | teated en | Each cond |
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported the World | has put t | sensitive | and simpl |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported teat ende | made from | Ribbed | Warming;T |
No model field in record. This line was not imported warming a | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Durex Per | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported our studd | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported for extra | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported 40percent |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
Upload Complete
You can view the CSV File here, please just check this to see if I'm making any glaring errors -
http://tinyurl.com/q5x58lr
(Please note, the CSV File contains adult goods, I Run an adult store so just be aware)
I am using windows 7 and Open Office Calc for the editing.
Any advice would be appreciated.
Haven't looked at the file, but from the reported errors, the data is missing either a unique model number for each item, or the fields header is not formatted (spelt) correctly. Easy populate ver 4 requires every unique item to have a unique model number. For first time uploading, the model number could be generated in the spreadsheet using whatever method desired, but will be the model number for that product until changed in the admin panel.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
ChrisUren
I am using Zen Cart v1.5.1 (The latest one) and Easy Populate for v1.5.1.
I Downloaded Zen Cart today after finally losing patience with OpenCart, and have ran into trouble using easy populate. I would really appreciate some help from the community.
When I go to add my CSV File to the database, this error comes up
PHP Code:
Upload Results
File uploaded.
Temporary filename: /customers/1/9/0/cheaponline############s.com/tmp/phpacB0j8
User filename: condoms.csv
Size: 24433
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported for all r | they come | moisten t | seal | and let y | the bette | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Bubble Gu | Banana an | lubricate | Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported Coloured | Novelty;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported tapered a | silky smo | special r | made from | individua |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported as when i | size real | manufactu |
No model field in record. This line was not imported
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported tell them | condoms c | A width o | however | come in m |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported specially |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported Made from | teated en | Each cond |
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported the World | has put t | sensitive | and simpl |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported SKINS are | Skins nat | natural f |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported teat ende | made from | Ribbed | Warming;T |
No model field in record. This line was not imported warming a | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Durex Per | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported our studd | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported for extra | Ribbed | Warming;T |
No model field in record. This line was not imported Ribbed | Warming;T |
No model field in record. This line was not imported teat ende | made from |
No model field in record. This line was not imported 40percent |
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
Upload Complete
You can view the CSV File here, please just check this to see if I'm making any glaring errors -
http://tinyurl.com/q5x58lr
(Please note, the CSV File contains adult goods, I Run an adult store so just be aware)
I am using windows 7 and Open Office Calc for the editing.
Any advice would be appreciated.
Okay, have looked at the file now. Couple of things: the fields are not comma separated, they are semi-colon separated. I think that's the first thing that may be an issue with the code, unless you modify the separator in the EP4 code or as part of OO creating the file. The other is that there appears to not be any quotes around the field data. This may be the way the file got downloaded from the storage location provided, or they may be missing. Some have had success without the quotes, but with them and the appropriate separator EP4 is successful.
To clarify for anyone else, essentially EP4 is detecting a row of data, but the row is being considered as one entire string and not separate pieces of information to incorporate into ZC. So it is not picking up any particular field especially the products_model field which does have data in it and therefore providing the error of no model number.
Let us know what ended up working for you or if there is more assistance needed. Welcome to zen Cart by the way!
-
Re: EasyPopulate 4.0 Support Thread
Thanks for your help mc12345678, I googled a bit more and found out the .csv file needs to be saved as a tab delimited text file, Open Office was saving it as something else, and was filling the fields with randomly generated data when saving, so Easy Populate couldn't read it.
Needless to say once I found that out it was such an easy process, I've got just over 4000 products in my store and it took about 2 hours! Plus importing images was so easy, this was the one thing I was worried about, but it took a few minutes :)
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
ChrisUren
Thanks for your help mc12345678, I googled a bit more and found out the .csv file needs to be saved as a tab delimited text file, Open Office was saving it as something else, and was filling the fields with randomly generated data when saving, so Easy Populate couldn't read it.
Needless to say once I found that out it was such an easy process, I've got just over 4000 products in my store and it took about 2 hours! Plus importing images was so easy, this was the one thing I was worried about, but it took a few minutes :)
More than welcome. I thought atthe beginning of this thread there was a lot about how OpenOffice should be setup to handle a majority of the process, (though understand thatthere is still an issue possibly with a few of the languages and getting them to work with EP4), but glad you got it to work. Ihesitated from saying that it wasn't a true csv file, because I know some of the spreadsheet applications use other characters to identify a separator.
2 hours? Is that total time from start to finish of "recreating" your store, or was this EP4 processing time? There is areview going on to identify areas of improvement and if the 2 hour time frame had to do with EP4 pprocessing time, then perhaps some additionnal optimization should be sought.
-
Re: EasyPopulate 4.0 Support Thread
It took 2 hours to edit the files (From Spreadsheets to the correct .csv format) and upload them to my site.
-
Re: EasyPopulate 4.0 Support Thread
Hi,
i'm trying to see if there is a way to integrate an MSRP field, into the plugin, as I have tried with different approaches and now all prices are not displaying, in my test site!, I have a VPS, so that's not a problem, I am testing several ways to display list MSRPs as list prices and my price as a saving. I downloaded and tried the MSRP module, the 1.5.1 specific version, but it's messing things up as described, I just need a way to do this and to do it fast. A new field in the csv will speed things up, but I am not sure what approach I have to follow to include that in a way the EasyPopulate4.x reads it correctly.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
icecold
Hi,
i'm trying to see if there is a way to integrate an MSRP field, into the plugin, as I have tried with different approaches and now all prices are not displaying, in my test site!, I have a VPS, so that's not a problem, I am testing several ways to display list MSRPs as list prices and my price as a saving. I downloaded and tried the MSRP module, the 1.5.1 specific version, but it's messing things up as described, I just need a way to do this and to do it fast. A new field in the csv will speed things up, but I am not sure what approach I have to follow to include that in a way the EasyPopulate4.x reads it correctly.
I haven't downloaded the plugin you're talking about, but where is a field added to support MSRP (what database table) and what is the field name?
If the mod affects the products tble, then simply need to include the field name from the EP4 admin panel. (Do not prepend a v_ or other character that doesn't exist in the database field name). If the field is added to another table, then would need to modify EP4 to handle it.
But unless I misunderstood, it seems that the installation of the MSRP has an issue? Be sure to review the applicable discussion thread for that plugin, there may be fixes posted that haven't been incorporated.
-
Re: EasyPopulate 4.0 Support Thread
Forgot to mention/answer the last part of your post. If the field name falls in line with the direction previously provided then would export the database and the field name will be included, then update/insert the values desired however chosen and then upload the newly modified file.
-
Re: EasyPopulate 4.0 Support Thread
This a sample csv I just exported from the site
Quote:
v_products_price v_products_msrp
35 35
0 0
25 25
99 99
38 38
65 65
20 20
45 45
45 45
Those are the fields I am getting but for some reason my imported file didn't make any differences between the MSRP and the other price, I am having another problem, as no prices are displayed ...
please take a look at my demo store
HTML Code:
http://www.theoutletseason.com/demostore
You will notice no prices are displayed!
I don't know if this has to do with the way I entered them into the csv and then imported them into the site, or something else ...
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
icecold
This a sample csv I just exported from the site
Those are the fields I am getting but for some reason my imported file didn't make any differences between the MSRP and the other price, I am having another problem, as no prices are displayed ...
please take a look at my demo store
HTML Code:
http://www.theoutletseason.com/demostore
You will notice no prices are displayed!
I don't know if this has to do with the way I entered them into the csv and then imported them into the site, or something else ...
So, couple of questions, did the msrp work before trying to use EP4 to update it? If you either add a new product or modify an existing one, will the price appear?
Currently when viewing the source code of a page, the following is displayed:
Code:
<!--bof Product Price block -->
<h2 id="productPrices" class="productGeneral">
</h2>
<!--eof Product Price block -->
This indicates that nothing is being generated between the h2 tags. Perhaps a coding issue from installing the mod? Any error logs?
After adding a product to the cart, the cart does show a price. I was trying to look to see what, if any settings could have been changed to hide the price even on the product page, but haven't been able to validate that anyone (or combination of settings) would hide the price on all pages except the cart. There's options in the product listing. And I recall some under product type also, but...
At the moment, and without further pre_EP4 install/update information, couldn't tell you what went wrong, but generally speaking it seems that this really isn't an EP4 issue anymore at the moment. I say this because at least the one field (and there may be others) does export and am guessing will import as well, but that either bad data is being provided to the database or the module installation has an error. If it is a case tht this is not an EP4 specific issue, may I recommend posting to the thread about MSRP or starting a new thread to address this issue. Again, so far it appears that MSRP doesn't work based on the information provided.
-
Re: EasyPopulate 4.0 Support Thread
That's weird because there are no error logs and I have the same conclusion as you, that's an empty h2 tag, and there's nothing there ...
As i had a pretty much test installation, I did copy the core files from the mod ... however I did fix one by myself because there was a function without an ending } ...
Other than there were no modifications to the core files ...
nothing except for the template to prevent both right and left columns from displaying and a few changes in my mega menus to add more columns ... but core files supposed to be untouched so I felt safe just replacing them ...
However I think there might be something wrong with that module, although I couldn't see anyone complaining about what I found ...
-
Re: EasyPopulate 4.0 Support Thread
Hi,
I am struggling with how to use easy populate and wondered if there are some online tutorials or a wiki like there was for the older versions of Easy Populate?
Thanks
Vix
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Vix332
Hi,
I am struggling with how to use easy populate and wondered if there are some online tutorials or a wiki like there was for the older versions of Easy Populate?
Thanks
Vix
There's a lot inthis thread if you work your way backwards from here. Also, from what I understand the "old" wiki's/FAQ's make reference to "instructions" for this version, though they are not highly detailed. What seems to be the issue?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Vix332
Hi,
I am struggling with how to use easy populate and wondered if there are some online tutorials or a wiki like there was for the older versions of Easy Populate?
Thanks
Vix
Quote:
Originally Posted by
mc12345678
There's a lot inthis thread if you work your way backwards from here. Also, from what I understand the "old" wiki's/FAQ's make reference to "instructions" for this version, though they are not highly detailed. What seems to be the issue?
Linuxguy2 had posted the following in this thread related to the instructions:
http://www.zen-cart.com/showthread.p...60#post1236860
-
Re: EasyPopulate 4.0 Support Thread
I've read the Wiki but not sure about some things.
If I already have the products in my store and I just want to update prices and stock levels but not change anything else, what all fields are required to be used?
Item #, Price, quantity, if I just import those three fields, since the item number already exists on the site, will they be found and updated, but leave all other info as is?
Some-one mentioned I think that if the description field was empty it may delete the description from the item, what about if that field just does not exist?
I read that I can Delete items in bulk by using 9 in the status field. So 0 is inactive, 1 is active, and 9 will delete?
Is that correct?
What if I do not use a status field in the import? Will all the items remain as I have them already set, and ZC just set the status based on stock levels?
I have about 2,000 items available, but only want to deal with about 500 for now. The problem I have though is when I get a CVS from supplier I can choose what fields it contains, but ALL products will be included.
I'm trying to figure the best way to deal with with only 500 of 2,000 items.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
Bikerstuff
I've read the Wiki but not sure about some things.
If I already have the products in my store and I just want to update prices and stock levels but not change anything else, what all fields are required to be used?
Item #, Price, quantity, if I just import those three fields, since the item number already exists on the site, will they be found and updated, but leave all other info as is?
Some-one mentioned I think that if the description field was empty it may delete the description from the item, what about if that field just does not exist?
I read that I can Delete items in bulk by using 9 in the status field. So 0 is inactive, 1 is active, and 9 will delete?
Is that correct?
What if I do not use a status field in the import? Will all the items remain as I have them already set, and ZC just set the status based on stock levels?
I have about 2,000 items available, but only want to deal with about 500 for now. The problem I have though is when I get a CVS from supplier I can choose what fields it contains, but ALL products will be included.
I'm trying to figure the best way to deal with with only 500 of 2,000 items.
First things first, EP4 uses the model # (not the product_id) to associate a record in the file with a record in the database. So that is one of the "mandatory" fields to be included.
Regarding the description, well the code is written so that regardless of the presence of the description field in the csv file an array field is established and then when the file is imported, if data is available to be imported to that field then it is updated to that data, if the data is not available then it is set to null. This is something that is likely to be corrected in the next release.
Next to discuss, keeping a field's header (column title) but emptying the contents below it is equivalent typically to importing a null or zero or blank entry. If the desire is not to import the contents of a column, then typically the column in it's entirety is to be deleted. (Note again, the description field is currently one that should stay unless it is desired to clear the description field of every imported product.)
I really wish I could tell you from here if/what the other required fields are, but basically there are those to match the entry with the database and then there is the fact that EP4 was coded to always consider the description as a part of the import (of the full product csv file). It appears that there was not a consideration that the description field would not be included, which generally speaking is a reasonable expectation.
Btw, the previous occurrence of the description issue was one where the description field was completely removed not left empty, this issue was then confirmed through a code review.
For columns that are not mandatory and are omitted the data of the field will remain as was. Regarding changing the quantity of an item and it's relationship to the active status, it is known that simply increasing the available quantity does not activate the product. So if the desire is to simultaneously increase and reactivate the product then the status must also be included.
If I understand correctly, your supplier will provide a file with approx. 2000 items, but you only want to have your store display approx 500 of those items/be updated to reflect the data of those items. Basically if you leave off the status column (provided that at some point/somehow "deleted" products are in some way inactivated).
The questions asked above, I would agree are not likely in the wiki, and in a way not likely to totally be addressed in future primary documentation. They are good questions, but in my opinion are more about day-to-day operation than limitations, capabilities, etc...
Ideally, as in so many other situations, I would recommend that you find the method of update that is quickest for you by use of a test store, backing up the data, attempt the import of your data file and verify that the operation is successful, if not then restore, make the desired changes to the import file and try again. :) once the right combination of items is identified, then try to make it so that the process can be easily/quickly repeated. :) hope that helps a little.
-
Re: EasyPopulate 4.0 Support Thread
Thank you. Yes that does help allot!
I have a local test store set up now so that I can experiment.
I think I may have thought of a way to do what I want then, with your help Thanks!.
If I import all items to a category called "Everything" and that full import has status set to 0 then all items would be updated but hidden (I think)
Then if I import a second CVS of just the items I want to sell, status 1 for these, and include the description so it's not deleted, I would make active for sale only the items I want and they should be updated. I would of course need some fields like category in this second CVS so that the items are linked from the "Everything" category to the ones they belong in.
Does that sound about right and any bad side effects I may not be knowing about? Like to the database or anything?
Oh, I am using Easy Populate 4 and Zencart 1.5.1
I will go experiment some more again now.
-
Re: EasyPopulate 4.0 Support Thread
Hey everyone, I know that there have been a few that have had problems using EP4 when it comes to not wanting to deal with the product description. So, I finally sat down and worked through the code myself and here is a solution that works with the current version (v4.022) available from the first post of this thread, and soon to be available in the fork of the code that I have made. In the mean time, if you modify the import file that is located in the admin directory:
ROOT_OF_STORE/admin/easypopulate_4_import.php
Find the code that includes:
Code:
// BEGIN: Products Descriptions
...
...
...
} // END: Products Descriptions End
Code:
// BEGIN: Products Descriptions
// the following is common in both the updating an existing product and creating a new product
if (isset($v_products_name)) {
foreach ($v_products_name as $key => $name) {
$sql = "SELECT * FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE
products_id = " . $v_products_id . " AND
language_id = " . $key;
$result = ep_4_query($sql);
if (mysql_num_rows($result) == 0) {
$sql = "INSERT INTO " . TABLE_PRODUCTS_DESCRIPTION . " (
products_id,
language_id,
products_name, " .
((isset($filelayout['v_products_description_' . $key]) || ( isset($filelayout['v_products_description_' . $key]) && $product_is_new) ) ? " products_description," : "");
if ($ep_supported_mods['psd'] == true) {
$sql .= " products_short_desc,";
}
$sql .= " products_url )
VALUES (
'" . $v_products_id . "',
" . $key . ",
'" . addslashes($name) . "', " .
((isset($filelayout['v_products_description_' . $key]) || ( isset($filelayout['v_products_description_' . $key]) && $product_is_new) ) ? "'" . addslashes($v_products_description[$key]) . "'," : "");
if ($ep_supported_mods['psd'] == true) {
$sql .= "'" . addslashes($v_products_short_desc[$key]) . "',";
}
$sql .= "'" . addslashes($v_products_url[$key]) . "')";
$result = ep_4_query($sql);
} else { // already in the description, update it
$sql = "UPDATE ".TABLE_PRODUCTS_DESCRIPTION." SET
products_name ='".addslashes($name)."', " .
((isset($filelayout['v_products_description_' . $key]) || ( isset($filelayout['v_products_description_' . $key]) && $product_is_new) ) ? "products_description ='" . addslashes($v_products_description[$key]) . "'," : "");
if ($ep_supported_mods['psd'] == true) {
$sql .= " products_short_desc = '" . addslashes($v_products_short_desc[$key]) . "',";
}
$sql .= " products_url='" . addslashes($v_products_url[$key]) . "'
WHERE products_id = '" . $v_products_id . "' AND language_id = '" . $key . "'";
$result = ep_4_query($sql);
}
}
} // END: Products Descriptions End
I tested this with an update of a single record. Perhaps some confirmation of functionality?
The product_name is still an attribute that should remain. This targets the import of files that do not have the following prefixes: categorymeta-ep nor attrib-. If the file(s) have that prefix then the above code will not be processed.
-
Re: EasyPopulate 4.0 Support Thread
THANKS!
I may not be able to work on my test store for a couple days, but I will try that soon as I can!
-
Re: EasyPopulate 4.0 Support Thread
Hi, I am using this EP4 mod ok but would like to add an extra column in the detailed stock by attributes data csv file down load.This would allow me to easily cross reference the output to a stock quantity file supplied by a manufacturer using their stock codes which are slightly different to the model numbers I use on my site. I would like a new column showing the manufacturers product code. This would be tied to the stock i.d. for each product attribute. I am currently manually creating the table by adding the manufacturers code but this is a long process and I would like to automate this if possible.
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
propster
Hi, I am using this EP4 mod ok but would like to add an extra column in the detailed stock by attributes data csv file down load.This would allow me to easily cross reference the output to a stock quantity file supplied by a manufacturer using their stock codes which are slightly different to the model numbers I use on my site. I would like a new column showing the manufacturers product code. This would be tied to the stock i.d. for each product attribute. I am currently manually creating the table by adding the manufacturers code but this is a long process and I would like to automate this if possible.
Sort of have lots of questions related to this query; however,am I correct in assuming that if the currently preffered SBA (that has an additional field) was being used then the issue would be resolved?
That would allow storing the identifier that is described so that updates would be easier, but it would not resolve new items per se as the data would not be present to export until it was imported at least once. That also assumes that the additional field added by that version of SBA isn't used for other purposes of SBA. (Haven't identified how that field is used yet, just know that it exists.)
Otherwise the question would be how would one create the data of that field on export and what if anything is stored back into the database associated with that field.
Otherwise some custom programming to do all that would be needed. But first clarification would help from start to "finish".
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Sort of have lots of questions related to this query; however,am I correct in assuming that if the currently preffered SBA (that has an additional field) was being used then the issue would be resolved?
That would allow storing the identifier that is described so that updates would be easier, but it would not resolve new items per se as the data would not be present to export until it was imported at least once. That also assumes that the additional field added by that version of SBA isn't used for other purposes of SBA. (Haven't identified how that field is used yet, just know that it exists.)
Otherwise the question would be how would one create the data of that field on export and what if anything is stored back into the database associated with that field.
Otherwise some custom programming to do all that would be needed. But first clarification would help from start to "finish".
Yes the addition of an extra field would be a great help. I am trying to update quantities from a supplied csv file, but the fields in the supplied file do not match the Detailed Stock By Attribute Data file exported by EP4. At the moment I am using a separate look up file to cross reference the required info then reimporting the generated output file. To do this I have to manually add a column to the Detailed Stock by attribute data file that I download to give the manufacturers stock code. This is used in the look up table to find the stock quantities. Once the stock quantity is updated in the look up table I remove the added column and upload the file to update stock quantities in my store.
I realise I would have to input the information for all existing products but for any new products it would just be added at the same time as all the new product information.
-
How do you set up extra fields/columns in EP4?
Can anyone point me in the right direction please? I've trawled the support thread and can't find the answer.
I need to setup a field/column header so I can enter an International Article Number (EAN) next to the products - there are around 4000 products in my site.
I have managed to match up most of the csv fields and cut and pasted them in, but how do I create the extrafields/header columns for the other information for each product?
Thanks
Robert
-
Re: How do you set up extra fields/columns in EP4?
Quote:
Originally Posted by
triplex
Can anyone point me in the right direction please? I've trawled the support thread and can't find the answer.
I need to setup a field/column header so I can enter an International Article Number (EAN) next to the products - there are around 4000 products in my site.
I have managed to match up most of the csv fields and cut and pasted them in, but how do I create the extrafields/header columns for the other information for each product?
Thanks
Robert
Start a little further back on the issue. Does the field exist in your store's database? Are you having to create it now in order to hold this data you are wanting to capture? There are a few plugins that will create extra fields associated with each product that can then be exported/imported by EP4. EP4 handles existing tables and the data in them.
If the field(s) exist in your database, then you may be able to use the configuration area on the admin panel to add the additional field(s) as part of the export.
Adding fields though to the database isn't typically a one place add type situation, there are several files involved, not to say it's difficult, but need to consider all methods of use and where the field(s) need to be included.
-
Re: Difference between EP4 and easy_populate_csv_for_zencart_v1.5.x_v1.2.5.7c.zip
I see that the EP4 download link is at the beginning of this thread, and there is a different easy populate plugin download in the plugins area.
Is there anything that explains the difference between these 2 EP plugins? Or which is better, for example, for adding custom fields, or product files with over 5000 products, etc.?
-
Re: How do you set up extra fields/columns in EP4?
Quote:
Originally Posted by
mc12345678
Start a little further back on the issue. Does the field exist in your store's database? Are you having to create it now in order to hold this data you are wanting to capture? There are a few plugins that will create extra fields associated with each product that can then be exported/imported by EP4. EP4 handles existing tables and the data in them.
If the field(s) exist in your database, then you may be able to use the configuration area on the admin panel to add the additional field(s) as part of the export.
Adding fields though to the database isn't typically a one place add type situation, there are several files involved, not to say it's difficult, but need to consider all methods of use and where the field(s) need to be included.
Thanks. What I am trying to do is import a field from a csv from my product supplier, that presently doesn't match any of the the existing fields provided in the EP4 files. Therefore, I (think I) need to create a field in a header/column of a csv that I can copy and paste in 4000 EAN entries and they will show next to the product details on the website when imported.
I can't find any defined advice about this and having looked around for about 10 hours today, I am hoping someone can give me a clue.
I know very little about SQL/databases etc so if anyone knows a dummies guide anywhere to using EP4 with Zencart that tells you how to create new csv's for data supplied from a product supplier that can be imported into EP4 and will show in the right place when a customer looks at a product, I would appreciate some help!
As I said originally, half of the fields show because I can match them up with the existing EP4 provided csv's.
How do I get the rest of the info to show in zencart if there are not comparative fields to paste the information into?
Thanks
Robert
-
Re: Difference between EP4 and easy_populate_csv_for_zencart_v1.5.x_v1.2.5.7c.zip
Quote:
Originally Posted by
stiggybaby
I see that the EP4 download link is at the beginning of this thread, and there is a different easy populate plugin download in the plugins area.
Is there anything that explains the difference between these 2 EP plugins? Or which is better, for example, for adding custom fields, or product files with over 5000 products, etc.?
I haven't tried any other EP program, at least mostly because this one I found to have all of the attributes/aspects needed, and at the time I started using it I think it was the only one that was compatible with zC1.5.x.
I have seen a different EP program in operation on a 1.5.1 site, but if anything what I saw was that there were less options/features/information. This version does allow splitting files to minimize the workload on the system during import (large number of records), there are some customization options to pull out fields that were not considered necessary (or perhaps are new) when developing the central code. There are also some aspects of data conversion that are incorporated that I personally haven't really focused on, but appear useful for the right purpose.
Basically the history as I understand it is that once there was EP, then there were children all wanting to offer some new functionality or something. Even now I have started what is called a fork off of this version to add some functionality. I need to properly request that the functionality be incorporated, but in no way do I think that the changes I've made have resulted in a "new" version of the program. Anyways, this version hasn't been properly packaged yet for submission, and the latest author hasbeen working on a type of rewrite for it (as well as developing/finishing some instructions). That said, a version I have seen includes an interface with froogle. That's not incorporated in this version, but probably could be added in with little difficulty (another thing that is ideal about this particular plugin, the organization allows relatively easy modification.)
But those are just my thoughts and experience. I think this version has been rewritten to bring control more into the store owner's hands which can be good (and bad :P).
-
Re: How do you set up extra fields/columns in EP4?
Quote:
Originally Posted by
triplex
Thanks. What I am trying to do is import a field from a csv from my product supplier, that presently doesn't match any of the the existing fields provided in the EP4 files. Therefore, I (think I) need to create a field in a header/column of a csv that I can copy and paste in 4000 EAN entries and they will show next to the product details on the website when imported.
I can't find any defined advice about this and having looked around for about 10 hours today, I am hoping someone can give me a clue.
I know very little about SQL/databases etc so if anyone knows a dummies guide anywhere to using EP4 with Zencart that tells you how to create new csv's for data supplied from a product supplier that can be imported into EP4 and will show in the right place when a customer looks at a product, I would appreciate some help!
As I said originally, half of the fields show because I can match them up with the existing EP4 provided csv's.
How do I get the rest of the info to show in zencart if there are not comparative fields to paste the information into?
Thanks
Robert
So, first a product field needs to exist to receive the data associated with your content. One solution is to use a plugin that Numinix created. I can't say that I know all the ins and outs of it's capabilities, but hopefully. The documentation would lead to indicating that the new fields are added to the products table. See: http://www.zen-cart.com/downloads.php?do=file&id=1495
Then once the field(s) are known to exist and you know. The field name(s), on the configuration menu for EP4 there is a location to fill in additional fields for export. Simply type in the name of the field(s) separated by a comma if more than one. An example would be product_status. This will result in the file containing v_product_status. Then on import the same field name would be necessary (v_product_status) and it should be imported to the database. The important part on this end is that the data type matches what you want it to contain(text, numbers, etc...y
As for displaying the information, that would require modifications to your template files as applicable to show the desired field, with possibly a change to other files to retrieve the data.
Technically this all is custom coding, and really should be taken to a new thread. There is also information in the FAQ about adding fields to a table and product types, etc. There may also be a product type out there that will hold the type of information you want, but then EP may need some customization to obtain and import that new data.
Hope that helps a little, just realize that it is a large change to the database and default functionality and not a specific EP4 issue.
-
Re: How do you set up extra fields/columns in EP4?
Thanks for the explaination mc12345678. I installed the EP4 plugin, and it works great now (after the sql patch for quantity error).
I, too, am wanting the same thing as triplex, and after days of reading posts (yes days), so do many others, so if this topic gets moved, please post the link...
From my old miva days, I had bought an extra fields plugin from viking coders that was great. You created the fields, uploaded your header-less cvs text file, and during import products, simply assigned the fields (including extras) to the columns that you wanted via pull down menus in the admin. It was great because I could, too, keep my columns in my text file in the order I WANTED, not a set, rigid, zencart order. Then from the admin, I could edit the product pages and insert the variable name tolken (v_product_custom_field) to have it displayed in the html page where ever.
A plugin like that would be great for zencart...
An
-
Attributes - EP4
Is there a definitive guide on how to create attributes and feed them in to my site via csv?
My supplier has given me a csv and I need to transfer the attributes for each product to my zencart site.
So far I have managed to "match up" the data in the various columns and import all of the products, images and prices thanks to the info in this support thread.
But I can't do the same with the attributes side of things, and I can't find anything anywhere that tells me how to do it.
I have read about creating a basic attribute file but TBH I don't understand options/values etc. I really need an idiot sheet detailing step a to z if possible.
Do I have to import the main data first, and then set up a seperate csv for the attributes?
And then how do I input the attributes from the suppliers csv? Or are they picked up automatically somehow?
-
Re: How do you set up extra fields/columns in EP4?
Quote:
Originally Posted by
stiggybaby
Thanks for the explaination mc12345678. I installed the EP4 plugin, and it works great now (after the sql patch for quantity error).
I, too, am wanting the same thing as triplex, and after days of reading posts (yes days), so do many others, so if this topic gets moved, please post the link...
From my old miva days, I had bought an extra fields plugin from viking coders that was great. You created the fields, uploaded your header-less cvs text file, and during import products, simply assigned the fields (including extras) to the columns that you wanted via pull down menus in the admin. It was great because I could, too, keep my columns in my text file in the order I WANTED, not a set, rigid, zencart order. Then from the admin, I could edit the product pages and insert the variable name tolken (v_product_custom_field) to have it displayed in the html page where ever.
A plugin like that would be great for zencart...
An
Welcome for the little help I offer. :) my apologies for the SEVERELY delayed response. I have no real excuse and it's not like I didn't start on this response the same day it was posted.
While as a tool such as EP4 is being used ever more for mass product import and some of these features probably support that, I could not be sure how long it might take to develop the extra functionality. I could foresee the possibility of saving said output format sequences by a name or other convention. Technically, something like that can be done already with a little coding/code movement, anyways. On the issue of layout, the file being imported can be in any sequence already, it is the output that is currently in a set sequence. The latest author had even (though possibly years ago) asked for input on sequencing and if I'm not mistaken had received little to no input and therefore developed what is present out of personal/professional need.
Regarding extra fields, while EP4 is handy at "communicating" with the database, there are some aspects that have not made it to the public (github) version. For example, the current code uses get statements/links instead of form posts.m. As a result the added functionality described above is rather difficult to include. Hopefully the next version/update of this will incorporate a post method ofoperation, so such added functionality can be easily incorporated. (Things such as drop downs, radio buttons, etc... Without the need for javascript)
In the meantime, the code should be easily enough modified to suit the individual needs of sequence. Yes the suggested functionality would make it more adaptable for on the fly import and would offer the possibility of "saving" various setups so that the import/export could be repeated in the same sequence again in the future.
-
Re: Attributes - EP4
Quote:
Originally Posted by
triplex
Is there a definitive guide on how to create attributes and feed them in to my site via csv?
My supplier has given me a csv and I need to transfer the attributes for each product to my zencart site.
So far I have managed to "match up" the data in the various columns and import all of the products, images and prices thanks to the info in this support thread.
But I can't do the same with the attributes side of things, and I can't find anything anywhere that tells me how to do it.
I have read about creating a basic attribute file but TBH I don't understand options/values etc. I really need an idiot sheet detailing step a to z if possible.
Do I have to import the main data first, and then set up a seperate csv for the attributes?
And then how do I input the attributes from the suppliers csv? Or are they picked up automatically somehow?
I don't know how long it hastaken to write this reply as I know that I am continuously being interupted as I write it.
A definitive guide for adding attributes. Debatable on whether this could be considered such, but let me try to explain the functionality in perhaps the most understandable way possible.
Consider how sucha process works in thhe admin panel. Now instead of doing this one product, one attribute, one category at a time. Then repeat that step of the process for however many items/type of things are to be acted upon. So for example, an item can't be assigned an option value until both the option value and the product independently exist to be paired together.
The next aspect of consideration is the use of the basic or full option. This comparison has been described a couple of times in the thread by me and others.
For the most part, each option on the EP4 screen requires a different CSV file, while some actions could get combined, this way each file is identified to a task, and each task has an identified file. More things couldbe combined in some cases, but it makes for a consistent process. Again the a-z process is basically the same as what would be found in the FAQ on performing each suchaction. In order to do one action, a different action has to have been done before that. As for matching columns, what I suggest is that one or more products be created with the applicable type of information added, possibly with the name of what is seen on screen, export the various types of information and then realize that filling in the information beneath the column header will populate the model with that information.
That's about as simple of an explanation as I can offer. I'd be glad to offer more if there are more questions. Again apologize for the delay in replies. (Fyi, I started to write this within a minute of my last post in this thread.)
-
Re: Attributes - EP4
zencart 151 w/EP4 > upgraded to 153 > login, admin, tools, Easy Populate 4 = EP4 FATAL ERROR: No default language set.
Am I the first to get this error after the upgrade from 151 to 153, or did I do something wrong?
Thank you
-
Re: Attributes - EP4
Quote:
Originally Posted by
stiggybaby
zencart 151 w/EP4 > upgraded to 153 > login, admin, tools, Easy Populate 4 = EP4 FATAL ERROR: No default language set.Am I the first to get this error after the upgrade from 151 to 153, or did I do something wrong?Thank you
First to report it at least. Guess I'll be trying out ZC 1.5.3 to see what's new. Have already helped some others with installs of other types of product and personally was hoping that this would not be affected since it doesn't overwrite any of the files.So the error appeared when you went to the menu selection for EP4? Didn't have to try to upload or download anything to get it?
-
Re: Attributes - EP4
I cannot even try to upload/download anything...
I've got 2 test sites/zencart installs. First one I upgraded to 153, clicked on tools>Easy Poplulate 4 and got basically a white page with only that error message on the page.
So, I thought with the other test zencart, I'll click on tools>EP4 and click on the uninstall first, then go an upgrade to 153, then go back to tools>EP4 and click on install, but instead got the same white page with the error message.
-
Re: Attributes - EP4
Quote:
Originally Posted by
stiggybaby
I cannot even try to upload/download anything...I've got 2 test sites/zencart installs. First one I upgraded to 153, clicked on tools>Easy Poplulate 4 and got basically a white page with only that error message on the page.So, I thought with the other test zencart, I'll click on tools>EP4 and click on the uninstall first, then go an upgrade to 153, then go back to tools>EP4 and click on install, but instead got the same white page with the error message.
Unfortunately, that is the response I would expect. This may not work still (if you intend to try to uninstall which won't really fix the problem, again there is nothing overwritten. Will need to figure out what variables are necessary to continue to "track" the default language or see why you're getting that error. The second site, was that a clean install? Not an upgrade?The link that you would be clicking on is something like: YOUR-STORE/YOUR_ADMIN/easypopulate_4.php?epinstaller=removeThe thing is, that the first "page" is still loaded, but I don't know if the error will still occur before, at, or after the code that picks up that the program is to be uninstalled. Effectively at the moment, EP4 is looking for what ZC considers to be the default language. That is not being found (in your store) the way that EP4 expects. Testing will need to be done to see if 1) can be reproduced, 2) what is needed to eliminate the error other than removing the display of the default language on the first page. (Data is used throughout the code.)
-
Re: Attributes - EP4
Just did a brand new 153 install.
Uploaded EP4 files for EP4 install on new zencart 153 install.
Admin Login>Tools>Easy Populate 4
Same result: EP4 FATAL ERROR: No default language set.
Is there a quick fix like deleting a line out or editing a line in the easypopulate_4.php file? I only plan on using English.
-
Re: Attributes - EP4
Quote:
Originally Posted by
stiggybaby
Just did a brand new 153 install.
Uploaded EP4 files for EP4 install on new zencart 153 install.
Admin Login>Tools>Easy Populate 4
Same result: EP4 FATAL ERROR: No default language set.
Is there a quick fix like deleting a line out or editing a line in the easypopulate_4.php file? I only plan on using English.
So, I began looking at the code, EP4 has heavily used mysql_ type functions. ZC 1.5.3 transitions to mysqli_ type functions. The language issue is merely the first of many "errors" in the code under 1.5.3. While a better fix might be to use more of the ZC standard code/functions, I am making the changes to this program to maintain past compatibility and add compatibility with 1.5.3 and expct to push the changes to a github version later today. I have the core export functionality working, and am working on the import and then to take a look at the split module and lastly to look through the other files to see if there is any remnant of mysql_ type calls therein.
Alternatively, the entire code could be made 1.5.3 only, but there seems to be little reason to do this as it will only cause more forks in versions. Please have patience while this is being done, I understand the potential impact and am trying to work as quickly and soundly as possible on this.
-
Re: Attributes - EP4
A version of EP4 compatible with ZC 1.5.3 has been uploaded to github: https://github.com/mc12345678/EasyPopulate-4.0
I will be requesting a pull of this to the version shown in post one of this site.
The direct download is: https://github.com/mc12345678/EasyPo...ive/master.zip
Please feel free to provide comments on the changes... Yes there are more improvements that could be made to the program; however, those are/will be made as necessary/able.
Modifications of this version, made it compatible with ZC 1.5.3 without losing capability with earlier versions of ZC (ie., did not reduce existing capability), added an additional option to the SBA detailed download/upload if the "appropriate" SBA is installed (Still need to update this functionality for other SBA programs), modified the sort order option assignment when performing a basic attribute upload so that the sequence is 1, 10, 20, 30, etc... upon upload (specifics can be modified in the detailed attribute functionality).
-
Re: Attributes - EP4
EXCELLENT! That is a really fast 153 update!
Thank you very much for updating EP4, and for doing it so fast.
-
Re: Attributes - EP4
Quote:
Originally Posted by
stiggybaby
EXCELLENT! That is a really fast 153 update!
Thank you very much for updating EP4, and for doing it so fast.
Well, kinda came down to time is money. Either possibly have people walk away from this plugin due to lack of support or, try to see to it's continued survival. More than welcome, hopefully it doesn't need too much modification to suit your uses.
-
Re: Attributes - EP4
The content at the link of the first post of this thread has been updated. (Ie, don't have to remember where that post about an update is found in the thread. :) just go to the beginning of the thread.) :) it's the same place it always was, just now with the recent changes incorporated.
-
Re: Attributes - EP4
The latest version for 1.5.3 has been updated to 4.0.24 - 7-13-2014. This incorporates mc12345678's recent work.
Note that this version has not been tested with earlier versions of zencart (1.5.2,1.5.1, etc.). Standard importing appears to work fine.
However, I have just identified a error in the Attributes import. I am working on this now.... I recommend that you DO NOT attempt to import attributes until this is corrected.
-chadd
-
Re: Attributes - EP4
Bug found and fixed: Simple typo made while making this compatible with mysqli.
github has been updated. Lastest verison: 4.0.24 - Beta 7-15-2014
https://github.com/chaddro/EasyPopulate-4.0
-chadd
-
Re: Attributes - EP4
Quote:
Originally Posted by
chadderuski
Yup, I missed a $ in the ep4_attributes.php file... Darnit. Thank you for your testing, identifying the error, and correcting it.
-
Re: Attributes - EP4
Quote:
Originally Posted by
mc12345678
...Modifications of this version, made it compatible with ZC 1.5.3 without losing capability with earlier versions of ZC (ie., did not reduce existing capability)...
Quote:
Originally Posted by
chadderuski
The latest version for 1.5.3 has been updated to 4.0.24 - 7-13-2014... Note that this version has not been tested with earlier versions of zencart (1.5.2,1.5.1, etc.). Standard importing appears to work fine.
I went back to 1.5.1 for now until more plugins update to 1.5.3.
Please clarify that while the 4.0.24 7-13-14 version is 1.5.3 compatible, and untested for 1.5.1&0, it *SHOULD* be 1.5.1 compatible?
Thanks again
-
Re: Attributes - EP4
Quote:
Originally Posted by
stiggybaby
I went back to 1.5.1 for now until more plugins update to 1.5.3.
Please clarify that while the 4.0.24 7-13-14 version is 1.5.3 compatible, and untested for 1.5.1&0, it *SHOULD* be 1.5.1 compatible?
Thanks again
I can only say this: during the process of upgrading the functionality, I had to make changes to the code. As was pointed out, I made a mistake in not including a $ which is/was very important as that single character prevented the assignment of information to a variable on the ZC1.5.3 side. So.... There obviously is the possibility that in adding the additional code I made mistake on the "old" side (added an extra character or deleted something "minor". So... Without rigorous testing, one can claim that the software is not tested with previous versions. In addition, because so many have downloaded this program and visited this thread, making such a claim offers a level of protection. Lest we not all forget that this is still considered a Beta product and that backups are always suggested prior to uploading. :) (would like to incorporate an option to auto backup before each import, but haven't developed that yet.)
Additionally, I did not specifically test this on 1.5.2 and advised chadd of that fact, so that part if nothing else is completely true. It is/was untested with ZC 1.5.2.
-
Re: Attributes - EP4
Ok, thank you for the explaination.
Sorry, but 1 more question:
I now see that there is chaddro/EasyPopulate-4.0, and mc12345678/EasyPopulate-4.0. Chaddro mentions 4.0.24, but I just downloaded mc12345678/EasyPopulate-4.0 and noticed that it is 4.0.23.
Does the mc12345678/EasyPopulate-4.0.23 have the bug/typo?
Or is the mc12345678/EasyPopulate-4.0.23 the fixed version?
-
Re: Attributes - EP4
Quote:
Originally Posted by
stiggybaby
Ok, thank you for the explaination.
Sorry, but 1 more question:
I now see that there is chaddro/EasyPopulate-4.0, and mc12345678/EasyPopulate-4.0. Chaddro mentions 4.0.24, but I just downloaded mc12345678/EasyPopulate-4.0 and noticed that it is 4.0.23.
Does the mc12345678/EasyPopulate-4.0.23 have the bug/typo?
Or is the mc12345678/EasyPopulate-4.0.23 the fixed version?
Well, as of a moment ago, it's a moot point as they are both the same now. Between chadd and I, we each have a free account so can not update each others file sets. In discussion with chadd, that not all expected file locations got updated to show the new version. :) trust us, when either of us say it isn't easy to get 100% right each and every time.
-
Re: Attributes - EP4
I forgot to mention. Thereno harm in asking questions. If you hadn't asked the first question on Saturday, no change would have been made yet to this. It is unfortunate that so many plugins need updating to work and that there wasn't more of a "come check this out" before the release, but it is also good that thos early release was put out before they get the next version distributed shortly.
-
Re: Attributes - EP4
Okay. Since the changelog.txt file for each still reads "4.0.23 07-13-2014..." (and not 4.0.24), I was just uncertain about if the typo got fixed.
Thanks again.
-
Re: EasyPopulate 4.0 Support Thread
I can't get Easypopulate to show up in my Zen cart Admin.
When I installed Zen Cart through Cpanel I renamed the admin file to adminfp.
After unzipping Easypopulate 4.0 I then uploaded the files into their appropriate directories under adminfp.
I assume that the files and folders are uploaded in the file tree structure in the zip file.
When I log in to Admin Easypopulate doesn't show up in either the tools drop down or configuration.
what am I doing wrong?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
fpoint
I can't get Easypopulate to show up in my Zen cart Admin.
When I installed Zen Cart through Cpanel I renamed the admin file to adminfp.
After unzipping Easypopulate 4.0 I then uploaded the files into their appropriate directories under adminfp.
I assume that the files and folders are uploaded in the file tree structure in the zip file.
When I log in to Admin Easypopulate doesn't show up in either the tools drop down or configuration.
what am I doing wrong?
Did you upload the applicable ZC version folder for your version of ZC that is also in the zip file? (1.5 or 1.3/9 version folder? And did the contents of the admin folder in the zip file get added to your admin folder (ahich btw, should now be renamed since you have provided it here) and not the admin folder itself into your admin folder?
-
Re: Attributes - EP4
My bad, I did forget to update the changelog.txt file ... I will try to get some basic testing done today. Please note that I don't have the ability to test on all versions of php/mysql.
I have two servers running apache under whm and cpanel:
1) PHP Version: 5.3.27 and MySQL 5.5.37-cll
2) PHP Version: 5.4.23 and MySQL 5.5.37-cll
If your hosting company is progressive with security, and you're running an up to date version of cpanel, then you'll most likely be on MySQL 5.x ...
Also, PHP 5.5 has been out for some time (http://php.net/releases/5_5_0.php) and PHP 5.6 is still in testing I think.
If you are planing to upgrade to zencart 1.5.3, be sure to review the requirements first and make sure your host is up to date.
-chadd
Quote:
Originally Posted by
stiggybaby
Okay. Since the changelog.txt file for each still reads "4.0.23 07-13-2014..." (and not 4.0.24), I was just uncertain about if the typo got fixed.
Thanks again.
-
Re: Attributes - EP4
Preliminary testing with EP 4.0.24 on ZC 1.39g, 1.5.0, 1.5.1, and 1.5.3 appears to be working correctly for the basic import/export and attribute features. I did not test 1.38 (very old and insecure), nor 1.5.2 since this was a preview release and not an official download. I don't see why it wouldn't work on these, but I have to draw the line somewhere :p
I have not tested the Stock by Attributes features added by mc12345678. I'll leave testing to mc12345678 for these as I have not used this plugin, and there appear to be several flavors of it.
-chadd
-
Re: Attributes - EP4
mc12345678, Thanks, this works good now. Appreciate the hard work that you and others have given to make ZenCart a great little shopping cart.
-
Re: Attributes - EP4
Quote:
Originally Posted by
kennad
mc12345678, Thanks, this works good now. Appreciate the hard work that you and others have given to make ZenCart a great little shopping cart.
Welcome, though chadderuski and those that came before were the ones to lay the groundwork to make the changes I made possible.
In fact because of that work, hopefully soon this plugin will be a fully recognized ZC module. Believe it or not, the primary reason it hasn't become so is that instructions haven't been fully developed. Hopefully we can get a good set together and submit it soon.
-
1 Attachment(s)
Re: Attributes - EP4
I am a new eCommerce merchant. Installed PrestaShop 1.6 and decided that it may not be the best for our needs. So i looked at OpenCart, Magento and Zen Cart and decided on Zen Cart....
So I installed ZC 1.5.3 and EP4 4.0.24 (latest edition). When I try to log-in to my store right after the EP4 installation, my computer screen goes to GitHub. (See attached screenshot).
I temporarily removed the EP4 files so that I could log-in to the store. I was then able to log-in successfully. I installed the files once more taking care to make sure that they were copied to the correct folders. then I tried to log-in again so that I can complete the installation of EP4 and I got the same GitHub screen again.
What am I doing wrong?
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
I am a new eCommerce merchant. Installed PrestaShop 1.6 and decided that it may not be the best for our needs. So i looked at OpenCart, Magento and Zen Cart and decided on Zen Cart....
So I installed ZC 1.5.3 and EP4 4.0.24 (latest edition). When I try to log-in to my store right after the EP4 installation, my computer screen goes to GitHub. (See attached screenshot).
I temporarily removed the EP4 files so that I could log-in to the store. I was then able to log-in successfully. I installed the files once more taking care to make sure that they were copied to the correct folders. then I tried to log-in again so that I can complete the installation of EP4 and I got the same GitHub screen again.
What am I doing wrong?
That is very unusual. There is nothing in the code that chadderuski and I have worked on that would send you anywhere else but your own site.
Pleas identify each step you have done to obtain the files and then upload them to your site?
The process should be something similar to this: goto github (or use the direct link that I posted a few posts back) in the lower right corner is an option to download the zip file. Unzip the zip file, then files that are in the admin directory are loaded into the admin directory, files in the admin directory specific to the version of ZC are then loaded into the admin directory of the store, then the admin directory is accessed and logged into. Goto tolls: EasyPopulate 4, select install, then goto configuration->EasyPopulate 4, select/verify the temporary storage directory location and set any other desired options, then return to the tools area to use EP4.
No where in all of this is a user sent back to github nor is there any "reach back/out" by the software to communicate with any other location, business, or the like. (For those that might have a concern of using this software.)
-
Re: Attributes - EP4
Hi:
Speaking for myself, I have every confidence in Chad and your efforts to provide a safe workable module that would provide e-Commerce merchants using ZC with product import, export, and update capabilities, etc. Based on all that I have read yesterday, I am very impressed with EP4. Before installing the module I spent all of yesterday reading this thread from page 1 to page 147 before downloading the files. I wanted to make sure that I don't miss anything. I am saying that there is something I may have missed. I need someone to help me discover that. And, it's not that I copied the files from or to the wrong place. There may be something else going on that is unique to my setup
After downloading the files, I signed-up for GitHub. Could that be somehow connected to the problem? (I must admit. In all of my reading, I did not read up on what GitHub is.
When I installed the EP4 files, I was still logged into GitHub. Before reading your post, I wen back a third time and this time, I individually copied each EP4 file to my admin folder. The files that are supposed to be copied to the admin folder were copied there. The files that are in the includes folder went to the includes folder and their respective folders on my store server as per instructions. The file in the 'Zen Cart 1.5 Extra Files' folder that is in the extra_functions folder was copied to my server's admin>includes>function>extra_functions folder. I try to log-in to my ZC store and I get GitHub.
Now here is where it gets weird. At the loaded GitHub screen I noticed that I am logged in to GitHub. So I log out. When I logged out my screen changes to mydomain.com. Yousee I log into my store using the following link: foodsourcedirect/store/admin. But when I tried to log-out of GitHub, the screen changes to a 404 screen at foodsourcedirect.com, which is my disabled Pprestashop 1.6 store off of our root. So I said well let me delete the GitHUB account. Again it takes me to the same 404 screen. So I clicked on my username (AVFSD) on GitHub. That too takes me to the 404 screen. I changed to FireFox and logged into GitHub and deleted the account. I stayed on FireFox and tried to log-in to my ZC store and it still went to the GitHub screen that was attached in my previous post. And would you know, my username AVFSD appears again at the top of the screen this time with "Account Settings, "Sign-in" grayed out.
Somehow GitHub is now linked to my domain. I am not blaming you guys. I am saying that what is happening is weird and it would be great if we can work together to find out what happened. EP4 and ZC are the eCommerce tools that I need.
A.J.
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
Hi:
Speaking for myself, I have every confidence in Chad and your efforts to provide a safe workable module that would provide e-Commerce merchants using ZC with product import, export, and update capabilities, etc. Based on all that I have read yesterday, I am very impressed with EP4. Before installing the module I spent all of yesterday reading this thread from page 1 to page 147 before downloading the files. I wanted to make sure that I don't miss anything. I am saying that there is something I may have missed. I need someone to help me discover that. And, it's not that I copied the files from or to the wrong place. There may be something else going on that is unique to my setup
After downloading the files, I signed-up for GitHub. Could that be somehow connected to the problem? (I must admit. In all of my reading, I did not read up on what GitHub is.
When I installed the EP4 files, I was still logged into GitHub. Before reading your post, I wen back a third time and this time, I individually copied each EP4 file to my admin folder. The files that are supposed to be copied to the admin folder were copied there. The files that are in the includes folder went to the includes folder and their respective folders on my store server as per instructions. The file in the 'Zen Cart 1.5 Extra Files' folder that is in the extra_functions folder was copied to my server's admin>includes>function>extra_functions folder. I try to log-in to my ZC store and I get GitHub.
Now here is where it gets weird. At the loaded GitHub screen I noticed that I am logged in to GitHub. So I log out. When I logged out my screen changes to mydomain.com. Yousee I log into my store using the following link: foodsourcedirect/store/admin. But when I tried to log-out of GitHub, the screen changes to a 404 screen at foodsourcedirect.com, which is my disabled Pprestashop 1.6 store off of our root. So I said well let me delete the GitHUB account. Again it takes me to the same 404 screen. So I clicked on my username (AVFSD) on GitHub. That too takes me to the 404 screen. I changed to FireFox and logged into GitHub and deleted the account. I stayed on FireFox and tried to log-in to my ZC store and it still went to the GitHub screen that was attached in my previous post. And would you know, my username AVFSD appears again at the top of the screen this time with "Account Settings, "Sign-in" grayed out.
Somehow GitHub is now linked to my domain. I am not blaming you guys. I am saying that what is happening is weird and it would be great if we can work together to find out what happened. EP4 and ZC are the eCommerce tools that I need.
A.J.
So, first of all, I forgot my manners... Welcome to Zen Cart, and glad that you have chosen to go down the path of Zen.
I think I understand now what has happened. In some way, the html code of each of the files seen in github has been copied into the file itself that is being loaded. So, when the admin panel loads, the first of those files is loaded as saved... This takes the individual back to github. So, hopefully the instruction(s) provided in my previous post has helped to resolve this issue by providing the files to be manipulated locally and then uploaded to your site.
On the issue of github... Github is basically a storage location where incremental changes may be applied, tested and then accepted to be a part of the main product. So, it is possible that someone could run off and create a new feature off of the existing software, test it out without affecting the known functional code/item. While it is useful for programming, it can be used for any number of processes/documents. As far as I know, an account is not required to obtain general information from github; however, there are more/other options available with a login/at a fee. Anyways, if the files are/have been downloaded as suggested and then installed, the issues should be resolved.
-
Re: Attributes - EP4
Thank you for the Welcome. Didn't notice any "bad manners" I think you were in shock. Apparently it took a few minutes for the account deletion process to complete. Also, I went back and double checked and realyzed that I had not copied over "install.txt." One small error with big consequences. Such is life. Thank you again for your courteous and fast response.
The fourth try (installation) was a charm. I am in "Configuration" now.
Is EP4 particular about where I put the temp folder?
A.J.
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
Thank you for the Welcome. Didn't notice any "bad manners" I think you were in shock. Apparently it took a few minutes for the account deletion process to complete. Also, I went back and double checked and realyzed that I had not copied over "install.txt." One small error with big consequences. Such is life. Thank you again for your courteous and fast response.
The fourth try (installation) was a charm. I am in "Configuration" now.
Is EP4 particular about where I put the temp folder?
A.J.
EP4 itself is not concerned so much as to the location, though, I can't say that I have tried nor would suggest that the location be offsite. Predominantly, the suggestion is to place the files in the admin directory as it is at least removed by one step from the root of the directory. This is essentially a security precaution for the product information that is stored.
It has been suggested that since the instructions suggest the admin directory that the default be made to point to the admin directory. This is something that can be done using the ZC assigned constants and is likely to make it into upcoming modifications; however, there are a few other things to concentrate on first.
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
The fourth try (installation) was a charm. I am in "Configuration" now.
A.J.
Hi A.J.!
I must award you with the MOST BIZARRE bug ever award for EP4!!! Only things that come to mind... did you copy the individual files from github or copy paste the text into your only fles, or did you download and extract the EasyPopulate-4.0-master.zip file and work with those files?
I have never seen what you describe, and to be honest, I cannot even imagine how you accomplished it. NOW... hmmm... did you download "Github for Windows" and pull a version down or fork a version? Then try to use THOSE files?? There are a LOT of hidden files related to github in those folders when you do that... perhaps you did something like this?
Anyway. It seems you have it working now! Blame it on the NSA... they took control of your computer and were having fun with you!
-chadd
-
Re: Attributes - EP4
Hi Chad. hahaha
It was weird. I believe that it may have been a combination of things. I clicked on Install.txt thinking that it was providing install instructions. Then I opened a GitHUb account. Downloaded your EP 4.0 master zip and copied those files to my admin etc.... Then stuff happened.
Anyway that's behind us.
I have re-formatted my categories to make them compatible with ZC. I opted to include the zen cart demo categories and data during the zen cart installation.
What is the next step? Do I upload my categories using the Category-EPxxxx template? Or can I upload Full-EP xxxx formatted file with categories and all the other fields since I already have demo categories from the ZC installation?
Once I learn how to upload my data error free, then I will need to create 23 custom product fields. and update ZC with complete product information for each product. We are a natural health food store. (herbs, spices, supplements, teas, personal care, etc.) What I need to do is provide the customer with 'Read Only' product information for each product. I noticed that the Numinix module includes some of the custom fields that I need but not all. However, I am not clear on the sequence of steps on how to install Numinix.
These are the fields that I will have to add to the product table.
Ingredients
Safety Information
Suggested Uses
Product Information
Kosher (yes or no)
Organic (yes or no)
Case Size
Brand
Wholesale Price
Reference Number (Item Number)
UPC
EAN13
Condition (New or Used)
Warehouse
Origin
Botanical name
Label Directions
Unit of Measure (UOM)
Unit of measure per Each (UOMPEREA)
Brand
Unit Price
Discount Percentage
Long Description
Do I add custom fields in the ZC product database table using phpMyAdmin?
Thanking in in advance for your guidance
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
Hi Chad. hahaha
It was weird. I believe that it may have been a combination of things. I clicked on Install.txt thinking that it was providing install instructions. Then I opened a GitHUb account. Downloaded your EP 4.0 master zip and copied those files to my admin etc.... Then stuff happened.
Anyway that's behind us.
I have re-formatted my categories to make them compatible with ZC. I opted to include the zen cart demo categories and data during the zen cart installation.
What is the next step? Do I upload my categories using the Category-EPxxxx template? Or can I upload Full-EP xxxx formatted file with categories and all the other fields since I already have demo categories from the ZC installation?
Once I learn how to upload my data error free, then I will need to create 23 custom product fields. and update ZC with complete product information for each product. We are a natural health food store. (herbs, spices, supplements, teas, personal care, etc.) What I need to do is provide the customer with 'Read Only' product information for each product. I noticed that the Numinix module includes some of the custom fields that I need but not all. However, I am not clear on the sequence of steps on how to install Numinix.
These are the fields that I will have to add to the product table.
Ingredients
Safety Information
Suggested Uses
Product Information
Kosher (yes or no)
Organic (yes or no)
Case Size
Brand
Wholesale Price
Reference Number (Item Number)
UPC
EAN13
Condition (New or Used)
Warehouse
Origin
Botanical name
Label Directions
Unit of Measure (UOM)
Unit of measure per Each (UOMPEREA)
Brand
Unit Price
Discount Percentage
Long Description
Do I add custom fields in the ZC product database table using phpMyAdmin?
Thanking in in advance for your guidance
Whoa nelly,
Got a lot going on there. Okay, so Zen Cart, some of the basics both with the program and the forum.
Forum first, while all of us here have some knowledge of something or other, not everything belongs in every thread. Further, people tend to follow a thread (or jump into one) based on the title or subject of the thread. So there are a number of things interlaced in your question. I consider only a small portion applicable to this thread. Others apply to either a new thread or one of the existing ones. (For example, questions about numinix' software would be much easier to answer by those following threads about numinix' programs.) I have recently had to provide some instruction about how to incorporate his workings into a store, and my best advice to make future building easier is to wait until you really need his software/have finished installing other code before installing his mods. Background to that (which Ep4 is not subject to) is that some installations expect certain tables to be unmodified and therefore take no action to ensure a successful install regarding the number of columns in the destination table. So either await installation of other mods, or learn how to get around their shortcomings. (And remember that basically everything here is "given" out of the hardwork and "free" time that contributors have.) That said, anyone is permitted to upload a change to a plugin, there are some guidelines and like most things in the zen cart forum they are covered either in their own thread, a faq, or the wiki. Do understand that there is the random possibility that you will be considered accountable for the future of the plugin, but that is not always an issue. :)
So, I think I've covered the forum enough, and realize not all will present in this way. Some will advise to get out of the thread. :) but, hey gotta start somewhere. :)
So the items specific to EP4. Currently, ep4 does not go and create everything that doesn't exist when doing something like a full import. As you may have seen (but not necessarily paid attention to) in the forum I have at least a couple of times explained the general procedure and workings of EP4.
The first suggestion, and surprisingly or not the program was put together somewhat this way, is to actually try to create a product in ZC from the admin. Become familiar with the sequence, how does a product come to exist fully developed for display to a customer? If you understand that process, then putting the store together through EP4 is very similar, but with lots of options at once rather than the several clicks that may be involved along the way. Say to add ten option values each to 5 option names, for example.... That's potentially 50 entries if you don't take advantage of some of the quick actions available in ZC, or could be copying a row downwards five rows after having added the ten items once before, etc...
Another way to think about it, if it's not in the database, it needs to get there somehow and if it's not in the database at all, go back to the basics (basic import/export) then get detailed about it. So if wanting to know if a category exists, ask the daatabase possibly with a basic category export. If it's there, then it's probably not associated with anything, so have to possibly take a look at a detailed category list. Then well, it needs to relate to a product, but the product isn't there either, so back to basics with the product, get it's initial data in there, then move on until all things that feed the information on the detailed sheet are available/present.
Okay, so moving on a little from there and to bridge the gap. Once you get all of your new fields, you'll need to tell EP4 about them in some wya, whether that is to modify the sql datadump or to add the fields onto the modifiable list in the admin panel. Only enter the field name as it appears in the database, do not add v_ at the beginning of the field.
So, hopefully that helped in one or more ways.
-
Re: Attributes - EP4
You're right. I am new to this Forum thing. Thank you for your suggestions. It looks like I've got my work cut out for me.
A.J.
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
I have re-formatted my categories to make them compatible with ZC. I opted to include the zen cart demo categories and data during the zen cart installation.
What is the next step? Do I upload my categories using the Category-EPxxxx template? Or can I upload Full-EP xxxx formatted file with categories and all the other fields since I already have demo categories from the ZC installation?
Once I learn how to upload my data error free, then I will need to create 23 custom product fields. and update ZC with complete product information for each product. We are a natural health food store. (herbs, spices, supplements, teas, personal care, etc.) What I need to do is provide the customer with 'Read Only' product information for each product. I noticed that the Numinix module includes some of the custom fields that I need but not all. However, I am not clear on the sequence of steps on how to install Numinix.
Do I add custom fields in the ZC product database table using phpMyAdmin?
LOL! Yes, a loaded question. My recommendations...
I would re-run the install script and not select to install the Demo data. The demo data is not necessarily 100% compatible with EP4. For example, Zencart will let you add a product without giving it a Model number and Zencart will function fine like that. However, EP4 needs a products_model (that's the database field) in order to know when to add or modify information for a given entry in the database.
Use the blank (no demo data) store to start to build you categories and products.
Now, if you want to use the demo data to see how things are done, just create a new database from your cpanel and install another instance of zencart in a sub-directory of your website.
Categories: The Category-EP export is a 1-to-1 export/import tool and ONLY used to UPDATE category information (like assigning meta data, image names). You don't use this sheet for creating your category structure.
Best practices are to first define ON PAPER how you want your store's categories to be organized. Remember, you cannot mix products and categories on the SAME level (this will break things). EP4 will automatically create your category structure for you using the main (full) sheet, you just have to specify the path under v_products_categories.
So, per my notes in the download, add several products through the admin FIRST, then use EP4 to export this data. This will help make things clear.
Also, be sure to install the Backup MySQL tool in the admin. You can easily make a backup (say your empty store) and then experiment with EP4 at will. Make a mistake? Just restore the database.
You may not NEED 23 custom products fields, you may be able to use something like Tabbed Products Pro which uses CSS and javascript to compartmentalize your products description information into tabs. If you MUST add a field to the products table base (say UOM, or UPC which I've done myself) be aware that you must also modify the CORE code to read this data and display it, or allow you to edit it in the admin. As mc12345678 said, there are other threads for covering things like this.
I hope this helps you get on the right path!
-chadd
-
Re: Attributes - EP4
Thank you, Chad. I have a clearer understanding now on how to proceed. Time and coding skills are not on my side. (I am a newbie.) So these directions will serve me well. I had run the Auto Install script for ZC 1.5.1 on my web-host and then manually updated to ZC 1.5.3. Do I delete all the files in my store folder and then start over? Or is there a ZC auto install script for ZC 1.5.3 that I can run that will overwrite the current installation?
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
Thank you, Chad. I have a clearer understanding now on how to proceed. Time and coding skills are not on my side. (I am a newbie.) So these directions will serve me well. I had run the Auto Install script for ZC 1.5.1 on my web-host and then manually updated to ZC 1.5.3. Do I delete all the files in my store folder and then start over? Or is there a ZC auto install script for ZC 1.5.3 that I can run that will overwrite the current installation?
So there are as you have identified a number of ways to go about it, but if you look at the upgrade section of the documentation, there should be an indication of the files that have been changed/added/deleted based on the version from which have upgraded. Effectively, if the new files overwrite the old files, then only need to delete the "extraneous" files and verify that overridden files are/have been upgraded as well.
I have to say, I was obviously in the weeds of things when I wrote last... Categories... Sheesh, too much into writing some new code and thinking abstractly rather than specifically. :)
But as for some form of "autoinstaller" or autoupgrader, there are too many potential differences to effectively develop something like that at this time. Maybe if the core code becomes uneditable or fully overridden through the use of notifiers and observers, but until then it is my opinion that there are just too many possible differences that could exist in a file or set of files. There is the database upgrade that is performed through zc_install, but not an equivalent file editor.
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
Thank you, Chad. I have a clearer understanding now on how to proceed. Time and coding skills are not on my side. (I am a newbie.) So these directions will serve me well. I had run the Auto Install script for ZC 1.5.1 on my web-host and then manually updated to ZC 1.5.3. Do I delete all the files in my store folder and then start over? Or is there a ZC auto install script for ZC 1.5.3 that I can run that will overwrite the current installation?
Btw, to more succintly answer the question of upgrading, I believe there are instructions in the documentation provided in the install, but there also is this faq: http://www.zen-cart.com/content.php?...pgrade-my-site
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
Thank you, Chad. I have a clearer understanding now on how to proceed. Time and coding skills are not on my side. (I am a newbie.) So these directions will serve me well. I had run the Auto Install script for ZC 1.5.1 on my web-host and then manually updated to ZC 1.5.3. Do I delete all the files in my store folder and then start over? Or is there a ZC auto install script for ZC 1.5.3 that I can run that will overwrite the current installation?
Over and over again in the forums you will see where people installed zencart using their host's provided cpanel script. Sometimes they work well, others not. It depends on the type of hosting you have and what they allow you to do and the quality of their install package... and if it's up to date. Sometimes you need to install patches after installing.
The PREFERRED method is to download the latest zencart from this site, then upload and run the installer that way. But to do this, you need to be able to create your database in your site's CPANEL.
Once you've installed ZC a few times, it will be second nature. And you'll always want to test plug-ins and modifications to a backup of your site before modifying your LIVE site.
-
Re: Attributes - EP4
Hi MC:
Just re-installed in root with no demo data. Reading up on stuff now. And oh. This time EP installed on first try....
Thanks for the feedback and guidance...
A.J.
-
Re: Attributes - EP4
I just completed a fresh install in the root after downloading ZC 1.5.3 from the ZC site...no demo data. Re-installed EP 4.0.. and BackUP MySQL...
I appreciate the guidance...
A.J.
-
Re: Attributes - EP4
Well I managed to figure out how to install the theme. Still have to do a lot of tweaking. But I have also spent significant time going over my product data looking at formatting, errors, missing data, etc. Today I am going to import jest a few products using the full-EPxxx file after I manually enter one or two products.
Following are some questions I have about formatting and field names:
My images are in the “fsd” folder under images on the server root:
public_html/images/fsd/18959-SO-Spicy-Taco.jpg
Is this the correct format for the image import field FOR ZC 1.5.3?
Example:
/images/fsd/18959-SO-Spicy-Taco.jpg
I have three images for each product. Can I mass import all three at the same time for each product? If yes, How do I write the link? Is it?
/images/fsd/18959-SO-Spicy-Taco.jpg,/images/fsd/18959_SO_Spicy_Taco.jpg,/images/fsd/18959.jpg
The three images:
18959-SO-Spicy-Taco.jpg Medium
18959_SO_Spicy_Taco.jpg Large
18959.jpg Small
What are these?:
v_metatags_products_name_status
v_metatags_title_status
v_metatags_model_status
v_metatags_price_status
v_metatags_title_tagline_status
I need to know how meta title, keywords and descriptions should be formatted in ZC.1.5.3
v_metatags_title_1
Meta Title: Meta title-Sandalwood(injojobaoil)
Meta title-ChamomileGermanInJojobaOil
v_metatags_keywords_1
Meta description-PeacefulPatchouliSweetOrangeFoamBath25oz
v_metatags_description_1
same as keywords?
What is “v_products_url_1”? Is it the same thing as “url rewritten”? Following are examples. Is it formatted correctly?
Examples:
sandalwood-in-jojoba-oil
chamomile-german-in-jojoba-oil
tags
Is this the correct formatting for tags?
Chamomile, German, in, jojoba, oil
AJ
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
Well I managed to figure out how to install the theme. Still have to do a lot of tweaking. But I have also spent significant time going over my product data looking at formatting, errors, missing data, etc. Today I am going to import jest a few products using the full-EPxxx file after I manually enter one or two products.
Following are some questions I have about formatting and field names:
My images are in the “fsd” folder under images on the server root:
public_html/images/fsd/18959-SO-Spicy-Taco.jpg
Is this the correct format for the image import field FOR ZC 1.5.3?
Example:
/images/fsd/18959-SO-Spicy-Taco.jpg
I have three images for each product. Can I mass import all three at the same time for each product? If yes, How do I write the link? Is it?
/images/fsd/18959-SO-Spicy-Taco.jpg,/images/fsd/18959_SO_Spicy_Taco.jpg,/images/fsd/18959.jpg
The three images:
18959-SO-Spicy-Taco.jpg Medium
18959_SO_Spicy_Taco.jpg Large
18959.jpg Small
What are these?:
v_metatags_products_name_status
v_metatags_title_status
v_metatags_model_status
v_metatags_price_status
v_metatags_title_tagline_status
I need to know how meta title, keywords and descriptions should be formatted in ZC.1.5.3
v_metatags_title_1
Meta Title: Meta title-Sandalwood(injojobaoil)
Meta title-ChamomileGermanInJojobaOil
v_metatags_keywords_1
Meta description-PeacefulPatchouliSweetOrangeFoamBath25oz
v_metatags_description_1
same as keywords?
What is “v_products_url_1”? Is it the same thing as “url rewritten”? Following are examples. Is it formatted correctly?
Examples:
sandalwood-in-jojoba-oil
chamomile-german-in-jojoba-oil
tags
Is this the correct formatting for tags?
Chamomile, German, in, jojoba, oil
AJ
So, I tried to search for a previous post I made regarding meta data to clarify the issues/concerns about what a few of the fields are about. I think I also had a discussion about images in here somewhere that I was going to point you directly at. Sum and total though, and not to cop out of providing more direct assistance. I think much of the questions will be answered after you have entered one or more products for yourself then exported the data and reviewed it. I say this, because again EP4 is a tool to get you into the ZC database data without all of the clicks to modify/update many products. So... Regarding images for example. The rules of images are still the same here as they are in ZC, and EP4 does not put the images on the server. It only let's the database know where to look for the images. (I also meant to look at a data dump I had, but on a cell that's not the "easiest"). So, if I am not mistaken the path to your images as stored in the database should be relative to the path defined in the configure.php file for the images path. So, if they are in public_html/images/cartoons, then I think that all that is necessary in the database is cartoons/cartoon1.jpg for the image named cartoon1.jpg. But... The "correct" pth will be evident upon export of the test data. Btw, the reason I think I'm right is that a database can be transferred to another system and depending on how the configure.php files are setup then all of the data will still be available and point to the right location(s) if the associated files are in the locations identified by the configure.php references.
So, the next thing... Regarding image name(s), again, if you review the faq on how to add additional images, you'll note that the base filename is important to "finding" all of the additional images and the other thing is that the "main" or base image should be uploaded last. This later part is because after each image is loaded to the server, the path is also loaded to the database. So, with the base image loaded last, the record becomes populated with the base name and all other associated files are then located. Files that end in _MED will be used as the medium sized image, etc... Again something that would be seen on export of a product that properly displays and has additional images.
Regarding the meta information, first I would suggest looking at the meta information window of a product, at least to see the "fields" that are identified for meta information. Along the top I think it is are switches yes/no or true/false related to each of the meta attributes of a product. That is the "status" of the meta information. The other items, keywords, description, etc. Are more or less what they describe, keywords are single words or a combination of them that are expected to be associated with the product. The description is more sentence like, words that provide clarifiaction about the product that are "hidden" in the metatags. The number at the end of any field corresponds with the language designation in your cart and is a field that when multiple languages exist can be defined for each language or else will end up adopting language 1 (typically english).
As for the product_url, that is data that typically is filled in at the bottom of the product info page and when filled in provides a link with the product stating something like to find out more about this product click here with a clickable link to the address filled in.
At this time, EP4 has not been programmed to handle/address rewritten urls, not to say that it isn't possible, it just hasn't been incorporated into the code.
Hmm, think I got all the items, but if not feel free to ask again! :).
-
Re: Attributes - EP4
Thank you MC. This information is helpful. The motivation for asking (and you alluded to it) was for me to find ways to automate all data entry as much as possible. Also, I realize that it's going to to take me some more hours going full-blast to figure out how ZC works in terms of linking graphic images with products, categories, sub-categories and to edit my chosen theme. I have been search the forum; but, searches get me to the thread but not necessarily the specific post that has the information searched on. But, I'm making great progress. Yes, the glass is half full.... not half empty....
Successfully imported 1961 products without any errors after I increased the char length of categories from 32 64. Working on the figuring our why most of the images are not displaying. I will look at some sample data to see how the meta files are formatted. I already meta title, keywords and descriptions....
Now I need tuh figyah out di udah ting dem now. (Going to figure out the other stuff now.....
Thanks again
AJ
-
Re: Attributes - EP4
Quote:
Originally Posted by
chadderuski
My bad, I did forget to update the changelog.txt file ... I will try to get some basic testing done today.-chadd
Thanks for the EP plugin, thanks for the hard work, thanks for the testing, and thanks for the replies!!!
FYI, works great on the 1.5.1 and 1.5.3 (test and soon to be live zencart installs). Tested import and export with custom extra fields (no attributes/options, no meta tags), and everything seems to be working A-OK on 3,500+ products!
-
Re: Attributes - EP4
Just a quick comment on two things:
Meta Data: Things have really changed over the last couple years in regards to metatags. Much of it has been deprecated to the point that adding keywords does little to no good. Google has specifically stated that they don't look at keywords anymore:
http://googlewebmastercentral.blogsp...?commentPage=2
http://searchenginewatch.com/article...-Secure-Search
http://selfstoragemagnet.com/tech/se...yahoo-or-bing/
http://www.708media.com/search_engin...-meta-tag-seo/
Images: EP4 does not upload images, it just updates the entry for the main image in your products database. You need to use an FTP program to upload your images. Now, without stepping on any toes, I suggest you upload a nice sized main image and then use one of the image processing plug-ins to create your Small and Medium images.
For additional images to work, you start with your main image as the base file name, and append _1, _2, _3, etc. to each additional images:
hb_3270.jpg
hb_3270_1.jpg
hb_3270_2.jpg
etc.
Upload those using ftp and Zencart will automatically show your additional images.
Remember, the image names NEED TO BE THE SAME! I also highly recommend that your images name have NO spaces. Yes, names with spaces will work, but
in the long run you'll be better off not having them. Plenty of programs out there to help you fix things like this.
Hope that helps.
-chadd
-
Re: Attributes - EP4
Hi Chadd. As always, it does help. I had uploaded the images before uploading the product files with the link. But most of the images are not showing. Apparently there are some image size settings in Cat>Image that I had to set to match the image sizes of the images that I had previously uploaded. In fact I was researching image batch processing software before I stopped to read your post.
Well then, I am going to see what ZC plugin options are available to me that can be used to batch re-size and rename files using the original file name with an appendage of my choice. "_MED, _LRG or _1, _2, _3", etc.
AJ
-
Re: Attributes - EP4
Oops. I forgot something. Yesterday I did my first product upload. I used the FULL-EP template. At first 287 product records failed to upload due to category names that were too long. I fixed that. As I mentioned in the previous post, most images are not showing. I know that's a size issue and a few images are in fact misnamed and some are missing. But I also noticed that although I have set product descriptions and product names to display, they are in fact missing. How can I re-upload the records to delete the existing records and repopulate the catalog? And what might cause product names and descriptions to not display?
-
Re: EasyPopulate 4.0 Support Thread
Is there a way to manually un-install ep4?
I removed the files installed, but is there more to it? MySQL, other configuration files modified during the install?
I get a blank page when I click the ep4 link in the admin panel. I know the file is there, I edited it with an echo just to prove it.
I copied the latest ep4 files into the correct locations.
I tried editing the easypopulate_4.php to run the remove (removed if statement) no difference.
php 5.4.30
MySQL 5.5.37-cll
zen cart 1.5.3
php 5/4/30
easypopulate_4.php, v4.0.23 07-13-2014 mc12345678
stopped working after zen cart automatic upgrade.
Thanks
Nick
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
nick02895
Is there a way to manually un-install ep4?
I removed the files installed, but is there more to it? MySQL, other configuration files modified during the install?
I get a blank page when I click the ep4 link in the admin panel. I know the file is there, I edited it with an echo just to prove it.
I copied the latest ep4 files into the correct locations.
I tried editing the easypopulate_4.php to run the remove (removed if statement) no difference.
php 5.4.30
MySQL 5.5.37-cll
zen cart 1.5.3
php 5/4/30
easypopulate_4.php, v4.0.23 07-13-2014 mc12345678
stopped working after zen cart automatic upgrade.
Thanks
Nick
Blank page means an error log was more than likely generated. Check your logs folder (ZC 1.5.1 and above) or your cache folder (1.5.0 and below).
The uninstall will still keep the tools/EasyPopulate V4 menu option, so would need to uninstall that through some SqL that would have to look up. From what version did you upgrade and to what version?
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
nick02895
Is there a way to manually un-install ep4?
php 5.4.30
MySQL 5.5.37-cll
zen cart 1.5.3
php 5/4/30
easypopulate_4.php, v4.0.23 07-13-2014 mc12345678
stopped working after zen cart automatic upgrade.
Hi Nick,
What happened was your were upgraded to a zencart version that wasn't compatible with your version of EP4. mc12345678 has updated the mysql to mysqli functions.
Normally, to uninstall EP4, you would go to Tools->EasyPopulate 4 and click "uninstall" on the right side. This uninstalled the Configuration menu entry and customization settings. You will still have a EasyPopulate 4 entry under Tools. You would then need to delete all EP4 files from the server.
If you still had an entry under Tools after deleting all files, I think you still missed one somewhere. Be sure to check all sub folders (comparing to the original file folder structure of the downloaded version).
If you download and install the latest version of EP4, it should fix things.
-
Re: Attributes - EP4
Quote:
Originally Posted by
FoodSourceDirect
Oops. I forgot something. Yesterday I did my first product upload. I used the FULL-EP template. At first 287 product records failed to upload due to category names that were too long. I fixed that. As I mentioned in the previous post, most images are not showing. I know that's a size issue and a few images are in fact misnamed and some are missing. But I also noticed that although I have set product descriptions and product names to display, they are in fact missing. How can I re-upload the records to delete the existing records and repopulate the catalog? And what might cause product names and descriptions to not display?
Status of 9 will delete the item with that model #. So that would delete the product.
Sort of an aside, I've seen several people recently extend the length of their category name. I'm just curious about what kind of category needs more than 32 characters. Somewhat rhetorical.
As for images, yeah I would go with IH4 (Image handler4). It will accept a file (suggested to use the largest sized photo) then recreate the image in the sizes desired (provided the desired size is not larger than the current size of the new image) for small, medium, and large. Sure, if you have a specifically desired image for one of the other sizes, then you can upload that image to the desired size designation. There's a lot of features/options associated with it and they are described in the user manual. There are some obscure connections between options, but they're there.
The lack of display, does the same issue occur even when you use the classic template? There is at least one template that I know of that doesn't display certain information without applying a fix first. Otherwise, I have seen that if the database isn't utf-8, that could cause such an issue by certain conditions.
-
Re: Attributes - EP4
Hi MC. I downloaded IH4 and read its documentation. I like all the features. Just a little timid about the whole core file change thing. The same reason why I haven't as yet installed Numinix.
Re: Missing data for V_Product_Name and V_Description_1. I noticed that column field headers are case sensitive. once I changed to lower case, problem solved. I downloaded picaflor-azul's Newport Eco them. I have to figure out how to fix a couple of layout issues. I feel like I am in school again.
AJ
-
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mc12345678
Blank page means an error log was more than likely generated. Check your logs folder (ZC 1.5.1 and above) or your cache folder (1.5.0 and below).
The uninstall will still keep the tools/EasyPopulate V4 menu option, so would need to uninstall that through some SqL that would have to look up. From what version did you upgrade and to what version?
Great, thanks.
The error in the log is
[25-Jul-2014 16:43:43 America/New_York] PHP Fatal error: Call to undefined function mb_internal_encoding() in (omitted path)easypopulate_4.php on line 143
The EP upgrade was from
$Id: easypopulate_4.php, v4.0.21 06-01-2012 chadderuski $
to
$Id: easypopulate_4.php, v4.0.23 07-13-2014 mc12345678 $
ep reports 4.0.24 7/15/2014?
Zen from 1.51-1.53, auto installed.
Like Chad mentions later in this thread my zen-cart was automatically upgraded, thus ep stopped working. I upgraded ep after reading the thread and still didn't work. I removed the files and tried uploading again.
FIXED IT!
Looking at backup easypopulate_4.php, I rem'd out both calls to mb_internal_encoding(). If I remember correctly I asked my host to change a setting on their server and they refused so I rem'd this as a work around.
Thanks for your help
Nick
-
Re: EasyPopulate 4.0 Support Thread
I have a question regarding this module and the modules listed on the right hand side in the main page. Is there a list somewhere of where to find these? I do need something for my google feed for "Google Product Category" if possible.
