Cancellations CSV integration
If you are unable to integrate cancellations through API, you may consider the following option: periodically send your Cancellation 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.
Essential variables
The CSV file must have a single row per product cancelled and include the following fields.
order_id The order identifier must be identical to the one provided during the purchase confirmation.
product_ids
The product identifier must be the same as the one provided during the purchase confirmation. This variable may contain a single value or multiple ones (comma-separated), depending on the circumstances of the initial order.
variation_ids
The variation id must be unique for its corresponding specific item.It is recommended to use the SKU. If more than one product is cancelled within a single order, you should include a comma-separated list of variations, for each product cancelled within the specific order considered.
date
Date or date time of cancellation event, format ISO 8601 (“2017-09-12” or “2017-09-12T15:48:02Z”).
Recommended variables
ecomm_size
Size originally ordered during purchase. This field is useful when multiple cancellations are requested for the same product within a single order. The number of sizes included must match the number of products cancelled. If more than one product is cancelled, the values must be comma separated.
Cancellations CSV example
A typical CSV file can be viewed here: