How to have scraped product data on a single excel row?

I'm scraping a website with multiple links for product categories. When I export the data, I've noticed that for a single product I will have different excel rows and this is a problem because I need to have all the product informations on a single excel row. How I can fix this, maybe with a setting into the selectors?

this is the sitemap
{"_id":"deco","startUrl":["https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/frutta_277","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/verdura-legumi-e-cereali_7","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/carne_5","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/formaggi_8","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/salumi_9","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/gastronomia_13","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/latte-burro-uova_10","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/yogurt-e-dessert_11","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/surgelati-e-gelati_15","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/pasta-pane-e-farinacei_12","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/condimenti_351","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/olio_349","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/sughi_350","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/caffe-ed-infusi_345","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/dispensa-e-scatolame_352","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/dolci_17","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/snack-dolci-e-salati_348","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/acqua_343","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/aperitivi-e-birra_347","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/bibite_346","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/liquori_344","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/tutto-per-l-infanzia_19","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/animali_18","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/capelli_20","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/cura-del-corpo_21","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/igiene-orale_22","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/carta-e-plastica_25","https://decoacasa.multicedi.it/spesa-consegna-domicilio/84135/detersivi-e-pulizia-casa_24"],"selectors":[{"clickElementSelector":"a.button--load-more","clickElementUniquenessType":"uniqueCSSSelector","clickType":"clickMore","delay":500,"discardInitialElements":"do-not-discard","id":"product-wrapper","multiple":true,"parentSelectors":["_root"],"selector":"div.li","type":"SelectorElementClick"},{"id":"Brand","multiple":true,"parentSelectors":["product-wrapper"],"regex":"","selector":"span[itemprop='name']","type":"SelectorText"},{"id":"Descrizione","multiple":true,"parentSelectors":["product-wrapper"],"regex":"","selector":"h3","type":"SelectorText"},{"id":"Prezzo Unitario","multiple":true,"parentSelectors":["product-wrapper"],"regex":"","selector":"div:nth-of-type(5)","type":"SelectorText"},{"id":"Peso","multiple":true,"parentSelectors":["product-wrapper"],"regex":"","selector":"div.size","type":"SelectorText"},{"id":"Prezzo","multiple":true,"parentSelectors":["product-wrapper"],"regex":"","selector":"span.price","type":"SelectorText"}]}

@ohict This happens because you have created several same navigation level selectors checked with the 'Multiple' option.

To fix this, you should change the 'Text' selectors to the 'Grouped' instead or uncheck the 'Multiple' option for all of the 'Text' selectors.

Learn more:

1 Like

You mean into the product card selectors I have?