Originally written by John Hardwick, last updated Oct 25, 2023, on the Swan Retail knowledge base (FRS).
Part of: Product Creator - v1207
This tab holds any attributes used in SwanFRS and is used as a look-up for the attribute’s choice lists on the Items tab.
When imported automatically from SwanFRS this tab becomes a look-up tab - i.e., no alterations are possible.
Attributes are system-wide choices and therefore this tab could be replicated in all spreadsheets, only setting the attributes applicable to the catalogue within the Items tab.
|
Field |
Comments |
|
Look up code |
This field will produce a warning if one or more of the cells in the row would cause a problem when loaded into SwanFRS. Duplicate indicates a repeated Attribute |
|
Attribute Code |
There are two options. Create an attribute group name for selection within the Items tab with the value being keyed specifically for that item. Set an attribute group and value. Separating the group and value with a pipe symbol (|). Any value set against this code is ignored. This option allows for speedy selection of commonly used attributes. E.g., ‘Size | Small’ creates the attribute code of Size and a value of Small. |
The import process will automatically create new attributes, where associated with a SKU.
It is suggested that the table is sequenced alphabetically, this makes picking the attribute and value easier within the Items tab
When linking to a Swan website, the following attributes may be of use.
Examples of use are: -
|
Attribute Name |
Value |
Details |
|
Promotion_Colour |
Hex value |
A hexadecimal value corresponding to the colour of the banner. Consult with your web team re the correct value to use. |
|
Promotion_Name |
Free format narrative |
A ‘banner’ title indicating the product is the subject of a special price – E.g., ON SALE |
Note: The following list of Attributes have specific columns in the spreadsheet and do not need setting up. If used more than once per SKU, they will cause the load to fail.
|
Attribute Name |
Value |
Details |
|
Brand |
Free format narrative |
Used when sending data to a linked website – used in product grouping |
|
Commodity Code |
Free format narrative |
Displays on the Purchase order when importing / exporting goods (from Europe) |
|
Is_Reorderable |
1 or 0 |
Used when sending data to a linked website – controls whether only stock items can be sold. |
|
PO_Label |
1 or 0 |
Setting to 1 instructs the PO print routine to include a stock label which can be sent to the supplier for them to attach to the product prior to shipping. |
|
Product_Upsells |
SKU, SKU, SKU |
A list of SKUs separated by commas instructing the web to suggest the customer purchases with their chosen item. |
|
Promotion_Colour |
Hex value |
A hexadecimal value corresponding to the colour of the banner. Consult with your web team re the correct value to use. |
|
Shipping_Class |
Free format text – no spaces |
Used to instruct the website of advanced delivery rules – please discuss with your web consultant. |
|
Ticket_Size |
Integer |
This attribute is designed to inform the ticket engine as to the size of label to be used for this stock item. |
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