Originally written by Will Miller, last updated Nov 22, 2024, on the Swan Retail knowledge base (SRS).
Part of: Item Import and Item Export Overview
Setting up items in SRS is one of the biggest tasks when initially setting up a system and a major maintenance task ongoing. The Item Import and Export programs can allow you to take advantage of details from suppliers and the Excel skills of your staff to make that maintenance as quick as possible.
Please refer to your account manager or project manager for guidance on the setup of items for your industry.
It is advisable to set up a few typical items within SRS Item Maintenance and then export them to get a clear idea of the structure for this import.
This template includes guidance on how to use it along with some sample data.
Columns that are not needed can be deleted provided the mandatory (Yellow) columns are left in.
SampleItemImport.xlsThis template can be used to import items from SRS v6.3 onwards.
Mandatory Fields
For New items on import, these are:
ProductType
Description
Measure → Not mandatory from patch 7.4-67 onward (Nov 19th 2024), only required if you’re creating items with a measure other than ‘Quantity’.
DepartmentCode
SupplierCode → Not mandatory for Non-stock, Composite or Meal items.
LeadTime
VATCode
SellingPrice
PackSize
PackCostCurrency
LastUnitCost → Formerly LastCostPrice
If updating an existing item, a primary identifier is also mandatory so SRS can find the item to update. One of the following:
ItemCode → Primary ID, can be used to then update AlternateItemCode or Barcode.
AlternateItemCode
Barcode
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article