9 Partner Feedback: Assortment Analysis
INTRODUCTION
The assortment analysis is a detailed evaluation of all articles supplied by the partner and thus offers. The file provides information about the status of each item accordingly. We offer the file in English only.
The file provided is in Excel format and consists of three tabs:
status:Howto Short introduction about the Excel file.
status:Report Overview with article status and number of affected records (products).
status:Basis Detailed list of all partner items with all possible additional information.
Depending on the partner type - merchant or supplier, different technical conflicts can occur in the data processing procedures. All these conflicts are explained below.
EXPLANATION ASSORTMENT ANALYSIS
The partner is shown at the top, as well as the date and version of the analysis. The report for the analysis runs regularly. A report should be no more than 48 hours old.
All conflicts that arise during data processing are shown. This means that all conflicts generated by an article can be seen and not just the most important conflict of the article.
The first step of the processing is the assignment. Here it is checked whether a product already exists or whether it must be newly created. Here, all minimum requirements are checked and, if positive, a product is created. At the same time, the offer data such as price and inventory are checked and the offer is attached to the product. After each update of the offer data, the data runs through the offer data check again.
REPORT
This tab shows an overview of all existing conflicts. The cause of the conflict can be found in the "Conflict" column. The "Is Buyable" column shows whether the affected items are buyable. The "assortmentState" column describes the import level at which the conflict arose and the "No. item" column shows the number of affected items
BASIS
In the Basic tab, the individual conflicts are displayed at data record level. This allows you to see exactly which data record is causing which conflict.
To do this, we recommend using the filter function to reduce the list and address individual conflicts.
PRIORITIZATION AND RESOLUTION OF CONFLICTS
We are aware that it is challenging to have all offered products purchasable. Therefore, it is recommended to address the points that allow assignment to existing products first (Assignment = Not Assigned).
We provide our partners with the Feedchecker to identify the errors even before the import.
Below you will find a detailed list of all possible conflicts.
Please note that conflicts marked with a yellow resolution suggestion can only be resolved by Digitec Galaxus.
Proposed solutions which are marked in blue can be solved by yourself. Here you usually have to optimize your data in the feed and let the solutions flow directly into the feed.
Recommended prioritization
Allow assignment through valid GTIN
Resolve offer conflicts
Create all products
IMPORT AND VALIDATION CONFLICTS
For information on technical import and validation conflict resolution, click here:
8 Troubleshooting for active datafeeds
OFFER DATA CONFLICTS
The following is an overview of all conflicts that arise due to assigned offers.
Please note the model you are working with Digitec Galaxus!
For all conflicts that need to be resolved by Digitec Galaxus, please contact the person responsible for you.
OC - Supplier (Retail)
Conflict | Error | Solve conflict |
---|---|---|
SPD is deactivated | status:internAL The offer is excluded from Digitec Galaxus / Galaxus Germany. | No action possible |
Purchase price is outside of the anticipated price range | The purchase price is below or above the permissible price range of the corresponding product. | Check your price, trade quantity and the GTIN of the offer and report to your Category Development Manager |
Purchase price is smaller or equal to 0.01 | The purchase price of the is less than 0.01 or greater than 100'000. | Check your purchase price |
Minimum order value exceeds the limit | Minimum order quantity * Purchase price → may have a maximum purchase value of CHF 50,000. | Check the purchase price and the minimum order quantity |
Product is deactivated | status:internAL No offer with positive availability | No action possible |
| RestockDate limit exceeded (InStock) Restock date no later than now + 3 months (OnDemand) | Check your RestockDate |
Orders without restock date are not allowed | Offers are not used in buying and selling because there is no availability. Orders without stock are not carried out. | Check your availability, RestockDate / RestockTime or deliver positive stock |
Digital products are not supported | Digital products are only permitted for partners with the appropriate configuration. | Fragen Sie die Freigabe beim für Sie zuständigen Category Development Manager an |
Assortment is deactivated | status:internAL "Use assortment" is deactivated in the assortment control. The partner is currently not in a productive state. | Contact your Portfolio Development Manager |
The minimum order quantity is not a multiple of the order quantity step | The maximum permitted minimum order quantity and order quantity step is 200 for direct deliveries and 500 for warehouse deliveries. | Check the minimum order quantity and the order quantity step |
Orders on restock date are forbidden | Offers are not used in purchase and sales if stock = 0 (regardless of RestockDate). | Check your availability as RestockDate or Restocktime are not taken into account. |
Product not storable | status:INTERN We are not allowed to store certain products for various reasons. | Contact your Portfolio Development Manager |
OC - Merchant
Conflict | Error | Solve conflict |
---|---|---|
Sales price is not between 0.01 and 100'000 | The sales price is less than 0.01 or greater than 100'000. | Check your sales price |
Currency is not supported | We receive a different currency than we expect. | Check your transmitted currency |
Multiple offers available from same merchant | More than one active offer per merchant on the same product is not allowed. | Please remove duplicates of the item / offer |
VAT rate is not valid | The VAT of the offer does not match the product or product type. | Check the VAT rate of the product. If it is correct, contact your Portfolio Development Manager. |
Manual deactivation of the merchant offer | status:internAL The marketplace offer is deliberately ignored by Digitec Galaxus / Galaxus Germany. | No action possible |
Cancelation of the merchant offer by the merchant | status:internAL Offer cancelled via CMI or EDI messages. The offer is automatically reactivated after 2 weeks if stock has been updated. | No action possible |
Restock date range exceeded | Stock = 0 AND Restock Date > today + 3 months | Check your RestockDate |
Orders without restock date are not allowed | The partner configuration blocks all offers for sale in the absence of availability. | Check your availability, RestockDate / Restocktime or deliver positive stock |
Digital products are not supported | Digital products are only allowed for partners with the appropriate configuration. | Request approval from the Category Development Manager responsible for you |
The supplier's assortment is deactivated | status:internAL Digital products are only permitted for partners with the appropriate configuration. | No action - contact your Portfolio Development Manager |
Minimum order quantity or increment order quantity exceeding the threshold | Maximum allowed minimum order quantity and order quantity step is 500. | Check minimum order quantity |
Minimum order quantity is not a multiple of increment order quantity | Minimum order quantity must be a multiple of the order quantity step. Here, for example, it would not be allowed if the minimum order quantity is 2 and the order quantity step is 5. | Check the minimum order quantity / order quantity step |
Orders with restock date are not allowed | Offers are not used in purchase and sales if stock = 0 (regardless of RestockDate). | Check your availability as RestockDate or Restocktime are not taken into account. |
No stock information | Offers are not used in the sale as no availability is indicated. | Check your availability, RestockDate / Restocktime or deliver positive stock |
PRODUCT DATA CONFLICTS
The following is an overview of all conflicts that have to do with product data and product creation
Please note that the conflicts are independent of the supplier or dealer model.
The minimum criteria for the product data, you can find here:
PC - Provider Product Conflicts
Conflict | Error | How to solve Conflict |
---|---|---|
Gtin has no global validity | Gtin is not globally valid according to the GS1 standard. | Check the GTIN (EAN) for global validity |
Gtin is missing | No Gtin available. | Check whether a GTIN can be transmitted or contact the responsible Portfolio Development Manager |
Null | ProviderKey appears in the assortment, but we have no GTIN or other product data for this data set | Check whether the GTIN and other minimum criteria for the provider product are imported into the feed. |
PC - Product Data Conflicts purchasing
Conflict | Error | How to solve Conflict |
---|---|---|
TitleDe missing | Product creation pending, as the product title in German is missing. This is a minimum criterion for product creation. | Check whether a product title is transmitted in German |
Images missing | Product creation pending, as pictures are missing. | *The image is a minimum criterion for product creation. Check whether at least one freely accessible URL link is transmitted. If this is the case, contact the responsible Portfolio Development Manager. |
ExclusionCriteriaMatch | status:internAL Product type and / or brand is excluded from product creation. Certain brands and product types are deliberately excluded. This is due to compliance requirements, NDAs and non-physical products. | No measures necessary, products in this status are regularly checked by Digitec Galaxus. |
Brand missing | Product creation pending, as the brand is missing. | *The brand is a minimum criterion for product creation. New brands are created within a few days Check whether the mark can be transferred or contact the relevant Portfolio Development Manager. |
ProductType missing | Product creation pending, as the product type could not be determined. | *The product type is a minimum criterion for product creation. The assignment usually takes place within a few days. Check if the category path can be submitted or contact the responsible Portfolio Development Manager. |
PC - Product Data Conflicts sales
Conflict | Error | How to solve Conflict |
---|---|---|
Images missing | Product clearance denied as images are missing. | *The image is a minimum criterion for product clearance. Check whether at least one freely accessible URL link is transmitted. If this is the case, contact the responsible Portfolio Development Manager |
QualiltyProperty missing | Important (gatekeeper) features are missing that are essential for the customer to purchase the item. | Check whether all properties are imported into the feed. If not, contact the Portfolio Development Manager responsible |
Compliance | Important compliance data is missing, which is absolutely necessary for the customer to purchase the item. | Check whether all existing data is imported into the feed. If not, contact the Portfolio Development Manager responsible |
*these conflicts are dependent on technical processes, these can take a few days and delay further processing, thus the correct conflict.