Have just installed 3.0.2.0-OpenCart and opencart-3-x-export-import-multilingual-3-20.ocmod, then I tried to import (first I exported my complete categories and products in separated files as its done by this extension)
I edited some categories names and products names just to test the import (only 6 categories and 2 products)
But, now I can only see the categories and products in the frontend, and not in the backend
If I re-import the changes seems to apply because I see them in the frontend. But nothing in the backend, completely empty products and categories.
What can I try?
Thanks,
Make sure that the admin backend language is also one of the supported frontend languages.sebadamus wrote: ↑Wed May 09, 2018 7:39 amHi,
Have just installed 3.0.2.0-OpenCart and opencart-3-x-export-import-multilingual-3-20.ocmod, then I tried to import (first I exported my complete categories and products in separated files as its done by this extension)
I edited some categories names and products names just to test the import (only 6 categories and 2 products)
But, now I can only see the categories and products in the frontend, and not in the backend
If I re-import the changes seems to apply because I see them in the frontend. But nothing in the backend, completely empty products and categories.
What can I try?
Thanks,
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
and i have trouble importing the product file,error:Uploaded spreadsheet file has validation errors.and i checked the :System > Maintenance > Error Logs,but there are no logs related to this.
PS:Export / Import (V3.20)
Opencart Version 3.0.2.0
what can i do about it?
thanks
I have imported products with this tool but I cannot see the products in the Products list. Inspite the products are available in the store (customers side) .
Where can I find the products that I have imported via this tool to can edit them?
Thank you.
Make sure that the admin language is also one of the supported frontend languages, too.znuky.ro@gmail.com wrote: ↑Fri Jun 08, 2018 8:17 pmHello,
I have imported products with this tool but I cannot see the products in the Products list. Inspite the products are available in the store (customers side) .
Where can I find the products that I have imported via this tool to can edit them?
Thank you.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have been using this extension to transfer a couple categories of products from my old OpenCart site (version 1.5.5.1) and into my new one (version 2.2.0.0). When I try to import what appears to be a proper table, does it need to have every single item in my database? I am getting the following errors but I only wanted to add/update the specified product IDs in my XLXS file.
I also don't have anything in the Specials worksheet because I don't want to add any specials. What do these errors mean?2018-06-12 16:43:04 - Export/Import: Missing product_ids in worksheet 'Products'!
2018-06-12 16:43:04 - Export/Import: Missing product_ids in worksheet 'Specials'!
2018-06-12 16:43:04 - Export/Import: Missing product_ids in worksheet 'ProductOptions'!
2018-06-12 16:43:04 - Export/Import: Missing product_ids in worksheet 'ProductOptionValues'!
2018-06-12 16:43:04 - Export/Import: Missing customer_groups in worksheet 'Specials'!
Thank you!
P.S. If it helps to know, I've already successfully altered my options XLXS and imported it with the new options that I wanted. I also tried to download my current item database to update the full table but there are too many and I am getting this error:
How do I proceed?Allowed memory size of 536870912 bytes exhausted (tried to allocate 8388608 bytes)
Server log is like this:
PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'c5_panstoreupd.oc_url_alias' doesn't exist<br />Error No: 1146
That table name does not exist on your OC database.PHP Fatal error: Uncaught exception 'Exception' with message 'Error: Table 'c5_panstoreupd.oc_url_alias' doesn't exist<br />Error No: 1146
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I have added this sample text to Products/description(en-gb):
Code: Select all
<p align="justify">Our traditional Corn Flakes are gluten free and low in fat. Start your day with a bowl of our delicious golden flakes which are grown under the Italian sun. We've added malted rice syrup to create our delicious breakfast suitable for all the family.<br><br>This is a 375g pack, ideal for anyone on a gluten free diet and tasty for everyone.<br></p>
Code: Select all
<p align="justify">Our traditional Corn Flakes are gluten free and low in fat. Start your day with a bowl of our delicious golden flakes which are grown under the Italian sun. We've added malted rice syrup to create our delicious breakfast suitable for all the family.<br><br>This is a 375g pack, ideal for anyone on a gluten free diet and tasty for everyone.<br></p>
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
first time using this and got an error... can we get some help?
2018-06-30 5:44:49 - Export/Import: Missing category_ids in worksheet 'Categories'!
2018-06-30 5:44:50 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 12
2018-06-30 5:44:50 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 30
2018-06-30 5:44:50 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 30
2018-06-30 5:44:50 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 30
2018-06-30 5:44:50 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 30
thank you
Yes, this error was already reported on GitHub on my behalf in the past.AgentN wrote: ↑Mon Jul 09, 2018 1:36 pmHi there,
first time using this and got an error... can we get some help?
2018-06-30 5:44:49 - Export/Import: Missing category_ids in worksheet 'Categories'!
2018-06-30 5:44:50 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 12
2018-06-30 5:44:50 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 30
2018-06-30 5:44:50 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 30
2018-06-30 5:44:50 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 30
2018-06-30 5:44:50 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in C:\xampp\htdocs\shop\vqmod\vqcache\vq2-system_library_template_Twig_Autoloader.php on line 30
thank you
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Export "By batches" is possible, but it is not possible to download the goods without removing the existing ones.
There are a large number of directories and goods, you need to export the entire list of products, but when Import there is a 504 error, the time of the script is not possible to change.
Or can it be possible to download only new products without removing existing ones?
Thank!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
After import, the goods are overwritten, even if you select "No (Delete all old data before Import)"
How can this be avoided?
everything seems to work fine even my php server settings are set high but there is a strange error "ERR_EMPTY_RESPONSE" when i try to import a file with just 4000 products, and i checked apache error logs, php error logs, opencart error logs i just cant find the reason for this error. If i know the error reason i can try to resolve it on my end only.
PS: Forgot to mention i am using OpenCart 2.2.0.0
Just? Try to go a little bit lighter on the size of the products you are trying to import and see if that results better insights. Also ensure the max input size in your php.ini uses a decent and high value (999M?). If already increased, it is possible that your server may be automatically defined to a lower value by your web hosting service.angadarora wrote: ↑Fri Aug 31, 2018 11:00 pmHi
everything seems to work fine even my php server settings are set high but there is a strange error "ERR_EMPTY_RESPONSE" when i try to import a file with just 4000 products, and i checked apache error logs, php error logs, opencart error logs i just cant find the reason for this error. If i know the error reason i can try to resolve it on my end only.
PS: Forgot to mention i am using OpenCart 2.2.0.0
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Users browsing this forum: No registered users and 73 guests