Product Content Specification

Product content catalogs in Logicbroker is designed to syndicate brand's and supplier's product content information across the entire Logicbroker retail network. The network connections include retailers, marketplaces and systems. The Logicbroker product content standard is designed to be used and mapped across all channels seamlessly.

 

mceclip0.png

 

Product content below can be setup using the Portal or CSV/XLSX upload. The Field Descriptions below will show what each field is used for and how they should be maintained.

 Tip:

The standard listed may not include all fields you may use to map to all of your retailers. There may be instances where you will need to create custom product attributes. You can do this by navigating to Product Catalog Attributes in the portal and adding new attributes that can be used in your product feed upload. For more information see this article.

Details and Sample Files

 

Portal

Products can be added manually in the portal under Products > Product Catalog > New Item.

All the fields in the standard and any custom attributes created will be available through the portal. Images can be uploaded and hosted in the LB system, once uploaded the URL will be provided to the channel or can be viewed by downloading the CSV/XLSX. If you need to provide your own hosted URL, it can be uploaded using the CSV Upload.

mceclip0.png

CSV
Download CSV Samples

 

Using the field descriptions below users can upload their entire catalog through the portal or using the API. In the portal navigate to Products > Product Catalog > Click the Download button to get the CSV template and Upload after the content has been updated.

In the API the POST /api/v1/Product/Catalog endpoint can be used to upload the file as a formData parameter. For variations of product that include color, material, pattern, size, etc you can use the "parent_sku" field as the main sku to manage the variations. The sku field would still need to be unique, however gtin, mpn and parent_sku can remain the same to indicate they belong to the group as a variation, see example below.

sku,name,parent_sku,mpn
LB-1M-M,Logicbroker Men's T-Shirt,LB-1,LB-1
LB-1W-M,Logicbroker Women's T-Shirt,LB-1,LB-1

Field Descriptions

Field Name

Group

Field Description

Example

Requirement

sku

Basics

Use a unique value for each product. Use the product's SKU where possible

Keep the ID the same when updating your data.

C123

Required

name

Basics

Accurately describe your product title.

For variants

Include a distinguishing feature such as color or size

Soft Cotton Blouse

Required

image

Basics

For the image:

Accurately display the product you're selling

Use an accepted format: non-animated GIF (.gif), JPEG (.jpg/.jpeg), PNG (.png), BMP (.bmp), and TIFF (.tif/.tiff)

 

If uploading through catalog CSV, image limits are 2MB, if uploading in portal the limit is 10MB.

https://logicbroker.com/testurl1

Required

image2

Basics

Meet the requirements for the image attribute with these exceptions:

The image can show product in use. If more images are needed, new custom attributes.

https://logicbroker.com/testurl2

Optional

category

Basics

For a list of valid categories see this attachment.

 

Appliances

Required

status

Basics

Enabled or Disabled

Enabled will send the product to your retailer when ready and will provide visibility to all retailers on the Connected Commerce Network.

Enabled

Required

description

Basics

Accurately describe your product.

Made from 100% organic cotton, this classic red men’s polo has a slim fit and signature logo embroidered on the left chest. Machine wash cold; imported.

Required

gtin

Product Identifiers

UPC, GTIN, EAN, or ISBN

MPN will be required if not provided

For multipacks:

Use the product identifiers that relates to the multipack

For bundles:

Use the product identifiers for the main product in the bundle

 

123456789012

Conditional

parent_sku

Product Identifiers

Used when a product has a variant. A parent SKU must be used when the following mutliple attributes are used:

- color

- size

- pattern

- material

- age group

- gender

C123-Blue

Conditional

mpn

Product Identifiers

gtin will be required if not provided

Use the most specific MPN possible. For example, different colors of a product should have different MPNs.

MP-111

Conditional

brand

Product Identifiers

Provide the brand name of the product generally recognized by consumers

provide N/A if one isn't available.

Mars

Required

subcategory

Detailed Product Description

Detailed category associated with the product. Logicbroker utilizes Google Merchant Center categories for easy distribution to all channels. For a full list of all detailed categories see this link.

It is recommended to use the most detailed subcategory for the product.

Appliances > Refrigerator

Optional

product_type

Detailed Product Description

Detailed product type, more specific to category.

Underwear

Optional

adult_product

Detailed Product Description

yes or no

yes

Optional

color

Detailed Product Description

Required for apparel items

 

Don't combine several color names into 1 word, such as RedPinkBlue. Instead, separate them with a /, such as Red/Pink/Blue. Don’t use a value that isn’t a color, such as multicolor, various, variety, men's, women's, or N/A.

If your product features multiple colors, list the primary color first.

For variants

Include with the same value for parent_sku and different values for color

blue

Optional

material

Detailed Product Description

To indicate multiple materials for a single product (not variants), add a primary material, followed by up to 2 secondary materials, separated by a /. For example, instead of CottonPolyesterElastane, use cotton/polyester/elastane

For variants

Include with the same value for parent_sku and different values for material

wool

Optional

pattern

Detailed Product Description

Product's graphic print

For variants

Include with the same value for parent_sku and different values for pattern

striped

Optional

size

Detailed Product Description

Required for Apparel

For variants

Include with the same value for parent_sku and different values for size

If sizes contain multiple dimensions, condense them into 1 value.

XL

Optional

condition

Detailed Product Description

"new" will be used if no value is provided

Supported values

new

Brand new, original, unopened packaging

refurbished

Professionally restored to working order, comes with a warranty, may or may not have the original packaging

used

Previously used, original packaging opened or missing

new

Optional

is_bundle

Detailed Product Description

Submit yes if you're selling a custom bundle of different products that you created, and the bundle includes a main product. For example, a camera combined with a lens and bag. If you don't submit the attribute, the default is no

Don't use this attribute for bundles without a clear main product. For example, a gift basket containing cheese and crackers

yes

Optional

multipack

Detailed Product Description

Number of idenitical products included in the product

6

Optional

product_url

Detailed Product Description

Must be a link to a verified domain name

https://logicbroker.com

Required

mobile_url

Detailed Product Description

Mobile version of the product's landing page.

https://logicbroker.com

Optional

cost

Price and Availability

Your cost of the product.

42.00

Optional

price

Price and Availability

Price the end customer will pay.

84.00

Required

map

Price and Availability

Minimum Advertised Price

98.00

Optional

msrp

Price and Availability

Manufacturer suggested retail price

100.00

Optional

sale_price

Price and Availability

Price of product when on sale.

79.00

Optional

sale_price_effective_date

Price and Availability

Required if sale_price is provided; seperating start date and end date with "/"

2016-02-24T11:07:31+0100 / 2016-02-29T23:07:31+0100

Conditional

currency

Price and Availability

Currency code associated with price and cost.

USD

Required

unit_of_measure

Price and Availability

UOM related to prices

Weight: oz, lb, mg, g, kg

Volume (US imperial): floz, pt, qt, gal

Volume (metric): ml, cl, l, cbm

Length: in, ft, yd, cm, m

Area: sqft, sqm

Per unit: ct, ea

lb

Optional

uom_value

Price and Availability

Integer value related to the unit_of_measure

12

Conditional

age_group

Apparel

Required for apparel

Supported values

newborn

Up to 3 months old

infant

Between 3-12 months old

toddler

Between 1-5 years old

kids

Between 5-13 years old

adult

Typically teens or older

adult

Conditional

gender

Apparel

Required for apparel items.

Supported values

male

female

unisex

male

Optional

size_country

Apparel

Supported values

US

UK

EU

DE

FR

JP

CN (China)

IT

BR

MEX

AU

US

Optional

size_type

Apparel

Only available for apparel.

Supported values

regular

petite

oversize

maternity

regular

Optional

shipping

Shipping

Your product's shipping cost

12.05

Optional

shipping_dim_uom

Shipping

Supported units

in

cm

in

Optional

shipping_height

Shipping

Height dimension used to calculate shipping.

20

Optional

shipping_width

Shipping

Width dimension used to calculate shipping.

20

Optional

shipping_length

Shipping

Length dimension used to calculate shipping.

20

Optional

shipping_weight

Shipping

Weight used to calculate shipping.

12.11

Optional

shipping_weight_uom

Shipping

Supported units

lb

oz

g

kg

lb

Optional

min_handling_time

Shipping

The shortest amount of time between when an order is placed for a product and when the product ships.

0

Optional

max_handling_time

Shipping

The longest amount of time between when an order is placed for a product and when the product ships.

For products ready to be shipped the same day, submit 0.

3

Optional

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

Submit a request