Skip to main content

📏 Product Template Rules and Guidelines

ANDMORE Support
  • Updated

The product template Import Products Template is your launchpad to manage your catalog efficiently in WebManager. This template allows you to:

  • Introduce new products
  • Disable discontinued products
  • Set up pricing tiers
  • Create advanced filters, and more

 

📋 Required Template

Template Required: Import Product Template

  • Make sure that your related product template is in .xls, .xlsx or .txt (Tab Delimited) format

 

🧾 Product Template Field Definitions

Each field (or column header) in the product template is used to define key product information. Required fields are bolded, and optional fields are noted as such. Let’s walk through what each one does:

ItemID ⌨️

Required Field
A unique alphanumeric identifier for each product.

  • Must be unique
  • Max character count: 50 characters
  • May include letters, numbers, dashes, or underscores
  • Avoid special characters (%,$,&,@,#, etc.) and spaces
  • Used in App search functionality
  • Example: 12345, ABCD-12345

⚠️ Important: Once entered, an ItemID cannot be edited. To remove a product, set IsDeleted = TRUE.

 

ItemName ⌨️

Required Field
A short, high-level product name that grabs your buyer’s attention.

  • Can be reused for multiple products
  • Max character count: 99 characters
  • Appears in App searches
  • Example: We Love Tacos Tee, Eucalyptus Body Butter

🔹 Note: If an item does not have an ItemName in the system, you may experience an issue with making an item active or inactive. Please ensure that all items have an item name.

Description 📝

Optional Field
A detailed product description to entice buyers.

  • No character limit
  • HTML-friendly (bullet points, formatting, etc.)
  • Can include images or video links
  • Re-namable via WebManager template settings

 

Notes 🗒️

Optional Field
Additional info about the product, similar to Description.

  • No character limit
  • HTML-friendly
  • Re-namable via WebManager template settings

 

Dimensions 📏 & DimensionsMetric 📐

Optional Fields
Used to list product measurements.

  • No format restrictions
  • Examples: 8x6x5, 8”x6”x5”, 8x6x5cm

 

OrderMinimumQuantity / OrderMultipleQuantity (OMQ)

Recommended

  • OrderMinimumQuantity: Lowest quantity a customer can buy (set to 1 if no minimum)
  • OrderMultipleQuantity: Purchase in set multiples (e.g., sets of 2, 4, 6, etc.)
  • Must be greater than 0

 

ContainerMinQty 🚚

Optional Field

  • Minimum order quantity required for container orders

 

OnHandQuantity (OHQ)

Optional Field

  • Max on hand quantity: 32,767
  • If items have a greater OHQ in WebManager, they will not display in the RepZio App, ShopZio, or B2B Direct website

✅ Enable Inventory Settings to hide or restrict ordering of low-stock items.

 

Category

Required Field
Used to group/categorise products

  • Max character count: 100 characters
  • Avoid special characters
  • Supports single or multi-level categories
  • Examples:
    • Home Goods/Decor
    • Home Goods/Decor|Decor/Table-Top Decor
⚠️ Important: Categories must have products assigned or they'll disappear. Items must also be categorised to be viewable.

 

InventoryStatus 🏪

Optional Field
Display availability status (e.g., In Stock, Out of Stock, Next Shipment 2 Weeks)

  • No “Yes/No” values
  • Max character count: 100 characters

✅ Use Inventory Settings to enforce availability rules.

 

ReportCategory 📉

Optional Field
Used for backend sales tracking, not visible to buyers

  • Example: Living Room

 

IntroDate 📆

Optional Field
Date when the product was added (MM/DD/YYYY)

 

UPC 🖥️

Optional Field
Universal Product Code (or SKU)

  • Max character count: 12 characters

 

BasePrice 💲€ £

Required Field
Starting price for a product

  • Numeric
  • Customisable currency name via WebManager
  • Must be labeled BasePrice in uploads

 

PriceLevel(1–20) 💲€ £

Optional Fields
Additional pricing tiers by level or currency

  • Columns should be named PriceLevel1, PriceLevel2, etc.
  • Max character count: 50 characters
  • Delete unused columns

 

SpecialPrice 🏷️

Optional Field
Overrides all other prices

  • Displayed until deleted or reset to $0.00
  • Available only in iOS App, Web App, and B2B

 

Source 🌎

Optional Field
Factory or country of origin

 

PieceBox 📦

Optional Field
Number of items in one box (integer only)

  • Example: 12

 

Cubes 🧊, Weight 𐄷

Optional Fields
Used for container logistics and buyer reference

 

UnitOfMeasure (UoM) 📏

Optional Field
Describes value units (e.g., pounds, inches, each)

 

UDF(1–20) 📓

Optional Fields
User-defined fields to customise search, filter, or display info

  • UDF1–UDF5 = UPPERCASE
  • udf6–udf20 = lowercase
  • Unlimited characters
  • Delete unused fields

 

PhotoName 📷 / AdditionalPhotos 📸

Optional Fields
Product image file names

  • Must be .jpg
  • Max size: 2048x2048px
  • No special characters or spaces
  • Use dashes/underscores

❌ Avoid: %,$,&,@,#, etc. and spaces

✅ Use: letters, numbers, dashes, underscores

 

CatalogCode / CatalogName 📖

Optional Fields

  • Required for multiline accounts; optional for others
  • CatalogCode: 4-character unique code
  • CatalogName: Descriptive catalog title

 

showChildFor / showRelatedFor

Leave blank — auto-filled during exports if child or related products are set up.

 

TaxCode 💰

Optional Field

Defines product taxability (e.g., T = Taxable, N = Non-Taxable)

 

AvailabilityDate 🗓️

Optional Field
Date when the product becomes available (MM/DD/YYYY)

 

IsDeleted ✔ ❌

Required Field
Controls product visibility

  • FALSE = Active / visible
  • TRUE = Inactive / hidden (but will show in WebManager and exports)

ProductTemplatewHeaders.gif

🔹 Note: You can also the following in the IsDeleted field.

  • 0 = False / Active
  • 1 = True / Inactive

Or,

  • No = False / Active
  • Yes = True / Inactive

❓FREQUENTLY ASKED QUESTIONS (FAQS)

Q. Is the template required?

A. Not required, but highly recommended. Without it, you'll need to map fields manually or create products in the “Products Quick Edit” section.

Q. Where can I download the most current templates?

A. Go to: WebManager → Manage Data → Download Data Templates.

Q. Where do I download my product file?

A. Head to: WebManager → Manage Data → Upload Data Sheets > Products. 

Q. I have uploaded products but don't see them. What gives? 

A. After upload, click "My Data Looks Good" and wait for the "Import File Ready" pop-up. Then click "Push Data Live" to publish.

Q. What does the 'Row not imported' error message mean?

A. It usually means there's hidden formatting, missing required fields (e.g., ItemID), or unseen data. Copy values into a fresh template and try again.

Q. 'An error occurred while trying to map the file'—what now?

A. First, confirm the correct file type is selected. If it is, refresh the page or return to Dashboard and re-upload.

Q. Why is one column not uploading into the system?

A. Make sure the header name matches exactly what the system requires. For example, if your template uses “Base Price” (with a space), but the system expects “BasePrice” (no space), it won’t upload correctly. Adjust the header to match the exact format used in the system.

 

Explore our Resource Center

Quickly find answers to your questions by searching the ANDMORE Resource Center.

 

 

Contact ANDMORE Support

Need further assistance? Click the Support link    located in the lower-right corner of your screen.  

 

 

Related articles