snakemouse

can anybody help me out.. i am stuck

so the price is "23.9" and the other elements if you need.

ID Active (0/1) Image_URLs_(x,y,z...) NAME category Price tax excluded or Price tax included Quantity Minimal quantity Available for order (0 = No, 1 = Yes) Show price (0 = No, 1 = Yes) 800 1 http://tilemarket.com.au/img/image/VENUS_CHARCOAL.jpg VENUS CHARCOAL LAPPATTO 300X300 7,8,10,14 23.9 1 1 0 1

Hi Guys, it has been a week that i was struggling to fix this error. all of a sudden, prestashop seems like skipping some of the products during csv importing and i extracted all the skipped data and it was showing me up an error as below. VENUS CHARCOAL LAPPATTO 300X300 (ID: 800) cannot be saved Property Product->price is not valid VENUS CHARCOAL LAPPATTO 300X600 (ID: 801) cannot be saved VENUS CHARCOAL LAPPATTO 600X600 (ID: 802) cannot be saved VENUS CHARCOAL MATT 300X300 (ID: 803) cannot be saved VENUS CHARCOAL MATT 300X600 (ID: 804) cannot be saved VENUS CHARCOAL MATT 600X600 (ID: 805) cannot be saved VENUS GREY GRIP 300X300 (ID: 806) cannot be saved VENUS GREY GRIP 300X600 (ID: 807) cannot be saved i got no clue to fix it seriously, i tried to spread it less than 10 items, less columns and was not working. but once i delete the price column it works! anybody has same experience or solution? please let me know, thank you

+ delete default languages except English.

Hi, I get 500 server error when i import products in csv. it's about 400 items with img urls. i tried include / exclud img urls, break up less than 100 items, adding up codes on .htaccess to maximize running time. but was not working. and i had a look up the error log saying all the category - subcategories are not existing. please give me a hand.. [Mon May 22 15:46:21 2017] [error] [client 40.77.167.43] File does not exist: /home/tilemark/public_html/porcelain-tiles [Mon May 22 15:45:20 2017] [error] [client 66.249.64.37] File does not exist: /home/tilemark/public_html/954-home_default_2x [Mon May 22 15:44:45 2017] [error] [client 66.249.64.37] File does not exist: /home/tilemark/public_html/4-tiles [Mon May 22 15:41:17 2017] [error] [client 66.249.64.31] File does not exist: /home/tilemark/public_html/913-home_default_2x [Mon May 22 15:40:14 2017] [error] [client 40.77.167.43] File does not exist: /home/tilemark/public_html/adhesive [Mon May 22 15:39:53 2017] [error] [client 40.77.167.117] File does not exist: /home/tilemark/public_html/tools-adhesive [Mon May 22 15:39:32 2017] [error] [client 157.55.39.178] File does not exist: /home/tilemark/public_html/tools-adhesive [Mon May 22 15:38:40 2017] [error] [client 46.229.164.99] File does not exist: /home/tilemark/public_html/robots.txt [Mon May 22 15:38:35 2017] [error] [client 220.181.108.178] File does not exist: /home/tilemark/public_html/233-home_default [Mon May 22 15:37:19 2017] [error] [client 66.249.64.34] File does not exist: /home/tilemark/public_html/922-home_default_2x [Mon May 22 15:34:46 2017] [error] [client 157.55.39.178] File does not exist: /home/tilemark/public_html/search [Mon May 22 15:34:36 2017] [error] [client 157.55.39.178] File does not exist: /home/tilemark/public_html/32-polished [Mon May 22 15:33:19 2017] [error] [client 66.249.64.31] File does not exist: /home/tilemark/public_html/901-home_default_2x [Mon May 22 15:32:33 2017] [error] [client 40.77.167.43] File does not exist: /home/tilemark/public_html/adhesive [Mon May 22 15:29:16 2017] [error] [client 66.249.64.34] File does not exist: /home/tilemark/public_html/754-big_default [Mon May 22 15:28:01 2017] [error] [client 66.249.64.37] File does not exist: /home/tilemark/public_html/mosaic [Mon May 22 15:27:24 2017] [error] [client 40.77.167.117] File does not exist: /home/tilemark/public_html/porcelain-tiles [Mon May 22 15:26:52 2017] [error] [client 157.55.39.253] File does not exist: /home/tilemark/public_html/porcelain-tiles [Mon May 22 15:25:18 2017] [error] [client 66.249.64.37] File does not exist: /home/tilemark/public_html/882-home_default_2x [Mon May 22 15:25:00 2017] [error] [client 217.182.132.62] File does not exist: /home/tilemark/public_html/search [Mon May 22 15:22:59 2017] [error] [client 157.55.39.253] File does not exist: /home/tilemark/public_html/primer [Mon May 22 15:22:34 2017] [error] [client 157.55.39.253] File does not exist: /home/tilemark/public_html/tools-adhesive [Mon May 22 15:21:15 2017] [error] [client 66.249.64.34] File does not exist: /home/tilemark/public_html/980-home_default_2x [Mon May 22 15:19:24 2017] [error] [client 66.249.64.31] File does not exist: /home/tilemark/public_html/adhesive

Yeap all good, i reset it and solved Thank you

Hi, i was struggling to import products csv but somehow the website has got database exceptions.. Anybody can help me to get through this? i am really new in this field i am able to access to back office (1.6.014) [PrestaShopDatabaseException]Unknown column 'link_color' in 'where clause' SELECT * FROM `mtm_st_mega_menu` WHERE (`txt_color`!="" || `link_color`!="" || `txt_color_over`!="" || `bg_color`!="" || `bg_color_over`!="" || `tab_content_bg`!="" || `bg_image`!="" || `bg_margin_bottom`!="" || `cate_label_color`!="" || `cate_label_bg`!="") AND `active`=1 at line 646 in file classes/db/Db.php 641. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 642. } 643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 644. { 645. if ($sql) 646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 647. throw new PrestaShopDatabaseException($this->getMsgError()); 648. } 649. } 650. 651. /** DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 297 - modules/stmegamenu/StMegaMenuClass.php] - [1 Arguments] StMegaMenuClass::getCustomCss - [line 3580 - modules/stmegamenu/stmegamenu.php] StMegaMenu->hookDisplayHeader - [line 510 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 456 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->initContent - [line 11 - override/classes/controller/FrontController.php] FrontController->initContent - [line 37 - controllers/front/IndexController.php] IndexControllerCore->initContent - [line 15 - override/controllers/front/IndexController.php] IndexController->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php]