The homepage for the {trundler} R package is at https://datawookie.github.io/trundler/.
Install from GitHub.
remotes::install_github("datawookie/trundler")
library(trundler)
Check version.
packageVersion("trundler")
[1] '0.1.5'
To access the full API you’ll need to first specify an API key.
# Example API key (this key will not work).
#
set_api_key("5bed3ac9-6dc9-4926-aed8-8c97a7cb8057")
To obtain a key, please get in touch. Contact details are in
DESCRIPTION
.
You can also subscribe via RapidAPI, in which case you use a different function to register your key.
set_rapidapi_key("5a1ae0ce24mshd483dae6ab7308dp129ef6jsn1f473053d6b0")
Use retailer()
to get a list of retailers.
retailer()
# A tibble: 103 x 4
retailer_id retailer retailer_url currency
<int> <chr> <chr> <chr>
1 1 EEM Technologies https://www.eemtechnologies.com/ USD
2 2 Clicks https://clicks.co.za/ ZAR
3 3 Dischem https://www.dischem.co.za/ ZAR
4 4 Game https://www.game.co.za/ ZAR
5 5 Woolworths https://www.woolworths.co.za/ ZAR
6 6 Fortnum & Mason https://www.fortnumandmason.com/ GBP
7 7 John Lewis https://www.johnlewis.com/ GBP
8 8 Marks & Spencer https://www.marksandspencer.com/ GBP
9 9 Pick 'n Pay https://www.pnp.co.za/ ZAR
10 10 Makro https://www.makro.co.za/ ZAR
# … with 93 more rows
Or you can acccess the details for a specific retailer.
retailer(45)
# A tibble: 1 x 4
retailer_id retailer retailer_url currency
<int> <chr> <chr> <chr>
1 45 Builders Warehouse https://www.builders.co.za/ ZAR
Get a list of products for a specific retailer.
retailer_products(5)
# A tibble: 92,284 x 5
product_id product brand model sku
<int> <chr> <chr> <chr> <chr>
1 2591731 Soft Touch Bikinis 2 Pack <NA> <NA> 60092074…
2 606751 Belted Chinos Woolworths Classi… <NA> 60092117…
3 606756 Cropped Leggings Woolworths Classi… <NA> 60092110…
4 606804 Pure Cotton Towelling Nappies … <NA> <NA> 60092149…
5 607099 Best Baby Ever Cotton Blend T-… <NA> <NA> 60092149…
6 607120 DR. HAUSCHKA Night & Active Kit Dr. Hauschka <NA> 40208290…
7 607465 Non-slip Chrome Hangers 5-Pack <NA> <NA> 60091732…
8 608276 Extra Depth & Length 144TC Cot… <NA> <NA> 60092146…
9 608341 144TC Cotton Blend Fitted Sheet <NA> <NA> 60092146…
10 608419 All Year Round Temperature Com… <NA> <NA> 60091789…
# … with 92,274 more rows
Products can be filtered by name and brand.
retailer_products(5, product = "coffee", brand = "nespresso")
# A tibble: 5 x 5
product_id product brand model sku
<int> <chr> <chr> <chr> <chr>
1 667365 NESPRESSO Essenza Mini Coffee Machine Nespres… <NA> 76300396187…
2 667426 NESPRESSO Citiz&Milk Coffee Machine Nespres… <NA> 76300544309…
3 667654 NESPRESSO Lattissima Touch Coffee Mach… Nespres… <NA> 76300476151…
4 667815 NESPRESSO Lattissima One Coffee Machine Nespres… <NA> 76300396464…
5 729093 NESPRESSO Creatista Plus Coffee Machine Nespres… <NA> 76300396488…
A similar search can be applied across all retailers.
products(product = "hand sanitiser")
# A tibble: 126 x 6
product_id retailer_id product brand model sku
<int> <int> <chr> <chr> <chr> <chr>
1 2121127 63 Kids Waterless Hand Saniti… Handtizer <NA> KID330
2 1427238 5 CHARLOTTE RHYS St Thomas W… Charlott… <NA> 606110261…
3 1753347 63 Waterless Hand Sanitiser -… Charlott… <NA> FCR075HAN…
4 1753348 63 Waterless Hand Sanitiser -… Charlott… <NA> FCR300WHS
5 1782558 3 Aquashield Hand Sanitiser … <NA> <NA> 000000000…
6 1782566 3 Aquashield Hand Sanitiser … <NA> <NA> 000000000…
7 1782675 3 Aquashield Hand Sanitiser … <NA> <NA> 000000000…
8 1782684 3 Aquashield Hand Sanitiser … <NA> <NA> 000000000…
9 2121135 63 Waterless Hand Sanitiser -… Handtizer <NA> HAND330
10 2265497 95 Dettol Instant Hand Saniti… <NA> <NA> 10614438EA
# … with 116 more rows
products(product = "coffee", brand = "nespresso|nescafe")
# A tibble: 179 x 6
product_id retailer_id product brand model sku
<int> <int> <chr> <chr> <chr> <chr>
1 1515084 13 Nescafe Original Instant Co… NESCAFE <NA> 254889601
2 1471626 35 NESPRESSO Magimix CitiZ & M… NESPRESSO <NA> 311-8204…
3 1492620 13 Nescafe Original Decaffeina… NESCAFE <NA> 254889371
4 1513042 13 Nescafe Dolce Gusto Preludi… NESCAFE … <NA> 296837064
5 1486019 13 Nescafe Dolce Gusto Cafe Au… NESCAFE … <NA> 301217353
6 1486026 13 Nescafe Dolce Gusto America… NESCAFE … <NA> 266292846
7 1492565 13 Nescafe Original Decaffeina… NESCAFE <NA> 254889388
8 1492555 13 Nescafe Black Gold Instant … NESCAFE <NA> 297876954
9 1486022 13 Nescafe Dolce Gusto Flat Wh… NESCAFE … <NA> 301217330
10 1486010 13 Nescafe Dolce Gusto America… NESCAFE … <NA> 276686404
# … with 169 more rows
products(product = "tv", brand = "samsung|hisense")
# A tibble: 954 x 6
product_id retailer_id product brand model sku
<int> <int> <chr> <chr> <chr> <chr>
1 1417977 51 "Samsung 49\" UA49RU7100 LED UH… Samsu… <NA> UA49RU7…
2 1417983 51 "Samsung 55\" QA55Q60RAK QLED 4… Samsu… <NA> QA55Q60…
3 1417984 51 "Samsung 65” QA65Q60RAK QLED UH… Samsu… <NA> QA65Q60…
4 1417987 51 "Samsung 65” QA65Q900RBK QLED 8… Samsu… <NA> QA65Q90…
5 1417988 51 "Samsung 65\" QA65Q70RAK QLED U… Samsu… <NA> QA65Q70…
6 1417989 51 "Samsung 65\" QA65Q80RAK QLED U… Samsu… <NA> QA65Q80…
7 1417991 51 "Samsung 75\" QA75Q60R QLED UHD… Samsu… <NA> QA75Q60R
8 1418018 51 "Samsung 82” Q60R QLED UHD Smar… Samsu… <NA> QA82Q60
9 1418021 51 "Samsung 40” N5000 LED FHD Tv" Samsu… <NA> UA40N50…
10 1418023 51 "Samsung 49” N5000 LED FHD Tv" Samsu… <NA> UA49N50…
# … with 944 more rows
Information on a specific product.
item <- product(530290)
What fields are available?
names(item)
[1] "product_id" "retailer_id" "product_url" "product" "brand"
[6] "model" "sku" "barcodes"
Get product name, SKU and barcodes.
item$product
[1] "Ola Rich 'n Creamy Magical Unicorn Ice Cream 1.8l"
item$sku
[1] "000000000000777619_EA"
item$barcodes
[1] NA
Get price history data for a specific product.
product_prices(530290)
# A tibble: 41 x 6
product_id time price price_promotion price_effective
<int> <dttm> <dbl> <dbl> <dbl>
1 530290 2020-05-10 03:23:38 50.0 40.0 40.0
2 530290 2020-05-09 02:56:09 50.0 40.0 40.0
3 530290 2020-05-08 01:36:36 50.0 40.0 40.0
4 530290 2020-05-06 03:06:50 50.0 40.0 40.0
5 530290 2020-05-05 01:34:16 50.0 40.0 40.0
6 530290 2020-05-04 02:56:37 50.0 40.0 40.0
7 530290 2020-05-03 03:01:05 50.0 40.0 40.0
8 530290 2020-05-02 04:27:22 50.0 40.0 40.0
9 530290 2020-05-01 02:20:50 50.0 40.0 40.0
10 530290 2020-04-30 02:21:07 50.0 40.0 40.0
# … with 31 more rows, and 1 more variable: available <lgl>
Use bumpversion to cleanly increment the version.
$ bumpversion patch
$ bumpversion minor
$ bumpversion major
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.