JSON Export

Below are some guides for exporting orders as JSON, also known as JavaScript Object Notation. It is one of the most popular modern data exchange formats. It’s most often used for building software applications.

Export from OrderWand Screen

Below is a screenshot of the export screen.

Export JSON buttons

Download it to your Computer

  1. Click the OrderWand icon in your icon bar
  2. Click the Download button
  3. A file save dialog will show and choose where to save it

Copy to your clipboard

  1. Click the OrderWand icon in your icon bar
  2. Click the Copy button
  3. Open the file with any of the following text editors:
    1. Visual Studio Code
    2. Notepad++
    3. Apple Numbers
  4. Right click and click “Paste” to paste it into your text editor

Example Order Export

See the colorized JSON example below. You can also click here to download an sample JSON file.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
[
  {
    "account": "youremail@gmail.com",
    "orderedAt": "2024-02-02",
    "shippingAmount": 0,
    "shippingStatus": "without tracking",
    "taxAmount": 0.34,
    "vendor": "TCG",
    "vendorId": "20C05516-511FF8-8C976",
    "products": [
      {
        "condition": "near mint",
        "finish": "foil",
        "itemIndex": 1,
        "name": "The Mycosynth Gardens (Extended Art)",
        "price": 5.19,
        "currency": "USD",
        "productLine": "MtG",
        "productType": "singles",
        "quantity": 1,
        "seller": "black sun cards",
        "setName": "Phyrexia: All Will Be One",
        "url": "https://store.tcgplayer.com/magic/phyrexia-all-will-be-one/the-mycosynth-gardens-extended-art",
        "vendorId": "479640"
      }
    ]
  },
  {
    "account": "youremail@gmail.com",
    "orderedAt": "2024-02-12",
    "shippingAmount": 0.99,
    "shippingStatus": "without tracking",
    "taxAmount": 0.39,
    "vendor": "TCG",
    "vendorId": "13F17E28-5C21CA-ABC2D",
    "products": [
      {
        "condition": "near mint",
        "finish": "foil",
        "itemIndex": 2,
        "name": "Karn's Bastion (Retro Frame)",
        "price": 1.25,
        "currency": "USD",
        "productLine": "MtG",
        "productType": "singles",
        "quantity": 2,
        "seller": "TC's Rockets",
        "setName": "Ravnica Remastered",
        "url": "https://store.tcgplayer.com/magic/ravnica-remastered/karns-bastion-retro-frame",
        "vendorId": "531295"
      },
      {
        "condition": "near mint",
        "finish": "non-foil",
        "itemIndex": 1,
        "name": "Wave Goodbye (Extended Art)",
        "price": 2.26,
        "currency": "USD",
        "productLine": "MtG",
        "productType": "singles",
        "quantity": 1,
        "seller": "TC's Rockets",
        "setName": "Commander: The Lost Caverns of Ixalan",
        "url": "https://store.tcgplayer.com/magic/commander-the-lost-caverns-of-ixalan/wave-goodbye-extended-art",
        "vendorId": "526254"
      }
    ]
  }
}