Import from a link
In short: Import from a Google Sheet with an optional daily sync, one product page, a whole store address, or a queue of many product links.
The From a link tab holds four tools that start from an address instead of a file: a Google Sheet, one product page, a store address, and a queue for many product links.
Where to find it
Sidebar → COMMERCE → Import / Export, tab From a link. On an Academy store, open Shop items and other stores first to see the tabs.
Import from a Google Sheet
- Share your sheet as "Anyone with the link can view" (in Google Sheets: Share, General access).
- Under Import from a Google Sheet choose Products or Customers.
- Paste the link into Paste the Google Sheet link here and press Check the sheet.
- The import page opens with a preview. Check it and press the import button.
A private sheet cannot be read; the message says to check the link and sharing. Products arrive as drafts.
- Update from this sheet every day. After an import from a sheet, turn this switch on.
- Once a day PersonaCart re-checks the sheet, updates anything that changed and adds anything new as a draft.
- Nothing is ever deleted.
- The card shows Last run (updated successfully, blocked, or ran into an error) and Next run, and Run now starts a sync straight away.
- If three tries in a row fail, the sync is paused and the reason is shown.
Import a product from a page (with AI)
Under Import a product with AI, press Start import and paste a product page address (works best with Shopify and WooCommerce product links). PersonaCart checks what the page is first:
- A product page: "we'll create a sellable product, with its product page", including variants and images re-hosted on your store.
- A shop or category page: refused, because importing a list creates an empty product. Open a single product and paste its own link.
- A page the site blocks: try the product's own link, or add the product by hand.
- A page, not a product: use Copy a page instead (New Page → Copy a page) to clone it as an editable page.
Press Import as product. It usually takes under a minute. When it finishes, Product created shows the product page and buttons Open product and View product page, with "A few things to finish" if something needs your attention. Check the price and details straight away.
Import products from a store address
- Import products from a store: type a public store address (for example
https://yourstore.com), press Import products, and PersonaCart detects the platform (Shopify, WooCommerce, Squarespace or any store with product pages) and brings the products in as drafts. - When it finishes: "Imported N products as drafts" with View products.
- If the address is not a public storefront you get an error.
For connected, private access to your own store, use Shopify, WooCommerce or Squarespace instead.
Import products from URLs (queue)
-
Import products from URLs: paste one or many product page links, one per line, and press Add to queue (or Queue N URLs).
-
Lines that are not valid links are skipped and counted.
-
Each link is imported in the background and PersonaCart emails you as each one finishes.
-
A limited number run at a time, and you can close the page.
-
An imported product arrives already Published and visible, so open it with View product and check the price and photos straight away.
-
The Import queue lists everything you sent, newest first, with a status: Queued (with "#N in queue" and an estimate), Importing, Imported (with View product), Failed (with Retry and the number of attempts) or Cancelled.
-
Cancel stops one queued import.
-
Paste a link you already sent and press Add to queue: it shows Already queued.
-
If you paste a page rather than a product, you are pointed to Copy a page.
Questions
Does my Google Sheet need to be public?
It needs to be shared as Anyone with the link can view. Private sheets cannot be read.
Will the daily sync delete products?
No. It updates changes and adds new rows as drafts. Nothing is ever deleted.
Why was my link refused?
Shop and category pages are lists of products, so they cannot become one product. Paste a single product's own link.