Skip to content

Share data

Why do we need data?

We use your catalog and order history data to prepare unique surveys for your customers. The responses we gather are used with millions of other data points to score purchases made by your customers with high accuracy and flag as many returns as possible. The survey does not ask any intrusive questions nor does it ask for any measurements. Instead, we build your stores predictions based on generic user answers, like what's your most common t-shirt size in your wardrobe today?

Before going live

If you have enough historical orders, we prepare a CSV file with unique survey links for all of your customers. This file is used in a campaign that is sent out by you using your mailing system (Klaviyo/Mailchimp/Omnisend/etc).

How to send your data

Regardless whether you’re sharing your historical data, or a daily update, please prepare the data file as follows:

  1. Compress the CSV file (zip would be best)
  2. Upload it to our SFTP server (Login details will be provided upon contact)

We take security and privacy of you, your customers, and your data very seriously and use highly secure SFTP (secure file transfer protocol) to secure your submissions. Details of our security can be found here

Data format

To simplify the extraction and handling the data should be separated into transactions and catalog.

In order for your data to be easily processed into our system, please ensure it contains the following fields, and that these fields conform to the noted specifications

  • Fields marked with * are required

    • Transaction data

    Column name Type Formatting Notes
    created_at* Strings YYYY-MM-DD hh:mm:ss in GMT time zone Example '2020-05-04 14:52:26'
    user_id* Strings Any Your internal id for customers
    order_id* Strings Any Your internal order id
    product_id* Strings Any Your internal id for the purchased product (will be a reference for the catalog)
    variant_title* Strings Any Variant of the purchased item (E.g Navy blue / Medium)
    price* Float Any Price of the item
    price_currency* Strings Any Currency of the price
    purchased_quantity* Strings Any Any additional attributes
    status* Strings Any Please let us know what statuses you track and what they represent
    return_reason Strings Any If applicable
    ... Strings Any Any additional transaction's attributes

    Catalog data

    Column name Type Formatting Notes
    product_id* Strings Any Your internal id for the purchased product
    product_sku Strings Any SKU of the product
    product_title* Strings Any A description of the product
    product_gender* Strings male, female, unisex or Other Gender of the purchased item
    product_brand* Strings Any Brand of the product
    product_category* Strings Any Category of the product (if several please separate with a delimiter. Please use different delimiter from the rest of CSV file or escape this field.)
    product_fit Strings Any Fit of the product (loose, tight, etc.)
    product_image* Strings URL URL for the product's image
    product_options* Strings Any The main options we are interested are product sizes, however you can share all of them if that's easier on your side. (This can be formatted as, but is not limited to: Size:S,M,L;Colour:White,Red; etc. Please use different delimiter from the rest of CSV file or escape this field.)
    ... Strings Any Any additional product attributes