![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-Logo.png\"){kind=logo}
<\/a>WooCommerce is one of the most popular eCommerce platforms for WordPress. It provides REST APIs to access products, orders, customers, coupons, and other store data. Many teams need to migrate WooCommerce data to SQL Server for reporting, operational dashboards, and analytics.<\/p>\nIn this tutorial, you will learn how to connect WooCommerce APIs to SQL Server Integration Services (SSIS) using ZappySys SSIS PowerPack. This approach helps you build repeatable ETL pipelines without writing custom API integration code.<\/p>\n
<\/p>\n
Prerequisites<\/h2>\n\n- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT) is available.<\/li>\n
- A WordPress site with WooCommerce installed and API access enabled.<\/li>\n
- ZappySys SSIS PowerPack<\/a> is installed on your machine.<\/li>\n<\/ol>\n
<\/p>\n
Steps<\/h2>\nGenerate WooCommerce API Credentials<\/h3>\n\n- Sign in to your WordPress<\/a> admin dashboard.<\/li>\n
- Go to WooCommerce<\/strong> > Settings<\/strong> > Advanced<\/strong> > REST API<\/strong>.<\/li>\n
- Click Add key<\/strong>.<\/li>\n
- Enter a description (for example, SSIS Integration<\/strong>), select a user, and set permissions to Read<\/strong> (or Read\/Write<\/strong> if needed).<\/li>\n
- Click Generate API key<\/strong>.<\/li>\n
- Copy the Consumer Key<\/strong> and Consumer Secret<\/strong>, then store them securely.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-Get-API-key.png\")
<\/a>Woocommerce – Get API key<\/p><\/div><\/li>\n<\/ol>\n
Create an HTTP Connection in SSIS<\/h3>\n\n- Create or open your SSIS project and package.<\/li>\n
- In Connection Managers<\/strong>, right-click and select New Connection…<\/strong>.<\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Create-a-new-HTTP-connection.png\")
<\/a>Create a new HTTP connection<\/p><\/div><\/li>\n
- Set the API URL:\n
https:\/\/{your-website}.com\/wp-json\/wc\/v3<\/pre>\n<\/li>\n - Set Credentials Type<\/strong> to Basic Auth (Username\/Password)<\/strong>.<\/li>\n
- Set Username<\/strong> to your WooCommerce Consumer Key<\/strong>.<\/li>\n
- Set the Password<\/strong> to your WooCommerce Consumer Secret<\/strong>.<\/li>\n
- Click OK<\/strong> to save the connection.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-the-HTTP-connection.png\")
<\/a>Woocommerce – the HTTP connection<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure JSON Source<\/h3>\n\n- Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\")
<\/a>Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\")
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
- Select the WooCommerce HTTP connection you created earlier.<\/li>\n
- Set the API URL. For example, use the following endpoint to fetch a summary of deposits:\n
https:\/\/{your-website}.com\/wp-json\/wc\/v3\/payments\/deposits<\/pre>\n<\/li>\n - Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Set JSON Path Filter<\/strong> to:\n
$.data[*]<\/pre>\n<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-JSON-source.png\")
<\/a>Woocommerce – JSON source<\/p><\/div><\/li>\n<\/ol>\n
Configure Destination Component<\/h3>\n\n- Add an\u00a0Upsert destination<\/strong><\/a>\u00a0(or another destination of your choice, such as\u00a0a Trash destination\u00a0<\/strong>or a\u00a0JSON\/CSV\/XML destination<\/strong>).<\/span><\/li>\n
- Connect the output arrow from JSON Source to the destination component.<\/li>\n
- Configure your SQL Server connection and target table.<\/li>\n
- Check the options you want to use: Insert<\/strong> or\/and Update<\/strong><\/li>\n
- Map the source columns to destination columns in the Mappings<\/strong> section.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png\")
<\/a>Woocommerce\u00a0 – Upsert destination<\/p><\/div><\/li>\n
- Click OK<\/strong> and execute the package.<\/li>\n
- Validate that WooCommerce rows have been loaded into your SQL Server table.\n
<\/p>\n
Steps<\/h2>\nGenerate WooCommerce API Credentials<\/h3>\n\n- Sign in to your WordPress<\/a> admin dashboard.<\/li>\n
- Go to WooCommerce<\/strong> > Settings<\/strong> > Advanced<\/strong> > REST API<\/strong>.<\/li>\n
- Click Add key<\/strong>.<\/li>\n
- Enter a description (for example, SSIS Integration<\/strong>), select a user, and set permissions to Read<\/strong> (or Read\/Write<\/strong> if needed).<\/li>\n
- Click Generate API key<\/strong>.<\/li>\n
- Copy the Consumer Key<\/strong> and Consumer Secret<\/strong>, then store them securely.\n<\/a>
Woocommerce – Get API key<\/p><\/div><\/li>\n<\/ol>\n
Create an HTTP Connection in SSIS<\/h3>\n\n- Create or open your SSIS project and package.<\/li>\n
- In Connection Managers<\/strong>, right-click and select New Connection…<\/strong>.<\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n<\/a>
Create a new HTTP connection<\/p><\/div><\/li>\n
- Set the API URL:\n
https:\/\/{your-website}.com\/wp-json\/wc\/v3<\/pre>\n<\/li>\n - Set Credentials Type<\/strong> to Basic Auth (Username\/Password)<\/strong>.<\/li>\n
- Set Username<\/strong> to your WooCommerce Consumer Key<\/strong>.<\/li>\n
- Set the Password<\/strong> to your WooCommerce Consumer Secret<\/strong>.<\/li>\n
- Click OK<\/strong> to save the connection.\n<\/a>
Woocommerce – the HTTP connection<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure JSON Source<\/h3>\n\n- Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n<\/a>
Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n<\/a>
SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
- Select the WooCommerce HTTP connection you created earlier.<\/li>\n
- Set the API URL. For example, use the following endpoint to fetch a summary of deposits:\n
https:\/\/{your-website}.com\/wp-json\/wc\/v3\/payments\/deposits<\/pre>\n<\/li>\n - Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Set JSON Path Filter<\/strong> to:\n
$.data[*]<\/pre>\n<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n<\/a>
Woocommerce – JSON source<\/p><\/div><\/li>\n<\/ol>\n
Configure Destination Component<\/h3>\n\n- Add an\u00a0Upsert destination<\/strong><\/a>\u00a0(or another destination of your choice, such as\u00a0a Trash destination\u00a0<\/strong>or a\u00a0JSON\/CSV\/XML destination<\/strong>).<\/span><\/li>\n
- Connect the output arrow from JSON Source to the destination component.<\/li>\n
- Configure your SQL Server connection and target table.<\/li>\n
- Check the options you want to use: Insert<\/strong> or\/and Update<\/strong><\/li>\n
- Map the source columns to destination columns in the Mappings<\/strong> section.\n<\/a>
Woocommerce\u00a0 – Upsert destination<\/p><\/div><\/li>\n
- Click OK<\/strong> and execute the package.<\/li>\n
- Validate that WooCommerce rows have been loaded into your SQL Server table.\n
- \n
- Sign in to your WordPress<\/a> admin dashboard.<\/li>\n
- Go to WooCommerce<\/strong> > Settings<\/strong> > Advanced<\/strong> > REST API<\/strong>.<\/li>\n
- Click Add key<\/strong>.<\/li>\n
- Enter a description (for example, SSIS Integration<\/strong>), select a user, and set permissions to Read<\/strong> (or Read\/Write<\/strong> if needed).<\/li>\n
- Click Generate API key<\/strong>.<\/li>\n
- Copy the Consumer Key<\/strong> and Consumer Secret<\/strong>, then store them securely.\n
<\/a>Woocommerce – Get API key<\/p><\/div><\/li>\n<\/ol>\n
Create an HTTP Connection in SSIS<\/h3>\n
- \n
- Create or open your SSIS project and package.<\/li>\n
- In Connection Managers<\/strong>, right-click and select New Connection…<\/strong>.<\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
<\/a>Create a new HTTP connection<\/p><\/div><\/li>\n
- Set the API URL:\n
https:\/\/{your-website}.com\/wp-json\/wc\/v3<\/pre>\n<\/li>\n- Set Credentials Type<\/strong> to Basic Auth (Username\/Password)<\/strong>.<\/li>\n
- Set Username<\/strong> to your WooCommerce Consumer Key<\/strong>.<\/li>\n
- Set the Password<\/strong> to your WooCommerce Consumer Secret<\/strong>.<\/li>\n
- Click OK<\/strong> to save the connection.\n
<\/a>Woocommerce – the HTTP connection<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure JSON Source<\/h3>\n
- \n
- Drag a Data Flow Task<\/strong> into Control Flow<\/strong> and open it.\n<\/a>
Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
- Select the WooCommerce HTTP connection you created earlier.<\/li>\n
- Set the API URL. For example, use the following endpoint to fetch a summary of deposits:\n
https:\/\/{your-website}.com\/wp-json\/wc\/v3\/payments\/deposits<\/pre>\n<\/li>\n- Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Set JSON Path Filter<\/strong> to:\n
$.data[*]<\/pre>\n<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong>.\n
<\/a>Woocommerce – JSON source<\/p><\/div><\/li>\n<\/ol>\n
Configure Destination Component<\/h3>\n
- \n
- Add an\u00a0Upsert destination<\/strong><\/a>\u00a0(or another destination of your choice, such as\u00a0a Trash destination\u00a0<\/strong>or a\u00a0JSON\/CSV\/XML destination<\/strong>).<\/span><\/li>\n
- Connect the output arrow from JSON Source to the destination component.<\/li>\n
- Configure your SQL Server connection and target table.<\/li>\n
- Check the options you want to use: Insert<\/strong> or\/and Update<\/strong><\/li>\n
- Map the source columns to destination columns in the Mappings<\/strong> section.\n
<\/a>Woocommerce\u00a0 – Upsert destination<\/p><\/div><\/li>\n
- Click OK<\/strong> and execute the package.<\/li>\n
- Validate that WooCommerce rows have been loaded into your SQL Server table.\n
- In Data Flow<\/strong>, drag and drop the ZS JSON Source<\/strong><\/a>.\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
- Go to WooCommerce<\/strong> > Settings<\/strong> > Advanced<\/strong> > REST API<\/strong>.<\/li>\n