All Collections
Inventory Planner basics
Bulk upload non-replenishable status
Bulk upload non-replenishable status
Jasper avatar
Written by Jasper
Updated over a week ago

If you need to set several SKUs as non-replenishable and have that information in a spreadsheet, you can bulk upload the information to Inventory Planner.

Important note: Replenishable status applies account-wide across all connections and cannot be specified by location.

In your spreadsheet, add column headers indicating which are SKUs and which is the replenishment status. If you do not add headers, the first product in your list will not import correctly. In the replenishment column, add 'True' or '1' to indicate that an item is non-replenishable.
(Note: If you wish to use the same process to reverse this setting, you can set this column value to be "False" or "0", to set items as being Replenishable)

In the Replenishment screen, select Import > Variant settings.

You can see the available columns listed on the bottom of the import section.

(We also offer the ability to download a CSV template, with the available columns for adjustment)

When your CSV file is prepared and ready, you can drag the file to the import section, or click to select your file.

Once Uploaded, proceed by using the option to Map Columns.

You will be taken to a field mapping screen, where you can check and confirm the columns on the file are mapped to the desired settings.

Click 'Import' to complete the import.

You will then see an import summary screen, that will confirm changes or if any errors were experienced during the import.

If you have any concerns, please reach to us using the in-app support chat.

Did this answer your question?