Partner SKU price update import
This article will help you to ensure a successful import walking you through how you can update your prices.
Update your price one at a time
Go to your Seller Lab Go to Catalog then click Partner Catalog
Click on any product to modify your price. Any changes made to your offer will reflect immediately on the noon website.
Add your Price, discounted price as you wish then start and end date if Sale Price selected.
Step by step walkthrough
1- From your dashboard (Home) left menu, select Catalog then Imports then click on Add Import at the top left of the page
Select Price as a “Main Type”, then Price Update as “Sub-type”.
Select Not Live as the “Status”, then Marketplace as “Noon”
Then click Request Export to download the document.
- Update your new prices in the columns: Price, and update if applicable Sale Price, Sale Start, Sale End to put your product on a promotion.
- The dates should be updated in the following format (2019-30-12, YYYY-DD-MM)
- Make sure that your prices are within the range reflected in the columns "x_noon_price_min” and” x_noon_price_max", otherwise your updates won't go live.
Price Bulk Update Steps
The columns with the header that mentions "current" reflect your current prices on the website.
The use of "x_noon_price_min” is to help sellers avoid setting low prices to their products by mistake. And the "global price max" is set to ensure that we offer competitive prices to our customers, which will continue to drive demand for our partners at the same time.
In case you'd like to set your prices below the ” x_noon_price_max" please send an e-mail with the SKUs and their respective prices to seller@noon.com to grant your approval of the lower prices.
- Finally, upload your updated file to Seller Lab on the Imports tab by clicking clicking Start Import (New Workflow) on the page you downloaded the excel file from.
- Xlsx, TSV and CSV file formats are accepted.
- Next, upload or paste your file
- Click Submit, and your prices will go live within a few minutes
- Prices of products priced below or above the noon price range won't go live (global price min & global price max)
Then you can track the status of your import in the imports' status page, once it's processed, that means all your updates is in place.
Note: If your file has so many updates, it may take some time in processing, you can refresh the page using the refresh button at the top right until you get your file processed.Understanding the Columns of the 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 | ashar2 | 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 |
| x_partner_title | Optional | iPhone X | The title you already assigned for your product |
| x_noon_sku | Optional | N20174454A | The noon SKU. This will only be available for linked products |
| x_noon_brand | Optional | Apple | The brand of your product as registered with Noon |
| x_noon_title | Optional | iPhone X | The title assigned to your product in Noon.com's catalog |
| current_price | Optional | 100 | The old price available before your import |
| current_sale_price | Optional | 800 | The old sale price available before your import |
| current_sale_start_date | Optional | 2019-21-03 | The old sale start date available before your import |
| current_sale_end_date | Optional | 2019-31-03 | The old sale start date available before your import |
| price | Required | 90 | The new price available after your import |
| sale_price | Optional | same_day | The new sale price would be available after your import. |
| sale_start_date | Optional | 2019-15-03 | The date you need to import as the newest update for the sale start. |
| sale_end_date | Optional | 2019-31-03 | The date you need to import as the newest update for the sale end. |
Best practices and tips
Please note that we do not allow price changes of more than 30% in a single import file. All imports go through an additional check at noon, and any price update above 30% will be verified with you via email. If you need to update a SKU price by more than 30%, please follow these steps:
First, update the price with less than 30% difference.
After the update is processed, import the same SKU again with the remaining price change.
Some columns require certain formatting. For example, "sale_start_date" indicates the starting date in the following format(2019-30-12, YYYY-DD-MM)
- 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.
You might find extra columns when you download the sample template, like X_noon_sku, Noon_warehouse_code, etc., those are optional fields and you can learn more about all fields from the help center.
Common errors
That’s it!
Got more questions?
Contact us at seller@noon.com
Related Articles
Partner SKU price range import
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 ...Partner SKU FBP stock update import
This guide provides a comprehensive overview of the Partner SKU FBP stock update import process. It's designed to assist sellers in efficiently updating stock for items stored in warehouses operating under the FBP model. The guide covers the use of ...Partner SKU rename import
This feature allows you to rename your existing partner_sku without needing to delete it, in case it was named incorrectly or requires updating. Follow this guide for a smooth, successful import process, covering the import columns and step-by-step ...Partner SKU delete import
This import enables you to delete your own existing partner_sku, in case you don't need it any more. In this article we will help you ensure a successful and effective import through walking through the import columns and step by step to delete your ...Price & Inventory Management Comprehensive Overview
This guide is created to take you through a structured journey, focusing on two of the most critical aspects of online retailing: pricing and inventory management. From establishing a robust pricing strategy to optimizing your inventory for peak ...