Resolved Product manufacturer not updated

Hello,

We corrected the CSV, making the manufacturer field as empty (no manufacturer assigned).

This is wrong. You cannot import an empty value. You can assign the new manufacturers in your import file and on import RO CSVI will delete the existing manufacturers for a product and import the new ones.

Correct you import file and run the import. If you still have nay problem, post the import debug log to check.

What if I want to remove the previous manufacturer value? No manufacturer for the product, blank. (which is the VM default)

Thank you.

I had to turn on the "Advanced" mode to find the new option.

I reimported the products with:
Delete Manufacturer
and
Delete Related Products
turned on

The only changes I made to the template.

The products imported but now their product view (template) is messed up in the front-end.

Disabled the above options, and re-importing now again. To see if that fixes it.


EDIT: Manufacturer entry seems to be successfully reset.

EDIT2: If this doesn't solve the issue, how do I rollback the patch you sent me?

Hello,

I had to turn on the "Advanced" mode to find the new option.

Yes, i missed that in my reply

The products imported but now their product view (template) is messed up in the front-end.

Check if no related products messes up the view. I can only think of that as a problem.

EDIT: Manufacturer entry seems to be successfully reset.

Thank you for confirming that patch is working.

EDIT2: If this doesn't solve the issue, how do I rollback the patch you sent me?

The patch has been developed on RO CSVI 7.17.0 version. To roll back the edits in patch file you can reinstall RO CSVI VirtueMart addon extension for version 7.17.0 version.

Unfortunately, this patch is causing problems to the imported product views. It's weird, here's the detail...

We tried re-importing the products, without removing Manufacturer, still front-view broken (browser dev tools reports a 500 server error somewhere during the loading of the product page).

We rolled-back to stable 7.14. Tried re-importing the products. No difference.

We eventually deleted the products from VM, and then imported again (7.14). Now it works ok.

---
I decided to do more testing. So I reinstalled your patch. And created a CSV with just two products in that category. Tried importing them, with Manufacturer removal turned on... 500 server error during the import... and it messed up the product view of all (thousands) products in that category! (very very weird).
Products in other categories, unaffected.

I am attaching the log and the import file used for this last test.

In short, this patch is NOT ready for shipping yet. Let me know how I can help you further troubleshoot this.

Thanks!

Hello,

Unfortunately, this patch is causing problems to the imported product views. It's weird, here's the detail...

The patch file has a query to delete manufacturer of a product based on a template settings. I really doubt if that is causing the view to break.

We rolled-back to stable 7.14. Tried re-importing the products. No difference.

The patch was developed based on the files of RO CSVI 7.17.0 version, i hope you installed the patch file on RO CSVI 7.17.0 version and not on RO CSVI 7.14.0 version.

I decided to do more testing. So I reinstalled your patch. And created a CSV with just two products in that category. Tried importing them, with Manufacturer removal turned on... 500 server error during the import... and it messed up the product view of all (thousands) products in that category! (very very weird).

Can you please find out more details on the 500 error and post it here? You can check your server error logs and that will give us the details on the 500 error.

I am attaching the log and the import file used for this last test.

The debug log is incomplete so there is nothing much to get from debug log other than the template settings. I see you are also deleting custom fields, prices along with manufacturer for a product.

Let me know how I can help you further troubleshoot this.

May i know which version of VirtueMart you are using? Once we have the details on 500 error, we should get a lead on what is breaking those frontend product views.

Hello,
The patch was developed based on the files of RO CSVI 7.17.0 version, i hope you installed the patch file on RO CSVI 7.17.0 version and not on RO CSVI 7.14.0 version.

No, I installed it on top of 7.14. Didn't know there was a newer version out (must have been a very recent release).
That may have been the reason for the mess.

EDIT: I see I mentioned CSVi 7.17 in the first post. This has been my mistake. I don't know how I came to this. Apologies.

The debug log is incomplete so there is nothing much to get from debug log other than the template settings. I see you are also deleting custom fields, prices along with manufacturer for a product.

Yes, this has been the default for all our templates, which forked fine so far.
When re-importing, we usually want to reset all details for a product, because any of the values may change (except the SKU).

May i know which version of VirtueMart you are using? Once we have the details on 500 error, we should get a lead on what is breaking those frontend product views.

VirtueMart 3.8.2 10325

I'll check the error log for any meaningful entries... Thanks!

Hello,

EDIT: I see I mentioned CSVi 7.17 in the first post. This has been my mistake. I don't know how I came to this. Apologies.

Yes and so i did not mention about on which version the patch has to be installed.

I'll check the error log for any meaningful entries... Thanks!

Yes please post it so we can check further.

Hello,
Did you find the cause for the broken views? We did not hear from you so want to check on the findings.

We checked the server error log, and found a bunch of fatal errors, that were caused by our custom code. These were not having an obvious impact on the front-end, but we went ahead and fixed them. These might have played a role in the problem described here, or may have not.

The above, plus the fact that we applied the patch to an earlier version of CSVi, makes our problems probably irrelevant.

We ended up removing and re-importing the products.

Since this is a production site, we cannot currently afford to do more tests (timewise). But we will do so in the future, and will report back any problems we find.

Thank you very much for your time and effort!

Hello,
Thank you for sharing your findings. For any new queries please create a new topic.