# Bittrex csv orders error on import for all entries

**URL:** <https://discuss.koinly.io/t/bittrex-csv-orders-error-on-import-for-all-entries/19808>\
**Category:** Koinly Support\
**Created:** [February 29, 2024, 3:59pm UTC](https://discuss.koinly.io/t/bittrex-csv-orders-error-on-import-for-all-entries/19808 "2024-02-29T15:59:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![CJR777](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/cjr777/32/1316_2.png) [@CJR777](https://discuss.koinly.io/u/CJR777)\
**Post date:** [February 29, 2024, 3:59pm UTC](https://discuss.koinly.io/t/bittrex-csv-orders-error-on-import-for-all-entries/19808/1 "2024-02-29T15:59:46Z")

</div>

**Describe the problem:**  
error when importing bittrex CSV I was given by bittrex support today get the following error: unknown side value: LIMIT . This only happens for the ORDERS csv they sent, the deposit and withdrawl csv files import fine.

 ![image](https://canada1.discourse-cdn.com/flex052/uploads/koinly_app/original/2X/9/9e2097d5aad36168c218a1a3b8c9269bc97066ef.png)

**Which exchange/wallet is this regarding?**  
bittrex

**How did you import data into this wallet?**  
CSV given by bittrex support

**What have you tried to fix this so far?**  
nothing , stuck, please help!

---

<div class="post-metadata">

**Author:** ![Carl\_Koinly](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/carl_koinly/32/854_2.png) [@Carl\_Koinly](https://discuss.koinly.io/u/Carl_Koinly)\
**Post date:** [March 4, 2024, 6:01pm UTC](https://discuss.koinly.io/t/bittrex-csv-orders-error-on-import-for-all-entries/19808/2 "2024-03-04T18:01:11Z")

</div>

Hi CJR777

Thanks for your message. 😊

This sounds like one for the team so they can take a closer look at the file the Bittrex team sent.

I’ll DM you. 👍🏻

---

<div class="post-metadata">

**Author:** ![schmar](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/schmar/32/441_2.png) [@schmar](https://discuss.koinly.io/u/schmar)\
**Post date:** [April 1, 2024, 7:48pm UTC](https://discuss.koinly.io/t/bittrex-csv-orders-error-on-import-for-all-entries/19808/3 "2024-04-01T19:48:38Z")

</div>

Got the same problem. @Carl_Koinly could you share the solution here? Thank you 🙂

EDIT: IDK what columns koinly expects, but the current (last week) format you get from the bittrex-support is this:

Closed Orders (doenst work because “Type” cannot be “LIMIT” in my case, and when I put the values from “Side” in there (BOUGHT/SOLD) the sender/receivers are flipped)  
Uuid,Exchange,Closed (UTC),Opened (UTC),Side,Type,Time In Force,Bid/Ask,Quantity,Remaining,Total,Avg. Price per Share

Closed Deposits (seems to work):  
Deposit Uuid,Currency,Amount,State,Confirmations,Last Updated (UTC),TxId,Crypto Address

Closed Withdrawles (seems to work)  
Payment Uuid,Currency,Amount,Address,Opened (UTC),Authorized,Canceled,Tx Fee,TxId

---

<div class="post-metadata">

**Author:** ![Carl\_Koinly](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/carl_koinly/32/854_2.png) [@Carl\_Koinly](https://discuss.koinly.io/u/Carl_Koinly)\
**Post date:** [April 8, 2024, 6:46pm UTC](https://discuss.koinly.io/t/bittrex-csv-orders-error-on-import-for-all-entries/19808/4 "2024-04-08T18:46:46Z")

</div>

Hey @schmar

Thanks for your message, so sorry, I missed your tag! 🙏🏻

I’ve just taken a look at the solution that was provided to CJR777 and the headers were changed slightly in the Closed Orders file. The ‘Type’ and ‘Side’ were switched, so Type is now column E and Side is column F. 👍🏻

Bittrex is exporting some of its data incorrectly, so as a heads up, my colleague also provided some extra tips in case some tokens are imported the wrong way round (BTC-ETH instead of ETH-BTC for example). I’ve copied/pasted this below in case you encounter the same problem:

- Import my file to Koinly
- Find implausible trades
- Once you do, open the file in Excel or a text editor and using find&replace change all occurrences of this pair in the file. As an example, you would change BTC-ETH to ETH-BTC.
- You do **not** have to change the direction (Buy/Sell) - only switch the base-quote in the pair
- Repeat this until you identify all the implausible pairs
- After that delete the wallet from Koinly and add it again using your modified file

Hopefully, you won’t need that, but that’s the solution if there are any problems with the tokens being switched. 👍🏻

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex052/uploads/koinly_app/original/1X/7ac58e5593a7122893d066794a7254dcdb5ddb31.png) [@system](https://discuss.koinly.io/u/system)\
**Post date:** [April 8, 2024, 9:47pm UTC](https://discuss.koinly.io/t/bittrex-csv-orders-error-on-import-for-all-entries/19808/5 "2024-04-08T21:47:12Z")

</div>

This topic was automatically closed 3 hours after the last reply. New replies are no longer allowed.
