Require Product Weight.

[mytheory.]

HI,

We want to move from price-based shipping costs to weight-based. I have 3 questions regarding this matter:

1) In the BO, when entering the product information is there a way to require the employee to enter a weight at least greater than 0? To eliminate any mistakes when we switch over, we want there to be an error sign when they save if this field is not correctly filled out.

2) What SQL query must I use if I want update all the weights of the main products that are already in the DB? Since we've been using price-based calculations all the weight fields for all our products are set to zero... so instead of manually updating 1000's of products, there must be a query that does this right? We want to keep attribute weights at zero... just the weights for the main product (which I assume would update with the quantity).

3) Might be an obvious question... but the weight field is inputted by lb. (considering this is how our localization is set to). So for example, half a pound would go in as .5 right instead of say 8 ounces...??

Thanks!

[rocky]

1) Edit classes/Product.php and change line 156 (in PrestaShop v1.3.5) from:

protected $fieldsRequired = array('id_tax', 'quantity', 'price');

to:

protected $fieldsRequired = array('id_tax', 'quantity', 'price', 'weight');

This should make the weight a required field.

2) Use something like this:

UPDATE `ps_product` SET `weight` = 100 WHERE `id_product` = 1;
UPDATE `ps_product` SET `weight` = 200 WHERE `id_product` = 2;

You should be able to write a big SQL query to update individual product weights this way.

3) Yes, that's right.

[mytheory.]

As always tremendous thanks for the help, rocky!

By using that query I would still have to modify the product_id for each product... is there a for loop function (or something similar) for mysql queries?

Thanks again!

[rocky]

I think there might be a foreach loop, but I always use Boolean expressions in the WHERE clause, or remove it altogether to set the same weight to every product. You could use WHERE `id_product` >= 1 AND `id_product` <= 100 to set products 1 to 100 to the same weight.

[mytheory.]

Ok... that makes sense.

I'll give it a go on one of my test setups.

Thanks again!!