Magento 2 product import export

1

Magento2Product Import/Export

Benno Lippert cobby.io

2

- Benno Lippert -Founder

“Opportunities are to be found amidst difficulties.“

@bennolippert

Albert Einstein

3

What‘s new?• Import History• Custom Options• Bundles• Downloadable• External images• Image attributes• New format

4

What‘s new?Import History

5

What‘s new?Import History

6

What‘s new?Import History

• Restart import• Log what was changed

Ideas to improve

7

What‘s new?New format

sku _type _attribute_set _product_websites name price description short_description qty …

attr1 attr2 attr3 attr4 attr5 attr6 attr7 attr8 … attr n

Old

+

Newsku store_view_code attribute_set_code product_type categorie

sproduct_websites +74 associated_sku

s

8

What‘s new?New format

• 81 fixed columns• UTF 8• Fielddelimiter ,• Multidimensional |

9

How do I import?Virtuals, Simples, Configurables, Grouped, Bundles, Custom Options,

Images, Productlinks

10

How do I import?Virtuals / Simples

• sku• attribute_set_code• product_type• product_websites• name• price

sku attribute_set_code product_type product_websites name price

a Default virtual base Virtual 1.0000

11

How do I import?Custom Attributes

additional_attributes• attrib_code• value

… additional_attributes …

"color=Green,activity=Gym|Hiking"

12

How do I import?configurables

configurable_variations• sku• superAttribute

… configurable_variations …

“sku=WSH12-28-Green,color=Green,size=28|sku=WSH12-28-Purple,color=Purple,size=28|sku=WSH12-28-Red,color=Red,size=28“

configurable_variations• superAttribute• Label

… configurable_variation_labels …

“color=Color,size=Size”

13

How do I import?configurables

Attention!• If the simple doesn‘t exits NO ERROR• Removing associated simples doesn‘t work• Backendproblem save configurable without simples

14

How do I import?grouped

associated_skus• sku• Default Qty

… associated_skus …

"24-WG085=0.0000,24-WG086=0.0000,24-WG087=0.0000"

Atttention!• If the simple doesn‘t exits NO ERROR• Removing associated simples doesn‘t work

15

How do I import?bundles

bundle_price_typebundle_sku_typebundle_price_viewbundle_weight_typebundle_values• name• type• required• sku• price• default_qty• price_type

… bundle_values …

"name=Sprite Stasis Ball,type=radio,required=1,sku=24-WG081-blue,price=0.0000,default=1,default_qty=1.0000, price_type=fixed|name=Sprite Stasis Ball,type=radio,required=1,sku=24-WG082-blue,price=0.0000,default=0,default_qty=1.0000, price_type=fixed|name=Sprite Stasis Ball,type=radio,required=1,sku=24-WG083-blue,price=0.0000,default=0,default_qty=1.0000, price_type=fixed"

16

How do I import?custom_options

custom_options• name• type• required• sku• price• price_type• option_title

… custom_options …

"name=Group 1,type=drop_down, required=1,price=2.0000,price_type=fixed,sku=2,option_title=two|name=Group 1,type=drop_down, required=1,price=3.0000,price_type=fixed,sku=3,option_title=three"

Beim Export wird aktuell die Gruppenreihenfolge vertauscht

17

How do I import?Images

base_imagebase_image_labelsmall_imagesmall_image_labelthumbnail_imagethumbnail_image_labelswatch_imageswatch_image_label

… []_image []_label …

"http://sub.server.tld/base-image.jpg" “Alt text for Base“

"base-image.jpg" “Alt text for Base“

/pub/media/import

18

How do I import?Images

additional_images additional_image_labelshide_from_product_page

… additional_images additional_labels hide_from_product_page …

"img.jpg,img2.jpg" “Alt1,Alt2“ “img2.jpg“

/pub/media/import

19

How do I import?Images

additional_attributes• attrib_code• Value = Image

… additional_attributes …

"cust_img_attr=http://sub.server.tld/base-image.jpg"

20

How do I import?Images

Attention!• Setting a video as Base Image is impossible• Changing Base Image keep in mind to add it to the

additional images, otherwise it‘s gone

21

How do I import?Productlinks

related_skuscrosssell_skusupsell_skus

… related_skus crosssell_skus upsell_skus …

„sku1,sku2" “sku3,sku4“ “sku5,sku6“

22

How do I import?Tier prices

Separate Format

sku,tier_price_website,"ALL GROUPS",tier_price_customer_group, tier_price_qty,tier_price24-MB01,1,1,0,1.0000,100.000024-MB01,1,1,0,20.0000,90.000024-MB01,2,1,0,1.0000,200.000024-MB01,2,1,0,20.0000,180.0000

23

How do I import?Downloadable

Not working at the moment!

24

What else is not working?

Creation of new attribute optionsEmpty attribute values Only update on of multiple storeviews Video featureRemoving website associationProduct reviewsSuper attribut label feature is goneGroup Prices don‘t exist anymore

Thanks

FINISH