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.
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
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.
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-1Field Descriptions
|
Field Name |
Label |
Group |
Field Description |
Example |
Requirement |
|
sku |
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 | Name |
Basics |
Accurately describe your product title. For variants Include a distinguishing feature such as color or size |
Soft Cotton Blouse |
Required |
|
image |
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. |
Required |
|
|
image2 |
Image 2 |
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. |
Optional |
|
|
category |
Category |
Basics |
For a list of valid categories see this attachment.
|
Appliances |
Required |
|
status |
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 |
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. |
Recommended |
|
gtin |
GTIN/UPC |
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 |
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 |
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 |
Brand |
Product Identifiers |
Provide the brand name of the product generally recognized by consumers provide N/A if one isn't available. |
Mars |
Recommended |
|
subcategory |
Sub-category |
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 |
Product type |
Detailed Product Description |
Detailed product type, more specific to category. |
Underwear |
Optional |
|
adult_product |
Adult product? |
Detailed Product Description |
yes or no |
yes |
Optional |
|
color |
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 |
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 |
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 |
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 |
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 |
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 |
Multi-pack count |
Detailed Product Description |
Number of idenitical products included in the product |
6 |
Optional |
|
product_url |
Product's landing page |
Detailed Product Description |
Must be a link to a verified domain name |
Recommended |
|
|
mobile_url |
Mobile URL |
Detailed Product Description |
Mobile version of the product's landing page. |
Optional |
|
|
cost |
Cost |
Price and Availability |
Your cost of the product. |
42.00 |
Optional |
|
price |
Price |
Price and Availability |
Price the end customer will pay. |
84.00 |
Recommended |
|
map |
MAP |
Price and Availability |
Minimum Advertised Price |
98.00 |
Optional |
|
msrp |
MSRP |
Price and Availability |
Manufacturer suggested retail price |
100.00 |
Optional |
|
sale_price |
Sale price |
Price and Availability |
Price of product when on sale. |
79.00 |
Optional |
|
sale_price_effective_date |
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 |
Currency |
Price and Availability |
Currency code associated with price and cost. |
USD |
Recommended |
|
unit_of_measure |
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 |
UOM value |
Price and Availability |
Integer value related to the unit_of_measure |
12 |
Conditional |
|
age_group |
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 |
Gender |
Apparel |
Required for apparel items. Supported values male female unisex |
male |
Optional |
|
size_country |
Size country |
Apparel |
Supported values US UK EU DE FR JP CN (China) IT BR MEX AU |
US |
Optional |
|
size_type |
Size type |
Apparel |
Only available for apparel. Supported values regular petite oversize maternity |
regular |
Optional |
|
shipping |
Shipping cost |
Shipping |
Your product's shipping cost |
12.05 |
Optional |
|
shipping_dim_uom |
Shipping dimension UOM |
Shipping |
Supported units in cm |
in |
Optional |
|
shipping_height |
Shipping height |
Shipping |
Height dimension used to calculate shipping. |
20 |
Optional |
|
shipping_width |
Shipping width |
Shipping |
Width dimension used to calculate shipping. |
20 |
Optional |
|
shipping_length |
Shipping length |
Shipping |
Length dimension used to calculate shipping. |
20 |
Optional |
|
shipping_weight |
Shipping weight |
Shipping |
Weight used to calculate shipping. |
12.11 |
Optional |
|
shipping_weight_uom |
Shipping weight UOM |
Shipping |
Supported units lb oz g kg |
lb |
Optional |
|
min_handling_time |
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 |
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 |
Comments
Please sign in to leave a comment.