I posted it here, but worth sharing to all
https://www.ozbargain.com.au/comment/5612963/redir
it isn't 100% accurate but better than nothing.
you need the office works product code, ie. WDEL1000PT
You also need the store ID, for Dee Why it is W204
then just run the following url.
https://api.officeworks.com.au/v2/availability/store/W204?pa…
returns "qty":57
list of store ids here
https://www.ozbargain.com.au/comment/5613967/redir
Officeworks can unilaterally purport to "prohibit" certain conduct all it likes, but how is this binding on anyone?
This isn't scraping though - it's an API request which returns JSON.
LOL ok lemme rephrase: if you're intending to go extracting the officeworks inventory, at least do it surreptitiously.
OP: one idea i had in the past was to do the same with the MSY webstore and identify the common products. that way you get MSY prices at officeworks convenience.
Anyone has experience scraping Woolworths?
I am looking to do it but they don't do API.
now, what sort of fun would it be if they just HANDED you an API, huh?
tip: use firefox to example your browser's HTTP requests, then learn how to replicate them awesome chrome app Postman
{
"Products": [
{
"Stockcode": 19252,
"Barcode": "9400517173173",
"GtinFormat": 13,
"CupPrice": 0,
"CupMeasure": "0",
"CupString": "$0.00 / 0",
"HasCupPrice": false,
"Price": 37,
"Name": "Smirnoff Red Vodka ",
"UrlFriendlyName": "smirnoff-red-vodka",
"Description": " Smirnoff Red Vodka 700ml",
"SmallImageFile": "https://cdn0.woolworths.media/content/wowproductimages/small/019252.jpg",
"MediumImageFile": "https://cdn0.woolworths.media/content/wowproductimages/medium/019252.jpg",
"LargeImageFile": "https://cdn0.woolworths.media/content/wowproductimages/large/019252.jpg",
"IsNew": false,
"IsOnSpecial": true,
"IsEdrSpecial": false,
"SavingsAmount": 7,
"WasPrice": 44,
"QuantityInTrolley": 0,
"Unit": "Each",
"MinimumQuantity": 1,
"HasBeenBoughtBefore": false,
"IsInTrolley": false,
"Source": "Aisle.Liquor.Spirits",
"SupplyLimit": 36,
"IsRanged": false,
"IsInStock": true,
"PackageSize": "700ml",
"IsPmDelivery": false,
"IsForCollection": true,
"IsForDelivery": true,
"IsForExpress": false,
"ProductRestrictionMessage": null,
"CentreTag": {
"TagContent": null,
"TagLink": null,
"FallbackText": null,
"TagType": "None"
},
"IsCentreTag": false,
"ImageTag": {
"TagContent": "/content/promotiontags/final-special.png",
"TagLink": "",
"FallbackText": "On Special",
"TagType": "None"
},
"HeaderTag": {
"BackgroundColor": "#fd0",
"BorderColor": "#fd0",
"TextColor": "#000",
"Content": "Save $7.00",
"TagLink": null,
"Promotion": "Special"
},
"HasHeaderTag": true,
"UnitWeightInGrams": 700,
"SupplyLimitMessage": "'Smirnoff Red Vodka ' has a supply limit of 36. The quantity in your cart has been reduced accordingly. To purchase a larger quantity, please contact us on 1800 000 610, or e-mail us at [email protected]. Please note - we do not supply trade orders.",
"SmallFormatDescription": "Smirnoff Red Vodka ",
"FullDescription": "Smirnoff Red Vodka ",
"IsAvailable": true,
"IsPurchasable": true,
"AgeRestricted": true,
"DisplayQuantity": 1,
"RichDescription": null,
"IsDeliveryPass": false,
"HideWasSavedPrice": false,
"SapCategories": null,
"Brand": "smirnoff red",
"FooterTag": {
"TagContent": null,
"TagLink": null,
"FallbackText": null,
"TagType": "None"
},
"IsFooterEnabled": false,
"Diagnostics": "2",
"IsBundle": false,
"ChildProducts": [],
"UrlOverride": null,
"AdditionalAttributes": {
"sapdepartmentname": "LIQUOR",
"sapdepartmentno": "20",
"sapcategoryname": "SPIRITS",
"sapcategoryno": "51",
"sapsubcategoryname": "VODKA",
"sapsubcategoryno": "382",
"sapsegmentname": "VODKA - COMMERCIAL",
"sapsegmentno": "1",
"specialsgroupid": null,
"PiesProductDepartmentNodeId": "1_C8BFD01",
"piesdepartmentnamesjson": "[\"Liquor\"]",
"piescategorynamesjson": "[\"Spirits\"]",
"piessubcategorynamesjson": "[\"Vodka\"]",
"servingsize-total-nip": null,
"servingsperpack-total-nip": null,
"microwaveable": "False",
"ovencook": "False",
"vegetarian": "False",
"freezable": "False",
"containsnuts": "False",
"containsgluten": "False",
"description": null,
"ingredients": null,
"nutritionalinformation": null,
"storageinstructions": null,
"usageinstructions": null,
"brand": "smirnoff red",
"manufacturer": null,
"countryoforigin": null,
"productheightmm": null,
"productwidthmm": null,
"productdepthmm": null,
"wool_productpackaging": null,
"recyclableinformation": null,
"importantinformation": null,
"allergencontains": null,
"allergenmaybepresent": null,
"lifestyleclaim": null,
"boxedcontents": null,
"suitablefor": null,
"fragrance": null,
"colour": null,
"antioxidant": "False",
"addedvitaminsandminerals": "False",
"bpafree": "False",
"sulfatefree": "False",
"parabenfree": "False",
"claims": null,
"alcoholfree": null,
"anti-dandruff": null,
"dermatologicallyapproved": null,
"dermatologistrecommended": null,
"dermatologisttested": null,
"fragrance-free": null,
"haircolour": null,
"hairtype": null,
"hypo-allergenic": null,
"non-comedogenic": null,
"oilfree": null,
"ophthalmologistapproved": null,
"ophthalmologisttested": null,
"paba-free": null,
"skincondition": null,
"skintype": null,
"soap-free": null,
"spf": null,
"sweatresistant": null,
"timer": null,
"waterresistant": null,
"phbalanced": null,
"antiseptic": "False",
"antibacterial": "False",
"activeconstituents": null,
"contains": null,
"microwavesafe": "False",
"productimagecount": "1",
"friendlydisclaimer": null,
"productimages": "19252.jpg",
"wool_dietaryclaim": null,
"healthstarrating": "0"
},
"DetailsImagePaths": [
"https://cdn0.woolworths.media/content/wowproductimages/large/019252.jpg"
]
}
]
}
I'm surprised at the attributes they have fields for, and then surprised again that they apparently don't use those fields.
Thanks
Also,
271 Clarence
253 Hunter
251 Pitt Street
This is bloody awesome
Now I need one for Kmart… they always have things missing
you are right, here is the better full list.
https://thydzik.com/downloads/office-stores.csv
I cut it down to suburbs only to shorten the description, and WA has only few stores.
Cool, always the man, looking forward to seeing you around Amex small shop again.
Also since I'm so needy, how to get into Woolworths API would be the best.
Woolworths are so dodgy in stocking their specials… half the time the item isn't stocked
… 2011. the script still works great, thank you
if you're intending to scrape, i would suggest you pass an appropriate User-Agent header with your request:
https://www.officeworks.com.au/information/policies/terms-of…