SFTP
SFTP Pricing & Availability Feed
DataVisual provides a daily inventory and pricing feed via SFTP. This is a read-only CSV file updated at 2 AM EST each day.
What You Get
A single CSV file containing your full product catalog with pricing and stock levels, refreshed daily.
File Format
- Format: CSV (Comma-Separated Values)
- Encoding: UTF-8
- Delimiter:
, - Header Row: Included
- File Name: Always
inventory.csv(replaced daily at 2 AM EST)
Column Definitions
| Column | Data Type | Description |
|---|---|---|
| Manufacturer | String | Manufacturer name |
| SKU | String | DataVisual SKU |
| Item Name | String | Product name |
| Short Description | Multi-line Text | Short description of the product |
| MSRP | Decimal | Manufacturer's Suggested Retail Price |
| Dealer Price | Decimal | Standard Dealer Purchase Price |
| Stock on Hand | Decimal | Quantity available in stock |
| Package Weight | Decimal | Weight of the package |
| Package Width | Decimal | Width of the package |
| Package Height | Decimal | Height of the package |
| Package Length | Decimal | Length of the package |
| UPC | String | Universal Product Code |
| Manufacturer SKU | Multi-line Text | Manufacturer's SKU |
New columns will always be added at the end of the file to prevent mapping issues.
Data Processing Guidelines
- Schedule retrieval after 2 AM EST to get the latest data
- Fields may be empty if data is unavailable
- Ensure correct decimal placement for currency fields
- Columns will always appear in the same order
Getting Connected
Log in to view SFTP connection details, credentials setup, and automation guides.
Support
For SFTP access issues, contact [email protected] (Monday - Friday, 9 AM - 4 PM EST).
Note: Support is limited to SFTP access issues. For system integration, data mapping, or pipeline development, please refer to our API documentation or EDI options.
Last modified on