How to edit WooCommerce prices and stock in Google Sheets

A price change across fifty products, or a stock count after a delivery, means a lot of clicks in WooCommerce. In a spreadsheet it is one paste.

How the sync works

SoftIcon Sheet Sync puts every product and every variation in a Google Sheet, one row each. Edit a cell and WooCommerce updates within seconds. Sell something, or change a product in WooCommerce, and the sheet updates too.

Set it up

  1. Install the free plugin and go to WooCommerce → Sheet Sync.
  2. Follow the wizard: create a Google service account, turn on the Sheets API and upload its key.
  3. Share your sheet with the service account email and paste the sheet URL.
  4. Send your products to the sheet.
  5. Paste the small Apps Script into the sheet and run it once, so edits in the sheet reach the store right away.

Checks before anything is saved

  • Prices must be numbers, and a sale price must be lower than the regular price.
  • Categories must already exist in WooCommerce.
  • A Sync status column shows what was saved and why a value was refused.

The Sheet Sync documentation walks through every step of the setup.

Categories

Related Posts

How to build a landing page in WordPress in ten minutes
How to build a landing page in WordPress in ten minutes

A landing page needs a hero, features, prices and answers. Ready-made sections give you all…

Read More
admin

admin

How to show products in 3D and AR in WooCommerce
How to show products in 3D and AR in WooCommerce

Photos show one side of a product. A 3D model shows every side, and on…

Read More
admin

admin

How to build a mega menu in a WordPress block theme
How to build a mega menu in a WordPress block theme

Block themes like Twenty Twenty-Five have no mega menu built in. Here is how to…

Read More
admin

admin

How to turn a PDF catalog into a flipbook in WordPress
How to turn a PDF catalog into a flipbook in WordPress

A PDF link makes people download a file. A flipbook lets them read the catalog…

Read More
admin

admin

How to show Word, Excel and PDF files on a WordPress page
How to show Word, Excel and PDF files on a WordPress page

Visitors should not need Office or a download to read a handbook or a price…

Read More
admin

admin

How related posts keep readers on your site
How related posts keep readers on your site

When an article ends, readers either leave or read on. A short list of related…

Read More
admin

admin