RabbitLabs/droplet-next
5
0
Fork 0
Code Issues 73 Pull requests Projects 1 Releases Packages Wiki Activity Actions

CSV Import #7

New issue
Open
opened 2026-02-25 18:07:28 +00:00 by Vylpes · 0 comments
Vylpes commented 2026-02-25 18:07:28 +00:00
Owner
Copy link

Goal: Allow users to import Seller Hub listing CSV exports, with validation, preview, history, and rollback.

In scope (P0):

  • Import wizard: upload CSV → column mapping UI (persist mapping) → validation preview
  • Import summary: imported / updated / skipped / errors / unmapped counts
  • Downloadable errors CSV (row number + reason)
  • Import history log
  • Rollback last import (minimum viable safety)

Data handling:

  • Upsert key: Item number first; fallback composite (SKU + Title + Format + Variation details)
  • Error on missing Title or invalid Available quantity
  • Unmapped queue population for missing/blank SKU
  • Price derivation: fixed_price = Current price ?? Auction BIN price; warn if both blank
  • Tolerant of extra columns, different column order

Acceptance criteria:

  • Given a real Seller Hub export, import completes with deterministic results
  • Errors are actionable and traceable to row + column
  • Column mapping is persisted for future imports
  • Rollback reverts all records created/updated by the last import
**Goal:** Allow users to import Seller Hub listing CSV exports, with validation, preview, history, and rollback. **In scope (P0):** - Import wizard: upload CSV → column mapping UI (persist mapping) → validation preview - Import summary: imported / updated / skipped / errors / unmapped counts - Downloadable errors CSV (row number + reason) - Import history log - Rollback last import (minimum viable safety) **Data handling:** - Upsert key: Item number first; fallback composite (SKU + Title + Format + Variation details) - Error on missing Title or invalid Available quantity - Unmapped queue population for missing/blank SKU - Price derivation: `fixed_price = Current price ?? Auction BIN price`; warn if both blank - Tolerant of extra columns, different column order **Acceptance criteria:** - Given a real Seller Hub export, import completes with deterministic results - Errors are actionable and traceable to row + column - Column mapping is persisted for future imports - Rollback reverts all records created/updated by the last import --- - [ ] #34 - [ ] #35 - [ ] #36 - [ ] #37 - [ ] #38 - [ ] #39 - [ ] #40
Vylpes added this to the (deleted) milestone 2026-02-25 18:07:28 +00:00
Vylpes modified the milestone from (deleted) to 0.3.0 2026-03-02 17:26:34 +00:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
develop
release/0.1.0
No results found.
Labels
Clear labels
  
blocked

   
duplicate
  
needs
approval

  
needs
criteria

  
needs
estimate

  
needs
tests

  
question
  
type
admin

  
type
alert

  
type
bug

  
type
change

  
type
defect

  
type
dependencies

  
type
epic

  
type
idea

  
type
incident

  
type
investigation

  
type
spike

  
type
story

  
won't fix
No labels
blocked
duplicate
needs
approval
needs
criteria
needs
estimate
needs
tests
question
type
admin
type
alert
type
bug
type
change
type
defect
type
dependencies
type
epic
type
idea
type
incident
type
investigation
type
spike
type
story
won't fix
Milestone
Clear milestone
No items
No milestone
0.3.0
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
RabbitLabs/droplet-next#7
No description provided.