Quote Originally Posted by salvo72 View Post
hi

i have a bit problem whith easypopulate4

if a modified a products (model12345) in admin at new import/update zencart create a new product with another product id and with the same products_model, then I find in these cases with two products with the same products_model

how can I fix?
you can indicate whether this forum has already dealt with the problem?

thanks
I think I understand the problem; however, it is difficult to understand all that was written. The obvious fix is to restore the backup made before updating the database with EP4. The next thing: I am not sure how many data entries are involved. If one/two, then easy either go into the admin panel and delete the one that is extra, or set it's status to zero and modify the model# to something different.

If multiple products have the same model# or there are multiple "pairs" of products with the same model#, then one method to "repair" them is to delete all of the products with the duplicate model#, then change the model# in the upload file as necessary to have unique product model#s and upload them.

If the issue is that the same product description was uploaded for a different model# (model# changed), then I would suggest deleting the newer uploaded entry.

A few words of warning: deleting products from the database may affect other reports and relationships in ZC, especially if they are dependent on the products_id field in the products table.

EP4 can delete a product by model# by changing the status of the model# for the product to 9 instead of 0 or 1 when importing the data file.

Looking at the picture provided, I see two red dots, the the information on the two rows is not the same: different model#, different image, etc... But now that I have looked again, I see that the red dots are two products that have the same information as the two products at the top of the list.

So, there's the short-cut way identified above, of deleting all cases, then uploading the expected product, but realize short-cuts tend to lead to problems. And then there is a way that would preserve your existing relational data. This method would use SQL statements or mySQLAdmin as well as EP4 or at least EP4 data and is more along the way I would try to recover if a backup had not been made.

Identify all duplicate model#s,
Identify the products_id,
Using the above information, modify the model#s for the newest product to be "removed" to a unique model# possibly the next product to be added and change the status to 0.
When the new product is added, change all relevant information to the new product and update the status to 1.
I may do more than that depending on a review of the purchase history of the product being modified, but that's basically what I think I would do in that situation.

Basically, the only fix when using EP4 by itself, without editing the product, is to delete all cases of the model# (status 9) and then upload only the one entry desired. There is no "rename" option in EP4. Otherwise there are other tools that can help.