Trying to create / modify from a template for an about 18 fields! table to pull into a MYSQL products_table from EXCEL. Also am trying to plan out the Excel SS so it can handle hundreds of manufactures with many product types. And also support Retailers who need help with uploading their data to their store fronts. Should each Store have its own Excel page in the Excel file? Should the many manufacuturers use common product titles for their products and a area below with the manufacturers own title name which may be different from a universal title. EX: Product_Desc vs Product_Des vs Product_About vs Product_Details so if same type info they would have to under one common title to be uniform to a website database for product_table use in MYSQL
What would really help first is someone has a detailed advancded Excel SS for such product lists that include shipping weights and dim weight, etc. to show a Buyer, the Vendor and the Shipping Company the data they each need.
And if possible SQL Statements examples that could be starting point template to get the products into the database after their "name normalization".
Thank you in advance!