I have a potential client who sells cosmetic products in wholesale.
He has over 1.000 active products made by several different industries in about a dozen categories.
The thing is that he currently uses a custom made software for keeping track of sales and inventory, completely offline, which is great and he's happy with it and he wants to keep it exactly as it is, especially since all of his staff already knows how to use this software and all.
Initially he told me he didn't want an e-commerce website, that he could manage the sales offline. Later I understood that he does need a site where the user can browse through the products, add them in bulk to the cart, selecting quantities for each product, etc... He just doesn't want to manage the sales through one of these online systems since he already has one in place... So he could make it work with just receiving a form with every purchase for example so we would only have to automate how the forms come into an email and then onto their offline system.
I am in touch with the developer who created and manages this software but his knowledge is limited when it comes to the internet, he's more of an old school system analyst, kinda guy. But he tells me he has this database in SQL and that he could export it in the best way possible, to be determined by whatever CMS I decide to use.
In my end, I wish I knew more about coding but I'm really a designer and my skills are also very limited on this front. So here are my questions;
What organ of my body would I have to give up, to have you guys help me import this directly into Webflow's CMS? I could create the CMS structure according to the database and then you could do a little magic and shazam, all the data would be instantly imported into the website I design the way I want using only my beloved Webflow. - I'm pretty sure that's not even possible but it was worth a shot...
Is there a more appropriate tool for this particular case? Do you know if any of the other systems (Ecwid, Shopify, Paystand..) or even something on Wordpress or Woocommerce or whatever, would support this kind of bulk importing?
Thank you all so much for your time and input...