How do I import a product spreadsheet?
Purpose and scope
Each product in your product catalogue has a number of data elements associated with it; including its product code, product name, URL, title, status, whether it is a Featured product, images associated with it and so on. This product information is displayed in WebShop in the product’s listing pages or on the product’s detailed information screen. Our product import / export spreadsheet feature allows you to update one or more product data elements quickly and efficiently.
The purpose of this article is to provide a step by step guide on how to import a product spreadsheet using our product import/export spreadsheet feature.
Key points
We recommend that you read Understanding product administration in WebShop to understand how the import/export spreadsheet feature operates and Importing product information and images for more information before following the steps outlined in this guide.
Step by step
Step 1: Log into Management Interface
Log into Management Interface using your username and password. This opens the dashboard of your Management Interface.
Step 2: Open Product Administration
Click Catalogue on the left hand menu. This opens Product Administration, from where you can manage your product catalogue.
Step 1: Set up product spreadsheet
Either manually create a spreadsheet with the information you wish to import. The product code (SKU) is always the first column. The spreadsheet contains some or all of the following columns:
Product code (SKU) - the product identifier
Name
URL
Page title
Meta keywords
Meta description
Status
Featured
Index priority
Special
Content
Images (up to 4)
Alt text for each image
Can buy - only visible when the Can’t Buy feature has been enabled
Or export a spreadsheet using our custom product export tool.
Edit the spreadsheet with the changes you wish to make.
Example
The following screen show the options selected to export 8 products which must be Visible and are not in either the Featured section or on Special offer.
Exporting this set of options downloads a spreadsheet containing 8 products with the following format:
Step 2: Import spreadsheet
Click Products.
Select “Import Products“ from the drop-down menu to the right of the Product Listing screen. This slides a menu out from the right of the screen.
Click “Select Product Spreadsheet“ and select the spreadsheet from your file directory.
Click Submit. This updates the data in your catalogue as specified in the spreadsheet.
Remember that changes are immediately visible in WebShop