EasyPopulate 4.0 Support Thread

Wtashby,

Don't know where in the process of suggestions thathavebeen made. If the "original" site is still available, is EP4 the only option on your admin panel that is not accessible at this point? Information in your admin's catalog is the same as on the store's side? (Ie, the configure.php files effectively match the same directories and database? This may become more evident when the above install suggested by chadderuski is performed and the files reviewed. (These could be different than expected if it was thought thaat they were saved but the write permissions were not changed to allow writing before trying to save.)

I realize that there seems to be a problem, but there have been several that have installed this to 1.5.3 and having equivalent settings thathavent had the same problem.the thingis to find the cause and perhaps incorporate some sort of solution up front to more clearly explain what is going on and possibly a solution.

Can I export a google merchant feed with this mod too? What would I have to do?

I actually want the merchant feed in tab delimited as I want to use it for Amazon product ads upload. Can this be done?

mydanilo:

Can I export a google merchant feed with this mod too? What would I have to do?

I actually want the merchant feed in tab delimited as I want to use it for Amazon product ads upload. Can this be done?

For export only, there are three files you will need to modify: admin/easypopulate_4.php, admin/easypopulate_4_export.php, and admin/includes/functions/extra_functions/easypopulate_4_functions.php

The first file will need a menu option and an $ep_dltype name added, related data will need to be captured in the other two files, then in the functions file need to modify the function that includes set_filetype to identify the fields that will be desired to be exported as well as a sql function to kick off the creation of the information. Then the export file will do the processing of the data returned from the filetype function, so if wanting to get all products, will want that sql to effectively return at least all of the products to be processed. The full function does that as an example. If you want to change the delimiter from comma to tab there is a place to do that I think in the export function.

That's a rough discussion of how easy chadderuski has made this.

Well thank you but I think that might be over my head. I was hoping that it was a pretty simple config or that somebody already use this to create a google merchant feed and would be willing to share?

mydanilo:

Well thank you but I think that might be over my head. I was hoping that it was a pretty simple config or that somebody already use this to create a google merchant feed and would be willing to share?

Ahh, gotcha. Well I was just about to see what the expected output would be and maybe incorporate it into this version. But if someone alreadyhas/knows, then great.

mc12345678:

Ahh, gotcha. Well I was just about to see what the expected output would be and maybe incorporate it into this version. But if someone alreadyhas/knows, then great.

Well, I guess if anything, the research to know what is expected/required seems to be a sticking point at the moment. I somewhat thought that I might be able to pull from another's code, but haven't found such an example yet really not one that will provide a quick (next hour or so) solution. But looks like it is possible, just need to know what data and header is expected.

Maybe I can help there. The Amazon Product Ads Upload File template might help to identify what is needed. I've put it my drop box for you to look at:
https://db.tt/7At3BkNV

Or the Google Merchant Center Feeder, or Amazon Inventory Loader from Numinix could shed some light to what is needed.

It just would be great to have the ability to generate a usable feed from this mod.

Looking a bit further into what the sample feed looks like, it should not be too difficult to just hand match the headers up with what I get from the regular full export of my product listing. I shall give it a shot and post my findings.

Matching up header is not too difficult but I've discovered that I don't have the products URL in my exported file. I need this for the Amazon feed. Any suggestion how this could be added to the exported file?

mydanilo:

Matching up header is not too difficult but I've discovered that I don't have the products URL in my exported file. I need this for the Amazon feed. Any suggestion how this could be added to the exported file?

Are you using standard ZC URIs? Regardless would want an additional $row[] to receive the uri, then some point after most/all of the data has been collected, within the while loop for the row data, construct a standard uri, say possibly with the zen_href_link function.

Few functions to help build the uri:
Zen_get_info_page($prodID) returns the portion of: main_page=
Zen_get_product_path($prodID) to get the cPath as cat1_cat2_cat3.
And then would concatenate the products_id= with $prodID
I think though the cat number is already a part of the data, the info_page can be obtained through the above function and the $page that is applicable for the zen_href_function is FILENAME_DEFAULT.

So uri:

$new_uri = HTTP_SERVER . DIR_WS_CATALOG . zen_href_link(FILENAME_DEFAULT, 'main_page='. zen_get_info_page($prodID) .'&cPath='. zen_get_product_path($prodID)  .'&products_id='.$prodID,,false);

The false is to prevent adding the session_id onto the uri.

I use Ceon URI Mapping module, do you think that will work? Where would I have to put the above code please?

All I really need is the URI added to the export file. The rest I can map myself manually with the Amazon template.

mydanilo:

I use Ceon URI Mapping module, do you think that will work? Where would I have to put the above code please?

All I really need is the URI added to the export file. The rest I can map myself manually with the Amazon template.

I have a version of EP4 that does that on my website, but if you look in the export file in your admin folder, in the section that checks if the ep_dltype is full, I would put it somewhere after the product id is assigned. The variable names may be different, and I think you'd have to assign a new filelayout item to end up with the data exported to the file. I'm working from memory at the moment, so I may have missed something, but that's the jest of it.

As far as CEON URIs, those going to the uri generated from the above code will end up seeing the CEON URI equivalent, but I do not know the effect of say "rankings" of providing the ZC standard uri for uris that are rewritten to a more human understandable version.

Was thinking about it some more, you could also use a similar set of data to query the ceon_mappings database for the uri of the product(s) as they currently are and with the same site information prepended to the database result submit that uri. Code would still be in the same location, just would have a database query to accompany it.

Hello,
Can someone please help me or point to the correct post where i can find the solution here? (someone suggested I post this here for help instead of the Dual Pricing thread)

I'm trying to add wholesale pricing to my Easy Populate spreadsheet.

I added the below line to the admin\includes\languages\english.php file as instructed but no luck >>>
define('EASYPOPULATE_CONFIG_CUSTOM_FIELDS', 'products_price_w'); //Easy Populate

Does anyone have any solutions for this? I am unable to update my wholesale products and I have more than 5000+ items.

I am having the same issue on a client's website that is 1.5.3.

PHP Version: 5.4.30, used the latest files at https://github.com/chaddro/EasyPopulate-4.0

Mod worked the day I installed it and generated a file. Yesterday it stopped working and gave the error below.

I checked easypopulate_4 in developers tool kit - got 188 match lines in 10 files.

Any help would be appreciated! THANKS SO MUCH!

wtashby:

I have read through this entire thread looking for a different answer than the missing $ update, but even after uploading and installing the latest version, and even copying and pasting the code from GitHub, I am still getting EP4 FATAL ERROR: No default language set, even though just a few days ago, Easypopulate 4 was working perfectly on my site. Has anyone come up with any different reasons for this, and/or fixes?

stellarweb:

I am having the same issue on a client's website that is 1.5.3.

PHP Version: 5.4.30, used the latest files at https://github.com/chaddro/EasyPopulate-4.0

Mod worked the day I installed it and generated a file. Yesterday it stopped working and gave the error below.

I checked easypopulate_4 in developers tool kit - got 188 match lines in 10 files.

Any help would be appreciated! THANKS SO MUCH!

In the file YOUR_ADMIN/easypopulate_4.php at line 177 that reads:

exit("EP4 FATAL ERROR: No default language set."); // this should never happen

Change to read:

exit("EP4 FATAL ERROR: No default language set. Table: ".TABLE_LANGUAGES." Code: ".DEFAULT_LANGUAGE." is set" ); // this should never happen

And please repost the resulting error message.

nesum18:

Hello,
Can someone please help me or point to the correct post where i can find the solution here? (someone suggested I post this here for help instead of the Dual Pricing thread)

I'm trying to add wholesale pricing to my Easy Populate spreadsheet.

I added the below line to the admin\includes\languages\english.php file as instructed but no luck >>>
define('EASYPOPULATE_CONFIG_CUSTOM_FIELDS', 'products_price_w'); //Easy Populate

Does anyone have any solutions for this? I am unable to update my wholesale products and I have more than 5000+ items.

If you are trying to export an additional field that is located in your products table and you are using EasyPopulate ver 4, that is not the way to do it. If you look in the admin panel, configuration, Easy Populate 4. There is a custom field text box. In that text box, enter the field name which appears to be products_price_w. Then on export/import that field will populatein both directions. If you need more than one field added, then separate the field(s) with a comma.

Hi guys

I have easypopulate working very well for imports and exports but want to import 3 values. My websites serves downloads of PDF ebooksso these are needed .

So the values I want to import are
products_attributes_filenames Sample Data would be \Books\Harrypotter.pdf
products_attributes_maxcount
products_attributes_maxdays

They are all stored in the table products_attributes_download

Is it possible to access these values with an import in Easy populate ?

Thanks Paul

Hasher:

Hi guys

I have easypopulate working very well for imports and exports but want to import 3 values. My websites serves downloads of PDF ebooksso these are needed .

So the values I want to import are
products_attributes_filenames Sample Data would be \Books\Harrypotter.pdf
products_attributes_maxcount
products_attributes_maxdays

They are all stored in the table products_attributes_download

Is it possible to access these values with an import in Easy populate ?

Thanks Paul

Yes this is possible through the existing coding of EP4. Do an export of the basic products attributes and the detailed products attributes to see how they canbe worked together to add/modify attributes associated with your product(s). The specific data that you are looking to use/modify would be in the detailed version. But first the product(s) would need to be built up to have/know that there is such an attribute to be considered.