1. Thomas
  2. RO CSVI
  3. Sunday, 17 January 2021
  4.  Subscribe via email
I need help importing the product variants. Only the first product variant customfield is importing, other product variant customfields not on product page.
Can't find the problem.

Custom Fields For All Version 4.1.1
Stockable Custom Fields Version 1.5.1

Joomla! 3.9.24
PHP-Version 7.4.10
VirtueMart 3.8.6 10373
Attachments (4)
Accepted Answer Pending Moderation
Hello Thomas,
Do you have RO CSVI - VirtueMart - Breakdesigns extension installed and enabled? If yes, please post import debug log to check. To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

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

thank you for your reply.
(I think i haven't made any changes? Everything went well before the update.)

Kind regards,

Thomas
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Thomas,
I think i haven't made any changes?

Yes you have RO CSVI VirtueMart Breakdesigns plugin installed and enabled so that is good.

Everything went well before the update.

Do you mean RO CSVI Update?

Your import file and template is good. Running import with your template and file adds the child products. See attached screenshot.

Please check if you have Stockablecustomfield added like the attached screenshot. Let me know if you have the same.
Attachments (3)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
the product update runs automatically. I didn't notice when exactly the problem started.
But otherwise it always worked. The last changes were the joomla, ro csvi and breakdesign update.

The product view on the first screenshot is not the same.
I have set up a test page: support@rolandd.com>:
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Thomas,
Recently we did some changes to VirtueMart Product import and with Stockable custom fields. I have attached a patch file with these changes. Please load the attached patch file and run the import again. See if your import issue is solved 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. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Thanks for the patch.
I've tested it extensively. The import of a single parent product with children works fine, when importing multiple products with user-defined fields there is confusion (missing fields, fields of other products).

example sku 501-13051_BULLS with missing fields. You can check this on the demo webpage.


Am Di., 19. Jan. 2021 um 05:19 Uhr schrieb RolandD Cyber Produksi <support@rolandd.com>:
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Thomas,
I am looking into this issue. Will let you know on what i find.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Thomas,
I was looking into the issue and found that your file has extra values for custom_title, custom_value and custom_multiple for almost all the products. If you see for the example product you sent 501-13051_BULLS, the content from import file is


"501-13051_BULLS";"";"Rahmenhöhe~RH~RH~RH";"customfieldsforall~stockablecustomfields~stockablecustomfields~stockablecustomfields";"~Y~Y~Y";"51cm";"";"1";"0"
"501-13056_BULLS";"501-13051_BULLS";"Rahmenhöhe";"RH";"";"56cm";"Y";"0";"1"
"501-13061_BULLS";"501-13051_BULLS";"Rahmenhöhe";"RH";"";"61cm";"Y";"0";"2"


As you can see there are only two child product rows but there are three of RH~RH~RH, stockablecustomfields~stockablecustomfields~stockablecustomfields and Y~Y~Y values in parent product. You need only two of these values for two child products. I am seeing this extra values for all the products with child in your import file and for products which does not have a child product, you have RH and stockablecustomfields and Y for custom_title, custom_value and custom_multiple fields. You need to correct these extra values and run the import.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Thank you for your suggested solution. Unfortunately this doesn't work for me. I installed version ro_csvi 7.18.0 and all problems are gone.
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Thomas,
Attached is your modified import file. With the patch file i sent earlier, please try the import with RO CSVI 7.19.1 version. Let me know on how it goes.

With this modified import file and with RO CSVI 7.19.1 version, import went good for me in my local test site. See attached screenshot.
Attachments (2)
Kind regards,

Tharuna

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

Thank you very much, I'll test it and get back to you.

Kind regards,
Thomas
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Tharuna,

on my local installation i have missing fields (RO CSVI 7.19.1, patch installed and your import file).
For parent and single products i need a orderable custom field, can't see this on the frontend.

Kind regards,
Thomas
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello Thomas,
on my local installation i have missing fields (RO CSVI 7.19.1, patch installed and your import file).

Can you please tell me which fields you are missing? Let me know if it is ok to run the import in the site you sent us https://shop-wittstock.de.

For parent and single products i need a orderable custom field, can't see this on the frontend.

In VirtueMart Custom fields page, you need to set Cart Attribute and Cart Input to Yes. See the attached screenshot. Do you have that set to yes?
Attachments (1)
Kind regards,

Tharuna

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

I have now found the problem! The "product_parent_sku" field in the import file must not be empty . "0" is required to update the "product_parent_id" field in the database table "virtuemart_products". If the parents' product or the children changed in the importfile for produkt variant update (add or remove one), the table "virtuemart_products" was not updated.
Now everything is running perfectly again with my original import files.

Thanks for your support!

Thomas
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Thomas,
That is strange. If the product_parent_sku is empty product_parent_id is entered as 0 (also default value in virtuemart_products table). See the query from the debug log you attached in your previous reply. I am not sure how that worked by setting explicitly in your import file.


Executed store
2021-01-18 10:12:12 1 [QUERY] UPDATE `j1ipx_virtuemart_products` SET `virtuemart_product_id`='3385',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`=NULL,`product_width`=NULL,`product_height`=NULL,`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`product_stockhandle`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_discontinued`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|',`product_canon_category_id`=NULL,`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='0',`pordering`='0',`has_categories`='1',`has_manufacturers`='1',`has_medias`='0',`has_prices`='1',`has_shoppergroups`='0',`created_on`='2020-12-09 13:30:48',`created_by`='0',`modified_on`='2021-01-18 10:12:12',`modified_by`='210',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku` = '526-01848_PEGASUS'
Kind regards,

Tharuna

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

maybe my database was a bit messed up from testing. It wasn't the main problem either.
I did a lot of testing and figured out how to change the import file.
When i disable parent product as derived, then is my importfile working, but the parent product is not orderable.
If product as derived "1" then the last child is missing.

"product_sku";"product_parent_sku";"custom_title";"custom_value";"custom_multiple";"custom_param";"category_delete";"product_as_derived";"pordering"
"021394503_KTM";"";"Rahmenhöhe~RH~RH~RH";"customfieldsforall~stockablecustomfields~stockablecustomfields~stockablecustomfields";"~~Y~Y~Y";"43cm";"N";"0";"0"
"021394506_KTM";"021394503_KTM";"Rahmenhöhe";"RH";"N";"46cm";"Y";"0";"1"
"021394511_KTM";"021394503_KTM";"Rahmenhöhe";"RH";"N";"51cm";"Y";"0";"2"
"021394516_KTM";"021394503_KTM";"Rahmenhöhe";"RH";"N";"56cm";"Y";"0";"3"

If I want to order parent and child products and have all the fields visible, my import file must look like this:

"product_sku";"product_parent_sku";"custom_title";"custom_value";"custom_multiple";"custom_param";"category_delete";"product_as_derived";"pordering"
"021394503_KTM";"";"Rahmenhöhe~RH~RH~RH~RH";"customfieldsforall~stockablecustomfields~stockablecustomfields~stockablecustomfields~stockablecustomfields";"~~Y~Y~Y~Y";"43cm";"N";"1";"0"
"021394506_KTM";"021394503_KTM";"Rahmenhöhe";"RH";"N";"46cm";"Y";"0";"1"
"021394511_KTM";"021394503_KTM";"Rahmenhöhe";"RH";"N";"51cm";"Y";"0";"2"
"021394516_KTM";"021394503_KTM";"Rahmenhöhe";"RH";"N";"56cm";"Y";"0";"3"

and then it works

Kind regards,

Thomas
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello Thomas,
Thank you for posting the solution.
Kind regards,

Tharuna

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


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