Originally written by Will Miller, last updated Feb 27, 2024, on the Swan Retail knowledge base (SRS).
Part of: Item Import and Item Export Overview
This program imports a spreadsheet and creates big ticket options used in bespoke item configuration during a sale or stock item configuration during purchase order creation from a catalog item. The option sets are assigned to Big Ticket Ranges, Models or Styles for use in catalog item configuration.
Using this program, it is possible to create (or update) numerous new option sets and options in a single process. Options can then be viewed within Big Ticket Option Maintenance.
Standard Menu Location: Stock > Maintenance > Items > Big Ticket Option Import
This program takes a file (csv or xls, xlsx) and processes the data into Swan.
Details of the columns used in the import can be found in Import Spreadsheet section of this document.
The import process will overwrite existing option choice codes.
Selecting the program from the menu will start the Big ticket options import wizard:
Locate the file to import then click the Next > button to begin the import process.
The system will produce a status report upon completion. An example is shown below
In the example above row 9 has been rejected, all other records have been processed.
A copy of the import log will be copied to the same folder as the import file with the same name as the import file but with a .log suffix.
An example is shown below –
Where appropriate issues can be corrected, and the file reloaded.
Import Spreadsheet
This section details the columns used within the Big Ticket Option Import program.
Example spreadsheet here: SampleBigTicketOptionsImport.xlsx
The columns required by the Big Ticket Options Import program are listed below.
|
Column Name |
Example |
Details |
|---|---|---|
|
OptionSetCode |
FAB100 |
The option set code must be unique or reference an existing set if adding options to it. |
|
OptionSetDescription |
Fabric Colours |
Description of the option set required for new sets |
|
SupplierCode |
If the option set is to be limited to a single supplier |
|
|
OptionSetType |
Swan |
Swan, Web or Both Used as the default when creating new options in the set. |
|
OptionCode |
Dark Green |
Specify option choice code |
|
OptionName |
FABGRE 001 |
Specify the name of the option to be linked to the OptionSetCode |
|
SequenceNumber |
0 |
Specify the sequence in which the option code will be presented. |
|
Weight |
Optionally specify the weight of this option in grams |
|
|
VatNumber |
Optionally specify the VAT rate number for this option. The VAT number must correspond to a code set within VAT Rate Maintenance. |
|
|
SeoCode1 |
Optionally specify a SEO (Search engine optimisation) code. |
|
|
SeoCode2 |
Optionally specify a SEO (Search engine optimisation) code. |
|
|
SeoCode3 |
Optionally specify a SEO (Search engine optimisation) code. |
|
|
SellingPrice |
110 |
Optionally specify a selling price for this option. |
|
CostUplift |
2.00 |
Optionally specify a cost price for this option. |
|
PercentageUplift |
0 |
Optionally specify a percentage uplift for this option. (default where not set is zero) |
|
Suspended |
Set to N (default) for active options. Set to Y to suspend the option. |
|
|
OptionType |
1 |
Choose from: 1 (default) Swan only 2 Web only 3 Both Swan and Web. |
|
ParentOptionCode |
Option code if this option is to be nested under as a lower level option. e.g. finish of a wood option such as Oak-->Oiled. |
|
|
SwatchImagePath |
C:\images\stockoption\bright green.png |
The file path of the image for the swatch. |
|
SwatchDescription |
Dark Green Fabric |
Description to use for the image |
|
SwatchDisplayType |
Image |
Image, Description or Both |
Swatches imported can be reviewed in Big Ticket Options Maintenance along with the rest of the option set detail:
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