A basic Google Spreadsheet product importer is to find in dashboard's Menu -> Products.
Dashboard General Settings -> Product Import -> Google Spreadsheet
| Value | Description |
|---|---|
| Google Sheets API Key | ..is to find in your own Google Developer Console. Please visit herefor: https://developers.google.com/maps/documentation/javascript/get-api-key |
| Sheet ID | ..the Sheet ID is in the URL of the created spreadsheet |
| Sheet Name | ..the Sheet Name is as bottom table tab named of the created spreadsheet |
| Attribute | Description |
|---|---|
category_name |
Root first-level category |
sub_category_name |
Sub-level category under first-level root category |
sku |
The sku number of your product |
name |
The product short description |
stock_quantity |
Product stock quantity |
regular_price |
Product regular price |
enabled |
Product visibility |
images |
Product images. Multiple images should be comma separated |
state |
State is marked by X. After import success is changed to a check |
Please note: The product images have to be uploaded via dashboard's file import: Menu -> Files