Documentation

1. Overview

SellerHQ helps you manage Shopify store data with bulk CSV tools:

• Export orders, customers, products + inventory, and locations to clean CSV files
• Import inventory quantities only (set available stock from a CSV)

SellerHQ does not create products, variants, or locations. Inventory import only updates quantities on variants that already exist in your store. Temporary CSV files are deleted after 24 hours.

2. Getting started

1. Install from Shopify (or open the app URL). If you are not signed in to SellerHQ, you will see the login / register screens first.
2. Create an account or log in with email and password (Laravel session auth). After auth, the Shopify connection flow continues automatically when you arrived via install.
3. Authorize SellerHQ on your Shopify store. You will be asked to grant these scopes: read_customers, read_orders, read_products, write_products, read_inventory, write_inventory, read_locations, write_locations.
4. You land on the Dashboard. From there use New Export or Update Inventory.

You can also connect later from Settings → Connect Shopify Store by entering your .myshopify.com domain.

3. Dashboard

The dashboard is your home screen after login.

• Connected store — store name and when it was connected
• Quick stats (last 7 days) — orders exported, customers exported, inventory updates performed, last activity
• Shortcuts — New Export and Update Inventory
• Recent exports / imports — last activity with status and download links when files are still available
• Reconnect warning — if the Shopify token is missing or needs re-authorization, you will be prompted to reconnect

4. Export

Export is the core feature. Choose an entity type, configure filters and columns, then generate a CSV.

Entity types

• Products + Inventory — one row per variant per location (SKU, barcode, quantities, etc.)
• Orders — order header fields, statuses, tags, flattened line items and addresses
• Customers — contact details, marketing consent, spend, tags, addresses
• Locations — store locations and addresses

Steps

1. Open Export and select an entity tab.
2. Set filters (date range for orders/customers, status, tags, vendor, etc. as available).
3. Select which columns to include (Select all / Deselect all available). ID fields are recommended so you can match rows later.
4. Click Generate CSV Export and keep the tab open while data is fetched from Shopify.
5. When ready, download the CSV. Files remain available for about 24 hours, then are deleted automatically.

Notes

• Output is always CSV (UTF-8, comma-delimited, with a header row).
• Processing runs in the browser request (no background queue). Large stores may take a few minutes.
• Export history at the bottom of the page lists recent jobs and download links.

5. Import (inventory quantities)

Use Import to bulk-set available inventory from a CSV. This never creates products or locations.

Minimum columns required

• Identifier — one of: sku, barcode, or variant_id
• Quantity — available quantity to set (e.g. inventory_quantity or quantity)
• Location (optional) — location_name or location_id. If omitted, the store’s primary location is used.

Example header: sku,inventory_quantity,location_name

Steps

1. Open Import and upload a CSV (click to choose, or drag and drop).
2. Review the preview table (first 10 rows) and total row count.
3. Map columns: identifier type, identifier column, quantity column, and optional location.
4. Choose mode:
   • Dry-run / validate only (recommended first) — checks rows against your store without writing inventory.
   • Live update — writes available quantities via Shopify’s inventory API.
5. Submit and keep the tab open until processing finishes.
6. Review the summary (updated / skipped / errors). Download the error CSV if any rows failed.

Rules

• Only existing variants are updated (matched by SKU, barcode, or variant ID).
• Multi-location is supported when you supply location name or ID.
• Max about 20,000 rows / 10 MB per upload for the current MVP.

6. Settings

Account and store connection management:

• Connected stores — domain, connection date, scopes, active/reconnect status
• Reconnect / Re-authorize — run Shopify OAuth again if scopes change or the token is invalid
• Disconnect — deactivate the store connection (you can connect again later)
• Account details — name and email (profile edit available)
• Change password — update your SellerHQ password
• Privacy — link to the privacy policy and data handling summary
• Delete account — permanently remove your account, disconnect stores, and clear associated export/import data

7. Limits & tips

• Export and import run synchronously in the open browser tab — do not close the page while processing.
• Large catalogs may take 1–5 minutes depending on store size and Shopify rate limits.
• Export CSVs and import error files are kept for about 24 hours, then removed.
• If API calls fail with an auth error, reconnect the store from Settings.
• Prefer a dry-run import before applying live inventory changes.
• You can export products + inventory first, edit quantities in a spreadsheet, then re-import.

8. Privacy & data

SellerHQ reads and writes Shopify data only to provide exports and inventory updates you request. Data is not sent to third-party accounting or external systems. Access tokens are stored encrypted. Full details are in the Privacy Policy.