Secure File Transfer Protocol Guidelines

Secure File Transfer Protocol Guidelines

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

FieldTypeComment
id_partnerMandatoryYour partner ID on Noon
country_codeMandatory‘ae’ for UAE, ‘sa’ for KSA, ‘eg’ for Egypt
partner_skuMandatoryThe unique sku code for each item your catalog
partner_warehouse_codeMandatoryThe warehouse code created with Noon
stock_grossMandatoryThe count of the gross stock at your warehouse for the corresponding partner_sku
processing_timeOptionalTime it will take for the stock to be available at Seller Warehouse

B. Template for Price Imports

FieldTypeComment
id_partnerMandatoryYour partner ID on Noon
country_codeMandatory‘ae’ for UAE, ‘sa’ for KSA, ‘eg’ for Egypt
partner_skuMandatoryThe unique sku code for each item your catalog
priceMandatoryThe price/MSRP of the sku
sale_priceOptionalThe offer price in case the sku is on offer
sale_start_dateOptionalOffer price start date
sale_end_dateOptionalOffer price end date

Seller Lab Setup Details

Step1: Use the SFTP link to view the page on Seller Lab
KSA SFTP link here
UAESFTP link here
EGPSFTP link here

mceclip2.png

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.

mceclip3.png

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 

mceclip4.png

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




    • Related Articles

    • Secure File Transfer Protocol Activation

      Price and stock management have just become much easier. noon offers you assistance with the Secure File Transfer Protocol (SFTP), an automation tool to securely transfer any price and stock quantity updates made on your company systems directly into ...
    • Product packing guidelines - FBN

      Signed up and ready to send us your products? Yalla! It is extremely important that the following guidelines are followed when preparing your products for transfer to a noon warehouse facility. Products with non-compliant packaging may get rejected ...
    • Packing Guidelines for DirectShipping

      This comprehensive guide outlines Noon’s packing guidelines for DirectShipping, ensuring the safe transit and delivery of products to customers. Adhering to these guidelines is vital for maintaining Noon's commitment to quality and customer ...
    • Content Guidelines for Product Listing for Home Category

      The following are the basic guidelines that need to be followed to complete your products' listing through a smooth process. The below guidelines are divided as per different product types under the Home Products category, this to ensure that your ...
    • Essential Guidelines For Bulky DirectShip Selling Model

      The Bulky DirectShip selling model is an initiative by Noon to uphold service quality and business integrity. This model, designed for items not requiring direct installation from the seller, sellers should follow specific guidelines to ensure an ...