BASIC PRODUCT DATA FEEDS
The basic integration covers both apparel and home furnishings with Shoptelligence. We require a daily product feed. All feeds are transmitted via SFTP using a username/password combination with pem/ssh keys available on request.
Shoptelligence accepts feeds in multiple formats such as JSON, CSV, TAB, XML and others.
FEED REQUIREMENTS
*Note: We only accept alphanumeric, hyphens, or underscores in the item_ids. No special characters.
Files must be flat and cannot contain tabs.
Please avoid double double code or single double code. Such as “” “” or ” ‘ or multiple commas (there should only be one item per row but a comma would mean there are more, so please avoid multiple commas!)
DAILY FEED REQUIREMENTS
Feed 1
Field | Field Format | Notes |
sku | varchar | |
category | varchar | Standard e-com taxonomy |
title | varchar | |
description | varchar | |
vendor | varchar | E.G. Ashleys, Coaster, Mitchell Gold, etc. |
image url | varchar | Must be full image URL path |
inventory status | varchar | If not included, assumed to be in stock. |
regular price | decimal | |
sale price | decimal | |
review quantity and rating | array[object] | Optional, but strongly encouraged. |
product url | varchar | Product detail page url. |
Feed 2 (only use if multiple warehouses are identified – most clients can skip this feed)
If an item is available in multiple locations, multiple rows will need to be generated.
FEED TRANSMISSION (SFTP)
Item | Notes |
username | |
password | |
IP address | sftp.shoptelligence.com |
port | 22 |
notes | Please use the Folder: uploads |