Hey everyone,

I tried importing a test csv, file with one product listed on the excel sheet, onto my ubercart website, but kept receiving this error. Bellow is my log file for this error I keep having. Any thoughts?

SQLSTATE[HY000]: General error: 1366 Incorrect decimal value: '' for column 'list_price' at row 1
Original item

array(
'product name' => 'Carbon Fiber Cigar Holder',
'description' => 'Cigar holder that is made from 100% carbon fiber. Can fit upto 10 Cigars',
'image' => 'public://Natural Carbon FIber Cigar Holder.jpg',
'product type' => 'Cigar Holder',
'sku' => '123',
'list price' => '$0.00',
'cost' => '$0.00',
'sell price' => '$100.00',
'weight' => '1',
'weight unit' => 'lb',
'red color price' => '$0.00',
'natural color price' => '$100.00',
'blue color price' => '$0.00',
)
Entity

(object) array(
'type' => 'product',
'changed' => 1438037125,
'created' => 1438037125,
'language' => 'und',
'is_new' => TRUE,
'status' => 1,
'promote' => 0,
'sticky' => 0,
'uid' => '1',
'revision' => FALSE,
'length' => 0,
'width' => 0,
'height' => 0,
'length_units' => 'in',
'pkg_qty' => 1,
'default_qty' => 1,
'shippable' => 1,
'ordering' => 0,
'comment' => '1',
'log' => 'Created by FeedsNodeProcessor',
'title' => 'Carbon Fiber Cigar Holder',
'timestamp' => 1438037125,
'nid' => '29',
'tnid' => 0,
'translate' => 0,
'vid' => '29',
)
error
2015-07-27 18:45:25 2015-07-27 18:45:25 Failed importing 1 content.

Regards,
RomReactor

Comments

MegaChriz’s picture

Assigned: romreactor » Unassigned
Category: Bug report » Support request
Status: Active » Fixed

Remove the dollar sign from the prices. You can either change this in the source file or by using Feeds Tamper's "Find replace" plugin.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.