You are currently viewing documentation for Linnworks Desktop, if you are looking for Linnworks.net documentation, click here.






Product Description and attribute import

Videos for this article

Overview

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

 SKU Title Price  Description  Size  Color  Brand  Suitable For  Material  Ages 
 SKU001 Boys shoes - 8.5 UK – Black  19.99 Very cool shoes for boys…  8.5 Black  ShoeMe  Boys  Leather  3-5 years 
 SKU002 Girls shoes – 8 UK - Green  17.99 Very cool shoes for girls...   8 Green  ShoeMe  Girls  Denim/Leather  3-5 years 

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
  • Click Next
  • 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.

Listing Number Subsource Identifier
1 EBAY1_1
2 EBAY1_2

 

Column Mapping

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.

Translation

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.

Google

  • 1.1 Google Translate API requires API token which you will need to obtain from Google. 
  • 1.2 Open google account, go to https://code.google.com/apis/console, select API Access and create new key. 
  • 1.3 You will also need to add your billing details.
  • 1.4 Go to https://developers.google.com/translate/v2/pricing?csw=1 to view the Google Pricing structure
  • Bing

  • 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.2 Register your application with Azure DataMarket. For that, visit https://datamarket.azure.com/developer/applications/ using the LiveID credentials from step 1.1.
  • 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 Template

    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.

    Preview Import

    The step lets you make final adjustments to titles, and attributes, view merged descriptions.

    Import

    Click Import to being import process.

     

    Language Tags

    Once the imports have completed, country specific titles, prices and descriptions will be added to the item.

     

     

    Expressions - How to

    How to create image thumbnail view?

    In product description screen insert expression snippet – Internal Image selector.

      ({IF["[{PRODUCT_IMAGE1}]"!=""]})
    <div>
    <img id="im" width="400" height="400" src="[{PRODUCT_IMAGE1}]" border="0">
    </div>
    <div>
    ({IF["[{PRODUCT_THUMBIMAGE1}]"!=""]})
    <a onclick="document.getElementById('im').src='[{PRODUCT_IMAGE1}]'"><img src="[{PRODUCT_THUMBIMAGE1}]"/></a>
    ({ENDIF})
    ({IF["[{PRODUCT_THUMBIMAGE2}]"!=""]})
    <a onclick="document.getElementById('im').src='[{PRODUCT_IMAGE2}]'"><img src="[{PRODUCT_THUMBIMAGE2}]"/></a>
    ({ENDIF})
    ({IF["[{PRODUCT_THUMBIMAGE3}]"!=""]})
    <a onclick="document.getElementById('im').src='[{PRODUCT_IMAGE3}]'"><img src="[{PRODUCT_THUMBIMAGE3}]"/></a>
    ({ENDIF})
    </div>
    ({ENDIF})

    How to insert RRP price crossed over and the actual price of the product displayed next to it?

    Import RRP price as an attribute. And use to following expression snippet.

    RRP <del><b>({=N2[[{PRODUCT_PROPERTY_RRP PRICE}]]})</b></del><br>
    Our Price ({=N2[[{PRODUCT_RRP}]]})</br>

    screen7.png

    How to output a list of product features as a list?

    Import product features as attributes (Product Feature 1, Product Feature 2, Product Feature 3 etc). Use the following snippet to output HTML list

    <ul>
     ({IF["[{Product Feature 1}]"!=""]})
     <li>
      [{Product Feature 1}]
     </li>
     ({ENDIF})
     ({IF["[{Product Feature 2}]"!=""]})
     <li>
      [{Product Feature 2}]
     </li>
     ({ENDIF})
     ({IF["[{Product Feature 3}]"!=""]})
     <li>
      [{Product Feature 3}]
     </li>
     ({ENDIF})
    </ul>


    Videos and Files

    Product Description and Attributes import tool - Linnworks

    This video demonstrates how to use Product Description import tool to bulk insert/update product descriptions, titles, attributes and pricing.

    Product Description Import and Attributes - Translate and template - Linnworks

    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