The Secure File Transfer Protocol allows you to transfer you data related to your product prices and stock quantities from your Enterprise Resources Planning (ERP) to your noon store. Once you complete the Secure File Transfer Protocol Activation, you can start using it to transfer your data as explained in this article.

How to use the SFTP?

• First step to whitelist the noon IP addresses.
• We identify the file based on the folder path so you can use any file name as per your standard terminology, hence no special names are required.
• The maximum size limit for a file is 20 MB. We allow CSV, TSV and XLSX file formats. For TSV files there is no row limit but for XLSX file we have a row limit of 20000, for CSV limit is 150K rows, due to file size limit
• Once imported we delete the original file from the folder, this is done to avoid re-processing of the same files.
• Files can be imported at the mentioned frequencies: 30 minutes, 1 hour, 3 hours, 6 hours, 12 hours daily; you will need to set up the frequency in the Seller Lab. This can be easily modified from Seller Labs as and when needed.
• All the original files and error logs can be accessed from Seller Lab as follows:

Seller Labs > Catalog> Imports

Templates used in importing the price and stock:

A. Template for Stock Imports

Field	Type	Comment
id_partner	Mandatory	Your partner ID on Noon
country_code	Mandatory	‘ae’ for UAE, ‘sa’ for KSA, ‘eg’ for Egypt
partner_sku	Mandatory	The unique sku code for each item your catalog
partner_warehouse_code	Mandatory	The warehouse code created with Noon
stock_gross	Mandatory	The count of the gross stock at your warehouse for the corresponding partner_sku
processing_time	Optional	Time it will take for the stock to be available at Seller Warehouse

B. Template for Price Imports

Field	Type	Comment
id_partner	Mandatory	Your partner ID on Noon
country_code	Mandatory	‘ae’ for UAE, ‘sa’ for KSA, ‘eg’ for Egypt
partner_sku	Mandatory	The unique sku code for each item your catalog
price	Mandatory	The price/MSRP of the sku
sale_price	Optional	The offer price in case the sku is on offer
sale_start_date	Optional	Offer price start date
sale_end_date	Optional	Offer price end date

 

Seller Lab Setup Details

Step1: Use the SFTP link to view the page on Seller Lab

KSA	SFTP link here
UAE	SFTP link here
EGP	SFTP link here

Step2: Add the protocol: SFTP by default, hostname, port, username and password. The connection name can be generic like your Partner ID on noon or your Company name.

Step 3: Choose the imports and then add the folder path, frequency and then save.

For example choose

1. Cross-dock stock update
2. Add the folder path - like “/Imports/stockfile”
3. Choose the frequency from the dropdown
4. Save 

How To Handle Common Errors?

Incase of Sale, the below errors can be reflected:

• "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 make sure that the sale_price is less than the price.

• "Sale start date is not greater than the sale end date."

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

• "Cannot update price by more than 30%"

Please make sure that the updated price is not more or not less than the previous price by 30%. For example if your current price is 100 AED then make sure the updated price is more than 70 AED and less than 130 AED.

• "Invalid partner_SKU"

This means that the imported SKU is not cataloged with Noon. Please add the sku in the catalog and then import the file.

 

That's it!

 

Got more questions? 

Contact us at automation@noon.com