Preparing Data for Import

Seller Buyer Web iOS Android

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.

  • Code
  • Name
  • Category
  • Category 1 (For Data Import Only)
  • Category 2 (For Data Import Only)
  • Product ID
  • SKU
  • Variant
  • Short Description
  • Size
  • Ordering Unit
  • Minimum Order Quantity
  • Order Multiple
  • Packing
  • HSN Code
  • Warranty
  • Stock Status
  • Price (Price 1 to Price 25 for supporting 25 different prices)
  • Notes
  • Warehouses
  • Tax Tier
  • Visibility Tier
  • Search Tags (comma separated)

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.

One Product Code - One Size Only

This options is plain & simple. You need to create a row for every product code and fill in all the rows.

  • Way2Order App : Seamless B2B Ordering Platform

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.

One Product Code - Multiple Sizes

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

  • Way2Order App : Seamless B2B Ordering Platform

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.

  • Way2Order App : Seamless B2B Ordering Platform

And finally your excel file will look like the screenshot below

  • Way2Order App : Seamless B2B Ordering Platform

You are now ready to import this Excel file.

Send Message via WhatsApp

+91 94645 00320

Weekdays 10:00 am to 6:00 pm (IST)

Start WhatsApp Chat Start WhatsApp Chat