Jump to content

Trying To Get The Following Fields With A Select


Recommended Posts

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?





Link to comment
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...