User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by getspace » Sun Aug 07, 2016 3:41 pm

Hi,

I am facing issue with plugin, while export the products it gives the error..

Undefined offset: 0
×Getting messages - what is this ?

I tried to contact hosting provider they said this :

The error which you are seeing is due to the connectivity issue of MHCCORP.COM. When you press the EXPORT button, the script is trying to connect with MHCCORP.COM and fails, it cause the 504 Gateway Time-out error as per the server logs.
[20:55:02 srv12 root@xxx ~]cPs# curl -v http://MHCCORP.COM/
* About to connect() to MHCCORP.COM port 80 (#0)
* Trying 192.254.233.92... Connection timed out
* couldn't connect to host
* Closing connection #0
curl: (7) couldn't connect to host
Last edited by straightlight on Mon Aug 08, 2016 8:21 pm, edited 1 time in total.
Reason: Added quote tags.

Newbie

Posts

Joined
Tue Jul 08, 2014 4:48 pm

Post by fenix76 » Mon Aug 08, 2016 8:06 pm

Hello,
Have problem with this mod:
then try to export I`ve got message
" Undefined offset: 3"
and in error log
(PHP Notice: Undefined offset: 3 in /var/www/instroysna/data/www/................./admin/model/tool/export_import.php on line 6920)
Last edited by straightlight on Mon Aug 08, 2016 8:21 pm, edited 1 time in total.
Reason: Added quote tags.

Newbie

Posts

Joined
Mon Aug 08, 2016 7:45 pm

Post by ActionHank » Wed Aug 10, 2016 4:31 pm

Hey, I've installed this extension on a fresh 2.3.0.2 install of opencart, but it isn't showing up in the back end.
I have rebuild the cache by refreshing and checked the permission tab but it isn't showing up there either.

Newbie

Posts

Joined
Wed Jul 01, 2015 5:05 pm

Post by JNeuhoff » Wed Aug 10, 2016 4:54 pm

ActionHank wrote:Hey, I've installed this extension on a fresh 2.3.0.2 install of opencart, but it isn't showing up in the back end.
I have rebuild the cache by refreshing and checked the permission tab but it isn't showing up there either.
Just to repeat it (I get this kind of enquiry almost every day): This is an Opencart installer issue, not an Export/Import issue! The files were most likely uploaded to the wrong place because of a missing or invalid FTP Root in the System > Settings > edit Store > FTP setting.

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 ActionHank » Wed Aug 10, 2016 5:52 pm

JNeuhoff wrote:
ActionHank wrote:Hey, I've installed this extension on a fresh 2.3.0.2 install of opencart, but it isn't showing up in the back end.
I have rebuild the cache by refreshing and checked the permission tab but it isn't showing up there either.
Just to repeat it (I get this kind of enquiry almost every day): This is an Opencart installer issue, not an Export/Import issue! The files were most likely uploaded to the wrong place because of a missing or invalid FTP Root in the System > Settings > edit Store > FTP setting.
That's all fine and dandy, but what if the install is in the root...? Or do i say somthing strange now?
And is there a fix for this? Even if its quick and dirty.

[edit]
Sorry, i misunderstood you, i have fixed it.

To fix Just add the last directory of your base url of the webserver in the ftp settings.

[/edit]

Newbie

Posts

Joined
Wed Jul 01, 2015 5:05 pm

Post by getspace » Wed Aug 10, 2016 6:00 pm

I am facing issue with plugin, while export the products it gives the error..

Undefined offset: 0
×Getting messages - what is this ?

I tried to contact hosting provider they said this :

The error which you are seeing is due to the connectivity issue of MHCCORP.COM. When you press the EXPORT button, the script is trying to connect with MHCCORP.COM and fails, it cause the 504 Gateway Time-out error as per the server logs.

[20:55:02 srv12 root@xxx ~]cPs# curl -v http://MHCCORP.COM/
* About to connect() to MHCCORP.COM port 80 (#0)
* Trying 192.254.233.92... Connection timed out
* couldn't connect to host
* Closing connection #0
curl: (7) couldn't connect to host

Newbie

Posts

Joined
Tue Jul 08, 2014 4:48 pm

Post by rikmg67 » Wed Aug 10, 2016 6:10 pm

Hi, just wondering if you can help/advise?

I export the spreadsheet and I have made amends to the sheet, when I go to import again, I get the following errors.

Could you offer me any advice please? Or where/how to get this working again?

Thanks,

I'm using opencart 2.0.1.1

2016-08-03 13:31:54 - Export/Import: Undefined option_value_name 'Leg Set Plinth Kit 1000 1700 Plinth – LEGC' for optiion_id '94' used in worksheet 'ProductOptionValues'!

Newbie

Posts

Joined
Thu Nov 29, 2012 12:44 am

Post by 3zzy » Sat Aug 13, 2016 10:00 am

Hi,

First off, thanks for developing and making the plugin available for free!

I just installed it and trying to figure it out. I'm wondering if there are excel templates available to test and see how it works?

Thanks

Newbie

Posts

Joined
Thu Aug 11, 2016 12:56 pm

Post by ahetaton » Tue Aug 16, 2016 9:25 pm

I installed the tool without error.
But when I want to export, and I get this message:

Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/local/lib/php') in /home/hardcore/public_html/admin/model/tool/export_import.php on line 7954

Please help! :(

Newbie

Posts

Joined
Tue Aug 16, 2016 9:24 pm

Post by JNeuhoff » Wed Aug 17, 2016 2:23 am

ahetaton wrote:I installed the tool without error.
But when I want to export, and I get this message:

Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/local/lib/php') in /home/hardcore/public_html/admin/model/tool/export_import.php on line 7954

Please help! :(
Are you sure you go the correct setting for DIR_SYSTEM in your admin/config.php? If so, then it might be also an access rights issue.

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 snappyfish » Wed Aug 17, 2016 5:06 pm

Hi,

I have installed Export/Import on 2.0.3.1

When exporting "products" using default settings

I added one product change but when trying to import get error below.

Code: Select all

2016-08-17 9:25:41 - Export/Import: Undefined option_value_name '25.4 130mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:41 - Export/Import: Undefined option_value_name '31.8 - 110mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '48cm' for option_name 'Frame Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (80mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '26x1.75/1.95 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '26x2.1/2.6 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Schrader Valve' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '29x1.75/2.125 Schrader Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '700x35/43C Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined attribute_name 'Suitable For' for attribute_group_name 'Child Trailer Spec' used in worksheet 'ProductAttributes'!
2016-08-17 10:03:15 - Export/Import: Duplicate product_id '1518' used in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Worksheet 'Specials' cannot use product_id '1519' because it is not listed in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Worksheet 'ProductOptions' cannot use product_id '1519' because it is not listed in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Worksheet 'ProductOptionValues' cannot use product_id '1519' because it is not listed in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Worksheet 'ProductAttributes' cannot use product_id '1519' because it is not listed in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '25.4 130mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '31.8 - 110mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '48cm' for option_name 'Frame Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (80mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '26x1.75/1.95 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '26x2.1/2.6 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Schrader Valve' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '29x1.75/2.125 Schrader Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '700x35/43C Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:16 - Export/Import: Undefined attribute_name 'Suitable For' for attribute_group_name 'Child Trailer Spec' used in worksheet 'ProductAttributes'!

Active Member

Posts

Joined
Thu Apr 14, 2011 4:36 am

Post by JNeuhoff » Wed Aug 17, 2016 5:41 pm

snappyfish wrote:Hi,

I have installed Export/Import on 2.0.3.1

When exporting "products" using default settings

I added one product change but when trying to import get error below.
You have to define the missing option values values first, before using them in your products import.

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 snappyfish » Wed Aug 17, 2016 7:40 pm

JNeuhoff wrote:
snappyfish wrote:Hi,

I have installed Export/Import on 2.0.3.1

When exporting "products" using default settings

I added one product change but when trying to import get error below.
You have to define the missing option values values first, before using them in your products import.
Thanks for for reply, could you explain more? Even when exporting the default products already in the store and trying to re-import with no changes I get this error?

Code: Select all

2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '25.4 130mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '31.8 - 110mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '48cm' for option_name 'Frame Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (80mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '26x1.75/1.95 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '26x2.1/2.6 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Schrader Valve' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '29x1.75/2.125 Schrader Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '700x35/43C Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined attribute_name 'Suitable For' for attribute_group_name 'Child Trailer Spec' used in worksheet 'ProductAttributes'!

Active Member

Posts

Joined
Thu Apr 14, 2011 4:36 am

Post by snappyfish » Thu Aug 18, 2016 9:13 pm

JNeuhoff wrote:
snappyfish wrote:Hi,

I have installed Export/Import on 2.0.3.1

When exporting "products" using default settings

I added one product change but when trying to import get error below.
You have to define the missing option values values first, before using them in your products import.
If I tick these options and export and then re-import there is no errors? But un-ticked and causes errors as mentioned.

Use option_id instead of option name in worksheets 'ProductOptions' and 'ProductOptionValues'
Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'
Use attribute_group_id instead of attribute_group name in worksheet 'ProductAttributes'
Use attribute_id instead of attribute name in worksheet 'ProductAttributes'
Use filter_group_id instead of filter_group name in worksheets 'ProductFilters' and 'CategoryFilters'
Use filter_id instead of filter name in worksheets 'ProductFilters' and 'CategoryFilters'

Active Member

Posts

Joined
Thu Apr 14, 2011 4:36 am

Post by zzzxxccvvv » Fri Aug 19, 2016 6:47 am

Hello,

I have been using your extension for a few years now and it is really great. I just wanted to know if you have added DOWNLOAD list import/export to it in recent versions.

Many thanks for your valuable work.

Newbie

Posts

Joined
Fri Oct 24, 2014 12:23 am

Post by sirszor » Sat Sep 03, 2016 1:39 am

I like this extension. I have been using it for 1 year. Today I installed the latest 3.5 to my OC2.0.3.1 system. It works almost fine. When I start Customers export it makes the xls file perfectly but I get an error message in error log:

"SELECT a.*, c.name AS country, z.name AS zone, (cu.address_id=a.address_id) AS 'default' FROM 'address' a INNER JOIN 'country' c ON C.COUNTRY_ID=A.COUNTRY_ID LEFT JOIN 'zone' z ON z.country_id AND z.zone_id INNER JOIN 'customer' cu ON cu.customer_id WHERE a.customer_id BETWEEN 1 AND 760 ORDER BY a.customer_id ASC, a.address_id ASC;"

What can cause this error log?

Newbie

Posts

Joined
Sun Mar 06, 2011 12:15 am

Post by JNeuhoff » Mon Sep 05, 2016 5:57 am

sirszor wrote:I like this extension. I have been using it for 1 year. Today I installed the latest 3.5 to my OC2.0.3.1 system. It works almost fine. When I start Customers export it makes the xls file perfectly but I get an error message in error log:

"SELECT a.*, c.name AS country, z.name AS zone, (cu.address_id=a.address_id) AS 'default' FROM 'address' a INNER JOIN 'country' c ON C.COUNTRY_ID=A.COUNTRY_ID LEFT JOIN 'zone' z ON z.country_id AND z.zone_id INNER JOIN 'customer' cu ON cu.customer_id WHERE a.customer_id BETWEEN 1 AND 760 ORDER BY a.customer_id ASC, a.address_id ASC;"

What can cause this error log?
Comment out the line

Code: Select all

$this->log->write( $sql );
in file admin/model/tool/export_import.php, in method getAddresses. It shouldn't be there.

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 sirszor » Mon Sep 05, 2016 6:58 am

Thank you! It helped.

Newbie

Posts

Joined
Sun Mar 06, 2011 12:15 am

Post by IvanPetrov » Thu Sep 08, 2016 8:30 pm

Hi! Thanks to JNeuhoff for the excellent import-export module.
But i have a little problem...(
How can I doing import without overwriting field "description"?
I have this problem, because description of products i'm writing manually in OC admin, but the rest of data - is automatically generated from my CRM (sku, prices, stocks and so on)...
So, when i'm doing import - my descriptions was overwrited with empty values(((

Newbie

Posts

Joined
Thu Sep 08, 2016 8:24 pm
Who is online

Users browsing this forum: No registered users and 7 guests