By default, a new spreadsheet cannot be accessed via Google’s API. We’ll need to go to your Google APIs console and create a new project and set it up to expose your Spreadsheets’ data.
Finally, if you want read datas from some Google SpreadSheet, you need share this file with your "Service account ID", this is: JSON file didn't uploaded
The process is overpassing some of these PHP directives values:
Depends of size of your shop, or size of the file that you want process, will require more or less values, an example can be the next values:
The best way to increase these values, is doing it directly in your server configuration, if you can't or don't know how to do it, your hosting support team can help you.
You also can try the next methods:
memory_limit = 512M
max_execution_time = 800
upload_max_filesize = 240M
post_max_size = 250M
php_value memory_limit 512M
php_value max_execution_time 800
php_value upload_max_filesize 240M
php_value post_max_size 250M
<?php phpinfo(); ?>
If you see that, still have old values, is possible that METHOD 1 and METHOD 2 didn't work because your server don't allow this type of changes across php.ini/.htaccess libraries, your changes have to be applied directly in server configuration and apache have to be reset.
If you want create new products make sure that you didn't fill column "Product ID", else, system will try find this product by this ID and will try edit it.
Also, the system will try find the product id by Model, even if you didn't fill column "Product ID", also have to make sure that data inserted in column "Model" not exists in your store, else, system will extract product id from this model.
Conclusion: To create new products, you haven't to fill column "Product ID" and model put in column "Model" have to be unique and new in your store.
If you want edit an existing product, you have to fill one of these columns:
Reason: Opencart searches for /tmp but it has no permissions to read and write.
Solution: Change the php directive "open_basedir" to a proper location with all permissions.
Make sure that you put a correct route in excel and uploaded image in a correct route. Go to see 2 examples.
OPENCART 1.X - EXAMPLE
Route of image in excel file:
Remember add "data/" in all routes if you are using Opencart 1.x
Upload image in your server in route:
OPENCART 2.X AND 3.X
Route of image in excel file:
Remember add "catalog/" in all routes if you are using Opencart 2.x or 3.x
Upload image in your server in route:
This problem is because there is some blank space or hidden symbol in some of cell of this excel.
To solve it, open excel file and remove the "empty" row that are giving problems. Save excel and try import again!.
Microsoft Excel has the limit of 32.767 characters by cell, if you are trying export and some of your data overpassing this quantity, this error will appear. You have next ways to solve this problem:
If you received this error when you tried create/delete new elements in your shop:
This is because some external extension is adding new fields in your models, and the extension developer is not checking if this key exist before start to working with it. This is a bad develop practise, to solve it, you have to use array_key_exists php function before start to work with it.
You have multiples ways to solve this problem:
If you are receiving an error simillar like this "Error: The used table type doesn't support FULLTEXT indexes. Error No: 1214. ALTER TABLE `TABLENAME` ENGINE=INNODB", an external extension created a new table (TABLENAME) that has a field with type "FULLTEXT", this type of field is not compatible with INNODB, you have to connect to your database and change this field type to "TEXT" (don't worry about this, is exactly same).