Help automate our Low Stock report system

We are in dire need of someone with knowledge of BigCommerce API, Google Sheets, and creativity. This is a huge project that needs to become as automated as possible. Currently we are using Google sheets as our main source, but we have most likely outgrown this. Below is a full write up of our steps to achieve our sheet which takes anywhere from 20-30 man hours. I do not know the best way to get this automated but it would be a huge help if any or most of this is. I have also attached a file of the finished product for your reference on what it looks like. We use this sheet for Low stock, buying, price changes, testing priority ect.

LSR Full write up
This is to be done every Tuesday and is finished on Thursday. Hours are man hours

Step 1 (~1.5 hours)

- Navigate to Bigcommerce and export “Low Stock Report” template
- Open Excel or Google sheets
- Sort sheet by meta Keywords
- Delete all products that do not contain a meta keyword
- Reprice Disk game SKUs (Bigcommerce does not export child SKUs for some reason)
- Copy old LSR sheet
- Delete old data rows
- Insert current data

Step 2 (~4 hours)

- Pull reports from Google Analytics (Bigcommerce essentially), Amazon, Etsy, Walmart, eBay.
- Count all games that are on LSR and put them in their respective columns
- For system SKU. Count games and add them to appropriate SKU
- Example. System-N64-100 N64 GoldenEye Pak is counted as 1 - N64 system and 1 -
007 Goldeneye game

Step 3 (~4 hours)

- Count incoming top 50 and accessories for ebay buying, SYG, VIP, Japan, Back room #
- Insert into corresponding columns
- Insert all incoming packages into the LSR
- Look at $price and Daily buy list and update eBay$ (this is being generated through native formulas in LSR
- Use these numbers to bid on ebay lots and know what price point we are able to buy products at

Step 4 (this is hard to automate as there is A LOT of variables ~8 hours)

- Sort first section by Build column
- If the Build column is less than 50%. Increase VIP Price and SYG Price by a certain percentage.
- SYG cannot be higher than VIP prices. There is a breakpoint in percentage adjustment (will need to be able to be manually adjusted if needed
- If over 50%, Highlight sale price (this shows we need to adjust our price on our website)
- Price is also related to OTW, VIP, SYG, Jap columns. If we are getting products from SYG but not VIP then no change. If we are getting from VIP and not SYG then VIP price needs to go down and SYG price needs to go up
- The cost of the game also plays a part.5% of $5 is different from 5% of $400.
- Do the above step for every category
- Go back to top and sort by %stock
- if 50% and lower. The Status title changes
-SYG title can go to 50%, top50SYG can go to 60%, VIP drops to 35-25%
-adjust prices based on incoming row, ebay number, Buy, Stock
- Get close to ebay buy number but not over
- Redo for each category


Step 5 (~3 hours)
- Make a copy of the LSR tab
- remove “up” and “down” arrows from VIP and SYG sheet
-Add 3 columns to the right of SYG tab
- Copy column 1 and row DEF
-Sort LSR categories by status A-Z
- Copy and paste values from M and Q to SYG and VIP sheet based on status name
- Rename products and remove “-xxx” at the end
- Continue copying and pasting for each category and each sheet
- Delete old data on new SYG and VIP sheets when done copying
- export both sheets
-import both sheets to external inventory system
- HTML code is generated
- replace old HTML code on BigCommerce to update website sell your games page
-repeat every other day or if prices need adjusting throughout the week.

Please write "Retro4Ever" as the header so I can be sure you have read the whole post and to filter out automated messages