Zoho Inventory

On paper, Zoho had all the flexibility and scalability we were looking for, but it turns out that it is incompatible with a Shopify store that has more than a few months of data. It won't import the data. This is not a misunderstanding and there is no workaround. Details below.

We bought it to be our CRM and Inventory Management System for our Shopify office furniture store. On installation, it would only import the last two months of transactions from Shopify. That's a disaster. For all of our regular customers, they'd have two accounts and we'd have to look in both places to find a past order, not to mention re-creating all of their account data by hand in the new system if they hadn't purchased in the last two months, and we'd have no idea what their lifetime value was.
Zoho support was sure I had done something wrong. It took weeks for them to decide that Shopify was the problem. They told me Shopify was blocking the export of the data. So I called Shopify. They told me (in an hour) that they have an automatic block to prevent hacking but all Zoho had to do was to call them and they'd unblock them!
Over a period of weeks, I tried to get to the right department to tell the install team or dev team about this, and no one seemed to know what I was talking about. They kept insisting it was a Shopify problem. A support rep got back to me a few months later and said the limitation had actually been built into Zoho and it would be fixed in the next version update. So, foolishly, I kept paying. I kept checking in and finally, two years later, they told they have no plans to fix this problem, and no, I couldn't have a refund even though I was waiting for them to fix what they told me they would fix, and had never used the product.