EasyPopulate 4.0 Support Thread

chadderuski:

It's easy to do and has been discussed earlier in this thread. The length check is very important to the import so that's why I added it.

-chadd

yeah so that pretty much didn't work. Found categories_name in the sql database. Increased it to 128 but it still won't access the naming convention. I also tried the ^. It created a whole different directory with ^ between the different words... Any ideas?

mrmanners:

yeah so that pretty much didn't work. Found categories_name in the sql database. Increased it to 128 but it still won't access the naming convention. I also tried the ^. It created a whole different directory with ^ between the different words... Any ideas?

I replied to your PM... I really think you are using 1.2.5.4!

BTW: You ARE using Dr. Bytes MySQL Database Backup Tool? You should ALWAYS run a backup before working with EP4!

EP4 like most tools will do just what you tell it... it you give EP4 bad data (you made a mistake in your spreadsheet) EP4 will happily take that data and import it to your databases.

I've added some necessary data checking in some places that were vital like category names, etc.

I have many successful users with very large data sets using EP4... one user has over 900,000 records! On his dedicated server he can import about 50,000 in (if I remember right) about 12 seconds!

Hope this encourages you to keep working to learn EP4... BTW, if you didn't get your version from my github account I can't vouch for the code.

-chadd

https://github.com/chaddro/EasyPopulate-4.0

chadderuski:

If this mod only adds fields to the products table, then you should be able to use the User Defined Products Fields to add these to your import sheet. After installing the MAP mod, look at the products table or sql you used to modify the table for the field names. Then add these under the Configuration > EasyPopluate 4 :: User Defined Products Fields.

Separate the fields with a comma, but do not add spaces, for example: field1,field2,field3
Do not add quotes either.

Your sheet will then export with columns for these fields as: v_field1, v_field2, v_field3

Let me know how that works for you!
-chadd

Thanks this worked!
For those who need the MAP mod integrated, the categories you need to add in the user defined box are: map_enabled,map_price

Hi Chad...

Firstly what a great extension EP is, I had got it set up on a server whilst i was testing out things and it was all working great.

I've now had to move over to a hosting package with siteground and have managed to install zen cart again no problem and was going to start again from scratch with everything.

When I re-installed EP (using your latest github version) for some reason I can't seem to get it to work correctly. I can see it at the bottom of the tools menu but everytime i try and do something in EP it takes me back to the admin login panel for some reason.

I know this has been documented before but i didn't even use the install sql feature to install it via the admin panel and can't see any rouge // in any of the configure.php files.

Is there anything else I can check here because it's driving me crazy as i've already tried a few things but to no avail, currently i've re-installed zen cart from scratch again and done the same for EP but it still doesn't work.

Currently with the hosting i've not transferred my domain name across yet so i'm having to access the site by ip address and noticed that in the url for that there is a ~ character which i was wondering if that had anything to do with the problem perhaps.

Unless there's a few more php files i can check for bad // ?

Any help would be greatly welcomed...

Thanks.
Matt

zan_dude:

Hi Chad...

Firstly what a great extension EP is, I had got it set up on a server whilst i was testing out things and it was all working great.

I've now had to move over to a hosting package with siteground and have managed to install zen cart again no problem and was going to start again from scratch with everything.

When I re-installed EP (using your latest github version) for some reason I can't seem to get it to work correctly. I can see it at the bottom of the tools menu but everytime i try and do something in EP it takes me back to the admin login panel for some reason.

I know this has been documented before but i didn't even use the install sql feature to install it via the admin panel and can't see any rouge // in any of the configure.php files.

Is there anything else I can check here because it's driving me crazy as i've already tried a few things but to no avail, currently i've re-installed zen cart from scratch again and done the same for EP but it still doesn't work.

Currently with the hosting i've not transferred my domain name across yet so i'm having to access the site by ip address and noticed that in the url for that there is a ~ character which i was wondering if that had anything to do with the problem perhaps.

Unless there's a few more php files i can check for bad // ?

Any help would be greatly welcomed...

Thanks.
Matt

Hi Matt,

Did you install zencart using a cpanel auto-installer? If so, then you likely have some "fudging" going on in your configure.php files. You will need to check these to be sure the are correct. A common issue I've seen are extra // (double wacks) where there should only be one. This will break EP though not zencart for some reason.

I haven't tested zencart on a site using the ~ tilda, so you are in uncharted grounds there. No problem using just an IP though.

-chadd

chadderuski:

Hi Matt,

Did you install zencart using a cpanel auto-installer? If so, then you likely have some "fudging" going on in your configure.php files. You will need to check these to be sure the are correct. A common issue I've seen are extra // (double wacks) where there should only be one. This will break EP though not zencart for some reason.

I haven't tested zencart on a site using the ~ tilda, so you are in uncharted grounds there. No problem using just an IP though.

-chadd

Hi,

I did the install by just copying the files into the right places with FileZilla and then going to tools > easypopulate4 at the bottom of the list and then having to press on install easypopulate by clicking at the top of the screen within the easy populate menu/module.

I'm just wondering if it could be the ~ character within the URL ? Is there any way I can verify this somehow. Unless there are more .php files to take a look inside with path errors?

In the configure.php insi admin includes I did notice the admin directory isn't specified like the other paths, it doesn't contain any // but it doesn't show a true path to the directory like the other dirs are.

Thanks,
Matt

Hello,
I have downloaded EasyPopulate CSV for ZenCart 1.5
I get an error when I run the SQL script - WARNING: An Error occurred, please refresh the page and try again.
Easy Populate doesn't show in the menu.
I have followed all the steps, and can somewhat access EasyPopulate by entering localhost/zencart/admin/easypopulate.php
The bottom of my screen has a bunch of code (I've pasted the image below).
When I do download the csv, it's blank - only headers.
I would appreciate any help!!
Thanks,
Amber

chrysalid:

Hello,
I have downloaded EasyPopulate CSV for ZenCart 1.5
I get an error when I run the SQL script - WARNING: An Error occurred, please refresh the page and try again.
Easy Populate doesn't show in the menu.
I have followed all the steps, and can somewhat access EasyPopulate by entering localhost/zencart/admin/easypopulate.php
The bottom of my screen has a bunch of code (I've pasted the image below).
When I do download the csv, it's blank - only headers.
I would appreciate any help!!
Thanks,
Amber

Hi Amber,

I'm sorry, this is not my version and I can't help you with it. But you could uninstall that one and install my version from here:

https://github.com/chaddro/EasyPopulate-4.0

-chadd

Just uplaoded 4.0 to transfer product info from one zencart store to another. The store with the info was 1.39 version and the new store is 1.5. I was able to transfer the info except the catagory description was not there or the catagory image........any thoughts?
I am able to manualy upload the description via the zencart admin but I still cannot get the catagory image to show up. The product image is showing just not the catagory image and in most cases it is the same image as the product.......any help?

Also by uploading it via easy populate can I still use all the editing options the zencart admin has?.........adding the catagory image doesn't seem to work.

Having a "Cosmetic" issue with EP

Before today it was fine and dandy no issues the files showed up nice and in the decorative box.

However today I get what you see in the attached image.

Nothing has been added (as far as other plugins etc)

All files are in tempEP as they should be.

Any Ideas?

OK just deleted and reinstalled using the Easy Populate For ZenCart v1.5
Now it looks all pretty again.

racinjason:

Just uplaoded 4.0 to transfer product info from one zencart store to another. The store with the info was 1.39 version and the new store is 1.5. I was able to transfer the info except the catagory description was not there or the catagory image........any thoughts?
I am able to manualy upload the description via the zencart admin but I still cannot get the catagory image to show up. The product image is showing just not the catagory image and in most cases it is the same image as the product.......any help?

Also by uploading it via easy populate can I still use all the editing options the zencart admin has?.........adding the catagory image doesn't seem to work.

You are editing the category from within the Admin, and unable to set the category image? Make sure you have the correct path set when editing. This is probably what your are doing wrong. Remeber that /images is assumed as the Main Directory from the drop box.

There IS a way to use EP4 to set category images and descriptions on import, but I HIGHLY RECOMMEND THAT YOU BACKUP YOUR STORE before playing with this. It is a one-to-one update based on the category ID.

Under Category Export/Import Options select >> Categories Only (with Metatags)

Export for each store. Note that your category ID's will NOT be the same between the two stores, so you will have to copy/paste from one sheet to the other. If all your category names are unique, it may be easy.

TEST with just a couple categories until you know what you are doing.

Hope this helps!

I even manualy add the catagory pics via zencart admin and they don't show up, although the image is listed in the edit catagory page.
I also noticed I didn't want the quantity of products to show to the public and manual change it in zencart admin, it warns me that the option has been chosen yet they still show up in the store...............whay is the zencart admin not working?......does EP4 override it?

chadderuski:

You are editing the category from within the Admin, and unable to set the category image? Make sure you have the correct path set when editing. This is probably what your are doing wrong. Remeber that /images is assumed as the Main Directory from the drop box.

There IS a way to use EP4 to set category images and descriptions on import, but I HIGHLY RECOMMEND THAT YOU BACKUP YOUR STORE before playing with this. It is a one-to-one update based on the category ID.

Under Category Export/Import Options select >> Categories Only (with Metatags)

Export for each store. Note that your category ID's will NOT be the same between the two stores, so you will have to copy/paste from one sheet to the other. If all your category names are unique, it may be easy.

TEST with just a couple categories until you know what you are doing.

Hope this helps!

racinjason:

I even manualy add the catagory pics via zencart admin and they don't show up, although the image is listed in the edit catagory page.
I also noticed I didn't want the quantity of products to show to the public and manual change it in zencart admin, it warns me that the option has been chosen yet they still show up in the store...............whay is the zencart admin not working?......does EP4 override it?

No, EP4 doesn't over-ride these things in zencart. You should post this question in the bugs area or upgrading forum. Definitely odd.

I am running EP 4 on zencart 1.5
I have been having strange things happening since I added the products with it. I down loaded the info from my other site and the info is showing correctly on the admin. But during check-out the weight of the items are different and it is showing the quantity of items even though the admin warns that I have it not showing. I downloaded the CSV file to look at it and noticed the description column width is way too small and the data was overlapping the other columns?...........could this be a problem?
I tried making the descp. column wider but it will only go to 100cm with Open office......................what are other people doing who's descptions are longer?

I figured out the open office width problem but it didn't fix the issue. The shipping estimater shows the item weights 2lbs at the top of the box but the the calculation it show 1 x 5lbs and is chargeing more for shipping. The quantity is till showing to the public too.

For anyone with the same problems I figured out the weight issues....got to admin>config>shipping> set the tare weight to 0:0.
Anyone help with the quantity showing and the catagory pics not showing up?

Another update.........I got the product quanity to stop appearing.
The show prduct quantity option in the product listing area had no effect but if you go to Admin, Catalog, Product Type, Product - General and edit layout. Turn off quantity in stock and model. That should do it for you.
Hope this is helping people.........sorry for the posts in a row.

Hey Chadd - Im looking to start up on the auto populate (GET xml or CSV > populate) functionality for EP4. Where did you leave off on that?

ZC1.5

Can't get v_categories_name_2 to show up on my site using this add-on.
I used a Tab Delimited spreadsheet as a template.
Added 1 product.
Cat 1 is Apparel, Cat 2 is hoodies
Saved as a Comma Delimited Text CSV (Open Office)
Uploaded the file
Inserted the file

The product shows up under the main category but the new sub0cat (hoodies) does nor show up in the Categories Menu.
seriousoffroadproducts . com
Mouse over the "Apparel" heading in the categories menu and you'll see the Teeshirt sub-cat.
Click on the "Apparel" heading in the categories menu and the hoodie pops up.

Thought I had this figured out....but apparently not.

Anyone?