10. Data Fields (within Import-Export)

Created by Migration Bot, Modified on Wed, 21 Oct at 12:30 PM by Migration Bot

Originally written by John Hardwick, last updated Jul 27, 2026, on the Swan Retail knowledge base (FRS).

Part of: Product Creator - v1214

This document relates to spreadsheet version 1214.1.00 onwards

This document details the ‘pre-set’ fields used within the spreadsheet.

When exporting data column headers will be set with the following names.

When import the column must have a header matching one of the fields specified below.

It is not possible to mix data types within the same load structure.

Import / Export Data fields

The table below details the export / import variables available and the data format the field must adhere to to be imported back into the spreadsheet.

All data sets must contain the Key Field and where appropriate the Secondary Key. These fields are needed to ensure the correct record is located prior to updating order associated data elements.

If a record is not found, with the exception of SKUs the Key Field and where appropriate the Secondary Key fields are then used to populate the new data ‘row’.
The Data Set and Column Title are used for field mapping, any mismatch will result in the column being ignored by the import process.
Fields marked with a comment of Export Only cannot be imported back into the spreadsheet.
Validly imported fields will result in a green background in the ‘source data', rejected fields will have a red background. Where no data change occurs a yellow background will be displayed with ignored and key fields retaining a white background.
When importing Item Pricing via the Items Pricing Tab, any single Key Field may be used
It is suggested that an export of the appropriate dataset is created to obtian the ‘specific format’ of the column header. This may then be used as the reference for edited data when importing back into the spreadsheets. (certain columns have carriage returns embedded within the field header).

Fields are listed in alphabetical Column Title sequence within Data Set. They can be imported in any sequence subject to having the appropriate key fields.

Data Set	Column Title	Data Type	Comments
Choice Attributes	OptionChoice	Alphanumeric - Max 100 Characters	Key Field
Choice Attributes	Attribute	Alphanumeric - Max 100 Characters	Secondary Key
Choice Attributes	Value	Alphanumeric - Max 100 Characters
Choice Links	Option	Alphanumeric - Max 50 Characters	Key Field
Choice Links	Choice Description	Alphanumeric - Max 100 Characters	Secondary Key
Choice Links	Link To	Integer Value
Choice Links	Sequence	Integer Value
Choice Options	OptionChoice	Alphanumeric - Max 100 Characters	Key Field
Choice Options	Opt01	Alphanumeric - Max 50 Characters
Choice Options	Opt02	Alphanumeric - Max 50 Characters
Choice Options	Opt03	Alphanumeric - Max 50 Characters
Choice Options	Opt04	Alphanumeric - Max 50 Characters
Choice Options	Opt05	Alphanumeric - Max 50 Characters
Choice Options	Opt06	Alphanumeric - Max 50 Characters
Choice Options	Opt07	Alphanumeric - Max 50 Characters
Choice Options	Opt08	Alphanumeric - Max 50 Characters
Choice Options	Opt09	Alphanumeric - Max 50 Characters
Choice Options	Opt10	Alphanumeric - Max 50 Characters
Choice Options	Opt11	Alphanumeric - Max 50 Characters
Choice Options	Opt12	Alphanumeric - Max 50 Characters
Choice Options	Opt13	Alphanumeric - Max 50 Characters
Choice Options	Opt14	Alphanumeric - Max 50 Characters
Choice Options	Opt15	Alphanumeric - Max 50 Characters
Choice Options	Opt16	Alphanumeric - Max 50 Characters
Choice Options	Opt17	Alphanumeric - Max 50 Characters
Choice Options	Opt18	Alphanumeric - Max 50 Characters
Choice Options	Opt19	Alphanumeric - Max 50 Characters
Choice Options	Opt20	Alphanumeric - Max 50 Characters
Choice Options	Opt21	Alphanumeric - Max 50 Characters
Choice Options	Opt22	Alphanumeric - Max 50 Characters
Choice Options	Opt23	Alphanumeric - Max 50 Characters
Choice Options	Opt24	Alphanumeric - Max 50 Characters
Choice Options	Opt25	Alphanumeric - Max 50 Characters
Choice Options	Opt26	Alphanumeric - Max 50 Characters
Choice Options	Opt27	Alphanumeric - Max 50 Characters
Choice Options	Opt28	Alphanumeric - Max 50 Characters
Choice Options	Opt29	Alphanumeric - Max 50 Characters
Choice Options	Opt30	Alphanumeric - Max 50 Characters
Choice Options	Opt31	Alphanumeric - Max 50 Characters
Choice Options	Opt32	Alphanumeric - Max 50 Characters
Choice Options	Opt33	Alphanumeric - Max 50 Characters
Choice Options	Opt34	Alphanumeric - Max 50 Characters
Choice Options	Opt35	Alphanumeric - Max 50 Characters
Choice Options	Opt36	Alphanumeric - Max 50 Characters
Choice Options	Opt37	Alphanumeric - Max 50 Characters
Choice Options	Opt38	Alphanumeric - Max 50 Characters
Choice Options	Opt39	Alphanumeric - Max 50 Characters
Choice Options	Opt40	Alphanumeric - Max 50 Characters
Choice Options	Opt41	Alphanumeric - Max 50 Characters
Choice Options	Opt42	Alphanumeric - Max 50 Characters
Choice Options	Opt43	Alphanumeric - Max 50 Characters
Choice Options	Opt44	Alphanumeric - Max 50 Characters
Choice Options	Opt45	Alphanumeric - Max 50 Characters
Choice Options	Opt46	Alphanumeric - Max 50 Characters
Choice Options	Opt47	Alphanumeric - Max 50 Characters
Choice Options	Opt48	Alphanumeric - Max 50 Characters
Choice Options	Opt49	Alphanumeric - Max 50 Characters
Choice Options	Opt50	Alphanumeric - Max 50 Characters
Choice Pricing	Achieved Margin	Decimal (2 Decimal places)	Export Only
Choice Pricing	Landed Cost (cost X + Anc's)	Decimal (2 Decimal places)	Export Only
Choice Pricing	Selling price to achieve margin	Decimal (2 Decimal places)	Export Only
Choice Pricing	Choice Code	Alphanumeric - Max 50 Characters	Key Field
Choice Pricing	Option / Choice	Alphanumeric - Max 50 Characters	Key Field
Choice Pricing	Ancillary Cost 1	Decimal (2 Decimal places)
Choice Pricing	Ancillary Cost 2	Decimal (2 Decimal places)
Choice Pricing	Ancillary Cost 3	Decimal (2 Decimal places)
Choice Pricing	Ancillary Cost 4	Decimal (2 Decimal places)
Choice Pricing	Ancillary Cost 5	Decimal (2 Decimal places)
Choice Pricing	Cost_1	Decimal (2 Decimal places)
Choice Pricing	Cost_2 (Alt Cost)	Decimal (2 Decimal places)
Choice Pricing	Currency Cost	Decimal (2 Decimal places)
Choice Pricing	Retail (MSRP)	Decimal (2 Decimal places)
Choice Pricing	Sell_1	Decimal (2 Decimal places)
Choice Pricing	Sell_2	Decimal (2 Decimal places)
Choice Pricing	Sell_3	Decimal (2 Decimal places)
Choice Pricing	Web Price	Decimal (2 Decimal places)
Choice Pricing	Workzone1	Decimal (2 Decimal places)
Choice Pricing	Workzone2	Decimal (2 Decimal places)
Choice Pricing	Workzone3	Decimal (2 Decimal places)
Choice Pricing	Workzone4	Decimal (2 Decimal places)
Choice Pricing	Workzone5	Decimal (2 Decimal places)
Choice Pricing	Workzone6	Decimal (2 Decimal places)
Choices	Achieved Margin	Decimal (2 Decimal places)	Export Only
Choices	Landed Cost (cost X + Anc's)	Decimal (2 Decimal places)	Export Only
Choices	Selling price to achieve margin	Decimal (2 Decimal places)	Export Only
Choices	Option	Alphanumeric - Max 50 Characters	Key Field
Choices	Choice Code	Integer Value	Secondary Key
Choices	Ancillary Cost 1	Decimal (2 Decimal places)
Choices	Ancillary Cost 2	Decimal (2 Decimal places)
Choices	Ancillary Cost 3	Decimal (2 Decimal places)
Choices	Ancillary Cost 4	Decimal (2 Decimal places)
Choices	Ancillary Cost 5	Decimal (2 Decimal places)
Choices	Cost 1	Decimal (2 Decimal places)
Choices	Cost 2	Decimal (2 Decimal places)
Choices	Currency Cost	Decimal (2 Decimal places)
Choices	Description	Alphanumeric - Max 100 Characters
Choices	Disc Date	Date
Choices	Lead Time	Integer Value
Choices	Option Choice Image	Alphanumeric - Max 100 Characters
Choices	Retail (MSRP)	Decimal (2 Decimal places)
Choices	Sell 1	Decimal (2 Decimal places)
Choices	Sell 2	Decimal (2 Decimal places)
Choices	Sell 3	Decimal (2 Decimal places)
Choices	Sequence	Integer Value
Choices	Web Price	Decimal (2 Decimal places)
Choices	Workzone 1	Decimal (2 Decimal places)
Choices	Workzone 2	Decimal (2 Decimal places)
Choices	Workzone 3	Decimal (2 Decimal places)
Choices	Workzone 4	Decimal (2 Decimal places)
Choices	Workzone 5	Decimal (2 Decimal places)
Choices	Workzone 6	Decimal (2 Decimal places)
Item Attributes	SKU	Alphanumeric - Max 50 Characters	Key Field
Item Attributes	Attribute	Alphanumeric - Max 100 Characters	Secondary Key
Item Attributes	Value	Alphanumeric - Max 100 Characters
Item Images	SKU	Alphanumeric - Max 50 Characters	Key Field
Item Images	Image path / name	Alphanumeric - Max 255 Characters
Item Images	Sequence	Integer Value
Item Options	SKU	Alphanumeric - Max 50 Characters	Key Field
Item Options	Opt01	Alphanumeric - Max 50 Characters
Item Options	Opt02	Alphanumeric - Max 50 Characters
Item Options	Opt03	Alphanumeric - Max 50 Characters
Item Options	Opt04	Alphanumeric - Max 50 Characters
Item Options	Opt05	Alphanumeric - Max 50 Characters
Item Options	Opt06	Alphanumeric - Max 50 Characters
Item Options	Opt07	Alphanumeric - Max 50 Characters
Item Options	Opt08	Alphanumeric - Max 50 Characters
Item Options	Opt09	Alphanumeric - Max 50 Characters
Item Options	Opt10	Alphanumeric - Max 50 Characters
Item Options	Opt11	Alphanumeric - Max 50 Characters
Item Options	Opt12	Alphanumeric - Max 50 Characters
Item Options	Opt13	Alphanumeric - Max 50 Characters
Item Options	Opt14	Alphanumeric - Max 50 Characters
Item Options	Opt15	Alphanumeric - Max 50 Characters
Item Options	Opt16	Alphanumeric - Max 50 Characters
Item Options	Opt17	Alphanumeric - Max 50 Characters
Item Options	Opt18	Alphanumeric - Max 50 Characters
Item Options	Opt19	Alphanumeric - Max 50 Characters
Item Options	Opt20	Alphanumeric - Max 50 Characters
Item Options	Opt21	Alphanumeric - Max 50 Characters
Item Options	Opt22	Alphanumeric - Max 50 Characters
Item Options	Opt23	Alphanumeric - Max 50 Characters
Item Options	Opt24	Alphanumeric - Max 50 Characters
Item Options	Opt25	Alphanumeric - Max 50 Characters
Item Options	Opt26	Alphanumeric - Max 50 Characters
Item Options	Opt27	Alphanumeric - Max 50 Characters
Item Options	Opt28	Alphanumeric - Max 50 Characters
Item Options	Opt29	Alphanumeric - Max 50 Characters
Item Options	Opt30	Alphanumeric - Max 50 Characters
Item Options	Opt31	Alphanumeric - Max 50 Characters
Item Options	Opt32	Alphanumeric - Max 50 Characters
Item Options	Opt33	Alphanumeric - Max 50 Characters
Item Options	Opt34	Alphanumeric - Max 50 Characters
Item Options	Opt35	Alphanumeric - Max 50 Characters
Item Options	Opt36	Alphanumeric - Max 50 Characters
Item Options	Opt37	Alphanumeric - Max 50 Characters
Item Options	Opt38	Alphanumeric - Max 50 Characters
Item Options	Opt39	Alphanumeric - Max 50 Characters
Item Options	Opt40	Alphanumeric - Max 50 Characters
Item Options	Opt41	Alphanumeric - Max 50 Characters
Item Options	Opt42	Alphanumeric - Max 50 Characters
Item Options	Opt43	Alphanumeric - Max 50 Characters
Item Options	Opt44	Alphanumeric - Max 50 Characters
Item Options	Opt45	Alphanumeric - Max 50 Characters
Item Options	Opt46	Alphanumeric - Max 50 Characters
Item Options	Opt47	Alphanumeric - Max 50 Characters
Item Options	Opt48	Alphanumeric - Max 50 Characters
Item Options	Opt49	Alphanumeric - Max 50 Characters
Item Options	Opt50	Alphanumeric - Max 50 Characters
Item Pricing	Achieved Margin	Decimal (2 Decimal places)	Export Only
Item Pricing	Landed Cost (cost X + Anc's)	Decimal (2 Decimal places)	Export Only
Item Pricing	Range / Collection Description	Alphanumeric - Max 80 Characters	Export Only
Item Pricing	Selling price to achieve margin	Decimal (2 Decimal places)	Export Only
Item Pricing	Barcode	Alphanumeric - Max 80 Characters	Key Field
Item Pricing	grid Seq.	Integer Value	Key Field
Item Pricing	Legacy	Alphanumeric - Max 80 Characters	Key Field
Item Pricing	line #	Integer Value	Key Field
Item Pricing	SKU	Alphanumeric - Max 50 Characters	Key Field
Item Pricing	Suppliers Model Number	Alphanumeric - Max 50 Characters	Key Field
Item Pricing	Ancillary Cost 1	Decimal (2 Decimal places)
Item Pricing	Ancillary Cost 2	Decimal (2 Decimal places)
Item Pricing	Ancillary Cost 3	Decimal (2 Decimal places)
Item Pricing	Ancillary Cost 4	Decimal (2 Decimal places)
Item Pricing	Ancillary Cost 5	Decimal (2 Decimal places)
Item Pricing	Cost_1	Decimal (2 Decimal places)
Item Pricing	Cost_2 (Alt Cost)	Decimal (2 Decimal places)
Item Pricing	Currency Cost	Decimal (2 Decimal places)
Item Pricing	Retail (MSRP)	Decimal (2 Decimal places)
Item Pricing	Sell_1	Decimal (2 Decimal places)
Item Pricing	Sell_2	Decimal (2 Decimal places)
Item Pricing	Sell_3	Decimal (2 Decimal places)
Item Pricing	Web Price	Decimal (2 Decimal places)
Item Pricing	Workzone1	Decimal (2 Decimal places)
Item Pricing	Workzone2	Decimal (2 Decimal places)
Item Pricing	Workzone3	Decimal (2 Decimal places)
Item Pricing	Workzone4	Decimal (2 Decimal places)
Item Pricing	Workzone5	Decimal (2 Decimal places)
Item Pricing	Workzone6	Decimal (2 Decimal places)
Item Relationships	SKU	Alphanumeric - Max 50 Characters	Key Field
Item Relationships	Relationship Description	Alphanumeric - Max 100 Characters	Secondary Key
Item Relationships	Upsell (SKU)	Alphanumeric - Max 50 Characters
Items	Achieved Margin	Decimal (2 Decimal places)	Export Only
Items	Landed Cost (cost X + Anc's)	Decimal (2 Decimal places)	Export Only
Items	Selling price to achieve margin	Decimal (2 Decimal places)	Export Only
Items	SKU	Alphanumeric - Max 50 Characters	Key Field
Items	line No	Integer Value	Secondary Key
Items	Range / Collection Description	Alphanumeric - Max 80 Characters	Secondary Key
Items	# of Seats	Integer Value
Items	Allocation on Despatch	Y or N
Items	Ancillary Cost 1	Decimal (2 Decimal places)
Items	Ancillary Cost 2	Decimal (2 Decimal places)
Items	Ancillary Cost 3	Decimal (2 Decimal places)
Items	Ancillary Cost 4	Decimal (2 Decimal places)
Items	Ancillary Cost 5	Decimal (2 Decimal places)
Items	B2B PO	Y or N
Items	Barcode	Alphanumeric - Max 80 Characters
items	Brand (web)	Y or N
Items	Commission Group	Alphanumeric - Max 1 Character
Items	Commodity Code	Alphanumeric - Max 100 Characters
Items	Cost_1	Decimal (2 Decimal places)
Items	Cost_2 (Alt Cost)	Decimal (2 Decimal places)
Items	Currency Cost	Decimal (2 Decimal places)
Items	Disc Date	Date
Items	Grid Seq.	Integer Value
items	Group_Product (Web)	Y or N
Items	Hierarchy 1	Alphanumeric - Max 20 Characters
Items	Hierarchy 2	Alphanumeric - Max 20 Characters
Items	Hierarchy 3	Alphanumeric - Max 20 Characters
Items	Hierarchy 4	Alphanumeric - Max 20 Characters
Items	Hierarchy 5	Alphanumeric - Max 20 Characters
Items	Hierarchy 6	Alphanumeric - Max 20 Characters
Items	Home Delivery	Y or N
Items	Include	Y or N
Items	Is Till Product	Y or N
Items	Lead Time	Integer Value
Items	Legacy System Code	Alphanumeric - Max 50 Characters
Items	Long Description	Alphanumeric - Max 50 Characters0
Items	Mask Separator	Alphanumeric - Max 50 Characters
Items	Max Stock Level	Integer Value
Items	Min Stock Level	Integer Value
Items	Number of Pieces	Integer Value
Items	Pack Description	Alphanumeric - Max 100 Characters
Items	Pack Size	Decimal (2 Decimal places)
Items	Packaged Cubic	Decimal (2 Decimal places)
Items	Part	Y or N
Items	PO Label	Y or N
Items	Product Group	Alphanumeric - Max 40 Characters
Items	Reorder Quantity	Integer Value
Items	Reorderable	Y or N
Items	Retail (MSRP)	Decimal (2 Decimal places)
Items	Retailer Description 1	Alphanumeric - Max 80 Characters
Items	Retailer Description 2	Alphanumeric - Max 80 Characters
Items	Retailer Description 3	Alphanumeric - Max 80 Characters
Items	Sales Department 1	Alphanumeric - Max 100 Characters
Items	Sales Department 2	Alphanumeric - Max 100 Characters
Items	Sales Department 3	Alphanumeric - Max 100 Characters
Items	Sell_1	Decimal (2 Decimal places)
Items	Sell_2	Decimal (2 Decimal places)
Items	Sell_3	Decimal (2 Decimal places)
Items	Serial Number	Y or N
items	Show Prices On Web	Y or N
Items	Spare 1	Alphanumeric - Max 50 Characters
Items	Spare 2	Alphanumeric - Max 50 Characters
Items	Spare 3	Alphanumeric - Max 50 Characters
Items	Spiff Margin controlled	Y or N
Items	Spiff Payment Value	Decimal (2 Decimal places)
Items	Suppliers Model Number	Alphanumeric - Max 50 Characters
Items	Ticket Sequence	Integer Value
Items	Ticket Size	Alphanumeric - Max 20 Characters
Items	TV	Y or N
Items	Unpackaged Depth	Decimal (2 Decimal places)
Items	Unpackaged Height	Decimal (2 Decimal places)
Items	Unpackaged Weight	Decimal (2 Decimal places)
Items	Unpackaged Width	Decimal (2 Decimal places)
Items	Uplift Percentage	Decimal (2 Decimal places)
Items	Web Colour	Alphanumeric - Max 100 Characters
Items	Web Orders	Y or N
Items	Web Price	Decimal (2 Decimal places)
Items	Web Re-Orderable	Y or N
Items	Web shop Description	Alphanumeric - Max 100 Characters
Items	Web shop End Date	Date
Items	Web shop Search Engine Optimisation	Alphanumeric - Max 100 Characters
Items	Web shop Shipping Class (web use only)	Alphanumeric - Max 100 Characters
Items	Web shop Start Date	Date
Items	Web shop Up Sell	Alphanumeric - Max 50 Characters
Items	Web Size	Alphanumeric - Max 100 Characters
Items	Workzone 1	Decimal (2 Decimal places)
Items	Workzone 2	Decimal (2 Decimal places)
Items	Workzone 3	Decimal (2 Decimal places)
Items	Workzone 4	Decimal (2 Decimal places)
Items	Workzone 5	Decimal (2 Decimal places)
Items	Workzone 6	Decimal (2 Decimal places)
Items	Block Auto Price	Y or N	I
Items	Is Warranty Item	Y or N
Items	Warranty Group	Alphanumeric - Max 200 Characters
Items	Web Promotion Name	Alphanumeric - Max 200 Characters
Items	Web Promotion Colour	Alphanumeric - Max 200 Characters
Matrix	Ticket Style	Alphanumeric - Max 50 Characters	Key Field
Matrix	Column Title 1	Alphanumeric - Max 20 Characters
Matrix	Column Title 2	Alphanumeric - Max 20 Characters
Matrix	Column Title 3	Alphanumeric - Max 20 Characters
Matrix	Column Title 4	Alphanumeric - Max 20 Characters
Matrix	Column Title 5	Alphanumeric - Max 20 Characters
Matrix	Column Title 6	Alphanumeric - Max 20 Characters
Matrix	Row Title 1	Alphanumeric - Max 20 Characters
Matrix	Row Title 2	Alphanumeric - Max 20 Characters
Matrix	Row Title 3	Alphanumeric - Max 20 Characters
Matrix	Row Title 4	Alphanumeric - Max 20 Characters
Matrix	Row Title 5	Alphanumeric - Max 20 Characters
Matrix	Row Title 6	Alphanumeric - Max 20 Characters
Matrix	SKU 1 1	Alphanumeric - Max 50 Characters
Matrix	SKU 1 2	Alphanumeric - Max 50 Characters
Matrix	SKU 1 3	Alphanumeric - Max 50 Characters
Matrix	SKU 1 4	Alphanumeric - Max 50 Characters
Matrix	SKU 1 5	Alphanumeric - Max 50 Characters
Matrix	SKU 1 6	Alphanumeric - Max 50 Characters
Matrix	SKU 2 1	Alphanumeric - Max 50 Characters
Matrix	SKU 2 2	Alphanumeric - Max 50 Characters
Matrix	SKU 2 3	Alphanumeric - Max 50 Characters
Matrix	SKU 2 4	Alphanumeric - Max 50 Characters
Matrix	SKU 2 5	Alphanumeric - Max 50 Characters
Matrix	SKU 2 6	Alphanumeric - Max 50 Characters
Matrix	SKU 3 1	Alphanumeric - Max 50 Characters
Matrix	SKU 3 2	Alphanumeric - Max 50 Characters
Matrix	SKU 3 3	Alphanumeric - Max 50 Characters
Matrix	SKU 3 4	Alphanumeric - Max 50 Characters
Matrix	SKU 3 5	Alphanumeric - Max 50 Characters
Matrix	SKU 3 6	Alphanumeric - Max 50 Characters
Matrix	SKU 4 1	Alphanumeric - Max 50 Characters
Matrix	SKU 4 2	Alphanumeric - Max 50 Characters
Matrix	SKU 4 3	Alphanumeric - Max 50 Characters
Matrix	SKU 4 4	Alphanumeric - Max 50 Characters
Matrix	SKU 4 5	Alphanumeric - Max 50 Characters
Matrix	SKU 4 6	Alphanumeric - Max 50 Characters
Matrix	SKU 5 1	Alphanumeric - Max 50 Characters
Matrix	SKU 5 2	Alphanumeric - Max 50 Characters
Matrix	SKU 5 3	Alphanumeric - Max 50 Characters
Matrix	SKU 5 4	Alphanumeric - Max 50 Characters
Matrix	SKU 5 5	Alphanumeric - Max 50 Characters
Matrix	SKU 5 6	Alphanumeric - Max 50 Characters
Matrix	SKU 6 1	Alphanumeric - Max 50 Characters
Matrix	SKU 6 2	Alphanumeric - Max 50 Characters
Matrix	SKU 6 3	Alphanumeric - Max 50 Characters
Matrix	SKU 6 4	Alphanumeric - Max 50 Characters
Matrix	SKU 6 5	Alphanumeric - Max 50 Characters
Matrix	SKU 6 6	Alphanumeric - Max 50 Characters
Option Attributes	OptionChoice	Alphanumeric - Max 100 Characters	Key Field
Option Attributes	Attribute	Alphanumeric - Max 100 Characters	Secondary Key
Option Attributes	Value	Alphanumeric - Max 100 Characters
Options	Description	Alphanumeric - Max 100 Characters	Key Field
Options	Option ID	Integer Value	Secondary Key
Options	Affect Prices	N, P or V
Options	Auto Expand	Y or N
Options	Include	Y or N
Options	Prompt Quantity	N, C or S
Options	SwanFRS Option Description	Alphanumeric - Max 50 Characters
Options	Text Option	Alphanumeric - Max 50 Characters
Price Points	Start Price	Alphanumeric - Max 50 Characters	Key Field
Price Points	End Price	Decimal (2 Decimal places)
Price Points	Price Point	Decimal (2 Decimal places)
Range	Range ID	Integer Value	Key Field
Range	Description	Alphanumeric - Max 60 Characters	Secondary Key
Range	Bullet 1	Alphanumeric - Max 20 Characters0
Range	Bullet 2	Alphanumeric - Max 20 Characters0
Range	Bullet 3	Alphanumeric - Max 20 Characters0
Range	Bullet 4	Alphanumeric - Max 20 Characters0
Range	Bullet 5	Alphanumeric - Max 20 Characters0
Range	Debranded Description	Alphanumeric - Max 60 Characters
Range	Exclude Margin	Y or N
Range	Home Del	Y or N
Range	Image URL	Alphanumeric - Max 20 Characters0
Range	Include	Y or N
Range	Notes	Alphanumeric - Max 300 Characters
Range	Show Debrand on PO	Y or N
Range	Ticket Narrative	Alphanumeric - Max 300 Characters
Sets	Parent (SKU)	Alphanumeric - Max 50 Characters	Key Field
Sets	Component (SKU)	Alphanumeric - Max 50 Characters0
Sets	Fixed Price	Y or N
Sets	Quantity	Integer Value
Web Features	Description	Alphanumeric - Max 300 Characters	Export Only
Web Features	SKU	Alphanumeric - Max 50 Characters	Key Field
Web Features	End Date	Date
Web Features	Start Date	Date
Web Features	Tier 1 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 1 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 10 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 10 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 2 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 2 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 3 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 3 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 4 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 4 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 5 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 5 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 6 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 6 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 7 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 7 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 8 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 8 Name	Alphanumeric - Max 50 Characters
Web Features	Tier 9 Desc	Alphanumeric - Max 50 Characters
Web Features	Tier 9 Name	Alphanumeric - Max 50 Characters

Not migrated from Confluence (over Freshdesk's file size limits): 2732130768.mp4 (222 MB)

Recent Searches

10. Data Fields (within Import-Export)

Import / Export Data fields

Was this article helpful?

Recent Searches

Popular Articles

Articles

Topics

Tickets

10. Data Fields (within Import-Export)

Import / Export Data fields

Was this article helpful?