Order import
Sign In with Google
Access token (used to read Google Sheets, expires one hour after signing in):
Google Sheets ID
Google Sheets tab name to process
Shopify store name (do not include .myshopify.com)
Shopify API key
Run mode
Dry run - check inventory and input sheet, logs only, no updates to Shopify
Dry run - US only - check inventory and input sheet, logs only, no updates to Shopify
Dry run - Non-US only - check inventory and input sheet, logs only, no updates to Shopify
Create one real order, as draft, selected at random
Create one real order, as draft, for the email below (must be an email in the Google Sheet)
Create one real order, as draft, and send invoice (only if international), for the email below (must be an email in the Google Sheet)
Create one real order, fully processed, for the email below (must be an email in the Google Sheet)
Full live run - US only
Full live run - non-US only
Full live run - all users
Email of user to run (only used with the last four selections above)
Override all customers with this address (leave blank for live runs)
Settings
Note: These are saved each time you click Process, and so are viewable by anyone with the URL.
To save without processing, leave inputs blank at top.
Variant ID(s) to order - separate with commas if multiple
Message to add to invoice
Shipping will be calculated after you click 'Complete your purchase' and select shipping method. You must complete this checkout by November 18, 2025 for your order to ship on time.
How long to reserve inventory (days)
Order note
Line item discount title
Line item discount description
Line item discount value
Line item discount type
PERCENTAGE
FIXED_AMOUNT
Google sheet column headings (must be on first row of tab) to Shopify mapping
email
shippingAddress.firstName
shippingAddress.lastName
Full name (must leave above two blank, last word will go to lastName, rest to FirstName)
shippingAddress.address1
shippingAddress.address2
shippingAddress.city
shippingAddress.provinceCode
shippingAddress.countryCode
shippingAddress.zip
billingAddress.firstName
billingAddress.lastName
Full name (must leave above two blank, last word will go to lastName, rest to FirstName)
billingAddress.address1
billingAddress.address2
billingAddress.city
billingAddress.provinceCode
billingAddress.countryCode
billingAddress.zip
quantity
Log level
ALL - maximum logging
DEBUG - medium logging
Errors only