How do I import and export Can't Buy products?

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 Can't Buy 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 in

Log into Management Interface using your username and password. This opens the dashboard of your Management Interface.

Step 2: Create spreadsheet

Create spreadsheet to import

Use our product import / export spreadsheet feature to quickly import related products.

Either manually create a spreadsheet with the information you wish to import. The spreadsheet contains at least two columns:
- Product code (SKU) - a list of product identifiers you wish to connect, where the first product code is the product that all other products are related to.
- Can Buy
Or export a spreadsheet which includes all Can’t Buy products, and update it as required.

More information

Read using our custom product export tool to find out how to export a custom set of product data elements. In this case, you need to select at least Can Buy to export products that have been set as Can’t Buy products. The associated product code (SKU) is automatically exported as the first column in the spreadsheet.

Step 3: Edit spreadsheet

Edit

Edit spreadsheet as required by adding or removing products you wish to set as Can’t Buy.
Save your changes.

Import spreadsheet

When the spreadsheet is ready for import, return to the Import & Export screen in Management Interface.
Click Choose File under Product Spreadsheet and select the spreadsheet from your file directory.
Click Update Catalogue. This updates the data in your catalogue as specified in the spreadsheets.

Remember that changes are immediately visible in WebShop.

Verify import

What does my customer see in WebShop?

Your customers can see the product, but not any stock or pricing information. Your customer is not able to purchase the product when it is configured as a Can’t Buy product.