This article is still in a preliminary version, please provide suggestions for improvement and aim any problems with this article towards [email protected]
Prerequisites for using this guide
You have cobby installed on your m1 and m2 store and both are on the same version of cobby, so that you can switch between them in excel as described here.
1. Attributes and Attribute-Sets
1.1 First create all Attribute-Sets you want to use in m2 in your m2-backend. If you plan to condense some sets from m1 this is the perfect time to do so.
1.2 create all the product-attributes you want to use in m2 and add them to the appropriate attribute sets,
1.3 create all the categories you want to use in m2,
1.4 cobby will feature these attributes after the cobby index has been rebuild, to start the index go to Stores -> Settings: Configurations -> Services: cobby and click save config (in m2 this starts the indexing process).
Once you have all the attributes you want in cobby, you can start to prepare the migration. The migration itself will be quite similar to this video if everything is well prepared.
You'll need two things: an import-table for each Attribute-Set containing all products and attributes of that set and a cobby-preset to match the data from your table to your new store.
2. You can create import tables straight from your m1 store:
2.1 load the store in cobby using the default preset, select an attribute-set-sheet, click on one of the headers of the table, press Ctrl-a (your whole table should now be marked, including headers), copy the whole table (Ctrl-c), open a new blank workbook, right-click in the second row and choose Paste Options Paste as Values.
2.2 While everything is still selected, select the Home-Ribbon -> Styles -> Format as Table, tick My Table has headers and click okay.
2.3 Name your Table: Navigate to the Design-Ribbon and under table name enter a short but descriptive name for your table, e.g. shoes_m1
2.4 Name your sheet: right click the sheet handle and click rename, again choose a short but descriptive name, e.g. shoesheet_m1
2.5 Rename your Table-headers: click into the cell A1 and type the following formula ="m1_"&A2 . Then drag the cell on the lower right corner for the whole lenght of the table below it. Afterwards go back to the cell A1, select it and press crtl+shift+right-arrow, this should mark all the formulas you had just created. right click your selection and choose "copy", then right-click on A2 and choose "Paste Options: Values" (its an icon that looks like a clipboard with the Numbers 123 on it). You can then delete the contents of row 1 (do not delete the row itself, just the contents).
2.6 save this workbook locally, but don't close it yet.
2.7 click on the cobby-ribbon and choose settings and select your m2 store, then close all instances of Excel, afterwards reopen your saved workbook.
2.8 Now click on the lower part of the load products button in the cobby-Ribbon and set the preset to default, then click on Start importmode.
3 Preparing a preset to match the data from your import table
3.1 navigate to your saved import sheet and remove all but the first product from the table (don't save the sheet in this state), click anywhere in the table and then click Split to Attribute Sets in the cobby-Ribbon.
3.2 A message will let you know that cobby needs an additional column to assign this product to a set and that the column has automatically been added at the right side of your table. Now all you have to do is enter the name of the attribute set you want this product to appear in. Afterwards click Split to Attribute Sets once more.
3.3 You can now switch to the appropriate attribute set sheet, notice that yellow columns have been added to the right side of the table with your product data in them. Now we can begin building the preset. In the next step we will enter a formula in each field that you want to transfer to m2.
3.4 Start as if you would create a new product: click on the drop-down-button of the cell in b3 and select All Store Views. For SKU you enter a formula that simply points to the m1_SKU cell at the end of the table. So the Formula for SKU looks like this: =[m1_SKU]. Proceed like this for all other product-attributes that you want to bring over from m1 without changes.
For some attributes you might not want to directly match them up, or direct matching is nearly impossible, e.g. when the category structure has changed for your m2 shop. For any case like this we can work with matching tables.
3.5 Once we have matched up all required cells and all cells we want to take with us to m2, we remove the product-data from the yellow columns. Select the first yellow column from the left, then hold Ctrl+Shift and press right arrow until you have reached the right end of the table. Then press DEL to delete the product data.
Now we can save our work as a preset in cobby. Just click on the lower part of the Load products-button, then preset and then save. Give the preset a short but descriptive name, e.g. Migration m1-shoes to m2-footwear #1.
3.6 You can now close excel and open your saved workbook from earlier, double-check that your preset is selected in the cobby-ribbon, start the import mode, click anywhere in the m1_table and "split to attribute set" and moments later you have all the products from that table in the respective sheet in cobby.
3.7 If everything looks well, hit "Save Products". You have now successfully migrated one attribute-set to m2.
4. Repeat the second and third steps for every Attribute Set in m1 and you are done.