Smart Refresh – Uploading a Product Catalog

Overview

This article helps to prepare and validate a product catalog before uploading it. The catalog must include the required product, hardware, pricing, country, and currency information in the expected format.

Catalog records that do not meet the validation rules may be rejected during processing. Country and currency validation can also determine whether the system processes individual records or rejects the entire file.

Before you begin

Confirm the following before uploading your catalog:

• The file contains products for only one country.

• The Country Location value uses a supported two-letter country code.

• All mandatory fields contain a value.

• Numeric fields contain only permitted numeric characters.

• Related multi-value fields contain the same number of values.

• Every product price is greater than zero.

• The product currency is appropriate for the catalog country or qualifies for USD fallback processing.  

Important

A catalog file can contain only one distinct Country Location value. Do not combine products from multiple countries in the same file.

Catalog field requirements

Country and currency validation

The upload process selects one of three currency-handling modes after evaluating the Country Location and Product Currency values in the file.

1. Strict mapping mode

Strict mapping mode is selected when at least one row contains a valid country-currency combination.

In this mode:

• Rows with a valid country-currency combination are processed.

• Rows with a non-matching combination are rejected.

Example:

For a catalog using country code IN:

• IN with INR is processed.

• If the file contains both INR and USD, the INR records are processed because a valid country-currency mapping exists.

2. USD fallback mode

USD fallback mode is selected when:

• No valid country-currency mapping exists in the file, and

• At least one row uses USD.

In this mode:

• Rows with Product Currency = USD are processed.

• All non-USD rows are rejected.  

Example

For a catalog using country code IN:

• IN with only USD is processed through the USD fallback mechanism.

• If the file contains USD and EUR, the USD records are processed and the EUR records are rejected.

3. Reject-all mode

Reject-all mode is selected when:

• The file contains no valid country-currency mapping, and

• No row uses USD.

In this mode, no rows are processed.  

Example

For a catalog using country code IN:

• IN with only EUR is rejected.

• A file containing EUR and JPY is rejected because neither currency is valid for IN and the file does not contain USD.  

Country and currency processing summary

Pre-upload checklist

Before uploading the file, verify each of the following:

File-level checks

• The file contains only one distinct Country Location value.

• The country is represented by a supported country code.

• The product currencies are valid for the selected country, or the intended records qualify for USD fallback processing.

Required-field checks

• SKU No

• Device Type

• Country Location

• Product Name

• Processor Manufacturer

• Processor Model

• Processor Cores

• Processor Speed (GHz)

• Memory Capacity (GB)

• Memory Type

• Graphics Card Details

• Operating System

• Storage Size (GB)

• Storage Type

• Screen Information

• Product Price

• Product Currency

Data-format checks

• Processor Cores contains only digits, commas, and decimal points.

• Processor Speed contains only digits, commas, and decimal points.

• Memory Capacity contains only digits, commas, and decimal points.

• Storage Size contains only digits, commas, and decimal points.

• Product Price is numeric and greater than zero.

• Related multi-value fields contain the same number of values.

• Product URLs and image URLs are entered as intended.

Troubleshooting common validation failures

Appendix: Common country and currency mappings

The source guide provides a complete ISO country code and currency reference. The following mappings cover several commonly used catalog locations:

Some countries have more than one supported currency mapping. The complete mapping, including all supported countries and additional currency combinations, is available in the ISO Country Code and Currency table in catalog_upload_rules pdf that is downloadable from the portal.