Phone: 1-888-326-6856 Email:

BTP News

The BTP Blog
  • Home
  • /
  • Uncategorized
  • /
  • A NEW Shopify App for Technical Folks! (Shopify Products to SQL)
  • 12 Aug

    A NEW Shopify App for Technical Folks! (Shopify Products to SQL)

    Business Tech Pro creates a Shopify app to assist in exporting product data in SQL

    I put together Shopify Products to SQL, an app that exports all product data and metafield data into SQL.

    I was unhappy with being unable to export all product data or product metafields in a usable format, so I created this application to pull everything into a My SQL database. This is great way to do transforms on your data, hook your data into other systems, or give someone a subset of your product data.

    Who should use the application?

    Anyone who wants to backup or ‘own’ their own Shopify data via SQL Database.

    What is the application?  

    The app provides a facility to backup all Product, Variant, and Metafield data to your favorite SQL Database.

    When should you use the application?

    Anytime you run the the app, it will build/create a set of ‘timestamped’ SQL files that can create table backups for all of your’s product data, variants, and optionally metafields.

    Where does the application go?

    Your Shopify shop and your SQL Database.

    Why have the application?

    The app provides backups of Shopify product(s) data in an SQL database for various purposes.

    How does it work?

    Run the Shopify Products To SQL application; after it finishes processing, the app will present the SQL backup files (with all of your product data).


    Check out the app for yourself here. Hope you all enjoy it.


    Business Tech Pro is the leader in optimizing your business for the real world, and offers a collection of helpful services to get you where you want to be:

    • eCommerce Packages
    • Feed Doctor
    • Automation
    • Pay Per Click
    • Email Marketing
    • Social Media
    • Web Design
    • Graphic Design
    • Content Creation

    Contact us at 888-326-6856 or today to see how we can help your business thrive!