Google Sheets WooCommerce Stock Control

@ukroficer

Hello, For two WooCommerce stores feeding one Google Sheet, I would use the REST API with an hourly Apps Script trigger rather than heavy dashboards, because stock, supplier rules, and PO creation need to stay readable for your team. - One master catalog structure for products, variations, SKUs, suppliers, minimums, and reorder qty. - Hourly import from both stores with clear source-store columns and update logs. - Low-stock alerts by colour and optional email, kept in commented Apps Script. - Ready-to-send PO tab or PDF generated from supplier details and reorder quantity. I will also account for large catalogs by paging API requests and avoiding formulas that recalc whole sheets. How many total products/variations are there across the two stores? I can start by mapping the sheet structure and API fields. Roman

@Tafsol

Hey there, Are both WooCommerce stores using the same SKU structure, and should the Google Sheet treat matching SKUs as one combined stock figure across both stores? I understand you need a simple Google Sheets stock-control system that pulls inventory from both WooCommerce stores, keeps it updated hourly, flags low stock, and automatically prepares a purchase order using the supplier and reorder information. -/ If the same SKU exists in both stores, should the system combine the quantities, or track each store separately? -/ Do you want the purchase order generated as a Google Sheet tab, PDF, or both, and should it group multiple low-stock items by supplier? -/ Should the system automatically send the PO to the supplier, or only prepare it for someone on your team to review and send? I’d build it around the WooCommerce REST API and Google Apps Script, with a central SKU sheet, configurable minimum/reorder quantities, scheduled synchronization, low-stock alerts and automatic PO generation. The setup would stay easy to maintain so your team can add SKUs and suppliers without changing the code. Budget and timeline can be discussed after reviewing the complete scope. Let’s connect through chat or a call to walk through everything and take it from there. Best regards, Tafsol (HJ)

@rajat07me

Combining stock from two WooCommerce stores into one Google Sheet is straightforward on paper, but the part that usually breaks later is messy sync logic and scripts nobody can safely edit. I’d build this so the inventory pull stays reliable, the low-stock check is easy to follow, and the purchase order output is generated automatically without turning the sheet into something overly technical for your team. I’ve handled WooCommerce API work, spreadsheet-based operational tools, and lightweight Apps Script automations where the goal was usability first, not a flashy dashboard. For this job, I’d keep the structure clean: master SKU sheet, supplier/reorder data sheet, scheduled hourly refresh, and a simple PO generator with commented script blocks so future edits are manageable. A brief setup guide is no problem, and I can build directly in your Google Workspace as requested. - Do both stores use the same SKU structure, or are there any store-specific SKU variations? - Would you prefer the low-stock alert to stay inside Sheets first, or do you want email included from day one? - For the purchase order output, should it create one PO per supplier automatically when items fall below minimum?

@Microlent

Hello, I understand that you are looking for a solution to streamline stock control for your two WooCommerce stores by integrating with Google Sheets. As an experienced developer specializing in automation and integration projects, I can offer you a tailored solution that meets your specific requirements. My approach would involve setting up a Google Sheets spreadsheet that pulls real-time inventory data from both of your WooCommerce sites, ensuring that the information is updated hourly to maintain accuracy. By implementing conditional formatting or automated alerts, we can promptly notify you when stock levels fall below the minimum threshold, allowing for timely reordering. Additionally, I will create a system that generates purchase orders automatically once low stock is detected, utilizing stored supplier details and predefined reorder quantities. The solution will focus on functionality and ease of use, with clear documentation and comments to facilitate future updates by your team. With my expertise in integrating WooCommerce with Google Sheets using APIs and automation tools, I am confident in delivering a reliable and efficient solution tailored to your needs. Please feel free to reach out to discuss this project further. I look forward to collaborating with you on this endeavor. Sincerely, Rajesh

@webbookstudio

Hi there, We understand you're looking for a simple yet effective stock control system in Google Sheets that integrates with your two WooCommerce stores, providing real-time inventory updates, low-stock alerts, and automated purchase orders. Our team at Webbook Studio has experience with WooCommerce, Google Sheets, and API integrations, having worked on similar projects such as e-commerce website development for a luxury leather retailer and a Scandinavian fashion brand, where we implemented custom inventory management systems. We can deliver a reliable and automated solution using Google Sheets, Apps Script, and the WooCommerce REST API, including features like hourly inventory sync, low-stock alerts via email or SMS, and automatic purchase order generation. One question: Have you already set up any API connections or add-ons like API Connector or Sheetgo in your Google Workspace, or would you like us to handle the entire setup from scratch? Feel free to message us to discuss the details! — Webbook Studio

@a4logic

Hello, As a seasoned developer with over a decade of experience, my skills align perfectly with the requirements of your project. I'm well-versed in WooCommerce and have previously connected it to Sheets via APIs and add-ons like API Connector and Sheetgo. Rest assured, your stock control spreadsheet will be built with clean formulas and lightweight Apps Scripts for easy understanding by your team members. My focus has always been on delivering automated, scalable, and secure solutions to my clients - just what you need for your WooCommerce stores. I'll ensure your inventory remains up-to-date throughout the day through regular syncing, exactly on hourly basis as requested. Additionally, I'll set up efficient low-stock alerts and automate purchase order creation seamlessly using the stored supplier details and predefined reorder quantities. In order to provide you long-term support, I will comment the scripts thoroughly and include a comprehensive setup guide so that you can conveniently add new SKUs or suppliers without diving into code. Quality results on time are my defining traits and deploying your project directly on your Google Workspace would be a breeze.I am excited about this project as it is perfectly suited to my skill set. I assure you clean work, excellent communication, and 100% client satisfaction throughout the entire development process. Let's create a streamlined solution for your venture together! Thanks!

@diektech

Hi — Elias here from Miami. I understand you're looking for a stock-control solution for your WooCommerce stores using Google Sheets. It’s essential to create a system that’s functional and reliable as your inventory changes. The real challenge often lies in ensuring accurate synchronization between WooCommerce and Google Sheets. A common issue is maintaining real-time updates without discrepancies. Automating this process while managing user permissions and ensuring data integrity are critical. My approach would involve designing a workflow that securely pulls data from your WooCommerce stores into Google Sheets. I’d focus on stability and maintainability, making sure future changes can be integrated easily. I’ve worked on similar integrations, streamlining stock management for e-commerce platforms, which helped reduce errors and improve efficiency. A few questions to better understand the scope: Q1 – What specific stock metrics do you want to track in the spreadsheet? Q2 – Are there particular user roles that need different access levels to the stock control sheet? Q3 – How do you currently handle stock updates, and what are your expectations for automation? Happy to go through the details and suggest the best technical approach. Looking forward to hearing from you.

@gauravgargcs

Hello, Hope you are doing well, I’ll connect both stores through the WooCommerce REST API, build clean Sheets formulas and commented Apps Script, configure low-stock alerts and automated PO tabs/PDFs, and provide a simple setup guide for adding SKUs and suppliers. I have 10 years of web/API automation experience, including WooCommerce integrations and Google Sheets automation. Let’s chat and I can start building this directly in your Google Workspace. thank you Regards Gaurav Garg

@SBITServices

Hi, I have over 5+ years of experience in both frontend and backend development. I will do the specified tasks. Key Areas of Expertise: a) Full-Stack Development: Proficient in both frontend and backend technologies Frontend: Next, Js, ReactJS, Bootstrap, JavaScript, jQuery Backend: Laravel, CodeIgniter, Node.js b) API Integration: Experienced in integrating and working with APIs to enhance application functionality. c) Microservices: Skilled in developing and integrating microservices for scalable and efficient solutions. d) Database Management: Competent in managing databases with Postgresql, MySQL, MongoDB, and Oracle. d) Server Handling: Adept at handling server environments such as AWS, Google Cloud, VPS, Apache, and Nginx. Lets connect in chat so that We discuss further. With Regards, Sai

@webperfection123

I can build a simple Google Sheets stock-control system connected to both WooCommerce stores using REST API and lightweight, well-commented Apps Script. It will include hourly inventory sync, minimum stock alerts, reorder quantities, and automatic purchase order generation using supplier details. I’ll also provide a clear setup guide so your team can easily manage SKUs and suppliers without touching code. Please see our portfolio on this link : https://www.freelancer.com/u/webperfection123

@asifalimzd

Hi there, I can build your lightweight WooCommerce store on the existing WordPress setup with a clean minimal design matching your logo and brand colours. I’ll configure and organise the five products, set up and sandbox-test PayPal, Stripe and Google Pay, keep the plugin stack minimal, and handle basic speed, security and responsive testing without heavy page builders or unnecessary add-ons. I’ll also provide a simple handover so you can easily add products yourself, with everything completed within your one-month timeline. Could you share your logo, brand colours and hosting/WordPress access so I can review the current setup and get started? Kindly send me a message to discuss more or directly award me. Thank you!

@minhhoangduc

Hi, I went through your project "Google Sheets WooCommerce Stock Control" and I can help. I'm a web developer working across WordPress, Shopify, Drupal, Magento, CS-Cart, WooCommerce, Joomla, OpenCart, building custom functionality, plugins, themes and integrations. I have many years of experience in programming, along with in-depth knowledge of software architecture, software development, and database systems. I have a strong background in web development and have worked on many projects, including e-commerce websites, custom plugins, and integrations and ability to solve quickly the every problem and then I always ensure the high quality & low cost of the work. Happy to discuss scope and timeline. Best, Hoang

@installerpoint

Hello, this is a clear and practical automation project. I can build a dependable Google Sheets stock-control workflow for both WooCommerce stores, using REST API synchronization, maintainable formulas, and commented Apps Script. I’ll include low-stock alerts, supplier-driven purchase-order generation, and a concise setup guide so your team can add SKUs without changing code. A useful improvement would be logging sync errors and generated orders for easy troubleshooting. I’m ready to build directly in your Google Workspace and keep the sheet simple for daily use. Check out my portfolio here:- https://www.freelancer.com/u/installerpoint Best Regards, Muhammad Adeel

@raheel2k29

Hello, I can build a dependable Google Sheets stock-control workflow connecting both WooCommerce stores through their REST APIs. The sheet will consolidate SKU inventory, minimum levels, reorder quantities, supplier details, and hourly refreshes, with clear low-stock highlighting and maintainable Apps Script alerts. I’ll also automate a ready-to-send purchase order tab or PDF whenever stock falls below its threshold, while keeping the formulas and scripts commented for easy team maintenance. I’ll structure the workbook so new SKUs and suppliers can be added without code changes, then provide a concise setup guide and test the workflow across both stores before handover. Regards Muhammad

@sohandas

I can sync both WooCommerce stores to Google Sheets, automate low-stock alerts and purchase orders. Ready to provide a quick sample.

@evgendob

Hello. WordPress development expert ready to help you with a project. I have more than 400 good reviews and more than 15 years of development experience behind, so project will be done with the best quality and timeframe. Free bug fixing support. We can always make deal on price. Tnx, and hope to hear you soon.

@Synet

The real success here depends on making sure the connection between your two shops and Google Sheets stays fast and stable without breaking when orders come in at the same time. I will build a clean setup using the WooCommerce REST API and custom Google Apps Script to pull your inventory smoothly every hour. We will start by laying out the exact columns you need for both stores and your supplier details, then share a live view so you can approve the layout before any code is written. Once you give the green light, I will write the automation scripts to handle the hourly sync, apply the conditional colour rules for low stock alerts, and generate the ready to send purchase orders automatically. I will use clean JavaScript for the scripts and standard Google Sheets formulas so your team can read and update everything easily. After building everything, I will test the sync between both WooCommerce stores and the sheet, record a short walkthrough video showing how it works, and write a simple setup guide for adding new items. We can split the project into safe milestones so you only release funds after seeing each part working. Let us have a quick chat about your stores before you award the project. Salma

@techplusintl

★★★ GOOGLE SHEETS SPECIALIST ★★★ Hi, To create a stock-control spreadsheet, I'll utilize Google Sheets and Google Apps Script to automate the inventory sync from your WooCommerce stores. I will implement the WooCommerce REST API to pull current inventory data for each SKU into a single sheet, ensuring it updates hourly. For stock management, I will set up columns for minimum stock levels and preferred reorder quantities. Conditional formatting will be applied to highlight low-stock items, and I will implement an Apps Script to send email alerts when stock dips below the minimum. When an item is flagged low, I will automate the generation of a purchase order tab or PDF using the supplier details and reorder quantities stored in the sheet. The scripts will be well-commented for clarity, and I will provide a brief setup guide for adding new SKUs or suppliers without needing to modify the code. I have experience connecting WooCommerce to Google Sheets using the REST API, which will facilitate a swift implementation. To get started, I will need access to your Google Workspace and WooCommerce API credentials. Thanks!

@adeelpirzada

Hi, I am Adeel. I built Boostifai, a multi-tenant SaaS that pulls live data from client CMS platforms and keeps it synced through scheduled jobs, so building a reliable WooCommerce to Sheets pipeline is familiar territory. I would use the WooCommerce REST API directly rather than an add-on, pulling stock hourly via Apps Script triggers into one master sheet keyed by SKU. Low stock would flag with conditional formatting and an email alert, then auto-populate a purchase order tab from your supplier data. I can start this week and will comment the scripts and write a short setup guide so your team can add SKUs without touching code. Are both stores on the same WooCommerce version, or do the APIs differ between them?