Each product in Linnworks can have multiple descriptions, titles and pricings. The description can be HTML with embedded tags or plain text. Product title, description and price can be assigned to a specific channel or act as a default value. When specific channel value for either title, description or price is not specified for a product the default value will be used when listing it.
This documentation describes how to use Product Description import tool to bulk insert/update product descriptions, titles, attributes and pricing.
Product Description, attributes, pricing import
Prepare CSV file to import
The import tool is designed to import data from Comma Delimited text file. The file must contain column called SKU.
The other columns in the file are used to store product attributes (color, size, brand etc), tags (for merging into a description when importing data), product description, price and title. The names of the columns are flexible and can be mapped to the expected names during the import process. Please note there is a limit of 50 characters on Attribute Name and a limit of 2000 characters on the Attribute Value.
Example of the CSV file
Boys shoes - 8.5 UK – Black
Very cool shoes for boys…
Girls shoes – 8 UK - Green
Very cool shoes for girls...
Open the product description import tool
To open the import tool
Start > Programs > Linn Systems > Linnworks > Tools > Data Import
Select Product Descriptions and Attributes from the drop down list
This will open a separate tool
Select CSV file
Choose the file you want to import and specify which channel you want the description, titles and pricing to apply. Default – means the imported description, title and price will be applied if there is no specific value for a particular channel the product is being listed on.
If you wish the import tool to use automated translation service (Microsoft Bing or Google Translate API) to translate the descriptions, attributes and titles to a different language, tick Translate.
eBay Multiple Listings
LinnLive has the ability to list the same inventory item under different titles, prices and descriptions. To do this you will need to add suffix tags to the subsource to identify each listing uniquely.
The suffixes work in the following way.
Column Mapping screen allows you to map columns in your CSV file to types being imported.
Title – product title for specified channel Price – product retail price – the values in the CSV file must be numeric. Attributes – the attribute value will be imported into Extended Property of a product. Tag – tag is text that can be used in the Description merge
To map the columns select the appropriate type by double clicking on the Type cell and select from the drop down box. Set a column to [Ignore] if the data in the cell does not need to be imported.
Product descriptions, titles and attributes can be translated to another language. If you ticked Translate on the first screen – the translation wizard screen will be shown after Column Mapping screen.
1.1 Google Translate API requires API token which you will need to obtain from Google.
1.1 Subscribe to the Microsoft Translator API on Azure Marketplace. Basic subscription is up to 2 million characters a month, are free. Translating more than 2 million characters per month requires a payment. Select from any of the available subscription offers.
1.3 Click on Register. In the Register your application dialog box, you can define your own Client ID and Name. The redirect URI is not used for the Microsoft Translator API. However, the redirect URI field is a mandatory field, and you must provide a URI to obtain the access code. A description is optional;
1.4 Take a note of the client ID and the Client Secret Value. Visit here to learn more about how to sign up for Microsoft Translator on Azure Marketplace.
Select the language you are translating from and to, enter your token and click Start Translating.
Some attributes may not need to be translated, to remove a specific column from translation, right click on the column header and Hide Column.
Note: Attributes are not stored in the system per channel. For example, if you import Color attribute and translate it to French the attribute name will become Color_FR.
Description can be imported as a plain text or HTML. The product description can have embedded tags, attributes and expressions. In basic terms you can have one description template and merge different properties of a product to create a specific product description. Consider the following diagram,
The data importing tool will transform the description template into a product description using product’s title, description text and attributes.
The template itself can have expressions. Expression is a way to output text conditionally. For example it is common to check whether an attribute with a certain name exists and if so, output the attribute value, if the value is empty output nothing.
Enter the description template on the left hand side, the right hand side panel will display the preview of the description. You can navigate to a specific item SKU to view the transformed template.
The step lets you make final adjustments to titles, and attributes, view merged descriptions.
Click Import to being import process.
Once the imports have completed, country specific titles, prices and descriptions will be added to the item.
The video demonstrates how to use Product Description and attributes import tool to translate product description to another language and how to use template expression to output information on the product description template conditionally