Product Import
A basic Google Spreadsheet product importer is to find in dashboard's Menu -> Products.
Setup Product Import
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 |
Supported Table Attributes
| 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 |
Product Images
Please note: The product images have to be uploaded via dashboard's file import: Menu -> Files