sql help (joins i think)

Code: Select all

/*
 * Product Download Query
 * 
 * This query is responsible for fetching all products from your website.
 * 
 * It should return all products that you want to send to StoreFeeder.
 * 
 * Required fields are sku, name and price_ex_vat. Other fields also have to be present in
 * the output of the query, but may be left empty (see example in the comments 
 * to the Orders Query about empty fields).
 * 
 * Note that you can 'hardcode' some of the fields, e.g. you could enter:
 * 
 * ... 'Default Warehouse' as 'warehouse'...
 * if you want all your products to be assigned to the 'Default Warehouse' inside StoreFeeder
 * 
 */
$productDownloadQuery = "SELECT 
`product.[sku]` AS 'sku',
` product_description.name` AS 'name',
`` as 'description',
`product.[price]` as 'price_ex_vat',
`vat_percent` as 'vat_percent',
`` AS 'rrp',
`` as 'cost',
`` as 'weight',
`` AS 'mpn',
`` as 'supplier',
`` as 'warehouse',
`` as 'inventory',
`` as 'ean',
`` as 'upc',
`` as 'image_url',
`` as 'website_url'
FROM product INNER JOIN product_description ON product.product_id = product_description.product_id";

Code: Select all

/*
 * Product Download Query
 *
 * This query is responsible for fetching all products from your website.
 *
 * It should return all products that you want to send to StoreFeeder.
 *
 * Required fields are sku, name and price_ex_vat. Other fields also have to be present in
 * the output of the query, but may be left empty (see example in the comments
 * to the Orders Query about empty fields).
 *
 * Note that you can 'hardcode' some of the fields, e.g. you could enter:
 *
 * ... 'Default Warehouse' as 'warehouse'...
 * if you want all your products to be assigned to the 'Default Warehouse' inside StoreFeeder
 *
 */
$productDownloadQuery = "SELECT
`product.[sku]` AS 'sku',
` product_description.name` AS 'name',
`` as 'description',
`product.[price]` as 'price_ex_vat',
`vat_percent` as 'vat_percent',
`` AS 'rrp',
`` as 'cost',
`` as 'weight',
`` AS 'mpn',
`` as 'supplier',
`` as 'warehouse',
`` as 'inventory',
`` as 'ean',
`` as 'upc',
`` as 'image_url',
`` as 'website_url'
FROM product INNER JOIN product_description ON product.product_id = product_description.product_id";

In each line of the query where there are backticks you need to fill in the appropriate field name from the opencart product table.... You're basically mapping your opencart fields to their field names/labels.

here's a couple of examples

`weight` as `weight`,
`image` as `image_url`,