Smacks! Simple Importer – CSV, Excel & WooCommerce Bulk Import

Smacks! Simple Importer is a bulk importer for WordPress and WooCommerce. Upload a CSV, Excel (XLSX), XML, or JSON file, drag your spreadsheet columns onto the target fields, and run the import. It handles WooCommerce products, posts, pages, custom post types, and media library items, with drag-and-drop column mapping and a live preview of how rows will land.

What you can import into WordPress and WooCommerce

• Simple WooCommerce products (SKU, name, prices, stock, categories, tags, brands, images, status, custom attributes)
• WordPress posts (title, content, excerpt, author, date, categories, tags, featured image)
• WordPress pages (with parent/child hierarchy, page templates, menu order)
• Any registered custom post type
• Media library items (images and files from URLs with titles, alt text, captions)
• Custom post meta via the meta: prefix syntax
• Custom taxonomies via the tax: prefix syntax
• Yoast SEO fields (when Yoast is active), including title, meta description, focus keyword, canonical URL, and Open Graph fields

Supported file formats: CSV, Excel, XML, JSON

• CSV (comma, semicolon, or tab, auto-detected)
• XLSX (Microsoft Excel)
• XML (with auto-detection of the repeating element)
• JSON (top-level array, NDJSON, or wrapped in a single “items” key)

How to import a CSV or Excel file

1. Choose your content type (products, posts, pages, custom post type, or media).
2. Upload your CSV / XLSX / XML / JSON file.
3. Map columns onto target fields. Auto-mapping suggests matches based on common header names.
4. Pick an update mode (insert, update existing, update only) and a match key (SKU, slug, title, ID).
5. Watch the import run in the background. Cancel any time. Logs show what happened for every row.

Idempotent re-imports

Each content type has a sensible match key by default (SKU for products, slug for posts/pages/CPTs, URL for media). When a row matches an existing record, the importer updates it instead of creating a duplicate.

Background processing

Imports run through Action Scheduler (bundled with WooCommerce, or available as a standalone plugin). Large files are processed in batches so PHP timeouts don’t break the import. You can close the tab and come back later.

Templates

The plugin includes downloadable starter templates for each content type, generated in CSV, XLSX, XML, and JSON formats so you can see the expected column shape.

Privacy

The plugin does not send any data to external services. All imports are processed locally on your WordPress installation. No tracking, no analytics, no callouts.

Simple Importer Pro

This free version handles everyday imports. Simple Importer Pro adds the heavier lifting for large catalogs and awkward source files:

• Advanced character-encoding and delimiter handling for international and exported files
• Priority support, ahead of the free queue
• Use it across your own and client sites, updates included

See features and pricing at https://simpleimporter.com. The free version stays fully functional on its own; Pro is optional.