Product Template with Headers Defined Product Template with Headers Defined

Product Template with Headers Defined

 

The Product Template ("ImportProductTemplate.xls") is the only required template to import products to the Webmanager / JuniperData portal. This template is used to add or delete products, as well as provide details about each product.  Once this is added, you then push it live to the RepZio App, JuniperWeb, or JuniperMarket. 

Below we describe each header for you to better understand the Product Template.  Each column is described below. Please note most of these are optional columns and not all have to be completed. 

 ItemID

  • A required column used for uniquely identifying each product- No Duplicates
  • Must be less than 50 characters in length
  • May contain letters, numbers, dashes, and slashes
  • Other foreign characters should be avoided
  • A forward slash or an underscore in the ItemID can affect your images, requiring you to use the PhotoName column
  • Can be used in the App to search for products

 ItemName

  • Name of product
  • The same name can be used for multiple products
  • Must be less than 100 characters in length
  • Can be used in the App to search for products

 Description

  • Information regarding the product
  • No character limit; provide as much detail as needed
  • Can include pictures and links to videos
  • HTML friendly; bullet points, text formatting
  • Can be renamed in the template settings in the webmanager portal

 Notes

  • Additional information regarding the product, similar to the description field
  • No character limit; provide as much detail as needed
  • HTML friendly; bullet points, text formatting
  • Can be renamed in the template settings in the Webmanager portal

Dimensions

  • Product’s length, width, and height
  • No character limit or restrictions
  • Examples: 8x6x5, 8”x6”x5”, 8in x 6in x 5in

DimensionsMetric

  • Product’s length, width, and height
  • No character limit or restrictions
  • Examples: 8x6x5cm, 8x6x5, 8 x 6 x 5

OrderMinimumQuantity

  • A set number dictating the smallest quantity of an item that can be purchased at a time
  • If left blank, it will default to a quantity of 1

 OrderMultipleQuantity

  • A set number dictating the quantity of a product that is ordered at a time
  • Example: Order in sets of 2, 4, 6, 8, etc.

 OnHandQuantity

  • Number value indicating the quantity of a product in stock and available to be sold
  • Max value of 32,767

 Category

  • Used to group or categorize products
  • If not in a category, the user will not see the product on the App
  • Categorization can be single (category) or multi-level (category/sub-category)
  • Must be less than 100 characters in length (if more characters are required, the Product Categories template can be used)
  • More information on creating categories

InventoryStatus

  • Used to display whether a product is in stock or not
  • You may use any terms you like. For example: In Stock, Out Of Stock, Next Shipment 2 Weeks, Available, Unavailable, etc.
  • The field cannot accept "Yes" or "No.
  • Must be less than 100 characters in length

ReportCategory

  • Used to set up reporting categories for your products.
  • This does not affect how your products are displayed in the app/B2B site/ShopZio.
  • For example: let's say you sell sofas, loveseats, and coffee tables. Let's also assume that you want to track how many living room products you have sold during a market.
  • You can enter "Living Room" under ReportCategory for your sofas, loveseats and coffee tables to track this.

IntroDate

  • This column is used to display when you added that product to your catalog/database.
  • This field can only support dates.
  • Date format: mm/dd/yyyy

 UPC

  • Acts as a barcode for a product
  • Used to scan a product and to create labels

 BasePrice

  • Starting price for each product
  • Must be strictly numeric
  • Can be a wide variety of currencies
  • Can be named anything on iPad

 PriceLevel(1-20)

  • Additional pricing fields aside from Base Price
  • Must be strictly numeric
  • Can be a wide variety of currencies
  • Can be named anything on iPad

SpecialPrice

  • This column overrides all other pricing columns on the product template spreadsheet. 
  • The price you enter here will be displayed for every customer you have.
  • The price will be shown until you delete it.

 Source

  • Used to identify unique factory locations
  • Used when products come from more than one factory
  • Deals with containers and their locations

 PieceBox

  • Number of items that come in one box
  • Example: Case = 12
  • Must be an Integer Value (Whole Number)

 Cubes

  • Used for container orders

 Weight

  • How much the product weighs
  • Can follow any system of measurement

 UnitOfMeasure

  • Can be used to describe the value of another field.  i.e. pounds, inches, feet, meters, each etc.

 UDF(1-15)

  • User-Defined Fields (UDF,udf)
  • Fields that can be filled with any data that this template does not have a header for.
  • Can be customized to show different names or info on the App
  • UDF's(1-5) header must be uppercase (UDF1, UDF2, UDF3...)
  • UDF's(6-15) header must be lowercase (udf6, udf7, udf8...)
  • No character limit or restrictions

 udf(16-20)

  • User-Defined Fields are customized fields used for advanced searching on the app
  • The advanced search on the app is based on these udf's & named as you need to help filter products
  • Search results are narrowed by the parameters set in these fields.  Examples can be color, material, construction or other terms you would like to search by.
  • udf's(16-20) header must be lowercase (udf16, udf17, udf18...)
  • No character limit or restrictions

 PhotoName

  • Left empty, our system will by default name the image with the ItemID
  • This field can be used to rename images
  • Must be .jpg format
  • Do not exceed 2048x2048 pixels
  • More information about images

   AdditionalPhotos

  • Name of alternate pictures to be associated with a product
  • Can contain numbers, letters, and dashes (-)
  • Must be .jpg format

 CatalogCode

  • Used for Multi-line accounts
  • A numeric code that defines a catalog in the system
  • Must be unique and 4 characters in length

 CatalogName

  • Used for Multi-line accounts
  • Name of the catalog that will show up on the iPad
  • Will be used in differentiating one catalog from another

ContainerMinQty

  • Used for configuring Container option
  • MinimumOrderQuantity needed for ordering items in a Container

 IsDeleted

  • Manages which products will show up on iPad using False or True
  • Products marked FALSE will show in the App
  • Products marked TRUE will be removed and will not push out to the app
  • Once marked TRUE, the product will continue to show in the webmanager portal (also will show on exports of products)
  • This field is required on every spreadsheet