How do I import and export related products linked with a single product
Purpose and scope
Do you have products in your catalogue that you'd like to upsell or cross-sell? With our related product feature, you can link products together, which are then displayed in your WebShop under a configurable heading. We support two types of related products: linear related products and group related products
This feature guide provides a step by step guide on how to use our spreadsheet import / export functionality to import and export related products in your product catalogue.
Key points
We recommend that you read Understanding product administration in WebShop to understand how the import / export spreadsheet feature operates and Understanding related products for more information on this feature 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.
.jpg?inst-v=a68073f4-53a6-4fde-9852-c7d771eb79d2)
Step 3: Open product
Click Products. This opens a listing of products in your catalogue.
Locate the product you wish to update.
Click the Edit icon to the right of the product. This opens the product administration tool.
Click Product Settings tab.
Scroll down to the Related Products option. Click either Export Linear Related Products or Export Group Related Products to export products that have been grouped and are associated with this product.
Step 3: Edit spreadsheet
Step 4: Import spreadsheet
When the spreadsheet is ready for import, return to the Import & Export screen in Management Interface.
The spreadsheet will only contain either linear or grouped related product information for the product that you have selected in the previous step.
Click Import Related Products, found under Related Products in the main content area. This opens the Import Related Products screen.
To import a linear related products spreadsheet, click Choose File under Related Products (Linear) and select the spreadsheet from your file directory.
To import a grouped related products spreadsheet, click Choose File under Related Products (Grouped) and select the spreadsheet from your file directory.
Click Update Related Products. This updates the links between the products as specified in the spreadsheets.
Remember that changes are immediately visible in WebShop.
Step 5: Verify changes
Your customers can see related products (either linear or grouped) for the product you have updated once you have imported your changes.
Linear related products
In WebShop, all product codes listed apart from the first product code are displayed on the first product code’s detailed product page. The first product code is not listed on any of the other linked product listing pages. Related products are displayed on the first product’s detailed product page from left to right in alphabetical numerical order.
Group related products
In WebShop, all products listed in the spreadsheet are displayed under Related Products on each of the four product's detailed product pages. The products are displayed from left to right in alphabetical numerical order.
To verify that the relationships created between products are correct, view the detailed product screen of the product(s) in WebShop and check that the related products are displayed as you expected.
