Partner SKU price update import

Partner SKU price update import

This import allows you to bulk update price, sale price, sale start date and sale end dates for your items on noon.com.

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

1.  Go to your Seller Lab Go to Catalog then click Partner Catalog

2. Click on any product to modify your price. 


3. Add your Price -  this is the price of the product that will appear to customers on the website. Any changes made to your offer will reflect immediately on the noon website.

4. If you would like to add a Sale Price, you may also add this on the page with the necessary start and end dates for how long you would like the Sale Price to be live for. If Sale Price is added, it will take priority over your Price in the duration of its campaign.

    Bulk Price Update Steps

This is a step by step process of updating prices of a bunch of your SKUs in one go. 

 Go to your Seller Lab > Go to Catalog > Go to Imports > Click Add Import on the top right of the page


1. Select Price as ‘Import Type’ > Select Price Update as ‘Sub Type’ 

2. To help you identify which SKUs to update, you can select between those that are Not Live or those that are Live under ‘Status’ 

3. You can then select your ‘Marketplace’ as noon

4. Click Request Export to download the document.

  

The provided export document helps give context on your Price, Sale Price and other information relevant to pricing your SKUs at noon. You can use this document to make changes to your pricing.

1. To update the price of your SKU, use the price column and add your new price

2. To add or update a sale price for your SKU, use the sale_price, sale_start_date and sale_end_date columns to add the price and the duration of your sale campaign. The dates should be updated in the following format (2035-31-12, YYYY-DD-MM).

3. Any columns that mention ‘current_x’ reflect values of the current pricing of your SKUs. All other columns are explained towards the end of this article.

4. As part of the export, you will see the following columns: x_noon_price_min and x_noon_price_max (also known as ‘global min/max’), as well as, x_seller_price_min and x_seller_price_max.

These columns are for guidance purposes only, sellers must ensure their price falls within the range shown, otherwise SKUs will not go live.

    1. The noon price min / max: this is a range set by noon to help sellers avoid setting vastly incorrect prices to their products by mistake. In case you would like to set your prices below the ‘x_noon_price_min’ please send an e-mail with the SKUs and their respective prices to seller@noon.com to grant your approval of the lower prices.

    2. The seller price min / max: this is an optional range that you as a seller can set for your SKUs to ensure that your price does not go live unless it is within these guardrails. To update your seller price min / max, do it through your Catalog page or through Partner SKU Price Range importer.

5. Finally, upload your updated file to the same Imports but clicking through to Start Import (New Workflow) on the page you downloaded the excel file from. The file can be uploaded or pasted and the file type must be the following: xlsx, TSV and CSV.


6. After clicking
Submit, track the status of your Import in the Imports' status page to make sure your file has gone through without errors. If successful, your prices should reflect within a few minutes.


NotesNote: If your file has too many rows, it may take some time to process.

Today3.png

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 have exported. Your available products will be different depending on the country selected.

id_partner

Required

1455

Your unique partner ID that identifies your account and your products.

partner_sku

Optional

ashar2

The name you have assigned your SKU.

psku_code

Optional

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 assigned your SKU.

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 current price of your SKU, if it exists.

current_sale_price

Optional

800

The current sale price on your SKU, if it exists.

current_sale_start_date

Optional

2019-21-03

The current sale start date on your SKU, if it exists.

current_sale_end_date

Optional

2019-31-03

The current sale end date on your SKU, if it exists.

price

Required

90

The (new) price you want your SKU to reflect.

sale_price

Optional

same_day

The sale price you want your SKU to reflect, if needed.

sale_start_date

Optional

2019-15-03

The sale start date you want your SKU’s sale price to reflect on. Only include if sale_price is added. 

sale_end_date

Optional

2019-31-03

The sale end date you want your SKU’s sale price to stop reflecting on. Only include if sale_price is added. 

Best practices and tips

Calculate the price difference 

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:

  1. First, update the price with less than 30% difference.

  2. After the update is processed, import the same SKU again with the remaining price change.

Check the format within columns

Some columns require certain formatting. For example, "sale_start_date" indicates the starting date in the following format(2019-30-12, YYYY-DD-MM)

For small updates use the paste feature 
If you are only making a small update (less than 500 rows) you can paste the values directly into the import and submit. That way you won't have to worry about file formats

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.

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 

In case of a sale, the sale price is higher than the price
This usually occurs if the sale is present and you update the price instead of the sale_price, in order to solve this, just export the price update, and fill only the sale_price column making sure it's less than the price.

Sale start date is not greater than the sale end date
Please make sure if the sale start and end dates are present, that the sale end is greater than the sale start, and both are following the right format (YYYY-DD-MM).

 


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 ...