Big Ticket Options Import Guide

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

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:

image-20240219-130629.png

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:

image-20240227-103456.png

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