Importing multiple products to Plytix requires a spreadsheet exported as a CSV or Excel-file. It may be necessary to adjust an existing spreadsheet in order to make it compatible with Plytix (see below). If you are not comfortable working with spreadsheets, fear not. You can always contact us for onboarding assistance.

See the recommended import settings here

Sheet Compatibility Check:

The five compatibility requirements are as follows:

  1. Mandatory column – SKU
  2. One product, one row
  3. Seven sub-levels for categories
  4. Declare parents for variations
  5. Links to files must to publicly accessible http-links

#1 Mandatory Column – SKU

Here is an example of a compatible spreadsheet. Only one column is mandatory: SKU. It is marked with an asterisk*.

SKU* Variation Of Name Description Category Size Price
AW1701 Raw Jeans Casual pants for any occasion Clothing>Pants>Denim M 159
AW1702 AW1701 Raw Jeans Casual pants for any occasion Clothing>Pants>Denim S 159
AW1703 AW1701 Raw Jeans Casual pants for any occasion Clothing>Pants>Denim L 159
AW17ST Beanie Great for autumn Accessories>Hats M 49
AW17CB Leather Boots Get comfy in the cold months Footwear>Boots M 79

*The only mandatory column for importing a product. All other columns will be imported as product attributes that you can define during the import mapping process

#2 One product, one row

Firstly, all rows in the sheet must be products, except the first row which can be a header row for the columns. If this is the case, you can mark this characteristic in the import mapping interface.

All information about a product must be contained in a single row.

Attributes with multiple values such as colors, files etc. must be in one cell, and need to be separated with a comma. Make sure that when matching/creating these attributes in the mapping tool, the value separator matches that in the spreadsheet.


     For multiple values in the mapping tool ^

#3 Seven sub-levels for categories

You can assign as many categories as you want to a product. However, in order to enforce a sound organization of products, as well as comply with industry standards, category structures are limited to six levels of subcategories below a root category.

For example, a pair of pants could have the following categories:

Clothing > Pants > Denim
Collection > 2017 > AW17
Men’s > Bottoms > Casual Pants > Denim
Men’s Clearance > Denim

Assigning these categories to a product in a spreadsheet is done by:

  1. Defining the category hierarchy using the > symbol
  2. Separating multiple values using a comma

Example:

Clothing>Pants>Denim,Collection>2017>AW17,Men > Bottoms > Casual Pants > Denim, Men’s Clearance > Denim

Notice that the ‘>‘ sign is used to define the hierarchy of the categories from top to bottom. One product, one row is followed here by separating multiple values for a single column with a comma.

#4 Declare parents for variations

Importing variations requires that you designate a parent product. This product will become the “root” variation under which all the others are organized.

For example:

The Raw Jeans in the example below has designated the medium size with the SKU AW1701 as the parent. The small and large sizes are variations of this product.

SKU* Variation Of Name* Description Category Size Price
AW1701 Raw Jeans Casual pants for any occasion Clothing>Pants>Denim M 159
AW1702 AW1701 Raw Jeans Casual pants for any occasion Clothing>Pants>Denim S 159
AW1703 AW1701 Raw Jeans Casual pants for any occasion Clothing>Pants>Denim L 159

To import variations correctly, make sure that:

  • You designate a parent product that all variations (or child products) refer to in the column PARENT SKU
  • No child product refers to another child product
  • Parent products are the “root” and therefore have the PARENT SKU column empty
  • The child products follow the One product, one row rule and have all information in its row, even if it means having duplicate data across all child product rows

#5 Link to files must be publicly accessible http-links

It is possible to import the digital files you have for you product by providing publicly accessible http-links to your files. If you have multiple files for a products, simply split the links with a comma.

Functional Columns (Plytix System Attributes)

Functional columns are special columns in the spreadsheet that allow you to do pre-import organizing. These columns define relationships instead or other organizational needs. Non-functional columns simply provide data input.

Most of the functional columns have already been described in the above section, here is a formatted overview over the functional columns for PIM imports.

It is not compulsory to provide information for all of these attributes, nor do you need too create these attributes as they are already provided in the system for you.

Column Name Description Purpose Example
Category Data in this column is parsed at category definitions, it is both used to build the category structure, as well as assigning categories to a product.

Build category structure

Assign categories to products

Clothes>Pants>Denim,
Collection>2017>AW17
Variation Of This column can for many products be empty, as it is only used for child products (variation) to refer to a parent. Link variations
SKU Parent SKU Name
A123 Parent Product
B456 A123 Child Product A
C789 A123 Child Product B
Publication Date If your product must be kept under wraps until it’s publication date, you can set the date in this column.This ensures the product is private, even if you include it in public exports. Manage release dates 11.07.2019
SKU This is the only mandatory column for products.

Create products

Discovery when searching

Files This column allows you to upload files along with your products. This column requires that multiple values are comma separated. Read more about this function here. 

 

Import files and auto-link them to products

Attributes with Asterisks*

While matching and mapping attributes, you will notice that some attributes have either one or two asterisks

  • One asterisk* indicates that these attributes accept multiple values and those multiple values need to be separated by a comma
    • For example: black, white, purple, blue, red, yellow, green
  • Two asterisks ** is a category hierarchy. Category hierarchies are set up using > to indicate subcategories, and commas to indicate new root categories:
    • category1>subcategory1, category2>subcategory1>subcategory2

Work Smarter

If you need to edit all rows in a column, doing it manually should be your last resort. Always google your issue first. The challenges you may face when preparing your spreadsheet have likely already been solved by others.

At Plytix we are primarily using Google Sheets to prepare sheets for import. What we find particularly nice about using it, is the Marketplace for Add-ons which makes reformatting super easy. Take a look at the selection of add-ons we use on day-to-day basis.