EasyPopulate 4.0 Support Thread

[FoodSourceDirect]

Here is the file info:


Added a new "test" product through the ZC Admin>Catalog. Exported the file using EP 4.0. I noticed that all the fields exported including the user defined / custom product fields but they were empty. Yet they are listed under Tools>Easy Populate 4.0.


I noticed that the information that I entered in one of the custom product fields of the test product that I created actually imported. (I entered the data into the custom product field using phpMyAdmin.)

Okay, so two things still, after adding some datato atleast one product through whatever means you have (say myphpadmin) try exporting the data, modifying what needs to be then importing it again.

In parallel with that, what is the filename that you have for your current import file? (Don't need the path, just the filenaame.)

[mc12345678]

Here is the file info:


Added a new "test" product through the ZC Admin>Catalog. Exported the file using EP 4.0. I noticed that all the fields exported including the user defined / custom product fields but they were empty. Yet they are listed under Tools>Easy Populate 4.0.


I noticed that the information that I entered in one of the custom product fields of the test product that I created actually imported. (I entered the data into the custom product field using phpMyAdmin.)

Been a while since I have looked through the various exceptions, but as provided that filename is not the format expected by EP4 to process the records into the database. Take note of the filename format of the exported file. When you said that one "imported" from what was entered in myphpadmin, did you mean that one exported? (From database to the csv file.)

[FoodSourceDirect]

Custom Product Field Names.zipYes. I typed information into the "product_information" custom product field from within phpMyAdmin. Then under Product & Pricing Export / Import Options, I chose Complete Products with Metatags to export my products. A look at the exported file revealed that the data that was typed using phpMyadmin was exported.


[FONT=Verdana, sans-serif]Product & Pricing Export/Import Options:
[/FONT]
Complete Products (with Metatags)

[FONT=Verdana, sans-serif]The attachment is very interesting.[/FONT]

[mc12345678]

Custom Product Field Names.zipYes. I typed information into the "product_information" custom product field from within phpMyAdmin. Then under Product & Pricing Export / Import Options, I chose Complete Products with Metatags to export my products. A look at the exported file revealed that the data that was typed using phpMyadmin was exported.


[FONT=Verdana, sans-serif]Product & Pricing Export/Import Options:
[/FONT]
Complete Products (with Metatags)

[FONT=Verdana, sans-serif]The attachment is very interesting.[/FONT]

Interesting indeed, (if I was able to open it). I highly suggest you rename your admin directory right now. It is included in the posted link. :/

[FoodSourceDirect]

Interesting indeed, (if I was able to open it). I highly suggest you rename your admin directory right now. It is included in the posted link. :/

Hi MC:

Something you said gave me a tip. I changed the beginning of the name of my csv file from FULL to Full and pre-pended the custom product field names in my csv file I created with "v_", redid the upload and it worked... Thanks

[mc12345678]

Hi MC:

Something you said gave me a tip. I changed the beginning of the name of my csv file from FULL to Full and pre-pended the custom product field names in my csv file I created with "v_", redid the upload and it worked... Thanks

Welcome, though the thanks should go to Chadderuski as it is has been his suggestion to export first to see how things look and respond before trying to upload. Also to back up back up, back up before making changes to the database. :)

[Kevin205]

Can a product be moved from one category to a newly desired category and subcategory using "FUll-EP_" import?

Example:
Move from: Products^T-Shirts
To: Clearance^T-Shirts

I did this by changing the v_categories_name_1 column from Products^T-Shirts to Clearance^T-Shirts. By doing this it retained the "Product Master Category" and created a linked product.

Furthermore even though it says it has created a linked product, the linked product can NOT be found in the cart. When the product model is searched in the cart, it only shows up in the master category.

The idea was to bulk move products from one category to another!

[FoodSourceDirect]

renamed. Thanks for the heads-up

[FoodSourceDirect]

Hi MC:

This is weird. I looked at the file that I exported from Easy Populate 4.0 and noticed that a v_ was inserted at the beginning of each of the column header names of the custom product fields. Did phpMyAdmin do that or did Easy Populate? Could that be the problem.?

[mc12345678]

Hi MC:

This is weird. I looked at the file that I exported from Easy Populate 4.0 and noticed that a v_ was inserted at the beginning of each of the column header names of the custom product fields. Did phpMyAdmin do that or did Easy Populate? Could that be the problem.?

The headings of the exported csv file are prepended with v_ and that same prefix is expected upon upload. Unfortunately, those that become familiar with that information, tend to also include it in the customized list. So there is no problem that it exists in the csv file and is an indication that the code is processing.

Still unsure if your issue has been resolved. The only other thing I can think of at the moment if it hasn't is that the database manipulated in myphpadmin is not the same as referenced in the admin/EP4 which wouldn't be unheard of when bouncing back and forth between the variious locations.