Google Spreadsheet
- Go to your shared Google Drive spreadsheet and make the updates you require
- Click Menu – File > Download > Comma Separated Values
- Put the file somewhere safe
Woocommerce Import
- Log into your Woocommerce website the normal way
- Click Products option in left menu
- Click Import button at top of page
- Choose the file you downloaded
- Click Continue
- Scroll to the bottom of the page
- Click Run the Importer (You don’t need to make any changes to column mapping, we’ve done that for you)
- Once complete, click View products
- Click Import button once
- Click the checkbox for Update existing products
- Repeat steps 3-8
