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 job
  • Name: Internal name of the file export job for users to add additional context
  • Admin User: User that requested the file export
  • Files Requested: List of each file requested (Catalog Enrichment File, Inventory File, or Pricing File)
  • Upload Time: The time when the file export is requested
  • Status: 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 context
  • Files: 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 Exportbutton 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