Import Product in Magento ?

[daniela95]

Hello everyone

I start webshop and try import product via xml but see this error message 

Import / Import/Export / Data Transfer / System / Magento Admin

Validation Results

We can't find required columns: sku.

Column names: "RRP Price", "age group", "Parent Qty", "Stock", "Warehouse_location" are invalid

i create this column and disable sku but see again this message can help me ?

[Damian Culotta]

Hi @daniela95,

Did you exported the sample file?

Can you share the file you've used (at least with a few products)?

[daniela95]

id,title,description,link,price,RRP Price,google_product_category,product_type,image_link,condition,availability,shipping_weight,gender,age group,color,size,mpn,brand,shipping,composition,category,quantity,Parent Qty,Stock,item_group_id,Warehouse_location
18-B5-SOR405,Cami With Chain Fringes,Cami With Chain Fringes. This style has a regular fit Adjustable straps,https://website.com/cami-with-chain-fringes.html?fee=4&fep=11489,4.5,10.9900,Clothing & Accessories > Clothing > Shirts & Tops,Clothing > Tops,,New,in stock,0.3000kg,unisex,Adult,Grey,8,18-B5-SOR405-Grey-UK 8,,,100% mix fibres,Top,7,0,1,18,R-BOX11
S-1-LTBWI7724,Platform Heel Loafers,Platform Heel Loafers. This style has been designed with a suede look and faux leather contrast trimmings.,https://website.com/platform-heel-loafers.html?fee=4&fep=12116,2,14.9900,Clothing & Accessories > Shoes,Footwear > High Heels,,New,in stock,0.5000kg,unisex,Adult,Black,UK3-EU36,S-1-LTBWI7724-Black-UK 3 - EU 36,,,100% mix fibres,Footwear,13,0,1,0,S-1
S-1-LTBWI7724,Platform Heel Loafers,Platform Heel Loafers. This style has been designed with a suede look and faux leather contrast trimmings.,https://website.com/platform-heel-loafers.html?fee=4&fep=12116,2,14.9900,Clothing & Accessories > Shoes,Footwear > High Heels,,New,in stock,0.5000kg,unisex,Adult,Blue,UK3-EU36,S-1-LTBWI7724-Blue-UK 3 - EU 36,,,100% mix fibres,Footwear,3,0,1,0,S-1
S-1-LTBWI7724,Platform Heel Loafers,Platform Heel Loafers. This style has been designed with a suede look and faux leather contrast trimmings.,https://website.com/platform-heel-loafers.html?fee=4&fep=12116,2,14.9900,Clothing & Accessories > Shoes,Footwear > High Heels,,New,in stock,0.5000kg,unisex,Adult,Red,UK3-EU36,S-1-LTBWI7724-Red-UK 3 - EU 36,,,100% mix fibres,Footwear,1,0,1,0,S-1
S-11A-AF5431-3,Faux Suede Court Shoe With Bow,Faux Suede Court Shoe With Bow Please be aware that some of the shoes will come without boxes,https://website.com/faux-suede-court-shoe-with-bow.html?fee=4&fep=12179,2,14.9900,Clothing & Accessories > Shoes,Footwear > High Heels,,New,in stock,0.5000kg,unisex,Adult,Blue,UK2-EU35,S-11A-AF5431-3-Blue-UK 2 - EU 35,,,100% mix fibres,Footwear,4,0,1,0,S-0A
S-11A-AF5431-3,Faux Suede Court Shoe With Bow,Faux Suede Court Shoe With Bow Please be aware that some of the shoes will come without boxes,https://website.com/faux-suede-court-shoe-with-bow.html?fee=4&fep=12179,2,14.9900,Clothing & Accessories > Shoes,Footwear > High Heels,,New,in stock,0.5000kg,unisex,Adult,Pink,UK2-EU35,S-11A-AF5431-3-Pink-UK 2 - EU 35,,,100% mix fibres,Footwear,1,0,1,0,S-0A

i change id in csv with sku but see another error

Data validation failed. Please fix the following errors and upload the file again.

 Following Error(s) has been occurred during importing process:

Only the first 100 errors are shown. Download Full Report

1. Product Type is invalid or not supported in row(s): 1, 2, 3, 4, 5, 6, 7, 8, 9......

Checked rows: 5043, checked entities: 5043, invalid rows: 5043, total errors: 5043

[Damian Culotta]

Hi @daniela95,

The error says:

1. Product Type is invalid or not supported in row(s): 1, 2, 3, 4, 5, 6, 7, 8, 9.....

I've created a file with your data and I've checked the product_type column and this is what I've got:

Sample file for product import

It seems you have some issue with columns or value separators.

Can you check your file again?

[daniela95]

i check now i admin panel product attributes and dont see product type can be that problem ?

[Damian Culotta]

Hi @daniela95,

You won't see that attribute in the same way the other attributes.

Values could be:

• simple
• virtual
• grouped
• configurable
• downloadble
• bundle

[daniela95]

ok what must to do now to fix that error ?

[Damian Culotta]

Hi @daniela95,

I don't know which type of products are you trying to create (I gues is simple type).

Use type on that column but laso be sure that the values are ok (that field separator is correct)

[shoesgraph109d]

I also want to know. I have a website on woocomemernce and I want to migrate on Magento now. I want to import all 200 products of the shoe from shoes graph website. Can you guide me?

[Damian Culotta]

Hi @shoesgraph109d,

I don't have enough experience with WooCommerce so I'm not sure which export options do you have right now.

Maybe if you can export the products data and then try to build a file similar to the one described before you'll be able to try to imort your catalog.