ChannelEngine: listed products

About this article

This article describes the Listed products step on channels.

Table of contents

Introduction

Overview

• Default columns
• Content columns
• Offer columns

Search, settings, and filters

Introduction

Whether your products are ready to be exported to the channel or your products are already exported, the Listed products step provides you with the detailed status of your product listing. Listed products generally contains two tabs: 

• Overview - the standard overview of each product's export status from ChannelEngine and published status on the channel's website.
• Validation and feedback - a log of error codes to help troubleshoot products that are unsuccessfully exported. For details on the Validation and feedback tab, check out ChannelEngine: listed products (validation and feedback).

Overview

At the top of the overview on selected channels, four widgets appear, giving you a concise view of how many products are successfully listed, with quick shortcuts to investigate issues that might be blocking a listing from appearing on the channel. This is the sellable products feature on ChannelEngine. To learn more about how to enable and use sellable products, check out ChannelEngine: dashboard (channel).

This listed products overview shows and hides columns depending on which column toggle options you choose.

The column toggle options are:

• Show price override settings
• Content
• Offers

Default columns

To limit the amount of information shown at once and make the best possible use of the available space, only the content export status is displayed in the overview by default – next to the product image, details, and the date of the last update. To view the latest offer export status (i.e.: the price and stock exported, and the price and stock the marketplace reports), select the Offers column toggle.

When none of the column toggles are selected, the default table shows the following columns:

• Image - shows a thumbnail of the product.
• Details - shows the title of the product, and the product's identifiers, such as the Merchant product number/SKU and the product's EAN/GTIN.
• Last import from channel - displays the date and time of the last feedback ChannelEngine received from the marketplace regarding the product, either from a feedback report or API call.
• Actions - gives you options to view the product details page or the product's stock calculation for the channel. If you apply any stock settings, such as stock limit or stock buffer, you can check how ChannelEngine calculates stock for this product in the Stock calculation modal. On select channels, you can view your live product listing on the marketplace by clicking the search icon.
  

Content columns 

Content columns are visible if you enable the Content column toggle.

Export from ChannelEngine

• Action - the action scheduled to be performed in the next export, applicable to either the offer or content export (depending on the marketplace and the type of connection it uses). Regardless of what type of export it refers to, the actions are the same:
  • CREATE - the product offer is scheduled to be created in the next export.
  • UPDATE - the product offer has been exported at least once, and all changes are scheduled to be exported as an update.
  • DELETE - the product offer no longer complies with any product selection filter and is scheduled for removal.
  • RETRY OFFER/RETRY CONTENT - an error occurred in the previous export, or a manual export has been triggered.
• Status - the status returned after the last action was performed. Usually, it corresponds with the previous action, but in some cases, it can differ. Note that these are only an indication of the current status. E.g.: ChannelEngine submits a product offer to bol for a product accepted by their API. Therefore, the status is CREATED or UPDATED. However, if it turns out to be an offer for an EAN that bol has no known product for, the Last import from channel status is NOT PUBLISHED.

Possible statuses

• CREATED - the product offer was created (i.e.: either there was no immediate error during the export, or there was a confirmation that the creation was accepted.
• UPDATED - the product offer was updated.
• DELETED - the product offer was removed from the marketplace (i.e.: either there was no immediate error during the export, or there was a confirmation that the deletion was accepted).
• FAILED TO CREATE - there was an issue during the export. The marketplace refused the product offer, or the product offer did not pass validation before exporting. An example for the latter scenario is displayed below:

•  
  • The first product had an EAN that did not pass EAN validation (e.g.: 000000 was entered, where an EAN13 like 8715342024592 was expected). To prevent an error on the marketplace's side, the product has been filtered out before exporting.
  • The second product has an exported price of 0, which is not accepted by the marketplace. To prevent an error on the marketplace's side, the product was filtered out before exporting.
• Reason - usually empty, but used by some marketplaces to display errors during the export.
• Date - displays the date and time of the last data export of this product.

Last import from channel

• Status - lists the status reported by the marketplace for your product, if the marketplace supports feedback. While this may appear similar to the Status of the Export from ChannelEngine section, it can vary.

Possible values

• NONE - either there is no feedback from the marketplace yet, or the marketplace does not offer any feedback reports.
• PUBLISHED - the product offer was published and it should be available on the marketplace.
• NOT PUBLISHED - the product offer was not published, the reason is usually stated right next to it in the Reason field.
• UNKNOWN - ChannelEngine received feedback from the marketplace, but it contained no information on this specific product. Some channels list this as NOT PUBLISHED instead.
• UNDER REVIEW - in some cases a product is first reviewed before it is published on the marketplace. E.g.: INNO and Wish.
• INVALID - the product did not pass validation before exporting. E.g.: invalid EAN or a price of 0.
• BEWARE - informs you that there has been a more recent export than the current status of the marketplace is received. This means that whatever status is labeled, it might not be applicable. There is no way to be sure until a new report for your product has been received.
• Reason - lists the specific reason the marketplace returned when trying the last action like creating or updating, either an error or a warning. By selecting the small 'table' icon in the top right corner of this field, you can see a popup listing all the applicable product warnings and errors.

Possible reasons

• UNMATCHED_OFFER - an error from bol stating the offer cannot be created, at the time of the last offer export. This can be due to an unknown EAN, or a product with the provided EAN is missing mandatory information so it cannot be placed online.
• Product not in offer file/Product not found in inventory report - the product offer was reported as successfully exported through an API connection. However, the product was not listed in the product report received from the marketplace so it is most likely not listed. This can have various causes, such as:
  •  
    • The hourly report was generated before the export of the offer.
    • The product offer was exported, but has been manually removed.
    • There was an error processing the product offer in the marketplace back-end, which caused the product to not be listed.

Usually, this status and reason can be automatically fixed after a while or the next export, but if this status remains visible for a longer period of time (e.g.: 3+ hours), contact ChannelEngine's Support team.

• Invalid EAN/Size/Price - the product offer was not exported because a required attribute has no value or an invalid value.
• Category required - the product offer was not exported because the mandatory category/product type was not mapped.
• SKU-related error (Amazon) - the specific reason description can vary, but the cause is usually the same. The Merchant product number/SKU is the unique identifier for offers on Amazon. It is not possible to change this or the EAN/ASIN it refers to – and if you delete an offer for a specific SKU, you cannot reuse it for the next 24 hours.
• Stock reserved for pending orders - occurs when you only have two or a few items in stock, and there are open orders for these items. Because of ChannelEngine's and bol's stock reservation, a stock of two can lead to a stock of one being exported, which in turn leads to a stock of zero, and this error.

Offer columns 

Offer columns are visible if you enable the Offers column toggle.

Export from ChannelEngine

• Price - shows the last exported price.
• Stock - the last exported stock quantity. If the fulfillment is set to a marketplace, like FBA or LVB, a label is shown.
• Date - the last date and time the offer export was performed. Note that offers are incremental, so an update for a product is only sent if the stock or price has changed.

Last import from channel columns

• Price - shows the reported price by the marketplace. Note that if you change your price, it is not immediately visible in this column. As feedback reports are generated hourly, the update can take some time. If the price differs for longer than three hours, contact ChannelEngine's Support team.
• Stock - the last imported stock quantity. As with the price, it can vary when a stock update has just been submitted. Next to that, in case of bol, they currently also reserve stock. So if one item is sold and you have a stock of three, the first stock column displays two (i.e.: three minus a reservation of one, done by ChannelEngine), and the second column displays a stock of one (two minus the reservation of one by bol).

Show price override settings

The Price override column appears if you enable the Show price override settings column toggle.

Enable the column to set a fixed override price. In the label next to the price field, you see the percentage change relative to the original price. If you enable price overrides in this column, all price rules, repricing, and other price settings from the Pricing step are overruled. The price you set is the price that is exported.

Search, settings, and filters

At the top of the Listed products overview, there is a search bar and several filters. Use the search bar to look up products by:

• Full identifier - enter the exact GTIN, or Merchant product number to find a specific product. To find multiple products at once, separate the identifiers by spaces. E.g.: 76946 76947 76948.
• Partial identifier or name - enter part of the GTIN or Merchant product number, or a single word from the product name. E.g.: searching for 2 returns all products with 2 in the identifier.
• Phrase in the name - enter multiple words from the product name in double quotation marks (" "). E.g.: searching for "purple pants" returns all products that include the phrase purple pants in their names. Without quoting, a multisearch will be performed on each word, giving results for purple and pants.

The functionality of the filters is detailed below:

• Extra filters - by default, these are all set to All. Change the different filters to Yes or No to narrow down the list of results.

• Export action - filter on the action performed on the next export. The actions are: Create (not exported yet), Update (created in the past so will be updated if applicable), or Delete (the product no longer complies with any product selection filter, and is scheduled for removal from the marketplace in the next export).
• Export status - filter on the current status of the export. Similar to Export action, but has one additional status: Failed to create (if the product export is unsuccessful). Another attempt is made in the next export, the action remains on Created. Unless there is an issue, this is not a state seen often.
• Channel status - filter on the reported status of the product on the marketplace itself. The possible states can vary per marketplace, as some use a direct API call response and others use a feedback file generated and read every few hours. The most common states are None (either not exported yet or there is no feedback from the marketplace), Published (the marketplace reports the product as active), or Not published (the product is not listed for a specific reason).
• Category - filter on one or more specific categories imported from your system.
• Channel category - filter on one or more specific categories on the marketplace. E.g.: bags, suitcases, beauty products, etc.
• Product selection - filter on one or more of your product selections. E.g.: summer sale products, sustainable products, etc.
• Product type - filter on the product type, i.e.: Child, Parent, Grandparent, or Standalone.
• Include bundles - filter on product bundles. You can choose to show bundles only, include bundles in the selection, or exclude them.
• Clear filters - remove all applied filters and allows configure new ones from scratch.
• Export selection - export all results to a CSV or a CSV for Excel. The export is useful to see a complete overview of the feedback and work offline.