Skip to content
All guides

Manage and explore

Import and export products with Excel

Export products on any plan. With Lite or Premium, you can also add or update products using Excel. Start with a CodePersist template or a fresh export.

From your spreadsheet to live product links
  1. Prepare the file

    Download the template or export products you want to edit.

  2. Upload and review

    Check the changes and removals. Nothing is saved yet.

  3. Confirm your choices

    Save the products, then publish the ones you selected.

Import can remove links you leave out of the file. Start from a fresh export when updating products, and review removals before confirming. Keep the import page open until it finishes.

Export all or selected products

  • On Products, select rows and choose Export selected.
  • To export the whole catalogue, clear the search, choose All statuses, select this page, then choose Select all matching products.
  • Selections stay checked across pages, searches and status filters. Download the Excel template from More.
  • Export includes editable product fields, topic selections, link titles, URLs, languages and QR settings, including selected disabled products.
  • Hidden topic definitions, link metadata and resources unavailable in the editor stay on the server. The exported workbook can be edited and imported on a paid plan.
  • It does not include revision history, analytics, generated artwork, credentials or provider configuration.

Review, import and publish

  • Choose Import Excel, upload the file, and correct any validation errors. Nothing is saved during validation.
  • The preview identifies new products and updates, counts topics and links, and shows removals.
  • Publication is selected by default for eligible products; uncheck individual products to import them as drafts only, or use the bulk toggle. Confirm once to start. Keep the window open while products are saved one at a time. All save attempts finish before any publication begins. If all saves succeed, the selected saved versions are published.

If a save or publication fails

  • If any save fails, the remaining saves are attempted and automatic publishing is held.
  • Retry failed products individually, publish only the selected products that saved, or leave without publishing. Retrying a save does not start publishing automatically. Successful saves are not repeated.
  • Publication retries use the saved revision and do not create another one.
  • Save retries keep the version originally reviewed and cannot resolve a version conflict.
  • If another edit changed a product after preview, or a network failure left the earlier write uncertain, review the current products and export a fresh workbook.
  • Leave and reopen import to upload and preview your changes again.
  • Closing the window does not undo completed saves and does not schedule continuation.

Look up the file details when you need them

Start with a downloaded template or export. Open these sections if you need help with a column or a file error.

Keep the template layout
  • Use exactly Products and Links, with one table per sheet: ProductsTable and LinksTable, starting at A1.
  • Keep every downloaded header in its original order, including optional columns. Do not add sheets, totals, formulas or notes outside the tables. Add rows inside each table. Empty rows are ignored. Colours, widths and tab order may be changed.

Use an unprotected .xlsx file, up to 10 MiB uploaded, 100 MiB expanded and 2,000 products. The existing limits of 16 topics, 32 links and four links per topic still apply. Account product limits also apply to new products.

Products / ProductsTable
ColumnWhat to enter
ProductKeyRequired file-local key, for example coffee250. Use the same key in Links.
GTINRequired text. A valid GTIN-8, GTIN-12, GTIN-13 or GTIN-14. Keep leading zeroes.
NameRequired product display name, up to 200 characters.
ResolverOptional HTTPS resolver origin without a path, query or fragment. Blank uses the configured CodePersist resolver; export leaves it blank for that resolver. An exact URL and GTIN match updates that product. Otherwise, a custom URL with the same GTIN as an existing CodePersist product attaches that domain to it. The domain must belong to your workspace and be active. An existing attachment cannot be replaced. Later updates accept the original or attached URL.
ShowLinkChoicestrue shows a page where visitors choose among the product's links after scanning. false or blank redirects to the selected default link.
QrErrorCorrectionL, M, Q or H. Leave blank to use M. Export leaves this cell blank when the saved value is M.
XDimensionMmQR module size in millimetres, 0.396–0.990 in 0.001 steps. Leave blank to use 0.495. Export leaves this cell blank when the saved value is 0.495.
Worked example — use the same product key on every sheet

These example rows describe one coffee product, its required product page, and English and French ingredients links. Keep GTIN as Text: 09506000134352. A blank Resolver uses the configured CodePersist resolver. Enter your active custom domain only when you want to use it. Replace the destination URLs with your public URLs. The template contains no example products to delete.

Products

ProductKeyGTINNameResolverShowLinkChoicesQrErrorCorrectionXDimensionMm
coffee25009506000134352Ground coffee 250gfalse

Links

ProductKeyTopicKeyTitleUrlLanguagesIsDefaultLinkId
coffee250Product pagehttps://brand.example/coffeetrue
coffee250ingredientsIngredientshttps://brand.example/coffee/ingredients/en-esen;es
coffee250ingredientsIngrédientshttps://brand.example/coffee/ingredients/frfr
Multiple languages and cell values
  • Separate language codes with semicolons in Languages, for example en;fr-CA;es. Spaces around codes are ignored. Leave Languages blank for product-page.
  • Use true or false for ShowLinkChoices and a decimal point for decimal text, for example 0.495. Excel numeric cells are accepted. Topics are inferred from links; empty topics cannot be imported.
Updating existing products
  • Products match by normalized resolver origin plus GTIN within your workspace.
  • A blank resolver selects CodePersist's default, never an existing custom domain. An existing GTIN on another resolver is rejected. Each confirmed import creates a revision.
  • Omitted editable links and their empty topics are removed; hidden topics and standalone resources stay on the server.
  • Keep an exported LinkId to update that link while retaining its saved metadata, even when its URL or languages change. Leave LinkId blank to create a new link with default metadata.
  • Moving an existing link between optional topics retains its metadata and adds the new topic’s required relation.
  • Mark at most one IsDefault per product; none selects the product page. Disabled products remain disabled. Published versions stay live until replacements are published.
  • For a product with an attached custom domain, either its original Resolver or the same custom URL updates that product and preserves its attachment. To add a domain to an existing CodePersist product, see the custom-domain steps below.

Add a custom domain through Excel

  • Connect your custom domain in CodePersist and wait for Active. Lite or Premium is required.
  • Export the existing CodePersist product, keep its GTIN and LinkId values, and enter the custom HTTPS origin in its Resolver cell, such as https://id.example.com/. Edit its content as needed.
  • The preview first matches a product already using that URL and GTIN. Otherwise, it matches your product with the same GTIN on the default CodePersist resolver and shows the permanent attachment. No second product slot is needed.
  • Review the attachment before saving. The product must be enabled, with no publication, removal or plan change in progress. A second or replacement custom domain is not allowed.
  • Saving applies the content changes and domain attachment in one new version. Select Publish during import to publish both URLs, or publish the saved version later. Previously printed CodePersist codes keep working.
  • Later imports can use either the original Resolver or the same attached custom URL. Export keeps the original Resolver, blank for the default CodePersist address.
  • Include only one row per product: its original and attached URLs are two addresses for the same product. If no product matches, the row creates a new product on the supplied domain.
Add a domain to an existing product →
Common errors and corrections
  • Products · row 1: invalid layout — restore a renamed/moved header from a fresh template.
  • Products · row 2 · GTIN: text required — format the cell as Text and type the GTIN again; changing the format alone cannot restore lost zeroes.
  • Links · row 3 · ProductKey: unknown reference — copy the exact ProductKey from Products. Formula not supported — paste a value instead.
  • Value outside table — expand the original table to include your new rows.
  • Error messages appear in your app language with the worksheet, row and column.