advice needed on client not understanding....

I Have a client 99.99% of their website completed, just testing. they are giving me stress on them having to do products. their manufacturer gave me an excel spreadsheet with all the product details which I uploaded to database. I assigned all products as NOT LIVE. as the client would need to assign the product to multiple categories. (I have tried explaining that there is no way the website could know what category a product belongs to so they need to do this manually. The manufacturer excel file does include its own category names, but these are completely different to how the client wants their categories setup (so I couldn't use it).


But the client just doesn't understand, one of their "helpers" is telling me her website does everything automatically. But I just don't believe that as how can the website know. And so because the products don't have categories they obviously don't show on website until client assigns them and makes them go live (they want ALL products to be live automatically) but I tried explaining that they still wont show until they assign each individual one to a category (plus the manufacturer didn't even provide product descriptions as well even upon request by me, instead they use long product names. So the client would need to update those as well. The amount of stress the client is giving me is immense as they are suggesting the website doesnt work to how they want it (they seem to think that by a press of a button everything works. Its very frustrating. I just need advice.

Also since the client wanted products to be assigned to multiple categories and that the category names could change at any time, I am using the database record ID to store the category/product.


How is the best way to explain to the client what they are asking is impossible?


Chris