Connect your tools,
sync your data.

Connect your Square account to sync inventory between StringsTheory and your Square catalog. Push your products to Square for in-store sales, or pull Square catalog items into StringsTheory for centralized management.

Connecting Your Account

• Go to Settings → Integrations → Square
• Click Connect to Square — this opens Square's OAuth authorization page in your browser
• Sign in to your Square account and grant StringsTheory permission to access your catalog and inventory
• You are redirected back to StringsTheory automatically. A green "Connected" badge confirms the link

Push Inventory to Square

Pushing sends your StringsTheory inventory items to your Square catalog as products. Each item's name, description, price, and quantity are synced. Items are matched by SKU — if a matching SKU exists in Square, the existing item is updated; otherwise, a new catalog entry is created.

• In the Square integration panel, click Push to Square
• Review the preview showing which items will be created, updated, or skipped
• Confirm to send the data

Pull from Square

Pulling imports items from your Square catalog into StringsTheory. This is useful if you already have products set up in Square and want to bring them into StringsTheory without re-entering everything.

• Click Pull from Square in the integration panel
• Use the import filter to choose which Square items to import — filter by category, or select individual items from the list
• Confirm the import to create new inventory items in StringsTheory

Per-Item Sync Toggle

Not every item needs to sync with Square. You can enable or disable Square sync on a per-item basis directly from the inventory item edit form.

• Open any inventory item and scroll to the Integrations section
• Toggle Sync to Square on or off
• Items with sync disabled are excluded from both push and pull operations and from auto-sync

Location Selection

If your Square account has multiple locations, choose which location StringsTheory syncs with. Go to the Square settings panel and select your preferred location from the dropdown. Inventory quantities map to the selected location's stock count.

Field Preferences

Control exactly which fields sync between StringsTheory and Square. In the Square settings panel, toggle each field on or off:

• Name — item display name
• Description — product description text
• Price — sale price mapped to Square's default price
• Quantity — stock count at the selected location

Disabling a field means it will not be overwritten during sync. For example, if you manage descriptions in Square but prices in StringsTheory, disable Description sync and enable Price sync.

Auto-Sync Intervals

Enable auto-sync to keep your Square catalog up to date without manual pushes. Choose an interval:

• 5 minutes — near real-time sync, best for high-volume shops
• 15 minutes — recommended default, balances responsiveness with API usage
• 30 minutes — moderate frequency for shops with less turnover
• 60 minutes — hourly sync for low-volume or batch-oriented workflows

Sync your entire inventory to a Google Sheets spreadsheet for reporting, sharing with partners, or as a live backup you can open from any browser. StringsTheory also creates per-item worksheets with serial data and custom production fields for detailed tracking.

Connecting Your Account

• Go to Settings → Integrations → Google
• Click Connect to Google — this opens Google's OAuth consent screen
• Sign in with the Google account that owns (or has edit access to) the target spreadsheet
• Grant StringsTheory permission to read and write Google Sheets data
• You are redirected back. A green "Connected" badge appears with your Google account email

Push Inventory to Sheets

Pushing writes your inventory data to the spreadsheet you select. Each inventory item becomes a row on the main "Inventory" worksheet. StringsTheory uses your Internal SKU as the primary key to match rows on subsequent syncs.

• After connecting, click Select Spreadsheet and choose an existing spreadsheet or create a new one
• Click Push to Sheets to write your current inventory data
• The main worksheet includes columns for name, SKU, category, quantity, cost, price, and more

Per-Item Worksheets

For items with serialized production units, StringsTheory creates a dedicated worksheet named after the item. Each row in the worksheet represents one serial number, with columns for serial number, status, color, manufactured date, dealer, customer, revision, notes, and any custom production fields you have defined.

• Worksheets are created automatically when you push an item that has production units
• Custom production fields (any non-standard column you add during CSV import) are preserved and synced as additional columns
• Worksheets update on every push — new serials are added, existing ones are updated

Pull Preview

Before pulling data from Google Sheets into StringsTheory, the pull preview shows you exactly what would change. This lets you review additions, updates, and deletions before committing anything to your local database.

• Click Pull from Sheets — a preview dialog appears showing proposed changes
• Review each change: new items (green), updated fields (amber), and items that exist locally but not in Sheets (gray)
• Accept all changes, or deselect individual items you want to exclude
• Click Apply to commit the accepted changes

Auto-Sync

Enable auto-sync to push your inventory to Google Sheets on a recurring schedule. The same interval options are available: 5, 15, 30, or 60 minutes. Auto-sync only pushes; pulls always require manual confirmation via the preview dialog to prevent accidental overwrites.

Connect your Shopify store to sync products and inventory levels between StringsTheory and your online shop. Push new products to Shopify, pull orders and stock changes back, and keep everything aligned across channels.

Connecting Your Store

• Go to Settings → Integrations → Shopify
• Click Connect to Shopify and enter your Shopify store URL (e.g., your-shop.myshopify.com)
• You are redirected to Shopify's OAuth authorization page — sign in and approve the permissions
• StringsTheory uses a permanent API token, so you only need to authorize once
• A green "Connected" badge appears with your store name

Push Products to Shopify

Pushing creates or updates products in your Shopify store based on your StringsTheory inventory. Items are matched by SKU.

• Click Push to Shopify in the integration panel
• Review which items will be created (new products) or updated (existing SKU matches)
• Product title, description, price, and inventory quantity are synced by default
• Images from StringsTheory are uploaded to Shopify as the product's featured image

Pull from Shopify

Pulling imports products from your Shopify store into StringsTheory. Use the import filter to select which Shopify products to bring in.

• Click Pull from Shopify to see a list of Shopify products
• Filter by Shopify collection, product type, or search by name
• Select the products you want to import and confirm
• Imported items appear in your inventory with Shopify sync enabled by default

Location-Based Inventory Mapping

Shopify supports multiple inventory locations (warehouse, storefront, fulfillment center). StringsTheory maps to one Shopify location at a time so quantities stay consistent.

• In the Shopify settings panel, select the Shopify location to sync with
• Inventory quantities pushed from StringsTheory update the stock at that location
• Pulls read the quantity from the selected location only
• To switch locations, change the selection in settings — the next sync uses the new location

Per-Item Sync Toggle

Just like Square, you can enable or disable Shopify sync on individual items.

• Open any inventory item, scroll to Integrations
• Toggle Sync to Shopify on or off
• Disabled items are excluded from all push, pull, and auto-sync operations

Import Filtering

When pulling from Shopify, you do not have to import everything. The import filter lets you pick and choose:

• Filter by collection to import only items from a specific Shopify collection
• Filter by product type to narrow results (e.g., only "Guitars" or "Parts")
• Search by name or SKU within the filtered results
• Deselect individual items from the import list before confirming

Field Preferences

Control which fields sync between StringsTheory and Shopify:

• Name — product title
• Description — product body HTML (converted to plain text in StringsTheory)
• Price — default variant price
• Quantity — inventory level at the selected location

Auto-Sync

Enable auto-sync with the same interval options (5, 15, 30, or 60 minutes). Auto-sync pushes updates from StringsTheory to Shopify on the configured schedule.

The Auto-Sync Manager is the central control panel for all automatic synchronization across your connected integrations. It runs in the background and keeps your data flowing without manual intervention.

Configurable Frequency

Set a global sync frequency that applies to all enabled integrations, or override the frequency per integration:

• 5 minutes — fastest interval, ideal for high-traffic shops where stock changes frequently
• 15 minutes — the recommended default; a good balance of responsiveness and efficiency
• 30 minutes — suitable for moderate activity levels
• 60 minutes — hourly sync for shops with predictable, low-frequency inventory changes

Sync-on-Edit

Enable Sync on Edit to trigger an immediate push to all connected integrations whenever you save changes to an inventory item. This provides near real-time sync without relying on the interval timer.

• Go to Settings → Integrations → Auto-Sync
• Toggle Sync on Edit on
• Now, every time you save an inventory item (create, update, or adjust quantity), the change is pushed to Square, Google Sheets, and Shopify immediately
• If you edit multiple items in quick succession, syncs are batched to avoid flooding the API

Per-Item Exclusion

Some items should never sync — internal-use supplies, test records, or items you only manage locally. Use the per-item sync toggle (available in the item edit form under Integrations) to exclude specific items from all auto-sync operations.

• Items with sync disabled for a specific integration are excluded from that integration's auto-sync, push, and pull
• Items with sync disabled for all integrations do not appear in any sync operation
• You can bulk-edit sync toggles by selecting multiple items in the inventory list and using Bulk Edit → Integrations

Adaptive Backoff on Failures

If a sync operation fails (network issue, API rate limit, expired token), StringsTheory does not keep retrying at the same frequency. Instead, it uses adaptive backoff to space out retries and avoid wasting resources.

• On the first failure, the sync interval increases from your configured setting to 15 minutes (or stays the same if already 15 minutes or more)
• On continued failures, the interval increases to 60 minutes
• Once a sync succeeds again, the interval resets to your configured frequency
• A warning badge appears on the integration icon in the sidebar when backoff is active

Integrations are included with both the Monthly ($29.99/mo) and Annual ($199.99/yr) plans. Start your 7-day free trial to try all integrations with full functionality before committing.