Scrapping delivers messed data

[MakiM]

I am trying to get the information ogf the 5157 items listed in the "medicamentos" page, but cant's seem to be able to make this work. I get incomplete and disorganized data.

Url: https://www.farmaciasanpablo.com.mx/medicamentos/c/06?sort=name-asc&q=%3Arelevance#

Sitemap:
{"_id":"san_pablo","startUrl":["https://www.farmaciasanpablo.com.mx/medicamentos/c/06?sort=name-asc&q=%3Arelevance#"],"selectors":[{"id":"main","type":"SelectorElement","selector":"div.col-xs-12:nth-of-type(1) div.row.fsp-grid","parentSelectors":["_root"],"multiple":true,"delay":0},{"id":"name","type":"SelectorText","selector":"div.row:nth-of-type(1) p.item-title","parentSelectors":["main"],"multiple":true,"regex":"","delay":0},{"id":"descr","type":"SelectorText","selector":"div.row:nth-of-type(1) p.item-subtitle","parentSelectors":["main"],"multiple":true,"regex":"","delay":0},{"id":"price","type":"SelectorText","selector":"div.row:nth-of-type(1) p.item-prize","parentSelectors":["main"],"multiple":true,"regex":"","delay":0},{"id":"next","type":"SelectorElementClick","selector":"div.row.section-header a.next span","parentSelectors":["_root"],"multiple":false,"delay":0,"clickElementSelector":"div.row.section-header a.next span","clickType":"clickOnce","discardInitialElements":false,"clickElementUniquenessType":"uniqueText"}]}

[iconoclast]

Hi there!

The website URL provide very useful data — page number, so you can use pagination brackets [ ... ] instead of clicking Next.

All you have to analyze is number of pages to scrape, it's just 172.

You have to envelop starting and ending page within brackets, separated by a minus sign.

Please note that the beginning page has a 0 as a page number, so starting from 0 to 171 equals 172 pages.

Try this sitemap:
{"_id":"san_pablo","startUrl":["https://www.farmaciasanpablo.com.mx/medicamentos/c/06?q=%3Aname-asc&page=[0-171]"],"selectors":[{"id":"Item_grouped","type":"SelectorElement","selector":"div.col-md-9 div.col-xs-12","parentSelectors":["_root"],"multiple":true,"delay":0},{"id":"Name","type":"SelectorText","selector":"p.item-title","parentSelectors":["Item_grouped"],"multiple":false,"regex":"","delay":0},{"id":"Dose","type":"SelectorText","selector":"p.item-subtitle","parentSelectors":["Item_grouped"],"multiple":false,"regex":"","delay":0},{"id":"Price","type":"SelectorText","selector":"p.item-prize","parentSelectors":["Item_grouped"],"multiple":false,"regex":"","delay":0},{"id":"Out of Stock","type":"SelectorElementAttribute","selector":"button.btn","parentSelectors":["Item_grouped"],"multiple":false,"extractAttribute":"disabled","delay":0}]}

To have results being strictly ordered, I would recommend you to use CouchDB.
For CouchDB, please refer to this page: https://webscraper.io/documentation#storage-backends