EasyPopulate 4.0 Support Thread

[Carbonless]

After successfully getting our store online and using easy populate for a good number of years, we had done some core upgrades and got away from using it in 2008. We are now needing to do mass updating to most of our products and we have installed the newest version on our 1.5.4 store as it was packaged.

As a result of our SEO reports we are finding that we not only need to edit product titles but we also need to edit model numbers and descriptions. We noticed that there is the ability to export using our products_ID as the primary key. When selecting just that and exporting various data, what is missing from each of them is the V_products_ID column.

We added products_ID to the custom export field and we are now getting that Collumn in our exports.

However, after editing a couple of products for title name and model number and attempting a test import, the import results in zero products being updated. If we change the primary key back to model number and edit and import, Then the import updates products successfully, however, if we change the model number it creates the product as a new product and duplicates it in our product database.

We now understand that if the primary key is the model number and the model number is changed it will result in a new product being created. Is there something I am missing in the configuration set up or is this a bug that the products_ID export does not import?

Thank you for any time and consideration to this issue…

[Carbonless]

Side note: we are not getting any errors displayed when trying to import the file that was exported with the products_ID column. Additionally the few changes that we did make did not increase the length of the title or model numbers.

[mc12345678]

What is the filename of the exported file and the then imported file? What was the method of "testing" the changes?

[Carbonless]

The name of the file exported was: Full-EP2016Apr27-145307 and we tried an import using the same name as we uploaded and as Full-EP2016Apr27-145307-import

Our attempt to test was simply to attempt a successful upload. No other testing method implemented.

[Carbonless]

Sorry... our attempt to test was to attempt a successful IMPORT, not upload.

[mc12345678]

Sorry... our attempt to test test was to attempt a successful IMPORT, not upload.

Glad you provided that correction, because I was just about to comment on the difference between the upload and import (other versions don't seem to have that "two" step process or it is not understood the difference.

Glad to know that part, but how do you "know" that no changes were made to anything after the import was what I was trying to get at..

As to the "setup", well I consider this new feature potentially hazardous to the "unknowing" and so I did include a little bit of "difficulty" to set it up at least as I have just taken a lap through the code... That being, to export with the products_id included one needs to currently add it to the user defined fields list. For import, the v_products_id field must be present and the admin configuration switch should be set to something other v_product_model... Capitalization does count, so above where V_products_ID was typed, that would be an incorrect field name for the purposes of the code.

Also were the "number" of columns modified between the export and import? (ie. columns removed?)

[Carbonless]

My steps:
Import/Export Primary Key: products_id
Added:

User Defined Products Fields

products_id

Exported file
Changed ONLY the Product name of 2 items and modified the model names of the same 2 products.
Saved file
uploaded
clicked import

Result:
Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 21087176
Memory Peak: 23515400
Execution Time: 0 seconds.

Verified against the actual products online with no changes.

I did verify that "For import, the v_products_id field must be present and the admin configuration switch should be set to something other v_product_model"

Any other item I'm missing?

[mc12345678]

I just ran an export with user defined field products_id in the admin-configuration (although was using version 4.0.34 not 4.0.34.a), then added three characters to the end of one of my test products, then with the primary key set to products_id, imported the file, every product showed as "updated" (even though technically nothing was to change except for the three characters added to the product name), and when I went to the store, the three characters were added to the product's name as expected...

[mc12345678]

Let me try modifying the product_model information of my test product to see what happens and if that is somehow associated... It was my expectation that this process would allow modification of the products_model field because that field would no longer be a primary field of concern...

[Carbonless]

Thank you for your time and feedback. May have to do a reinstall. I'll await your test result.