Thread: SQL query to auto fill 'actual cost' info in Admin section for product variants

If this is possible, maybe someone knows how to accomplish this and/or write the SQL query:

We have approx. 700 items on our website. In the variant section for all products (no variant for any product is the same), we would like to fill in the "actual cost" line with the same number that is in the "price" line.

Is there a way to accomplish this with some type of SQL query? Maybe by another way?

To type the information by hand for 700 + products will be very time consuming and we are looking for a shortcut.

Any help is appreciated.

Thank you.

The query looks like this :-

C#/VB.NET Code:

UPDATE ProductVariant SET Cost = 12.34 WHERE VariantID = 333;
UPDATE ProductVariant SET Cost = 25.29 WHERE VariantID = 334; 


You can create these easily in excel, then it's just a quick copy & paste job (you can do them all at one go).


TTFN

BFG

Thank you. I was hoping to be able to accomplish this with one command that would automatically fill in the "actual cost" field of each variant with whatever info was in the "price" field.

Is that something that can be done? One command?

Sorry - I misread...

This will do it :-

C#/VB.NET Code:

UPDATE ProductVariant SET Cost = Price; 


TTFN

BFG

Thank you! Worked perfectly! You just saved me hours of work...