EasyPopulate 4.0 Support Thread

milobloom:

Sure Thing

What I do is work on 1000's of products at a time...
I try my best to sort them by simular types and attributese
Copy 1 and use the admin side to copy all attributes to categories.

I will install Easy Populate 4 on the site tonight since there is no risk.

I am going NUTS because I cannot get my other easy populate to work. But if I can get the job done and have a way to do attributes then I am very excited to work on this mod to work with you.

Milo

Great! Just be sure to read all the notes! EP4 uses Comma delmited CSV files .... 1.2.5.4 uses TAB delimited TEXT, and categories are handled differently. Don't forget to backup your store or use on a testing database until your are familiar with this version.

schoolboy:

Paul... this is very interesting and exciting! Would you make this mod available in the free add-ons at some point? I know there would be a lot of interest in it.

Well Im using Autoit to create this script and it works just fine but I think that anyone using it will need to edit it for their own purposes.

Also I am automating Excel to convert the CSV. As chadderuski says Open office is a better program . Autoit doesnt have great librarys for Open office as yet. Saying that I only have 100 products in my store at the moment so its not a great test but it is faultless in importing products.

Guess there is two important points .This script wont be perfect for everyone and I wont post in this thread as it will cause thread drift .Happy to start another thread

Going to improve it today as i only done a days work on it and I'm by no means a programmer.

If you have a larger file to test with that would be great. Also Im only interested in working with EP4 , not he legacy EP.

Paul

I will be working Dedicated CRON support.

Just a heads up, but I cannot promise as to when I'll get to it! I have another programmer that's interested in working on this too, so may-hap this will arrive sooner than later!
This is actually one of the reasons I've broken the script's files up into import/export so that it would be easier to make a direct call on the script like I've seen
some cron job do. I've never written a cron job before, so this is new territory for me.

Feel free to express your ideas. PM me if you have code to offer.

-chadd

Hi, have zencart 1.5 installed and added EP4.0. Works fine however need to add in my extra fields I have planned for my new site so that they will be downloaded and uploaded via EP4.0. I had this working using the old EP (using info on thread 116061) however cannot get the old EP to work on zencart 1.5.

I have looked at the easypopulate_4_import.php and easypopulate_4_export to try and apply the same logic however the files are totaly different to the previous easy populate data. Presumably these would be the correct files to add in the extra field names.

Any assistance in the location to add extra code for the addition of my extra fields to enable ep4.0 to upload and download them automatically would be much appeciated. Even if its just which php files and line numbers.

Sorry if this does not make sence but have only just started with php code, websites and sql.

Many Thanks

dkwwkd:

Hi, have zencart 1.5 installed and added EP4.0. Works fine however need to add in my extra fields I have planned for my new site so that they will be downloaded and uploaded via EP4.0. I had this working using the old EP (using info on thread 116061) however cannot get the old EP to work on zencart 1.5.

I have looked at the easypopulate_4_import.php and easypopulate_4_export to try and apply the same logic however the files are totaly different to the previous easy populate data. Presumably these would be the correct files to add in the extra field names.

Any assistance in the location to add extra code for the addition of my extra fields to enable ep4.0 to upload and download them automatically would be much appeciated. Even if its just which php files and line numbers.

Sorry if this does not make sence but have only just started with php code, websites and sql.

Many Thanks

It's actually much easier than the old EP. What field names are you adding? And are they only in the products database?

Thanks for quick responce, I have about 8 or 9 that I am adding. Yes they are all in the products database - the same table as product weight etc. some of them are product_pack, product_author, etc

dkwwkd:

Thanks for quick responce, I have about 8 or 9 that I am adding. Yes they are all in the products database - the same table as product weight etc. some of them are product_pack, product_author, etc

The main work is in the includes/functions/extra_functions/easy_populate_4.php file

Go down to the function ep_4_set_filelayout() function. You are going to add layout entries to the "full" case.

Look a the entries for:

	if ($ep_supported_mods['upc'] == true) { // UPC Mod
		$filelayout[] = 'v_products_upc'; 
	}

And a little further down:

            $filelayout_sql = 'SELECT ....
	if ($ep_supported_mods['upc'] == true) { // UPC Code mod
		$filelayout_sql .=  'p.products_upc as v_products_upc,'; 
	}

Basically you are going to create your own mod, and add your file layout and sql statements here.

You will need to define your mod in the easypopulate_4.php file, and then there are a number of additional edits to the easypopulate_4_import.php file.

If this is beyond your php knowledge, PM me a list of the field names as they appear in your products table and their field types. Verify them with phpMyAdmin.

But you should be able to puzzle it out easily enough... $ep_supported_mods[] is how I switch on entries for these mods. So they are found pretty easily.

-chadd

**** BUG REPORT **** as of 4.0.17

OKAY, if you are using a multi-byte language (say, greek), the categories will NOT import correctly!

I'm working on a solution, and this has highest priority right now.

Sorry for the inconvenience! I haven't had many people from "way yonder" to help beta test other languages.

-chadd

U have used an easypop4 template that I downloaded from my zen admin.

I modified it and added more products

After adding more products I saved and uploaded back to the site

the site said upload successful, but it did not add any new items or update the one that existed.

any Idea as to how I can get this to work and start loading my items?

ediscs:

U have used an easypop4 template that I downloaded from my zen admin.

I modified it and added more products

After adding more products I saved and uploaded back to the site

the site said upload successful, but it did not add any new items or update the one that existed.

any Idea as to how I can get this to work and start loading my items?

Hi ediscs,

1. Which version of EP4 do you have?
2. Can you attach a sample of your data with headers intact?
3. Did you use OpenOffice to create your CSV file using the instructions at the start of this thread.
   You need to use a comma delimited file. Some people have been trying to use data from ep 1.2.5.4
   which is NOT directly compatible.
4. Are you sure setup your categories correctly?
5. Did you receive any errors or warnings?

Thanks!

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_weight v_product_is_call v_products_sort_order v_products_quantity_order_min v_products_quantity_order_units v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_tax_class_title v_status v_metatags_products_name_status v_metatags_title_status v_metatags_model_status v_metatags_price_status v_metatags_title_tagline_status v_metatags_title_1 v_metatags_keywords_1 v_metatags_description_1

Downloaded EP4 from the link at the begining of this thread.
Downloaded spreadsheet from the EP setting in my admin after creating one item to use as a template.
I am sure it is setup correctly, even have an uninstall in the upper right of the admin easypop tab
No errors or warnings at all just Green highlight that says File uploaded successfully: Full-EP2012Jan11-161557.csv

Ediscs,

That is just the headers. Can you attach the Full-EP2012Jan11-161557.csv file?

chadderuski:

Hi ediscs,

1. Which version of EP4 do you have?
2. Can you attach a sample of your data with headers intact?
3. Did you use OpenOffice to create your CSV file using the instructions at the start of this thread.
   You need to use a comma delimited file. Some people have been trying to use data from ep 1.2.5.4
   which is NOT directly compatible.
4. Are you sure setup your categories correctly?
5. Did you receive any errors or warnings?

Thanks!

csv attached as zip

Ediscs,

Curious.... Did you upload the file and THEN click the Import Link? I was able to import your data fine on my end.

-Chadd

That is what I was missing, I knew I had to be over looking something. thanks.

Just a question is there anyway to track qty on variations so that when a certain amount of them are gone the variation disappears?

ediscs:

That is what I was missing, I knew I had to be over looking something. thanks.

Just a question is there anyway to track qty on variations so that when a certain amount of them are gone the variation disappears?

That would be a question for the general forum. It is possible to setup your store so that when a product reached zero quantity, that it is mark sold out, among other settings. You would also need to explain what you mean by "variations" (which sounds like attributes to me).

chadderuski,
What I meant was I know that there is a way to do it in Zen, there is a sport yo just qty on your variations. I was wondering if there was some variable heading such as v_product_variation_qty that could be added to achieve the same results without going and doing everything manually which takes forever.

Sweet work Chad. I know you have been working for a long time on this. Just installed and updated some prices. Works great so far.

mydanilo:

Sweet work Chad. I know you have been working for a long time on this. Just installed and updated some prices. Works great so far.

Thanks! I have another update coming very shortly. I had to fix the multilingual stuff to handle mult-byte languages for the new UTF8 support in zencart 1.5.

ediscs:

chadderuski,
What I meant was I know that there is a way to do it in Zen, there is a sport yo just qty on your variations. I was wondering if there was some variable heading such as v_product_variation_qty that could be added to achieve the same results without going and doing everything manually which takes forever.

It may be possible, but I will have to know more about this "variations" thing. If you could point me to the exact area where you add or edit this.
Also, is it part of a mod you installed and not the default installation?

Thanks!