Anyone able to shed some light on this... EP4 reporting the following even though 'specials price' is LOWER than 'normal price'.
(my debugging info preceding the standard error message is included in sample output below, e.g., s_price: 6.7270 p_price: 14.1363, where s_price = 'specials_price' and p_price = 'products_price')
I've tried numerous things but just cannot understand why this is occurring for the handful of products above out of a few hundred in the original upload file.Code:s_price: 6.7270 p_price: 14.1363SKIPPED! - Model: EKFBASUSCH3AN - specials price higher than normal price... s_price: 90.0000 p_price: 115.5000SKIPPED! - Model: EKFBASUSCH3WAN - specials price higher than normal price... s_price: 90.0000 p_price: 127.9545SKIPPED! - Model: EKFBKITGAX58UD7AN - specials price higher than normal price... s_price: 90.0000 p_price: 139.1363SKIPPED! - Model: EKFC260275285GTXGWN - specials price higher than normal price... s_price: 80.0000 p_price: 109.8181SKIPPED! - Model: EKFC285GTXA - specials price higher than normal price... s_price: 77.3520 p_price: 104.7272SKIPPED! - Model: EKFC295GTX1PCBBackAN - specials price higher than normal price... s_price: 50.0000 p_price: 123.0454SKIPPED! - Model: EKFC4890CFAN - specials price higher than normal price... s_price: 80.0000 p_price: 117.4545SKIPPED! - Model: EKFC4890SAPPHIREPCBAN - specials price higher than normal price... s_price: 80.0000 p_price: 107.6818SKIPPED! - Model: EKFC5870V2AN - specials price higher than normal price... s_price: 90.0000 p_price: 108.1363SKIPPED! - Model: EKFC9800GX2SLIN - specials price higher than normal price... s_price: 80.0000 p_price: 163.1818SKIPPED! - Model: EKFCR600CFA - specials price higher than normal price... s_price: 35.3180 p_price: 143.4545SKIPPED! - Model: EKFCR600CFXA - specials price higher than normal price... s_price: 40.3520 p_price: 163.8636SKIPPED! - Model: EKMMSUPHFINTELN - specials price higher than normal price... s_price: 8.5000 p_price: 10.3181SKIPPED! - Model: EKMOS680i1 - specials price higher than normal price... s_price: 9.0910 p_price: 36.3636SKIPPED! - Model: EKMOS680i2 - specials price higher than normal price... s_price: 9.0910 p_price: 36.3636SKIPPED! - Model: EKMOS680i2A - specials price higher than normal price... s_price: 9.0910 p_price: 36.3636SKIPPED! - Model: EKFBKITGAP67AUD7AN - specials price higher than normal price... s_price: 90.0000 p_price: 155.0909SKIPPED! - Model: EKFC5850AEN - specials price higher than normal price... s_price: 99.9000 p_price: 112.6818SKIPPED! - Model: EKFC5870AEN - specials price higher than normal price... s_price: 99.9410 p_price: 124.5454SKIPPED! - Model: EKFC5870PEN - specials price higher than normal price... s_price: 95.8500 p_price: 108.1363SKIPPED! - Model: EKSUPHFFEN - specials price higher than normal price... s_price: 79.1270 p_price: 104.5000SKIPPED! - Model: EKFC570GTXSEPEN - specials price higher than normal price...
Example of header and first data record in the file (only records that error are included in the current test file):
I am using Excel and encoding in UTF-8 via Notepad++ to ensure the descriptions are not compromised and many other similar records with specials in the original file are being processed as expected. I just can't see a pattern or work out why it is falling over on these.Code:v_products_model,v_products_type,v_products_image,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_product_is_call,v_products_sort_order,v_products_quantity_order_min,v_products_quantity_order_units,v_products_priced_by_attribute,v_product_is_always_free_shipping,v_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_tax_class_title,v_status EKALUFC4870KITV2,1,ek/EKALUFC4870KITV2.jpg,ALU - FC4870 KIT V2,"<p class=""prodname"">EK-ALU-4870 Kit V2</p><br /><p class=""prodname2"">ALU replacement part for EK-FC4850/4870 water blocks</p><br /><p class=""proddesc"">With the ALU replacement part you can make all your EK-FC4850/4870 compatible with (Club 3D) non-reference Radeon HD 4870 graphic cards</p><br /><p class=""prodinc""><b>Enclosed:</b><br>- ALU Part<br>- Mounting screws<br>- Thermal pad</p><p class=""prodname2"">EKWB EAN: 3830046993670</p><div><p align=""center""><a title=""Check Compatibility list for this product"" target=""_blank"" href=""http://www.coolingconfigurator.com/waterblock/3830046993670""><img src=""/store/images/ek_compat.gif""> </a><a target=""_blank"" href=""http://www.ekwaterblocks.com/shop/EK-IM/EK-IM-3830046993670.pdf""><img src=""/store/images/ek_install_man.gif""> </a><a target=""_blank"" href=""http://www.ekwaterblocks.com/shop/EK-PSS/EK-PSS-3830046993670.pdf""><img src=""/store/images/ek_prod_spec.gif""></a><br /><a target=""_blank"" href=""http://www.ekwaterblocks.com/shop/catalogsearch/result/?q=3830046993670""><font face=""MS Reference Sans Serif"" size=""2"" color=""#f88c18""><strong>Search EKWB shop for 3830046993670</strong></font></a></p></div>",www.ekwb.com/shop/alu-fc4870-kit-v2.html, 6.7270 ,2013-01-01,2020-02-02,14.1363,0,0,1,1,0,0,,2009-12-02,4 ,EK Water Blocks,Water Cooling^Blocks^VGA-Full Cover,GST,1I've been testing this extensively before posting.
Would appreciate any assistance.
Cheers
GAM


I've been testing this extensively before posting.
Reply With Quote
