rseigel Posted February 22, 2013 Share Posted February 22, 2013 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 Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now