/get-leadlist
Builds a spreadsheet of discounted items in stock at your stores, filtered by price, discount, and stock.
/get-leadlist storeids:<text> [minmsrp:<number>] [maxmsrp:<number>] [minpercentoff:<number>] [maxpercentoff:<number>] [minstock:<whole number>] [maxstock:<whole number>] [mininstoreprice:<number>] [maxinstoreprice:<number>] [possiblepenny:<yes or no>]storeidsrequiredType one store number, several separated by commas (0589,1234), or all to use every store on your account. Store numbers are 1 to 4 digits; shorter numbers get leading zeros (589 becomes 0589). You can only use stores you have added.
Type: text
minmsrpoptionalMSRP is the item's regular price, in dollars. Default 0.
Type: number
maxmsrpoptionalIn dollars. Must be at least minmsrp; set both to the same value for an exact match. Default 10,000,000 (no real limit).
Type: number
minpercentoffoptionalPercent off the regular price, written like 60 for 60% off (not 0.6). Default 1, so items with no discount are left out.
Type: number
maxpercentoffoptionalMust be at least minpercentoff. Default 100.
Type: number
minstockoptionalHow many the store has on hand. Must be more than 0. Default 1, so out-of-stock items are left out. Applies to the possible penny list only when you set it.
Type: whole number · From 1 to 2147483647
maxstockoptionalMust be at least minstock. Default: no limit. Also applies to the possible penny list when set.
Type: whole number · From 1 to 2147483647
mininstorepriceoptionalThe current price at the store, in dollars. Default 0.
Type: number
maxinstorepriceoptionalIn dollars. Must be at least mininstoreprice. Default 10,000,000 (no real limit).
Type: number
possiblepennyoptionalSet to True to also get a second file of possible penny items. Default False.
Type: yes or no
What it does
This command searches the items the bot has found at your stores and puts the matches in a spreadsheet (CSV file). Use the options to narrow the list, for example only items at least 60% off, or only items under $20.
You can pick one store, several stores, or all of your stores at once. You can only search stores you have added with /add-store.
Every limit includes its end value. For example, minpercentoff:60 includes items that are exactly 60% off. Items that ring up at $0.01 but are not confirmed penny items are left out of the lead list. Use possiblepenny:True to see those.
What you get back
Only you can see the reply. It has a CSV file you can open in Excel, Google Sheets, or Numbers. The file has one row per item per store, with these columns:
- Product ID: the internet number (the number on homedepot.com product pages, labeled "Internet #")
- In Store SKU and UPC (or N/A)
- Store Number and Store Address
- Quantity: how many the store has
- MSRP: the regular price
- Confirmed In Store Price
- Percent Off
- Date Dropped: shown in Pacific time and labeled PST or PDT, whichever was in effect on that date, or N/A
- Title and Product Link
Rows are grouped by store number, lowest first. Within each store, the biggest discount comes first. Titles, addresses, and links appear exactly as stored, including any commas, quotation marks, or | characters.
With possiblepenny:True, you get a second CSV file. It lists items that ring up at $0.01 at your store but are not confirmed as penny items there, while the same item is confirmed as a penny item at another store. Its columns are Product ID, In Store SKU, UPC, Store Number, Quantity, Title, and Product Link. It is sorted by store number, then by Product ID. It uses minstock and maxstock only when you set them. By default it includes items that show 0 on hand, since penny items often do. It does not use your MSRP, price, or discount filters, because every item on it rings up at $0.01.
Example
/get-leadlist storeids:0589 minpercentoff:60You get a CSV of items at store 0589 that are 60% to 100% off and have at least 1 in stock.
If something goes wrong
- No Stores Found: you have no stores on your account yet. Add one with /add-store.
- Invalid Filters: a minimum is more than its maximum, or
minstockis not more than 0. A minimum can equal its maximum. Fix the numbers and try again. - Invalid Store ID: a store number is not 1 to 4 digits. Check for typos or extra characters.
- Store Access Denied: you asked for a store you haven't added. The reply lists the stores you do have. Add the missing store with /add-store, or use
storeids:all. - No Leads Found: nothing matched. Try looser filters, such as a lower
minpercentoff. - Error Occurred: something failed on our side. Try again later.