---
title: Export for Shopping.com
description: "To add a new query: From your Admin Area, go to Inventory > Import/Export. Click the Saved Exports tab."
---
[Skip to content](https://help.volusion.com/s/exportforshoppingcom#main-content)
English - United States
Show submenu for translations
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 Shopping.com
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**: Shopping.com
**qb\_querytype**: Select
**qb\_export\_filetype**: CSV
**qb\_query**:
```
SELECT
'Config_FullStoreURLProductDetails.asp?ProductCode=' +
p.ProductCode + '&click=71' AS "Product URL"
,p.ProductName AS "Product Name"
,pd.ProductDescription AS [stripHTML-"Product Description"]
,pe.upc_code AS upc
,pe.ProductManufacturer AS Manufacturer
,'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-2.jpg' AS "Image URL"
,pe.ProductWeight AS "Shipping Weight"
,pe.ProductPrice AS Price
,p.ProductCode AS MPN
,'Y' AS Stock
,ShoppingDotCom_Category AS Category
,pe.ProductCondition as Condition
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')
ORDER BY p.ProductCode
```
**Configuring Your Products**
The next step is configuring your products to be exported. You will need to assign a **Shopping.com Category** to the products you want included in your export.
1. From your Admin Area, go to **Inventory** \> **Products**.
2. Select the **Product Code** you wish to edit.
3. Under **Advanced Info** \>**3rd Party Integrations,** make your selection from the **Shopping.com** **Category** drop-down and click **Save**.
Once you've added the export and assigned a Shopping.com category to your products, you can at any time go to the **Inventory** \> **Import/Export** section, select **Saved Exports** and export the desired information out to an export file (most commonly a CSV file) and use as needed.
- [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)
[](https://volusion.com/)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, Volusion