What this connection supports
Tikkivo Catalog Sync can read a published Google Sheets CSV source and map its columns to Shopify product and variant data. This is useful when a supplier maintains a sheet of identifiers, prices and available quantities that you need to import repeatedly.
The app does not provide a private Google Drive OAuth connection in this release. It does not make Shopify and Google Sheets a two-way inventory system. Do not choose this workflow if your requirement is to push Shopify sales back into a private spreadsheet.
Check publication and confidentiality first
Publishing a sheet as CSV exposes its published content to people who can access that published URL. Treat the contents as public: include only the supplier data needed for this workflow. Never publish credentials, customer information, private commercial notes or data you are not authorized to share.
Use a separate, deliberately prepared sheet rather than publishing an internal workbook indiscriminately. If the source must remain private, do not publish it just to enable sync. Assess another supported source or contact support to discuss the requirement without sending credentials or private feed URLs.
Prepare stable identifiers and quantities
Use a consistent identifier for each existing Shopify variant. Preserve leading zeros in SKUs and check for duplicate rows. Give stock quantities their own column. Decide whether the source represents supplier availability or stock you physically hold; these are not automatically interchangeable.
Keep the column structure stable between runs. Before connecting the source, inspect the CSV output to confirm that it contains the intended sheet, column headers and values rather than a sign-in page or unrelated HTML.
Map and test a manual update
Connect the published CSV as a supported remote source in Catalog Sync. Set the matching keys, map only the fields you want to update and choose one location for the available-stock update. Confirm the source inventory ownership setting before applying the import.
Review the preview against a small sample. Check a product with zero availability, a normal quantity and an unmatched SKU. Do not assume that a blank quantity should mean zero. Resolve any unexpected interpretation before approval, then verify the affected variants in Shopify.
Enable scheduling only after verification
The Free plan supports manual updates; paid plans provide scheduled remote updates. The public Starter plan includes daily scheduled updates. Confirm the current limits and scheduling options on the Shopify listing and in the app before relying on a particular interval.
Changes made in a sheet do not necessarily reach Shopify immediately. Account for the supplier’s own refresh timing, the import schedule and possible failures. This setup is not a guarantee against overselling and is not a replacement for a real-time multichannel stock system.
Investigate stale or missing updates
Check that the published CSV still exposes the intended data, identifiers still match, and the feed remains accessible. Review activity and download the operation report. If a run is partial or unverified, inspect Shopify before retrying it.
Use the stock-update checklist to review locations, ownership and failed operations. For an initial file-based workflow, start with supplier catalog imports.
Try the workflow with Catalog Sync
Start with a small sample and verify the result in Shopify. Review supported sources, current pricing and limitations before installing.
Written by the app publisher. No independent endorsement or guaranteed stock outcome is implied.