Post by sirajpatel » Thu Aug 17, 2017 4:01 am

hi, tried to export from 2.2 and import it in 3.0.2, it gives an error the following error

2017-08-16 19:39:51 - Export/Import: Invalid header in the Categories worksheet
2017-08-16 19:39:51 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 12
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: The Twig_Function_Function class is deprecated since version 1.12 and will be removed in 2.0. Use Twig_SimpleFunction instead. in /home/f9/public_html/system/library/template/Twig/Function/Function.php on line 13
2017-08-16 19:39:51 - PHP Unknown: The Twig_Function class is deprecated since version 1.12 and will be removed in 2.0. Use Twig_SimpleFunction instead. in /home/f9/public_html/system/library/template/Twig/Function.php on line 12
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100

Newbie

Posts

Joined
Thu Aug 17, 2017 3:56 am

Post by sirajpatel » Thu Aug 17, 2017 4:09 am

hi, tried to export from 2.2 and import it in 3.0.2, it gives an error the following error

2017-08-16 19:39:51 - Export/Import: Invalid header in the Categories worksheet
2017-08-16 19:39:51 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 12
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: The Twig_Function_Function class is deprecated since version 1.12 and will be removed in 2.0. Use Twig_SimpleFunction instead. in /home/f9/public_html/system/library/template/Twig/Function/Function.php on line 13
2017-08-16 19:39:51 - PHP Unknown: The Twig_Function class is deprecated since version 1.12 and will be removed in 2.0. Use Twig_SimpleFunction instead. in /home/f9/public_html/system/library/template/Twig/Function.php on line 12
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100

Newbie

Posts

Joined
Thu Aug 17, 2017 3:56 am

Post by sonique7 » Fri Aug 18, 2017 3:57 pm

I am facing the same issue as above. I tried to move products from 2.3 to 3.0.2 and i got this error --

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

i went to the logs to confirm and i saw this

2017-08-18 7:55:32 - Export/Import: Invalid header in the Products worksheet
2017-08-18 7:55:32 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/z9ord/public_html/shop/system/library/template/Twig/Autoloader.php on line 12
2017-08-18 7:55:32 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/z9ord/public_html/shop/system/library/template/Twig/Autoloader.php on line 30
2017-08-18 7:55:32 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/z9ord/public_html/shop/system/library/template/Twig/Autoloader.php on line 30
2017-08-18 7:55:32 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/z9ord/public_html/shop/system/library/template/Twig/Autoloader.php on line 30

please help out

Newbie

Posts

Joined
Fri Aug 18, 2017 3:48 pm

Post by JNeuhoff » Mon Aug 21, 2017 6:39 pm

In case you get the 'Invalid header' error message, please do the obvious: Use the correct header for the 'Products' or 'Categories' worksheet. You can get the correct header for these worksheets by doing an Export first off the new website. And then copy/paste the old data to the new worksheet before an import.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Download Options * Free Download Buttons * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by NDS » Sun Aug 27, 2017 11:11 pm

Hello! I just installed this plugin in OpenCart 2.3.0.2, but I can not find the documentation... Although the page of this plugin says "Documentation Included". Where can I find the documentation for this plugin, in particular, the contents of the fields of the Excel file for import?
Sorry for my English :)

NDS
Newbie

Posts

Joined
Sun Aug 27, 2017 11:04 pm

Post by oc_ms » Mon Aug 28, 2017 3:18 am

Dear JNeuhoff!

Is it possible to import with only one Excel file? I tried one file with the tables "AttributeGroups", "Attributes", "Categories", "Products", "ProductAttributes" and "AdditionalImages" but received the error "undefined attribute_group_id". Then I splitted the file in three single files (Attributes*/ Categories and Products*) and everything works fine.

Thanks for your short reply!

Best regards,

Holger

Newbie

Posts

Joined
Thu Jun 05, 2014 3:25 am

Post by firstuser » Tue Sep 05, 2017 12:33 am

Hi. The installed module indicates that the page is not found. what's wrong?

Newbie

Posts

Joined
Sun Jun 04, 2017 11:37 pm

Post by MVV » Fri Sep 08, 2017 4:58 pm

Hi. This tool is amazing, thank you for it!
I updated it from v3.16 to v3.17 on OC 2.3.0.2 and everything is fine, but I only can't export Products. It shows me a message File now found and http://mywebsite/admin/index.php?route= ... YST99A2SZ2
Do you have any idea where is the problem? I can export categories, options, customers, etc. normaly. Only when I try to export product, I got this message.

MVV
Newbie

Posts

Joined
Fri Sep 08, 2017 4:49 pm

Post by ginsar » Tue Sep 19, 2017 1:46 pm

Hi. I installed the module, but it does not work. Exporting of goods results in an error.

Attachments

111.JPG

error - 111.JPG (76.95 KiB) Viewed 475 times


Newbie

Posts

Joined
Tue Sep 19, 2017 1:40 pm

Post by JNeuhoff » Tue Sep 19, 2017 9:17 pm

ginsar wrote:
Tue Sep 19, 2017 1:46 pm
Hi. I installed the module, but it does not work. Exporting of goods results in an error.
Missing standard PHP ZIP-library here, ask your webhost to install it.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Download Options * Free Download Buttons * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by ginsar » Wed Sep 20, 2017 2:05 pm

JNeuhoff wrote:
Tue Sep 19, 2017 9:17 pm
Missing standard PHP ZIP-library here, ask your webhost to install it.
What kind of library?
I have VDS and I can install it myself.

Newbie

Posts

Joined
Tue Sep 19, 2017 1:40 pm

Post by JNeuhoff » Wed Sep 20, 2017 6:02 pm

ginsar wrote:
Wed Sep 20, 2017 2:05 pm
JNeuhoff wrote:
Tue Sep 19, 2017 9:17 pm
Missing standard PHP ZIP-library here, ask your webhost to install it.
What kind of library?
I have VDS and I can install it myself.
It could also be this:
https://stackoverflow.com/questions/214 ... php-output

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Download Options * Free Download Buttons * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by ginsar » Fri Sep 22, 2017 8:28 pm

JNeuhoff wrote:
Wed Sep 20, 2017 6:02 pm
It could also be this:
https://stackoverflow.com/questions/214 ... php-output
Where is here talk about Standard Library ?

Newbie

Posts

Joined
Tue Sep 19, 2017 1:40 pm

Post by JNeuhoff » Fri Sep 22, 2017 8:58 pm

As the link explains, the most common cause of this error when saving to php://output is an open_basedir restriction that doesn't include a valid system's temp folder (e.g. /tmp), or permissions for the system's temp folder. If shows some possible solutions to this issue. The Export/Import tool uses the PHPExcel library which is located in the system/PHPExcel folder, or in the system/library/export_import folder, depending on the OpenCart version used.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Download Options * Free Download Buttons * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by salwa123 » Wed Sep 27, 2017 8:36 pm

The catalog gives a code of 20.40, so how do I know the code of the main and sub sections
Is it possible to display the name of the main section in particular and sub-branch other

Active Member

Posts

Joined
Fri Mar 04, 2016 6:01 pm

Post by JNeuhoff » Thu Sep 28, 2017 3:07 am

salwa123 wrote:
Wed Sep 27, 2017 8:36 pm
The catalog gives a code of 20.40, so how do I know the code of the main and sub sections
Is it possible to display the name of the main section in particular and sub-branch other
Your post is confusing, there is no catalog code. There is a categories column whose values are comma-separated lists of category__ids. You can find the latter via exporting the Categories first.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Download Options * Free Download Buttons * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by salwa123 » Fri Sep 29, 2017 10:35 pm

Usually when a clean product we have to define its catalog. How do we know the catalog number?
Or in other words, what is the relationship between the product id and the main catalogs id and branch catalogs and the branch thereof

Active Member

Posts

Joined
Fri Mar 04, 2016 6:01 pm

Post by Wonderwoman » Tue Oct 03, 2017 2:58 pm

Hi, i've exported the files and didn't edit anything, i just import it to see how it goes but i get this error message

2017-10-03 6:21:37 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '412' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '670' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Worksheet 'Specials' cannot use product_id '412' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Worksheet 'Specials' cannot use product_id '670' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Worksheet 'Discounts' cannot use product_id '412' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Orange Polkadots' for option_name 'Expandable Shopping Bag Design' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Dramatize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Energize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Fantasize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Glamorize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Harmonize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Hypnotize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Optimize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Polarize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Privatize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Sensualize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Sociolize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Tranquilize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Tropicalize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '900B Pink Suga' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '901B Think Pink' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '903C Just Peachy' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '904B Rose Bud' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '905D Smokin Hot Pink' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '907C Mauve Outta Here' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '909D Coral-Line' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '910D Red Velvet' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '912C In The Flesh' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '913C Sand Storm' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '914C Mocha-Licious' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '915B Spiked W/Rum' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '918D Cherry Bomb' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '919B Vamp It Up' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '965 Cherry Picking' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '966 Dont Blink Pink' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '968 Pinkerbell 970' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Purty Persimmon' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'No 1 Earth Brown' for option_name 'Clio Tinted Tattoo Kill Brow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Baby Girl - 9m' for option_name 'Baby Size' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Baby Girls - 12m' for option_name 'Baby Size' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Baby Girls - 18m' for option_name 'Baby Size' used in worksheet 'ProductOptionValues'!


I'm not sure what to do with Undefined option_value_name error message. Do I delete the the option? And what to do next?

Newbie

Posts

Joined
Sat Jul 08, 2017 7:21 pm

Post by JNeuhoff » Tue Oct 03, 2017 10:46 pm

About the option_value_names: Do an Export of the option definitions and then check to make sure their names don't contain leading or trailing blank characters.

MHC Web Design
Override Engine * Integrated VQMod * Multilingual SEO * Instant Option Price Calculator * TrustPilot Reviews * Download Options * Free Download Buttons * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by nortski » Fri Oct 06, 2017 12:34 am

Hi,
There appears to be a slight bug concerning the 'description(en)' field when I download my product catalogue. On some of my items it will repeat what's in the description multiple times underneath each other. Rather annoying as this means I have to check out every item to see if it has been affected.

EDIT: This seems to have something to do with Open Office. If I open the file in Excel it appears fine.
Last edited by nortski on Fri Oct 06, 2017 1:10 am, edited 1 time in total.

The Alt Box, built using Opencart 2.0.3.1.


New member

Posts

Joined
Tue Nov 01, 2011 9:22 pm
Who is online

Users browsing this forum: No registered users and 6 guests