Gist for product transfer from sql to airtable

airtable_item_vw.sql

SELECT   item.item,
        qty AS inventory_level,
        description,
        product_code,
        family_code,
        plan_code,
        unit_weight,
        weight_units,
        charfld1 AS upc,
        stat,
        RowPointer,
        Uf_fourthCategory AS fourth_category,
        Uf_LicenseeMark AS licensee_mark,
        Uf_itemMaster_CountryOrigin AS country_origin,
        Uf_Items_BaseSyle AS base_style,
        Uf_Items_Size AS item_size
FROM    item
JOIN    (
         SELECT item,
                SUM(qty_on_hand) AS qty
         FROM   dbo.itemwhse
         WHERE  qty_on_hand > 0
         GROUP BY item
        ) AS inv
ON      inv.item = item.item
WHERE   item.stat = 'a'
        AND inv.qty > 0
	AND item.product_code NOT IN ('PKG-100', 'RAW-300', 'RAW-200', 'RAW-500', 'RAW-100')
	AND item.family_code NOT IN ('RAW')
	AND item.item NOT like ('%U-%')