Rappi fields in every export
Records are typed by vertical rather than merged. Restaurant rows carry venue, menu section, item, description, price and option groups. Retail and grocery rows carry product, brand, pack size, unit price, category and barcode where published. Pharmacy rows add composition and prescription status where the platform states it.
Country and currency are first class fields on every row. Rappi operates on local currencies that move at different speeds, and a price series that does not record which currency it is in cannot survive contact with a year of inflation.
Merchant records carry the store name, category, address and city, delivery fee, minimum order, estimated delivery time and open state, kept separate from the items.
Unit price is computed for grocery and pharmacy rows where weight or count is published, because comparing a six-pack against a single unit is not a comparison.
Availability and the collection timestamp are on every row, with the country domain recorded so a row can always be traced back to the market it came from.