Full Catalog Export
Overview
The Spresso Commerce system enables organizations to export their existing catalog, inventory, and pricing information easily via Foxtrot. Export enables organizations to:
- Ensure manual changes to variants or products are reflected in the catalog file to avoid overwriting
- Enable quick iterations of the catalog build-out during onboarding
- Reviewing variant pricing and inventory information across Fulfller Locations
Best Practices & Callouts
- Exports can be filtered to individual files, variants, and fulfiller locations
- Full exports are limited to once per day due to the large size and resource utilization of the job so use variant and fulfiller location filtering as much as possible
- File export files are stored on the SFTP so please work internally to share credentials
- Catalog Enrichment File Format: The CSV file export will include all available and optional field headers whether they are in use for the organization or not. It is recommended that any unused fields be removed before ingesting the updated files.
Catalog File Export Page
When a user navigates to the Catalog File Export page, the page displays all previous file export jobs with the following columns:
Job ID
: Internal ID of the file export jobName
: Internal name of the file export job for users to add additional contextAdmin User
: User that requested the file exportFiles Requested
: List of each file requested (Catalog Enrichment File, Inventory File, or Pricing File)Upload Time
: The time when the file export is requestedStatus
: Indicates the status of file request (New, In-Progress, Successful, Failure)Download
: Link to the SFTP to receive exported files
Catalog File Export: Create New
At the top left corner of the page, there is a button to Create a New Export Job. Steps to create new:
Details Tab
Name
: Internal name of the file export job for users to add additional contextFiles
: Select the file(s) you wish to export:Catalog Enrichment
,Inventory
,Pricing
Variants Tab
Use the available options to add the variants you'd like to export.
Specific Variants:
Add Variants by CSV
Add by Brand
Add by Product
All Variants: Select the Export All Variants checkbox
FulfillerLocations Tab
To target specific fulfiller locations, use the search box to add all applicable fulfiller locations or to select all use the Export all Fulfiller Locations
checkbox
Save & Export Files
- Click the
Save and Export
button in the top left corner to save and execute the export job. - You will be redirected to the list view page while the job is processing
- Refresh the page to view the latest status.
- Once the job is completed, the
Download
button will be enabled for you to download the files locally from the SFTP
Updated about 1 month ago