Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Magmi Column Mapper error
 
CoolThinker
Jr. Member
 
Avatar
Total Posts:  9
Joined:  2009-03-08
 

Hello,

I am successfully using Magmi for a while now, recently when trying for the first time to update Stock (**qty** field) in Magento 1.8 I came across an issue and haven’t been able to resolve… not sure what I am missing here…

Here’s the scenario:

I recieve a .CSV with ONE column of data (no header), the rows are sku numbers:

0001
0002
0003
0004
0005
0006
0007

these skus are supposed to be the OOS update… and so I setup MAGMI to:

> Assign a header called “sku” for the ONLY existing column:
>
> > On Column mapper v0.0.3
> > - Mapped columns list = A
> > - New name for col A = sku
>
> Add 2 more columns (qty and is_in_stock) both with values = 0
>
> > On Value Replacer v0.0.8a
> > - Replaced attributes = qty,is_in_stock
> > - New value for qty = 0
> > - New value for is_in_stock = 0
>
> Other general settings for the local CSV are
>
> > - CSV separator: (,) CSV Enclosure: (")
> > - [checked] Headerless CSV (Use Column Mapper Plugin to set processable column names)

my hope is to have the CSV looking like this before MAGMI runs the update:

sku qty is_in_stock
0001 0 0
0002 0 0
0003 0 0
0004 0 0

And here’s the errors I see when I run the update:

No sku info found for record #1
No sku info found for record #2
No sku info found for record #3
No sku info found for record #4
No sku info found for record #5
No sku info found for record #6
No sku info found for record #7

Skus imported KO:7/7

When I manually build the CSV with the headers and rows the Upload works correctly. What am I doing wrong??

Thanks in advance!!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top