Now that you have installed the bulk import/ export tool for OpenCart, you can begin using it to add or modify products in your OpenCart store. The first step is to export your existing products so you know how the spreadsheets work. Then you can add products to the spreadsheet offline and upload the file once you have finished.
- Log into the OpenCart Dashboard
- Go to System > Export/ Import
- Click “Export” to download an Excel spreadsheet of your current products
- Open the spreadsheet with the appropriate software such as Open Office or Microsoft Excel
- Once you are done adding the products you want to add, in the correct format as your current products are laid out on the spreadsheet, save the file
- Now, go back to your OpenCart dashboard to: System Export/ Import
- Choose the file you just saved on your local computer by clicking the “Choose File” button next to “Import from spreadsheet file:”
- Once you save selected a file, click “Import”
Notice at the bottom of the spreadsheet, there is 7 separate sheets to work with (categories, products, options, attributes, specials, discounts, and rewards)
Once you have successfully imports your categories and products you will get a message on the top of your screen letting you know it has completed.
If you need further assistance please feel free to ask a question on our support center.
I tried to import .xlsx file,but i got this error while uploading.
Uploaded spreadsheet file has validation errors!
See also ‘System > Tools > Error Logs’ for more details.
No server data has been changed.
Thanks
You will want to check the error_log file as the message says. It will contain more details.
Hello.
I found your extension to OC 2.2.0.0.
And when you try to import my error occurs:
==
Call to undefined function isInteger()
No server data has been changed.
==
How to fix it?
Thankyou.
Hello Pavel,
Thank you for contacting us. Please ensure the tables in your database match the information you are importing, as this is a common error.
Aleo, enabling error reporting may help produce a more meaningful error message.
Thank you,
John-Paul
great
hi, i need help, please.
I have instaled the extension well, but when i go to export give me this “ Attribute ‘Attributes 2’ is defined multiple times within its attribute group!
In the Settings-tab please activate the following:
Use attribute_id instead of attribute name in worksheet ‘ProductAttributes'” ” and i don’t see where do i have to change that. Sorry if i dont write well, i dont speak english very well.
Regards
Hello Glenda,
Have you tried performing the actions described in the error message?
Best Regards,
TJ Edens
Hi,
I installed export/import, I have a vqmod installed, Everything ok. When I upload file I get message – Success: You have successfully imported your data! But, I don’t any product in my admin panel and site.
I use OC 2.1.0.1.file is .xlsx
Thanks!
Hello Radu,
Unfortunately we do not have any experience as of yet with OpenCart 2.x. However, you may want to check your database to see if the products were indeed inserted there. That would give you a first step.
Kindest Regards,
Scott M
Hi
I have granted permission for the admin through usergroup.
But the tool is not showing up.
Please help me
regards
sudha
Hello sudha,
Thank you for contacting us. Did you follow our installation guide?
What version of OpenCart are you running?
What version of the Bulk Import/export plugin are you running?
Thank you,
John-Paul
Need a little help putting the correct details in cells of my spreadsheet, so that I don’t have to enter ‘colour’ and ‘size’ manually for each product.
Thank you to anyone who can help
Hello MjpBiz,
Sorry for the problem with the spreadsheet. If this requires a custom fix, then you will need to speak with the developer of the plugin, or a programmer that can further assist you with the modification of the input fields. Please consult with the developer, or post a question in the OpenCart forum for further assistance. Check the readme.txt for detail documentation on the use of the importing too.
Export/Import: Invalid header in the Products worksheet
how to solve this issue ?
Hello,
Sorry for the problem with the invalid header. You need to make sure that the headers match up with the ones being used by OpenCart. You would need to remove any extra header columns that do not match.
I hope this helps to answer your question, please let us know if you require any further assistance.
Regards,
Arnel C.
Hi Scott
I am on opencart 2.0.3.1
Thanks
Hello John,
In doing a bit of research the error means that it only needs 1 parameter but it is getting 2 passed to it. You may be able to test it by opening the file at system/PHPExcel/Classes/PHPExcel/Reader/HTML.php and seeing if line 427 is trying to pass 2 parameters. You may want to remove the second parameter and see if that helps. Make sure you make a copy of the file beforehand so you have a pure one to restore if needed.
Unfortunately I am not aware of what causes this or even if it will fix it. It is just a suggestion based on what I found on the error message and other people’s results in different environments.
Kindest Regards,
Scott M
Hi
I succesfully import the product according to the import tab but nothing is added. I find this error in the error log
PHP Warning: DOMDocument::loadHTMLFile() expects exactly 1 parameter, 2 given in /home/relimobi/public_html/system/PHPExcel/Classes/PHPExcel/Reader/HTML.php on line 427
Thanks
Hello John,
What version of OpenCart are you using?
Kindest Regards,
Scott M
i am using opencart Version 2.0.2.0. i uploaded and installed Export/ Import tool but cant find step 2 option (Go to System > Export/ Import).
what do i do?
Hello Idoko,
Sorry for the problem with the tool. We can’t tell what version you’re trying to load (as there are multiple versions of the tool). If you’re not seeing it, then make sure that you have met all of the requirements needed for the tool to work. If you continue to have problems, we highly recommend that you contact the author of the tool in order to resolve the issue.
I hope this helps to answer your question, please let us know if you require any further assistance.
Regards,
Arnel C.
and one more error occur
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”demooo’,11,’https://images.cwrelectronics.com/product/xl/42998XL.jpg’,1,19.95,0,’ at line 1
Error No: 1064
INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (68,100,”,”,”,”,”,”,”,,’demooo’,11,’https://images.cwrelectronics.com/product/xl/42998XL.jpg’,1,19.95,0,’2009-02-03 16:06:50′,’2011-09-30 01:05:39′,’2009-02-03′,146.4,2,1,9,0,0,0,0,’1′,’0′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
Hello Mayank,
Apologies for the problem with the import. If you look closely at all of the errors listed, there appear to be multiple problems with the data you’re using. You will need to correct the data you’re trying to import BEFORE you can simply use the tool. The data needs to match with the fields that you have setup in OpenCart already. If you have data that is not appropriate for import/export, it will also cause many of the errors that you’re seeing. We did not create this plugin, so if you’re having coding issues with the plugin, you will need to contact the author of the plugin and provide information on the problem that you’re having. I hope this is clear. The import/export program will NOT sort out the data for you, you must remove any inappropriate data or fields before you can attempt the import or export.
Regards,
Arnel C.
i try to import but some error occur
Uploaded spreadsheet file has validation errors!
See also ‘System > Error Logs’ for more details.
No server data has been changed.
and error log say
2015-05-22 17:15:13 – Export/Import: Missing product_ids in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’28’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’29’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’31’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’32’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’34’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’36’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’40’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’41’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’44’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’45’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’46’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’48’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’49’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Specials’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Specials’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Discounts’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’28’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’29’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’31’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’32’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’33’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’34’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’36’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’40’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’41’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’44’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’45’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’46’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’48’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’49’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:15:13 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Missing product_ids in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’28’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’29’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’31’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’32’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’34’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’36’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’40’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’41’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’44’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’45’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’46’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’48’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’49’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Specials’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Specials’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Discounts’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’28’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’29’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’31’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’32’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’33’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’34’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’36’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’40’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’41’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’44’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’45’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’46’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’48’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’49’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:16:24 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’28’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’29’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’31’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’32’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’34’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’36’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’40’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’41’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’44’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’45’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’46’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’48’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘AdditionalImages’ cannot use product_id ’49’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Specials’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Specials’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Discounts’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’28’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’29’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’31’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’32’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’33’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’34’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’36’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’40’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’41’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’44’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’45’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’46’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’48’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘Rewards’ cannot use product_id ’49’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductOptions’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’30’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’35’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductOptionValues’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’42’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’43’ because it is not listed in worksheet ‘Products’!
2015-05-22 17:18:02 – Export/Import: Worksheet ‘ProductAttributes’ cannot use product_id ’47’ because it is not listed in worksheet ‘Products’!
2015-05-23 14:02:12 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-24 10:11:24 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-24 10:11:25 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-24 17:21:19 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-24 17:23:06 – PHP Warning: mail() [<a href=’function.mail’>function.mail</a>]: SMTP server response: 530 5.7.0 Must issue a STARTTLS command first. pc9sm7114413pdb.6 – gsmtp in D:\xampp\htdocs\rynkel\system\library\mail.php on line 162
2015-05-24 17:23:43 – PHP Warning: mail() [<a href=’function.mail’>function.mail</a>]: SMTP server response: 530 5.7.0 Must issue a STARTTLS command first. m2sm7114541pdp.4 – gsmtp in D:\xampp\htdocs\rynkel\system\library\mail.php on line 162
2015-05-24 17:32:21 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-24 17:32:37 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-24 17:32:37 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-24 17:33:07 – PHP Warning: mail() [<a href=’function.mail’>function.mail</a>]: SMTP server response: 530 5.7.0 Must issue a STARTTLS command first. bx6sm7120324pdb.39 – gsmtp in D:\xampp\htdocs\rynkel\system\library\mail.php on line 162
2015-05-24 19:40:29 – PHP Warning: mail() [<a href=’function.mail’>function.mail</a>]: SMTP server response: 530 5.7.0 Must issue a STARTTLS command first. l8sm7333936pdj.80 – gsmtp in D:\xampp\htdocs\rynkel\system\library\mail.php on line 162
2015-05-25 13:07:24 – PHP Notice: Undefined variable: entry_video in D:\xampp\htdocs\rynkel\admin\view\template\catalog\product_form.tpl on line 122
2015-05-25 13:26:05 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 13:48:51 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 13:49:53 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 13:54:19 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 13:57:47 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 13:59:48 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:01:12 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:02:13 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:02:47 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:04:13 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:04:28 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:05:20 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:06:29 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:18:08 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:18:17 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:19:36 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:21:49 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:22:06 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:22:06 – PHP Notice: Undefined variable: vid in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 316
2015-05-25 14:49:10 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:51:57 – PHP Notice: Error: Unknown column ‘v.vid’ in ‘field list'<br />Error No: 1054<br />SELECT DISTINCT *, pd.name AS name,v.vid,p.image, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = ‘1’ AND pd2.quantity = ‘1’ AND ((pd2.date_start = ‘0000-00-00’ OR pd2.date_start < NOW()) AND (pd2.date_end = ‘0000-00-00’ OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = ‘1’ AND ((ps.date_start = ‘0000-00-00’ OR ps.date_start < NOW()) AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = ‘1’) AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = ’52’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available <= NOW() AND p2s.store_id = ‘0’ in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-25 14:51:57 – PHP Notice: Trying to get property of non-object in D:\xampp\htdocs\rynkel\catalog\model\catalog\product.php on line 10
2015-05-25 14:51:57 – PHP Notice: Error: Unknown column ‘v.vid’ in ‘field list'<br />Error No: 1054<br />SELECT DISTINCT *, pd.name AS name,v.vid,p.image, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = ‘1’ AND pd2.quantity = ‘1’ AND ((pd2.date_start = ‘0000-00-00’ OR pd2.date_start < NOW()) AND (pd2.date_end = ‘0000-00-00’ OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = ‘1’ AND ((ps.date_start = ‘0000-00-00’ OR ps.date_start < NOW()) AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = ‘1’) AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = ’52’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available <= NOW() AND p2s.store_id = ‘0’ in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-25 14:51:57 – PHP Notice: Trying to get property of non-object in D:\xampp\htdocs\rynkel\catalog\model\catalog\product.php on line 10
2015-05-25 14:51:57 – PHP Notice: Error: Unknown column ‘v.vid’ in ‘field list'<br />Error No: 1054<br />SELECT DISTINCT *, pd.name AS name,v.vid,p.image, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = ‘1’ AND pd2.quantity = ‘1’ AND ((pd2.date_start = ‘0000-00-00’ OR pd2.date_start < NOW()) AND (pd2.date_end = ‘0000-00-00’ OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = ‘1’ AND ((ps.date_start = ‘0000-00-00’ OR ps.date_start < NOW()) AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = ‘1’) AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = ’52’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available <= NOW() AND p2s.store_id = ‘0’ in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-25 14:51:57 – PHP Notice: Trying to get property of non-object in D:\xampp\htdocs\rynkel\catalog\model\catalog\product.php on line 10
2015-05-25 14:51:58 – PHP Notice: Error: Unknown column ‘v.vid’ in ‘field list'<br />Error No: 1054<br />SELECT DISTINCT *, pd.name AS name,v.vid,p.image, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = ‘1’ AND pd2.quantity = ‘1’ AND ((pd2.date_start = ‘0000-00-00’ OR pd2.date_start < NOW()) AND (pd2.date_end = ‘0000-00-00’ OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = ‘1’ AND ((ps.date_start = ‘0000-00-00’ OR ps.date_start < NOW()) AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = ‘1’) AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = ’52’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available <= NOW() AND p2s.store_id = ‘0’ in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-25 14:51:58 – PHP Notice: Trying to get property of non-object in D:\xampp\htdocs\rynkel\catalog\model\catalog\product.php on line 10
2015-05-25 14:51:58 – PHP Notice: Error: Unknown column ‘v.vid’ in ‘field list'<br />Error No: 1054<br />SELECT DISTINCT *, pd.name AS name,v.vid,p.image, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = ‘1’ AND pd2.quantity = ‘1’ AND ((pd2.date_start = ‘0000-00-00’ OR pd2.date_start < NOW()) AND (pd2.date_end = ‘0000-00-00’ OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = ‘1’ AND ((ps.date_start = ‘0000-00-00’ OR ps.date_start < NOW()) AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = ‘1’) AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = ’52’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available <= NOW() AND p2s.store_id = ‘0’ in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-25 14:51:58 – PHP Notice: Trying to get property of non-object in D:\xampp\htdocs\rynkel\catalog\model\catalog\product.php on line 10
2015-05-25 14:51:58 – PHP Notice: Error: Unknown column ‘v.vid’ in ‘field list'<br />Error No: 1054<br />SELECT DISTINCT *, pd.name AS name,v.vid,p.image, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = ‘1’ AND pd2.quantity = ‘1’ AND ((pd2.date_start = ‘0000-00-00’ OR pd2.date_start < NOW()) AND (pd2.date_end = ‘0000-00-00’ OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = ‘1’ AND ((ps.date_start = ‘0000-00-00’ OR ps.date_start < NOW()) AND (ps.date_end = ‘0000-00-00’ OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = ‘1’) AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = ‘1’) AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = ‘1’) AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = ‘1’) AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = ‘1’ GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = ‘1’ GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = ’52’ AND pd.language_id = ‘1’ AND p.status = ‘1’ AND p.date_available <= NOW() AND p2s.store_id = ‘0’ in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-25 14:51:58 – PHP Notice: Trying to get property of non-object in D:\xampp\htdocs\rynkel\catalog\model\catalog\product.php on line 10
2015-05-25 14:52:18 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:52:49 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 14:52:49 – PHP Notice: Undefined variable: video in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 316
2015-05-25 15:42:06 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 15:42:06 – PHP Notice: Undefined variable: video in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 316
2015-05-25 15:46:30 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 15:48:32 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 15:48:32 – PHP Warning: mysql_query() [<a href=’function.mysql-query’>function.mysql-query</a>]: Access denied for user ‘ODBC’@’localhost’ (using password: NO) in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 317
2015-05-25 15:48:32 – PHP Warning: mysql_query() [<a href=’function.mysql-query’>function.mysql-query</a>]: A link to the server could not be established in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 317
2015-05-25 15:48:32 – PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 318
2015-05-25 15:52:27 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 15:53:31 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:21:48 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:22:11 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:24:04 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:25:01 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:26:10 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:28:34 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:30:00 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:30:19 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 16:31:10 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-25 17:29:39 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-27 9:36:55 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 215
2015-05-29 19:31:13 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 220
2015-05-29 19:31:14 – PHP Notice: Undefined variable: entry_captcha in D:\xampp\htdocs\rynkel\catalog\view\theme\journal2\template\product\product.tpl on line 220
2015-05-29 20:11:21 – PHP Fatal Error: Call to undefined method ModelToolExportImport::deleteProducts() in D:\xampp\htdocs\rynkel\admin\model\tool\export_import.php on line 914
2015-05-29 20:11:21 – PHP Warning: Cannot modify header information – headers already sent by (output started at D:\xampp\htdocs\rynkel\admin\model\tool\export_import.php:914) in D:\xampp\htdocs\rynkel\admin\model\tool\export_import.php on line 49
2015-05-29 20:11:21 – PHP Warning: Cannot modify header information – headers already sent by (output started at D:\xampp\htdocs\rynkel\admin\model\tool\export_import.php:914) in D:\xampp\htdocs\rynkel\admin\model\tool\export_import.php on line 50
2015-05-29 20:13:23 – PHP Notice: Undefined variable: sql in D:\xampp\htdocs\rynkel\admin\model\tool\export_import.php on line 864
2015-05-29 20:13:23 – PHP Notice: Error: Duplicate entry ’50’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (50,100,”,”,”,”,”,”,”,6,’TOP1′,0,’catalog/tees a1.jpg’,1,0,0,’2015-05-22 17:29:25′,’2015-05-23 14:01:27′,’2015-05-22′,0,1,1,0,6,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:13:23 – PHP Notice: Error: Duplicate entry ’51’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (51,100,”,”,”,”,”,”,”,6,’top2′,0,’/product/dress c1.jpg’,1,0,0,’2015-05-24 10:16:56′,’0000-00-00 00:00:00′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:13:23 – PHP Notice: Error: Duplicate entry ’52’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (52,100,”,”,”,”,”,”,”,6,’B1′,0,’/product/shirt b1.jpg’,1,0,0,’2015-05-24 10:20:46′,’0000-00-00 00:00:00′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:13:23 – PHP Notice: Error: Duplicate entry ’53’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (53,100,”,”,”,”,”,”,”,6,’B2′,0,’/product/tshirt d5.jpg’,1,0,0,’2015-05-24 10:24:38′,’2015-05-24 17:20:41′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:13:23 – PHP Notice: Error: Duplicate entry ’54’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (54,100,”,”,”,”,”,”,”,6,’G1′,0,’/product/dress d1.jpg’,1,0,0,’2015-05-24 10:27:01′,’0000-00-00 00:00:00′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:13:23 – PHP Notice: Error: Duplicate entry ’55’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (55,99,”,”,”,”,”,”,”,6,’134′,0,”,1,0,0,’2015-05-24 17:28:46′,’2015-05-24 17:30:49′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1’); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:13:23 – PHP Notice: Error: Duplicate entry ’56’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (56,1,’15 min’,”,”,”,”,”,”,6,’B2′,0,’/auto-detailing.jpg’,1,0,0,’2015-05-25 13:21:26′,’2015-05-25 16:30:41′,’2015-05-25′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:13:23 – PHP Warning: Cannot modify header information – headers already sent by (output started at D:\xampp\htdocs\rynkel\admin\model\tool\export_import.php:43) in D:\xampp\htdocs\rynkel\system\modification\system\library\response.php on line 12
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’50’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (50,100,”,”,”,”,”,”,”,6,’TOP1′,0,’catalog/tees a1.jpg’,1,0,0,’2015-05-22 17:29:25′,’2015-05-23 14:01:27′,’2015-05-22′,0,1,1,0,6,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’50-1′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_description` (`product_id`, `language_id`, `name`, `description`, `meta_title`, `meta_description`, `meta_keyword`, `tag`) VALUES ( 50, 1, ‘girl toper’, ‘<p><span data-target=”chatbox-message-content” class=”chatbox-thread-item ng-scope has-multi-line”><span class=”ng-binding”>Attached\n is the sample file that we will upload. Please note a product can be \nunder multiple categories and multiple sub-categories. Visit Rynkel.com \nand the main category \’Auto Home and Office\’ , \’Boating and Marine\’ , \n\’Electronics\’ etc are just the static heading on the website. When you \nmouse over it shows category and then sub-category. Also you have to \nremember if there is a new product resides in the csv file they may have\n new category and sub-category. We need to create that in the system and\n put it under the website heading automatically. Please spend some time \nto design the upload process very carefully, otherwise it will give you \nand me nightmare.</span></span></p>’, ‘Girl toper’, ‘Attached is the sample file that we will upload. Please note a product can be under multiple categories and multiple sub-categories. Visit Rynkel.com and the main category \’Auto Home and Office\’ , \’Boating and Marine\’ , \’Electronics\’ etc are just the stat’, ‘girl’, ‘toper’ ); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’50-66′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_category` (`product_id`,`category_id`) VALUES
(50,66); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’50-0′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_store` (`product_id`,`store_id`) VALUES (50,0); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’51’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (51,100,”,”,”,”,”,”,”,6,’top2′,0,’/product/dress c1.jpg’,1,0,0,’2015-05-24 10:16:56′,’0000-00-00 00:00:00′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’51-1′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_description` (`product_id`, `language_id`, `name`, `description`, `meta_title`, `meta_description`, `meta_keyword`, `tag`) VALUES ( 51, 1, ‘Girl Green’, ‘<p><span data-target=”chatbox-message-content” class=”chatbox-thread-item ng-scope has-multi-line”><span class=”ng-binding”>Attached\n is the sample file that we will upload. Please note a product can be \nunder multiple categories and multiple sub-categories. Visit Rynkel.com \nand the main category \’Auto Home and Office\’ , \’Boating and Marine\’ , \n\’Electronics\’ etc are just the static heading on the website. When you \nmouse over it shows category and then sub-category. Also you have to \nremember if there is a new product resides in the csv file they may have\n new category and sub-category. We need to create that in the system and\n put it under the website heading automatically. Please spend some time \nto design the upload process very carefully, otherwise it will give you \nand me nightmare.</span></span></p>’, ‘Green top’, ”, ”, ‘Tops, Girl Fasion’ ); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’51-66′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_category` (`product_id`,`category_id`) VALUES
(51,66),
(51,62),
(51,60),
(51,59); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’51-0′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_store` (`product_id`,`store_id`) VALUES (51,0); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’51-0′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_layout` (`product_id`,`store_id`,`layout_id`) VALUES (51,0,4); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’52’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (52,100,”,”,”,”,”,”,”,6,’B1′,0,’/product/shirt b1.jpg’,1,0,0,’2015-05-24 10:20:46′,’0000-00-00 00:00:00′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’52-1′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_description` (`product_id`, `language_id`, `name`, `description`, `meta_title`, `meta_description`, `meta_keyword`, `tag`) VALUES ( 52, 1, ‘Boy Top’, ‘<p><span data-target=”chatbox-message-content” class=”chatbox-thread-item ng-scope has-multi-line”><span class=”ng-binding”>Attached\n is the sample file that we will upload. Please note a product can be \nunder multiple categories and multiple sub-categories. Visit Rynkel.com \nand the main category \’Auto Home and Office\’ , \’Boating and Marine\’ , \n\’Electronics\’ etc are just the static heading on the website. When you \nmouse over it shows category and then sub-category. Also you have to \nremember if there is a new product resides in the csv file they may have\n new category and sub-category. We need to create that in the system and\n put it under the website heading automatically. Please spend some time \nto design the upload process very carefully, otherwise it will give you \nand me nightmare.</span></span></p>’, ‘boy top’, ”, ”, ‘boy, shirt’ ); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’52-66′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_category` (`product_id`,`category_id`) VALUES
(52,66),
(52,65),
(52,62),
(52,60),
(52,59); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’52-0′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_store` (`product_id`,`store_id`) VALUES (52,0); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’52-0′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_layout` (`product_id`,`store_id`,`layout_id`) VALUES (52,0,4); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’53’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (53,100,”,”,”,”,”,”,”,6,’B2′,0,’/product/tshirt d5.jpg’,1,0,0,’2015-05-24 10:24:38′,’2015-05-24 17:20:41′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’53-1′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_description` (`product_id`, `language_id`, `name`, `description`, `meta_title`, `meta_description`, `meta_keyword`, `tag`) VALUES ( 53, 1, ‘boY Shirt’, ‘<p><span data-target=”chatbox-message-content” class=”chatbox-thread-item ng-scope has-multi-line”><span class=”ng-binding”>Attached\n is the sample file that we will upload. Please note a product can be \nunder multiple categories and multiple sub-categories. Visit Rynkel.com \nand the main category \’Auto Home and Office\’ , \’Boating and Marine\’ , \n\’Electronics\’ etc are just the static heading on the website. When you \nmouse over it shows category and then sub-category. Also you have to \nremember if there is a new product resides in the csv file they may have\n new category and sub-category. We need to create that in the system and\n put it under the website heading automatically. Please spend some time \nto design the upload process very carefully, otherwise it will give you \nand me nightmare.</span></span></p>’, ‘Boy shirt’, ”, ”, ‘Boy, Boy shirt’ ); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’53-62′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_category` (`product_id`,`category_id`) VALUES
(53,62),
(53,61),
(53,60),
(53,59),
(53,66),
(53,63); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’53-0′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_store` (`product_id`,`store_id`) VALUES (53,0); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’53-0′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_layout` (`product_id`,`store_id`,`layout_id`) VALUES (53,0,4); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’54’ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (54,100,”,”,”,”,”,”,”,6,’G1′,0,’/product/dress d1.jpg’,1,0,0,’2015-05-24 10:27:01′,’0000-00-00 00:00:00′,’2015-05-24′,0,1,1,0,0,0,0,0,’1′,’1′,’1′,’1′); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’54-1′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_description` (`product_id`, `language_id`, `name`, `description`, `meta_title`, `meta_description`, `meta_keyword`, `tag`) VALUES ( 54, 1, ‘Girl Red’, ‘<p><span data-target=”chatbox-message-content” class=”chatbox-thread-item ng-scope has-multi-line”><span class=”ng-binding”>Attached\n is the sample file that we will upload. Please note a product can be \nunder multiple categories and multiple sub-categories. Visit Rynkel.com \nand the main category \’Auto Home and Office\’ , \’Boating and Marine\’ , \n\’Electronics\’ etc are just the static heading on the website. When you \nmouse over it shows category and then sub-category. Also you have to \nremember if there is a new product resides in the csv file they may have\n new category and sub-category. We need to create that in the system and\n put it under the website heading automatically. Please spend some time \nto design the upload process very carefully, otherwise it will give you \nand me nightmare.</span></span></p>’, ‘Girl’, ”, ”, ‘Girl, Top’ ); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ’54-66′ for key ‘PRIMARY'<br />Error No: 1062<br />INSERT INTO `oc_product_to_category` (`product_id`,`category_id`) VALUES
(54,66),
(54,64),
(54,63),
(54,61),
(54,59); in D:\xampp\htdocs\rynkel\system\library\db\mysqli.php on line 41
2015-05-29 20:18:30 – PHP Notice: Error: Duplicate entry ‘
Hi, i exported “products” and changed the prices. but i was not able to import successfully.
I then export one more time, this time without editting anything. i import again and still get the error.
Can you please advise? I am using OC 2.0.2.0 and there is only 183 products.
Uploaded spreadsheet file has validation errors!
See also ‘System > Error Logs’ for more details.
No server data has been changed.
Hello Mishi,
Have you checked your error log file within your opencart installation to find the exact error your website is giving when trying to import the file? If you could please provide the line giving the error so we may troubleshoot the issue more.
Best Regards,
TJ Edens
Dear friends,
I need opencart 2.0 export/import working sample excel sheet.any one provide me?
Please HELP!
In our case file gets downloaded (only 173bytes) but gets an error on opening.
Everything was working fine before, untill we changed the VPS (Moved all files and db to the new host vps) Dont know which setting to do. Please Help!
Hello Savvy,
Thank you for contacting us today. Enabling error reporting in OpenCart, may help provide a more detailed error message when you are exporting.
Have you tried removing the parenthesis “()” from the file name, or shortening the file name?
There are additional suggestionson Microsoft’s official page on the Filename is not valid error.
Thank you,
John-Paul
opencart 2.0.1.1 and yes I did.
Hello Jonathan,
We are not well versed in OpenCart 2.x currently and have not run many tests. Please provide more information so we can attempt to duplicate. Which specific download of the extension are you using? Give the exact steps that you are taking that lead to this error.
Kindest Regards,
Scott M
Hi
I tried uploading a spreadsheet and the following errors appear…
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘1 Ltr Venice (Lime)’ for option_name ‘Paint’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico Venice Paint 12 x 3 Wall Brush’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico 2″ Wide Flat, Double Thick’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico 35 mm Oval’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘1 Ltr Venice (Lime)’ for option_name ‘Paint’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico Venice Paint 12 x 3 Wall Brush’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico 2″ Wide Flat, Double Thick’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico 35 mm Oval’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘1 Ltr Venice (Lime)’ for option_name ‘Paint’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico Venice Paint 12 x 3 Wall Brush’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico 2″ Wide Flat, Double Thick’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico 35 mm Oval’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘1 Ltr Venice (Lime)’ for option_name ‘Paint’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico Venice Paint 12 x 3 Wall Brush’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico 2″ Wide Flat, Double Thick’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘Authentico 35 mm Oval’ for option_name ‘Brushes’ used in worksheet ‘ProductOptionValues’!
2015-04-17 0:38:36 – Export/Import: Undefined option_value_name ‘1 Ltr Venice (Lime)’ for option_name ‘Paint’ used in worksheet ‘ProductOptionValues’!
Please can anyone help my cause with these errors and point me in the right direction.
Hello Jonathan,
Thank you for contacting us today. We are happy to help, but will need some additional information.
What version of OpenCart are you using?
Did you ensure you are using the version of the Export tool, that is compatible with your version of OpenCart?
Thank you,
John-Paul
Thanks Arnel for co-operating . i need it urgent now i am going to upload it with 1.5.6.4 it working well. once againg thanks for co-operation
Hello Hamza,
I’m sorry for the problems you’re seeing with the import. Most likely, the value that you’re trying to import is going into a field that is of type “integer” as opposed to “decimal”, so it’s being trimmed. We did NOT write this program, so you will need to contact the author of the extension in order to see if it can be modified to accommodate your needs.
Regards,
Arnel C.
i have men shirt and i option i have collar sizes
Sizes :14,14.5 ,15,15.5,16,16.5
every time i export the file and import it again it changs the sizes to 14,15 ,15 ,16 ,17
all the sizes with decimals are coverted into whole numbers , quick help would be appericaited
how i send my db file to you
Hello Fareed,
We do not have your database, and you cannot simply paste it into the message windows here. Make sure that you have verified that the data you’re trying to transfer matches up with with the requirements of the application. Please email the database you’re trying to transfer to customer_community@inmotionhosting.com with a subject line of: Attention: Community Support. That way we can find it. We can look at the data you’re sending, but it doesn’t guarantee we can fix it. You may need to refer to the extension author’s support if we are unable to resolve the problem.
Regards,
Arnel C.
yes i have install it the module working perfectly but issue is that products are not showing in related menu . my all products avalible in admin panel
Hello Fareed Khan,
We would need to see your database and look at the products you imported to see why it’s not showing. However, you should check your settings for what you imported, it’s very possible that you’re missing a settings that’s currently required for you products to show properly. For example, check out the OpenCart forums on this same issue.
Regards,
Arnel C.
2015-04-10 4:17:17 – Export/Import: Invalid header in the Categories worksheet
2015-04-10 4:17:17 – Export/Import: Invalid header in the Products worksheet
2015-04-10 4:17:17 – Export/Import: Invalid header in the Options worksheet
2015-04-10 4:17:17 – Export/Import: Invalid header in the Attributes worksheet
2015-04-10 4:17:17 – Export/Import: Missing AttributeGroups worksheet, or AttributeGroups worksheet not listed before Attributes
2015-04-10 4:17:17 – Export/Import: OptionValues worksheet also expected after an Options worksheet
2015-04-10 4:22:21 – PHP Notice: Undefined variable: heading_title in C:\xampp\htdocs\farid\catalog\view\theme\buyshop\template\common\home.tpl on line 15
2015-04-10 4:22:35 – PHP Notice: Undefined variable: heading_title in C:\xampp\htdocs\farid\catalog\view\theme\buyshop\template\common\home.tpl on line 15
2015-04-10 4:26:05 – Export/Import: Invalid header in the Categories worksheet
2015-04-10 4:26:05 – Export/Import: Invalid header in the Products worksheet
2015-04-10 4:26:05 – Export/Import: Invalid header in the Options worksheet
2015-04-10 4:26:05 – Export/Import: Invalid header in the Attributes worksheet
2015-04-10 4:26:05 – Export/Import: Missing AttributeGroups worksheet, or AttributeGroups worksheet not listed before Attributes
2015-04-10 4:26:05 – Export/Import: OptionValues worksheet also expected after an Options worksheet
plz sugust me how i solve this problem.?????
Hello Fareed,
Were you able to install teh vqmod prior to installing the import/export module?
Kindest Regards,
Scott M
Hey guys, thanks for posting this handy article, helped me big time. Although i was searching for more efficient way, to import\export products. I found this tool in the web, not sure if this is OpenCart extension, or stand alone tool, but they have detailed documentation for these questions:
this is for import: https://store-manager-for-opencart-documentation.emagicone.com/products-management/import-products
and this is for export: https://store-manager-for-opencart-documentation.emagicone.com/products-management/export-products
I tried this on their trial version, had to spend few hours, but in the end i managed to do this bit more fluently.
I hope this will help.
Hello Chuck,
Thank you for the suggestion. Feel free to contribute a post to our User Submitted section.
Thank you,
John-Paul
Does anyone have a demo or a sample spreadsheet to see what data fields are included?
Hello GF,
Thank you for your question. Please see the following image, taken from the above guide:
It shows the default format of an exported spreadsheet.
Thank you,
John-Paul
Hello sir
I want to import product on opencart 1.5.6.4 by excel sheet.all is ok.but product attribute not added.if i include any attribute on excel sheet.that not upload.which showing not exct. excel sheet.
please help me for resolve this problem.will you give me an example for excel sheet
Hi,
Can not open exported excel file. It says it is the wrong file extension or/and corruppted file. Tried to export several times.
Hello Kristian,
It almost sounds like the file is not downloading completely. Do you have an account with us? If so can you provide us with your domain so I may try to replicate the issue?
Best Regards,
TJ Edens
Assalam O Alakum!
Afsar!
As Scott mentioned that there are compatability issues with new version, so either wait for upgrade or do it manually.
By the wasy, I can help you in exporting the existing data to new installation.
# of hours needed for this exercise could be confirmed after I have the details.
Feel free to contatc me at hasanjh7@gmail.com.
Thanks
Hasan
hi ,
i am using opencart theme version 2.0.1.1 and i have installed the extension but i am having some difficulties to make it work. i am having error
“Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
See also ‘System > Error Logs’ for more details.
No server data has been changed.”
do you have any idea?
i have successfully installed and using this extension in my opencart theme 1.5.6.4 but what i am trying to do is now exporting my existing product / catagories data from 1.5.6.4 and trying to import the same xls file to my opencart theme version 2.0.1.1
when i click import in opencart 2.0.1.1 i am having this error in red text :
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
See also ‘System > Error Logs’ for more details.
No server data has been changed.
what i am doing wrong please help.
so many thanks for your support and assistance.
Regards
Afsar ahmed
Hello Asfar,
From what I can see on the extension’s home page, it is not yet fully compatible with OpenCart 2.x
Kindest Regards,
Scott M
Hi, I’m in trouble with the module import / export facility in my OC 1.5.6.4.
We install all 3 folders in / public_html / ocart frame tool import and all well but after that this option does not appear in the System tab.
Can you tell me where is the error?
Thanks in advance
Hello Manuel,
Did you first install VQmod?
Kindest Regards,
Scott M
First of all a very big thank you for the awesome work. I was able to successfully use the export/import for Opencart 2.0.1.1 by following the exact instructions mentioned. For installaing the extension I used the readme file provided with the zip file.
Couldn’t thank you enough.
The Products are not coming under the categories on website. the products are uploaded, the categories are uploaded. But when i click on categories, it shows ‘no products inside’. what must be the problem?
This may simply be an issue of no categories being associated with the products, usually due to an error in the import. To resolve it, it is usually best to just adjust the categories for each product.
Hello Scott, That’s effective. I have upgraded the PHP up to 5.2.17. It goes well without any bug. So great work! Many thanks.
Hello Sir , OpenCart 1.5.6.4 with opencart-1-5-1-to-1-5-6-x-export-import-multilingual-2-17.zip, PHP version 5.2.6
Export works good. However, import any files exported, the tips is:Call to undefined function libxml_disable_entity_loader()
No server data has been changed.
How to fix it? Thanks.
Hello WT,
From what I can find, it seems to be a php/application version combination issue. You may want to try and upgrade the php version first. I know that OpenCart says it only needs 5.2 or higher, but upgrading it a bit should not hurt, especially if you are one of our customers where you can change the version of php on your server at any time.
Kindest Regards,
Scott M
Open Cart version 1.5.6.4
I have added this extension manuallay and not through VQmod(there were soem problems with VQ mod at my shared hosting)
First I amde and export and then I added all my products in the same file.
I applied import, though it says SUCCESSFUL,but, practically notnhing is there. Have tried multiple times
Hello Hasan,
As stated in our article on Installing the bulk import/export extension you must have VQmod installed in order for the extension to work. Please make sure you do that and then let us know if you have any other issues.
Kindest Regards,
Scott M
Hello sir
I want to import product on opencart 1.5.5.1 by excel sheet.all is ok.but product attribute not added.if i include any attribute on excel sheet.that not upload.which showing not exct. excel sheet.
please help me for resolve this problem.will you give me an example for excel sheet
thank
jahan
Hello jahan,
Thank you for your question. Before you can import an attribute in OpenCart, it must be setup in the dashboard first. It is covered in our class on Adding Attributes to OpenCart products.
The easiest way is to add all the attributes to any product, which will create the tables. You should then be able to import your product attributes successfully.
If you have any further question, feel free to post them below.
Thank you,
John-Paul
Hi Sir,
I received you e-mail and thank you kindly! Before I contact the other author is there no way that you could tell me if the import feature could take the path from the options worksheet image column and add it to the a sql table “oc_product_option_value” column “option_image” ? Perhahps a change in a config file or similar?
Thank you again!
Regards,
Mario
Hello Mario,
Thanks for the question and your patience. The problem has to do with the function (in PHP or MySQL) that is being used to run the import. It would need to include that value in the transfer. It may be a simple code change that you can make, but I am not sure where this value would need to be included. The author of the plugin, or OpenCart support should have an idea of where the change would required for the import function. I do apologize that I cannot give you those specifics.
Regards,
Arnel C.
Hi Sir,
The module works extremely well and I am finding extremely useful. I just have one issue with import and hopefully you are able to assist. I have a module that adds option images to each product when selecting different options in color along with a thumbnail next to it. I do however see that the exported file, under worksheet “Options” there is a image header with the path to the actual thumbnail pertaining to my actual options selections.
When I do the initial import, the option pictures dissapear from all imported products and then I have to click browse to link them again to show up on each product. Could it be that the import does not read the header (image) on the options worksheet correctly?
Your response is greatly appreciated!
Regards,
Mario
Hello Mario,
Sorry to hear about the problem with the module. We unfortunately will not be able to fix that module for you. However, let’s go through what’s happening.
My guess at this point is that the import function does NOT include the graphic path. Your best fix for this would be to contact the module author to see if they have a work around that you can apply to the function related to the import process used by OpenCart.
I hope that helps to lead you to your solution! Please let us know if you have any further questions.
Regards,
Arnel C.
Hello Sofia, Make sure that the extension that you had installed is for the same opencart version you are working on and then check whether you had followed all the steps which use to be mentioned in the documentation in the .txt file which presents in the plugin folder. While you download the plugin from the website you will find that text file in that folder or you can find all the steps on that web page too.
Hello Jacob,
Thank you brother … got solution .. was using wrong version of that tool as you mentioned .. Thanks alot for your help and quick response …
Hello Anupam,
No problem, doing a Google search for that error relating to OpenCart it seems to be a common oversight that a lot of people have.
Let us know if you had any further questions at all.
– Jacob
Hello sheenagupta78,
Did you got solution for the problem that you were geeting previously — “Table ‘sitename.product_tag’ doesn’t exist ” ??? As I am getting this error… so i’m stucked .. Please help me ..
Thank you in advance ..
Hello Anupam,
Be sure that you are using the correct version of the Export/Import Tool extension for the version of OpenCart that you’re running. Usually if you start running into problems with the export it can be caused by the different changes that happened to OpenCart and the extension between various versions.
– Jacob
Hello Sir,
Thanks for help. I tried on my laptop and its working. so i think problem on server. I am using shared hosting plan. Can you suggest me some points regarding this problem, so i will ask to my service provider.
Thanks for your help.
With warm regards,
Devdatt
Hello Devdatt,
I spoke with one of our designers who use OpenCart and they said it may be a memory related issue. You may want to ask your host if they can increase the amount of memory your php uses. As your store grows, your export file will get larger using up more memory when attempting the export. They did say that over time, even increasing the php memory will not work.
The designer did suggest another module you may want to consider for the future, though it does cost. It is the Smart Export/Import module.
Kindest Regards,
Scott M
I have copied all files once again. I am using Export/Import Tool for OpenCart 1.5.6.x – 17 version. still same problem.
Hello Devdatt,
In testing with the same version of OpenCart and using the same version of the extension, we are able to import and export without error. The error message you are getting specifically addresses a function in the PHPExcel set of files. This set of files is included with the extension. It seems it can find the files but is not recognizing one of the functions. I have no idea why that would be.
If you haven’t already you may want to try another copy of the extension (same version, just re-download it) to see if that helps.
Kindest Regards,
Scott M
when i am going to export below error occurred.
I am using opencart 1.5.6.4
Parse error: syntax error, unexpected $end in /home/zhampakc/public_html/system/PHPExcel/Classes/PHPExcel/Calculation.php on line 2926
Fatal error: Class ‘PHPExcel_Calculation’ not found in /home/zhampakc/public_html/system/PHPExcel/Classes/PHPExcel.php on line 151
can you help me?
It appears that you may have not either copied all of the correct folders over, or you may have used the incorrect version of the extension. I recommend copying over all of the files again, ensuring that you are using the correct version of the extension.
Is it possible to change the output format of a field to text so the export module will not chop off zeros in the model number and seo keyword fields so excel will play nice
Hello Keith,
Unfortunately, there is no “built-in” way to change the output format, so you would have to have a developer code a solution.
If you have any further questions, feel free to post them below.
Thank you,
-John-Paul
Well.. got it working and I am very pleased. I was going to buy lots of extensions. Now that I’ve got it sorted out, it is very easy to work with. I’ll bet there are lots of tools for these spreadsheets to speed things up even further. I used the KINGSOFT spreadsheet. Just remember to save it as Excel 2007 that worked for me. I am very pleased with InMotion hosting.. you have been first rate, I could not ask for better support. Dunno what the mysterious “text file” thing was though! Where it backed up as a Text file, a SQL file. But all’s well that ends well.
Hello David,
Glad to hear that you were able to get things working now!
– Jacob
WHOA.. I just tried it again..and it backed up as a XLSX. Correct. Wonder what gives? Lemme try to restore it..or better yet, edit it and restore it.
Man…it keeps wanting to back up as a TXT file, a SQL file.
Hello David,
A .sql file is essentially just a .txt file they just have different extension names.
– Jacob
Whoa.. I am using KINGSOFT free spreadsheet.. my Microsoft Excel has issues. Wont let me register ‘cos it says I have registered it too many times. So I dl’d Kingsoft. When I saved it in MS Excel 2007 format- it worked. OpenCart accepted it. It is funny when I backed up a few minutes ago, it saved as a TEXT file.. I will try again just to see what happens. Just tried it.. it did it again! Saved it as a SQL file. This is mysterious. BUT not as MYSTERIOUS as that maddening “Captcha” thingy. That thing is driving me nuts.
Even stranger.. I did another BACKUp. Well..this downloaded as a Text file! So I just turned around and restored it, and voila.. it worked. Except it didnt do anything. DUH..what am I missing?
Hello David,
It sounds during the process of your exporting your OpenCart settings, and then editing them in a Spreadsheet program, that the fields no longer match up with what the server is expecting when you attempt to import the file. It’s important that you maintain the exact same correct format of your previous products for any new products you’re adding.
What spreadsheet editor are you using to make your edits? If you simply export your settings, are you able to import them again without making any adjustments in a spreadsheet editor?
For us to be able to troubleshoot this further, we’d need to take a look at your exported OpenCart file. Please upload this file to your home directory, and then let us know the name of it and we can take a look for you.
– Jacob
I try to restore my file..but get this message:
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘PK’ at line 1
Error No: 1064
I am on reseller hosting with hostgater and get the following when trying to import — any advise ?
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 3145728 bytes) in /home/macnaugh/public_html/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961
Hello Marius,
It looks like your PHP memory_limit setting in your php.ini file is set to 64MB. Which is what the 67108864 bytes exhausted… part of your error is saying.
You should simply be able to increase your memory_limit setting to something higher like 256M in order for OpenCart to have enough memory for it to export everything.
Please let us know if you had any other questions at all.
– Jacob
Hi all,
Can anybody upload a downloadable exported .xlsx file?
I use a 1.5.6.1 opencart, but the php safe mode is active.
So I cannot export:S
I’ve exported a sample .xlsx file for you to use. It is just an export of a default OpenCart installation. You may find it at the following:
OpenCart exported Excel file
Hello Jacob,
Im having the below error. Ive adjusted the memory_limit to 512M, ive also done a recursive php on htaccess. But im still having the same errors.
Please your assistance would be great importance.
Thanks
Fatal error: Out of memory (allocated 417857536) (tried to allocate 72 bytes) in /home3/dayo/public_html/system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123
Hello dayo_b,
From looking at the error you have posted, it looks like your memory_limit is not being successfully set, either because it is not successfully set as recursive, or due to something else. Check to ensure that it is indeed correctly set to recursive and if it is, I recommend contacting technical support as they will be able to make changes within your account for you if needed.
The best solution I found online seems to be this: creating product_tag table below:
Hi.
How can i add new fields to the excel sheet?
I want to add filters to my products using the import extension. It’s almost impossible to do that one by one in opencart. It’s frustrating. How can i add Filters Field to the Excel sheet?
I didn’t find solution on google.
Thank you
Hello rostom,
It appears that we have already answered your question at the following:
Adding fields to import export tool
hi scott,
finally i found the solution … the problems come from the memory exhausted issue… so i follow the steps to increase the memory from 64M to 512M by following the steps here and set it recustive mode https://www.inmotionhosting.com/support/website/php/recursive-php-ini … thank you very much … this website has help me lots and its free
hi scott,
thank you for your reply. But my main problem is when i was exporting the excel file with the extension .xlsx . There is an output for backup_categories_products.xlsx . But when i try to open up the file with Microsoft Excel, it says that the file is corrupt. I have tried clearing the cache but i am still facing the same problem.
Hello designhaus,
The error you are receiving may not have anything to do with your import file. It is working with the CacheBase.php file, which means it may be in the site caching. You may want to clear the OpenCart cache and then try.
The error itself occurs when the program has already started to format output for the screen and then receives header information, this would not really occur when importing a spreadsheet, but may occur when OpenCart is trying to put something on the screen.
Kindest Regards,
Scott M
hi i tried to export but the file is said to be corrupt everytime.. anyone can help me with this
Opened up the error log and the message shown below:-
2014-01-12 16:36:30 – PHP Warning: Cannot modify header information – headers already sent by (output started at /home/dsiqncom/public_html/dsignhaus2013/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/dsiqncom/public_html/dsignhaus2013/dh1611/model/tool/export.php on line 50
Thank you for helping. I have already increased PHP memory limit but i cannot export many data at excel file.
I looks like PHP is trying to use more memory than an allotted in your php.ini file. To fix this issue, increase your PHP memory limit via the following instructions:
Fixing the Allowed memory size exhausted error
Hi jeffMa thank you for helping me to fix my problem. And i have another problem i cannot export file excel and this error appear
“2013-12-05 13:52:06 – PHP Warning: Cannot modify header information – headers already sent by (output started at /home/stylewed/public_html/styleweddingsmy.com/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/stylewed/public_html/domain name/admin/model/tool/export.php on line 50
2013-12-05 13:53:28 – PHP Fatal Error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1048576 bytes) in /home/stylewed/public_html/domain name/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155”
i hope you can help me to fix my problem.
Hello farahh,
It sounds like your Excel file is not in the correct format that OpenCart expects. Withing your Excel file, you will need the required headers over each entry that determines what each field is. Within the readme.txt file inside the extension, you will see an explanation on what each of these are.
Thank you JacoblMH for help me. I have already contacted my server to install ZipArchive and my Excel success to open. But when i wanted import file excel i already edited in opencart, it mentions “Success: you have successfully imported you categories and products!” but the product i add not appear on my website. And Error Logs mention “Export/Import: Invalid header in the Attributes worksheet”.
Do you see anymore specific details when you navigate to System > Error Logs as mentioned?
It’s sounding like the server your website is hosted on does not have the ZipArchive PHP class which comes with the PHP Zip extension.
If you’re hosted with us, please find your server name in cPanel and let us know what it is and we can see about having our system administration team ensuring that is available for you on that server.
– Jacob
Thx jeffMa for your answer, i has download and install Excel viewer but my excel still cannot open. But I find some error in Error Log at opencart. It mentions ” Class ‘ZipArchive’ not found See also ‘System > Error Logs’ for more details.”
do you have any idea about my problem?
.XLSX files are typically not a format in which you would be able to open them up in Word and would require Excel which is also part of the Microsoft Office suite. It is also possible that the file may not be in a compatible format for your version of Excel if you have tried it that way as well. Try the Excel viewer that is provided by Microsoft which may also help.
Hi, i already success installs extension Bulk import/export but when I export files from my opencart my excel sheet cannot open? Has some error appear when I try open excel file… ” Excel cannot open the file’backup_product. xlsx because the file format or file extension is not valid. Verify that the file has not been corrupted and that file extension matches the format of the file.” i used word 2007.
Anyone can help me?
What version of OpenCart are you running, and which version of the OpenCart Export/Import Tool are you running?
When I downloaded opencart-1-5-4-x-export-import-13.zip and took a look at the /system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php file on line 234 there is no mentions of a ZipArchive class. It sounds like possibly you don’t have all of the files uploaded, or have the improper version for your version of OpenCart.
Let us know if you had any other questions.
– Jacob
Followed all instructions in the Bulk Import Export tutorial for opencart. Received the following error after I downloaded the excel file:
Fatal error: Class ‘ZipArchive’ not found in /home/gremilli/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 234
Hello Rozhawk,
I’m sorry to hear that you’re having problems. The white screen is very general – do you get any specific errors? I looked on your account and did not see an Opencart installation. If you have it elsewhere with InMotion can you please provide a URL? It’s difficult to say what’s causing the error, without seeing the files. Check out this post for info on this type of error: blank white pages.
I hope this helps to get you pointed in the right direction. If you can provide more information we would be glad to investigate the issue further.
Regards,
Arnel C.
Hi,
I’m running OC v 1.5.5.1. When I click on the export button I just get taken to a white screen and nothing happens (both in Chrome and IE).
Any suggestions?
Appreciate any help provided!
The System > Export / Import menu option should display even prior to you giving the User Groups permission to it, you’d just get a permission denied message.
It sounds like possibly you might have missed the step about installing vQmod for OpenCart. As prior to uploading the admin, system, and vqmod directories from the opencart-1-5-6-x-export-import-16.zip file, there should already be a vqmod directory on the server.
If you do already have vQmod installed, there might be another issue at hand but it would be a bit hard to guess at what that was without taking a look at the site.
You can let us know what your website is here publicly, or if you’d prefer, you can send an email directly to us at support@inmotionhosting.com asking for more specific help to your website.
– Jacob
Hi,
I’m running OC v1.5.6 and downloaded opencart-1-5-6-x-export-import-16.zip, extracted the files and dropped them as instructed into my root folder using Filezilla. I then selected the ‘tool/export’ options in the Top Administrator section of User Groups in both Access and Modify Permission tables. However once saved down I am not getting the ‘Export/Import’ option appear in the System menu.
Please let me know what you suggest my next step is.
Thanks!
Hello Sheenagupta78,
It appears you’re still trying run an export using existing OpenCart code that do not include the tables that you have added. The problem may be that even you added the table, that you’re still missing some dependencies. If you’re using an an add-on that has created the extra tables, then I would recommend not including it in order to get the bulk of the data exported and then imported into your newer version. You may need to consult with OpenCart (forum.opencart.com – their forums are great for issues like this), on the best way to include the extra data. You may have to rebuild it. OpenCart will only be responsible their tables and structures. If you’re adding something, they will not be aware of it or it’s affect on import export operations. If you’re using an add-on then you should speak with the developer that has caused the extra table to be added. If you have added it yourself, then again, the best thing to do in this case is to simplify and remove the table until you can complete the export or import operations. Then add to the new database. Otherwise, you would be better off consulting with OpenCart directly for the database operations that are not operating correctly.
Apologies that we cannot provide a direct answer for the matter. Please let us know if you still have any further questions.
Regards,
Arnel C.
i created another table product_tag , by using query create table select * , but now error is
Error: Unknown column ‘pt.tag’ in ‘field list’
Error No: 1054
Table ‘sitename.product_tag’ doesn’t exist
should i rename the table product to product_tag
copy the query into your phpmyadmin and make correction what errors there…
i have installed opencart 1.5.5, then opencart1.5.3.x export import 11
i made all changes as specified , changes in 3 files , along with changes in user group
import/export option appeared in system
but in chrome export button didnt gave me any response , and export option in firefox worked but excel file didnt contained any data but gave following error
Notice: Error: Table ‘sitename.product_tag’ doesn’t exist
Error No: 1146
SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR “,” ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR “,” ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR “,” ) AS tags FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT(‘product_id=’,p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id LEFT JOIN `product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in /home/content/30/9520830/html/India2bharat11/system/database/mysql.php on line 50
Hello sheenagupta78,
We are happy to assist you, but we need additional information to provide a specific answer. Please provide specific steps you are taking, and include information such as the full error message and version of OpenCart you are using.
This way we can attempt to replicate the problem that is occurring.
If you have any further questions, feel free to post them below.
Thank you,
-John-Paul
am getting an error sitename.product_tag doesnt exists in excel file , after i downloaded it. although this table exists
Hello Naught,
Thanks for your question. Yes, when you import data into another database, it needs to match the fields, otherwise the import will fail because of the data mismatch. It’s important to note that the field data should match. For example, in OpenCart, the product id is a NUMERICAL value. This means that you cannot use text in the ID.
I hope this clarifies the issue . Please let us know you require any further assistance.
Regards,
Arnel C.
Hey Tim, great article. One question: When you add your new items, ones that aren’t yet in the OpenCart database, do you also add the fields that opencart populates, like _id, time_created, etc?
Hello munafa1,
It sounds like you are having trouble using the import function. We are happy to assist you, but we need more information, such as the exact error you are receiving, what type of browser you are using, what version of OpenCart you are running.
Also, could you provide a the specific steps you are taking, so we can attempt to replicate the issue, such as where you are clicking?
If you have any further questions, feel free to post them below.
Thank you,
-John-Paul
is it import function working properly in in extenstion
Are you sure it’s 30 minutes? I made an edit yesterday and it only just now showed up after I restarted the FTP server.
I just tried restarting the FTP server and that applied the changes made to the php files, BUT further changes don’t take effect unless the server is restarted again.
Is there a server-side cache that’s been enabled that only gets cleared when the FTP restarts?