Product Importer

WooCommerce Excel Product Importer is a powerful and lightweight WordPress plugin designed to streamline the process of adding products to your WooCommerce store. Instead of manually entering each product, you can simply upload an Excel (.xlsx) file and let the plugin handle the rest—including images, categories, and stock management.

🚀 Features

• Bulk Import: Import hundreds of products in seconds using a simple Excel sheet.
• Smart Mapping: Automatically maps columns for SKU, Name, Description, Price, Stock, Categories, and Images.
• Image Sideloading: Provide image URLs in your Excel sheet, and the plugin will automatically download and set them as the product image and gallery.
• Category Management: Automatically creates categories if they don't exist.
• Stock Management: Sets stock quantities and statuses automatically.
• Update Existing Products: Matches products by SKU to update existing ones.
• Error Logging: Detailed logs for troubleshooting failed imports.

📋 Requirements

• WordPress: 5.0 or higher
• WooCommerce: 3.0 or higher
• PHP: 7.4 or higher
• Composer: Required to install the PhpSpreadsheet library.

🛠️ Installation

1. Clone or Download: Upload the product-importer folder to your /wp-content/plugins/ directory.
2. Install Dependencies: The plugin requires the PhpSpreadsheet library. Navigate to the plugin directory in your terminal and run:

   composer install

   Note: If you don't have Composer, you can run composer require phpoffice/phpspreadsheet.

3. Activate: Go to your WordPress Admin -> Plugins and activate Product Importer.

📖 How to Use

1. Prepare Your Excel Sheet: Create an .xlsx file with the following column headers (all lowercase):

   • sku: Unique product identifier (Required)
   • name: Product title (Required)
   • description: Full product description
   • price: Product price (numbers only)
   • stock: Quantity available
   • categories: Comma-separated category names (e.g., Electronics, Headphones)
   • image_urls: Comma-separated direct links to images

2. Upload:

   • Navigate to Product Importer in your WordPress sidebar.
   • Choose your prepared .xlsx file.
   • Click Import Products.

3. Check Results: The plugin will provide a summary of how many products were imported and any errors encountered during the process.

📁 Project Structure

product-importer/
├── admin/              # Admin-specific CSS, JS, and UI partials
├── includes/           # Core logic and helper classes
├── languages/          # Translation files
├── public/             # Public facing assets (if applicable)
├── vendor/             # Composer dependencies (installed via composer)
├── product-importer.php # Main plugin file
└── uninstall.php       # Cleanup on plugin deletion

🤝 Contributing

Contributions are welcome! If you have a feature request or found a bug, please open an issue or submit a pull request.

📜 License

This project is licensed under the GPL-2.0+ License. See the LICENSE file for details.

Made with ❤️ for the WooCommerce Community.