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 the upload template, step-by-step instructions, best practices, and tips for a successful stock update.

Step by Step walkthrough

Access the import feature through the Catalog then Imports section on your dashboard.
Initiate a new import and select 'stock' as the main type, and 'FBP stock update' as the sub-type.
Customize your export based on warehouse selection, download it, and proceed to the next step.
Import your file either by drag-and-drop or by copying and pasting data into the Paste tab.
Submit your import after the green loading bar appears.
Track the status of your import on the imports page; once processed, your updates are in place.
Be aware that processing may take some time for files with numerous updates; refresh the page as needed to check the status.

The Upload Template:

Here is a brief about all the columns you would need in your import file

Column Header	Definition
country_code	The country for which you've exported. Your available products will be different depending on country selected
id_partner	Your unique partner id that identifies your account and your products
partner_sku	The SKU you assign yourself to each and single one of your product Or The unique sku for each item your catalog
psku_code	This code is generated as soon as you create your own partner_sku. 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_sku_child	Applied to Seller SKUs - Whenever you’re creating variants you distinguish between parent and child SKUs. Child one contains the content that applies to that specific variant only - for now this is only the attribute for size.
noon_warehouse_code	The warehouse code created with Noon.
x_noon_title	Product title as listed on noon.
x_noon_brand	Brand name of the product.
current_stock_gross	Current stock quantity available at the warehouse.
current_processing_time	Time required by the seller to process the order
x_stock_status	Internal status indicating if stock is active ,available or not or blocked.
stock_gross	The count of the stock which you want to update against the partner_sku.
processing_time	Time it will take for the stock to be available at Seller Warehouse

Best Practices and Tips:

Ensure correct formatting within columns, especially for "Processing_Time".
For smaller updates (less than 500 rows), use the paste feature directly in the import tool.
Save your file in XLSX or CSV format; XLS files are not compatible.
Use Unicode Text encoding when saving your file to ensure compatibility.

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

A frequent issue is mismatched Psku_code and Partner SKU, often due to all-numeric SKUs or special characters. This can be resolved by deleting the partner sku column or importing using only the psku_code.
Avoid saving the file post-download; directly pasting the values can prevent issues.

That’s it!

Got questions?