Hi,
on a new OC installation 3.0.3.9 with nothing else other than the included products I tried to do an export and I get the following error
Error: Unknown column 'pt.tag' in 'field list'
Error No: 1054
SELECT p.product_id, GROUP_CONCAT(pt.tag SEPARATOR ",") AS tag, pd.* FROM `ocfy_product` p LEFT JOIN `ocfy_product_description` pd ON pd.product_id=p.product_id AND pd.language_id='1' LEFT JOIN `ocfy_product_tag` pt ON pt.product_id=p.product_id AND pt.language_id='1' GROUP BY p.product_id ORDER BY p.product_id ;
Any pointers how to fix this?
Every other export works.
I have the following modifications installed from the Marketplace
Autofill Meta tag
Greek Translation
Mega Filter Pack
And also Cardlink (payment processing), and Greek Map.
Everything else is exactly what came with the installation of Opencart.
Tried removing all other extensions except Mega Filter Pack and the result was the same. PHP version is 7.4.33
There is no product_tag table in OC 3.0.3.9.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
If there is not such a table in OC 3.0.3.9 then is it safe to assume that one of the installed extensions created it?
I tried uninstalling some of them. If this entry was created by an extension should't its uninstallation remove it (generaly speaking).
Also my error looks very similar to mariosp with the exception that some product variables (?) have the prefix 'oc_product_XXXXX' whereas mine have the prefix 'ocfy_product_XXXXX' and we are only one version of OC apart.
I tried uninstalling some of them. If this entry was created by an extension should't its uninstallation remove it (generaly speaking).
Also my error looks very similar to mariosp with the exception that some product variables (?) have the prefix 'oc_product_XXXXX' whereas mine have the prefix 'ocfy_product_XXXXX' and we are only one version of OC apart.
Hello everyone. I solved the problem of loading images by URL.
When importing, in the "image_name" column, you can specify the full URL to the image on another site, the script will save:
- category images to the \image\catalog\category folder
- product images and additional images to the \image\catalog\products folder
if there are no such categories, they will be created.
tested on opencart version 3.0.4.0 and plugin version 4.17
changes were made to lines 411, 1006, 1505, 1631-1650
When importing, in the "image_name" column, you can specify the full URL to the image on another site, the script will save:
- category images to the \image\catalog\category folder
- product images and additional images to the \image\catalog\products folder
if there are no such categories, they will be created.
tested on opencart version 3.0.4.0 and plugin version 4.17
changes were made to lines 411, 1006, 1505, 1631-1650
Attachments
\admin\model\extension\export_import.php
deleted
Last edited by michael2820 on Sat Sep 14, 2024 9:20 pm, edited 1 time in total.
--- please reply only with verified data, that is: no 'I think', 'maybe' etc. ---
The current version is 4.17:
opencart-3-x-export-import-multilingual-4-17-cloud.ocmod.zip for OpenCart 3
export_import.ocmod.zip for OpenCart 4
opencart-3-x-export-import-multilingual-4-17-cloud.ocmod.zip for OpenCart 3
export_import.ocmod.zip for OpenCart 4
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
I installed the module as you specified, but when I want to connect to the module page, nothing appears. I am sharing the screenshot with you in the attachment.
Version: 4.0.2.3
PHP: 8.2.25
https://ibb.co/p6DWQyQ
I installed the module as you specified, but when I want to connect to the module page, nothing appears. I am sharing the screenshot with you in the attachment.
Version: 4.0.2.3
PHP: 8.2.25
https://ibb.co/p6DWQyQ
Open a support ticket at https://www.opencart.com/index.php?rout ... sion_id=17, and provide more details, including OpenCart admin and FTP logins, see that I can take a quick look at it. Maybe you accidentally deleted the en-gb language?yaramazkedicik wrote: ↑Wed Nov 13, 2024 8:10 pmHi,
I installed the module as you specified, but when I want to connect to the module page, nothing appears. I am sharing the screenshot with you in the attachment.
Version: 4.0.2.3
PHP: 8.2.25
https://ibb.co/p6DWQyQ
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi JNeuhoff,JNeuhoff wrote: ↑Wed Nov 13, 2024 10:47 pmOpen a support ticket at https://www.opencart.com/index.php?rout ... sion_id=17, and provide more details, including OpenCart admin and FTP logins, see that I can take a quick look at it. Maybe you accidentally deleted the en-gb language?yaramazkedicik wrote: ↑Wed Nov 13, 2024 8:10 pmHi,
I installed the module as you specified, but when I want to connect to the module page, nothing appears. I am sharing the screenshot with you in the attachment.
Version: 4.0.2.3
PHP: 8.2.25
https://ibb.co/p6DWQyQ
I created a support ticket saying "I have a question". I hope I did it right.
If you haven't received it yet, I can send you a message here.
Best regards.
Hi JNeuhoff,yaramazkedicik wrote: ↑Thu Nov 14, 2024 3:04 amOpen a support ticket at https://www.opencart.com/index.php?rout ... sion_id=17, and provide more details, including OpenCart admin and FTP logins, see that I can take a quick look at it. Maybe you accidentally deleted the en-gb language?
I created a support ticket saying "I have a question". I hope I did it right.
If you haven't received it yet, I can send you a message here.
Best regards.
[/quote]
Yes, you did it right, we received your support ticket, and fixed it. There was a corrupted Turkish language text in your translation, it's now fixed.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
I'm having an issue with the Export/Import. When I try to export products and categories I'm getting this message:
Trying to access array offset on value of type int
Exporting Customers is work fine
I'm running OpenCart 3.0.2.0 and PHP version: 8.3.15
Thanks in advance for the help
Best regards
I'm having an issue with the Export/Import. When I try to export products and categories I'm getting this message:
Trying to access array offset on value of type int
Exporting Customers is work fine
I'm running OpenCart 3.0.2.0 and PHP version: 8.3.15
Thanks in advance for the help
Best regards
OC 3.0.2.0 doesn't support PHP 8.3, for the latter you'd need OpenCart 3.0.4.0.
As regards your error from the Export/Import tool: You are using the wrong version, see our FAQ.
As regards your error from the Export/Import tool: You are using the wrong version, see our FAQ.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi,
I am having some problems while using the Export/Import module.
1- For example, I configure the product_id order of the products as 1, 2, 3, ... and I enter the product. Later, when I print the product list, I see that the product in the first place has been deleted. For this reason, I always start the order from 2.
2- Again, when I get the product list (for example, I have 20-30 products), the number of products appears as 5-6 in the ProductSEOKeywords tab. The SEO-friendly spellings of the other products do not appear.
Version: 4.0.2.3
PHP: 8.2.25
I am having some problems while using the Export/Import module.
1- For example, I configure the product_id order of the products as 1, 2, 3, ... and I enter the product. Later, when I print the product list, I see that the product in the first place has been deleted. For this reason, I always start the order from 2.
2- Again, when I get the product list (for example, I have 20-30 products), the number of products appears as 5-6 in the ProductSEOKeywords tab. The SEO-friendly spellings of the other products do not appear.
Version: 4.0.2.3
PHP: 8.2.25
Not enough details here to help you. For a start, go to the Version Info tab, what does it say? Are you actually using the latest version of the Export/Import tool which includes recent fixes for the ProductSEOKeywords worksheet?yaramazkedicik wrote: ↑Tue Mar 18, 2025 5:37 pmHi,
I am having some problems while using the Export/Import module.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi JNeuhoff,
I installed this module about 3 months ago.
Version Info:
Version of Export/Import Tool 4.17.2
Version of OpenCart 4.0.2.3
Version of PHP 8.2.27
I installed this module about 3 months ago.
Version Info:
Version of Export/Import Tool 4.17.2
Version of OpenCart 4.0.2.3
Version of PHP 8.2.27
Try the current version 4.17.4 of the Export/Import tool, there were a number of bugfixes.
Also bear in mind that OpenCart 4.0.2.3, like unfortunately all of the current OpenCart 4 versions, aren't yet suitable for a live site, still under heavy development.
Also bear in mind that OpenCart 4.0.2.3, like unfortunately all of the current OpenCart 4 versions, aren't yet suitable for a live site, still under heavy development.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Now updated for the latest OpenCart 4.1.0.x versions. OpenCart 4.1.0.1 or later handles product codes, such as sku, upn, ean, jan, isbn, and mpn, differently compared to previous versions, hence this latest update of the Export/Import tool.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
OC 3.0.3.9
Default store theme, POS module,Antispam module, Enable-Disable products module and export/import tool v3.22 installed
The installation of this module had no issues, I can access the Export/Import menu in System/Maintenance/Export-Import
Any time I try to Export or Import however it just gives me a 500 error. There is nothing in the error log.
EDIT - I realized after I posted this that I had v3.22 installed when I should have the 4.17 version. It works now, thank you.
Default store theme, POS module,Antispam module, Enable-Disable products module and export/import tool v3.22 installed
The installation of this module had no issues, I can access the Export/Import menu in System/Maintenance/Export-Import
Any time I try to Export or Import however it just gives me a 500 error. There is nothing in the error log.
EDIT - I realized after I posted this that I had v3.22 installed when I should have the 4.17 version. It works now, thank you.
Last edited by wildcraft on Sat Apr 05, 2025 7:26 am, edited 1 time in total.
Who is online
Users browsing this forum: No registered users and 24 guests
