I'm new to Wix so please bear with me.
I've designed a new website for my business using Wix which shows all of the products I am able to sell. There are around 50-60 individual model pages, each of which shows information and technical data for the product and, at the bottom, all of the products within the model range are listed with part description and pricing along with other options which are compatible with that model.
The problem I face is that pricing changes on at least a monthly basis and it is a long and laborious task to update every single page.
Is there a way of using a database to display the description and price based upon the part number so that I can just update a database using an export from my pricelist which is stored in Excel?
If it helps, here is a link to one of the pages - https://www.touchscreens-direct.co.uk/signage-4202l . At the bottom of the page, a table of products and prices is shown. Whilst the description doesn't change I need to find an easier way of updating the pricing every month (in total there are over 500 products, some of which can be listed on multiple pages).
Oh and idally the part numbers need to be detectable in a search engine so that anyone searching for the part number on the Internet will be able to link to the page/site.
Any assistance, advice or guidance is gratefully appreciated.