Here is the link to the excel: https://www.dropbox.com/s/7fam0cqean0lm8k/SNOC%20PRICE%20LIST%202016%20master.xls?dl=0
I have an excel file that needs to be broken down, categorized and then modified so that "all" items that are offered in various finishes with various glass options etc gets created row by row on an excel for database loading. Your skills will be to be able to create tables, look at the pdf catalog to see what items comes in what finishes or glass and then create "every" single combinations of finish / glass etc row by row on an excel file. I estimate that the products will take up 50,000 rows when done. I have already start messing around with this to see how difficult it will be to do this. Breaking this down is essential for me to sell this company using our database so I need "all" items and their respective combinations created row by row using excel commands and all options for every item need to be created for this company. I need the complete model number created for this company. On the attached, in tab 1...named fixtures. I highlighted one item: 1010_. There are three categories of finishes that this item comes in: Solid, Color, Antique and each of those are difference prices. So I would need all combinations of every item in the entire line broken down with the item number and price and description. So in this case it would look like this:
1010 would be listed 28 times as there are 3 solid, 17 color and 9 Antique finishes...so I need this listed row by row. On the attached, there are many tabs that show all the options...I need this done so I can load the line on the internet and into my database. One option would be to do product modifiers...but the issue there will be pricing everything out...I would rather just list the completed item number out like this with a "_" in between all options. Tab 2 of the attached shows what I want...I just transpose pasted and then vlookuped and =concatenated etc. From here...I will add more and more information by web-scraping data...but I want to start by creating "every" item in this company. You can see the line on their site at: http://www.snocinc.com/
For lighting products....such as the Montpellier Collection...item 3311...this would also need the Glass added to the item so this would be a "lot" of combinations...so it would be something like this:
Then the same list of glass again for the next finish: _3 and so on.