1. eclipse
  2. RO CSVI
  3. Wednesday, 16 December 2020
  4.  Subscribe via email
Hi,
I’m using Joomla 3.9.23, Virtuemart 3.8.6, with Breakdesigns Custom Fields for All 4.1.1 ands Stockable Custom Fields 1.5.1
I’ve installed CSVI 7.19.0 and the CSVI Breakdesigns plugin 7.19.0.
I’m testing with a blank Joomla installation, and following your documentation for the Breakdesigns plugin. Our products usually have 2 custom fields for all fields within a stockable custom fields, so I was testing Option 6: Stockable Custom fields with String and Custom fields for all custom fields.
I followed the documentation and create one string custom field, one Custom field for all custom field, and then add them to a Stockable custom field. I create the Import template, and run it with the supplied demo content. The example Parent Product is imported, along with the 2 child product variations, and 3 products show in my Product List in Virtuemart (1 parent and 2 children). However, when preview the Parent product in the front of the website, only one variation/child product is showing. If I edit the parent product, there are 2 child products showing in the CHILD PRODUCTS tab, but only some of the first variation is showing in the CUSTOM FIELDS tab.
I have repeated the examples for Options 5, 6 and 7 in the Breakdesigns plugin documentation on your site, but I get similar results. The child products are imported so they show in the Virtuemart Products List, but when editing the parent product, the child products show in the Child Products tab, but in the custom fields tab, there is only a partial first variation entry.
I cannot seem to get the import to completely add the new products to the custom fields in the Parent Product, no matter what examples I try.
I also setup a parent product with 5 children as an example, and then tried to export it. I cannot find a field for CUSTOM_MULTIPLE when mapping fields for the export file, and so I cannot try to backwards engineer the correct import code either.
Maybe I am not understanding how the custom_multiple field works, or maybe I am doing something wrong. I have attached a screenshot of my Parent Product child product tab, and custom field tab, and also the import log.
Any help would be very appreciated, as we are hoping to use this to import larger number of child product variations. When editing a parent product with over 100 child products, the page becomes unstable to continue to edit.
Thanks,
Aaron
Attachments (3)
Accepted Answer Pending Moderation
Hi Tharuna,

I have enabled the Delete Custom fields relations option in the Import Template, but I still cannot get the correct ordering after my second import.
I am using the same example - importing parent with 26 children, which works correctly. Then I go to import my second import file, which has the additional 3 child products, using your ordering above, but i still get the wrong order after importing the 29 child products with new custom_ordering.

I can't see what I am doing wrong :( I have attached my 26 product import, the 29 product import and the import logs.

Any ideas what I am doing wrong?

Thanks,
Aaron
Attachments (5)
  1. one week ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Aaron,
I was able to reproduce the ordering issue with your files and with Delete custom fields relation option set to Yes. Please load the attached patch file with the fix for the issue. Run the import and let me know on how it goes with the patch file.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Even though we are 30 minutes past beer o'clock here, I couldn't wait to test it. I have a copy of the clean install that I have restored so many times, I could do it in my sleep, so what is the worst that can happen....
And guess what, it worked!:D :D :D :D :D

I was able to use those 2 import files and the ordering was correct both times. For anyone reading this in future, I was importing a parent product with 26 children (stockable custom fields), and then import a further 3 children into the required custom ordering - so all 29 are in correct order.
I even had another beer, deleted all products and did it again, and it is still working. And to think I nearly gave up drinking because I could not get this working (joking).
The only items not working in my import files are the image title and description. The thumbnail is generated correctly, but the image title and Alt (file_title and file_desc) don't work in my import test files. Do they work in your tests?

I wish I could say that I won't bug you any more, but I have to do some testing with more combinations of the custom fields, but I have a good idea of how everything works. Thanks for persisting and finding fixes.
Enjoy your weekend!

Thanks,
Aaron
Attachments (1)
  1. one week ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello Aaron,
Even though we are 30 minutes past beer o'clock here, I couldn't wait to test it. I have a copy of the clean install that I have restored so many times, I could do it in my sleep, so what is the worst that can happen....
And guess what, it worked!:D :D :D :D :D

Thank you for confirming that patch is working. This fix will be included in our next RO CSVI release.

The only items not working in my import files are the image title and description. The thumbnail is generated correctly, but the image title and Alt (file_title and file_desc) don't work in my import test files. Do they work in your tests?

I know why it is not working for you. In your import template on image tab set Fill media fields to No(See attached screenshot), save the template and run the import. That should solve the problem with file_title and file_desc.

I wish I could say that I won't bug you any more, but I have to do some testing with more combinations of the custom fields, but I have a good idea of how everything works. Thanks for persisting and finding fixes.
Enjoy your weekend!

We are glad that you are helping us in finding these hidden bugs :) Happy weekend to you too!

Please leave us a review on Joomla Extension Directory.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. one week ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hi Tharuna,

Setting the Fill media fields to NO works, sorry i had misinterpreted that it should be set to Yes. Now that image file_title and meta fields work too. Thanks!

I'm trying to set my export template to be able to export just a single parent product with it's child products. I have looked through the Rules plugins, though I don't think they suit this need.

I can export the entire category (within the export template options), and this does export the child products (even though they aren't assigned to a category). So I had an idea to make a dummy unpublished product category called "Export Products" and assign any products I want to export to this category. Does this sound like the easiest solution to being able to export a single product with children?

Thanks,
Aaron

p.s. added a review :)
  1. 5 days ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Aaron,

Thank you for the review, we appreciate it.

As for your export, you can also specify the product SKUs on the Options tab. This way you can export the products you want. Is that not an option for you?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 5 days ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hi Tharuna,

The export products via SKU filter works, but is not the easiest or quickest way to export a single parent product with lots of children (each with unique SKU's).
If we want to update a parent product with lots of children and add some more custom fields, we would export the parent product with children, and copy/paste the custom_title's and other fields to save time, and then update the custom_ordering as required. And this has been working in our tests. Maybe I am doing something wrong, but if I export using SKU 101 for my example, it only exports the parent product itself and none of it's child products (they are not sku 101). I tried the Use Parent Values, but from reading the 7.19.0 changelog, this is only for exporting empty values with the parent values, and not exporting children.
If I put YES for child products only, it doesn't export anything - but this is expected as none are SKU 101.

I wish there was an option for "Export Child Products with Parent YES/NO", and I would only need to add the single parent SKU, and not all the child products sku's as well - but I might be the only one wanting that option, so I am not requesting or considering it essential or even needed, as I have thought of an easy work-around.
I thought that temporarily adding the parent (and any other export products needed) to the dummy/unpublished EXPORT category would be easiest. When I run the export, I am glad to see that the parent product is exported along with the children - even though the children have no category assigned.

So is there an easier way? And please don't tell me that it is a bug, and child products should not be exported via category filter if they have no category assigned, and you are going to fix it - i like this bug!!

Thanks,
Aaron
  1. 4 days ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Aaron,
If we want to update a parent product with lots of children and add some more custom fields, we would export the parent product with children, and copy/paste the custom_title's and other fields to save time, and then update the custom_ordering as required. And this has been working in our tests. Maybe I am doing something wrong, but if I export using SKU 101 for my example, it only exports the parent product itself and none of it's child products (they are not sku 101). I tried the Use Parent Values, but from reading the 7.19.0 changelog, this is only for exporting empty values with the parent values, and not exporting children.
If I put YES for child products only, it doesn't export anything - but this is expected as none are SKU 101.

With product SKU filter, RO CSVI checks for all products which has SKU as 101 as part of it and not the exact SKU as 101. So if you have any common string with your child products SKU, you can use that in SKU filter. Like if first child product has SKU childsku-1, second child product has SKU as childsku-2 and third child product has SKU as childsku-3 and so on, just using the string childsku in Product SKU filter will get all the child products on export.

I wish there was an option for "Export Child Products with Parent YES/NO", and I would only need to add the single parent SKU, and not all the child products sku's as well - but I might be the only one wanting that option, so I am not requesting or considering it essential or even needed, as I have thought of an easy work-around.
I thought that temporarily adding the parent (and any other export products needed) to the dummy/unpublished EXPORT category would be easiest. When I run the export, I am glad to see that the parent product is exported along with the children - even though the children have no category assigned.

Yes, you are the first user to ask for such a feature. If we get more requests from other users we can consider in developing it. I guess assigning parent to a dummy category and exporting based on that category will be an easy workaround here. I am not seeing any other easy way considering child products SKUs are unique.

So is there an easier way? And please don't tell me that it is a bug, and child products should not be exported via category filter if they have no category assigned, and you are going to fix it - i like this bug!!

That is not a bug. That is how VirtueMart works. If a child product does not have a category or price or image assigned it uses the details of parent product. With RO CSVI VirtueMart Product export template there is an option to set if you would like to use parent values for child products on export. See attached screenshot.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 4 days ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hi Tharuna,

So far, so good - I have taken a clone copy of our live site, installed the CVSI and plugins and templates, and have only found issues so far exporting products that already have corrupt custom fields. These corrupt custom fields occurs when we edit parent product with too many children and it does not save the edits correctly, so the irregular exports are be expected. We can also use the export to find those errors and hopefully re-import them correctly.

The problem with my idea assigning a product to a category to export that category sounds good, BUT then I have to edit the parent product. I did not think of this, and the whole point of importing changes is to avoid editing the parent product....and as soon as I went to assign a parent product with lots of child products and could not change categories, I realised the problem with my category export idea.

Unfortunately there is no common SKU for these parent products with lots of children, so i will have to work out a way of exporting differently.
I can assign parent products with less than 100 children to a export category and it works perfectly. But i cannot edit the products with 100s of children this way.

Any other idea apart from SKU or Category filters? The skip rule would be good if it contained a DO NOT SKIP option :) for example, do not skip product sku 101 (or it's children) but skip the rest. If I better understood the rules plugins I would try and make one for this purpose.

I can always export an existing category containing the current parent product and even exclude some other sku's I don't need (unless there are lots of products in that category), so this won't be a deal breaker, but I was interested if you thought of another way?

I will be further testing tomorrow but I am hoping not to bother you too much anymore,

Thanks,
Aaron
  1. 4 days ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
So far, so good - I have taken a clone copy of our live site, installed the CVSI and plugins and templates, and have only found issues so far exporting products that already have corrupt custom fields. These corrupt custom fields occurs when we edit parent product with too many children and it does not save the edits correctly, so the irregular exports are be expected. We can also use the export to find those errors and hopefully re-import them correctly.

Reimporting them should correct those custom fields.

The problem with my idea assigning a product to a category to export that category sounds good, BUT then I have to edit the parent product. I did not think of this, and the whole point of importing changes is to avoid editing the parent product....and as soon as I went to assign a parent product with lots of child products and could not change categories, I realised the problem with my category export idea.

Unless the parent product is assigned to the category you cannot export it based on the category in export. The category has to be assigned to parent product and not for child products. May i know why that would be a problem assigning a category to a parent product which has lots of child products?

Any other idea apart from SKU or Category filters? The skip rule would be good if it contained a DO NOT SKIP option :) for example, do not skip product sku 101 (or it's children) but skip the rest. If I better understood the rules plugins I would try and make one for this purpose.
I can always export an existing category containing the current parent product and even exclude some other sku's I don't need (unless there are lots of products in that category), so this won't be a deal breaker, but I was interested if you thought of another way?

You can still achieve do not skip with RO CSVI Skip rule plugin using regular expressions but the problem i see here is that skip rule will only include the parent product as that has SKU 101 and not the child products as they have unique SKUs.

You can still make a rule to your purpose, take a look at Writing a rule plugin document :D
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 4 days ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hi Tharuna
May i know why that would be a problem assigning a category to a parent product which has lots of child products?

We have found that anything over 200 children will cause the parent product page to load incorrectly when trying to edit it. We've upped our hosting but the same problems occur as per posts on the VM forums when users have a lot of custom fields assigned to the one product. As we have a generic product that has many options available for the one XYZ Brand T-Shirt as an example. We have stockable custom fields like colours, sizes, and material combinations.

Some parent products will need up to 500 custom fields...so we cannot edit those parent products after adding the first 200 or so manually. Plus importing them would be much easier - as pointed out on the VM forums, wheer a user said they used your product to setup products with a large number of custom fields, as they were also unable to edit parent products with large number of custom fields.

So at the moment, exporting an existing category it probably the best option for us :)

I looked at the rule writing before, and will see if we need to do this. I'll also look into using similar SKU's for parent and child products so this can be used in future too - this is probably the best way to go as most of our SKU's are personal use only and could be updated.

Thanks so much for your help,
Aaron
  1. 4 days ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Aaron,
We have found that anything over 200 children will cause the parent product page to load incorrectly when trying to edit it. We've upped our hosting but the same problems occur as per posts on the VM forums when users have a lot of custom fields assigned to the one product. As we have a generic product that has many options available for the one XYZ Brand T-Shirt as an example. We have stockable custom fields like colours, sizes, and material combinations.

Some parent products will need up to 500 custom fields...so we cannot edit those parent products after adding the first 200 or so manually. Plus importing them would be much easier - as pointed out on the VM forums, wheer a user said they used your product to setup products with a large number of custom fields, as they were also unable to edit parent products with large number of custom fields.

Thank you for sharing this information. We are glad to hear that our product is of help to users in such situations :)

I looked at the rule writing before, and will see if we need to do this. I'll also look into using similar SKU's for parent and child products so this can be used in future too - this is probably the best way to go as most of our SKU's are personal use only and could be updated.

Having similar SKUs for parent and child is a good option. You can update the SKUs for existing products using RO CSVI by using virtuemart_product_id in import file.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 4 days ago
  2. RO CSVI
  3. # 12
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!