This article refers to the required syntax to import Size and/or Color within one Item-Import spreadsheet.
What you'll learn
- How do I use the Size/Color/Style Column from the standard Item Import Template
Our latest Item Import Template may be found HERE
Importing Sizes
In your Size/Color/Style column, you can import sizes for your products in MarketTime. You can refer to the "Sizes" tab on our Item Import Template to see a list of acceptable sizes in MarketTime.
To start a new size in Excel, you can type the Size's Name to start. When you are done typing the sizes name, you will use two commas ",," to indicate that this is the end of the size you are typing. Should you only need one size listed, you could stop typing at this point.
To list multiple sizes, use a hashtag/pound "#" to indicate that we are starting a new size. You can immediately type the next size after this hashtag, and repeat this process.
Referring to the template, you should see this syntax shown below. This would import six sizes for your product on this row; XS, S, M, L, XL, and 2XL
| XS,,#S,,#M,,#L,,#XL,,#2XL,, |
Importing Colors
In your Size/Color/Style column, you can import Colors for your products in MarketTime. There is no preset list of Colors that you can choose. This is a free-form field that you can use to create your own color names. The character limit for Color is 20 Characters.
Colors can be listed on your spreadsheet beginning and ending in a comma. Similar to Sizing syntax -- you can indicate that a new color should be used with a hashtag/pound sign "#"
Referring to the template, you should see this syntax shown below. This would import 3 colors for your product on this row:
| ,Green,#,Blue,#,Yellow, |
Importing Style
In your Size/Color/Style column, you can import Style for your products in MarketTime. There is no preset list of Style that you can choose. This is a free-form field that you can use to create your own Style variants. The character limit for Style is 25 Characters
Styles can be listed on your spreadsheet by using 2 commas before your Style name. Similar to Sizing and Color syntax -- you can indicate that a new Style should be used with a hashtag/pound sign "#"
The following example syntax would allow 3 styles to be imported.
| ,,Style1#,,Style2#,,Style3 |
Importing Size/Color Combinations
In your Size/Color/Style column, you can import Colors and Size combinations that work together. For example, if you had 2 sizes for your product and each size came in different colors. you could use this method.
First, you will start by listing the size. This can be done by simply typing the Size to begin. Then, use a comma and type in your color. Enter one more comma to denote that we will not be importing style.
| S,Yellow, |
Once again, we will use a Hashtag/Pound Sign "#" to designate that there should be a new Size/Color Combination to follow. So, to designate 2 different Size/Color combinations, the syntax should appear as the example does below
| 4,Red,#4,Blue,#6,Red,#6,Blue |
Importing Size/Color/Style Combinations
In your Size/Color/Style column, you can import Size/Color/Style combinations that work together. For example, if you had 2 sizes for your product, each size came in different colors, and each color had a unique style. you could use this method.
First, you will start by listing the size. This can be done by simply typing the Size to begin. Then, use a comma to type in the color. Enter one more comma before typing in your style, and your field should look like the example below:
| S,Yellow,Style1 |
Once again, we will use a Hashtag/Pound Sign "#" to designate that there should be a new Size/Color/style Combination to follow. So, to designate 2 different Size/Color combinations, the syntax should appear as the example does below
|
4,Red,Style1#4,Blue,Style2#6,Red,Style3#6,Blue,Style4 |