For eg. i want to update stock for 20 product where option name is size and new stock will be 6 products instead of 2 or whatever stock is in that moment on the store.
Thanks.
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Duplicate entry '164-0' for key 'PRIMARY'<br />Error No: 1062<br />INSERT INTO kg_product_to_category SET product_id = '164', category_id = '0'' in /home/kickeu/public_html/kickgame.uk/system/database/mysqli.php:41 Stack trace: #0 /home/kickeu/public_html/kickgame.uk/vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('INSERT INTO kg_...') #1 /home/kickeu/public_html/kickgame.uk/vqmod/vqcache/vq2-admin_model_catalog_product.php(783): DB->query('INSERT INTO kg_...') #2 /home/kickeu/public_html/kickgame.uk/vqmod/vqcache/vq2-admin_controller_catalog_product.php(84): ModelCatalogProduct->editProduct('164', Array) #3 [internal function]: ControllerCatalogProduct->update() #4 /home/kickeu/public_html/kickgame.uk/vqmod/vqcache/vq2-system_engine_front.php(74): call_user_func_array(Array, Array) #5 /home/kickeu/public_html/kickgame.uk/vqmod/vqcache/vq2-system_engine_front.php(60): Front->execute(Object(Action)) #6 /home/kickeu/public_html/kickgame.uk/ad in/home/kickeu/public_html/kickgame.uk/system/database/mysqli.php on line 41
First of all, thank you very much for creating the multi language support import/export module. Brilliant work!
I searched the topic and found a previous questions regarding the SEO column. We would like to import/export this also based on the multiple languages. Can this be supported or otherwise obtained?
Thanks!
Bink Fournituren
BinkFour wrote:Hi JNeuhoff,
First of all, thank you very much for creating the multi language support import/export module. Brilliant work!
I searched the topic and found a previous questions regarding the SEO column. We would like to import/export this also based on the multiple languages. Can this be supported or otherwise obtained?
Thanks!
Bink Fournituren
Yes, I can write a customisation (as a VQmod XML file) to support multilingual url aliases. Send me a PM with the exact details of your DB changes done to support multi-lingual SEO. I assume it's just an added 'language_id' column to the 'url_alias' DB table?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Those modifications you did for me are working really well
However, I just upgraded to 2.18 and noticed that my footer text has gone. It is still there in the footer.php file so no idea what to do.
http://www.theambercat.co.uk/store/
I am not sure I understand what you mean. Send me a PM with the exact details of what isn't working, and your OpenCart + FTP login details, and I can take a look at it.TAC wrote:Hi JNeuhoff ,
Those modifications you did for me are working really well
However, I just upgraded to 2.18 and noticed that my footer text has gone. It is still there in the footer.php file so no idea what to do.
http://www.theambercat.co.uk/store/
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have a problem I cannot resolve after extensive searching and testing.
since installing this tool, products I upload show on my site at a reduced price to the price I have uploaded.
sounds strange.
the import spreadsheet shows the correct price, and when I view the product in opencart admin it displays correctly - but not on my site. there must be a blanket discount or price reduction of 12.5% somewhere in the background I cannot find.
I have no tax classes or rates that equal this figure.
please note - it was perfectly fine prior to installing and amending the core files for this tool - I have re-checked the core files I changed, and triple checked tax classes etc etc
I'm at a loss - is this something you know of? thanks
for some reason, pricing was being overridden and converted to another currency rate - I only found this out after I deleted the other currencies sitting in the background.
is there somebody who can help me importing new products to my opencart shop.
I installed the plugin and tried to upload excel file but somehow the system does not work and show me this message:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 97524177 bytes) in /home/hyrsbgz2/public_html/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 327
Is there somebody who can help me with this?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I updated the memory to 512M and fixed the .htacces file. Also consulted with my hosting support team - Nothing.
the system still showing me pretty the same error, this time I need more 64 bytes. I have tried a couple of times and the needed bytes rising from 64 to 71 now.
Please, advise me something. Should I change the the extension that i have instaled ? I am with opencart 1.5.6 and installed the extension that is called >> opencart-1-5-6-x-export-import-1-18
Please use the Export/Import tool V2.19, that allows allows export and import in smaller batches, thus avoiding memory issues.I am with opencart 1.5.6 and installed the extension that is called >> opencart-1-5-6-x-export-import-1-18
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
So I think maybe it;s not the picture size problem.But just in case, I still changed all the pictures in Photoshop reducing to 500*500 pixels. Still cannot work. I can manually upload these pictures one by one without the export/import tool, so there's no problem with the pictures. Could anyone help this issue out?
Your product images are usually in the 'image/data' folder, and you need to specify your images as something like 'data/my-image-name.png'. Also, your product images are way too big with 2000*2000 pixel resolution! This will only slow down your server unnecessarily!yang8510 wrote:Hi, I uploaded 900 image files (most are under 500KB, up to 2000*2000 pixel) by FTP, to the path of image/catalog/demo/. and I pointed to the same path in the import excel file. But after I imported the excel file, I found only several pictures are showed in the store successfully. Some of the successful one are over 1M, 2000*2000, and some are under 100KB, 200*200.
So I think maybe it;s not the picture size problem.But just in case, I still changed all the pictures in Photoshop reducing to 500*500 pixels. Still cannot work. I can manually upload these pictures one by one without the export/import tool, so there's no problem with the pictures. Could anyone help this issue out?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have new problem and i cant remove it alone.
In database, i have customized options - sku for options.
They are in product_option_value.
I try to add info in admin/model/tool/export_import.php for new option values in
Code: Select all
function storeProductOptionValueIntoDatabase
Code: Select all
// load the worksheet cells and store them to the database
Can you help me?
Thanks in advance!
2014-12-10 11:37:05 - PHP Warning: set_time_limit(): Cannot set time limit in safe mode in /home/hameloni/domains/hamelon.ir/public_html/admin/model/tool/export_import.php on line 4927
2014-12-10 11:37:05 - PHP Warning: realpath(): SAFE MODE Restriction in effect. The script whose uid is 574 is not allowed to access /tmp owned by uid 0 in /home/hameloni/domains/hamelon.ir/public_html/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 175
2014-12-10 11:37:05 - PHP Warning: tempnam(): Unable to access in /home/hameloni/domains/hamelon.ir/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 197
2014-12-10 11:37:05 - PHP Warning: ZipArchive::open(): Unable to access php://output in /home/hameloni/domains/hamelon.ir/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 239
2014-12-10 11:37:05 - PHP Warning: ZipArchive::open(): Unable to access php://output in /home/hameloni/domains/hamelon.ir/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 240
2014-12-10 11:37:05 - PHP PHPExcel_Writer_Exception: Could not open php://output for writing. in /home/hameloni/domains/hamelon.ir/public_html/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 241
In file admin/model/tool/export_import.php, modify the following methods:Ma57eR wrote: In database, i have customized options - sku for options.
They are in product_option_value.
storeProductOptionValueIntoDatabase
uploadProductOptionValues
validateProductOptionValues
getProductOptionValues
populateProductOptionValuesWorksheet
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 27 guests