images
  • Pricing
  • Demo
  • FAQ’s
  • Docs
  • Support
  • Login
Buy now

Import and export

Import and export

⌘K
  • Gift Cards Pro
    • Getting started
      • Download the free version
      • Buy and download Gift Cards Pro
      • Install the plugin and activate the license
      • System requirements and compatibility
      • User roles and permissions
    • Plugin pages and shortcodes
      • Designer cards page
      • Image cards page
      • Image cards in list view (gift items)
      • PDF preview pages
      • Payment successful and cancelled pages
      • Check voucher balance page
    • Plugin settings
      • General settings
      • Payment settings
      • WooCommerce settings
      • Selling gift cards with WooCommerce
      • Email settings
      • AI Backgrounds settings
      • Invoice settings
    • Design templates and gift items
      • Designer cards
      • Create a template with the builder
      • Generate backgrounds with AI
      • AI credits
      • Image cards
      • Gift items and packages
      • Categories
    • Display booking forms
    • Orders and vouchers
      • Order details
      • Manual orders
      • Email Center
      • Import and export
    • Redeem vouchers
      • Via WooCommerce
      • In person
      • Staff redeem page
    • FAQ
    • Video guide
    • Changelog
  • Codemenschen Werk Probe
    • Installation
    • Connect to Werk
    • What Werk sees
    • Werk AI and drafts
    • Visitor statistics
    • Requirements
    • FAQ
  • Autoupdate Plugins & Themes
    • Download the free version
    • Download the premium version
    • Installation Instructions
    • Plugin Settings
    • Video Guide
    • Changelog
  • Joomla Giftcard Extension – Premium download
    • Joomla Giftcard Extension – Document
  1. Home
  2. Docs
  3. Gift Cards Pro
  4. Orders and vouchers
  5. Import and export

Import and export

You can export orders for your accounting, move the voucher data to another site, or bring in gift cards you already sold.

Export orders as CSV

Open the Export as CSV tab under Orders (or Tools → Export Orders (CSV)), choose the Order date (Last month, This month, All time or your own dates), the Payment status and the Format, and click Download CSV. Choose Excel Europe for the semicolon format that Excel opens straight into columns in most European languages.

Move vouchers to another site

  1. On the old site click Export Database under Orders. You get a JSON file with the vouchers and their activity.
  2. On the new site click Import Database under Orders, choose the JSON file and import it. The data is merged into that site.

Import orders from a CSV file

Open Tools → Import Orders, choose your CSV file and click Import. Save the file as UTF-8. The first row is treated as a header and skipped. The columns must be in this order:

Id, Order type, Template ID, Item category ID, Item ID, Buying for, From name, To name, Amount, Message, First name, Last name, Email, Address, Postcode, Payment method, Shipping, Shipping email, Shipping method, Expiry, Voucher code, Voucher PDF link, Order date, Status, Payment status, Language, Phone

The file from Export as CSV has a different column layout, so it cannot be imported as it is.

  • A row with the payment status Paid gets its balance at once.
  • A row with an empty voucher code gets a new code.
  • A row is skipped when its code is invalid, already in use or repeated in the file. The page tells you how many rows were skipped. A code has 4 to 40 letters, digits or hyphens.

Gift cards that are already printed

To add a few printed cards, use a manual order and enter the code from the card in Existing card code (optional). The card and the order then share one balance. For many cards, use the CSV import with the printed codes in the Voucher code column.

Updated on November 4, 2026

Doc navigation

← Email CenterRedeem vouchers →
images
    • Pricing
    • Demo
    • FAQ’s
    • Docs
    • Support
    • History
    • Blog