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
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
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
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Sorry for my English
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
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.
Missing standard PHP ZIP-library here, ask your webhost to install it.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Or in other words, what is the relationship between the product id and the main catalogs id and branch catalogs and the branch thereof
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?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.
The Alt Box, built using Opencart 2.0.3.1.
Users browsing this forum: No registered users and 67 guests