cancel
Showing results for 
Search instead for 
Did you mean: 

Import Product in Magento ?

Import Product in Magento ?

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 ?
9 REPLIES 9

Re: Import Product in Magento ?

Hi @daniela95,

 

Did you exported the sample file?

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

Re: Import Product in Magento ?

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

Re: Import Product in Magento ?

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 importSample file for product import

 

 

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

Can you check your file again?

Re: Import Product in Magento ?

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

Re: Import Product in Magento ?

Hi @daniela95,

 

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

Values could be:

 

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

 

Re: Import Product in Magento ?

ok what must to do now to fix that error ?

Re: Import Product in Magento ?

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)

Re: Import Product in Magento ?

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?

Re: Import Product in Magento ?

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.