scron
asked on
Example MySQL statement for Wholesale/Retail product details for both the buyer and shipping company
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!
Scron
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!
Scron
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just wondering where and how I run it and can programmers modify it needed.
The sources I get? Online images and text, emails csv, excel files, txt files, dvds, cds with folder names as part of the name of a column! So I have to what with a Folder name that is critical To! Like folder name 42InchKids with many 42 inch images of ceiling fans
PS how are Images handled in Databases? Say I put the images into a file named?
then direct the database to go to that file path???
or What or do I need to go to the backend and find the product and upload the images separately I am guessing that is the way.
The sources I get? Online images and text, emails csv, excel files, txt files, dvds, cds with folder names as part of the name of a column! So I have to what with a Folder name that is critical To! Like folder name 42InchKids with many 42 inch images of ceiling fans
PS how are Images handled in Databases? Say I put the images into a file named?
then direct the database to go to that file path???
or What or do I need to go to the backend and find the product and upload the images separately I am guessing that is the way.
I will do a mockup of how it takes a file and imports it into a table, you can modify it at your pleasure.
ASKER
how could the mockup become a php file? also?
ASKER
Does it need to be put on the webserver into a php folder.
In other worlds how is run?
I can open MSDOS txt box and familiar with typing commands in there.
What I do have trouble with so far is writing SQL statements and getting them to work I guess that will take time and learning...
I went to a conference last night and the speaker worked in cakephp etc. and I asked him that question and that is what he suggested! a Mapping method and using the ARRAY to get it to change over to a uniform table names is true it is needed.
Does it import the XML style files just curious since is pretty new. But not really likely would use it. THANKS!!!!