Post on 06-Jan-2017
transcript
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