Volusion Source Data Export

Volusion Source Data Export

Supported Files

When Volusion is selected with File Upload, the standard Source file set is:

Entity	Expected filename
Global	ExchangeRates.csv
Tax	Tax.csv
Category	Categories.csv
Product	Products.csv
Category	OptionCategories.csv
Product	Options.csv
Product	KITS.csv
Product	KITLNKS.csv
Product	ProductImages.csv
Customer	Customers.csv
Order	Orders.csv
Order	OrderDetails.csv
Order	TrackingNumbers.csv
Review	Reviews.csv

Do not add unsupported entity files

Data outside this list requires an approved Custom Service scope. Preserve the expected filenames and the platform export structure shown for the selected Source setup.

Volusion file-based migration uses STANDARD EXPORT for the main source tables. If the store has more than one image per product, also create the ProductExport saved query so the migration package includes the product image URLs that Next-Cart needs to process those images.

Export each required table separately

Keep every generated CSV unchanged. Customer and Order exports can contain sensitive information, so store them securely.

Export the source data

Export the standard Volusion tables

1. Sign in to Volusion.

2. Go to Inventory > Import/Export and open STANDARD EXPORT.

   

3. In Export From, choose the table to export.

4. Under Columns, select Check All.

5. For File Format, choose CSV - Comma Delimited Text File.

6. Click Export, then click Download in the pop-up when the export is ready.

   

7. Repeat the process for the data areas required by the migration. Export the following tables ExchangeRates, Tax, Categories, Products, OptionCategories, Options, KITS, KITLNKS, Customers, Orders, OrderDetails, TrackingNumbers, and Reviews.

Export product image URLs

When the Volusion store has more than one image per product, create the ProductExport saved query and export its result as a separate CSV. The query generates the product image URL columns that must accompany the other Volusion source files.

Go to Inventory > Import/Export > Saved Exports, then click Add New Query. Configure the saved query with these exact values:

Field	Value
QB Customer ID	0
QB Table	DB_EXPORT
QB Title	ProductExport
QB Query Type	SELECT
QB Export File Type	CSV

In QB Query, paste the following query exactly:

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

After the fields and query are complete:

1. Select Save to create the saved query.

2. Return to Inventory > Import/Export > Saved Exports. In Saved Queries, choose ProductExport.

3. For File Format, choose CSV - Comma Delimited Text File, then select Export.

4. When the export completes, select Download. Keep the downloaded Product image URL CSV with the rest of the Volusion export package and prepare that supported upload file as ProductImages.csv.

Include the ProductExport CSV with the migration files

Upload the Product image URL CSV together with the other Volusion CSV files when product images are part of the migration. Do not rename its columns or modify the saved query unless Next-Cart specifically instructs you to do so.

Verify the export

Confirm that:

• every required standard table was exported with all columns;
• each CSV opens without structural errors;
• ProductExport is included when the store has more than one image per product; and
• the Product image URL CSV contains Unique Retailer SKU plus the expected Image URL columns.

If the export is incomplete

• Re-run only the affected standard export after checking the selected table and columns.
• If ProductExport is missing, create the saved query using the exact field values and SQL above, then export it again.
• If a generated file is empty or unreadable, create a fresh export instead of editing the file manually.
• If a required data area remains unavailable, stop before substituting another file and submit a support ticket with the platform, missing data area, and export option you used.
• After correcting the export, repeat the verification checks before upload.

Next Steps

Continue with Upload Source Data Files to prepare and validate the exported files for the Source connection.