Table of Contents

    Table of Contents

      Share On

      X IconLinkedIn IconFacebook Icon
      HomeRelease NotesBulk Return To Sender (RTS) Order Creation In OMS

      Bulk Return To Sender (RTS) Order Creation In OMS

      Learn how to create multiple Return to Sender (RTS) orders in Omniful OMS using bulk CSV upload, including step-by-step instructions and sample sheet details.

      Version: v1.0
      Date: 2025-12-04
      Owner: Omniful Product Team

      Summary

      The new Bulk Return to Sender (RTS) feature in the OMS allows users to quickly create multiple RTS orders at once using a CSV file upload. From the Return to Sender module, users can choose the Bulk option, select the seller, choose whether the items are QC Passed or QC Failed, and specify who the items should be returned to (such as the seller or supplier). After downloading and filling the sample file, users upload it to generate multiple RTS orders in a single action. Once created, the orders appear in Live Orders, where users can open them, review the details, and download the same reference file used during creation. This helps streamline the RTS workflow, especially when dealing with many items or multiple SKUs.

      How It Works

      1. Navigate to Orders → Create Order → Return to Sender module.
        RTS1.png
      2. Select the Bulk creation option. RTS2.png
      3. Choose the Seller for whom the RTS orders will be created. RTS2.png
      4. Select whether the items are QC Failed or QC Passed. RTS3.png
      5. Choose the return recipient — Seller, Supplier, or Someone Else. RTS4.png
      6. Download the sample file and fill in the required item details.
        RTS5.png
      7. Upload the completed file.
        RTS6.png
      8. Click Create Order to generate RTS orders in bulk.
        RTS7.png
      9. Successfully created orders will appear in Live Orders, and the reference file can be downloaded. RTS8.png

      Sample Sheet Columns Overview

      ColumnExplanation
      order_numberUnique RTS order number.
      Example: RTS-01
      seller_sku_codeSKU code exactly as defined in Omniful.
      Example: SKU01
      quantityUnits being returned; must be positive integers.
      totalLine total = quantity × unit_price.
      currencyISO currency code (e.g., SAR, AED).
      payment_statusprepaid or postpaid.
      delivery_typeType of delivery mode.
      Example: normal, express.
      supplier_codeExact supplier code present in Omniful (Supplier RTS only).
      recipient_nameName of the recipient (Other RTS only).
      Example: Abdullah
      shipping_addressAddress of the recipient (Other RTS only).
      Example: 123 Main Street
      shipping_cityCity of the recipient (Other RTS only).
      Example: Riyadh
      shipping_country_codeCountry code of the recipient (Other RTS only).
      Example: SA
      shipping_countryCountry name of the recipient (Other RTS only).
      Example: Saudi Arabia
      shipping_regionRegion of the recipient (Other RTS only).
      Example: SA
      recipient_country_calling_codeCountry calling code.
      Example: 966
      recipient_phonePhone number of the recipient (Other RTS only).
      recipient_emailEmail of the recipient (Other RTS only).
      tax_inclusiveTRUE/FALSE — whether unit_price includes tax.
      unit_pricePrice per SKU unit.
      tax_percentApplicable tax percentage.
      reference_order_idReference order ID for traceability.
      order_noteOptional remarks about the order.
      Example: QC failed.

      Technical Details

      • Multiple RTS orders can be generated in a single upload.
      • Each RTS order may contain multiple SKUs.
      • The reference file uploaded during bulk creation remains available for download under Order Logs in the Order Details side sheet.
      • The system validates uploaded rows and creates RTS orders accordingly.

      Notices

      © 2025 Omniful. All Rights Reserved.
      For more information, visit Omniful.ai