Categories
View Replies (8)

Resolved RE: Having trouble using the Breakdesigns plugin to import

  1. eclipse
    eclipse
  2. RO CSVI
  3. Tuesday, 02 March 2021
  4.  Subscribe via email
Hi Tharuna,

We have been exporting old products with lots of children and importing them with changes as needed, which has been great. It would be helpful if we could read the import logs to find issues though, but usually we can spot a typo or incorrect field and fix it.

However we have a product with many children, and we are just getting stuck on the 10th set of options in the custom_ordering column. We are using option~size, and after importing we notice the last child product in the 9th option does not show in the front end as selectable, and then none of the 10th set of options show. It is really frustrating because I can't see a typo in the import file, and I can't see what the issue is in the import log either :(
Everything imports correctly up until the last child in the 9th option.
BC Grey Frame Oxide Ring BCFOT 8/2.8 mm shows, but the last 8/3.0 mm, and then none of the 10th option CC Silver Frame Oxide Ring CCFOT shows at all in the front end of the website when previewing the product.

Is it possible the 10th option causes a bug?? I doubt it but I cannot see what I am doing wrong either.

Many thanks,
Aaron
Attachments (2)
com_csvi.log.124.txt
260221 FTips Working 2.xlsx
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Aaron,
I found the cause for your issue, you have 268 child products in your import file. For parent product row you have 268 times of stockablecustomfields in custom_value field, 268 times of newOption Sizes MASTER in custom_title field but custom_multiple field has only 234 times of Y. That makes the child products not to import and so they don't show up both on frontend and backend. Correct your import file and run the import again.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Aaron,
Created this as a new post as this is a new issue.

BC Grey Frame Oxide Ring BCFOT 8/2.8 mm shows, but the last 8/3.0 mm, and then none of the 10th option CC Silver Frame Oxide Ring CCFOT shows at all in the front end of the website when previewing the product.

Do you see the values in backend? Are these values imported by RO CSVI? Debug log has only 20 entries by default so i was not able to check if these rows were inserted in database.
Kind regards,

Tharuna

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

Yes, this is a different issue so thanks for opening the new ticket.
I can see all 268 children in the backend of the website VM Product List. It is difficult to edit the parent product page to check, however the child products stop at the 9~31 custom field. The last 9th option 9~32 does not show in the Custom Fields list in the parent product, nor do any of the 10~1 to 10~33 show.

This is the same on the front of the website, see attached screenshot.

I have attached the full logs. I can see the following differences between the logs for the individual child products. After the 9~31 custom field, there is no more of the following SQL in the remaining 34 child products (9~32 and 10~1 to 10~33).
This is the last entry to have this statement. The following custom fields/child products do not have this statement.

2021-03-03 04:55:37 235 [QUERY] INSERT INTO `r5xoq_virtuemart_product_custom_plg_customsforall` (`customsforall_value_id`,`virtuemart_product_id`,`customfield_id`) VALUES (288,5102,17084)
2021-03-03 04:55:38 235 [DEBUG] Inserted main custom id for stockable custom fields plugin
2021-03-03 04:55:38 235 [QUERY] UPDATE `r5xoq_virtuemart_product_customfields` SET `customfield_params` = 'parentOrderable=\"0\"|custom_id=\"\"|outofstockcombinations=\"disabled\"|child_product_id=\"5102\"|' WHERE `virtuemart_customfield_id` = 16617
2021-03-03 04:55:38 235 [DEBUG] Find the custom field ID

I had to remove some info from the log as it was too big to attach, so i removed some info from the middle of the logs where I could spot nothing different between them.

The first value to have the above statement missing is entry #236. All following entries in the log do not have that insert main custom field, but i cannot see what I have done wrong in my import file :(

Thanks for your help,

Aaron
Attachments (2)
com_csvi.log.125.txt
missing.png missing.png
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Aaron,
Looking into this issue, will let you know on what i find.
Kind regards,

Tharuna

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

I am so sorry, yes that has fixed it. Thank you so much again for your help!

Cheers,
Aaron
  1. more than a month ago
  2. RO CSVI
  3. # 4
eclipse
eclipse
Accepted Answer Pending Moderation
Hi Tharuna,

Just a quick question - I am about to install RO CSVI on our live site, and wanted to know if the latest 7.20.0 version includes the patches we used during our original testing, or whether I have to install the patch from here:
https://rolandd.com/support/ro-csvi/having-trouble-using-the-breakdesigns-plugin-to-import

Thanks,
Aaron
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Aaron,
You don't need to load the patch file, the fix is included with RO CSVI 7.20.0 version.
Kind regards,

Tharuna

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

Thanks!! Have a great day. Beer o'clock here already :D

Cheers,
Aaron
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


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