Nicholas Pease
My portfolio and project place.
HomeProjects
Aubuchon Hardware Additional Register Tools
The register tools are a suite of software developed for the Aubuchon Hardware company to aid in the updating of manual UPC lookup books as well as interfacing with the backends pricing API to provide real time inventory, pricing, and product information. Due to the nature of this software, it is closed sourced.
The Suite of Tools Includes:

Generate Register Book

Generate Pallet Signs

Generate List from SKU/UPC

SKU Counter

Create-A-Sign 2

SKU Investigation

ColorX Calculator
Generate Register Book
This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

Generate Register Book
Generate Register Book
This tool takes a Microsoft Excel workbook and formats the data in a manner consistent among uses. This allows the store to generate identical books, with minimal duplication of efforts and materials, while optimizing for time. This tools also allows the store to utilize barcode's in the book, without relying on cashiers to type all of the codes by hand.

Generate Pallet Signs
Generate Pallet Signs
This tool takes a Microsoft Excel workbook and reads through all the user selected categories. It then queries the central Aubuchon Inventory API to assemble individualized pallet signs with most up to date pricing and additional data.

Generate List from SKU/UPC
Generate List from SKU/UPC
This tool takes a bulk list of UPC's / SKUs and queries the Aubuchon Inventory API to assemble a list of items with the most up to date pricing and additional data. This tool is used to generate lists for the store to use in their daily operations. Potential applications involve inventorying, general list-making, and other correspondences.

SKU Counter
SKU Counter
This tool takes a bulk list of UPC's / SKUs and queries the Aubuchon Inventory API to count the number of items in the list. This tool is used to generate counts for the store to use in their daily operations. Potential applications involve inventorying, cycle counting, box inventorying, and other applications where counting a large number of scannable items is not practical.

Create-A-Sign 2
Create-A-Sign 2
This is a better version of the Aubuchon Hardware 'Create-A-Sign' program. This tool includes options to bulk generate signs, modify the pricing data should it be inaccurate, among other additions.

SKU Investigation
SKU Investigation
This tool investigates potentially mistyped SKUs for user errors on the POS systems. It then sorts those similar SKUs according to their 'suspiciousness' and allows the user to investigate the potential errors. This tool is best used for negatives and other issue SKUs

ColorX Calculator
ColorX Calculator
This tool is used to calculate the paint differential between two given Benjamin Moore ColorX paint color formulas. It works by converting both formulas into common units, and outputting a simple to dispense formula to turn the old color, into the desired color.
Google Sheets Tool As an additional tool, I have developed a Google Sheets Add-On that allows the user to interface with the Aubuchon Inventory API to query information regarding inventory, product pricing and other information. It can be used to automate a wide variety of spreadsheets including inventory pick lists and many more. A redacted version of this tool is below
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 function AUBDATALOOKUP(input, type) { if (input && type) { var url = API_URL; var text = UrlFetchApp.fetch(url).getContentText(); var json = JSON.parse(text) switch (type.toLowerCase()) { case "description": return json.product[0].webDesc break; case "qty": return json.product[0].onHandAmt break; case "price": return json.product[0].promoPrice != ""? "*"+json.product[0].promoPrice: json.product[0].retailPrice break; case "location": return json.product[0].section + " S:" + json.product[0].Slot break; case "sku": return json.product[0].sku break; default: for (var UPC in json.Table1) { UPC = json.Table1[UPC] if (UPC.Primary) return UPC.altUPC } break; } } else if (input) { var url = API_URL; var text = UrlFetchApp.fetch(url).getContentText(); var json = JSON.parse(text) for (var UPC in json.Table1) { UPC = json.Table1[UPC] if (UPC.Primary) return UPC.altUPC } } else { return "AUBUCHON PRODUCT DATA TOOL\n[SKU TO LOOKUP], [TYPE OF DATA]\nVALID TYPES: UPC, DESCRIPTION, QTY, PRICE, LOCATION" } }
© 2024 Nicholas Pease.
Last Updated on 18 Oct 2024.