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

- Click on Catalog, then click My Catalog.


- Click on the Edit price button to modify your price in the quick view.



- In the pop-up that appears, update the price and click on Save Changes to update the price. 


- You can also click on the SKU and update the price in the offer section.


- Select the pricing method and update the price for the SKU. Any changes made to your offer will reflect immediately on the noon website.  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. If the Sale Price is added, it will take priority over your Price during its campaign. Click on Save to update the price.


Bulk Price Update Steps

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

-  Click on the Catalog and then select Imports.


- Then click on Add Imports.
 


- Select Price as ‘Import Type’ then select Price Update as ‘Sub Type.’  To help you identify which SKUs to update, you can select between those that are Not Live or those that are Live under ‘Status’. You can then select your ‘Marketplace’ as noon.

 



- Click Export Template to download the document.
 
- You can check the instructions and requirements for the details to be filled on the sheet on the Seller Lab. 


Info
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

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.

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

Today3.png

- Once the sheet is ready, go back to the Seller Lab and click on Next 


- In the next step, upload the sheet from the device and then click on Submit.


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

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

    • Increase Your Sales with the Price Engine

      Now you can effortlessly go head to head against the competition! Just sit back and let the noon Price Engine take care of the fierce pricing battles of e-commerce. What Is a Price Engine? The price engine is a price optimization software that saves ...

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