Skip to content
  1. Extras
  2. GoogleSheets
  3. Development
  4. Events

Events ​

The following events are available:

Import ​

  • gsOnBeforeImportValues - fetches data from the sheet before field formatting
    • values - array of values
  • gsOnImportValues - fetches data from the sheet after field formatting
    • values - array of values

Export ​

  • gsOnBeforeExportValues - array of values for export before formatting
    • values - array of values
  • gsOnExportValues - array of values for export after formatting
    • values - array of values

Resources ​

  • gsOnBeforeGetResource - fetches the list of resources
    • query - selection query
  • gsOnGetResource - resulting list of resources
    • resources - array of resources

Categories ​

  • gsOnBeforeGetCategories - fetches the list of categories
    • query - selection query
  • gsOnGetCategories - resulting list of categories
    • categories - array of categories

Products ​

  • gsOnBeforeGetProducts - fetches the list of products
    • query - selection query
  • gsOnGetProducts - resulting list of products
    • products - array of products

Orders ​

  • gsOnBeforeGetOrders - fetches the list of orders (minishop2)
    • query - selection query
  • gsOnGetOrders - resulting list of orders (minishop2)
    • orders - array of orders

Vendors ​

  • gsOnBeforeGetVendors - fetches the list of vendors (minishop2)
    • query - selection query
  • gsOnGetVendors - resulting list of vendors (minishop2)
    • vendors - array of vendors

Users ​

  • gsOnBeforeGetUsers - fetches the list of users
    • query - selection query
  • gsOnGetUsers - resulting list of users
    • orders - array of users

Clients ​

  • gsOnBeforeGetClients - fetches the list of clients (minishop2)
    • query - selection query
  • gsOnGetClients - resulting list of clients
    • users - array of clients

msOptionsPrice2 ​

  • gsOnBeforeGetOptionsPrice2 - fetches the list of options
    • query - selection query
  • gsOnGetOptionsPrice2 - resulting list of options
    • options - array of options

msProductRemains ​

  • gsOnBeforeGetRemains - fetches the list of product stock
    • query - selection query
  • gsOnGetRemains - resulting list of product stock
    • remains - array of stock

All events also have a range parameter - the sheet name.