Export existing products from store with export product feed
The Export Feed feature enables you to extract product and catalog data directly from your store and deliver it automatically to external destinations such as Google Sheets, FTP/SFTP, or accounting platforms. This simplifies catalog backups, warehouse reporting, supplier data sharing, and multi-channel inventory management.
Watch the Export Feed Walkthrough
Watch this step-by-step video guide to learn how to create and configure an export feed in Stock Sync.
How to Set Up an Export Feed
Go to App → Create new feed → Export
- Select Connection Destination: Search for and select the destination connection where your exported file should be sent (such as Google Sheets, FTP/SFTP, or QuickBooks).
- Configure Fields & Mapping: Set up the export fields you wish to include. If mapping by column position, enter the numerical column index (e.g.,
1for the first column,2for the second) instead of a column name. - Execute and Retrieve Export: Run the feed to generate and deliver the file to your configured destination. Access the file to verify product data using the SKU column as your unique reference identifier.
Export Feed Smart Settings
1. Connection Types & Destinations
Export feeds send your live catalog data to various external endpoints depending on your operational workflow.
Destination Type | Common Use Case | Configuration Notes |
|---|---|---|
Google Sheets | Real-time reporting, team collaboration, and shared inventory tracking | Requires connecting your Google account and selecting or creating a target spreadsheet. |
FTP / SFTP | Automated data pipelines, 3PL logistics sync, and supplier updates | Requires server host, port, username, password/key, and target directory path. |
QuickBooks | Accounting reconciliation, inventory valuation, and billing alignment | Requires account authorization to map inventory items. |
2. Field Mapping & Column Positioning
When defining the structure of your exported file, you can map store attributes to specific positions in the destination file:
Store Product Attribute | Mapping Method | Output Example / Notes |
|---|---|---|
| Column Index or Header | Master identifier used to reference items across external systems. |
| Column Index or Header | Product name as shown in your store admin. |
| Column Index or Header | Available live inventory level across tracked locations. |
| Column Index or Header | Active store selling price. |
1 for the first column.Key Rules & Technical Details
- Direct Catalog Extraction: Export feeds query and extract data directly from your store's database; therefore, source file matching logic is not required.
- Column Indexing Convention: When configuring column positions manually, use positive 1-based integers (
1,2,3, etc.). - Identifier Reliability: Always export the
SKUor product/variant ID if you plan to re-import the file into an Update Feed later.
Troubleshooting Steps
- Issue: Exported file is missing expected columns or data appears misaligned → Solution: Go to your export field mapping settings and verify that column index numbers are sequential and do not overlap.
- Issue: File fails to upload to destination (e.g., FTP or Google Drive) → Solution: Check destination credentials, confirm write permissions for the specified directory, and re-test the connection under Feed Settings.
Good Articles to Continue
- Matching Column (Step 2) Overview → Detailed guide on configuring field mappings and column positions across feeds.
- How to Set Up an Update Feed → Step-by-step instructions on updating existing store products using supplier files.
Updated on: 03/11/2026
Thank you!
