Need to export from your PriceGrabber account? Here are a few steps for you to get the job done:
To add a new query:
- 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. Now you can export the desired information out to an export file and use as needed!
p.ProductCode AS 'Unique Retailer SKU'
, p.ProductName AS 'Product Name'
, pd.ProductDescriptionShort AS [stripHTML-Detailed Description]
, pe.ProductCondition AS 'Product Condition'
, '' AS Categorization
, pe.ProductManufacturer AS 'Manufacturer Name'
, p.Vendor_PartNo AS 'Manufacturer Part Number'
, pe.UPC_code AS UPC
, pe.Book_ISBN AS ISBN
, pe.ProductPrice AS 'Selling Price'
, pe.ProductWeight AS 'Shipping Weight'
, pe.EstShip_Ground AS 'Shipping Cost'
, pe.Availability AS Availability
+ p.ProductCode + '&click=71' AS 'Referring Product URL'
+ p.ProductCode + '-2.jpg' AS 'Image URL'
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)
Note: The Categorization field needs to be manually populated into the spreadsheet after the data has been exported. This is because PriceGrabber wants this filled in with text preferably according to PriceGrabber.com's taxonomy (category hierarchy). Please see PriceGrabber.com for more information.
Depending on the type of business and products being uploaded, some of the fields in the query are optional. For a full list of required and optional fields, please see PriceGrabber's Data Feed Requirements chart.
Note on Image URLs: Please note that this export will report a URL for each product's image provided the following conditions are true:
- The product's main image exists - this is the product image labeled "productcode"-2.jpg (e.g. ABC123-2.jpg)
- The product is not hidden.
- The product is not a child product.
Any product that does not meet these conditions will not have a product photo URL provided through the above export.