322: Using the Bulk Export/ Import Extension in OpenCart 1.5

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. 

  1. Log into the OpenCart Dashboard
  2. Go to System > Export/ Import
  3. opencart_import_1

  4. Click “Export” to download an Excel spreadsheet of your current products
  5. opencart_import_2

  6. Open the spreadsheet with the appropriate software such as Open Office or Microsoft Excel
  7. opencart_import_3

    Notice at the bottom of the spreadsheet, there is 7 separate sheets to work with (categories, products, options, attributes, specials, discounts, and rewards)

  8. 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
  9. Now, go back to your OpenCart dashboard to: System Export/ Import
  10. Choose the file you just saved on your local computer by clicking the “Choose File” button next to “Import from spreadsheet file:
  11. Once you save selected a file, click “Import
  12. opencart_import_4

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.

opencart_import_5

If you need further assistance please feel free to ask a question on our support center.

Thoughts on “322: Using the Bulk Export/ Import Extension in OpenCart 1.5

  • 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

  • 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

  • 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

  • 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.

    • 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.

    • 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

  • 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,’http://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,’http://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

    • 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

    • 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: http://store-manager-for-opencart-documentation.emagicone.com/products-management/import-products

     

    and this is for export: http://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 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

  • 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 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.

      • You noted that your module adds option images to products that are in the database in OpenCart
      • The exported file under worksheet options includes a path to the actual thumbnail
      • However, AFTER importing the file, the image disappears, and you have to go back in and link it again

      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.

  • 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.

    • 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

     

  • 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:

    CREATE TABLE `product_tag` (
      `product_tag_id` int(11) NOT NULL AUTO_INCREMENT,
      `product_id` int(11) NOT NULL,
      `language_id` int(11) NOT NULL,
      `tag` varchar(32) COLLATE utf8_bin NOT NULL,
      PRIMARY KEY (`product_tag_id`),
      KEY `product_id` (`product_id`),
      KEY `language_id` (`language_id`),
      KEY `tag` (`tag`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

  •  

    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

Leave a Reply