Basically it needs two extensions installed. One is for Google Spreadsheet (App script addon), another for Magento 2. App script addon update spreadsheet functionality and send-fetch data from-to web store, directly through Magento 2 REST API. Magento 2 extension its some kind of optimization for search, update products, import products, mail merge email templates with data from store by shortcodes, manage update unsibscriber emails. System work only! if 2 extensions are installed.
Open Google Spreadsheet -> Menu -> Add-ons -> Get Add-ons
In search field type “Easymanage”, find add-on and press “+ Free” button
After successfully installed Magento 2 and Google Spreadsheet modules, you should see the new menu item in your spreadsheet “Add-ons” -> “Easymanage“. Click “Easymanage” -> then select one of three items “Products”, “Customers” or “Mail merge”
!IMPORTANT – during first run app require access from yours account such as Google Drive etc… You have to allow all of them, that access let App script modify current spreadsheet. NOTE – we do not read, modify, create anything on yours drive.
Registration sidebar opened. Select “Magento 2“
You should see login screen, for authorization. Login and password are required for accessing Magento 2 REST API. We recommend to you create new admin user with ACL access “Magento_Catalog::catalog”, “Magento_Catalog::store” or all and use it there.
After login(login required only once), you will get Eeasymanage sidebar, there you can start update your products.
All working? If no – check the forum – anyway its time for coffee, tea, beer or whatever 🙂
Uninstall from Magento 2
SSH to yours project root directory. Run cmd:
If installed via composer
php bin/magento module:uninstall Develodesign_Easymanage
If installed by coping
php bin/magento module:disable Develodesign_Easymanage
Remove all source from app/code/Develodesign folder
Uninstall from spreadsheet
Click on logout link in sidebar menu. !important all Easymanage app data will be cleared. Remove addon from Add-ons -> Manage add-ons