Download & Extend
Ubercart Feed Mappers » Issues

UC cost will not import- general error 1366 incorrect decimal value

Posted by bigmonmulgrew on November 21, 2012 at 10:21pm
Project:Ubercart Feed Mappers
Version:7.x-1.0
Component:Code
Category:bug report
Priority:major
Assigned:Unassigned
Status:active

Issue Summary

Hi all
I will admit I'm a little new to feeds and ubercart but I've been struggling with this for 3 days not trying to work it out and I've given up and decided to mark it as a bug.

The uc cost fiel throws an error
SQLSTATE[HY000]: General error: 1366 Incorrect decimal value: '' for column 'cost' at row 1
when importing

In the has a lot in it but heres the last bit for original item

  'cost_price' => '1485.82',
  'retail_price' => '1745.84',
  'product_code' => 'PCS750217',

Now the last bit for entity,

  'filesize' => 32135,
        'display' => 1,
        'width' => 640,
        'height' => 480,
      ),
    ),
  ),
   'cost' => '',
   'sell_price' => '1745.84',
   'is_new' => true,

Notice cost is empty. I'll admit I don't understand most of the code here but I'm guessing cost should have a value like sell_price does.

If I remove the cost it imports fine (although I've removed a lot of fields while I'm testing)

Any help would be much appreciated

Login or register to post comments

Comments

#1

Posted by edmonkey on January 11, 2013 at 2:43am

any resolve on this issue?

#2

Posted by rlustemberg on March 20, 2013 at 9:49am

II was having the same issue. I was using the JsonPath parser. But when I went to check at the parser settings in the import form (not the parser configuration page), I saw that the fields had not been updated on the form. I put them there manually and then the issue was solved. I guess is a bug in Feeds.