By importing excel data, you can quickly & easily set up your 'Seller' account & create your private product catalog. Only the following attributes can be imported using the Excel import feature.
There are 2 options while importing data. First, when your products do not have any variations i.e. one product code is linked with only one size. The second option is when your products have multiple variations i.e. one product code is linked with multiple sizes.
Way2Order encourages you to download the Excel Template & use that template to import data.
This options is plain & simple. You need to create a row for every product code and fill in all the rows.
You can use any spreadsheet program and then export your data to Excel format (.xls or .xlsx). The above screenshot is from Apple Numbers. You can use Microsoft Excel or Google Sheets also.
This option includes one additional step. You create your excel file the same way & create a row for every size. Your spreadsheet will look like the screenshot below
Now we need to fill in every row so that the Way2Order App does not give us any error while importing this excel file. So to do that we start to fill in the blank rows.
Copy the rows which are common for all sizes like the Code, Name, Category & Category1 in our example.
And finally your excel file will look like the screenshot below
You are now ready to import this Excel file.