1. Home
  2. FAQ
  3. Shopping Cart Questions
  4. Volusion
  5. How to export product images from Volusion?

How to export product images from Volusion?

Getting ready to pull the trigger but you don’t see ProductImages.csv that you can export from Volusion? Different to other data types, product images can only be exported using a custom query. In this article, we will guide you how to export it:

  1. Log in to Volusion admin and go to Inventory > Import/Export > Saved Exports. Then click Add New Query.Volusion export product images
  2. Fill in the form with the following information:
    • QB Customer ID: 0
    • QB Table: DB_EXPORT
    • QB Title: ProductExport
    • QB Query Type: SELECT
    • QB Query: (copy the query below and paste into the field)

      SELECT
      p.ProductCode AS 'Unique Retailer SKU'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-2.jpg' AS 'Image URL 1'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-3.jpg' AS 'Image URL 2'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-4.jpg' AS 'Image URL 3'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-5.jpg' AS 'Image URL 4'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-6.jpg' AS 'Image URL 5'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-7.jpg' AS 'Image URL 6'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-8.jpg' AS 'Image URL 7'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-9.jpg' AS 'Image URL 8'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-10.jpg' AS 'Image URL 9'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-11.jpg' AS 'Image URL 10'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-12.jpg' AS 'Image URL 11'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-13.jpg' AS 'Image URL 12'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-14.jpg' AS 'Image URL 13'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-15.jpg' AS 'Image URL 14'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-16.jpg' AS 'Image URL 15'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-17.jpg' AS 'Image URL 16'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-18.jpg' AS 'Image URL 17'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-19.jpg' AS 'Image URL 18'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-20.jpg' AS 'Image URL 19'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-21.jpg' AS 'Image URL 20'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-22.jpg' AS 'Image URL 21'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-23.jpg' AS 'Image URL 22'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-24.jpg' AS 'Image URL 23'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-25.jpg' AS 'Image URL 24'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-26.jpg' AS 'Image URL 25'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-27.jpg' AS 'Image URL 26'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-28.jpg' AS 'Image URL 27'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-29.jpg' AS 'Image URL 28'
      , 'Config_FullStoreURLConfig_ProductPhotosFolder/'
      + p.ProductCode + '-30.jpg' AS 'Image URL 29'

      FROM Products p
      INNER JOIN Products_Descriptions pd ON
      p.ProductID = pd.ProductID
      INNER JOIN Products_Extended pe ON
      pd.ProductID = pe.ProductID

      ORDER BY p.ProductCode

    • QB Export File Type: CSV
  3. Click Save.
  4. Go to Inventory > Import/Export > Saved Exports. Choose “ProductExport” from the Saved Queries drop down, then choose “CSV – Comma Delimited Text File” from the File Format dropdown. Then click Export button.
  5. Once the export process is done, a pop-up will display with the Download button. Hit the button. A CSV file will be downloaded to your computer with all image URLs of your products.Volusion export product images

***Note: If you are moving data from your Volusion store to another e-commerce platform, please upload the CSV of product images along with other CSV files to get all product images downloaded to the new store.

Updated on May 19, 2022

Was this article helpful?

Related Articles