Back to Curriculum Table of Contents
Importing and Creating Products


An apparel company’s number one objective is to make products people want to buy, and creating those products is the first step in the process. Trendy logo T shirts, elegant pairs of sling-backs, and classic suits start out both as sketches on a blank page and product entries in ApparelMagic.

Whether just getting started with ApparelMagic or entering new products each season, getting styles added to the system efficiently helps teammates at all stages from creating orders to running reports. ApparelMagic allows users to add products quickly and easily using two different techniques: importing in bulk or creating individually.

In this lesson, we’ll learn to import and create styles. After the lesson, add your own products using either of the techniques you’ve learned.

There are two ways to add products: by importing them in bulk or by creating them individually.To begin we will look at importing products. Use the left-hand Navigation Bar and click Products.

Select Inventory from the submenu.

This page shows all of your company’s inventory. To import new products, click the Actions button at the bottom of the screen.

Select Import from the menu.

Click the Download Template button.  When it is on your desktop, open the .csv file in Microsoft Excel or Google Sheets to begin working on the import template.

Row 2 in the file contains sample data. You may use this data as reference. Delete the data when you are ready to add information about your products.

Enter your products and their associated information, one per row.Enter 1 in the is_product column to show that the item is a product rather than a component.We’ll learn more about these fields when we create a product later in the lesson.

A system administrator should create values in the Settings module for the following fields before they can be specified: vendor_name, size_range_name, and size.style_number, is_product, attr_2, size_range_name, and size are required fields.

Enter 1 under is_active to ensure the product is an active product. If you would like to import inventory in addition to the product record, enter the quantity under qty_inventory. If this field is empty, the system will assume there is no inventory.

Next, save your .csv file and drag and drop the file into the Upload tab.

The Review tab will let you review your import and ensure all fields have been filled correctly. Click on an item to evaluate it.

Any errors to importing will be shown in red. If all looks correct, click the Import button at the bottom of the screen.

On the resulting dialog box, click Yes to confirm your import.

Click OK to continue.

Going to the Styles area in the Products submenu, we will see our products have been successfully added.

This page shows your firm’s finished goods, or styles. Use the fields at the top of the screen to sort or search for the item you have added.Alternatively, you may also add a product individually. Click the + New button at the bottom of the screen.

In the Style Number area, enter your new product’s reference name.Style numbers may consist of both numbers and letters, but many businesses use numeric codes to keep SKU length manageable. The product can be described more in the Description field.

Use the Price field to enter the most common price you use when selling the product, which will be your default price. This is the default price that is used later in costing calculations. It is easily modifiable when taking orders.

Later on, we’ll learn how to use Price Groups to assign multiple prices to a product.

Many users use the Season field to organize their products by season and year: Spring 2018 for example. However, it can be modified as the business needs. Holiday 2019 or March Wk 2 for example might be used for businesses with more specific seasons.

The Collection field might be used to define the market for the product, such as women or childrenswear or any other grouping method. Grouping products into useful and specific collections will make products much easier to find and analyze later on.

The Category field, again, can organize products in a multitude of ways. Many organizations using ApparelMagic will use this field to sort their products by type, such as Skirt or Jeans, but you may use any categories your company finds useful.

The final field in this area, Default Vendor, is used when the product is generally sourced from the same manufacturer or wholesaler.Note that this is only the default vendor, and you may choose other vendors when you create Purchase Orders.

As many companies use only numbers in the Style Number field, You can use the Description field to hold a longer version of the product name.When you have finished entering data in the Product Information page, click Finish to continue.

The other fields on the Overview page are much like they were for our Material. Input Origin, Content, Weight, and Unit of Measure as desired.

Using the same drag-and-drop method we used for our material, add an image to the Style. This may be a flat, illustration, or photo.For best results, use a high resolution or larger photo as the images will adjust to fit the screen.

More images may be added using the + button below the main image.

Click Save before continuing.

We will continue on to the Matrix tab next.

A Product Matrix shows the full assortment of colors and sizes available for each style or material. This table gives the user the ability to set a size range for each product, as well as specify which colors are available in each size.

The first step to creating our matrix is to select the Size Range. Size Ranges vary based on the product type. For example, a child’s T-shirt may be in sizes S-XL, but a men’s shoe might be sized 9-12, while a buckle for a purse could be One Size.

Users with administrative privileges are able to create new size ranges for use within ApparelMagic using Dictionaries. If your product requires a size range not listed in the menu, contact your system administrator.

Click the + New Color button to add a new color to the product.

Use the drop down menus on the Color field to add colors.Administrative users can also add colors using Dictionaries in the Settings module.

Drag and drop images of each color into the PIcture fields. In this case we are using colorized flats, but you may also use fabric colors or images of the finished product.Continue adding all additional colors.

To activate all sizes in all colors, simply click All On.

If some colors are only available on certain sizes, you can individually click the checkboxes to turn them off. Each cell in the resulting table becomes its own SKU, or Stock Keeping Unit.Click Save before continuing.

The next tabs, Processes, BOM, Specs will be covered in the Product Development lesson.Click on the Costing tab to continue.

Select Manual costing on the toggle at left. ApparelMagic is also able to automatically analyze costing throughout the production process, which we will learn about in a later lesson.

Using the Manual Cost field, we’ll enter the cost we will buy the product at from the wholesaler or factory.

Using the Duty Rate, Freight, and Other fields, you can enter additional costs. They will be added together to calculate the Total Cost at the bottom of the page.

Click Save before continuing.

Click on the Pricing tab to continue.

This tab shows our price and profit margin after costs shown on the Costing page when using manual costing. The calculations are made using the Default Price field entered on the Overview page. You can add a Price Group using the + button.

Price Groups allow businesses to offer customized pricing for different groups of customers. By using price groups, the price specified on the style’s price group will be used on transactions that have a customer with the same price group.

For example, you could price your products differently for each country.Businesses that sell to both stores and directly to customers often also use Price Groups to add their retail and wholesale prices.customers.

We’ll use this case as our example, adding a price for Wholesale Use the Price field to enter the price and click Ok to add.

Use the + button to add additional Price Groups, as we have for the Retail price.Click Save before continuing on to the Prepacks tab.

Using this tab, you can create bundles of size assortments to make taking orders more efficient later on. Click + to create a new Prepack.

Name your prepack in the Name field and enter the size assortment in the following fields.

You can enter additional Prepacks using the + button. Click Save before continuing to the Files tab.

This tab is integrated with Dropbox, allowing you to save relevant PDFs, images, spreadsheets, and more for later reference with your coworkers.For this example, we are able to drag-and-drop an associated PDF.

You can access your files whenever you need them through this tab. If the Files tab is not enabled, contact your system administrator to set up the Dropbox integration.Click the E-Commerce tab to continue.

ApparelMagic is also able to integrate with E-Commerce solutions such as Magento and Shopify. You can learn more about these integrations in the support center.

This concludes the ApparelMagic Importing and Creating Products Tutorial.Now that we’ve walked you through the steps, try importing or creating a product on your own!

Importing and Creating Products Quiz

1. Where in the Products module would you go to import multiple new styles at once?a) Stylesb) Materialsc) Inventoryd) Inventory Transfers

Answer: c) Inventory. Click the Actions button and choose Import to use the import template.

2. True or False: Each Style can only have one image.

Answer: False. You can add additional images to the Overview page using the + button below the main image. Each colorway may have its own image on the Matrix tab. Additional images can also be stored on the Files tab using the Dropbox integration.

3. Which tab would you use to create a specific assortment of sizes to be sold together?a) BOMb) Specsc) Prepacksd) None of the above

Answer: c) Prepacks. Use the + button to add new assortments.

Back to Curriculum Table of Contents