# Uploading orders

Before uploading, make sure your CSV file is formatted correctly. (You can still map columns later even if they aren’t formatted exactly.)

#### Example CSV Format

| Email Address       | Last Name | First Name | Phone      | Order Date and Time | Ticket Type       | Zip/Postal Code | Qty Tickets | Total Ticket Price | Total Face Value | Order ID | Subscribed to Email | Subscribed to SMS |
| ------------------- | --------- | ---------- | ---------- | ------------------- | ----------------- | --------------- | ----------- | ------------------ | ---------------- | -------- | ------------------- | ----------------- |
| <brenden@cymbal.co> | Brenden   | Rice       | 9492327899 | 1/5/2024 22:00:00   | General Admission | 123456          | 3           | 200                | 190              | 1234567  | TRUE                | TRUE              |

{% file src="<https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2FN51Cy70DIZkaDZJm50t1%2Fexample-orders.csv?alt=media&token=9550b195-2207-40ef-b73b-74742bc99ab8>" %}

## Supported Time Formats

* 12-hour, non-padded, meridiem, with seconds precision (EX: 3:04:05 PM)
* 24-hour with seconds precision (EX: 15:04:05)

## Upload Steps

1. From the [**Home tab**](https://manager.cymbal.co/home), select the **event** you want to upload orders for

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2FDycxudX0DhYKBGoU5TJY%2Fimage.png?alt=media&#x26;token=07437409-3a1f-44ee-8d52-85d71ad3f8eb" alt=""><figcaption></figcaption></figure>
2. Click **Orders** in the left panel

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2FitD6JsV670z3JVpQIESF%2Fimage.png?alt=media&#x26;token=ec4cd975-39c8-4aaf-990b-3d68ecb31c3f" alt=""><figcaption></figcaption></figure>
3. Click **Upload** (top right)

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2FwUIE10HD8gmlG7Gvnhtb%2Fimage.png?alt=media&#x26;token=d6e8498f-2fde-4e46-a29c-ca7d2a338f85" alt=""><figcaption></figcaption></figure>
4. Upload your CSV file. *(See the example above for formatting.)*

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2Foe9Kzv3savdsTfCdPskj%2Fimage.png?alt=media&#x26;token=d9ad88ba-205f-4fe8-bdad-79c91488f98c" alt=""><figcaption></figcaption></figure>
5. **Map columns** to the correct Cymbal fields

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2Fe1iAGGuFeVatp5TKXUcg%2Fimage.png?alt=media&#x26;token=e2402ecc-6131-4358-a00b-fb4031937998" alt=""><figcaption></figcaption></figure>
6. Review the **confirmation** modal and respond to any additional questions

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2FGV97sy6LOLm2SwzeusLq%2Fimage.png?alt=media&#x26;token=9c4a6ec3-fb73-46e5-8e79-9875501e20e5" alt=""><figcaption></figcaption></figure>
7. Click **Upload** to complete.

***

## Managing Past Uploads

To review or delete past uploads:

1. Click **Upload** again

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2Fzzkk9xARtSmTfjcbfcAd%2Fimage.png?alt=media&#x26;token=ccf34404-0455-4e39-af43-4f084df550ee" alt=""><figcaption></figcaption></figure>
2. Select **Manage past upload**

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2FoSPrT56QzVq9ZK2L3Chi%2Fimage.png?alt=media&#x26;token=3e1dfc58-578b-4c9c-9e94-f9737fffdc9e" alt=""><figcaption></figcaption></figure>
3. Here you can view all past uploaded CSVs and delete any if needed

   <figure><img src="https://3106879467-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoQT7U7QQ2l3wKMDKfZ0M%2Fuploads%2Ffuf918zpk0xk3PBxmCKa%2Fimage.png?alt=media&#x26;token=3427a1f2-6666-4275-a405-e1da45dd780d" alt=""><figcaption></figcaption></figure>
