Trying To Get The Following Fields With A Select

[rseigel]

I'm trying to write a SELECT that grabs the following fields:

 

- product.reference

- sale price (the only way I can see to get this is to subtract the reduction amount from the retail price)

- quantity

- EAN13 (I'm using this to store the ASIN # for Amazon)

- product id type (this will ALWAYS be ASIN so I just need a way to hard code it in the SELECT

- condition type

 

I know the SELECTs will be different depending on whether it's a simple product or combination product.

 

Anyone have any experience with this that can help?

 

Thanks,

 

Ron