Returns CSV integration

If you are unable to integrate returns through API, you may consider the following option: periodically send your Returns confirmations to Usizy in a CSV file.

This CSV file should use the same file type (.csv, .xls…) for each submission.

Files should be uploaded to a Google Drive folder that will be provided during the integration.

We recommend sharing a file at least once every two weeks.

💡

Please note that once a file has been collected by uSizy, it will be removed from the folder and you will need to update a new file for future returns, following the previously agreed template and format.

Essential variables

The CSV file must have a single row per product returned and include the following variables:

order_id

The order identifier must be identical to the one provided during the purchase confirmation.

product_ids

Each product identifier must be identical to the one provided during the purchase confirmation. If more than one product is returned within a single order, you should include one row per product and variation returned.

variation_ids

Each variation id must be unique for its corresponding specific item. It is recommended to use the SKU. If more than one product is returned within a single order, you should include one row per product and variation returned.

date

Date or date time of return event, format ISO 8601 (“2017-09-12” or “2017-09-12T15:48:02Z”).

💡

The date format must remain consistent for each row and for each file submitted for the integration to work. If your chosen date format is “yyyy-mm-dd”, it should not be changed later to “dd-mm-yyyy”, as this will generate errors within the automatic data collection process.

Recommended variables

reason

The reason for returning the product is essential to understand what type of returns are impacting your Ecommerce. Usizy reduces returns due to size error.

We recommend including the following reasons:

return due to size (“size ”)
other reasons ("other “)

💡

All returns due to size error must be indicated using the flag “size” only. If more than one value is included, they must be comma separated. If left blank, the associated return will not be considered as size error related, for the Dashboard KPIs. Custom keywords are accepted for reasons other than “size”.

fit

Confirms if the size purchased is too small (“small”) or too big (“large”). This field can be left blank if no information is available.

💡

The “reason” and “fit” variables are essential to benefit from Usizy Machine Learning and continuous service improvement.

ecomm_size

Size originally ordered during purchase. This variable is useful when multiple returns are requested for the same product within a single order.

Optional variables

size_changed

In case of a product exchange for a different size, the new size may be included in this field to improve machine learning.

return_cost

Total return shipping cost

currency

Currency used for return-cost

CSV file example

A typical CSV file can be viewed here: Returns csv example.csv

Returns CSV integration

Essential variables #

Recommended variables #

Optional variables #

CSV file example #

Essential variables

Recommended variables

Optional variables

CSV file example