I need to copy the price on a product to a "shadow" price field on the product.
the price in the DB is including vat.
doing this via the API is a pretty heavy process, getting a collection of all products, setting the shadow fields value = the product.price, and then saving each product.
I was thinking that with a pretty simple sql statement, this could be done, with a fraction of the resources and a lot faster, than by using the API.
As i was stating before, the price in the DB is including vat, there is only one currency, and there is no discounts.
And when 7.2 is released and stable, there is no need for the shadow field anymore, as searching in ranges will not be a problem anymore.
Is there any reason not to do the copy in a sql statement ?
/Kenneth
