OpenCart integration with Google Sheets API for product updates
The SheetsUp extension is designed to integrate OpenCart with Google Sheets to update product parameters such as price, stock, availability status, promotional prices, minimum quantity, sku, ean, mpn, jan, upc, isbn, and location fields. In the module, you can set your own markups for prices, automatically add promotions. There is an automatic periodic update of products from Google Sheets by CRON.
DEMO Admin
SheetsUp allows online stores built on the OpenCart platform to interact with product data using Google Sheets via the Google Sheets API. It is a convenient and effective solution that allows you to automate the process of updating products, simplifying the daily work of the manager, as well as updating prices, availability and other important data.
If your Google spreadsheet file is in .xls, .xlsx or .ods format - choose another module - Google DriveUp for OpenCart.
Managing and updating products in your online store is a critical task. However, this process can be a time-consuming task. But there are ways to make it easier, and one of them is to use integrated solutions like SheetsUp: a module for updating products from Google Sheets to OpenCart.
The SheetsUp extension makes updating products an easy and straightforward task. You do not need to have technical skills to work with this module. The module allows you to set up automatic updates, which saves you time. With SheetsUp, you can edit many products at once, which allows you to quickly make changes to your product range.
Module installation instructions:
Upload the module in the admin panel in the "Extensions" : "Install".
Go to the "Extensions" : "Extensions" : "Modules" and enable the module.
Get a json key to work with Google Sheets API - instructions
Edit module. Enable the status of the module and adjust all its options to your needs and save the settings.
Check module operation.
Bingo!
Screenshots of SheetsUp
Changelog SheetsUp
v1.0.3 (18 December 2024) - Updated Google php libraries. Added compatibility with OpenCart 2.1
v1.0.2 (24 July 2024) - Fixed handling of formatted numeric values in price and quantity columns
v1.0.1 (16 February 2024) - Fixed an error in the module model that occurred with certain settings.
You must be logged in to view the files!
Михайло Мельник
01 May 2024
Модуль немає аналогів, принаймні я не знаходив. Працює чудово - один раз налаштував імпорт і забув. Автор дуже допоміг, за що подяка!
We decided to provide you with the opportunity to get some blogs adapted to SEO Pro that our clients have encountered and asked us to make them SEO ad..
In this article, we will tell you how to track store conversions on OpenCart and transfer the value of conversions to Google Analytics (GA4) and Googl..
While everyone is waiting for the release of OpenCart 4.1.0.0, a new release of OpenCart "old" branch 3.0.x.x with version number 3.0.4.0 has been rel..
This website uses cookies 🍪 to provide you with the convenience of working with its functions, based on the Privacy Policy