The WooCommerce Products provider lets you export and import your product catalog between WooCommerce and Google Sheets. Manage pricing, inventory, and product details from a spreadsheet.
Requirements
WooCommerce must be installed and activated on your site.
Available Fields
- Product ID — The unique product identifier.
- Product Name — The product title.
- SKU — Stock Keeping Unit code.
- Price — Regular price.
- Sale Price — Discounted sale price.
- Stock Quantity — Current inventory count.
- Stock Status — In stock, out of stock, or on backorder.
- Product Type — Simple, variable, grouped, or external.
- Categories — Product categories.
- Tags — Product tags.
- Description — Full product description.
- Short Description — Brief product summary.
- Weight — Product weight.
- Dimensions — Length, width, and height.
- Images — Product image URLs.
- Status — Published, draft, or pending.
Filtering Options
- Product Type: Filter by simple, variable, grouped, etc.
- Product Category: Export products from specific categories.
- Stock Status: Filter by in-stock or out-of-stock products.
Real-time Sync
Supports real-time sync for product creation, updates, and deletion. Inventory changes are reflected in your Google Sheet immediately.
Import Support
Import product data from Google Sheets to WooCommerce. This is perfect for bulk price updates, inventory management, or migrating products. Use Product ID or SKU as the unique key.
Example Use Cases
- Bulk update product prices from a spreadsheet.
- Track inventory levels in a shared Google Sheet.
- Export your full product catalog for review or migration.
- Let your team manage product details in a familiar spreadsheet interface.
- Create automated inventory reports on a daily schedule.