Need to export for Nextag? No problem. To add a new query:

  1. From your Admin Area, go to Inventory > Import/Export.
  2. Click the Saved Exports tab.
  3. Click Add New Query and complete the required fields, as shown below.

Once you've added the export, it will be available in your Saved Exports when you need it - export the desired information out to an export file and use as needed.

qb_customerID: 0
qb_table: DB_Export
qb_title: Nexttag
qb_querytype: Select
qb_export_filetype: TAB
qb_query

SELECT

'Config_FullStoreURLProductDetails.asp?ProductCode='
 + p.ProductCode + '&click=71' AS url
, p.ProductName AS product
, pd.ProductDescription AS [stripHTML-product_description]
, pe.upc_code AS ProductDescriptionShort
, pe.ProductManufacturer AS mfr_name
, 'Config_FullStoreURLConfig_ProductPhotosFolder/'
 + p.ProductCode + '-2.jpg' AS ImageURL
, pe.ProductWeight AS "Shipping Weight"
, pe.ProductPrice AS Price
, p.ProductCode AS mfr_sku
, p.stockstatus AS in_stock

FROM Products p
INNER JOIN Products_Descriptions pd ON p.ProductID = pd.ProductID
INNER JOIN Products_Extended pe ON pd.ProductID = pe.ProductID

WHERE (p.IsChildOfProductCode is NULL
 OR p.IsChildOfProductCode = '')
AND (p.HideProduct is NULL OR p.HideProduct <> 'Y')
Did this answer your question?