Our platform allows you to manually upload and update your Quality Control status via a CSV file, making it easy to handle large volumes of data efficiently. This is especially useful for stores working with 3PL services that do not have API support.
Key Features
1. CSV Upload to Quality Control Tab
You can upload a CSV via Drag and Drop or by selecting a file. You can find an example CSV sheet at the bottom of the article.
Your CSV must contain the following fields:
Order number
Product SKU
Condition
Returned quantity
2. Field Mapping
Once uploaded, click Import data. You will need to map each Swap-required field (for example: QC Condition, SKU) to the correct column in your CSV using the dropdown menus.
Irrelevant columns can be set to Ignore this column.
All required fields must be mapped before you can continue.
When ready, click Import.
3. Conditions Handling
In this step you decide how provider states are translated into Swap conditions.
For each provider state, you can choose one of:
Missing
Damaged
Wrong item
Sellable
In the Quality Approved column, select whether the product is approved or not. This determines the RMA QA status.
4. Importing Data and Processing
When you click Start Processing:
The system checks your file for errors (for example, missing mandatory fields).
If errors are found, they are flagged on-screen so you can correct and re-upload.
If the file is valid, the data is imported and your RMA page is updated with the QC results.
5. CSV Results
Once the CSV is processed, results are displayed on the platform. You can view:
The original WMS (Warehouse Management System) data
The processed CSV data
Each order’s conditions are shown in an easy-to-read table.
Successful imports – show all relevant data, including updated conditions.
Failed rows – are highlighted, with an explanation so you can fix and reprocess them.
6. Manual and Automatic Processing
Manual Processing – WMS recommendations are shown on the RMA screen. You can review and decide how to handle each return.
Automatic Processing – Returns are processed automatically according to your predefined Quality Approved rules.
When QC is completed, the Sellable status is updated accordingly.
