How to Set Up and Work With Product Identifiers for eBay in Linnworks

It is compulsory for eBay sellers to use product identifiers when listing branded new and manufacture refurbished items, within a range of specific categories, Linnworks customers should follow the outlined method for submitting the required Product Identifiers through Linnworks. 

What exactly are Product Identifiers?

Specifically, Product Identifiers include:

  • The brand name of an item
  • The manufacturer part number (MPN)
  • Global trade item numbers (GTINs), which are assigned to most retail products and include:
    • Universal product codes (UPCs)
    • International standard book numbers (ISBNs)
    • European article numbers (EANs)

In other words, they are unique identifiers that will be used to help eBay categorise new, branded products. Do bear in mind, however, that custom items and items produced before product identifiers were introduced in 1970, won’t have unique product identifiers, and in these instances you should input “Does Not Apply” or “unbranded” in the necessary field.

Where is the data saved?

You should be aware that the brand name and MPN will be saved as an Extended Property in the stock item, and the Product Identifier (EAN/UPC/ISBN) will be saved in the barcode field on the stock item.

How is the data submitted by Linnworks?

When listing to eBay through Linnworks, you will be required to map the brand name as an Item Specific in the configurator (for both non-variant and variation products). In case of listing non-variant product, MPN should be added as an Item Specific. In the case of listing eBay variation, MPN must be added as a Variation attribute. In the case of listing both non-variant and variation products with the same configurator, add MPN to both Item Specifics and Variation sections of the configurator. Linnworks will automatically decide which of these two values submit to eBay basing on the type of each particular listing (non-variant or variation).

Please be aware that Linnworks will pull the Product Identifier value automatically from the barcode field, and eBay will identify its correct type, for instance, a European Article Number (EAN) or a Universal Product Code (UPC). In case there is no barcode for the item you list, you can set ‘Does Not Apply’ in the barcode field of the Stock Item.

Submitting for a new listing

When creating new listings from Linnworks the Product Identifier information will be submitted to eBay as part of the standard listing process so long as the required data exists on the Linnworks stock item and the configurator is mapped to the relevant extended properties.

Find out more about creating a listing on eBay with Linnworks

Updating existing listings

If you have previously created a listing to eBay through Linnworks without the Product Identifiers, and need to update your listing via Linnworks.net, the necessary process is as follows:

  1. Update the data on the Linnworks stock item, either manually or via Data Import
  2. Ensure the configurator is set up to submit the Brand Name as an Item Specific and MPN as an Item Specific (for non-variant products) or as a Variation (for variant products)
  3. Go to Settings > Configurators > eBay
  4. Select the required eBay Configurator(s)
  5. Click on the cog icon at the top right of this screen
  6. Pick Revise Selected from the pop-up menu
  7. Tick the options Update Extended Properties and Add New Attributes from Configurator
  8. Click Revise Selected to close the screen and start the update process
  9. To view progress on the updates, click on the number(s) in the Templates column

Finding your items that are missing Product Identifiers

To help you identify which products are missing Product Identifiers we have written a script that can be run in Dashboards > Query Data using the Custom Script option. When executed it will return a list of SKU's that are missing any one of the Product Identifiers (Barcode / Brand / MPN).

  1. Goto Dashboards > Query Data
  2. Ensure Custom Script is selected from the drop-down
  3. Copy the script (see below)
  4. Paste into the Custom script window
  5. Click View Report
  6. If required Export using the Download (CSV file) button
--query for live SKU's that do not have any one of the following
--* Barcode
--* Extended Property - Brand
--* Extended Property - MPN

DECLARE @epBrand VARCHAR(50) = 'Brand' -- The name of the Extended Property used for Brand
DECLARE @epMPN VARCHAR(50) = 'MPN' -- The name of the Extended Property used for MPN

;WITH ProductIdentifiers AS (
 SELECT  
  fkStockItemId,[Brand],[MPN]
 FROM 
 (SELECT 
   fkStockItemId, sep.ProperyName, sep.ProperyValue
  FROM StockItem_ExtendedProperties sep WITH (NOLOCK)
  WHERE sep.ProperyName IN (@epBrand, @epMPN) 
 ) AS SourceTable
 PIVOT
 (MAX(ProperyValue)
  FOR ProperyName IN([Brand], [MPN])
 ) AS PivotTable
)

SELECT 
	si.ItemNumber, si.BarcodeNumber, 'Brand'= ISNULL(ep.Brand,''),'MPN' = ISNULL(ep.MPN,''),'Variation Group Name'= ISNULL(vi.VariationGroupName,'')
FROM 
	StockItem si WITH (NOLOCK)
	LEFT JOIN ProductIdentifiers ep ON si.pkStockItemId = ep.fkStockItemId
	LEFT JOIN StockItem_Variations siv WITH (NOLOCK) ON siv.fkStockItemId = si.pkStockItemId
	LEFT JOIN VariationItem vi WITH (NOLOCK) ON siv.fkVariationItemId = vi.pkVariationItemId 
WHERE 
	si.bLogicalDelete = 0 AND (si.BarcodeNumber IS NULL OR ep.Brand IS NULL OR  ep.MPN IS NULL)
ORDER BY
	si.ItemNumber