In need of suggestions on the best way to create poducts database
Just purchased the dynamic suite today. Looking forward to creating a more modern online store for our shop. However, I am a unfamiliar with setting up SQL databases. Unfortunately, our shop uses peachtree accounting for inventory control (worst software, EVER). I can get our inventory to export to an excel sheet in a somewhat easy to use format. We have 9000+ different inventory items, and I would prefer not to do manual data entry for the database, for obvious reasons. We sell antique motorcycle parts and I would like to keep the format simple. Something like this....
Part Number Description Price
I really need it to be that simple. This is how it is setup in peachtree and I do not want to edit each item one by one, I have done similar adjustments in the past and it takes ages and there is too much risk of error involved with peachtree. I would prefer to use an open source, or free, tool to convert my inventory excel sheet into a SQL database. I was hoping somebody on the support team would have a suggestion that would integrate nicely with eCart. I have seen SQL convert for excel, but it costs $50. I would only really need to use the tool once, right? Pretty sure I cannot justify the purchase to the boss after we spent $300 on the suite. I am struggling to modernize a very old school motorcycle shop, any suggestions would be much appreciated.