Skip to main content
When you receive new stock and need to update its details, you can import the Stock Attribute file via SFTP. This file lets you change descriptions, dates, and FIFO information for existing stock.
Template: standard_stock_attributes_update_import_template.csv — download it, fill in your data, and upload it via SFTP.
1

Understand the stock attribute file

The file includes the following fields:
FieldTypeMandatoryDescription
storage_unit_referenceStringYesUnique code for the storage unit holding the stock
string1 - 5StringYesVarious stock attributes to update
stock_descriptionStringYesDescription of the stock to change
datetime1 - 5StringYesDates related to each stock line
fifo_dateStringNoExpiry date of the stock
2

Match storage unit references

Ensure the storage_unit_reference you enter matches the reference of the stock you want to update. This is how the system identifies the correct stock for changes.
3

Fill in the attribute information

  • string1 - 5: Update specific attributes of your stock
  • stock_description: Enter the updated description
  • datetime1 - 5: Provide the relevant dates for each stock line
  • fifo_date: Update the FIFO date if needed
4

Save and upload the file

Save the file and upload it to the system using SFTP.

​
Frequently asked questions

It uniquely identifies the stock, ensuring changes are applied to the correct items.
The storage_unit_reference, string1-5, stock_description, and datetime1-5 fields are mandatory. The fifo_date is optional.
Yes, you can update descriptions, dates, and FIFO information in a single file import.
Use the format required by your system settings, typically yyyy-mm-dd.