How to Import Products

You can upload a CSV file to add or update item information, product names, custom SKUs, custom sort order, and modify kits & item relationships.

The Wondersign Product Importer allows you to:

• Import or update your own products
• Enhance feed-based products (update custom fields)
• Add or update a custom SKU
• Update product names
• Add or update a custom product sort order
• Add or update image URLs
• Add or update video URLs
• Import custom product relationships
• Import custom product kits
  
  

Requirements/Tools Needed:

• Sign in to my.catalogkiosk.com using the Google Chrome web browser
  
  

Getting Started

1. In the main navigation, go to Content and select Products from the drop-down.

2. In the top right, click the green Import Products button.

Please Note: If you don't see this button, you might be on a Legacy plan that doesn't include product import functionality. Please give us a call at 855-408-9966 or send an email to sales@wondersign.com.

3. The introduction screen explains the various import functions and also allows you to Download Example CSV File. This file can be used as a template for your own catalog data. Once you are ready to proceed, click Next.

4. Use the Choose File button to upload your CSV file from your desktop. If you are using the provided template file or if your CSV has a header row, leave the box CSV Has Header Row checked.

5. In the Import Settings select if you wish to create new products or update existing products. You can also check if the import contains new and/or updated products.

To import a brand new custom catalog with items that are not part of the managed vendor feeds, leave the box next to Create new products checked.

To update existing products in the Wondersign platform, check the corresponding box and then select from the three sub-options.

• Skip empty fields: If a field in the Wondersign platform contains data and the same field in the CSV file does not, the importer will not delete the field information in the platform on import - as long as this option is checked. (This is recommended)
• Skip items that originated from a 3rd party data feed: With this option selected, the import process skips items from a managed vendor feed and only updates custom items.
• Enhance only: With this option checked, empty fields on the Wondersign platform will be filled with content from the imported file.

And finally, the import wizard also allows you to keep your catalogs up-to-date by automatically deleting items if they are not part of the CSV file any longer. This is useful when removing discontinued items or temporarily hiding out-of-stock product.

To delete items when they're not present in the CSV file, check the box Delete items.

6. Click Next to proceed to column mapping.

7. The Wondersign platform automatically detects columns if the column header information matches. For all other columns, they have to be mapped to the correct column header by hand. A green status indicates that columns are successfully mapped.

Column Mapping

To add or update/enhance fields in the Wondersign platform, you can use any or all of the fields available for mapping. Please Note: that Brand and SKU are required fields.

Here is the list of fields that serve a special purpose:

1. attributes: These fields can be used to import custom product attributes (characteristics).

• attributes.#.attribute : this value defines the attribute type or name.
• attributes.#.values.# : this value defines the attribute value whether it's a number, text, true/false, etc.

For multiple attributes use the '#' placeholder value to distinguish between different attributes. See the table below for examples.

• 1: Any characteristic should be imported as an attribute and each have their own attribute value. 
  
• 2: the attributes.#.values.# (VALUE) should always follow to the right of the attributes.#.attribute (ATTRIBUTE NAME) column, as shown above.
  
• 3: attributes can have multiple values, but each unique value requires its own column.
  

Imported custom attributes will appear on the Product Details page in the Catalog App Manager (CAM) and as filter options in the Catalog Kiosk App.

1. customerSku : This field can be used to import custom SKUs that should be displayed instead of the manufacturer's SKUs. This is critical for retailers with their own unique SKU system. And using custom SKU numbers also makes cross-shopping or showrooming much harder.

2. packageProducts : These fields can be used when importing kitted or bundled items that consist of multiple components. The component SKUs and quantity can be defined by using these fields.

3. rank : When importing a custom sort order, the rank column needs to contain a numeric value. The number determines the sort order on the kiosk and tablet app, if the Custom Sort Order is selected in the device group settings (Advanced Configuration > Product Sorting).

4. relatedProducts : These fields define which products should be shown as associated items.

• completeYourCollection : This is for up-sell purposes to recommend a matching love seat to a sofa, or a matching nightstand to a bed.
• crossSell : As the name indicates, this is to add items that go well with the main item, such as accessories and decor items.
• series : These fields define items that pertain to the same series/collection as the main item.
  

Importing Categories

To import and assign products to categories, please refer to this Wondersign Taxonomy Table.

Please Note: Use the full category path including the department level, category level, and product level (e.g. Furniture > Bedroom > Beds) as listed in the taxonomy document* to add products to existing categories. The importer is also case-sensitive.

*Wondersign's Taxonomy and category structure is subject to change at any time. You can manage and modify the category structure for your account, visit the article How to Add Custom Categories.

Importing Images

• RGB Images only, no CMYK
• Supported formats: JPG, PNG
• Minimum resolution: 1200 px (longer edge)
• Maximum resolution: 100 Mpx (width x height. Eg. 10000 x 10000 px for 1.0 aspect ratio)
• Do not include extra whitespace in rectangular / scene imagery
• URL must return proper content-length header for the image file, try to avoid redirects

Using Feature Bullets in Product Description

Feature bullets can be added to your product description through import using structured HTML.

<b>Product Features</b>
<ul>
<li>Feature 1</li>
</ul>

Once your mapping is complete, click Finish to proceed.

The CSV file is now being imported in the background. You can use the Wondersign platform without limitations while the import process is under way.

To check on status, click the Background Tasks icon (check mark) in the top right and select View Details.

The list of background tasks shows you the nature and status of each task, together with time stamps, the outcome, and a link to View Results.

To download a log file that documents each failed row or field with a reason for the error, click Download log file. This will help when fixing potential data issues.

To fully automate product data import and to move from manual imports to automated (managed) data feeds, please shoot us a note and we're happy to go over the various methods to automate product data feed ingestion.