Resolved replacement with empty field

Hello,
Product weight and measures are decimal fields so it wont accept empty or space and 0.0000 is the default value. Please try to import using value "NULL" instead of empty "" (space) and let me know on how it goes.

Good morning. I tried to insert NULL but still does not work :-(

Hello,
Can you tell me the requirement of having this field empty? I dont see any issue having 0.0000 in the field as that is the default value.

the shipping rate is not calculated

Hello,

Can you elaborate some more on that?

what do you mean?

I am exactly asking the same question

Can you explain how having a 0 value is affecting the shipping rates?

my shipping rates are set according to the weight of the product. If the product weighs 0, the rate is not calculated

How is the weight calculated then when it is NULL?

CSVI can't import NULL values, actually the underlying code doesn't. To empty the weight values you will have to run this SQL query using PhpMyAdmin for example:

UPDATE jos_virtuemart_products SET product_weight = NULL WHERE product_weight = 0;

This will set all the product weights to NULL for products with a weight of 0.

If you know or know someone that can code a bit, you could execute this automatically using the CSVI plugin which is triggered on the onImportComplete. The other option would be to get the shipping rates plugin to do the same with a 0 value as it does with a NULL value. Both values mean that the product has no weight I think.

Thanks for the reply. What has me tips the standard procedure for those who want to take the weight and measures from parent products?

Hello,

I think that VirtueMart takes values from parents by default if children do not have any values set. That is more a VirtueMart than a CSVI question.

How is the weight calculated then when it is NULL?