Microsoft Excel, Apple Numbers, Google Sheets, or Apache OpenOffice are recommended. When opening the template in these programs, be sure to select comma separated if prompted in a box similar to the image below (Apache OpenOffice shown here).
Enter products into the spreadsheet according to the information in the relevant article below.
If importing basic items, visit the Bulk Manage: Inventory Imports article for help. If importing items with variants, visit this Bulk Management article instead.
Follow the relevant section below to learn how to save your completed spreadsheet based on the spreadsheet software you are using. All steps are the same whether you have a Mac or PC.
After saving the spreadsheet, follow the steps here to import it to BackOffice using Bulk Management.
Microsoft Excel
Save your spreadsheet in .csv format when using Excel.
Click 'File', then 'Save As'.
Click the 'File Format' dropdown and select 'Comma Separated Values (.csv)', then 'Save'.
Click to Enlarge
Apple Numbers
Save your spreadsheet in .csv format when using Numbers on a Mac.
Click ‘File’, then select ‘Export To’ and ‘CSV’.
Click to Enlarge
Click ‘Advanced Options’, then select ‘Unicode (UTF-8)’.
Click to Enlarge