---
title: Saved Export for Products Table
description: To created saved exports for products, go to Inventory > Import/Export > Saved Exports and then click Add New Query.
---

[Skip to content](https://help.volusion.com/s/savedexportforproductstable#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)

# Saved Export for Products Table

**Saved Export for Products Table**

To created saved exports for products, go to **Inventory** \> **Import/Export** \> **Saved Exports** and then click **Add New Query**.

**QB\_CustomerID**: 0  
**QB\_Table**: DB\_Export  
**QB\_Title**: Products  
**QB\_QueryType**: SELECT  
**QB\_Export\_FileType**: CSV  
**QB\_Query**:

SELECT  
ProductCode,  
Vendor\_PartNo,  
ProductName,  
DisplayBeginDate,  
DisplayEndDate,  
HideProduct,  
StockStatus,  
LastModified,  
Options\_Cloned\_From,  
Photos\_Cloned\_From,  
Share\_StockStatus\_With,  
LastModBy,  
IsChildOfProductCode,  
IsChildOfProductCode\_ProductID,  
Options\_Cloned\_From\_ProductID,  
Photos\_Cloned\_From\_ProductID,  
Share\_StockStatus\_With\_ProductID,  
ProductPopularity,  
HomePage\_Section,  
AutoDropShip,  
DoNotAllowBackOrders,  
ProductDescriptionShort,  
ProductDescription,  
UPC\_code,  
ProductKeywords,  
ProductNameShort,  
ProductWeight,  
FreeShippingItem,  
MinQty,  
MaxQty,  
RecurringStartPrice,  
RecurringStartDuration,  
RecurringPrice,  
RecurringHowOften,  
RecurringDuration,  
AllowPriceEdit,  
ProductPrice,  
ListPrice,  
SalePrice,  
TaxableProduct,  
SelectedOptionIDs,  
GiftWrapCost,  
(Select top 1 p.ProductName from Products\_Joined inner join accessories a on p.productid = a.AccessoryProductID  
where p.ProductID = a.AccessoryProductID) AS Accessories,  
DownloadFile,  
Availability,  
METATAG\_Title,  
METATAG\_Description,  
DiscountedPrice\_Level1,  
DiscountedPrice\_Level2,  
DiscountedPrice\_Level3,  
DiscountedPrice\_Level4,  
DiscountedPrice\_Level5,  
Photo\_SubText,  
Photo\_AltText,  
DiscountedRecurringPrice\_Level1,  
DiscountedRecurringPrice\_Level2,  
DiscountedRecurringPrice\_Level3,  
DiscountedRecurringPrice\_Level4,  
DiscountedRecurringPrice\_Level5,  
Fixed\_ShippingCost,  
Fixed\_ShippingCost\_Outside\_LocalRegion,  
Uses\_Product\_KeyTypes,  
Price\_SubText,  
Price\_SubText\_Short,  
ListPrice\_Name,  
ProductPrice\_Name,  
SalePrice\_Name,  
Hide\_YouSave,  
Hide\_FreeAccessories,  
SetupCost,  
SetupCost\_Name,  
DiscountedSetupCost\_Level1,  
DiscountedSetupCost\_Level2,  
DiscountedSetupCost\_Level3,  
DiscountedSetupCost\_Level4,  
DiscountedSetupCost\_Level5,  
SetupCost\_Title,  
StockReOrderQty,  
warehouses,  
Affiliate\_Commissionable\_Value,  
AddtoCartBtn\_Replacement\_Text,  
Book\_ISBN,  
ProductCondition,  
EstShip\_Ground,  
EstShip\_2ndDay,  
EstShip\_Overnight,  
CustomField1,  
CustomField2,  
CustomField3,  
CustomField4,  
CustomField5,  
ShoppingDotCom\_Category,  
Yahoo\_Category,  
Yahoo\_Medium,  
ProductManufacturer,  
Hide\_When\_OutOfStock,  
StockLowQtyAlarm,  
AddToPO\_Now,  
LastPO\_Qty,  
LastPO\_Date,  
HowToGetSalePrice,  
Inv\_Verify\_QtyOnHand,  
Inv\_LastVerified,  
EnableMultiChildAddToCart,  
Vendor\_Price,  
EnableOptions\_InventoryControl,  
PhotoURL\_Small,  
PhotoURL\_Large,  
Private\_Section\_Customers\_Only,  
Quickbooks\_Item\_Accnt,  
Quickbooks\_Item\_AssetAccnt,  
Quickbooks\_Item\_CogsAccnt,  
ProductFeatures,  
TechSpecs,  
ExtInfo,  
OrderFinished\_Note,  
METATAG\_Keywords,  
ProductDescription\_AbovePricing,  
CUSTOM\_METATAGS\_OVERRIDE,  
ProductCode AS ProductURL,  
ProductCode AS PhotoURL,  
(SELECT TOP 1 CategoryID FROM Categories\_Products\_Link CPL WHERE CPL.ProductID = p.ProductID ORDER BY ID) AS CategoryTree

FROM Products\_Joined p

If you don't want all the fields, you can remove corresponding column titles accordingly. If you'd like a more simplified version of this process, please see **[How to Create a Saved Export for Products](https://help.volusion.com/s/howtocreateasavedexportforproducts?hsLang=en-us)** .

- [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