csv-import

Import PSA, Shopify, and cert-based purchases into SlabLedger from CSV files.

Updated Mar 25, 2026
One-click install
npx skills add https://github.com/guarzo/slabledger --skill csv-import-guarzo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: csv-import
Source: https://github.com/guarzo/slabledger/tree/main/.claude/skills/csv-import
Command: npx skills add https://github.com/guarzo/slabledger --skill csv-import-guarzo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

CSV imports streamline bulk loading of card purchases into SlabLedger from PSA spreadsheets, Shopify exports, and direct cert entries, reducing manual data entry and errors.

Core Features & Use Cases

  • PSA Import: Use endpoint POST /api/purchases/import-psa with header detection and tolerant parsing. Supports fields like cert number, listing title, grade, price paid, date, etc.
  • Shopify Import: Endpoint POST /api/purchases/import-external; requires handle and title; cert resolution via cert number, cert, or sku; tag parsing; price fields; image handling; deduplication.
  • Cert Entry: Endpoint POST /api/purchases/import-certs; JSON body with certNumbers; dedup, etc. See references/csv-formats.md for detailed column requirements and example rows.

Quick Start

Prepare a CSV in the PSA, Shopify, or cert-entry formats and POST it to the appropriate API endpoint to begin importing.

Frequently Asked Questions about csv-import

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I import PSA spreadsheet data into SlabLedger from a CSV file?

To import PSA spreadsheet data into SlabLedger, prepare a CSV with fields like cert number, listing title, grade, and price paid, then POST it as a multipart file upload to the /api/purchases/import-psa endpoint for tolerant parsing and validation.

Can I import Shopify export CSVs into SlabLedger with cert resolution and tag parsing?

Yes, you can import Shopify export CSVs into SlabLedger by POSTing multipart file uploads to the /api/purchases/import-external endpoint, which requires handle and title fields and supports cert resolution via cert number, cert, or sku, plus tag parsing and deduplication.

What CSV column requirements does SlabLedger need for PSA, Shopify, and cert-based imports?

SlabLedger CSV column requirements vary by format: PSA imports need cert number, listing title, grade, and price; Shopify imports require handle and title with optional cert and sku fields; cert entries use a JSON body with certNumbers. See references/csv-formats.md for detailed examples.

Does the SlabLedger CSV import handle header detection and data validation errors?

Yes, the SlabLedger CSV import includes built-in header detection, tolerant parsing, and validation with error reporting across all three endpoints, ensuring bulk loading of PSA spreadsheets, Shopify exports, and cert entries reduces manual data entry errors.

What's the best way to bulk import cert numbers into SlabLedger without a CSV file?

The best way to bulk import cert numbers without a CSV is using the /api/purchases/import-certs endpoint, which accepts a JSON body containing a certNumbers array and handles deduplication automatically during the cert entry process.

Why does my Shopify CSV import fail when missing required handle or title columns?

Shopify CSV imports fail without required handle and title columns because the /api/purchases/import-external endpoint enforces per-format column requirements and built-in validation, returning error reports for any missing mandatory fields during the import process.