I'm already down I'm afraid :( this client is one of those clients from hell. I even spoke to the supplier that she uses as she told me to contact him since they are the ones that send the product list via excel. Even after explaining to him her requirements he even said usually they don't do it that way. That their other clients would usually have to go in and manually assign a product to what ever category. Because on supplier product list their categories could change at any time. Plus each day the supplier needs to take the product info from website via csv then update it and then give back to client to refresh products on website. So even if I did some kind of category 'mapping' it will still cUse issues.
This client is a nightmare because she doesn't like me sending long emails explaining what I need to do, or questions I need to raise so that we can think about options or ways of doing things (for example with delivery using two different delivery companies and they calculate delivery costs 2 different ways with different post code zone tables) I need to ask her and she just gets rude and tells me to just finish it or she will take me to court! The website build had been going on since 2014 as I've got a new job now and even though I told her back then I neee to get website finished due to new job she still kept delaying me so I could t finish it back then, so now I had to do it in my spare time. And only now (when it's almost finished and I ask her to test it, it feels like the first time she's seen it and telling me certain features need to be done this way or that as other websites do it that way, I try and tell her that we never agreed to it in original price of website but she turns round and says that other websites do it so it's common sense. I can tell you a lot more how bad this client has been but don't want to bore you :( I kinda wish I never met her as she keeps blaming me when I was only going on original project plan she originally agreed on. So stressed :(