Exporting for Bizrate/Shopzilla is a fairly easy task. Just follow these simple steps and you'll be good to go!
- From your Admin Area, go to Inventory > Import/Export.
- Click the Saved Exports tab.
- 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: Bizrate / ShopZilla
qb_querytype: Select
qb_export_filetype: TAB
qb_query:
SELECT
pe.ShoppingDotCom_Category AS Category
, pe.ProductManufacturer AS Mfr
, p.ProductName AS Title
, pd.ProductDescriptionShort AS [stripHTML-description]
, 'Config_FullStoreURLProductDetails.asp?ProductCode='
+ p.ProductCode + '&click=71' AS URL
, 'Config_FullStoreURLConfig_ProductPhotosFolder/'
+ p.ProductCode + '-2.jpg' AS "Image URL"
, p.ProductCode AS SKU
, p.StockStatus AS "Stock"
, pe.ProductCondition AS "Condition"
, pe.ProductWeight AS "Ship Weight"
, pe.EstShip_Ground AS "Ship Cost"
, '' AS Bid
, '' AS "Promo Text"
, '' AS UPC
, pe.ProductPrice AS price
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')
AND (pe.ProductPrice > 0 AND pe.ProductPrice IS NOT NULL)