Data Exchange With Google Spreadsheets for OpenCart
The module has been tested on OpenCart 3.x. Operation on other versions is not guaranteed.
Sales and technical support of the module for online stores are not provided in the Russian Federation and the Republic of Belarus.
The module code is unencrypted, without ionCube or obfuscation. You can freely view and modify the code.
Google Spreadsheets Data Exchange Module for OpenCart
Automate price and stock management in OpenCart using Google Sheets!
Editing prices and inventory manually through the admin panel is time-consuming, inconvenient, and requires constant attention. The “Google Spreadsheets Data Exchange” module allows you to easily and quickly make changes to prices directly in Google Sheets and then import them into OpenCart.
Why Is This Convenient?
- Flexibility and speed — make changes in spreadsheets and update the store in one click.
- Bulk editing — update thousands of products at once without accessing the OpenCart admin panel.
- Convenient data presentation — sort, filter, and analyze products in Google Sheets.
- Team collaboration — edit data as a team without giving access to the OpenCart admin panel.
- Export with category filtering — export selective data, for example, only for specific categories.
- Import from multiple Google Sheets — update data not only from your own spreadsheets, but also from supplier price lists.
- CRON automation — schedule imports and exports to run automatically.
What Data Can Be Imported into OpenCart?
- Price
- Stock quantity
- Product status
- Indexing / Noindex
- Special prices for customer groups with the ability to set a promotion period
- Product identifiers supported for import: product_id, model, sku, upc, ean, jan, isbn, mpn
What Data Can Be Exported from OpenCart to Google Sheets?
- Price
- Stock quantity
- Product status
- Indexing status
- Special prices for customer groups
- Product identifiers: product_id, model, sku, upc, ean, jan, isbn, mpn
What’s Included in the Module?
After purchasing the module, you will receive two files:
- composer_google_api.zip — files required to work with the Google API (upload via FTP).
- google_spreadsheets_v_1_0_oc3.ocmod.zip — installed via OpenCart.
How to Configure the Module?
- For importing into OpenCart: obtain an API key with Google Sheets API enabled in Google Cloud.
- For exporting from OpenCart: configure a service account in Google Cloud and grant it access to the spreadsheet.
Installation
- Unzip the composer_google_api.zip archive and upload its contents to the site root via FTP.
- Install the module via the OpenCart admin panel.
- Refresh the modifications.
License
The license applies to one domain and its subdomain.
ocStore 3.x
English
Russian
English
Russian
PHP 8.0-8.3