Skip to main content

Shopify app workaround

If the ShopWP Shopify app is down and you need to connect your Shopify store, you can use this workaround.

warning

Note: This is only a workaround and should not be used long term.

These are the steps that ShopWP normally takes care of for you behind the scenes.

Create a custom app inside Shopify​

Open your Shopify dashboard and click "Settings". Then click "Apps and sales channels"

ShopWP app work around 1

You'll most likely need to enable the custom app development feature by clicking the "Allow custom app development" button.

ShopWP app work around 2

Again click "Allow custom app development" one more time.

ShopWP app work around 2

From there, click the "Develop apps" button.

ShopWP app work around 2

Now click "Create an app"

ShopWP app work around 2

Give your custom app a name such as, "ShopWP temp workaround"

ShopWP app work around 2

Once the custom app is created, click the "Configure Admin API scopes" and ensure the following scopes are selected:

  • read_customers
  • read_discounts
  • read_inventory
  • read_product_feeds
  • read_product_listings
  • read_products

ShopWP app work around 2

Once you have all the scopes selected, click save.

Click the Configuration tab and then click the "Configure" button next to the "Storefront API integration".

ShopWP app work around 2

Ensure the following scopes are selected:

  • unauthenticated_read_customers
  • unauthenticated_read_product_listings
  • unauthenticated_read_product_inventory
  • unauthenticated_read_product_pickup_locations
  • unauthenticated_read_product_tags
  • unauthenticated_read_selling_plans
  • unauthenticated_write_bulk_operations
  • unauthenticated_read_bulk_operations
  • unauthenticated_read_bundles

Once you have all the scopes selected, click save.

Go back to the "Overview" tab and click the "Install app" button.

ShopWP app work around 2

Once you're done installing the app, you'll need to copy and paste these two API keys. Be sure to keep them somewhere safe like a text file. We will use them later in the guide.

  • Admin API access token
  • Storefront API access token

ShopWP app work around 2

Now open WordPress and go to the Plugins page. Search for the plugin called "SQL buddy" and install it.

ShopWP app work around 2

Once installed, go to the "SQL Buddy" link from the Tools menu.

ShopWP app work around 2

Click the "wp_wps_settings_connection" table

ShopWP app work around 2

Copy the two API keys into the below columns:

access_token - Admin API access token storefront_access_token - Storefront API access token

ShopWP app work around 2

Done! You can now use ShopWP. Make sure to uninstall the SQL Buddy plugin if you don't plan on using it again.

phpmyadmin​

If you don't see an existing record in the database, then you'll need to uninstall SQL Buddy and use a different method instead. SQL Buddy will not allow you to add new records to the database.

In this case, using phpmyadmin through your webhost is the easiest option. Most webhosts will have this option available for you to choose.

Once you login to phpmyadmin, click the wp_wps_settings_connection table and go to the insert tab. From there, you can manually insert a row. See the below screenshot.

ShopWP app work around 2