Send product data to LoudCrowd
Product data is an important part of the LoudCrowd Creator Storefronts solution. This data is used to recommend products for your influencers to choose to add to their storefront collections as well as tag in their UGC media.
If your e-commerce system is set up on Salesforce or Shopify, we have pre-built integrations that can pull this data via an API connection. However, other systems will need to send us a regularly update product file and, possibly, a product pricing file.
Setup Product Feed
The product feed file can be uploaded to LoudCrowd via SFTP.
Your team can either drop the file to our hosted sftp server, or LoudCrowd can periodically pull a file from a SFTP server you host.
If you do not have an SFTP integration setup on your account please contact your LoudCrowd representative so it can be setup for you.
We recommend a daily file since products can change often.
This file should include both standalone products and product variants.
For translations of title and PDP URLs, add multiple rows for the same variant but different translations and locale data (language, country).
Product feed update behavior
NOTEThe product feed considers the sent .csv file as a full set of your product catalog.
This means, in particular, that any product that might have been sent and included in a prior file but is not included in a newer one will be marked as inactive, and its data will be made unavailable.
You cannot use the product feed incrementally (i.e., send a file with just new products); you must always send the full catalog.
Product field guide
We recommend a .csv file with the following data fields:
| Field | Description |
|---|---|
| productId | This is the ID or SKU of the product in your system. |
| parentId | If this row is a product variant, the ID or SKU of the parent product should match the productId field. LoudCrowd will use this field to group variants under a product. If a product is a parent or standalone product, this field should match the productId field. |
| position | For variants, this field determines the display order, starting at 1. Set to 0 for parent or standalone products. Note that variants must come immediately after the parent product on the CSV file rows. |
| brand | The brand of this product. |
| title | This is the title used to display the product. |
| active | (Y, N) whether or not the product is currently being sold. |
| URL | The URL is the link to this product's detail page, which will be used to direct buyers to the products from the creator storefronts. |
| imageSrc | URL of a product or variant image. If a product or variant has multiple images, repeat the row with the same product details, changing only the URL for each image. These images will be used for both picking and displaying products and variants in creator storefronts |
| language | The locale language, the title, product URLs, and options are written in. ISO 639-1 (alpha2) two-letter format. Required only for translations. |
| country | The locale region to refine the language further for the title and product URL. ISO 3166-1 (alpha-2) two-letter format. Optional for translations. |
| listPrice | the regular price of the product, this will display as a struck-through price in favor of the sale price |
| salePrice | the currently discounted price of the product, if same as the list price, only one will be displayed |
| currencyCode | this is the currency of the prices for this product |
| availability | (in stock, out of stock) used to hide products that are currently out of stock |
| option1Name | The name/title of the first variant option, like Size or Color |
| option1Value | The value of the first variant option, like XL, or Blue |
| option2Name | The name/title of the second variant option, like Size or Color |
| option2Value | The value of the second variant option, like XL, or Blue |
| option3Name | The name/title of the third variant option, like Size or Color |
| option3Value | The value of the third variant option, like XL, or Blue |
Note: if there are more options for the product. See below
Example:
productId,title,active,imageSrc,brand,listPrice,salePrice,currencyCode,URL,availability,parentId,position
37637613,Photo Paper 2.3x3.4” (50 Pack)...,Y,https://media.example.com/is/image/product/7011637?wid=800,HP,47.99,50.99,USD,https://www.example.com/product/prd-7011637,in stock,7011637,0
47627781,"Portable Projector, 480p LED",Y,https://media.example.com/is/image/product/47627781?wid=800&hei=800,HP,387.99,387.99,USD,https://www.example.com/product/47627781/hp-mobile-portable-projector-480p-led-projector-for-home-office.jsp,in stock,47627781,0
58975778,"Portable Projector, 480p LED, Grey",Y,https://media.example.com/is/image/product/58975778?wid=800&hei=800,HP,387.99,387.99,USD,https://www.example.com/product/47627781/hp-mobile-portable-projector-480p-led-projector-for-home-office.jsp?color=grey,in stock,47627781,1
158975780,"Portable Projector, 480p LED, White",N,https://media.example.com/is/image/product/158975780?wid=800&hei=800,HP,387.99,349.99,USD,https://www.example.com/product/47627781/hp-mobile-portable-projector-480p-led-projector-for-home-office.jsp?color=white,out of stock,47627781,2
SFTP Drop Requirements for product feed
In order to drop files to our SFTP server, the connection has the following requirements:
Product Feeds with more than 3 variant options
In order to send more options for products, they will need to be in a seperate file. The file should have:
Setup Product Pricing Feed
Since pricing can change even faster than the product details themselves. Some clients elect to sent LoudCrowd a separate product price file. This is optional depending on your price structure and frequency.
Product pricing feed update behavior
Unlike the main product feed, the product pricing feed does incremental updates.
This means you don't need to send the full product catalog each time.
You can send smaller files with only the products that changed their prices or are now on sale (or for which their sale period ended so their salePrice needs to be cleared).
This ensures you can send these smaller files as soon as you need to, and they are processed quickly so that our system reflects the new prices.
Product pricing field guide
We recommend a .csv file with the following data fields:
| Field | Description |
|---|---|
| productID | this is the id or sku of the product in your system |
| listPrice | the regular price of the product, this will display as a struck through price in favor of the sale price |
| salePrice | the currently discounted price of the product, if same as the list price only one will be displayed |
| currencyCode | this is the currency of the prices for this product |
Example:
productId, salePrice, listPrice, currencyCode
123ABC, 100.00, 150.00, USD
456DEF, 103.00, 110.00, USD
789HIJ, 10.00, 11.27, USDSFTP Drop Requirements for product pricing feed
In order to drop files to our SFTP server, the connection has the following requirements:
- SSH Public keys in the form RSA, ECDSA, or ED25519
- The file will need to be dropped into a directory named /prices
- File should be a .csv, .tsv, or .json file
Updated 6 months ago