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 ?
Tags (1)
7 REPLIES

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)?

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"

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:

Área de trabajo 1_008.pngSample file for product import

 

 

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

Can you check your file again?

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"

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

 

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"

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)

--
If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"