Item Import

Created by Migration Bot, Modified on Fri, 23 Oct at 11:21 AM by Migration Bot

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.xls

This 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article