Auto Update WooCommerce Stock Daily from Google Sheets

Let’s learn how to auto update WooCommerce stock daily from Google Sheets. This is great if you want to keep your WooCommerce product stock automatically updated every day. That means you can manage your inventory in a spreadsheet, and changes will sync with your WooCommerce store on a daily basis, saving you hours of manual inventory updates.

Why update WooCommerce stock daily from Google Sheets?

Many store owners benefit from daily stock updates, especially in fast-paced or inventory-sensitive industries. Here are a few common examples where updating stock daily can be really beneficial and useful:

1. Retailers with daily deliveries: If you receive new stock every day, updating your WooCommerce inventory daily ensures customers always see accurate availability.
2. Warehouses syncing with suppliers: If you maintain a shared stock sheet with suppliers or fulfillment centers, you can use that same Google Sheet to auto-update your WooCommerce stock each day.
3. High-volume stores: For businesses with fast-moving inventory, daily updates help prevent overselling or disappointing customers with out-of-stock items.
4. Multiple sales channels: If you’re managing inventory across platforms like Amazon or Etsy, syncing to a single Google Sheet and updating WooCommerce daily ensures consistency.
5. Dynamic availability: Service-based businesses or rental companies that change availability every day can reflect those changes directly on their store via daily updates.

Tools you’ll need to reset stock every day

You need two tools in addition to WooCommerce:

1 – WP Sheet Editor – WooCommerce Products

This plugin allows you to manage your WooCommerce products in a spreadsheet view directly within WordPress. It’s perfect for bulk edits and managing stock, prices, and other product fields.

2 – Google Sheets Sync

This service connects Google Sheets to your WordPress site. It lets you import and export product data automatically between Google Sheets and WooCommerce.

Step 1. Open your WooCommerce products spreadsheet

Go to WP Sheet Editor > Edit Products in your WordPress dashboard. You’ll see all your WooCommerce products in a spreadsheet.

Step 2. Connect your site to Google Sheets

After signing up for the Google Sheets Sync service, you’ll get a helper plugin. This connects your WordPress site with Google Sheets and the required APIs.

Follow this guide to complete the setup.

Step 3. Export stock data to Google Sheets

To ensure your privacy, the service only accesses Google Sheets files that were generated through it. Therefore, the first step is to export your products into a new Google Sheet. In this case, we’ll export only the fields related to product stock.

Click on the Export tool in WP Sheet Editor.

Now choose the following settings:

• What columns to export:
  • ID
  • Name
  • Stock
  • In Stock? (Stock Status)
• Which rows: Export all rows (include variations if needed by enabling “Display variations” first).
• Editing App: Google Sheets
• Export Name: Give it a name like “Daily Stock Update”.

Click Start new export to generate the Google Sheet.

Once the export is complete, click on View Google Sheet to open and review the stock data.

As you see, we have exported the stock data of our products from WooCommerce to Google Sheets.

Now we’re ready to schedule a recurring import that will pull data from this Google Sheet into WooCommerce every day.

Step 4. Schedule daily stock updates from Google Sheets

Now we’ll schedule a daily import that syncs your Google Sheet to WooCommerce every 24 hours or every 1 day.

Open the Import tool in WP Sheet Editor.

Select these options:

• Run this in the future: Enable this checkbox.
• Select the date and time: Enter the date and time when you want to start importing stock data every 24 hours.
• Notify this email address when the process finishes: Add your email to get notified every time the recurring import is executed.
• Select the Run in recurring intervals option.
• Run every: You can select 1 Days or 24 Hours.
• Name: Add a descriptive name for this recurring import.
• Source: Google Sheets
• Google Sheet file: Select the sheet you exported in Step 3.
• Click on Next.

You can import all the columns or select specific columns to import.

Now you need to select how you want to import the data and match the existing products:

• Do you want to update or create items: In this example, we will update existing items and ignore new items.
• How do we find existing items to update: Use the ID column to identify and update the right products.
• Click on Next.

Click The preview is fine, start import to finalize the schedule.

You can now go to View scheduled imports to confirm that your daily import has been set up. Now you can start managing the stock of your WooCommerce products in Google Sheets, and the changes will be automatically applied every day at the selected time.

That’s it!

From now on, your WooCommerce product stock will automatically update every day based on the data in your Google Sheet. This ensures your store always shows the most accurate inventory, without you needing to log in daily.

You can update your sheet manually, or even connect it to other tools or systems. Either way, WooCommerce will stay in sync automatically.