EasyPopulate 4.0 Support Thread

[sw1138lr]

Chadd,

I'm attempting to upload my Google Product Categories into the attributes. The field v_products_options_values_name_1 has a value of
"Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures". After I imported the file it creates two attributes due to the comma.
The first one is "Toys & Games > Toys > Dolls" and the second one is "Playsets & Toy Figures > Action Figures". These are not even valid "Option Values" that I created. The valid one is "Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures".

How can I overcome this problem?

Kevin

[chadderuski]

Chadd,

I'm attempting to upload my Google Product Categories into the attributes. The field v_products_options_values_name_1 has a value of
"Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures". After I imported the file it creates two attributes due to the comma.
The first one is "Toys & Games > Toys > Dolls" and the second one is "Playsets & Toy Figures > Action Figures". These are not even valid "Option Values" that I created. The valid one is "Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures".

How can I overcome this problem?

Kevin

Hi Kevin,
May I ask why you are using attributes (I assume a read-only one) for GPC? The default length of products_options_values_name is way to short to support this, and even your example will get cut off if created through the admin.

What I did was create a field in my products table called products_gpc. Now you have a new column in your Full import sheet v_products_gpc which is supported in EP4. Then I did a quick tweak to Numinix's Google Merchant Feeder to submit this column with my data.

To continue along your path would require using a different delimiter in the core code.

-chadd

[sw1138lr]

Chadd,

When we installed Numinix's "Google Merchant Center Feeder Configuration" version 1.13.0 it did not create a column products_gpc. In the Numinix's instructions it indicates to create the "Google Product Categories" as attributes.

So can I just add the new field manually? If so, how would I get the new field to show up on the products page in the ADMIN?

Thanks,
Kevin

[dstegall]

Please excuse my ignorance...

From what I see, Easy Populate creates a .txt file. I need a .csv file. Is this possible? Thank you!

[Shroomjunkie]

Never mind problem fixed ...

For those of you who come across this issue the issue is caused by having the "Admin Profiles" mod installed.

To fix the issue go into Tools --> Admin Settings - Edit Permissions

Scroll down to the bottom to where it says:

Third Party Mods (when enabled these 3rd party contributions will appear in the Admin menus determined by their authors)

Then put a tick in the box that says "easypopulate 4" and click the Save Changes button.

EasyPopulate 4.0 should then be shown under your Tools menu.

Chad you might consider adding this information to your install file so that others who are using the "Admin Profiles" mod don't forget to edit their profiles accordingly.

BTW for those of you who are interested. I found out what the issue was by directly accessing the link to EP4 from within my admin panel.

Hi CybaGirl and Chadderuski

I have read all 44 pages of this forum and can still find no solution for my problem. I have sat here for nearly 48 hours straight and have created the same databse/new zen installation and EP mod 10 times. I followed every instruction to the tee. I installed fresh Zen 5. Changed the admin folder to "apurplelisting" deleted the zc_install folder. New site and admin and database working fine. Then I follow your steps again to the tee. Downloaded EP 4. Renamed the ADMIN folder to "apurplelisting" using Filezilla uploaded the 2 folders into "businesslisting" which is a subdomain. So my filezilla route is : public_html/businesslisting/apurplelisting
Login on the admin and no drop down for EP is there in either tools or configuration. ????????????????

This has made me try again and again and agaiin and again and again and again and again and again (you get the point) LOL and there is no answer on this forum expect that whoever experienced the problem managed to get it sorted. Trust me this is no user error. Your post above and the post just before it CybaGirl is exactly the problem I have. BUT wait for it... Your solution is not helping...

In Zen 5 fresh install admin there is a new categories called "Admin Access Management" and there is nowhere in any of the 4 drop down menu's that you as you suggested above "To fix the issue go into Tools --> Admin Settings - Edit Permissions " nor is there any admin settings on under tools as it used to be in Zen 1.3.9. So if this was the case in your situation and I can't access "admin settings", then where can I "edit permissions" to fix this problem ? I even tried the "langer="
method after uploading files and it actually works but before it does it comes up with this error


Easy Populate Configuration Missing. Please install your configuration by clicking here
Warning Easy Populate uploads folder not found!
NIX SERVERS: Your uploads folder is either missing, or you have altered the name and/or directory of your uploads folder without configuring this in Easy Populate.
WINDOWS SERVERS: Please request your web host to assign write permissions to the uploads folder. This is usually granted through Windows server user account IUSR_COMPUTERNAME.
Your configuration indicates that your uploads folder is named EASYPOPULATE_CONFIG_TEMP_DIR/, and is located in /home/purple/public_html/businesslisting/, however this cannot be found.
Easy Populate cannot upload files until you have provided an uploads folder with read/write/execute permissions for the site owner (usually chmod 700 but you may require chmod 777)"

My server runs on Linux and I have full permission to change all permissions. Which I did. But then when you refresh the admin it still does not show and EP in any dropdown menu's.

Please somehelp me as I am prepared to sit here for another 48hrs but after that if the problem has not been resolved, I am going to my garden shed, get my chainsaw and do some really crazy things to my PC. :-)

[sw1138lr]

Chadd,

I went into my phpMyAdmin to view the length of the Options Value. products_options_values_name is varchar(150). So it is long enough to hold "Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures".

The problem is EasyPopulate is creating two "products_attributes" out of the value from my spreadsheet. This is due to the comma "," in the value in the column from the spreadsheet v_products_options_values_name_1. It takes the first part before the comma and added that as an attribute to my product then it took what was after the comma and added that as a second attribute.

Can I change EasyPopulate to see this as one continuous field regardless of the comma?

thanks,
Kevin

[dairymom]

I just got EP4.0 working this afternoon. I have ZC1.5.

Can someone set me in the right direction? I am trying to add options. Even the sample file doesn't seem to work. So here is what I know. Let me know what you need to know to help me.

I added columns for the three different items v_products_options_type v_products_options_name_1 v_products_options_values_name_1

Uploaded the csv. Took some time but figured it out.
Products are there but they have no options.
Added the suggested columns.
Still no options. No colors in my shirts.

Does it matter which order in the file? I just added at end.

What do I need to know to proceed.

[SPH]

I just got EP4.0 working this afternoon. I have ZC1.5.

Can someone set me in the right direction? I am trying to add options. Even the sample file doesn't seem to work. So here is what I know. Let me know what you need to know to help me.

I added columns for the three different items v_products_options_type v_products_options_name_1 v_products_options_values_name_1

Uploaded the csv. Took some time but figured it out.
Products are there but they have no options.
Added the suggested columns.
Still no options. No colors in my shirts.

Does it matter which order in the file? I just added at end.

What do I need to know to proceed.

We have the Attrib_Basic (sheet has to be named that) working. Here are our columns, in rows for this post, with what we have below each:

v_products_model
Precious Formals P20550

v_products_options_type
0

v_products_options_name_1
Color

v_products_options_values_name_1
White,Red,Black

[dairymom]

We have the Attrib_Basic (sheet has to be named that) working. Here are our columns, in rows for this post, with what we have below each:

v_products_model
Precious Formals P20550

v_products_options_type
0

v_products_options_name_1
Color

v_products_options_values_name_1
White,Red,Black

Thank you for your reply. I am having such a hard time understanding all of ZC but I am determined. OK. Back to work.

I added the columns from the sample and the options given. They never showed up. When I downloaded the csv file to see how it was done. They had disappeared. I am sure I am missing something fundamental.

[kcb410]

Hello everyone,

I've installed EP4 and it seems to working well. Good work chadderuski !

Regarding importing attributes........Is anyone experimenting or having success importing attributes such as?:
v_options_values_price
v_price_prefix
v_products_options_sort_order
v_products_attributes_weight
v_products_attributes_weight_prefix

We have an attribute heavy site with some products having 10-12 option_names with each name having from 5 to 12 option_values some on which are 'priced by attributes'. We're preparing a spreadsheet with approx 500 new products and we're trying to find the best strategy to deal with their attributes.

Any comments are appreciated. Thank you