Made to Order options (Customisations)
This may be used as an Import or an Export option.
The file looks like this:
Export
Use the filters to narrow your selection, then click 'Export'. This will generate a file that will include all Customisations for products that match your filters.
Import
Make changes to the file and import it to update Products. Any changes here will be added to existing Customisations.
It is possible to remove existing Customisations when you upload a file by using he 'remove existing MTO options tickbox'.
Please be aware that removing Customisations in bulk is risky and could result in Customisations being removed incorrectly.
| Field | Purpose |
|
Code |
The SKU Code of the Variant to which the Customisations are linked |
| Product |
The Product Name to which the Customisations are linked - Variant Option Values are also appended to this, to differentiate between Variants
This is for reference purposes only, and changes here will not be updated within the system. |
| Option Name |
The Name associated with the Customisation, e.g. 'Size' or 'Colour'
Adding a new entry here may create a new Option |
| Option Value | The Value associated with the Customisation, e.g. 'Small' or 'Red' |
| Option Price |
The additional price to the customer associated with this Customisation, e.g. selecting 'Gold Feet' may add £49.99 to the price
Enter in this format only: '0.00' |
| Option Percent |
The additional price to the customer associated with this Customisation, e.g. selecting 'Cotton' may add 10% to the price
Enter in this format only: '0.00' |
| Option Cost |
The additional cost associated with this Customisation, e.g. selecting 'Gold Feet' may add £49.99 to the price
Enter in this format only: '0.00' |
| Swatch Group |
The Swatch Group linked to this Customisation.
Adding a new entry here may create a new Swatch Group |
| Swatch Name |
The Swatch Group linked to this Customisation.
On upload, if a Swatch Name matching this entry exists within the Swatch Group (see above), that Swatch will be linked to this customisation.
Adding a new entry here may create a new Swatch |
| Swatch Image |
The link to the Swatch Image that is linked to this Customisation
If you are creating a new Swatch Group, or there is no Swatch with a corresponding Swatch Name within an existing Swatch Group, and you have entered a link here, it will import that Swatch Image and create a new Swatch |
| Image Link Ref | This shows a link to an existing Variant Image, if one exsists |
| Child Option | Use this to set up interrelated options, e.g. choices for 'Choose Pattern/Plain' could lead to Child Options of 'Choose Plain Colour' and 'Choose Pattern Colour' |
Mapping
You will need to map your data before it can be imported. Included below is the optimal mapping/spreadsheet structure.
Mistakes made here may have serious impact on your Product database.
Please be aware that removing Customisations in bulk is risky and could result in Customisations being removed incorrectly.
