CSV files data feed
Document version 3.8.2
DATA FLOW INTEGRATION GUIDE
This guide depicts all the data flow interfaces available on the Popsell platform through CSV files.
Depending on data flows, they can be :
imported into the Popsell platform,
or exported from the Popsell platform.
Data flows can be :
triggered manually via the Popsell Manager,
or programmatically every night, between 4 AM and 5:30 AM C.E.T. In that case, CSV files are uploaded on an FTP folder located on a Popsell server, or on another FTP server provided.
Web services can also be used for data exchange, please refer to the specific guides.
File format is CSV, UT8 encoded, delimiter is comma (,) or semicolon (;)
First line always contain the column labels (first line ignored during import)
Date format is “YYYY-MM-DD HH:MM:SS” or “YYYY-MM-DD”
String values must be surrounded by double quotes if they may contain the delimiter. The escape character is backslash.
Recommended file name is [file-name]-YYYYMMDD-[seq].csv
File-name identifies the type of data (eg: contacts)
Seq is a sequential used to order the files is more than one is to be uploaded every day
Folder structure : one subfolder for each type of file
Brand ambassadors [Export | Manual or Auto]
Folder and file name: AMBASSADORS
Popsell user id
Popsell unique promoter’s identifier
Customer’s unique ID
1 if user is active, 2 if user is an administrator, 0 otherwise
M or F
1 if user has unsubscribed, 0 otherwise
Number of external posts created
Current score in the gamification program
Registering white list [Import | Manual]
The list of authorized users to get registered into the Popsell Platform.
All the records are appended to the database.
Customer’s unique ID or customer’s email address
Ambassadors’ contacts [Import | Manual or Auto]
Folder and file name: CONTACTS
Contacts with email addresses are imported into the Popsell CRM database. They are linked to an ambassador according to its customer ID. Contact ID is used as the key to identify the record updates.
Ambassador’s unique ID
Contact’s unique ID
String – email address
M or F
String - Comments
String - Address line 1
String - Address line 2
String Home phone
String Mobile Phone
true or false
1 if contact record has been deleted
String : fr_FR (can be null)
Format “YYYY-MM-DD HH:MM:SS”
Integer : Type of contact
4: Sales representative
Note: extra data and tags cannot be imported through CSV files, but only using the web service. Please refer to the web service documentation.
Products and product categories [Import | Auto]
Folder and file name: PRODUCTS
Product flow also creates corresponding product categories if category name is not found
Category name *
Name of category. Displayed as a tab in the front office UI
Label of category. Displayed as a sticker on the product frame when categories are combined in the front office UI [Optional]
Used when categories are displayed as an image. Link to a category page on the ecommerce site [Optional]
Category start date
Category end date
Category image url
Used when categories are displayed as an image [Optional]
Product ref *
Unique Product reference (If not unique, need to combine with SKU)
Product label *
Product image url *
Payment requests [Export | Manual or Auto]
Folder and file name: PAYMENT_REQUESTS
Payment requests are issued by ambassadors (requested manually or automatically via the gamification program). They are created in a “PENDING” status.
If exported manually, all the PENDING requests are exported.
If exported programmatically, all the PENDING requests issued for more than 5 days are issued. This delay enables the administrators to check for fraud or misbehaviour.
Ambassador’s customer ID
Payment amount requested
Popsell request ID
Payment requests confirmation [Import |Auto]
Folder and file name: PAYMENT_PROCESSED
Once payment requests have been processed, a result file must be created. The requests will be marked as “PAYMENT PROCESSED”, and a confirmation email will be sent to the promoter. If provided, an activation code will be sent in the email (to be entered by the promoter while processing an order).
Request Id *
Popsell request ID
Points of sale [Import | Manual]
A list of point of sales (stores) can be imported from the Popsell Manager.
POS Identifier (Brand POS ID)
POS Type [Optional]
Store name [Optional]
Store description [Optional]
Store hours [Optional]
Address street 1 [Optional]
Address street 2 [Optional]
City [Optional but recommended]
Post code [Optional]
Phone 1 [Optional]
Phone 2 [Optional]
For any support, or any specific demand, please contact Popsell at: email@example.com