This import allows you to submit / update your price range, including min_price, max_price. for your items on noon.com.

This article will help you to ensure a successful import walking you through the template and a step by step guide along with best practices and tips.

The upload template

Here is a brief about all the columns you would need in your import file

Field / Column	Important	Sample value	Description
Country_Code	Required	AE	The country for which you've exported. Your available products will be different depending on country selected
id_partner	Required	1455	Your unique partner id that identifies your account and your products
partner_sku	Optional	Atta2604	The SKU you assign your self to each and single one of your product
Psku_Code	Required	a51578b667d96d04e0fb34d	This code is generated as soon as your product is linked to a noon product. It is a standardized alphanumeric code that will not change. When making subsequent imports you can either use this value or your partner_sku or both
price_min	Required	200	The minimum price you accept for this product during offers / deals
price_max	Required	200	The maximum price you aim for this product

 

Best practices and tips

Please note that this import goes through a secondary check at noon. Any

If your encounter format error use the paste feature 

Be sure to save your file in xlsx or csv format

Product Catalog doesn't import XLS files. If you create or edit your file in Excel, we recommend saving the file with Unicode Text encoding.or you can simply paste all the data in the Paste tab.

Check the file format and encoding

• Windows: Select Save As > Save as type > Unicode Text.
• Mac: Select Save As > Format > UTF-16 Unicode Text.

List each offer on its own row Each row in your xlsx/csv file must represent a single offer, such as a mobile, a toy or a T-shirt etc.

If you need to make only minor changes or additions to the account, you might choose to export a xlsx file from Exports, edit it, then import it back into Imports.

Common errors 

Minimum price cannot be higher or equal to the price, and the same for the maximum price is not allowed to be equal or higher than the priceIn case of sale, the sale price is higher than price

The psku_code and the partner_sku are not matching 

This usually occurs when you partner_sku contains all numbers or special characters. In order to solve this issue after you have prepared your import you can delete the partner_sku column or just import against psku_code.

Alternatively not saving the file after download and just pasting in the values can prevent issues.

Step by step walkthrough

1- From your dashboard (Home) left menu, select Catalog then Imports then click on New Import at the top left of the page

2 - Select from the menu Price the sub-category Partner SKU Price Range 

  

3- After reading the brief guidelines & downloading the template please Press NEXT at the right bottom of the page

4- Now you can import your file through either by pasting the information or by uploading the sheet

5- Then you can track the status of your import in the imports page, once it's processed, that means all your new price ranges are in place.

 

Note

-   If your file has so many updates, it may takes sometime in processing, you can refresh the page using the refresh button at the top right until you get your file processed.

    * Files accepted: XLS, CSV and TSV