---
title: Export for PriceGrabber
description: Need to export from your PriceGrabber account?
---

[Skip to content](https://help.volusion.com/s/exportforpricegrabber#main-content)

English - United States

Show submenu for translations

![Volusion Logo](https://help.volusion.com/hs-fs/hubfs/Color_Logo_Horizontal.png?width=1500&height=1500&name=Color_Logo_Horizontal.png)

Open main navigation

Close main navigation

- English - United States
  
  Show submenu for translations
- [Contact Us](https://volusion.com/contact)

[Contact Us](https://volusion.com/contact)

 Search the Help Center

- There are no suggestions because the search field is empty.

1. [Volusion Help Center](https://help.volusion.com/s?hsLang=en-us)
2. [V1](https://help.volusion.com/s/v1?hsLang=en-us)

# Export for PriceGrabber

Need to export from your PriceGrabber account? Here are a few steps for you to get the job done:

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. Now you can export the desired information out to an export file and use as needed!

**qb\_customerID**: 0  
**qb\_table**: DB\_Export  
**qb\_title**: PriceGrabber  
**qb\_querytype**: Select  
**qb\_export\_filetype**: CSV  
**qb\_query**:

```
SELECT
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
, 'Config_FullStoreURLProductDetails.asp?ProductCode=' 
+ p.ProductCode + '&click=71' AS 'Referring Product URL'
, 'Config_FullStoreURLConfig_ProductPhotosFolder/' 
+ 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 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](https://www.pricegrabber.com/) for more information.

Depending on the type of business and products being uploaded, some of the fields in the query are optional. The following fields are required:

- **Product ID:** Unique identifier (SKU) for each item.
- **Title:** Descriptive product name.
- **Price:** Current selling price.
- **Description:** Detailed product description.
- **Image URL:** Direct link to the main product image.
- **Category:** Must map to PriceGrabber’s internal taxonomy.
- **Availability:** Current stock status.

*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.

- [Getting started](https://help.volusion.com/s/getting-started?hsLang=en-us)
- [Manage Your Store](https://help.volusion.com/s/manage-your-store?hsLang=en-us)
- [Marketing for Success](https://help.volusion.com/s/marketing-for-success?hsLang=en-us)
- [Volusion Payment Powered by Stripe](https://help.volusion.com/s/volusion-payment-powered-by-stripe?hsLang=en-us)
- [Partner Marketplace](https://help.volusion.com/s/partner-marketplace?hsLang=en-us)
- [Support](https://help.volusion.com/s/support?hsLang=en-us)
- [V1](https://help.volusion.com/s/v1?hsLang=en-us)
- [Security](https://help.volusion.com/s/security?hsLang=en-us)

[![Volusion Logo](https://help.volusion.com/hs-fs/hubfs/Color_Logo_Horizontal.png?width=1500&height=1500&name=Color_Logo_Horizontal.png "Volusion Logo")](https://volusion.com/)

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2026, Volusion