mySQL Query of all Products

4 Oct 2011, 1:32 PM

keitex

New Zenner

Join Date:: Nov 2010
Posts:: 11
Plugin Contributions:: 0

mySQL Query of all Products

Hi,

I need to create a query which will give me back all the products with details of

ID
TITLE
DESCRIPTION
PRODUCTTYPE
LINK
IMAGELINK
CONDITION
AVAILABILITY
PRICE
BRAND
GTIN
MPN
SHIPPING
SHIPPINGWEIGHT

I have managed to get a few of those fields but I cannot find the rest like condition and product link. Could someone help me please?

5 Oct 2011, 1:25 AM

rodg

Deceased

Join Date:: Jan 2007
Location:: Australia
Posts:: 6,263
Plugin Contributions:: 4

Re: mySQL Query of all Products

Some of the fields you mention simply don't exist, and not all the others exist in the same table, which means you'll need to use foreign keys to retrieve the relational data.

Not difficult to do, but I seriously doubt that anyone here is going to do it for you.

Cheers
Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.