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: 100 characters
  • Appears in App searches
  • Example: We Love Tacos Tee, Eucalyptus Body Butter

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

βœ… 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 = visible
  • TRUE = hidden (but still shows in WebManager and exports)

ProductTemplatewHeaders.gif

 

❓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.

 

Related articles