This import allows you to mass update stock for items stored in your warehouses operating on the FBP model.

This article will help you to ensure a successful import walking you through the template and a step by step guide along with best practices and tips.

The upload 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		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_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
noon_warehouse_code	Optional	W00000001A	The identifier of which noon warehouse where your products located
Partner_Warehouse_Code	Required	1805	Your warehouse code if you've chosen to assign one.
current_stock_gross	Optional	1	The old stock available before your import
current_processing_time	Optional	2_days	The old processing time available before your import
Stock_Gross	Required	90	The new stock available after your import
Processing_Time	Optional	same_day	The new processing time available after your import.

 

Best practices and tips

Check the format within columns

Some columns require certain formatting. For example, "Processing_Time" indicates duration in days as following (same_day,1_day,2_days,3_days,4_days)

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.

 

If you have set a default processing time value for your warehouse you do not need to update processing time in this import. For details on how to set a default read this article here

List each item on its own row Each row in your xlsx/CSV file must represent a single product and a warehouse location, 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 

The psku_code and the partner SKU are not matching 

This usually occurs when your partner SKU contains all numbers or special characters. In order to solve this issue after you have prepared your import, you can delete the partner sku column or just import against psku_code.

Alternatively not saving the file after download and just pasting in the values can prevent issues.

 

Step by step walkthrough

1- From your dashboard (Home) left menu, select Catalog then Imports

2- From the import status page, choose New Import at the top left of the page

 

3-In main type select stock, and in sub-type select FBP stock update 

4- Customize your export by choosing one of your warehouses or choose no warehouses to export all the partner_SKUs which are not assigned to any warehouse.

5- Download your customized export and press next at the right bottom of the page

 

4-Now you can import your file through

-Drag & drop

 

- Copy and paste the data in the Paste tab

6-After you get a green loading bar, please press submit at the right bottom.

7- Then you can track the status of your import in the imports 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 our button at the top right until you get your file processed.