Size/Color/Style Combined-Method Guide

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

TABLE OF CONTENTS

• Importing Sizes Only
• Importing Colors Only
• Importing Size/Color combinations

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

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 name your own colors in.

Colors are 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:

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 the same comma-surrounding rules that you typically would for a color -- encompassing it in two commas. So it should look a little something like this:

Once again, we will use a Hashtag/Pound Sign "#" to designate that there should be a new Size/Color Combination to follow. This part can be a bit tricky to review if you do not understand the full fundamentals of this article. In Total, Referring to the Template, you should see this syntax shown below: