Connecting a data source
Šis saturs vēl nav pieejams jūsu valodā.
A data source is a connection to a supplier’s product catalogue. CatalogRelay fetches it, you map columns, and products update in your normalized catalogue.
Add a supplier
Section titled “Add a supplier”- Go to Suppliers → Add supplier
- Enter a Name and optional Notes
- Save
Add a data source
Section titled “Add a data source”On the supplier page, click Add data source, then choose a connection tab.
| Tab | Use when |
|---|---|
| HTTP / File | Direct download URL (CSV, XML, JSON) |
| FTP / SFTP | File on an FTP, FTPS, or SFTP server (SFTP recommended) |
| Paginated API | REST API that returns pages of products |
| Spreadsheet | Public Google Sheet or Microsoft Excel / OneDrive link |
HTTP / File
Section titled “HTTP / File”- URL must be
http://orhttps:// - Public, HTTP Basic, or Bearer auth
- Private / reserved IPs are blocked (SSRF protection)
FTP / SFTP
Section titled “FTP / SFTP”Enter host, credentials, and remote path to the feed file.
Paginated API
Section titled “Paginated API”Same auth options as HTTP, plus page parameter (default {pageNo}), start page, and max pages (default 50). The payload is still CSV, XML, or JSON.
Spreadsheet
Section titled “Spreadsheet”The sheet must be Anyone with the link → Viewer. Private OAuth sheets are not supported.
- Google Sheets — paste the share link; optional sheet
gidfor a specific tab - Microsoft Excel / OneDrive — share link must resolve to CSV (Publish to web → CSV). Native XLSX downloads are not supported
After save
Section titled “After save”CatalogRelay probes the feed (“Analyzing feed structure…”). Status moves to Mapping required, Connection failed, or Active.
- Map columns (SKU required)
- Save mapping — first import is queued
- Later: use Schedule import for a manual re-import (rate-limited)
Import schedule
Section titled “Import schedule”Tenants do not configure an import cron in the UI. Copy in the product explains that imports run automatically before each export cycle on paid plans.
| Plan behaviour | |
|---|---|
| Free | Manual only (Schedule import) |
| Paid | Automatic imports ahead of export cycles, plus plan daily caps per feed |
Inactive / over-cap feeds may be paused — see Billing in the app if syncs stop.
Mapping tips
Section titled “Mapping tips”- Modes: Map column, Fixed value, Map values (for availability the third mode is Rules: default status plus Or/And exception conditions)
- Availability Map column treats empty /
0/no/falseas out of stock and any other value as in stock. Use Rules for status phrases - Optional Custom Attribute Mappings for extras you defined under Data Mapping → Attributes
- XML may ask for a row element tag name
- Suggestions are keyword-based (not AI)
- Saving a mapping remaps existing products from stored raw data
Monitoring
Section titled “Monitoring”Open the data source / supplier for import status and product counts. Browse Products to inspect mapped fields, raw supplier attributes, and Effective values (priced / computed).