Skip to content

Snowfall Press Integration

Export a CSV

You can export a CSV file for sending to Snowfall Press from here. (Clear the cache first if you recently made changes to any of the PDF files.)

Copies of the files that have been sent to Snowfall Press can be found in Ezra's OneDrive folder here: H:\OneDrive - SGC\Snowfall Press

Remove duplicates

Open the 2 sheets in one Excel file:

  • Select the data for the first table
  • Click on: Data → Get Data → From Other Source → From Table/Range
  • Close the first table and select "Keep" when it asks

  • Repeat for the 2nd table

  • In Power Query, select Sheet A

  • Home → Merge Queries
  • Select Sheet B as the second table
  • Choose the matching column(s)
  • Select Left Anti Join

Power Query will return all rows in Sheet A that are NOT in Sheet B.

Connect the WooCommerce API

  • In WP, navigate to WooCommerce > Settings.
  • Click the Advanced tab.
  • Select REST API.
  • Click the Add Key button. 🔑

  • Fill in the details:

    • Description: Give your API key a memorable name (e.g., "Snowfall App").

    • User: Choose a user on your site to be associated with the key. For most integrations, an administrator or a user with the Shop Manager role is needed.

    • Permissions: Set the permissions based on what your application needs to do. For full access to read and update data, select Read/Write.

  • Click Generate API Key.

WooCommerce will then display the Consumer Key and Consumer Secret. These are your API credentials. Copy them immediately and store them in a secure place, as they won't be visible again for security reasons. The Consumer Key acts as the username, and the Consumer Secret is the password for API authentication.

Your site's URL: https://shepherdsglobal.org/wp-json/wc/v3/

WooCommerce REST API docs can be found here: Woo API docs.