Articles on: Getting Started

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


  1. 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).
  2. Configure Fields & Mapping: Set up the export fields you wish to include. If mapping by column position, enter the numerical column index (e.g., 1 for the first column, 2 for the second) instead of a column name.
  3. 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.


You can use the exported SKU column as a reliable master key to prepare future Update Feeds or catalog bulk adjustments.



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

SKU

Column Index or Header

Master identifier used to reference items across external systems.

Title

Column Index or Header

Product name as shown in your store admin.

Quantity

Column Index or Header

Available live inventory level across tracked locations.

Price

Column Index or Header

Active store selling price.


When mapping export columns by position, always enter numeric indices starting at 1 for the first column.


Unlike Update Feeds, Export Feeds do not require incoming SKU matching because product data is extracted directly from your store.



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 SKU or product/variant ID if you plan to re-import the file into an Update Feed later.


Export feeds extract products directly from your store to external systems. Unlike Update Feeds—which require SKU matching to locate store products from an incoming supplier file—Export Feeds generate the data directly from your catalog.



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


Updated on: 03/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!