Multilingual Export/Import for OpenCart 2.x / 3.x / 4.x

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.

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.

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

deleted

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

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

yaramazkedicik wrote: ↑

Wed Nov 13, 2024 8:10 pm

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

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?

JNeuhoff wrote: ↑

Wed Nov 13, 2024 10:47 pm

yaramazkedicik wrote: ↑

Wed Nov 13, 2024 8:10 pm

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

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?

Hi JNeuhoff,

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.

yaramazkedicik wrote: ↑

Thu Nov 14, 2024 3:04 am

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?

Hi JNeuhoff,

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.