Scraping each values in a page (single product code) in more rows

How to?
#1

Hi guys,

this project is awesome. Good work and thank you so much for this extension.:star_struck:

So, I want to know if is possible to scrape each values in a page (single product code) in more rows. Example:

This is a content of page:

Product Name (title)

00001 (code)

Color Avaible:
White
Blue

Compatibility Parts:
AUDI
BMW

So I want this result:

| TITLE | CODE | COLOR | COMPATIBILITY |
| Product Name | 00001 | white | audi |
| Product Name | 00001 | white | bmw |
| Product Name | 00001 | blue | audi |
| Product Name | 00001 | blue | bmw |

The result is 4 rows, for that page..is it possible?I try in more method but nothing resolve it.

How can I do?

#2

It depends on page design. If there are just two lists then it won't be possible to scrape the page like this. You can select colors and parts with grouped selector, but then they will be stored in one row. If you can post the pages URL I can take a closer look.

#3

yes, of course

I have found this example pages URL that represent the same my example:
https://www.crosshop.eu/parafango-post-Ufo-Honda-Cr-125-1985-1990-Honda-Cr_W0QQcodiceZho+02601QQformatZdettaglioQ145phpQQlinguaZIT
https://www.crosshop.eu/parafango-post-Polisport-Kawasaki-Kx-125-250-1999_W0QQcodiceZp859510000QQformatZdettaglioQ145phpQQlinguaZIT
https://www.crosshop.eu/parafango-post-Acerbis-Honda-Crf-r-250-2014-2017-H_W0QQcodiceZ0016888QQformatZdettaglioQ145phpQQlinguaZIT

This is an example of three pages. Do you thing that is it possible with web scraper?

Thank you

#4

The only way to scrape this site would be using grouped selectors. Here is an example sitemap:

{"_id":"crosshop_example","startUrl":["https://www.crosshop.eu/parafango-post-Ufo-Honda-Cr-125-1985-1990-Honda-Cr_W0QQcodiceZho+02601QQformatZdettaglioQ145phpQQlinguaZIT"],"selectors":[{"id":"page_element","type":"SelectorElement","selector":"section#main","parentSelectors":["_root"],"multiple":true,"delay":0},{"id":"title","type":"SelectorText","selector":"h1.title-product","parentSelectors":["page_element"],"multiple":false,"regex":"","delay":0},{"id":"code","type":"SelectorText","selector":"span.opt-price:nth-of-type(4)","parentSelectors":["page_element"],"multiple":false,"regex":"","delay":0},{"id":"colors","type":"SelectorGroup","selector":"span.box-color","parentSelectors":["page_element"],"delay":0,"extractAttribute":""},{"id":"models","type":"SelectorGroup","selector":"div.info-moto-compatibilta li","parentSelectors":["page_element"],"delay":0,"extractAttribute":""}]}

#5

ah ok, thank you so much for your time.

Do you know something method in excel to extract that values in differente row?