Post by seme1 » Mon May 20, 2019 4:52 am

Hello JNeuhoff,

Another question I have is regarding custom fields added to the products. How can they be exported in the excel file and re-imported? I only have one custom field that needs to be exported/imported.

Newbie

Posts

Joined
Wed Mar 20, 2019 5:49 am

Post by JNeuhoff » Mon May 20, 2019 4:39 pm

Your admin backend language must be also one of the supported frontend languages as you correctly stated. You could modify the frontend language selector in the 'common/language.tpl' file to exclude the admin language from the selector.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by seme1 » Tue May 21, 2019 8:21 pm

Thank you for your response.
I have a custom field added in the table oc_product and I wish to export/import that custom field when exporting the products. Can you please guide me on how this can be achieved ? Perhaps point me to the right sections that I need to modify the code to include that custom field ?

Newbie

Posts

Joined
Wed Mar 20, 2019 5:49 am

Post by Laoyumi » Sun Jun 16, 2019 9:37 am

The following error at import in OC 3.0.3.2:
2019-06-15 8:27:41 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /www/htdocs/........../...................../system/library/template/Twig/Autoloader.php on line 30
Export to Excel works. Nice extension! Easy to use. Only that one issue it seems.

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by JNeuhoff » Sun Jun 16, 2019 8:43 pm

Laoyumi wrote:
Sun Jun 16, 2019 9:37 am
The following error at import in OC 3.0.3.2:
2019-06-15 8:27:41 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /www/htdocs/........../...................../system/library/template/Twig/Autoloader.php on line 30
Export to Excel works. Nice extension! Easy to use. Only that one issue it seems.
Ignore this message. The Export/Import real error message will be above that one in your OpenCart error.log.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Laoyumi » Mon Jun 17, 2019 12:04 pm

The error has gone - I do not know why but am unable to reproduce the error.
Have reinstalled the extension today and noticed a new version for 3.0.3.2. Or I fiddled something else, might even have made an error in the spreadsheet.
Important - its working with 3.0.3.2 and makes live so much easier. Thank you

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by Laoyumi » Tue Jun 25, 2019 1:03 pm

Maybe a small issue discovered: When I import products from .xlsx additional related items get stripped. In the field "related_ids" I have the value of "197,198". But only 197 is shown in OC. I have to manually add 198 through the admin interface.
Opencart 3.0.3.2, Import/Export Tool vers. 3.2
Generally the tool drives me crazy but when I look at the error log is is always my fault in the spreadsheet.

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by JNeuhoff » Tue Jun 25, 2019 3:10 pm

Laoyumi wrote:
Tue Jun 25, 2019 1:03 pm
Maybe a small issue discovered: When I import products from .xlsx additional related items get stripped. In the field "related_ids" I have the value of "197,198". But only 197 is shown in OC. I have to manually add 198 through the admin interface.
Opencart 3.0.3.2, Import/Export Tool vers. 3.2
Generally the tool drives me crazy but when I look at the error log is is always my fault in the spreadsheet.
This is an issue with the local settings of of operating system or spreadsheet software used. Make sure that '197,198' isn't treated as a decimal number, it has to be a string entry in your spreadsheet software. I recommend using LibreOffice Calc rather than MS Excel.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Laoyumi » Tue Jun 25, 2019 3:38 pm

Thank you, issue solved. Setting the column to "Text" and it imports all the product_ids.
I am on Linux Mint using LibreOffice exclusively. Am very happy with Linux, as easy to use as Windows. But calc can not always replace the shortcomings of the user (me).

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by borko471 » Tue Jul 02, 2019 12:05 am

Hi guys. I'm running OC 1.5.3. My issue is with the 'Limit products export by category:' text field (filtering by Category before exporting). No suggestions show up while I'm typing and even if I type the correct name and press enter, it's no good. I checked a previous answer which said to check for duplicate SEO keywords, which I did and there were none. I'm pretty sure this text box was working when I first installed the module. Could it be because of duplicate Category Names in either language?

Newbie

Posts

Joined
Fri Apr 05, 2019 6:42 pm

Post by borko471 » Thu Jul 04, 2019 8:00 pm

borko471 wrote:
Tue Jul 02, 2019 12:05 am
Hi guys. I'm running OC 1.5.3. My issue is with the 'Limit products export by category:' text field (filtering by Category before exporting). No suggestions show up while I'm typing and even if I type the correct name and press enter, it's no good. I checked a previous answer which said to check for duplicate SEO keywords, which I did and there were none. I'm pretty sure this text box was working when I first installed the module. Could it be because of duplicate Category Names in either language?
Bump.
I eliminated all duplicate names of the categories in both my languages. I made sure there are no duplicate SEO keywords, either. The filter by category text box is still not working. I'll be glad if someone has any ideas about this so I can at least try something. I'll try removing caches now.

Newbie

Posts

Joined
Fri Apr 05, 2019 6:42 pm

Post by ndryomov » Thu Jul 18, 2019 2:15 am

Hi, guys

I installed Export/Import Tool on OpenCart v3.0.3.2 and try to import xls with products. During import I'm getting error:

Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed.

In error log I got error - 2019-07-17 16:33:59 - Export/Import: Invalid worksheet names

What right structure of products file should be for importing?

Thanks in advance for your answers

With best regards

Newbie

Posts

Joined
Sat Jul 13, 2019 4:15 am
Who is online

Users browsing this forum: No registered users and 2 guests