1. rsangrosext
  2. RO CSVI
  3. Wednesday, 07 October 2020
  4.  Subscribe via email
Hi there,

I'm managing to importing products with your excellent component but I'm experiencing something I cannot find out how to solve. For child variants for a product I want to store NULL values for fields:

product_length
product_width
product_height
product_lwh_uom

Since this fields are inherit from parent product. In the csv file I'm placing nothing on the field for the child products but on the import process the field is stored with "0.0000" in database instead of NULL what is happening in reality if I create the product manually. I'm concerned this could create problems with shipping rules.

Could you please help me and tell me how to store NULL values for this fields?

That's an example where first row is the parent product and the rest lines are for child products:

HEADER = product_length product_width product_height product_lwh_uom
FIRST ROW = 31.0000 18.0000 11.0000 CM
SECOND ROW =
THIRD ROW =
...

Thanks.

I attach the example csv file.
Attachments (1)
Accepted Answer
Accepted Answer Pending Moderation
Hello,
Yes i see that VirtueMart has the option of saving value as decimals when value is entered as 0 and null when the value is empty. With RO CSVI we store values as decimals as the database field is defined as decimal(See attached screenshot). I have added support for null values with attached patch file. Please load the patch file and run the import again. Remember that the patch will work only on new products and will not update the values for products which are already in database.
Attachments (2)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer Pending Moderation
Hello,
I'm concerned this could create problems with shipping rules.

Can you tell us on how the value 0.0000 affect the shipping rules? Just want to know how it would be different from Null value.
Kind regards,

Tharuna

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

About your question "Can you tell us on how the value 0.0000 affect the shipping rules?" I just did the test. If you place 0.0000 shipping rules on weight will never take place because once you choose the variant, since the variant has 0.0000 as weight will never apply different shipping cost based on the weigth of product since they will be allways be 0.0000.

I beleive NULL value restricts the rule to what is defined on parent product where I'll place the right weight. In this case, when the weight on parent is considered, the shipping rules are applied correctly.

I think your patch should be definitely considered to be part of your core component.

Thanks for the support.
Regards
  1. 3 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
About the Patch, thanks for it. It worked perfectly! :D
  1. 3 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
I beleive NULL value restricts the rule to what is defined on parent product where I'll place the right weight. In this case, when the weight on parent is considered, the shipping rules are applied correctly.

That is odd that the rules are applied when it is NULL and not 0.0000 when both are considered as empty value.

About the Patch, thanks for it. It worked perfectly! :D

Thank you for confirming that patch is working. This fix will be included in our upcoming RO CSVI release.
Kind regards,

Tharuna

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


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